Setup & configuration · Guide 08 of 53
Moving your books from Xero, QuickBooks or Sage
Bring your opening position across from Xero, QuickBooks or Sage in one click — the opening trial balance, outstanding invoices and bills, and your bank accounts — then check it ties, and undo it cleanly if anything is wrong.
If you already keep your books in Xero, QuickBooks or Sage, IQ Books can bring your company across in one click. It uses the connection you already have to read your source books — it never changes them — and rebuilds your starting position in IQ Books: an opening trial balance, your outstanding customer invoices and supplier bills, and your bank accounts. This guide covers picking a start date, what does and doesn’t come over, how accounts are matched, how to check the result, and how to undo it.
Before You Start
Migration works on every plan, the free plan included. You’ll also need to be an owner or admin of the IQ Books organisation to connect the source platform.
- Your old books are left completely untouched — migration only reads from them.
- You can migrate into a brand-new organisation, or into an existing one that has no activity yet.
- If you’ve already connected the platform for MatchIQ or CodeIQ, it will show as ready to migrate from with no extra sign-in.
Choosing The Right Start Date
The start date is the first day you want to trade “live” in IQ Books. Everything before it belongs to your old system. IQ Books dates the opening balances the day before the start date, and locks that period so nothing can be posted into it by mistake.
- Pick a clean cut-over. The best start date is the first day of a VAT quarter or your financial year, so a single VAT period never straddles two systems. The wizard suggests your current financial-year start and the start of the current month from the source’s year end.
- New organisation. Creating a fresh organisation counts against your organisation allowance and comes with a seeded chart of accounts.
- Existing organisation. You can only migrate into an org whose first transaction is dated after your chosen start date. If the org has already been used earlier than that, IQ Books refuses the import. Migrating into an unused org uses no extra slot.
Running The Migration
- Open the wizard. Go to
Settings → Organisationand choose Move my books (it’s also offered on the dashboard). Pick Xero, QuickBooks or Sage and connect it if you haven’t already. - Pick the company. Choose the company, tenant or realm you want to bring across under that connection.
- Set the destination and start date. Choose a new or existing organisation and confirm the start date.
- Review the preview. Before committing, IQ Books shows how many trial-balance lines, customers, suppliers and invoices it found, whether the source trial balance balances, and whether your outstanding invoices and bills tie to the debtor and creditor totals.
- Start and wait. Click start and watch the progress. When it finishes, your organisation has opening balances, brought-forward invoices and bills, real bank accounts, and a locked pre-migration period.
What Comes Across (And What Doesn’t)
Migration brings your starting position, not your full history:
- Comes across: the opening trial balance as one dated journal; every outstanding customer invoice and supplier bill, re-created as real documents (with their original dates and no VAT, since that VAT was already declared in your old system) so ageing and payment allocation still work; and your bank accounts with their opening balances.
- Doesn’t come across: transaction-by-transaction history before the start date, individual historical bank lines, and past reconciliation status. Your old system keeps all of that, so hold on to its reports for prior-year detail.
How Bank Accounts And Categories Are Matched
Chart-of-account codes differ between platforms, so IQ Books lines accounts up by name, not code. A name it recognises reuses the existing IQ Books account; a name it doesn’t creates a new one. Your bank accounts arrive the same way — matched by name and turned into real, usable bank accounts.
Checking The Opening Trial Balance
- Run the trial balance. Go to
Reports → Trial Balanceand set the “as at” date to the day before your start date. - Compare to your old system. Pull the same-dated trial balance from the source and check the figures line up. Debits and credits will always equal each other in IQ Books, because the opening balance is posted as a balanced journal.
- Check the Conversion accounts. Your debtor and creditor balances are rebuilt from the re-issued invoices and bills, using a pair of temporary Conversion holding accounts (numbered 9997 and 9998). When everything ties, these net to zero. Any leftover means your outstanding documents didn’t fully match the debtor or creditor total in the source — IQ Books shows this residue honestly rather than hiding it.
- Tie out the ageing. Open Aged Debtors and Aged Creditors and confirm they agree with the debtor and creditor control balances on the trial balance.
Undoing A Migration
If the start date, company or destination was wrong, you can undo cleanly. Nothing is ever hard-deleted — reversals are posted so the audit trail stays intact.
- Open the migration history. Go to
Settings → Organisation, find the completed migration, and choose Undo. - New-organisation migration. The whole organisation is archived and its slot returns to your allowance.
- Into an existing organisation. IQ Books reverses it in order: lifts the lock it set, voids the brought-forward invoices and bills, reverses the opening-balance journal, and archives any contacts, accounts and bank accounts it created that gained nothing else.
Common Questions
Will this change my Xero, QuickBooks or Sage books? No. Migration only reads from them; your old books are untouched, so you can keep them as a reference.
Why do my brought-forward invoices show no VAT? That VAT was already accounted for on your old system’s returns. Re-issuing the invoices without VAT means you can still age them and receive payment without declaring the same VAT twice.
What if the source trial balance doesn’t balance? The preview warns you before you commit, and any imbalance lands visibly in the Conversion accounts afterwards rather than being absorbed — so you can spot and fix it.
Can I re-run it? Yes, but it’s cleanest to undo first. On a re-run, same-named archived accounts are revived rather than duplicated.