Payables account reconciliation

This chapter explains what the payables ledger is used for, why you reconcile it to supplier statements, what typically causes differences, and how to prepare (and correct) a reconciliation. You’ll learn how to spot timing differences, omissions, and errors so liabilities are reported accurately.

Learning objectives

By the end of this chapter, you should be able to:

• Explain the purpose of the payables general ledger account and how it relates to double-entry bookkeeping.
• Explain the purpose of reconciling the payables general ledger account to external documents.
• Prepare a reconciliation of the payables general ledger account to supplier statements.
• Identify and correct errors that would be highlighted by performing a reconciliation of the payables general ledger account.

Introduction

Businesses often buy goods and services on credit. When that happens, amounts owed to suppliers build up in the payables ledger.

At month-end, suppliers usually send a statement showing:

• the opening balance
• invoices issued
• payments received
• credit notes issued
• the closing balance

Just like a bank reconciliation compares your cash book to the bank statement, a payables reconciliation compares your payables ledger balance to the supplier’s statement. In an ideal situation, the closing balances match. When they don’t, the difference is usually explained by timing, missing entries, or errors.

Causes of payables differences

Below are some of the reasons why the account payables ledger may not agree with the supplier statements.

• Timing differences resulting from goods or payments in transit
  • Goods in transit: Goods shipped by the supplier, usually, near month-end, may be recorded on the supplier’s statement but not yet received or recorded by the buyer. This creates a temporary difference between the supplier’s statement and the payables ledger balance until the goods arrive and are processed.
  • Payments in transit: Payments to the supplier, usually, near month-end, may be recorded in the payables ledger (reducing the balance) but not yet received or processed by the supplier. The payables ledger balance will show a lower balance while the supplier’s statement still reflects the higher unpaid amount until the payment clears.
• Credit notes not yet processed: The business may have returned goods or identified pricing errors and therefore recorded a debit in the trade payables ledger account to reduce amounts owed. However, if the supplier hasn’t yet processed these returns or agreed to the adjustments, their statement won’t reflect the reduction. The supplier statement will show a higher balance than the payables ledger account.
• Recording errors and disputes: Either party may have made posting errors, duplicate entries, or recorded incorrect amounts. Disputes over quantities delivered, pricing agreements, or quality issues can also lead to different recorded balances while the issue is being resolved.

Why the need for payables ledger reconciliation?

Reconciling accounts payable to external documents (supplier statements, invoices, delivery notes) helps ensure the accuracy and completeness of recorded liabilities.

A reconciliation helps you identify:

• omitted invoices
• understated or overstated invoices
• duplicate entries
• pricing errors
• timing differences

It also helps prevent overpayment, detect fraud, maintain good supplier relationships, and ensure the financial statements reflect the actual amounts owed.

Preparation of the accounts payable reconciliation

The following are steps you can follow to prepare the accounts payable reconciliation.

1. Trace or match each item on the trade payables ledger account to the supplier’s statement and mark them.
2. Post the unmarked terms on the supplier’s statement to the trade payable ledger account.
3. Correct errors made in the payables ledger account.

Illustration: Payables ledger reconciliation

Kaufmano Trading Company maintains a trade payable ledger for all suppliers. The following ledger shows the activities with Reliable Suppliers Ltd for December 2024.

The statement received from the supplier shows that Kaufmano Trading Company owes $13,050. Additional Information:

1. Goods worth $1,500 were delivered on 31 December, but the invoice was not received until 3 January 2025.
2. A payment of $500 was made on 30 December but was not processed by the supplier until 2 January 2025.
3. A debit note for $150 relating to damaged goods returned in December has not yet been received by the supplier.
4. There appears to be an invoice for $1,000 worth of goods that the supplier delivered, but Kaufmano Trading Company has not recorded the invoice amount. Required: Prepare a reconciliation statement showing how the accounts payable ledger balance of $11,200 reconciles to the supplier statement balance of $13,050.

Suggested Solution

5. Identify items that were not recorded in the accounts payable and their effect on the ledger account.

Do you know the items?

3. Identify items that were recorded in the accounts payable but not in the supplier statements and their effect on the ledger account.

Do you know the items?

3. Prepare a reconciliation statement showing how the accounts payable ledger balance of $11,200 reconciles to the supplier statement balance of $13,050.

4. Prepare a reconciliation statement showing how the supplier statement balance of $13,050 reconciles to the accounts payable ledger balance of $11,200.