3.2 Reconciling Supplier Statements with the Payables Ledger

3.2 Reconciling Supplier Statements with the Payables Ledger

The Purpose of Supplier Statements

A supplier statement (or statement of account) is an external commercial document sent periodically (typically at the end of each month) by a supplier to its credit customers. The statement provides an itemised summary of all transactions that have passed through the supplier's receivables ledger account for that customer during the billing period, including:

• Opening balance brought forward from the preceding month.
• Sales invoices issued for goods or services supplied.
• Credit notes issued for returned items, volume allowances, or price adjustments.
• Payments received and credited to the account.
• Closing balance outstanding as of the statement date.

Opposing Accounting Perspectives

To reconcile supplier statements accurately, bookkeepers must understand that the supplier and the customer view the exact same commercial debt from opposite perspectives:

$$\begin{array}{c|c} \textbf{Supplier's System (Receivables Ledger)} & \textbf{Customer's System (Payables Ledger)} \\ \hline \text{Customer is a Trade Receivable (Asset)} & \text{Supplier is a Trade Payable (Liability)} \\ \textbf{Normal Balance: DEBIT} & \textbf{Normal Balance: CREDIT} \\ \text{Invoices are debited} & \text{Invoices are credited} \\ \text{Payments/Credit Notes are credited} & \text{Payments/Credit Notes are debited} \end{array}$$

Consequently, when a supplier statement shows a closing debit balance of £6,000, our internal payables ledger account for that supplier should normally show a corresponding closing credit balance of £6,000.

---

Why Balances Rarely Match: The Four Causes of Difference

In day-to-day business, the closing balance on a supplier's statement almost never equals the balance in the customer's payables ledger account. Discrepancies fall into four distinct categories:

1. Timing Differences

Timing differences occur when a genuine, valid transaction has been processed by one business, but the documentation or funds have not yet cleared or been recorded by the other party due to standard postal, transit, or banking clearing cycles:

• Payments in Transit: The customer sends a cheque or initiates an electronic bank transfer (BACS or Faster Payments) near month-end. The customer credits the Cash Book and debits the supplier's personal account immediately. However, the supplier's statement was generated before the funds arrived or cleared, so the payment is missing from the statement.
• Invoices in Transit: The supplier generates and posts an invoice on the 29th or 30th of the month, debiting the customer's account. The customer does not receive the physical goods or invoice until the 2nd or 3rd of the following month, meaning the invoice is omitted from the customer's current period purchases daybook.
• Credit Notes in Transit: Goods were returned to the supplier near month-end along with a debit note. The supplier has not yet inspected the items or generated the formal credit note, so the credit does not appear on their monthly statement.

2. Internal Bookkeeping Errors (Customer Errors)

Mistakes made by our own bookkeeping staff when processing transactions:

• Omitted Invoices/Credit Notes: A valid purchase invoice was misplaced or left unrecorded in the Purchases Daybook and payables ledger.
• Duplicate Entries: Entering the same purchase invoice twice into the system.
• Transposition Errors: Entering figures incorrectly (e.g. posting an invoice of £482 as £428).
• Posting to the Wrong Account: Entering an invoice into Supplier A's personal account instead of Supplier B's personal account (error of commission).

3. Supplier Errors

Mistakes made by the supplier's accounting department:

• Inaccurate unit pricing or incorrect trade discounts applied to invoices.
• Mathematical casting errors or incorrect VAT calculations.
• Crediting our payment to a different customer's account.
• Charging for items that were never ordered or delivered.

4. Disputed Transactions

Circumstances where the customer intentionally refuses to record or pay an invoice:

• Goods delivered were damaged, defective, or incorrect specification, and a credit note has been demanded but not yet received.
• Disagreements over carriage, packaging charges, or delivery terms.

---

The Audit and Reconciliation Workflow

Reconciliation is a critical internal control that must be performed before approving supplier payments. The procedure involves five sequential steps:

1. Step 1: Side-by-Side Comparison: Lay the supplier statement beside the individual supplier account in our payables ledger.
2. Step 2: Tick Matching Entries: Compare each item line by line. Tick off invoices, credit notes, and payments that appear on both records with identical values.
3. Step 3: Segregate Unticked Items: Isolate the unticked items into two groups:
   • Items requiring internal ledger adjustments (omitted invoices, duplicate entries, internal transposition errors).
   • Items requiring reconciliation adjustments (payments in transit, supplier errors, disputes, credit notes pending).
