Accounts Payable Reconciliation: The Monthly Bookkeeper Checklist (2026)

Accounts Payable Reconciliation: The Monthly Bookkeeper Checklist (2026)

It's the last business day of the month. You've got eight clients to close, two vendor statements sitting in your email unanswered, and one client who swears they paid a bill that never showed up in the system. Sound familiar?

AP reconciliation is the one task where shortcuts compound. Skip it in April and you're untangling stale credits and ghost balances in November. Do it right every month and January 1099 season becomes a documentation exercise instead of a fire drill.

This checklist walks through the exact seven steps bookkeepers use to close AP cleanly: pull the subledger, tie it to the GL, reconcile vendor statements, clear unapplied credits, flag 1099 candidates before the year-end rush, generate the AP aging, and document what you couldn't resolve. Each step connects to the broader accounts payable workflow for bookkeepers that keeps small-firm clients audit-ready year-round.

What is accounts payable reconciliation?

Accounts payable reconciliation is the monthly process of confirming that your AP subledger (the detailed vendor-by-vendor open balance list) matches your GL control account, then verifying each open balance against vendor statements. The goal is a clean, documented AP balance at period end: every open invoice is real, every credit is applied, every 1099-eligible vendor is flagged. For small-firm bookkeepers, a full reconciliation takes 25-90 minutes per client depending on transaction volume. Doing it monthly reduces year-end catch-up work by roughly 70-80%.

Key Takeaways

• Subledger-to-GL tie is non-negotiable: any variance, even $0.01, must be documented before closing the period.
• Vendor credits are silent cash leaks: unapplied credits average $180-$400 per client per year at small businesses; clear them monthly, not at year-end.
• The 1099-NEC threshold is now $2,000: raised from $600 by OBBBA for payments after Dec 31, 2025; flag vendors at $1,500 cumulative YTD so you're not scrambling in December.
• AP aging tells you what to escalate: anything 61+ days past due needs a client conversation this month, not next.
• Documented exceptions protect you: a one-line carry-forward note on each unresolved item is the difference between "bookkeeper error" and "known open item."
• Monthly AP discipline feeds clean 1099s: every W-9 you collect in April costs nothing; collecting it in January under a filing deadline costs real stress.

The 7-Step Monthly AP Recon Checklist

Here are the seven steps in order. Run them on every client, every month. The sequence matters: steps 1 and 2 verify the data foundation before you build anything on top of it.

Step 1: Pull the AP Subledger

Export a vendor-by-vendor open balance list as of the last day of the period. In QBO this is the Accounts Payable Aging Detail report filtered to "As of [period end]" with all aging periods showing. In Xero it's the Aged Payables Detail. Whatever system you're using, you want every open bill line: vendor name, invoice number, invoice date, due date, and open balance.

What to check:

• Any vendor with duplicate invoice numbers. Duplicates either mean two copies of the same bill got entered or a vendor billed twice. Flag both.
• Bills dated more than 90 days in the past with no corresponding payment. Either the payment got miscoded or the bill is genuinely stale. You need to know which.
• Any credit balance on the subledger (negative open balance on a vendor). This means you've paid more than you owe, possibly an overpayment, possibly an unapplied credit memo. Step 4 handles these.

Save the export as a dated file. You'll compare it against the GL in Step 2 and against vendor statements in Step 3.

Step 2: Tie AP Subledger Total to the GL Control Account

The AP subledger total must equal the AP control account balance on the trial balance. No rounding, no approximation. If the numbers don't match, you have a posting error somewhere, an entry was made directly to the AP control account bypassing the subledger, or a journal entry hit AP without a corresponding vendor record.

How to run the tie:

1. Pull the AP subledger total from Step 1.
2. Pull the AP control account balance from the general ledger (trial balance or balance sheet) as of the same date.
3. Calculate the variance: subledger total minus GL balance.

If variance = $0: Document it, move on.

If variance ≠ $0: Stop here. Don't proceed to vendor reconciliations with bad source data. Common causes:

• Direct journal entry to AP (accountant made an adjusting entry directly, bypassing the vendor module)
• Unposted transactions (bills or payments sitting in draft)
• Conversion entry from prior bookkeeper that hit the control account without a subledger counterpart

