Creditors Reconciliation Study Guide
Fundamentals of Creditors Reconciliation
Creditors reconciliation is an essential internal control procedure within an accounting department. It involves the systematic comparison of different sets of financial information to identify discrepancies, investigate causes, and rectify errors. This process ensures the accuracy of the financial records and monitors the business's obligations to its suppliers.
Prerequisites for Mastering Creditors Reconciliation:
- Cash Receipts Journal (CRJ) and Cash Payments Journal (CPJ).
- Creditors Journal (CJ) and Creditors Allowances Journal (CAJ).
- Knowledge of the Creditors Control Account in the General Ledger.
- Understanding the Creditors Ledger and the subsequent Creditors List.
- Comparison techniques for matching the Creditors Control Account with the Creditors List.
- Knowledge of internal control measures specifically for creditors' accounts.
Primary Objectives of the Reconciliation Process:
- Strengthening internal control to mitigate the risk of fraud and reduce clerical errors.
- Comparing internal records (the Creditors Ledger) with external documentation provided by suppliers (the Monthly Creditors Statement).
- Detecting omissions or mistakes made by either the creditor or the business itself.
Core Accounting Concepts and Documents
- Creditors Reconciliation Statement: An internal document prepared to reconcile the differences between the balance of a creditor's account in the local ledger and the balance shown on the statement received from that creditor.
- Creditors Ledger: The proprietary internal record of a business that tracks all transactions with a specific creditor from the business's perspective.
- Creditors List: A list of all individual creditors' balances at the end of a period, the total of which must equal the balance of the Creditors Control Account.
- Creditors Monthly Statement: An external record sent by the creditor to the business. It serves as a copy of the business’s account as it appears in the creditor's books.
- Invoice: A document indicating a purchase on credit, increasing the amount owed.
- Debit Note: A document issued by the business to the creditor, typically when returning goods, to indicate the business is debiting the creditor's account (decreasing the liability).
- Credit Note: A document received from a creditor acknowledging goods returned or overcharges, which reduces the business's debt.
- Interest on Overdue Account: A charge added to the account balance when payments are not made within the agreed timeframe.
- Discount Received: A reduction in the amount owed to a creditor, usually for early payment.
- Electronic Funds Transfer (EFT): The modern standard for payments, replacing traditional checks.
Reconciliation Methodologies
There are two distinct levels of reconciliation performed regarding creditors:
Internal vs. External Records:
- This involves comparing the Creditors Ledger (internal) against the Creditors Statement (external).
- This identifies timing differences, errors in recording, or omissions by either party.
Internal vs. Internal Records:
- The end balance of the Creditors Control Account in the General Ledger is compared to the total of the Creditors List at the end of the month.
- This ensures that the posting from journals to both the control account and the individual ledger accounts has been executed correctly.
- This control method ensures the final balance displayed in the financial statements is accurate.
Procedural Steps for Effective Reconciliation
Step 1: Opening Balance Verification
- Compare the beginning balance on the Creditors Statement with the beginning balance in the Creditors Ledger.
Step 2: Comparing Increases (Purchases)
- Compare the Credit column (+) in the Creditors Ledger with the Debit column (+) on the Creditors Statement. Specifically, match Invoices received against Invoices listed on the statement.
Step 3: Comparing Decreases (Payments and Returns)
- Compare the Debit column (-) in the Creditors Ledger with the Credit column (-) on the Creditors Statement.
- Debit Notes (internal) should match Credit Notes (external).
- EFT payments (internal) should match Receipts (external).
- Discount Received (internal) should match Discount Allowed (external).
Step 4: Identifying Omissions
- Look for unique items on the statement not in the ledger (e.g., interest charges) and circle amounts that do not appear in both records.
Step 5: Correcting Internal Records
- If errors or omissions are found in the Creditors Ledger, the business must record adjustments in the appropriate journals and post them to the ledger.
Step 6: Preparing the Reconciliation Statement
- If errors exist on the creditor's statement, notify the creditor to correct them in the following month. In the interim, record these adjustments on a Creditors Reconciliation Statement to explain the discrepancy between balances.
Exemplar: Zipro Winkels and Lucinda Vervaardigers
In this scenario, Zipro Winkels is the business and Lucinda Vervaardigers is the creditor.
Internal Record (Creditors Ledger of Zipro):
- Jan 1 Balance:
- Jan 5 Invoice 154 (CJ): (New Balance: )
- Jan 7 Debit Note 84 (CAJ): (New Balance: )
- Jan 15 EFT (CPJ): (New Balance: )
- Jan 28 Journal Voucher 585 (Interest): (New Balance: )
- Jan 31 Invoice 289 (CJ): (Final Balance: )
External Record (Statement from Lucinda Vervaardigers as of 25 Jan 2021):
- Jan 1 Balance:
- Jan 5 Invoice 154 (DJ): (New Balance: )
- Jan 7 Credit Note 41 (DAJ): Correctly should be a credit, but erroneously listed as a Debit (+): (New Balance: )
- Jan 15 Receipt 742 (CRJ): (New Balance: )
- Jan 25 Journal Voucher (AJ): (Balance on Statement: )
Reconciliation Adjustments:
- The business (Zipro) ledger is correct.
- Invoice 289 () is missing from the statement because the creditor closed their books on the 25th.
- Credit Note 41 was incorrectly debited by the creditor. This requires a "double correction" on the recon statement: one to cancel the incorrect addition of and one to correctly subtract the , totaling a subtraction of .
Creditors Reconciliation Statement (31 January 2021):
- Balance per Creditors Statement:
- Add: Invoice 289 (not on statement):
- Less: Credit Note 41 (erroneously recorded):
- Balance per Creditors Ledger:
Comprehensive Activity: Amy Handelaars vs. Khaya Verskaffers
Initial Data:
- Amy Handelaars Ledger Balance (Khaya Verskaffers account):
- Khaya Verskaffers Statement Balance (27 January 2021):
Adjusting Information:
- (a) Invoice 372 is correct in the ledger as . The statement shows . Khaya Verskaffers (the creditor) will correct this. Adjustment on recon: .
- (b) Invoice 376 () on the statement was issued to Amo Winkels, not Amy Handelaars. It must be removed from the statement balance. Adjustment on recon: .
- (c) Khaya Verskaffers omitted a discount of on the 26th. Adjustment on recon: .
- (d) Invoice 395 () was recorded in the ledger for Khaya Verskaffers but belongs to Khagan Verskaffers. This must be removed from the internal ledger balance. Adjustment to Ledger: .
- (e) Invoice 401 () on the statement is for goods ordered by Amy Handelaars but was omitted from their ledger. Adjustment to Ledger: .
- Additional unmatched items in Ledger: Invoice 406 () and EFT payment on the 30th () occurred after the statement date.
Final Reconciliation Balances:
- Adjusted Ledger Balance:
- Adjusted Statement Balance: