Built from inside practice. Built by Mr H Hammad FCCA, ACA, ICAEW Chartered Accountant with over 20 years in practice.
ProductFor ClientsClient PortalResourcesWhy BalansixPricingAcademySupportFree practice guideBook a demoLogin
BalansixAcademy

Plan a controlled migration and prove opening balances

Practise mapping an opening trial balance, supporting customer and supplier amounts and agreeing a Balansix migration boundary.

Intermediate23 minute lessonMigration & opening balances

What you will learn

A successful migration defines where the old records stop and Balansix begins. Practise proving an opening trial balance, its customer and supplier details, and the first bank reconciliation before routine work continues.

By the end, you can

  • Distinguish prior-year comparatives, opening balances and a mid-year conversion.
  • Reconcile control totals to supporting details.
  • Prevent overlap between migrated balances and new transactions.
  • Prepare an evidenced migration sign-off.

Before you begin

  • Use the fictional opening trial balance below.
  • Understand customer, supplier and bank control balances.
  • For an actual migration, agree the dates, source trial balance, owner and reviewer.
Use the example, then apply the method. The people, businesses and figures in this lesson are fictional. Work through the activity on paper before applying the method to authorised client work.

1. Agree the migration boundary

Write down the client, selected accounting period, source balance date and first transaction date to process in Balansix. State whether the file contains a prior-year trial balance, balances at the beginning of the period or a mid-year conversion.

Balansix uses the source balance date and accounting period to establish the import's purpose. A prior-year trial balance can support comparatives as well as brought-forward balances. A start-of-period import serves a different purpose from a conversion partway through the year.

Review the displayed treatment before continuing. Follow migration help and opening balances help for the import steps.

2. Prove a small opening trial balance

Fictional Elm Workshop starts its new accounting period with the following approved balances. This exercise uses a balance-sheet opening position, without a separate comparative profit and loss.

Elm Workshop opening trial balance
AccountDebitCredit
Bank£6,000—
Customer balances£4,000—
Equipment cost£9,000—
Accumulated depreciation—£3,000
Supplier balances—£2,000
Loan—£5,000
Equity—£9,000
Total£19,000£19,000

Map by the meaning of each source account, not merely by a similar code. Preserve cost and accumulated depreciation as separate balances. Retain the approved source file used for the comparison.

Try this. Prove that the opening trial balance balances. Follow the later customer receipt and explain why it must not create a second sale.

3. Prove the detail behind the controls

The £4,000 customer control consists of Alder £2,500 and Birch £1,500. The £2,000 supplier control consists of Coast Supplies £1,200 and Dale Tools £800. These schedules must agree with their control totals.

Retain counterparty names, original references, dates and outstanding amounts so later payments can clear the correct opening items. Check that the bank balance is associated with the correct business account. Retain the asset register and lender evidence for the other balances.

A trial balance can balance while its customer schedule is incomplete. Check both the ledger equation and the supporting detail before approval.

4. Keep migrated balances and new activity distinct

The £6,000 bank amount is the opening position. It is not a fresh receipt. The £4,000 customer balance is already represented in the opening records. Re-entering those old unpaid invoices as new sales would duplicate the underlying amount.

For a mid-year conversion, identify which current-year transactions are already included in the imported balances. Agree how the remaining detail and reporting requirements will be handled before importing additional activity.

Document the boundary with a concrete statement, such as “Opening position at the start of 1 January; bank activity processed from 1 January onwards.” Use dates appropriate to the approved source. Avoid overlapping imports whose coverage nobody can explain.

5. Test the first real workflow

In the exercise, Alder pays its full £2,500 after migration. Match the receipt against Alder's opening amount using the opening-balance settlement workflow. The remaining customer control is £1,500, belonging to Birch. The bank becomes £8,500 if there are no other movements.

This proves more than a balanced import: the new workflow can use the detail that was brought across. Follow clearing an opening customer balance when processing the settlement.

Perform an equivalent review for a supplier payment. Confirm that the payment clears the opening liability rather than recording a second purchase.

Model answer and migration sign-off

Model answer: the opening trial balance totals £19,000 on each side. Customer detail totals £4,000 and supplier detail totals £2,000. After Alder's £2,500 payment, customer balances total £1,500 and bank is £8,500.

Keep a sign-off pack containing the approved source trial balance, mapping, support schedules, date boundary, review outcome and first reconciliation. Record who resolved any differences and which source was authoritative.

Approval and posting should be completed by the authorised reviewer through the opening-balance workflow. Routine bookkeeping can then proceed from a starting position that the team can explain and reproduce.

Check your understanding

Alder pays £2,500 of the £4,000 opening customer balance. What remains if nothing else changes?

Read the answer and explanation

£1,500 customers and bank increases by £2,500.

The receipt clears Alder’s opening amount. Birch’s £1,500 remains outstanding, and the receipt increases bank.

Continue learning