4. Step 4: Update Internal Accounts: Post any unrecorded valid invoices or correcting entries into the Purchases Daybook / Cash Book and post them to the supplier's personal account.
5. Step 5: Prepare Reconciliation Statement: Draft a formal Supplier Statement Reconciliation Statement starting from the supplier statement balance, adjusting for transit and dispute items, and arriving at the updated payables ledger balance.

---

Comprehensive Worked Example: Reconciling Northgate Supplies

Background Data

On 31 July 2026, the payables ledger account for Northgate Supplies in the books of Apex Retailers shows a credit balance of £4,350.

The monthly supplier statement received from Northgate Supplies dated 31 July 2026 shows a closing balance of £6,810 (Dr).

$$\text{Unreconciled Difference} = \pounds6,810 - \pounds4,350 = \mathbf{\pounds2,460}$$

Audit Discoveries

A line-by-line comparison uncovers the following discrepancies:

1. Payment in Transit: A BACS payment of £1,800 sent by Apex Retailers on 30 July was recorded in the Cash Book and debited to Northgate's ledger account. The payment did not reach Northgate's bank account before their statement was produced on 31 July.
2. Unrecorded Purchase Invoice: An invoice (#NS-4491) for £540 dated 31 July was received by Apex Retailers on 2 August and has not yet been entered in the Purchases Daybook or payables ledger.
3. Credit Note in Transit / Disputed Return: Damaged goods valued at £210 were returned to Northgate Supplies on 28 July accompanied by debit note #DN-104. Apex Retailers recorded this in the Purchases Returns Daybook and debited Northgate's account. Northgate Supplies had not yet issued their credit note at 31 July, so no credit appears on the statement.
4. Internal Transposition Error: Purchase invoice #NS-4380 for £670 was mistakenly recorded in Apex Retailers' Purchases Daybook and payables ledger as £760 (an overstatement of liability by £90).

Action Plan and Adjustments

Step 1: Correcting Internal Records (Payables Ledger Account)

Before drafting the external reconciliation, Apex Retailers must correct its own internal ledger for genuine transactions and bookkeeping mistakes:

• Initial Payables Ledger Balance: £4,350 (Cr)
• Add unrecorded invoice (#NS-4491): +£540 (Credit supplier)
• Deduct overstatement on invoice #NS-4380 (£760 - £670): −£90 (Debit supplier)

$$\text{Corrected Payables Ledger Balance} = \pounds4,350 + \pounds540 - \pounds90 = \mathbf{\pounds4,800} \text{ (Cr)}$$

                  Payables Ledger Account: Northgate Supplies
-------------------------------------------------------------------------
Details                     Amount (£) | Details               Amount (£)
-------------------------------------------------------------------------
Correction: Invoice #NS-4380        90 | Balance b/d                4,350
Balance c/d                      4,800 | Unrecorded Inv #NS-4491      540
---------------------------------------|---------------------------------
Total                            4,890 | Total                      4,890
-------------------------------------------------------------------------
                                       | Balance b/d (corrected)    4,800

Step 2: Preparing the Supplier Statement Reconciliation Statement

Now adjust the supplier statement balance for transit items and unacknowledged returns to verify whether it matches the updated payables ledger figure:

              Supplier Statement Reconciliation: Northgate Supplies
                               As at 31 July 2026
-------------------------------------------------------------------------
Balance as per Supplier Statement (Debit):                       £6,810

Less: Payment in transit (BACS sent 30 July)                     -1,800
Less: Goods returned awaiting credit note (Debit Note #DN-104)     -210
                                                                 -------
Agreed Balance as per Adjusted Payables Ledger Account (Credit): £4,800
=========================================================================

The reconciliation is complete and fully agreed at £4,800.

---

Managing Disputed Items and Authorisation Protocols

When a discrepancy is caused by a supplier error (e.g. incorrect prices or missing trade discounts):

1. Issue a Debit Note: A debit note is formally sent to the supplier explaining the reason for the price reduction or goods return.
2. Hold Disputed Invoices: The disputed invoice is flagged in the accounting software so that payment is withheld until a formal Credit Note is issued by the supplier.
3. Do Not Amend Internal Records Prematurely: Until the supplier issues an official credit note agreeing to the price reduction, the original invoice stands as a legal document. The dispute is maintained as a reconciling item on the supplier statement reconciliation.