GL - GST on Tax Journals Report
Overview
The General Ledger 'GST on Tax Journals Report' program enables you to produce two reports detailing Tax Journal entries for Goods and Services Tax (GST) transactions that have been processed through TASS.web:
Expenditure Report (Acquisitions).
Revenue Report (Supplies).
The report details transactions grouped by 'Tax Code' and includes the following detail:
Transaction-type and Date.
Year and Period.
GL Account
Reference (Journal Number).
Tax (expressed as a percentage).
Nett amount, Tax amount and Totals.
Choose the 'Screen with Hyperlinks' Formatting Option to drill-down to the 'Tax Journal Details' screen for further details.
General Tab
Run your expenditure report first then repeat the process for the revenue report.
Step 1
The default is 'GST on Tax Journals – Expenditure Report'.
Click the 'GST on Tax Journals – Revenue Report' radio button when you are ready to produce the second report.
Step 2
Select the 'Year' and 'Period(s)' to include in your report.
Choose either a 'Start Year/Period and End Year/Period' OR 'Start Date and End Date'.
Step 3
By default, the report will include transactions for all 'Tax Code' values.
Bank Code | Leave this blank to include transactions for all bank accounts on your report. If you do not want to include all accounts on the report, use the drop-down list to select the individual account(s). Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key allows individual selection of accounts. |
Tax Code | Leave this blank to include transactions for all relevant tax codes on your report. If you do not want to include all tax codes on the report, use the drop-down list to select individual code(s). Holding down the 'Shift' key while clicking on your options permits a range selection, holding down the 'Ctrl' key allows individual selection of accounts. |
Print Tab
Sort By
The report is sorted by 'Tax Code'.
Formatting Options
Choose the 'destination' of the report. This can be to Adobe® PDF viewer, Microsoft Excel®, Microsoft Word® or a screen with hyperlinks.
The 'Screen with Hyperlinks' format is best if you need to 'drill-down' to the source tax journal.
Show Table Borders and Alternative Row Colours | The 'Table Borders' and 'Alternate Row Colours' options can enhance the readability of the report but are not available if the listing destination is Excel®. |
Three separate types of reports can be generated:
A Detailed Report including transaction details per tax code.
A Summary Report displaying totals per tax code.
A Detailed Report including transaction line descriptions per tax code.