Print Ledger Report: Difference between revisions

From eStream Software
Line 38: Line 38:
|}<br />
|}<br />


==Group and other options==
==Parameter 2==
:1.  <br />
:2. Follow the below SETTINGS to create. <br />
::{| class="wikitable"
::{| class="wikitable"
|-
|-
! Field Name !! Field Contents
! Parameter 2 Name !! Purpose to filter
|-
|-
| Code || ND-0 (Recommended code)
| Filter By: '''Post Date''' || Parameter date to be filtered by '''Post Date'''.
|-
|-
| Description || Non-Deductible
| Filter By: '''Tax Date''' || Parameter date to be filtered by '''Tax Date'''.
|-
|-
| Tax Type || (Non GST - Both Sales & Purchase)
| Date || Define the date range.
|-
|-
| Tax Rate || 0% (please key-in)
| Account || Select the '''GL Account''' (for General Ledger), '''Customer Account''' (for Sales Ledger) and '''Supplier Account''' (for Purchase Ledger)
|-
|-
| Tax Account || GST-301 (This field is compulsory. Due to tax rate is 0%, therefore no posting)
| Project || Select the '''Project'''.
|-
|-
| Tax Inclusive|| Untick
| 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'''.
|}<br />
|}<br />
:3. Click Save. See below screenshot.
::[[File:GST-Non-deductible Expenditure-01.jpg | 440PX]]<br />
<br />


  '''NOTE : '''<br />
  '''NOTE : '''<br />

Revision as of 08:13, 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)
440PX


Parameters

Parameter Name 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 Name 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.

NOTE : 
Do not click the tax rate arrow key down if the tax account is not defined yet.


Data Entry for Non-Deductible

For Purchase Invoice

1. Insert a new detail row and key-in the total input tax not going to claim.
2. Select the tax code "ND-0".
3. See below screenshot.
340PX


For GL Cash Book

1. Insert a new detail row and key-in the total input tax not going to claim.
2. Select the tax code "ND-0".
3. See below screenshot.
340PX


NOTE: 
Please ensure you understand the Non-Deductible expenditure from your auditors before you apply this guide.


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.
240PX


3. You can see the non-deductible transactions filtered by ND-0.
240PX


4. From this instance, the total non-deductible expenditure amount is Rm3030.00
NOTE: 
This non-deductible tax amount will not post to GAF.

See also