Every variance needs a documented reason before you move to Step 3. One line is enough: "Variance of $312.50, traced to JE #1042 dated 10/31, adjusting entry from prior firm. Documented in workpapers."

Step 3: Reconcile to Vendor Statements

For vendors who send monthly statements (most suppliers, utility companies, and any vendor on net-30 or net-60 terms), pull the statement and tie each line to your subledger. This is the step that catches bills your client didn't forward to you.

The full process is covered in the vendor statement reconciliation guide, but here's the month-end workflow:

1. Request statements from all major vendors by the 5th of the following month (or ask your client to forward them automatically).
2. For each statement, match line by line against your open AP detail: invoice number, amount, date.
3. Flag discrepancies in three categories:
   • On statement, not in books: Missed invoice, get a copy from the client, enter it.
   • In books, not on statement: Either you recorded something the vendor didn't credit yet, or there's a duplicate. Verify with the vendor.
   • Amount mismatch: Price dispute, freight charge discrepancy, or a returned item that hasn't been credited. Document and flag for client.

Not every client has vendors who send statements. For clients with primarily one-off vendors or project-based AP, skip this step and note it in your workpapers.

Step 4: Apply Unapplied Vendor Credits

Unapplied credits are one of the most common AP cleanup items at small businesses. A vendor issues a credit memo for returned goods, the client's admin enters it, and no one applies it against an open bill. Six months later there's a mysterious negative balance on the subledger that nobody can explain.

The vendor credit memo guide covers how credits should be entered. At month-end, the reconciliation step is simpler: run a search on your AP subledger for any vendor with a credit balance (negative balance), then apply each one.

Application process:

1. For each credit balance vendor: identify the credit memo and the open bills it should offset.
2. Apply the credit against the oldest open bill first (standard practice, though some clients prefer largest-bill-first for cash flow optics).
3. If the credit exceeds all open bills: leave the remainder as a credit balance and note that a refund may be owed.
4. Document each application with credit memo number and the bill(s) it offset.

Clearing unapplied credits each month keeps your AP aging accurate. A vendor with a $400 credit sitting unapplied looks like a $400 credit balance on aging, which skews cash flow reporting and confuses your client's controller.

Step 5: Identify 1099 Candidates

This is the step most bookkeepers skip until December. Don't.

Every month, pull your YTD vendor payment total for any non-corporate vendor who might hit the filing threshold. Under the One Big Beautiful Budget Act (OBBBA), the 1099-NEC and 1099-MISC thresholds both increased to $2,000 for payments made after December 31, 2025. The old $600 threshold still applies to TY 2025 payments. For 2026, you're watching for the $2,000 mark.

The monthly 1099 candidate sweep:

1. Run a vendor payment summary YTD filtered to: individuals, sole proprietors, single-member LLCs, and any vendor who hasn't returned a W-9 confirming corporate status.
2. Flag any vendor with YTD payments of $1,500 or more. That's your 90-day warning zone, they'll cross $2,000 within a quarter if invoices continue at the same pace.
3. For flagged vendors without a current W-9 on file: generate a W-9 request now. The how to request a W-9 from a vendor guide has scripts and tracking templates.
4. Document vendor name, YTD total, W-9 status, and entity type in a running 1099 tracking tab.

Why the $1,500 flag threshold matters:

At $2,000 cumulative payments without a valid W-9 on file, §3406 backup withholding kicks in at 24%. That means your client is legally required to withhold 24 cents of every dollar paid to that vendor until a valid W-9 is received. Most small businesses don't know this. You do. Catching it at $1,500 gives you time to collect the W-9 before backup withholding becomes an issue.

Penalty exposure without W-9s:

Missing or incorrect 1099s carry §6721 penalties: $60/return if corrected within 30 days, $130/return if corrected by August 1, $340/return if corrected after August 1, and $680/return for intentional disregard with no annual cap.

For a bookkeeper managing 15 clients with 5-10 vendors each, even $130/return penalties across a portfolio add up fast. The monthly flag process is what separates firms that sail through 1099 season from firms that spend February scrambling for W-9s.

The full tracking workflow is in the 1099 filing guide for 2026, which covers W-9 collection, TIN matching, and filing mechanics.

Step 6: Generate AP Aging Report

