Example of the Reconciliation of Control Accounts with Ledger Balances

Reconciliation of Control Accounts with ledger balances is a vital process to ensure that the general ledger reflects accurate financial information. It involves comparing the balances in the control accounts (such as the Sales Ledger Control Account and Purchase Ledger Control Account) with the total of individual balances in subsidiary ledgers (such as the Sales Ledger and Purchase Ledger). Below is a step-by-step example illustrating this reconciliation process.

1. Scenario: XYZ Company’s Sales Ledger Control Account

XYZ Company maintains a Sales Ledger Control Account to summarize the balances of all its credit customers. At the end of January, the company needs to reconcile this control account with the individual balances in the Sales Ledger (subsidiary ledger).

Sales Ledger Control Account (General Ledger):

  • Opening Balance (Jan 1): $10,000 Dr.
  • Credit Sales (Jan 5): $15,000 Dr.
  • Cash Received (Jan 10): $8,000 Cr.
  • Sales Returns (Jan 15): $2,000 Cr.
  • Discounts Allowed (Jan 20): $500 Cr.
  • Bad Debts Written Off (Jan 25): $1,000 Cr.

Balance per Sales Ledger Control Account (Jan 31): $13,500 Dr.

Sales Ledger (Subsidiary Ledger) Balances:

  • Customer A: $5,000 Dr.
  • Customer B: $4,000 Dr.
  • Customer C: $6,000 Dr.

Total of Individual Debtor Balances: $15,000 Dr.

2. Identifying the Discrepancy

When comparing the balance in the Sales Ledger Control Account ($13,500 Dr.) with the total of the individual debtor balances in the Sales Ledger ($15,000 Dr.), there is a discrepancy of $1,500.

Discrepancy:

  • Sales Ledger Control Account: $13,500 Dr.
  • Total of Sales Ledger Balances: $15,000 Dr.
  • Difference: $1,500 Dr.

3. Investigating the Discrepancy

Upon investigation, the following issues were identified:

  • Omission: A payment of $1,000 received from Customer C was recorded in the subsidiary ledger but not posted to the control account.
  • Duplicate Entry: A $500 discount allowed to Customer B was recorded twice in the control account.

4. Correcting the Errors

To reconcile the control account with the subsidiary ledger, the following adjustments need to be made:

A. Correcting the Omitted Payment from Customer C

Date Particulars Debit (Dr.) Credit (Cr.) Narration
Jan 31 Cash A/c
Sales Ledger Control A/c
$1,000 $1,000 Being correction of payment from Customer C not recorded in the control account.

B. Correcting the Duplicate Discount Entry for Customer B

Date Particulars Debit (Dr.) Credit (Cr.) Narration
Jan 31 Sales Ledger Control A/c
Discount Allowed A/c
$500 $500 Being correction of duplicate discount entry for Customer B.

5. Rechecking the Reconciliation

After making the adjustments, the revised balance in the Sales Ledger Control Account is:

  • Original Balance: $13,500 Dr.
  • Add: Payment from Customer C: $1,000 Dr.
  • Add: Correction of Duplicate Discount: $500 Dr.

Revised Sales Ledger Control Account Balance: $15,000 Dr.

This matches the total of the individual balances in the Sales Ledger, completing the reconciliation process.

6. Importance of Reconciliation

This example demonstrates how discrepancies between control accounts and subsidiary ledgers can arise due to omissions, duplications, or errors. Regular reconciliation ensures that financial records are accurate and reliable, supporting sound financial management and decision-making. It also strengthens internal controls, prevents fraud, and facilitates efficient audits.

Scroll to Top