In this guide 6 sections
Close the old books at a cutover date, take a trial balance and load receivables and payables by party, stock by item and location, bank balances and fixed assets. Tie every sub ledger to its control account. Post gaps to a named suspense account.
Choose the cutover date and close the old books
Most businesses cut over at the start of a month or a financial year, and a year start is cleanest because income and expense accounts open at zero. Only balance sheet accounts carry across.
Close the old books to that date by posting depreciation, accruals and bank charges, then take the trial balance and save it as both a PDF and a spreadsheet. Every load ties back to it.
If the accountant will still adjust the old year, say so, because those late audit journals must be copied across by hand and each one gets logged. Record each late journal in a log with its date, amount and approver, so the opening figures can be restated without guessing which entries were already loaded.
- Final trial balance at cutover date
- Bank statements to the same date
- Aged receivables and payables reports
- Stock valuation report by item
- Fixed asset register with cost and depreciation
Carry across balances by party, item and location
Never load one figure for debtors. Load each unpaid invoice with its number, date and due date under the customer, and do the same for supplier bills, because ageing only works if invoice dates survive.
Stock goes in by item, quantity and location with a unit cost, since a bare total cannot answer the next stock count. Fixed assets arrive one row per asset with cost, accumulated depreciation, useful life and purchase date, so the depreciation run continues from the right figure.
Bank accounts carry the reconciled balance, plus a list of uncleared cheques and deposits in transit, each with its date and reference, and the closing statement stays beside it.
- Receivables: customer, invoice number, date, amount outstanding
- Payables: supplier, bill number, date, amount outstanding
- Stock: item code, location, quantity, unit cost
- Bank: reconciled balance and uncleared items
- Fixed assets: cost, accumulated depreciation, life
Tie each load to the trial balance
Add up each sub ledger and compare it with its control account, because debtors must equal the open invoices and stock must equal quantity times cost for every line. Any difference needs a reason. Write each reason beside the difference.
After loading, run the new trial balance and compare it with the old one account by account in a sheet whose difference column ends at zero.
Never force a match. A forced figure returns months later as a mystery that nobody can trace back to a voucher, and the auditor will ask about it.
Handle gaps between the trial balance and sub ledgers
Gaps are common here. Old journals posted straight to the debtors control account leave the ledger higher than the invoice list, and stock adjustments made without item detail do the same to inventory.
In QuickBooks or Xero the opening balance usually goes in as a journal dated the day before your start date, while party balances come in as opening invoices. Gaps go to a named suspense account. Never bury one in retained earnings.
Then give the suspense balance an owner and a deadline, and review the list every week until each item is traced to a source document and cleared. Aim for two months.
- Control account minus sub ledger total
- Suspense account used, never hidden
- Owner and clear by date for each item
- Accountant approves the final treatment
Verify, archive and close the loop
Print the first month’s aged receivables from the new system and compare them line by line with the old report, then send two or three statements to friendly customers. Their answer is real evidence.
Keep the old books read-only for as long as your accountant advises, since older detail can live in archived reports and history need not be loaded at all. That keeps the first import small. Store the exports of the old receivables, payables and stock reports in the same folder, so any question about the first month can be answered from documents.
Sign the opening balance workbook with the date and your initials, then file it beside the trial balance PDF, so both travel together at audit time. Ask the accountant to review the workbook before sign-off, because a second reader catches transposed digits in unit costs and invoice numbers that a total will hide.
Opening balance tie out sheet
A spreadsheet with one row per account. Columns cover account, old trial balance, sub ledger total, loaded balance, new trial balance, difference, suspense item, owner and cleared date, with a sign-off line. A second tab lists every open item.
Open a blank worksheet to printQuestions owners ask
Do we need to load all past transactions?
Usually not, because you load opening balances and open items and keep older years as archived reports, though your accountant should confirm the retention rules that apply to you.
What if the trial balance and sub ledgers disagree?
Post the gap to a named suspense account, give it an owner and clear it from source documents, because a hidden gap grows and returns as an audit query. Never edit figures to hide it.
Which date should we choose?
Choose a month end or year end, once the old books are closed and bank accounts reconciled, and prefer a year start because income and expense accounts open clean.
Can the opening balance be changed later?
Yes, through a dated correcting journal. Approve and note any change, so an auditor can follow the trail from the old books to the corrected figure without asking you for explanations.