The AP aging report is the output your client actually sees. Generate it after steps 1-5 so it reflects a clean, reconciled AP balance: credits applied, vendor discrepancies documented, no duplicate bills.

Standard aging buckets:

The AP aging report guide covers how to read and present aging to clients, including how to explain 90+ day balances without creating panic.

What to note in your workpapers:

• Total current AP balance (reconciled)
• Breakdown by aging bucket
• Number of vendors 60+ days past due and reason (disputed invoice, pending credit, legitimate cash flow issue)
• Any vendors on payment hold

Send the aging report to your client with a brief comment on anything in the 61+ bucket. One sentence: "Acme Supply invoice #4421 ($1,200) is 67 days past due, please advise on payment timing." That's it. You've done your job.

Step 7: Document Exceptions and Carry-Forwards

Not every AP item gets resolved in the current month. A disputed vendor invoice, a missing statement, a credit memo your client says is wrong, these carry forward. Document them.

For each unresolved item, write one line:

Vendor: Office Depot | Invoice: #OD-9912 | Amount: $340.00 | Issue: Duplicate entry (02/14 and 02/17). Awaiting vendor confirmation before removing 02/17 entry. | Status: Carry-forward to next month.

That's it. No paragraph, no analysis. Just what it is, why it's unresolved, and what the next step is.

Why documentation matters:

If you're ever asked "why is this still open," your one-line note is the answer. Without it, "bookkeeper error" is the default assumption. With it, you've established a clear audit trail. Same principle applies to payment reconciliation items that sit open across periods, the carry-forward note is what protects you.

Save your documented exceptions in a dedicated workpaper file per client. Month over month, you'll see patterns: the same vendor always has a discrepancy, the same client always has duplicate entries. Those patterns are billable conversations. For definitions of terms used throughout this workflow, aging buckets, subledger, control account, backup withholding, see the bookkeeping glossary.

The Year-Round Discipline That Makes January 1099 Filing Easy

January 1099 panic comes from 12 months of deferred decisions. Every month you skip the 1099 candidate sweep, every W-9 you don't collect in April because "it's not urgent yet," every vendor without an entity-type classification on their record, those accumulate into a 3-week project in January.

The monthly AP recon checklist is how you avoid that. Step 5 is your live 1099 tracker. By the time you run payroll in December, your vendor list should already have W-9s on file, entity types confirmed, and YTD totals that match what you expect.

The 1099 workflow guide has the full January filing sequence: TIN matching, corrected 1099 procedures, state filing requirements, and how to handle foreign vendors (who get a W-8BEN and a 1042-S, not a 1099, §1441 withholding at 30% applies absent a treaty).

How AI Categorization Cuts Recon Time From 90 Min to 25 Min Per Client

The time-consuming part of AP recon isn't the logic, it's the data prep. Pulling vendor payment totals for 15 vendors across 3 months of transactions, cross-referencing invoice numbers against vendor statements, checking for duplicate entries. At 90 minutes per client across 8 clients, that's 12 hours of month-end close. Every month.

Growthy's pattern learning handles the categorization layer so your data arrives pre-sorted. Transactions from the same vendor are already bucketed the same way you coded them last time. You're reviewing and approving instead of hunting through uncategorized transactions. On returning clients, accuracy runs above 90%. On first import, it's around 85%.

You didn't become a bookkeeper to click "Categorize" 500 times a month. The 25-minute recon time isn't a promise, it's what firms running AI bookkeeping workflows report after 3-4 months on the platform. The first month you're still teaching it. By month three, you're checking work, not doing it.

Growthy is built by a CPA firm partner who still reconciles books for real clients, so the AP reconciliation workflow maps to how bookkeepers actually close clients, not how enterprise software assumes you close them.

Ready to Close AP Faster?

Run this checklist on your next client close and see where your time actually goes. If it's Step 1 data prep or the 1099 candidate sweep, those are exactly the tasks that pattern learning handles first.

Get started with Growthy, no credit card required. First import takes about 10 minutes.

Tax figures verified against IRS Notice 2025-62, IRS 1099-K FAQs, §3406 proposed regulations, and IRS Pub 1099 General Instructions / Rev. Proc. 2025-32 on 2026-05-14.