Transfer opening balances and reconcile control accounts
Import acquisition-date or cutover balances and reconcile the general ledger to receivable, payable and inventory detail.
Section 3.4 · Computerised accounting systems
Exam scope and assessment notes
Cambridge International AS & A Level Accounting 9706, 2026–2028 syllabus, Version 2. These lessons cover the process of transferring business accounts to a computerised accounting system and ways to maintain data integrity during conversion. No specific accounting application is required. Practice is self-checked, not an official Cambridge grade. Full timed Papers 1–4 and human subject-teacher review remain outstanding.
Before you begin
- Use the Topic 1.2 accounting-system skills: understand double entry, trial balances, control accounts, source documents and why complete records matter.
Work on paper. Try each question before revealing help, and explain why your method works.
Quick readiness check
A trial balance has debits $510,000 and credits $510,000. What does that prove?
What you will learn
- Prepare opening balances from an approved closing trial balance
- Reconcile subledgers and control accounts
- Investigate imbalance rather than using an unexplained suspense entry
Use one approved source balance at the cutover date
Opening balances should come from an approved closing trial balance and related schedules at the agreed date. Confirm the accounting period, currency, debit/credit signs and whether adjustments such as accruals, depreciation or inventory counts have been posted before extraction.
Import the general ledger totals and supporting customer, supplier and inventory details as specified. If the system keeps subledgers, the total of detailed records should agree with each corresponding control account. Reconcile bank, receivables, payables, inventory, fixed assets, loans, tax and equity to their source schedules.
Use differences as investigation signals
A trial balance must have equal debits and credits, but that alone does not prove every balance is in the correct account. Reconcile both total balances and supporting detail, and investigate missing, duplicated, reversed or misclassified values.
Do not enter an unexplained figure into suspense just to force the import to balance. A temporary control account is only appropriate when the organisation's approved process allows it, the amount is investigated, and the item is cleared promptly with evidence and review.
Pause and explain
The supplier subledger is $1,800 higher than payables control. What is the best first response?
Worked example
The source trial balance shows receivables control $72,400 debit. The imported customer balances total $69,900. Calculate the difference and give three checks before approval.
Show the worked solution
- Difference = $72,400 − $69,900 = $2,500 missing from the imported detail relative to control.
- Check for omitted or duplicate customers, opening balances with wrong signs, and cutover receipts or credit notes posted to only one system.
- Trace the $2,500 difference to source records, correct it with approval and rerun the reconciliation.
Answer The detail is $2,500 below the control account. Investigate the source customer list, signs and cutover transactions before approving the opening balances.
Try a topic test
Choose Easy, Normal or Difficult. Save your answers and open worked review after finishing.
Test this topic →From guided practice to a new situation
Write your answer and reasoning first. Use a hint only if you are stuck. The model solution is for self-checking; your written work is not automatically marked.
Opening inventory control is $64,500. Imported item records total $63,200. A late count adjustment of $1,300 is in the old system but not the export. Reconcile the balances and state a controlled correction.
Give me a hint
Add the omitted adjustment to the detailed amount, then compare it to control.
Compare my reasoning
- Imported detail $63,200 + omitted count adjustment $1,300 = $64,500.
- The difference is explained by the late adjustment rather than an unexplained plug.
- Post the approved adjustment once in the new system or rerun the export, retain evidence and rerun the inventory-control reconciliation.
The balances reconcile after the $1,300 count adjustment. Record it once with approval and evidence, then repeat the reconciliation.
Look for these in your work
- Imported detail $63,200 + omitted count adjustment $1,300 = $64,500.
- The difference is explained by the late adjustment rather than an unexplained plug.
- Post the approved adjustment once in the new system or rerun the export, retain evidence and rerun the inventory-control reconciliation.
Opening trial balance totals are debits $840,000 and credits $834,500. Calculate the imbalance and name three likely conversion checks.
Give me a hint
Compare debit and credit totals and trace the difference through the import.
Compare my reasoning
- Imbalance = $840,000 − $834,500 = $5,500 debit excess.
- Check omitted credit balances, debit/credit sign reversal and whether an account was mapped to an incorrect side or excluded.
- Compare the source trial balance, mapping table and import log; post a correction only when supported.
There is a $5,500 debit excess. Check omitted credits, sign reversals and mapping/import exclusions against the source, then correct with evidence.
Look for these in your work
- Imbalance = $840,000 − $834,500 = $5,500 debit excess.
- Check omitted credit balances, debit/credit sign reversal and whether an account was mapped to an incorrect side or excluded.
- Compare the source trial balance, mapping table and import log; post a correction only when supported.
A financial controller proposes using suspense for a $9,000 mismatch between inventory detail and the control account and resolving it next quarter. Explain why approval should wait.
Give me a hint
The mismatch affects a material supporting balance and can hide omitted or duplicated inventory.
Compare my reasoning
- The difference means the detailed stock records do not support the ledger balance at cutover.
- It could affect stock valuation, cost of sales, fulfilment and later profit; a suspense entry does not identify the cause.
- Investigate records and adjustments, correct or document the approved treatment and obtain reconciliation sign-off before relying on the new opening balances.
Do not approve an unexplained material difference. Resolve its source or apply a formally controlled exception before relying on the inventory records.
Look for these in your work
- The difference means the detailed stock records do not support the ledger balance at cutover.
- It could affect stock valuation, cost of sales, fulfilment and later profit; a suspense entry does not identify the cause.
- Investigate records and adjustments, correct or document the approved treatment and obtain reconciliation sign-off before relying on the new opening balances.
Common mistakes
- Treating an equal trial balance as proof that subledgers agree
- Plugging a reconciliation difference into suspense without investigating
- Importing control totals and detailed balances from different dates
What can you explain now?
What should receivables detail agree with after import?
Compare with the explanation
The general-ledger receivables control account at the same cutover date
Matching dates and balances let the team detect omitted, duplicated or misclassified customer items.
After trying it yourself, choose your next review. This is your self-assessment.
Your review choice appears on Today. Sign in to sync it across devices.
Make it stick
Which three balances should be reconciled to their supporting detail during an opening-balance transfer?
If you needed the solution, close it and solve the problem again from a blank page. A correct answer is stronger when you can explain the reason for each step.