3.2 Reconciling Supplier Statements with the Payables Ledger
Key Takeaways
- A supplier statement is an external document sent by a trade creditor detailing invoices, credit notes, payments received, and the closing balance owed from the supplier's perspective (a debit asset).
- Discrepancies arise from four primary sources: timing differences, internal bookkeeping errors, supplier errors, and disputed transactions.
- Timing differences (payments in transit, invoices in transit, credit notes in transit) require adjustments on the reconciliation statement, not entries in the internal ledger.
- Internal errors (omitted invoices, duplicate postings, transposition errors) must be corrected immediately in the purchases daybook and supplier personal accounts.
- Reconciliation statements systematically adjust the supplier statement balance to arrive at the verified payables ledger balance, providing critical internal control before authorizing cash disbursements.
Last updated: September 2026
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:
\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)}$$ ```text 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: ```text 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.Loading diagram...
Test Your Knowledge
Why does a supplier statement typically show a debit balance while the corresponding account in the customer's payables ledger shows a credit balance?
A
B
C
D
Test Your Knowledge
A business receives a supplier statement showing a balance owed of £8,950. The payables ledger account for this supplier shows £7,200. It is discovered that a payment of £1,750 was posted in the cash book and payables ledger on 29 September, but has not yet cleared the supplier's bank account. What action is required in the business's payables ledger?
A
B
C
D
Test Your Knowledge
Which of the following items requires an adjusting entry in the buyer's payables ledger rather than being treated purely as an item on the reconciliation statement?
A
B
C
D
Test Your Knowledge
When preparing a supplier statement reconciliation starting from the supplier statement balance, how should a payment in transit (sent by the buyer but not yet credited by the supplier) and a disputed overcharge (where the supplier billed £100 more than the agreed contract price) be treated?
A
B
C
D