Why is there an unfiled amount on the GST Reconciliation report?
You might see an unfiled amount in your GST Reconciliation report for these reasons.
The Filed amount on the report comes from the published BAS. It's calculated by dividing the gross amount subject to GST by 11. There may be a small rounding difference between this amount and the actual GST on the GST Audit Report.
As whole dollars are reported to the ATO, these differences always show as unfiled amounts. They don’t clear if you post a manual journal. You can manually edit the GST Reconciliation report to clear the unfiled amount but this won't adjust the GST account balance. The edited figures will only appear on the published GST Reconciliation report.
If there's a large difference, check the GST on the GST Calculation Worksheet against the GST Audit Report.
Transactions entered or edited in a GST period after the BAS was published in Xero
Any transactions entered or edited in Xero for a GST period where the BAS is already published aren't automatically included in the next period's BAS.
Option 1 - Reverse and re-enter the transaction
Reverse the transaction or changes made in the prior GST period, and enter the correction or transaction in the current GST period.
You can re-run the BAS and compare the new GST Audit Report to the published report to identify which transactions are new or have changed.
Option 2 - Re-lodge the BAS
Re-run and publish the BAS for the period the changes occurred in. Then lodge an amended BAS with the ATO.