Accounts Payable Reconciliation: Process and Template

Accounts payable reconciliation is the control that proves your books are right before you close the month. It compares the total of every unpaid vendor invoice in your AP subledger against the accounts payable balance sitting in the general ledger, then explains any difference between the two. When the numbers tie, you can sign off the close with confidence. When they do not, you have a problem to find before the financials go out.

Most teams treat it as a tedious month-end chore, and it stays painful for one reason: the source data is scattered across PDF invoices, email attachments, and a subledger that was keyed in by hand. This guide walks through what the reconciliation is, the exact steps controllers follow, what belongs on a reconciliation template, and how to get the underlying invoice data clean enough that the two balances agree the first time.

What is accounts payable reconciliation?

Accounts payable reconciliation is the process of confirming that the total owed to suppliers in the AP subledger equals the accounts payable control account balance in the general ledger as of the same date. It catches missing invoices, duplicate entries, and journal errors before they reach the financial statements. The reconciliation is complete when every difference between the two balances is identified, explained, and either corrected or documented.

There are really two things people mean by the term. One is the high-level ledger tie-out: AP subledger total versus GL control account, the month-end close task this article focuses on. The other is transaction-level matching, where you check individual invoices against purchase orders and receipts. That second job is covered in our guide to invoice reconciliation, and matching a supplier's own statement to your records is covered in vendor statement reconciliation. All three protect the same balance from different angles.

Why is accounts payable reconciliation important?

It is important because an unreconciled AP balance can misstate both your liabilities and your cash forecast, and auditors will flag it fast. If invoices are missing from the subledger, you understate what you owe and overstate profit. If duplicates slipped in, you risk paying a vendor twice. A clean reconciliation each period gives you an accurate payables figure, a defensible audit trail, and an early warning when the close process is breaking down.

There is a cash angle too. The reconciled AP total feeds your accounts payable aging report, which drives payment planning and metrics like days payable outstanding. Garbage in the subledger means garbage in every downstream decision about when and what to pay.

What are the steps in the accounts payable reconciliation process?

The accounts payable reconciliation process has six core steps: pull both balances, compare them, list the open items, investigate any variance, post corrections, and document the result. Run them in the same order every period so the work is repeatable and a reviewer can follow it. Here is what each step involves.

1. Pull the subledger and the GL balance as of the same cutoff. Run the AP aging or open-payables report for the period-end date, and pull the AP control account balance from the general ledger for that exact date and time. A mismatched cutoff is the single most common reason two correct systems appear to disagree.

2. Compare the two totals. If the AP subledger total equals the GL control account balance, you are done after documentation. If not, the difference is your reconciling amount to explain.

3. List the open items behind the subledger total. Build a line-by-line list of every unpaid invoice that makes up the subledger balance: vendor, invoice number, invoice date, due date, and amount. This is the evidence that supports the number you are tying to the ledger.

4. Investigate the variance. Trace the difference to its cause. Typical culprits are journal entries posted directly to the AP control account, unposted or stuck invoice batches, payments recorded in one system but not the other, and timing differences around the cutoff.

5. Post corrections. Once you find the root cause, fix it in the right place. Missing invoices get entered, duplicates get reversed, and a stray manual journal gets corrected with a documented adjusting entry.

6. Document and get it reviewed. Save the reconciliation worksheet, the supporting open-items list, and a short explanation of any residual difference. A reviewer should be able to understand the tie-out in about five minutes.

What is AP to GL (control account) reconciliation?

AP to GL reconciliation compares the total in the accounts payable subledger with the accounts payable control account in the general ledger. The control account is the single GL line that should always mirror the sum of the subledger detail. When a journal entry hits the control account directly, bypassing the subledger, the two drift apart, which is why direct postings to AP control are the first thing experienced controllers check. The goal is a zero difference, or a small difference you can fully explain with timing items.

What goes on an accounts payable reconciliation template?

A good accounts payable reconciliation template has three blocks: the two balances at the top, the open-items detail in the middle, and a reconciling-items section that bridges any gap. Keep it on one tab so a reviewer never has to hunt. A practical column layout looks like this:

Header block: period-end date, AP subledger total, GL control account balance, and the difference (a formula, not a typed number). Open-items block, one row per unpaid invoice: vendor name, invoice number, invoice date, due date, GL account, and amount. Reconciling-items block: a short list of each timing or error item, its amount, and the action taken. Add a sign-off line for preparer and reviewer with dates so the worksheet doubles as audit evidence.

What causes accounts payable reconciliation discrepancies?

Most discrepancies trace back to a handful of repeat offenders: invoices keyed into the subledger but never posted to the GL, duplicate invoice entries, manual journals booked straight to the AP control account, payments applied in one system but not the other, and cutoff timing where an invoice lands on a different side of period-end in each ledger. Foreign-currency revaluation and intercompany postings filtered incorrectly cause the rest. Notice that several of these start with bad invoice entry, which is why teams that automate accounts payable data entry see far fewer reconciling items each month.

How do you reconcile accounts payable in Excel?

To reconcile accounts payable in Excel, export the AP aging detail and the GL transactions for the control account into two tabs, then use SUMIF and XLOOKUP to total each and surface the difference. Put the subledger total in one cell, the GL balance in another, and a difference formula between them so it updates as you investigate. The slow part is never the formulas, it is getting the invoice detail into rows in the first place. If your invoices live as PDFs, our guide on how to extract invoice data to Excel turns a stack of bills into clean, sortable rows with vendor, invoice number, date, and amount already split into columns, including full invoice line item extraction when you need to reconcile at the line level. Once the GL side is also a PDF export, converting that PDF trial balance to Excel drops the control account balance into a cell you can tie to directly.

How do you reconcile accounts payable in QuickBooks?

In QuickBooks, run the Accounts Payable Aging Summary and the Balance Sheet for the same date, then confirm the aging total matches the Accounts Payable line on the balance sheet. If they differ, the usual cause is a transaction posted to the AP account without a vendor, or a journal entry that hit AP directly. Use the Transaction Detail by Account report filtered to the AP account to find the entry, then correct it. The same tie-out logic applies in NetSuite, Sage, and Xero; only the report names change.

How often should you reconcile accounts payable?

Reconcile accounts payable at least once a month, as part of the period-end close, and ideally do a lighter check weekly if you process high invoice volume. Monthly reconciliation is the standard because it aligns with financial reporting and catches problems while they are still small. Weekly reviews keep the month-end version short and stop a single bad batch from compounding for four weeks before anyone notices.

How automation makes the reconciliation tie out the first time

Reconciliation gets fast when the subledger is right to begin with. Every duplicate, transposed amount, or missing invoice you avoid at data-entry time is a reconciling item you never have to chase at close. That is the real payoff of cleaning up invoice capture: not just lower invoice processing costs, but a month-end that ties out on the first pass. Using dedicated invoice processing software to read each PDF and write accurate vendor, invoice number, date, and amount values straight into your rows removes the keying errors that cause most variances. When you also convert your bank statements to Excel for the cash side, both halves of the close start from clean, structured data instead of PDFs you have to read by hand.

Accounts payable reconciliation will never be glamorous, but it does not have to be a two-day scramble. Pull both balances on the same cutoff, list your open items, explain every difference, and document the tie-out. Do that on clean invoice data and the reconciliation becomes a ten-minute confirmation that the books are already right.