Strategy, Legal & Operations

The ultimate guide to accounts payable reconciliation

When your accounts payable records match what your suppliers expect, you avoid costly errors and keep cash flow predictable. AP reconciliation is what makes that possible.

Published September 30, 202612 min read Share

This article was originally published on May 5, 2025 and has been refreshed and re-published with new content on September 30, 2026.

Accounts payable (AP) reconciliation is the process of checking your AP records against supplier statements and resolving any differences. At period-end, it also involves confirming that the total in your AP subledger agrees with the accounts payable balance in your general ledger.

For small business owners and accounting teams, doing this well hinges on three things: a repeatable process, a template that keeps it consistent, and clear answers to the sticking points that usually cause errors—like timing differences, missing invoices, and duplicate payments.

Key takeaways

• Accounts payable reconciliation matches your internal ledger against vendor statements to confirm what you actually owe.
• Missing this step regularly can lead to duplicate payments, damaged vendor relationships, and inaccurate financial statements.
• A simple template makes the process repeatable across vendors.
• At month-end, reconcile the total in your AP subledger to the accounts payable control account in your general ledger to catch posting errors and timing differences.
• Automation tools can flag duplicate invoices and mismatched entries before they become costly problems.

Here’s what we’ll cover

What is accounts payable reconciliation?

Accounts payable reconciliation is the process of comparing the invoices, payments, credits, and balances in your AP records with the information provided by your vendors.

At month-end or another financial close, you should also confirm that the total AP subledger balance agrees with the accounts payable control account in your general ledger.

Put simply, what your books say you owe should be backed up by both your supplier records and your accounting system. When the numbers don’t agree, reconciliation is how you find out why.

Why does AP reconciliation matter?

Small AP discrepancies can create bigger problems if they’re allowed to pile up. Regular reconciliation gives you confidence that the amounts you’re paying, reporting, and planning around are based on records you can trust.

In practice, AP reconciliation helps you:

• Keep records accurate: you can see what the business owes without old errors or unresolved differences muddying the picture.
• Protect vendor relationships: paying the right amount at the right time means fewer disputes, fewer awkward follow-ups, and stronger relationships with suppliers.
• Improve cash flow visibility: a reliable view of upcoming payables makes it easier to plan where cash needs to go next.
• Support audit readiness: regular reconciliation leaves a clearer record of how AP balances were checked and resolved, making it easier to support those balances during an audit.
• Spot suspicious activity: reviewing your accounts payable regularly can help surface unusual invoices, payments, or changes that need investigating.
• Catch errors early: reconciliation surfaces discrepancies in invoices or payments before they become harder to trace and resolve.
• Make better decisions: accurate AP data gives you a more reliable view of liabilities when allocating resources and planning ahead.

How frequently should you reconcile accounts payable?

There’s no single reconciliation schedule that suits every business. The right cadence depends on how many invoices and payments you process, how complex your AP operation is, and how quickly you need discrepancies to surface.

Monthly reconciliation

For many businesses, monthly reconciliation is a practical rhythm: frequent enough to catch problems without adding unnecessary work to the day-to-day AP process. Higher-volume or higher-risk vendor accounts may benefit from a weekly check instead.

Quarterly and year-end reconciliation

Businesses with relatively low transaction volumes may perform some vendor reconciliations quarterly. However, AP balances should still be reviewed as part of the relevant financial close process.

Daily reconciliation

Businesses processing a high volume of invoices and payments may reconcile key AP activity daily, particularly when discrepancies need to be identified quickly.

Month-end close reconciliation

Month-end reconciliation of accounts payable typically expands beyond individual vendor statements. At this point, you’re not only checking whether you and your suppliers agree—you also need confidence that your own accounting records agree with each other.

That means tying your AP subledger total to the control account balance in your General Ledger (GL).

Referencing against the GL confirms the two match before you close the books and catches posting errors or timing differences that a vendor-statement comparison alone won’t reveal.

The accounts payable reconciliation process, step by step

A good AP reconciliation process doesn’t need to be complicated. The key is following the same checks in a logical order, so discrepancies are easier to spot, investigate, and resolve.

Follow this accounts payable process in the same order each time to check balances, investigate differences, and keep your records up to date.

1. Review your starting balance

   Start by reviewing your AP ledger’s opening balance, the amount you owed suppliers at the start of the period. Confirm it matches the previous period’s ending balance.

   If it doesn’t, investigate the difference before moving on. Starting with the wrong balance only carries the problem into the rest of the reconciliation.

