12 min read |

Switching Accounting Software Is Awful. So We Made It One Click.

The reason you're still paying for software you complain about isn't loyalty — it's conversion dread. Here's what a correct conversion actually involves, why the industry never automated it properly, and how it became a single click.

Watercolour illustration of ledger books crossing a bridge of light from one shelf to another

Quick answer

A correct accounting software conversion needs four things: a balanced opening trial balance dated the day before your start date, debtors and creditors rebuilt from individual outstanding invoices (not totals), complete contact records, and a locked pre-conversion period. Done manually this takes days and goes wrong quietly. IQ Books automates the entire sequence for Xero, QuickBooks, Sage and Pandle: connect, choose a start date (it suggests the start of your financial year), preview what comes across with the numbers checked, click once — and it's reversible if you change your mind. IQ Books is in private beta with early access by request.

Ask a room of small-business owners how they feel about their accounting software and you will hear grumbling — about price, about clunky workflows, about features gated behind higher tiers. Ask the same room who is planning to switch, and the hands stay down. This is not an endorsement. It is dread.

The dread is rational. Everyone knows someone whose migration went wrong: the debtors that didn't tie, the VAT return that straddled two systems, the fortnight of evenings re-keying suppliers. Accounting software is the rare product category where the pain of leaving is so reliably awful that vendors can raise prices annually — and they do — with remarkably little churn. The switching cost is not a bug in the market. It is load-bearing.

So it is worth doing two things carefully: explaining what a correct conversion actually involves — because half the fear comes from not knowing — and then showing why none of it needs to be manual anymore.

What a correct conversion actually involves

Strip away the mystique and a conversion is one well-defined accounting exercise. You are drawing a line on a date and saying: before this line, the old system is the record; from this line, the new one is. Getting that right requires four components.

1. The opening trial balance — dated the day before

Your new books open with the old system's closing trial balance as at the day before your start date. If you start on 1 July, opening balances carry the world as it stood at close of 30 June. Every balance-sheet account comes across: bank balances, VAT owed, loans, equity. If you convert mid-year, the trial balance also carries the year-to-date profit-and-loss balances, which is what keeps your full-year accounts correct even though the year lives in two systems. The one non-negotiable: it must balance. A trial balance that doesn't tie in the old system will not be improved by moving it.

2. Debtors and creditors — rebuilt, not copied

Here is the step that separates a real conversion from a botched one. Your trial balance says debtors are £14,200 — but the new system cannot work with a single number. When a customer pays in August, the software needs the actual invoice to allocate that payment against; when you chase late payers, aging needs original invoice dates. So every outstanding invoice and unpaid bill must be recreated individually, at its original date, for its outstanding amount — and the sum of those documents must equal the control-account line in the trial balance. When it does, the conversion ties. When it doesn't, you want to know loudly, not discover it at year end.

3. Contacts — with their details, not just their names

Customers and suppliers need to arrive with emails, addresses, VAT numbers, payment terms and currencies, because invoicing resumes on day one. This is the step that eats the evenings when done by hand — and the step most CSV-export routes do worst, because a name without its terms and tax details is a contact you will be re-editing for months.

4. A locked line

Once opening balances are in, the pre-conversion period should be locked so nobody accidentally posts a transaction dated before the line. The old system stays available read-only for reference and HMRC's six-year record-keeping requirement. Two systems both accepting entries for the same period is how businesses end up with two versions of the truth.

Why the manual version goes wrong

None of these steps is intellectually hard. The failure mode is volume and drift: eighty outstanding invoices re-keyed by hand invite three typos; a trial balance exported on Tuesday but invoices exported on Thursday no longer describe the same moment; a missed supplier surfaces in month three as a payment with nothing to allocate it against. Manual conversions fail the way bookkeeping always fails — quietly, cumulatively, and at the worst possible time.

This is also why the traditional advice is "only switch at year end". It is not that mid-year conversion is improper — it is that when every step is manual, you minimise the number of chances to fumble. Automate the steps and the calendar constraint mostly evaporates.

What one click actually does

