GST System Differences

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. They mainly apply to Tax Exclusive invoices and when the entity is set up for CASH Accounting.

This post provides an explanation of the GST differences between MYOB and Xero and how they may impact conversions with transactional history.

Most times we will deal with GST calculation differences in the invoice or bill by using additional line(s) to ensure the GST total matches between Xero and your source software. Occassionally we may need to make a small annual journal to balance these differences over the transactional period converted. If this second action is required it will be mentioned in your post conversion Action Checklist.

Credit Notes and the Date They are Applied

MYOB / Reckon
  1. MYOB / Reckon applies credit notes on any date the user chooses. The result of this, if CASH Accounting is used, is that the applied date is the date that GST is recorded as being credited.
  2. For example – Sales Invoice created in February, Credit note issued in March and applied in April. The result is that the GST credit is not recognised until the following GST period.
Xero
  1. Xero works off the later of the dates of the invoice and credit note.
  2. For example – Sales invoice created in February, Credit note issued in March, therefore payment(credit) is applied in March also. The result is that the GST credit is recognised in March, the current GST period.
A possible impact is that as the conversion replicates the Xero method of applying the Credit note, the conversion balances can sometimes be affected by credit notes due to timing differences.  In our conversions, we enter compensating transactions to match the balances in MYOB / Reckon.

Overpayments

MYOB / Reckon
  1. If an invoice is overpaid in MYOB / Reckon (CASH) then the full value of GST of the payment is posted to GST Collected and then recognised on the BAS. When a refund is made to the customer then the appropriate portion of GST is also posted as a credit.
  2. For example – an invoice for $110 (inc GST) has a payment of $220 applied (double payment). $20 GST will go to GST Collected. When a refund is done for $110 then $10 will come out of GST collected.
Xero
  1. If an invoice is overpaid in Xero (CASH) then only the GST portion of the original Invoice is posted to GST Collected on payment, the rest of the transaction is marked as BAS Excluded. This recognises that there has not been a sale just an overpayment.
A possible impact is that there will be 2 lines for the transaction in Xero not 1 as previously in MYOB / Reckon. Otherwise, the invoice totals will be the same.  Some of the system differences as mentioned affect the timing and capture of GST. Due to these differences in our conversions, we may need to add adjusting entries to move GST from Paid to Collected and vice-versa to match the quarterly BAS’s submitted since the conversion date (when the transactions commence in Xero). 

Recognition of GST Paid/Collected in Invoices

MYOB / Reckon
  1. MYOB / Reckon Sales – all GST on the invoice is recognised as GST Collected.
  2. MYOB / Reckon Purchases – all GST on the invoice is recognised as GST Paid.
For example in MYOB / Reckon – A sales invoice with sale of items plus $25 for freight posting to an expense account for Freight Recovered. All GST will post to GST Collected.
Xero
  1. Xero Sales – GST is recognised based on the account type used on the invoice, Income to GST Collected, Expense to GST Paid.
  2. Xero Purchases – GST is recognised based on the account type used on the invoice, Expense to GST Paid and Income to GST Collected.
For example in Xero – Sales Invoice with sale of items plus $25 for freight posting to an expense account for Freight Recovered. GST post to GST Collected for the item sale, and GST for the freight will post to GST Paid. Please see example 1.1 below:

Example 1.1
      

Due to these differences, the totals of GST Collected and GST Paid may appear to be different than your source file. If this is the case, you will find the difference between the two account balances out, therefore the amount of GST Payable / Refundable is captured correctly in the BAS reports.

For a basic example: In MYOB if GST Collected is $200 and GST Paid is $50 the total payable is $150. In Xero, if GST Collected appears as $500 and GST Paid appears as $350 the total payable remains $150.

Invoice Rounding

MYOB
  1. Unit cost is stored with 4 decimal places.
Xero / Reckon
  1. Unit cost is stored with 2 decimal places.