2. Gather your documents

   Bring the records you’ll be comparing together before you start:

   • Vendor statements: provided by your suppliers, showing what they believe you owe.
   • AP ledger: your internal record of everything owed to vendors.
   • AP aging report: shows which invoices are due and which are overdue.

3. Compare vendor statements with internal records

   Match each invoice on the vendor statement against your AP ledger. Look for anything that doesn’t line up, including missing invoices, different amounts, unexpected credits, or transactions you don’t recognize.

   If your AP process uses purchase orders, invoice matching provides an additional control before reconciliation. Two-way matching compares the invoice with the purchase order, while three-way matching also checks the goods receipt or other evidence that the purchase was received.

   Catching those mismatches earlier means there are fewer surprises left to untangle at reconciliation.

4. Investigate and resolve discrepancies

   Don’t simply note a mismatch and move on. Trace it back to the invoice, payment, credit, or approval that caused it, and contact the vendor if your own records don’t provide the answer.

   Cross-check your recorded payments against your bank statements, too. This confirms nothing’s missing or duplicated on the payment side. If your process touches broader cash reconciliation, our bank reconciliation guide covers that step in more depth.

5. Reconcile the AP subledger to the general ledger

   If you’re reconciling at month-end or period close, this is the point to confirm your AP subledger total matches the control account balance in your general ledger. A mismatch here often points to a posting error, a timing difference, or an entry recorded in one system but not the other.

   If the difference relates to how an invoice, payment, credit, or adjustment has been recorded, review the underlying accounts payable journal entry before making any correction.

   If you’re doing a routine or weekly vendor-level reconciliation, you can typically skip this step and move straight to updating your ledger.

6. Update your AP ledger

   Once you’ve resolved the discrepancies, update your AP ledger so each vendor balance reflects the supporting invoices, payments, credits, and adjustments.

7. Review and approve the final reconciliation

   Before you call the reconciliation finished, check that every difference has either been resolved or clearly explained and that the supporting records are up to date.

   Where your team structure allows, have someone else review the reconciliation and sign it off. A fresh pair of eyes can catch an unresolved variance or unsupported adjustment that’s easy to miss when you’ve been working through the detail yourself.

   Then, save a copy of the completed reconciliation for future reference or audits.

Accounts payable reconciliation example and template

A reconciliation template takes some of the friction out of repeating the same process month after month. Rather than starting from scratch, you have one consistent place to record the figures, investigate differences, and show what was resolved.

Most accounts payable reconciliation templates include the following columns:

Column	What it captures
Vendor name	The supplier you’re reconciling against
Opening balance	Amount owed at the start of the period
Invoices received	New invoices added during the period
Payments made	Payments recorded against this vendor
Adjustments	Credits, disputed amounts, or corrections
Closing balance	Your ending balance for the period
Vendor statement balance	The balance the vendor reports
Variance	The difference between your closing balance and theirs

For a basic reconciliation template, you can calculate the two key fields as follows:

Here’s how that might look for one supplier:

Vendor name	Opening balance	Invoices received	Payments made	Adjustments	Closing balance	Vendor statement balance	Variance
Acme Supply Co.	$12,000	$4,500	$9,000	$0	$7,500	$8,200	$700

The $700 variance is worth investigating. Acme may have included an invoice or charge that hasn’t reached your ledger yet, or your records may include a payment that Acme hasn’t applied to the account.

The useful part isn’t simply spotting the $700 difference—it’s having a clear trail that helps you work out where it came from. Keeping variance visible in the template also makes recurring problems easier to spot across vendors or accounting periods.

Use formulas for both the closing balance and variance in your spreadsheet so that changes to invoices, payments, or adjustments automatically recalculate the balance and highlight any difference.

What are the most common AP reconciliation challenges?

AP reconciliation tends to become difficult for very ordinary reasons: a document goes missing, somebody enters a figure twice, or a supplier’s records don’t quite match your own. The good news is that most of these problems are easier to solve when you know what to look for.

Missing invoices

One missing invoice is enough to throw a vendor balance out. Keeping invoices in one centralized system makes them easier to find, match, and follow through the AP process.

Duplicate payments

When several people touch the same invoices, duplicate payments can slip through—especially if responsibilities aren’t clear. Automation can help flag duplicate records earlier in the AP process, reducing the risk of duplicate payments.

Vendor discrepancies

Sometimes the issue sits outside your own records. An invoice may be missing from a statement, a payment may not have been applied, or a credit may still be outstanding. Requesting current statements and raising discrepancies quickly makes these differences much easier to resolve.

Fraud and security risks

