Ensure you use the best processes to migrate your data from Handiledger
First, you need a Xero ledger.
Ensure you import your chart of accounts during the set up.
Now you need to bring in opening balances.
There are many options.
Each has its pros and cons.
Manual method
Our all time favourite, especially if you have small asset registers.
This means just going to the opening balance screen and typing them in.
Accounting / advanced / conversion balances.
Pros
- Complete transparency
- No need to manipulate data in CSV
- Simple
- Do some, come back and finish it later
- Use CTRL C / CTRL V to copy and paste
- Typing the word “accounting” will present all accounts with “Accounting” in it
- Clean up the data on the way through
- Take a coffee break
Cons
- Boring
- Time consuming for large trial balances
Our experience shows:
- We recommend this for smaller to medium sized trial balances.
Import through a manual journal
Xero has an import template in CSV.
Looks under accounting / advanced / manual journals / import
You can copy the data into the template.
See image:
You only need to complete the RED sections, which is account name and balances.
Pros
- Speed - it does not take as long as the manual method
Cons
- Requires data formatting in excel, which can take time
- You can NEVER use the conversion balance window
Use the Xero conversion toolbox
Xero has a toolbox that can do many items, such as:
- Balances
- Assets
- Journals
- Invoices
- Bills
You will need to ask your Xero account manager for help here.
Pros
- High volume imports can be well managed compared to manual process
- If the account from the old system isn't in Xero, you can create it easy
- Bring in much more than balances
- Has a few AI smarts
Cons
- It's another user interface / software
- You can’t walk away half way through, do it until the end