Changing Accounting Basis in Xero Post Conversion

Changing Accounting Basis in Xero Post Conversion

Changing Accounting Basis in Xero Post Conversion
Table of contents
Warning: We recommend that you do not use the file until it has been corrected.  Unless you understand the full accounting implication of the above steps there is a very high chance that the integrity of the data may be impacted by changes you make in the Xero organisation. This may not surface until sometime later and could result in major rework required.

Reconversion

If the file loaded for conversion was set to the wrong accounting basis you can choose to reconvert the file. This will attract a reconversion fee of $220 in addition to the original package conversion fee. 

How to Manually Adjust the Accounting Basis

If you decide to change your accounting method in Xero post-conversion you will notice the following:
  1. Your GST reconciliation report will have unfiled amounts
  2. The GST reconciliation report will no longer balance to the GST report and the balance of the GST account in your chart of accounts.
  3. Your BAS will no longer reflect what you have reported and filed with the ATO in MYOB.

This is all due to the difference between remitting GST for Cash and Accrual methods.

During the conversion process, we have already made a number of adjusting entries at various dates in Xero pre and post-conversion dates to compensate for the difference in GST handling between MYOB and Xero. Some of these entries will need to be readjusted to cater to the change to GST basis method.

Providing this advice is outside of the scope of services we offer so we recommend you confirm with your accountant or bookkeeper what adjustments are required and how to calculate them.

1. Change Accounting Basis in Financial Settings

Steps to update the Accounting Basis in Xero,
  1. In the Accounting menu, select Reports.
  2. Under Tax, click Activity Statement.
  3. Click Settings.
  4. Under GST Accounting Method, select the method you are changing to.
  5. Click Save & Continue

2. Record a GST adjustment

Once you’ve changed the GST accounting method, you may need to make an adjustment so your Activity Statement is correct.

For each quarter from when the transactional history commences in Xero, you will need to compare the MYOB and Xero BAS Report and make compensating adjustments to ensure that the figures in Xero match the data in MYOB. If GST adjustments have been captured in the quarter you could amend the existing adjustments alternatively please see below:

As per Xero's Help Centre To record the adjustment in Xero:
  1. Create a manual journal.
  2. Code all entries to the GST account using the relevant tax rates, and date the journal so it’s included in the correct period.
For example, you need to:
  1. Reduce sales (G1) by 11,000 (inclusive of 1,000 GST).
  2. Reduce purchases (G11) by 2,200 (inclusive of 200 GST).

Check your Activity Statement after changing the GST accounting basis method.

Check the following in the first few reports you create after changing the GST accounting method.

From Cash to Accrual Basis
From Accrual to Cash Basis
Check all entries are included.
Check entries already reported aren't repeated.
Unpaid invoices and bills raised prior to the change may not be reported when paid.
Unpaid invoices and bills raised prior to the change may be reported again when paid.

3. Review the GST Reconciliation

Please also review the GST Reconciliation report after changing the GST accounting method in Xero All GST reports are based on the GST accounting method in place at the time the report is run.
Once you’ve changed the GST accounting method, the GST Reconciliation report may not be correct. This is because the report should include all tax periods, and some tax periods will have had a different GST accounting method. If the report is not correct, you may need to make further adjustments or manually reconcile GST.


    • Related Articles

    • Check Your Accounting Basis

      We create a Xero organisation based on Accounting Basis in your source file. It is recommended that you check this and correct if necessary prior to uploading the source file to us for conversion. NOTE: for Australia Accounting Basis this should be ...
    • GST Reconciliation Post Conversion

      Publish your BAS for the period before your conversion date Run and publish the older BAS, or finalise the new Activity Statement for all periods prior to your conversion date that contain transactions with GST. You’ll need to do this in Xero so your ...
    • Changing GST Accounting Basis following a conversion

      Changing GST Accounting Basis following a conversion Changing your GST Accounting basis at any time, be it post conversion or some time in the future, will have an impact on the GST history. For example, with moving from Cash to Accrual all the ...
    • GST System Differences

      There are a number of differences in regards to GST handling that you need to be aware of when moving from one accounting package to another. These can impact you regardless of whether you are converting over yourself or using our conversion service. ...
    • BAS Reconciliation Checklist for Xero

      BAS Reconciliation Checklist for Xero Have you recently moved across to Xero and still figuring out how to navigate the software? Wish you had a guide for processing your Business Activity Statement efficiently? We have been working with Xero for ...