An accounts payable reconciliation template ties two things together. First, the vendor aging report must equal the accounts payable balance in the general ledger. Second, the balance you show for each important vendor must agree with that vendor's own statement, or the gap must be explained line by line with a reason and an owner.
Accounts payable subledger to general ledger: the first tie-out
The first tie-out proves that the accounts payable subledger, the list of open vendor bills, adds up to the accounts payable balance in the general ledger. If it does not, vendor-level work is wasted, because the totals you compare against are already wrong.
Run the aging report as of the last day of the period. Take its total and compare it with the general ledger balance for accounts payable on the same date. They should be equal. The template needs only a few lines:
| Line | Example amount |
|---|---|
| Accounts payable aging total at period end | 84,615.00 |
| General ledger accounts payable balance | 84,615.00 |
| Difference | 0.00 |
When the difference is not zero, look for the usual causes before anything else:
- Manual journal entries posted straight to the accounts payable account, which hit the ledger but never appear in the subledger.
- A date mismatch. The aging was run as of today, not as of period end, or a bill was back-dated after the report ran.
- Multiple payable accounts. Some systems keep separate accounts for different currencies or bill types, and the aging covers all of them while you compared only one.
- Unapplied payments or credits sitting outside the open-bill list.
For the general method of tying a ledger balance to a subledger, including how to list and age the reconciling items, see tying the general ledger balance to the subledger or source. Fix the tie-out first; vendor statements come second.
Vendor statement reconciliation, line by line
Vendor statement reconciliation compares the balance a supplier says you owe with the balance your own records show for that supplier. A vendor statement is a list the supplier sends, usually monthly, of invoices, payments and credits against your account. You match it to your ledger one line at a time.
Pick the vendors that matter: the largest balances, the most active suppliers, and any vendor whose account has shown problems before. You do not need a statement for every vendor. The steps for each one are:
- Start with the vendor's closing balance and the statement date.
- List each invoice on the statement and find it in your open bills by number.
- List each payment on the statement and find it in your payment records by date and amount.
- List each credit and find the matching credit memo in your books.
- Mark every line that exists on only one side.
- Total the one-sided lines. They should explain the whole difference between the two balances.
Here is a template filled with example figures for a supplier named Example Supply Co.
| Reference | Vendor statement | Our ledger | Difference | Status |
|---|---|---|---|---|
| INV-1041 | 2,400.00 | 2,400.00 | 0.00 | Agreed |
| INV-1052 | 1,875.00 | 1,875.00 | 0.00 | Agreed |
| INV-1060 | 1,310.00 | 1,310.00 | 0.00 | Agreed |
| INV-1067 | 1,235.00 | 0.00 | 1,235.00 | Not received |
| INV-1031 | 1,500.00 | 1,500.00 | 0.00 | Agreed |
| Payment, check 7731 | 0.00 | (1,500.00) | 1,500.00 | Payment in transit |
| CM-204 credit memo | 0.00 | (350.00) | 350.00 | Credit not on statement |
| Total | 8,320.00 | 5,235.00 | 3,085.00 |
The differences listed, 1,235.00 plus 1,500.00 plus 350.00, add to 3,085.00. The remaining unexplained difference is 0.00, and that is the figure that lets you sign the reconciliation. If the explained items had added to less, you would keep looking.
Which accounts payable reconciling items are normal?
Normal accounts payable reconciling items are differences that arise from timing and process, not from error, and they clear on their own once the other side catches up. A reconciling item is a line that makes two balances differ and that you can name and support.
The expected ones are:
- Payments in transit. You sent a check or transfer before the statement date, and the vendor had not applied it by then.
- Invoices in transit. The vendor issued a bill and its statement shows it, but your copy has not yet arrived or been entered.
- Credit memos in transit. You recorded a credit the vendor has not yet issued, or the reverse.
- Cut-off differences. The vendor includes a shipment on the 31st that you recorded on receipt on the 2nd.
- Disputed items. You and the vendor disagree on price, quantity or terms, and the line stays open until resolved.
- Unapplied cash. The vendor received your payment but has not matched it to an invoice.
Each of these clears within a cycle or two. An item that has been open for several months is no longer a timing difference. Age every reconciling item and set a date by which it must clear; anything older goes to a person with the authority to resolve or write it off. Not every difference is worth chasing, and for how to draw that line, see setting materiality thresholds for balance sheet reconciliations.
Differences that are not normal
Some differences should never be filed as routine. A vendor balance that is lower than your own is unusual, because suppliers rarely understate what they are owed. A statement showing a payment you did not make is a possible fraud signal. A debit balance on a vendor, meaning the vendor owes you, needs a refund or a credit application, not a quiet carry-forward.
How do you treat a vendor statement showing invoices you never received?
When a vendor statement shows an invoice you have no record of, treat it as unconfirmed liability: ask the vendor for a copy, check whether you received the goods or service, and book it only when you have support. Do not pay from a statement alone.
Work through these steps:
- Search your own records first. The invoice may be in a shared inbox, filed under another vendor name, or entered with a typo in the number.
- Request the invoice copy and proof of delivery from the vendor. The purchase order and the receiving record show whether you ordered and received it.
- Decide the outcome. If the goods or services were received and the invoice is valid, book it, in the right period. If you cannot establish that you ordered or received them, dispute the line in writing and leave it off your ledger.
- Note the status on the template. "Requested copy, due Friday" or "disputed, sent June 3" tells the next reviewer where it stands.
At period end, a valid unrecorded invoice may belong in the period before the statement date, if the goods were received then. That is an accrual question for your accountant or the accounting policy you follow, and it is why you keep the evidence with the reconciliation. In the example above, INV-1067 for 1,235.00 sits in this category until the copy and the receiving record arrive.
Accounts payable duplicates and missing credits
Accounts payable duplicates are bills paid or recorded twice, and missing credits are refunds or credit memos that were issued but never applied. Both let a company pay more than it owes without anyone noticing a single wrong line.
Duplicates slip through for ordinary reasons:
- The invoice arrives by email and again by mail, and each copy is entered.
- A vendor reissues an invoice with a new number after a correction, and the old one is not voided.
- A statement amount is paid while the underlying invoice is also in the payment run.
- The same invoice is entered under two slightly different vendor names, so duplicate checks on vendor and number never fire.
Look for the same vendor, the same amount and dates close together, then confirm against the documents. The full rules for that test are in the guide to same payee, same amount, close dates: duplicate transaction rules, written for bank statement lines, and the same idea applies to your payment history. A duplicate found on a vendor statement usually shows up as a payment with no matching invoice, or as a vendor balance that is lower than your own.
Missing credits are quieter. A vendor issues a credit memo for returned goods, and your team files it without applying it to a bill. The credit sits unused, and you later pay an invoice in full. Check each vendor statement for credit lines, and compare them to your credit memos. When a credit exists on the statement and not in your books, record it. When it exists in your books and not on the statement, ask the vendor to confirm it.
Using software for the matching
Matching statements by hand works for a few vendors and becomes slow at scale. PreciseBankFlow checks bank statement lines for duplicates and gaps, and lists each exception with its evidence for your review, which helps when you trace a payment from your payable records to the bank. It does not replace vendor statements; see the PreciseBankFlow homepage for what it covers.
For the idea behind all of this, what account reconciliation means explains why each balance needs a second source, and balance sheet account reconciliations shows how accounts payable fits next to the other accounts you reconcile at month end.