Skip to the guide
IQ Booksby ReconcileIQ

Setup & configuration · Guide 02 of 53

Setting opening balances

When you migrate to IQ Books mid-year, opening balances tell the ledger what each account stood at on day one. The workflow generates a single dated journal that the rest of your books posts against.

Most businesses do not start IQ Books on day one of a fresh fiscal year. Opening balances are how you bring across the closing position from your previous bookkeeping — whether that was a spreadsheet, a different platform, or your accountant’s end-of-year file — so that the ledger you build going forward sits on top of accurate starting figures.

Where to start

Accounting → Opening balances is a form of lines: for each one, the account, whether its balance is a debit or a credit, the amount in your base currency and a memo. Add line gives as many as you need, and the running totals show whether the debits and credits agree before you commit. Usually these are balance-sheet accounts only; income and expense accounts carry a balance only when the books start part way through a financial year.

Moving from other software

Run the trial balance in your old software as at the day before your first day in IQ Books, and date the opening balances that same day. If you start in IQ Books on 1 July, the trial balance and the opening balances are both at 30 June. Type its lines in, or upload it (below).

Starting a new business

There is no old trial balance, so the opening balances record what the owner put in and took out before day one. For a sole trader:

  • Owner Capital as a credit: what you paid in (capital introduced).
  • Owner Drawings as a debit: anything you took out.
  • The bank account as a debit: what is in it on day one. With the two lines above, that balances.

Add capital and drawings lines puts those accounts on the form for you to fill in. If you type only what is in the bank, Balance with Owner Capital adds the matching capital line. A new limited company does the same with Share Capital and any Director’s Loan Account.

Upload a trial balance

Rather than typing each line, Upload a trial balance takes the closing trial balance from your old software, as CSV or Excel:

  1. Choose the file and the date the opening balances are dated (your cutover date). IQ Books finds the account code and name columns and either a debit and a credit column or one balance column (for a single column, say whether credits are shown as negative or positive).
  2. Match the accounts: each row is matched to your chart by its code, then its name, then the words in another order, then the names old trial balances use for control accounts (trade debtors, trade creditors, VAT, PAYE, retained earnings, share capital and so on). A code that is a different account here is never guessed: the row says so and you pick. Pick an account for anything left unmatched.
  3. It has to balance. Put on the opening balances then fills this form (rows on the same account are added together), with the date set. Nothing has posted yet: check the lines, then Commit opening balance.

Debtors and creditors in a trial balance are single figures, so the aged debtors and creditors reports would have no invoices or bills behind them. To have each customer’s and supplier’s documents there instead, add an account such as “Opening balances conversion”, put the debtors and creditors lines on it in the upload, then enter each outstanding invoice and bill with its own date and its line on that same account (not on sales or a cost, which would count them twice). Once they are all in, the conversion account is back to nothing and debtors and creditors are made of the real documents. A migration from Xero, QuickBooks or Sage does all of this for you.

Only a code or the very same account name is taken as a match. A name with the same words in another order (“Office Equipment Depreciation” against “Accumulated Depreciation - Office Equipment”) is offered and waits for Yes, this one, because the two can be a charge and a balance. Amounts marked Dr and Cr are read as debit and credit balances, and a row whose amount cannot be read is listed rather than left out.

What “opening balance” means in IQ Books

The opening balances post as one balanced journal dated on your cutover date (opening_balance:YYYY-MM-DD). The form will not commit until the debits equal the credits; if they do not, you have missed an account or entered one on the wrong side. Committed opening journals are listed under the form, and one put in wrongly can be deleted there (it is reversed, and both stay on the record) and entered again.

The migration cutover date

Pick one date and stick to it. Every transaction dated before the cutover is the previous system’s problem; every transaction on or after the cutover lives in IQ Books. The opening balances journal itself is dated on the cutover.

If you choose, say, 1 April, then:

  • Bank balances on 31 March become opening balances dated 1 April.
  • Outstanding invoices and bills as of 31 March are entered with their original dates and amounts but are not double-counted in the opening journal — their effect on debtors and creditors is captured because the AR/AP opening balances net to the total of those outstanding documents.

Order of operations

  1. Create your bank accounts first in Banking → Bank accounts. Each bank account links to a chart-of-accounts row, so this needs to exist before opening balances can populate it.
  2. Create your customers and suppliers — the parties you have outstanding invoices or bills with.
  3. Enter outstanding sales and purchase invoices with their original issue dates and amounts. They become outstanding documents in the new system, due dates intact.
  4. Enter remaining opening balances in the Opening balances workspace: bank balances, fixed assets, accumulated depreciation, capital, retained earnings, VAT control, etc.
  5. Verify the trial balance in Reports → Trial balance for your cutover date. Debits should equal credits; account balances should match what the previous system showed.
  6. Commit. Once committed, the opening journal is fixed like any other — if you find an error, delete it from the list under the form (it is reversed) and enter it again rather than editing in place.

Common mistakes

  • Forgetting the VAT control account. If you were VAT-registered before migration, there is almost certainly a balance owed to or by HMRC at cutover. Enter it; otherwise your first VAT return after migration will be wrong.
  • Treating P&L accounts as openings. Don’t. Revenue and expense accounts always start at zero on the first day of the period. Cumulative profit-to-date sits in retained earnings (or the equivalent equity account), not in the P&L lines themselves.
  • Doubling up on outstanding invoices. If you enter the customer invoice itself, you do not also need to put a separate opening balance against AR — the invoice will populate AR for you. The opening AR balance you enter should equal exactly the sum of any outstanding invoices you did not separately enter.

Related guides

Entering the Opening-Balance Journal Line by Line