Reconciliation is also a useful opportunity to notice activity that doesn’t look right. Clear approval controls, secure payment processes, and regular review make unusual invoices or changes easier to challenge before they’re paid.

Data entry errors

A wrong invoice number, transposed figure, or misplaced decimal can create a surprisingly stubborn difference. Standardized data entry, validation checks, and automation reduce the amount of manual input—and the opportunities for those mistakes to happen.

Time-consuming, manual processes

What works for 20 invoices can quickly become painful at 2,000. As transaction volumes grow, automating routine capture, matching, and checking can free your finance team to spend more time investigating the exceptions that actually need attention.

What are accounts payable reconciliation best practices?

The strongest reconciliation processes are usually the least dramatic: they’re consistent, repeatable, and designed to catch small problems early. Four habits make a particularly big difference.

Automate where possible

Automating data entry, invoice matching, approval workflows, and duplicate-payment checks can reduce manual work and make discrepancies easier to spot. AP automation software can help capture invoice data, route invoices for approval, flag duplicates, and support purchase-order matching across the wider AP process.

Standardize your process

Create one reconciliation workflow and use it consistently. When everyone gathers the same records, checks them in the same order, and documents discrepancies in the same way, there’s less room for steps—or problems—to fall through the cracks.

Reconcile frequently

A small discrepancy is usually easier to investigate while the transaction is still fresh. If your volume justifies it, reconciling key vendor accounts weekly can stop missing invoices or unapplied payments from becoming month-end mysteries.

Keep vendor communication open

Your suppliers are part of the reconciliation process too. Request statements regularly and raise differences while the details are still easy for both sides to trace. A quick conversation now can save a much longer investigation at close.

If you want a broader view of how reconciliation fits into your wider payables workflow, see our guide to accounts payable management best practices.

What is vendor reconciliation in accounts payable?

Vendor reconciliation is the part of AP reconciliation that checks your internal records against an individual supplier’s statement. The aim is to identify missing invoices, unapplied payments, credits, or other differences before they affect payment or reporting.

A few simple habits make that process much easier:

• Request vendor statements regularly so you’re always working from current information.
• Cross-check outstanding balances to confirm you and the vendor agree on what’s owed.
• Resolve disputes before paying so an unclear charge doesn’t turn into an avoidable overpayment or payment delay.

Make accounts payable reconciliation a part of your routine

Accounts payable reconciliation isn’t the flashiest part of finance, but getting it right quietly solves a lot of problems: fewer payment mistakes, cleaner records, better visibility of what you owe, and a smoother close.

The process doesn’t need to be complicated. Build a consistent routine, investigate differences while they’re still fresh, and use automation where it genuinely removes repetitive work.

Looking to reduce the manual work behind AP reconciliation? Sage Intacct accounts payable software helps automate invoice capture, matching, approvals, payments, and reconciliation workflows, so your finance team can spend less time chasing discrepancies and more time reviewing exceptions, managing cash flow, and supporting the wider business.

Frequently asked questions about AP reconciliation

What causes accounts payable not to match the general ledger?

An AP subledger may not match the general ledger because of timing differences, entries posted directly to the AP control account, invoices or payments that haven’t posted correctly, or adjustments recorded in one place but not the other.

Start with the total difference, then trace it back to the transaction or journal entry behind it rather than adjusting the balance simply to make the numbers agree.

How do you reconcile accounts payable if a vendor doesn’t provide a statement?

If a vendor statement isn’t available, review the open invoices, credits, payments, and aging balance in your own records, then confirm any uncertain items directly with the supplier.

You can still reconcile the AP subledger to the general ledger at period-end, but without a supplier statement you lose that independent check of the vendor balance.

Who should review an accounts payable reconciliation?

Where your team structure allows it, the person reviewing an AP reconciliation should be different from the person who prepared it.

That separation gives you a useful second check before the reconciliation is signed off, particularly for unresolved variances or manual adjustments.

What should you do with old outstanding items in accounts payable?

Don’t let old AP items sit indefinitely simply because they’ve been carried forward before. Investigate whether the invoice is still payable, whether a payment or credit has been applied incorrectly, and whether you need information from the supplier before making an adjustment.

Should you reconcile every vendor account?

Not every vendor necessarily needs the same level of attention at the same frequency. Prioritize according to factors such as transaction volume, value, risk, and whether you receive regular statements, while making sure your overall AP balance is still properly reviewed as part of the close process.

Browse more topics from this article

• Accountants
• Accounting 101
• Boss your business
• Cash Flow
• Compliance & Regulation
• Growing a business
• Sage accounting solutions
• Small business
• Starting a business
• Stay competitive
• working capital