Print Ledger Report: Difference between revisions

From eStream Software
 
(22 intermediate revisions by the same user not shown)
Line 11: Line 11:
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Parameter 1 !! Purpose to filter
! Parameter 1 !! Purpose  
|-
|-
| Filter By: '''Post Date''' || Parameter date to be filtered by '''Post Date'''.
| Filter By: '''Post Date''' || Parameter date to be filtered by '''Post Date'''.
Line 41: Line 41:
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Parameter 2 !! Purpose to filter
! Parameter 2 !! Purpose
|-
|-
| Filter By: '''Post Date''' || Parameter date to be filtered by '''Post Date'''.
| Group By || To be group by...Account Code, Post Date, Tax Date, Ref 1 (Doc No), Tax, etc.
|-
| Filter By: '''Tax Date''' || Parameter date to be filtered by '''Tax Date'''.
|-
| Date || Define the date range.
|-
| Account || Select the '''GL Account''' (for General Ledger), '''Customer Account''' (for Sales Ledger) and '''Supplier Account''' (for Purchase Ledger)
|-
| Project || Select the '''Project'''.
|-
|-
| Agent || Select the '''Agent'''.
| Merge GL Code for same document || Same documents and GL Account will be merged together.
|-
|-
| Area || Select the '''Area'''.
| Option: '''Exclude Project''' When Merging || Same documents and GL Account but '''different Project Code''' will be merged together.
|-
|-
| Control A/c || Select the '''Customer/Supplier Control Account'''. (Applicable to Sales Ledger and Purchase Ledger only)
| Use 2nd Description || To use 2nd description.
|-
|-
| Tax || Select all tax code (including '''non-GST''' Tax type)
| Include '''Zero Closing Balance''' || To show the accounts has zero closing balance.
|-
|-
| General Ledger || To generate the '''general''' transactions, eg. bank, cash, sales, purchase, fixed assets, etc.)
| Include '''Zero B/F with Transactions Before''' || To show the accounts has zero balance from B/F which has transactions before.
|-
|-
| Sales Ledger (Customer Control) || To generate the transactions related to '''Customers'''.
| '''Local''' Currency || All transactions converted into local currency value.
|-
|-
| Purchase Ledger (Supplier Control) || To generate the transactions related to '''Suppliers'''.
| '''Foreign''' Currency || All transactions remain as the original currency value, eg. USD, AUD, etc.
|}<br />
|}
 
'''NOTE : '''<br />
Do not click the tax rate arrow key down if the tax account is not defined yet.<br />
 
<br />
 
===Data Entry for Non-Deductible===
'''For Purchase Invoice'''<br />
:1. Insert a new detail row and key-in the '''total input tax not going to claim'''.<br />
:2. Select the tax code "ND-0".<br />
:3. See below screenshot.
::[[File:GST-Non-deductible Expenditure-02.jpg | 340PX]]
<br />
<br />


'''For GL Cash Book'''<br />
==Ledger (based on Tax Date)==
:1. Insert a new detail row and key-in the '''total input tax not going to claim'''.<br />
:1. Select '''Tax Date''' at Filter By.
:2. Select the tax code "ND-0".<br />
:2. Select the Date ('''Tax Date''') range.  
:3. See below screenshot.
:3. Apply the Ledger report to generate the GL transactions by '''Tax Date'''.
::[[File:GST-Non-deductible Expenditure-03.jpg | 340PX]]
::[[File:GL-Ledger-02a.jpg | 440PX]]<br />
<br />
<br />


'''NOTE: '''
:4. You can select all the tax code (including non-GST) to apply, eg. TX-NC.  
Please ensure you understand the Non-Deductible expenditure from your auditors before you apply this guide.
::[[File:GL-Ledger-02b.jpg | 440PX]]<br />
 
<br />
<br />


==How to analyse the total tax amount from Non-Deductible?==
NOTE:
''[ GL | Print Journal of Transaction Listing...]''<br />
You can compare the ledger based on '''Tax Date''' (GST taxable period) with GST Listing.


:1. Select the date range to APPLY.<br />
:2. Filter at the Tax grid column. See screenshot below.<br />
::[[File:GST-Non-deductible Expenditure-04.jpg | 240PX]]
<br />
<br />


:3. You can see the non-deductible transactions filtered by ND-0. <br />
==Ledger (based on Post Date)==
::[[File:GST-Non-deductible Expenditure-05.jpg | 240PX]]
:1. Select '''Post Date''' at Filter By.
:2. Select the Date ('''Post Date''') range.
:3. Apply the Ledger report to generate the GL transactions by '''Post Date'''.
::[[File:GL-Ledger-03.jpg | 440PX]]<br />
<br />
<br />
:4. From this instance, the total non-deductible expenditure amount is '''Rm3030.00''' <br />
'''NOTE: '''
This non-deductible tax amount will not post to GAF.


==See also==
==See also==
:[[Print GST Listing]]

Latest revision as of 01:55, 10 January 2017

Ledger Report

[GL | Print Ledger ...]

This ledger report consists of:
1. General Ledger
2. Sales Ledger (Customer Ledger)
3. Purchase Ledger (Supplier Ledger)
440PX


Parameter 1

Parameter 1 Purpose
Filter By: Post Date Parameter date to be filtered by Post Date.
Filter By: Tax Date Parameter date to be filtered by Tax Date.
Date Define the date range.
Account Select the GL Account (for General Ledger), Customer Account (for Sales Ledger) and Supplier Account (for Purchase Ledger)
Project Select the Project.
Agent Select the Agent.
Area Select the Area.
Control A/c Select the Customer/Supplier Control Account. (Applicable to Sales Ledger and Purchase Ledger only)
Tax Select all tax code (including non-GST Tax type)
General Ledger To generate the general transactions, eg. bank, cash, sales, purchase, fixed assets, etc.)
Sales Ledger (Customer Control) To generate the transactions related to Customers.
Purchase Ledger (Supplier Control) To generate the transactions related to Suppliers.

Parameter 2

Parameter 2 Purpose
Group By To be group by...Account Code, Post Date, Tax Date, Ref 1 (Doc No), Tax, etc.
Merge GL Code for same document Same documents and GL Account will be merged together.
Option: Exclude Project When Merging Same documents and GL Account but different Project Code will be merged together.
Use 2nd Description To use 2nd description.
Include Zero Closing Balance To show the accounts has zero closing balance.
Include Zero B/F with Transactions Before To show the accounts has zero balance from B/F which has transactions before.
Local Currency All transactions converted into local currency value.
Foreign Currency All transactions remain as the original currency value, eg. USD, AUD, etc.


Ledger (based on Tax Date)

1. Select Tax Date at Filter By.
2. Select the Date (Tax Date) range.
3. Apply the Ledger report to generate the GL transactions by Tax Date.
440PX


4. You can select all the tax code (including non-GST) to apply, eg. TX-NC.
440PX


NOTE: 
You can compare the ledger based on Tax Date (GST taxable period) with GST Listing.


Ledger (based on Post Date)

1. Select Post Date at Filter By.
2. Select the Date (Post Date) range.
3. Apply the Ledger report to generate the GL transactions by Post Date.
440PX


See also

Print GST Listing