Print Ledger Report: Difference between revisions

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)

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.

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

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.

@@ Line 5: / Line 5: @@
 ::2. Sales Ledger (Customer Ledger)
 ::3. Purchase Ledger (Supplier Ledger)<br />
-::[[File:GL-GL_Ledger-01.jpg | 440PX]]<br />
+::[[File:GL-Ledger-01.jpg | 440PX]]<br />
 <br />
@@ Line 11: / Line 11: @@
 ::{| class="wikitable"
 |-
-! Parameter 1 !! Purpose to filter
+! Parameter 1 !! Purpose
 |-
 | Filter By: '''Post Date''' || Parameter date to be filtered by '''Post Date'''.
@@ Line 41: / Line 41: @@
 ::{| class="wikitable"
 |-
-! Parameter 2 Name !! 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 />
-'''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 />
- '''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 />
-==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 />
-: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 />
-: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==
+:[[Print GST Listing]]