There is currently an issue that when a user runs a GST Reconciliation report on a Cash (Payments) Basis. The GST portion of Accounts Receivable / Accounts Payable Prepayments is reducing the GST in the AR or AP balances, and then causes the report to not balance.
To identify which prepayments are causing this issue run the Payable/Receivable Invoice Summary report for the 1st Jan 2017 to the end of the GST Period and:
- Include Prepayments
- Layout: Group by ‘Source’
- Select the GST column
- Filter by Status and select only Approved
The Prepayment group will then show the Prepayments that are causing the difference.
Note: TSO does not believe this will affect many school clients. ALWAYS reconcile the GST Return to the GST Reconciliation Report. Please contact us should you require assistance or a copy of the reconciliation instructions.