Complete your GST Reconciliation report with a conversion balance

Learn how to complete your GST Reconciliation when your organisation has a conversion balance for GST. We'll use an example to show how it works.

If you're a new organisation, or have recently registered for GST after using Xero for a while, follow the process for completing the GST Reconciliation after you start with GST.

Example scenario

  • Your organisation's conversion date is 1 April 2015.
  • You use the invoice basis to account for GST.
  • Your organisation files GST every 2 months, with the last GST return pre-conversion being for the 2 months ended 31 March 2015. This return was completed outside Xero.
  • Your conversion balance for GST is 5473.61 credit, that is, you owe GST to Inland Revenue.
  • You've entered your conversion balances into Xero, including details of invoices and bills outstanding at conversion date.
Unpaid invoices at conversion date
DateInvoice totalGST
20 Dec 20143664.22477.94
1 Mar 20153838.52500.68
15 Mar 20154723.58616.12
Totals12226.321594.74
Unpaid bills at conversion date
DateBill totalGST
5 Mar 20153889.01507.26
15 Mar 20152218.12289.32
16 Mar 20151668.06217.57
24 Mar 2015118.1915.42
29 Mar 2015625.3681.57
31 Mar 20151424.91185.86
Totals9943.651297.00

Number 1. Run GST Reconciliation report to check conversion balances

Run your GST Reconciliation report to the day immediately before your conversion date to check that your opening balances are correct.

  1. In the Reports menu, select All Reports.
  2. Under Tax, click GST Reconciliation.
  3. In the From date field, select the first day of the GST period before the date of the oldest unpaid invoice or bill.

    In this example, your oldest unpaid invoice is dated 20 Dec 2014. The first day of the GST period before that date is 1 Dec 2014. Enter 1 Dec 2014.

  4. In the To field, enter the day before your conversion date.

    In this example, enter 31 Mar 2015.

  5. Click Update.

    Image showing date fields.

Review the GST Reconciliation report and confirm:

  • All opening balances are 0.
  • If opening balances are not 0, change the From date to an earlier date.
  • The total unfiled GST collected matches GST on outstanding invoices at conversion date.

  • Total unfiled GST paid matches GST on outstanding bills at conversion date.

    Image showing GST paid section.

  • The only item in the GST Account Transactions section is your GST conversion balance. The amount is your total GST conversion balance minus GST on outstanding invoices at conversion date plus GST on outstanding bills at conversion date.

    Image showing GST Transactions section.

  • The GST Owing closing balance equals your GST Account Transactions balance.

    Image showing GST Owing section.

  • At the bottom of the report, the GST Account Summary balance equals your conversion balance for GST.
  • The GST Account Summary balance and the GST Account Balance match.

    Image shwowing GST Account Summary and GST Account Balance sections.

If your report does not meet these criteria, review your conversion balances and invoices and bills outstanding on conversion date and re-enter them if necessary.

Number 2. Save your report as a draft

When you've confirmed your report is correct, click Save as Draft.

Number 3. Complete your first GST return in Xero

Following the end of your first GST period after your conversion date:

  1. Complete your first GST return in Xero
  2. Save your GST return as final
  3. Publish the return

Image showing GST return for period ended 31 May.

Number 4. Update your GST Reconciliation report

After you've published your first GST return in Xero, update your GST Reconciliation report.

In this period you filed your pre-conversion GST return outside Xero, and paid your GST owing on that return to Inland Revenue.

  1. In the Reports menu, select All Reports.
  2. Click the Drafts tab.
  3. Click the draft GST Reconciliation report to open it.
  4. Don't change the From date. Change the To date to the end of the GST period you've just finalised. Click Update.

    Image showing To date 31 May.

  5. In the Filed column, enter the GST collected and paid amounts from your GST returns for 31 March and 31 May.

    Image showing GST collected and paid sections.

  6. If you made an adjustment on your GST return, enter it in the relevant Adjustments field.
  7. Check the GST Account Transactions are correct. This section of the report shows transactions coded directly to the GST account.

    In this example, you imported a purchase and used the tax rate 'GST on imports'. You also paid your conversion balance GST owing to Inland Revenue.

    Image showing GST Account Transactions section.

  8. Check the GST Owing section is correct.

    Image showing GST Owing section 31 May.

  9. Check the GST Account Balance matches the GST balance in your balance sheet at 31 May.
  10. Check the GST Account Summary balance matches the GST Account Balance.

    Image showing GST Account Summary and GST Account Balance 31 May.

  11. Click Save as Draft.

Number 5. Update the report for subsequent GST periods

Repeat Step 4 after you publish each subsequent GST return. Save as Draft to retain the figures you enter for each GST period.

You can export the report to Excel, PDF or Google Sheets at the end of each GST period to save a snapshot at that point in time.