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.
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.
| Account | Debit | Credit |
|---|---|---|
| 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
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.
Optional: selecting this button saves only this lesson’s completion on this browser. It does not create a Balansix training record or certificate, and it will not follow you to another device.