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 1: / Line 1: @@
-<big>Print Ledger Report</big>
+==Ledger Report==
+''[GL | Print Ledger ...]''<br />
+:This ledger report consists of:
+::1. General Ledger
+::2. Sales Ledger (Customer Ledger)
+::3. Purchase Ledger (Supplier Ledger)<br />
+::[[File:GL-Ledger-01.jpg | 440PX]]<br />
+<br />
+==Parameter 1==
-'''GST Expenditure (Effective from YA 2015)'''<br />
-:1. para 39(1)(o): GST input tax paid or to be paid not allowed as deduction if:-
-::a. Non-registered person with turnover exceed GST threshold of Rm500,000.
-::b. Registered person fail to claim input tax credit his entitled to claim.<br />
-:2. section 39(1)(p): Output tax absorbed by GST by registered person is not allowed as tax deduction.<br />
-:3. GST block input tax & deductible expenses:-
 ::{| class="wikitable"
 |-
-! Block Tax !! GST input Tax !! Tax deductible?
+! 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'''.
 |-
-| Passenger car (Cost and maintenance)  || Blocked || Deductible (to claim capital allowance)
+| Agent || Select the '''Agent'''.
 |-
-| Club subscription fee || Blocked || '''Non-deductible'''
+| Area || Select the '''Area'''.
 |-
-| Medical insurance/personal accident insurance || Blocked || Deductible
+| Control A/c || Select the '''Customer/Supplier Control Account'''. (Applicable to Sales Ledger and Purchase Ledger only)
 |-
-| Family benefits || Blocked || Depend (check with your auditors or tax consultant)
+| Tax || Select all tax code (including '''non-GST''' Tax type)
 |-
-| Entertainment expenses (Potential customer) || Blocked || '''Non-deductible'''
+| General Ledger || To generate the '''general''' transactions, eg. bank, cash, sales, purchase, fixed assets, etc.)
 |-
-| Entertainment expenses (Supplier) (p || Blocked || Allowed 50% deduction
+| Sales Ledger (Customer Control) || To generate the transactions related to '''Customers'''.
-|}
+|-
-<br />
+| Purchase Ledger (Supplier Control) || To generate the transactions related to '''Suppliers'''.
+|}<br />
-==How does this work?==
+==Parameter 2==
-===Setup New Tax Code===
-''[GST | Maintain Tax ...]''<br />
-:1. Click New. <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 />
- 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]]