| Line 41: | Line 41: | ||
::{| class="wikitable" | ::{| class="wikitable" | ||
|- | |- | ||
! Parameter 2 !! Purpose | ! 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. | ||
|- | |- | ||
| 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) | ||
|- | |- | ||
| | | 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. | ||
|}<br /> | |}<br /> | ||
<br /> | <br /> | ||
Revision as of 09:03, 9 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 to filter 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. Account Select the GL Account (for General Ledger), Customer Account (for Sales Ledger) and Supplier Account (for Purchase Ledger) 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.
How to analyse the total tax amount from Non-Deductible?
[ GL | Print Journal of Transaction Listing...]
- 1. Select the date range to APPLY.
- 2. Filter at the Tax grid column. See screenshot below.
- 3. You can see the non-deductible transactions filtered by ND-0.
- 4. From this instance, the total non-deductible expenditure amount is Rm3030.00
NOTE: This non-deductible tax amount will not post to GAF.