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 />
-==Parameters==
+==Parameter 1==
 ::{| class="wikitable"
 |-
-! Parameter Name !! 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'''.
 |-
-| Filter By: '''Tax Date''' || Parameter date to be filtered by Tax 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)
+| Account || Select the '''GL Account''' (for General Ledger), '''Customer Account''' (for Sales Ledger) and '''Supplier Account''' (for Purchase Ledger)
 |-
-| Project || Select the Project.
+| Project || Select the '''Project'''.
 |-
-| Agent || Select the Agent.
+| Agent || Select the '''Agent'''.
 |-
-| Area || Select the Area.
+| Area || Select the '''Area'''.
 |-
-| Control A/c || Select the Customer/Supplier Control Account. (Applicable to Sales Ledger and Purchase Ledger only)
+| 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.)
+| 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.
+| Sales Ledger (Customer Control) || To generate the transactions related to '''Customers'''.
 |-
-| Purchase Ledger (Supplier Control) || To generate the transactions releated to Suppliers.
+| Purchase Ledger (Supplier Control) || To generate the transactions related to '''Suppliers'''.
 |}<br />
+==Parameter 2==
-==Group and other options==
-:1.  <br />
-:2. Follow the below SETTINGS to create. <br />
 ::{| class="wikitable"
 |-
-! Field Name !! Field Contents
+! 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.
 |-
-| Code || ND-0 (Recommended code)
+| Option: '''Exclude Project''' When Merging || Same documents and GL Account but '''different Project Code''' will be merged together.
 |-
-| Description || Non-Deductible
+| Use 2nd Description || To use 2nd description.
 |-
-| Tax Type || (Non GST - Both Sales & Purchase)
+| Include '''Zero Closing Balance''' || To show the accounts has zero closing balance.
 |-
-| Tax Rate || 0% (please key-in)
+| Include '''Zero B/F with Transactions Before''' || To show the accounts has zero balance from B/F which has transactions before.
 |-
-| Tax Account || GST-301 (This field is compulsory. Due to tax rate is 0%, therefore no posting)
+| '''Local''' Currency || All transactions converted into local currency value.
 |-
-| Tax Inclusive|| Untick
+| '''Foreign''' Currency || All transactions remain as the original currency value, eg. USD, AUD, etc.
-|}<br />
+|}
-:3. Click Save. See below screenshot.
-::[[File:GST-Non-deductible Expenditure-01.jpg | 440PX]]<br />
 <br />
- '''NOTE : '''<br />
+==Ledger (based on Tax Date)==
- Do not click the tax rate arrow key down if the tax account is not defined yet.<br />
+: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'''.
+::[[File:GL-Ledger-02a.jpg | 440PX]]<br />
 <br />
-===Data Entry for Non-Deductible===
+:4. You can select all the tax code (including non-GST) to apply, eg. TX-NC.
-'''For Purchase Invoice'''<br />
+::[[File:GL-Ledger-02b.jpg | 440PX]]<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 />
+ NOTE:
-:1. Insert a new detail row and key-in the '''total input tax not going to claim'''.<br />
+ You can compare the ledger based on '''Tax Date''' (GST taxable period) with GST Listing.
-:2. Select the tax code "ND-0".<br />
-:3. See below screenshot.
-::[[File:GST-Non-deductible Expenditure-03.jpg | 340PX]]
-<br />
- '''NOTE: '''
- Please ensure you understand the Non-Deductible expenditure from your auditors before you apply this guide.
-<br />
-==How to analyse the total tax amount from Non-Deductible?==
-''[ GL | Print Journal of Transaction Listing...]''<br />
-: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]]