GST Reconciliation Report for Cash Purposes

Modified on Wed, 21 Feb at 12:08 AM

GST Reconciliation Report for Cash Purposes allows you to prepare your BAS for the relevant period for reporting to the ATO.

Note: A video outlining this process is embedded at the end of this article.

Access: Main menu > Accounting > General Ledgers > Reports- This Year and Last Year > GST Reconciliation Report – CASH Accounting

If you pay on a quarterly basis basis, you select the relevant period, example period 1 to 3, In this example, for a month, we will select period 1 to 1.
The Pay Date From/To is the reporting of your PAYG. In this example we select 1 July to 31 July 2018. If reporting for a quarter enter the relevant dates or alternatively if the last month of the quarter only enter that date.
Company is simply the company we are reporting on, in this example “1”. If you have more than one company you report for, you need to produce the report for that company and select for example company “3”.
Hit OK and this will merge the document in Word.

The First page of the GST Reconciliation Report is the Summary page which assists with your calculation. It is not populated automatically however allows you to complete the figures from the report prior to transcribing onto your BAS statement or lodging through the ATO portal.
The second and subsequent pages break down into a number of tables the figures to assist with calculating your GST payable
Table 1 looks at the Cash Received and Refunds
Table 2 is the summary of the GST Control Accounts, however, this is for reporting purposes only
Table 3 has the Transaction Summary based on input from LawMaster. For example, credit vouchers entered and debt transactions for invoices raised. You will need to also see if any DE or JRNL transactions have been added and manually adjust your GST figures.
Table 4 details the Journal Summary of all the transactions to the GST account.
Table 5 is the Summary of cash payments
Table 8 is the PAYG summary
Table 9 is any Invoice Exceptions

Calculating GST

GST Payable - Cash Received and Refunds

Substantiating Report

Refer to the Debtor Transaction Enquiry to confirm figures are correct.

Access: Main menu > Accounting > Debtors > Enquiry > Debtor Transaction Enquiry.

Report for the same period for your GST Reconciliation Report e.g. Period 1 to 1.

GST - Input Credits (Paid on Purchases)

Substantiating Report

Refer to the Print Payments History report.

Access: Main menu > Accounting > Accounts Payable > Reports > Print Payment History.

Report for the same period for your GST Reconciliation Report e.g. Period 1 to 1. You can also elect to show GST Only Payments.

Please Note: The total purchases figure may not balance to each other due to some transactions that have been allocated to a general ledger may have zero GST, however is included in the Gross Payment amount in the Payment History Report. You could then run the Payment History Report showing All Payments to have both reports balance.

PAYG

GST Journal

After you have completed your BAS, process a journal in LawMaster to the GST Control Account for the GST amounts, so you know what is payable to the ATO. It is recommended that you enter the journal for the period you are preparing your GST Reconciliation Report e.g. in this example we are processing the report for period 1, so the journal will be entered in period 1. If we are processing the report for periods 1 to 3, the journal will be entered in period 3.

Access: Menubar > Transactions > General Ledger Journal Input.