Opening balances are entered as one dated batch on the Opening balances screen. IQ Books turns that batch into a single journal and posts it straight away, so it pays to line up your figures before you start.

  1. Open the Opening balances screen. You’ll need an owner, admin or bookkeeper role to post one.
  2. Set the opening-balance date. Use the day before your first live IQ Books trading day — if you go live on 1 July, date the balances 30 June. Everything you post from your first trading day onwards then sits on top of this starting position.
  3. Add a line for each account. Pick the account and enter its balance as either a debit or a credit. You need at least two lines, every amount must be greater than zero, and each line is one side only — a debit or a credit, never both.
  4. Make the batch balance. Total debits must equal total credits to the penny. If they don’t, IQ Books refuses the batch and shows you the difference so you can find what’s missing.
  5. Post the opening balances. The journal posts immediately. Only accounts that belong to this organisation and aren’t archived can be used.

Only one opening-balance batch is allowed per date. If you try to enter a second one on the same day, IQ Books tells you opening balances already exist for that date — fold the extra lines into the existing batch (delete and re-enter it, see below) or use a different date.

Turning Your Old Trial Balance Into Opening-Balance Lines

The cleanest source for your opening balances is the trial balance from your previous system as at the cutover date. Each trial-balance line becomes one opening-balance line, keeping the same debit or credit side.

Say you’re moving across on 1 July 2026, so your balances are dated 30 June 2026, and your old trial balance reads:

  • Bank current account — £8,400 debit
  • Trade debtors (money owed to you) — £12,000 debit
  • Equipment at cost — £6,000 debit
  • Trade creditors (money you owe) — £5,200 credit
  • VAT owed to HMRC — £3,100 credit
  • Capital / retained earnings — £18,100 credit (the balancing figure)

Enter each of those as a line on the same side it sits on in your trial balance. Debits total £26,400 and credits total £26,400, so the batch balances and will post. The capital or retained-earnings line is what makes the two sides meet: it represents the accumulated worth of the business built up before you switched. A limited company uses retained earnings and share capital here; a sole trader uses a capital or owner’s account.

Missing one figure on cutover day? Enter everything you do have and park the difference in Suspense (account 999) so the batch balances and posts. A balance sitting in Suspense is expected, not an error — move it to the right account with a normal adjustment once you have the number.

Fixing or Removing Opening Balances You Entered Wrong

Posted opening balances are never edited in place. If you dated them wrongly, put them on the wrong organisation, or mistyped a figure, you remove the whole batch and enter it again.

  1. Find the batch in the opening-balances list. Batches you’ve already reversed appear greyed out.
  2. Choose delete on the entry. IQ Books doesn’t wipe it — it posts an equal-and-opposite journal to cancel it out and marks the original as reversed. Both stay on the record as an honest audit trail.
  3. Re-enter the batch correctly. With the wrong one reversed, enter a fresh batch on the right date or in the right organisation.

A couple of things worth knowing:

  • Only a live opening-balance batch can be removed. Try to delete one that’s already been reversed and IQ Books tells you it’s already reversed.
  • A migration usually locks the books up to the opening-balance date. If that lock sits exactly on the batch you’re removing, deleting it also lifts the lock automatically — the balances and the lock arrived together, so they leave together.

Letting IQ Books Migrate Your Books Automatically

If your old records live in Xero, QuickBooks or Sage, you don’t have to key the opening balances by hand. The migration wizard reads the closing position from the source and builds the opening balances for you — along with your customers, suppliers, real bank accounts and, crucially, the individual outstanding invoices and bills. Your old books are left completely untouched.

  1. Open the migration wizard. From Settings → Organisation choose ‘Move my books’ (it’s also offered on the dashboard), then connect the source platform.
  2. Pick the source company and a start date. The wizard suggests your current financial-year start. Your opening balances are dated the day before that start date.
  3. Review the preview. It shows how many trial-balance lines, customers, suppliers and invoices will come across, whether the trial balance balances, and whether the amounts owed to and by you tie back to the outstanding documents.
  4. Start the migration and wait. It runs in the background. When it finishes, the organisation has its opening balances, brought-forward invoices and bills, real bank accounts, and a locked period covering everything before the cutover.

Two details to keep in mind. Accounts are matched by name, not code, so tidy account names in the source pay off. Customers and suppliers come over too, on every plan including the free one. If you ever need to undo it, reverse the migration opening-balance batch from the Opening balances screen exactly as described above.

Common Questions About Opening Balances

  • Do I need opening balances if I’m a brand-new business starting on IQ Books? No. If day one of the business is day one on IQ Books, there’s nothing to carry in — just start invoicing and recording bank transactions.
  • Will my aged debtors and creditors show each customer and supplier? Not from a hand-entered opening balance. A single figure on the debtors or creditors control account has no individual invoices behind it, so it shows as an unallocated lump and you can’t match incoming receipts against it. If you need working aged reports and the ability to allocate payments, either use the automatic migration (which rebuilds each outstanding invoice and bill) or raise the individual open invoices and bills dated before cutover — and then leave the debtors and creditors lines out of your opening balance so you don’t count them twice.
  • How do I bring in opening stock? Enter the value of stock on hand as a debit to your stock account within the opening-balance batch (balanced by capital or retained earnings). Bear in mind IQ Books values stock at weighted-average cost, not FIFO.
  • Can I post opening balances if I’ve already locked the period at the cutover date? Yes. Entering opening balances is deliberately allowed to post on or before a locked date, so a migration lock never stands in the way of getting your starting position in.

IQ Books by ReconcileIQ

Your books, kept by themselves.

IQ Books is the AI-native UK ledger that does the bookkeeping for you. Bank transactions arrive coded, receipts and bills file themselves from a photo or an email, and the books are reconciled to the statement. RiQ does it, you sign it off. The ledger is free.