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.

Three separate types of reports can be generated:

1. A Detailed Report including transaction details per tax code.

2. A Summary Report displaying totals per tax code.

3. A Detailed Report including transaction line descriptions per tax code.