IQ Books has the conversion built in as a first-class feature — not a CSV import with aspirations, but the full accounting exercise above, automated end-to-end for Xero, QuickBooks, Sage and Pandle. The wizard runs from the org-creation screen, the dashboard, or Settings, and it works like this:

Connect and choose. Sign into the old platform once (or use an existing connection) and pick the company. IQ Books reads the company's own financial-year settings and suggests the cleanest start date — start of your financial year, with start-of-month and any-date options — and explains, in a sentence, that closing balances the day before become your opening balances.

Preview with the numbers checked. Before anything is written, you see what's coming: how many trial-balance lines, customers, suppliers and open invoices — and, crucially, whether the trial balance balances and whether the outstanding invoices tie to the debtors and creditors figures. The checks that a careful bookkeeper would run by hand appear as badges on the screen.

One click, then the machine does the accounting. The trial balance posts as opening balances dated the day before your start. Every outstanding invoice is recreated and issued at its original date, for its outstanding amount, with no VAT (that was accounted for in the old system) — which rebuilds debtors and creditors so aging and payment allocation work from day one. Bank balances become real bank accounts, ready for statement imports. Contacts arrive with their emails, addresses, VAT numbers, terms and currencies. The pre-conversion period locks automatically. And any residual difference between the invoices and the control accounts is parked visibly on a conversion-balances account — never silently absorbed, because a difference you can see is a question you can answer.

And it's undoable. This is the part that removes the last of the dread. If you picked the wrong company, the wrong date, or simply changed your mind, one click reverses the whole migration — invoices voided, opening balances reversed, everything swept — with a proper audit trail rather than a deletion. A conversion you can undo is a conversion you can attempt on a Tuesday afternoon instead of planning like a house move.

The guard rails matter as much as the speed

Speed without correctness would just be a faster way to ruin your books, so the engine enforces the accounting rules a cautious professional would: opening balances can only ever land before the first transaction already in the organisation — the software will refuse a date that would inject balances into the middle of live bookkeeping, and tells you the exact date it needs to precede. The old platform is read, never written: your Xero or QuickBooks data is untouched, which means the escape hatch stays open in both directions while you settle in.

That last point deserves emphasis because it inverts the industry's usual logic. Lock-in works by making departure feel dangerous. A migration that is one-click in, verifiable on screen, reversible, and leaves the source untouched is the opposite of dangerous — it converts the switching decision from a leap into a look.

What it costs to look

The old calculus was: endure the price rises, because the alternative is a fortnight of conversion risk. The new calculus is: the conversion is a click, the source system is untouched, the result is checkable line by line, and the destination — a ledger with the entire IQ Suite built in natively — starts at a fraction of what the incumbents now charge. IQ Books is in private beta; if you want to be among the businesses whose books it's already running, request early access. Bring a Xero, QuickBooks, Sage or Pandle company with you, and watch a fortnight of dread finish before your tea does.

Frequently Asked Questions

What are conversion balances when switching accounting software?

Conversion balances are the closing balances from your old accounting system as at the day before your start date in the new one, entered as opening balances. Every balance-sheet account carries over, while debtors and creditors are rebuilt from the individual outstanding invoices rather than entered as single totals — that is what keeps invoice aging and payment allocation working in the new system.

When is the best time to switch accounting software?

The start of your financial year is cleanest, because the old system holds complete years and the new system starts fresh with no year straddling two platforms. But a properly executed conversion works at any date — the start of a VAT quarter or a month works well — provided opening balances are dated the day before the start date and all outstanding invoices are brought over.

Can I switch accounting software mid-year?

Yes. A mid-year conversion brings over the trial balance as at the day before your chosen start date, which includes the year-to-date profit and loss balances, so your full-year accounts remain correct. The key requirements are a balanced opening trial balance, outstanding invoices recreated individually, and the old system kept read-only for reference.

How does IQ Books migrate from Xero, QuickBooks, Sage or Pandle?

IQ Books connects to the old platform's API, then in one click pulls the closing trial balance as at the day before your chosen start date, your complete customer and supplier lists with contact details, and every outstanding invoice at its original date and outstanding amount. It posts the opening balances, rebuilds debtors and creditors from the invoices, verifies the numbers tie, locks the pre-migration period, and the whole migration is undoable if you change your mind.