Transaction types that may lead to issues
We always try to deliver the conversion with full transactional
history.
On occasions, if the following transaction types occur extensively we may only be able to provide a service with no or reduced history. In some instances it may prevent us from being able to complete the conversion at all. If this occurs we will endeavour to advise you as soon as possible.
- Manual journals to control accounts – Xero does not allow journals to control accounts. Where we encounter these transactions we use the conversion clearing account to replicate these journals in Xero. However extensive use of journaling to control accounts is outside the scope of our automated service and we will advise if we encounter this in your file.
- Tracked inventory – We cannot convert Tracked inventory however this can be set up post-conversion, for more information please see here.
- Multiple Accounts Receivable / Accounts Payable accounts – Xero only allows for one system Account for each Accounts Receivable / Accounts Payable. Where possible we will merge multiple Accounts Receivable / Payable accounts to conform with Xero’s functionality. However, if there are many, or complex, AR / AP accounts in the source file we will not be able to complete the conversion.
- Transactions with greater than 1,000 lines – There are limits to the number of API calls that we application can make against a particular Xero organisation. This includes transaction line limits - Xero will not allow Invoices / Bills to have in excess of 1000 transaction lines.
- Archived Chart of Accounts - Where the chart of accounts are archived and there is transactional data in the converted period this may prevent extraction of data for this chart of account. Please ensure these are all active.
- Any integrated add-ons – Add on’s bring data into accounting files in different ways. If you have an add on which posts a manual journal to accounts receivable of accounts payable for instance, we will bring in the payments into a secondary account under Accelerate package these will be reconciled and under any other package the user can reconcile post-conversion.
- GST set up as a bank account – In some accounting packages there is the ability to set GST Collected and GST Paid-up as Bank Accounts / Credit Cards. In Xero this action cannot be replicated and GST bank accounts can not be set up as the system account for GST. We suggest selecting a package with Bank Account mapping so that you can have this created as a current liability to avoid any conversion issues.
- Trade Debtors/Trade Creditors accounts linked to bank accounts – In some accounting packages you have the ability to set up bank accounts as the system account for Accounts Receivable / Accounts Payable. In Xero this action cannot be replicated and bank accounts can not be set up as the system account for Accounts Receivable / Accounts Payable. We suggest selecting a package with Bank Account mapping so that you can have this created as a current liability to avoid any conversion issues.
- Tax Codes used for both 0% and 10% – In some accounting packages you have the ability to set up and use Tax Codes as both 0% and 10%. Xero only allows one to be applied consistently throughout its use. As a result, we often find that there is a BAS Discrepancy between the two file. This is due to Xero only including calculated GST in the Activity Statement and to deliver a file with the correct GST balance we include variance as a transaction line within the invoice or bill. We do provide an email post-conversion advising this variance so you can make the necessary adjustments if you wish, alternatively, you can provide this to your financial professional for their records.
- Manual adjustment of GST- if the source file has transactions where the GST has been manually adjusted after the system has calculated the GST then it is possible that the GST when converting into Xero will be incorrect. eg if there is a GST free portion GST free tax code is required to be selected.
If we do identify an issue within your file we will let you know as soon as possible.
Please see below for the essential file preparation steps before uploading your file:
- MYOB (AU & NZ)
- Reckon (AU)
- Quickbooks (US)
Related Articles
Tracked Inventory after conversion
Our conversion brings across the accounting data associated with Inventory and not stock management data. Please see here for How inventory data is converted. About Tracked Inventory Inventory items are converted as 'Un-tracked Items' this allows ...
Inventory Items
All items are created in Xero with their item codes, descriptions and purchase and sales details. What we Convert Item number and item name Base Sales Price Standard cost COGS and Inventory $ COGs and Inventory Accounts Item Description: Note: there ...
Xero add-ons
We are not experts on Xero add-ons, and for this reason, it is best you speak to people that specialise in this area. To get more information about add-ons you can: Read about them on the Xero website Use the services of a cloud integrator
Chart of Accounts
Chart of Accounts All accounts including bank accounts come across in the conversion regardless of their status. This is because there may be transactions associated with these accounts. If you have accounts that you do not want to use you can ...
Using Xero
Paid Bill or Invoice Showing an Amount Due You may find that an invoice/bill is showing as unpaid even though there should be $0 amount due. All of your reports are displaying the correct balances but when you view this particular invoice/bill it ...