A possible impact is that line totals not being the same on conversion, that is that the GST is a couple of cents more or less, but the total of the invoice should be the same.  In our conversions, we add balancing lines to the transaction so that the Xero invoices match MYOB / Reckon.

      

1/11th Rule

MYOB
  1. GST is calculated by using the 1/11th rule based on the total invoice amount.
Xero / Reckon
  1. Xero / Reckon calculates 1/11th of the line total.
A possible impact for MYOB conversions is that invoice totals could no longer match on conversion.  In our conversions, we add balancing lines to the transaction so that the Xero invoices match MYOB.

Adjusting GST to Match Supplier Invoice

MYOB
  1. Allows editing of the GST amount on purchase invoices to be able to match the provided document.
Xero / Reckon
  1. Xero / Reckon is strict on only accepting 10% as the GST amount. (% as set up in the Tax tables for the code used).
If necessary for the conversion we will split the invoice lines into GST and FRE lines so that the invoices will have the correct GST and Invoice Total.

Non-Standard Tax Codes

MYOB / Reckon
  1. Allows non-standard tax codes to be set up.
  2. As it is not possible to determine the correct treatment (due to an MYOB / Reckon limitation) during our conversion process it is only possible to establish whether it is GST 10% or GST Free 0%.
We cannot complete conversions that use custom tax codes with any other percentages at this point.
The possible impact is this may cause variation in the Xero GST reporting. The categories and breakups will no longer exist for historical reporting. As the accountant, you will need to add back these non-standard tax codes post-conversion. There may be an impact on them flowing through to BAS – here is a link to Xero support on setting up non-standard tax codes.

Only One GST Account in Xero

MYOB
  1. Allows more than one GST posting account, usually GST Collected and GST Paid.
Xero / Reckon
  1. Uses one GST posting account and keeps track of GST Collected and GST Paid in a sub-ledger. In Reckon this is generally called tax payable.
Our conversions merge the GST accounts into one account. We also use a GST Conversion Balance account for achieving this goal, this account should not be adjusted or used post-conversion.

Conversion Adjustments to Compensate

To compensate for the differences in GST treatment between MYOB, Reckon and Xero, we enter adjusting transactions and lines using our conversion Clearing Accounts during the conversion process.
NOTE: Transactions should not be added to or removed from these accounts without first checking with us as this may have an impact on Conversion Balances.

MYOB Clearing Account Transactions

Managing GST

As you can see GST treatments differ between MYOB, Reckon and Xero and can cause data disruption and potential confusion on the part of your client.

At Jet Convert, we have developed a methodology for checking and treating GST tax components when bringing transactions across from MYOB and Reckon to Xero. As you are aware compensation for the GST differences between MYOB, Reckon and Xero, we enter adjusting transactions and lines using our conversion Clearing Accounts during the conversion process. If you do a conversion with us transactions should not be added to or removed from these accounts without first checking as this may have an impact on Conversion Balances.  Our aim is to have the GST data in the best shape possible for your client to work with.

New Zealand - GST Reporting Frequency

Please note if the MYOB source file has a GST reporting frequency of:
  1. Annual (12 months) we have made this setting in Xero as 6 Monthly.
  2. Quarterly we have made this setting in Xero as 2 monthly
  3. Monthly will continue to be set as monthly in Xero.
These variances are due to old options in MYOB which do not currently relate to the current options with the Inland Revenue Department.


    • Related Articles

    • System Differences - Creation of Trade Debtors/ Creditors Original Accounts

      When converting information to Xero there are some system differences that need to be taken into consideration. For example, some accounting systems will allow you to create direct entries & manual journals to the Trade Debtor and Trade Creditor ...
    • $0 balance invoices/Differences in the GST Reconciliation Report

      Invoices that have positive and negative lines that result in the balance of the invoice being $0.00 are captured differently among accounting systems. These are sometimes used to Journal an amount from one account to another without creating a ...
    • 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 ...
    • 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 ...