Child pages
  • Out of Balance in Tax/GST Information Reconciliation report

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID: 9285, 2947

Here are the common causes of an "Out of Balance" in the Tax/GST Information Reconciliation report.

 

UI Expand
titleA timing difference between when tax/GST is remitted and when the new reporting period begins

If the report is filtered for the next reporting period, the Actual Account Balance will include the forwarding balance from the previous period. This causes the activity of the tax/GST code linked account to appear overstated when compared to the Expected Account Balance. As a result, an out of balance is reported. 

UI Expand
titleA transaction has been allocated directly to a tax/GST code's linked account

If the activity of a tax/GST code linked account consists of amounts allocated to it via a tax/GST code only, then the Actual Account Balance of that account must equal that tax/GST code's activity Total. Additional transactions that are directly allocated to a tax/GST code linked account will affect that account's activity. These introduced amounts will be reflected in the Actual Account Balance which will no longer equal the Expected Account Balance.

With the exception of recording your payment to or refund to the ATO/IRD, you should not allocate transactions directly to the GST Collected or GST Paid accounts.

UI Expand
titleThe opening balance of the tax/GST code's linked account is wrong or has been changed

Check the account opening balances by going to Setup > Balances > Account Opening Balances.

To check if an opening balance has been changed

  1. Restore a backup of your company file that you know has the correct opening balances.
  2. In the restored company file, take note of the opening balances.
  3. Correct the opening balances in your current working company file.
UI Expand
titleA tax/GST code's linked account has been changed part-way through the reporting period

If a tax/GST code's linked account has been changed, and that change is within the report's period, the tax/GST code's entire activity for that period is reported against the account it is currently linked to. As only a portion of the tax/GST code's activity was actually posted to its current linked account, an out of balance for the account will be reported.

To check if a linked account has been changed:

  1. Restore a backup of your company file from when your tax/GST was last reported.
  2. In the restored company file, run the Tax/GST Code List report.
  3. Click Show Hide and include the Tax/GST Collected and Tax/GST Paid columns in your report. This will display the linked accounts for each tax code.
  4. Print the report and compare it with the same report produced from your current working company file. This will identify any tax/GST codes that have had their linked accounts changed.
HTML Wrap
width15%
classcol span_1_of_5
 
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Tracking the profitability of profit centres using Jobs

Restoring a company file backup (New Zealand)

Backing up and restoring company files (Australia)

...