Things to check when completing your GST Reconciliation report on the accruals basis
Review these items when you're balancing your GST Reconciliation report on the accruals basis for GST.
Have the report columns been filled in?
If you're using Full BAS
The GST Reconciliation report only displays data in the Adjustments and Filed columns from published BAS.
To check your BAS is published:
- In the Reports menu, select All Reports.
- On the Published tab, check your BAS for the period is listed.
If your BAS is not listed:
- Select the Drafts tab.
- Click the draft BAS to open it. If there isn't a draft BAS, run a new one.
- When you've reviewed it, click Publish.
If you're using Simpler BAS
If you're using the Simpler BAS reporting method, Xero doesn't populate the Filed column for you. You'll need to copy in these amounts from 1A and 1B of your finalised activity statements.
Is the conversion balance of your GST account correct?
If you've converted to Xero from another accounting system, ensure your conversion balance for GST is correct. Check you've entered all invoices and bills outstanding at conversion date correctly in Xero.
Are the opening balances on your GST Reconciliation report set to 0?
We recommend you always set the From date on your GST Reconciliation report as the start of the first period containing GST. This means that your opening balances will be 0.
See our worked examples for guidance:
You can also run the GST Reconciliation report for a specified period. You'll need to export the report and make some adjustments to balance it.
Review transactions in the GST Account Transactions section
If there are any transactions in the GST Account Transactions section of the report, check with your accountant or bookkeeper that you've coded them correctly. Normally, the only transactions you should see in this section are:
- Your GST conversion balance (if any)
- A trial balance adjustment (if you entered comparative balances with your conversion balance)
- Payments to and refunds from the ATO
- GST on import purchases
Have you accounted for manual adjustments on your BAS?
If you've made a manual adjustment to your BAS, make sure you process the transaction in Xero. Talk to your accountant or bookkeeper if you're not sure how to enter it.