Bookkeeping
Reconciling accounts payable before year-end
November 19, 2026 · 10 min read

Quick answer
To reconcile accounts payable before year-end, make the total of your AP aging report match the AP balance in the general ledger, then prove the aging is right: compare it to statements from your biggest vendors, remove duplicates, move vendor debit balances out, and after December 31 check every bill and payment from January for anything that belonged to last year. Bills you owe but haven't received yet go in as accruals, not as fake bills in AP.
It's late December. Your AP aging says you owe vendors about $141,000. The balance sheet says $148,600. Nobody can explain the gap, and your CPA's year-end list has a line that says "please provide AP detail that ties to the trial balance."
That gap is common. AP is where every small slip shows up: a bill entered twice, a payment posted to the wrong vendor, a journal entry made straight to the AP account because it was quicker.
Below: the year-end AP reconciliation in the order we'd do it, a worked example, a December and January calendar, and the common mistakes.
To the penny
How closely the AP aging total should match the general ledger AP balance
30–60 days
How far into the new year it's worth checking bills and payments for last year's costs
$2,000
The 1099-NEC reporting threshold for payments made in 2026 (IRS)
What does reconciling accounts payable actually mean?
It means two things, and people often do only the first.
The internal tie-out. The total of your aged payables report (every open bill, by vendor) must equal the accounts payable balance in your general ledger at the same date. If you use QuickBooks Online or Xero and enter bills through the bills screen, these usually match. When they don't, something was posted to the AP account outside the bills process.
The outside check. Two of your own reports agreeing doesn't prove they're complete. For that you compare your records to what vendors say you owe, and look for bills that should be in AP but aren't. As AccountingTools puts it, the AP reconciliation agrees the ledger to your own detail, while a vendor statement reconciliation compares your records to the supplier's to catch unrecorded invoices and unapplied credits. You want both.
Why bother before year-end instead of after?
Because year-end AP feeds three things at once: your annual financial statements, your tax return, and your 1099s.
If AP is overstated (duplicates, bills already paid), expenses are too high and profit too low. If it's understated (missing December bills), the reverse, and on an accrual-basis tax return that moves taxable income too. Lenders and auditors test AP early, because missing liabilities are the easiest way for profit to look better than it is.
Step 1: tie the AP aging to the general ledger
Run the AP aging summary and the balance sheet at the same date, after everything for the period is posted. Then:
- Check that last month's aging tied. If November didn't tie, fix November first, or you'll chase old differences in December's numbers.
- Look at the AP account in the general ledger for journal entries. A journal entry to AP doesn't attach to any vendor, so it shows on the balance sheet but not on the aging. This is the most common cause of a difference.
- Rerun both reports after late entries, on the same (accrual) basis.
Each journal entry gets one of two fixes. If it's a real amount owed to a specific vendor, reverse it and enter it as a bill. If it isn't a vendor bill at all (an estimate, a tax, a payroll item), move it to the account it belongs in.
Step 2: compare statements from your biggest vendors
Ask your top vendors by spend, plus any vendor with a balance that looks odd, for a statement as of the end of November or December.
| What you find | What it usually means | What to do |
|---|---|---|
| Invoice on their statement, not in your books | Bill never entered, or sent to the wrong inbox | Get a copy, confirm the goods or service arrived, enter it |
| Invoice in your books, not on theirs | Duplicate entry, or a bill entered under the wrong vendor | Find the original, delete or move the extra one |
| Payment on your side, not on theirs | Payment in transit, or applied to another customer account | Send proof of payment with the invoice number |
| Credit memo on their statement, not in your books | Return or price adjustment never recorded | Enter the credit and apply it to an open bill |
Step 3: hunt down duplicates and debit balances
Sort open bills by vendor and amount and look for repeats within a few weeks. Bill number typos ("INV-1043" and "INV1043") are how duplicates slip past software warnings.
Then filter the aging for negative balances. A vendor with a debit balance means you've paid more than you were billed: a duplicate payment, a deposit, or a credit you never used. Inside the aging, that negative quietly nets against everything you really owe, so total AP looks smaller than it is. At year-end, either apply the credit to an open bill, ask for a refund, or move it to an asset account (such as "vendor receivables" or "prepaid") so AP shows only what you owe.
Step 4: search for unrecorded liabilities after December 31
This step happens in January, and it's the one that catches the most. Auditors call it the search for unrecorded liabilities: you look at what happened after year-end to find costs that belonged before it.
Go through:
- Payments made in January (and into February if the books aren't closed yet). For each, ask what period the goods or services were for.
- Bills received or entered in January. A December 18 contractor invoice that arrived January 6 belongs in December.
- Open purchase orders and delivery records for goods received in December but not billed.
The test isn't the bill date or the payment date. It's when you received the goods or the service was performed. Practitioners usually stop the search somewhere in the 30 to 60 days after year-end, once January's bills have arrived.
Step 5: accrue what you owe but haven't been billed for
Some December costs won't have a bill at all by the time you close: the December utility bill that arrives January 20, legal work done in December and billed in February, freight for a December delivery.
Record these as accrued liabilities, a separate account from AP, with a reversing entry on January 1. Don't create fake vendor bills to get them on the books. Fake bills get paid twice, mess up 1099 totals, and make next year's aging unreliable. Keep a short schedule of each accrual and the basis for the amount. Our post on adjusting journal entries covers accruals and reversals in more detail.
A worked example: making AP tie at December 31
Say you run a hypothetical 25-person commercial cleaning supply company. On December 31 the general ledger shows AP of $148,600 and the aging shows $141,350, a gap of $7,250.
The tie-out finds two journal entries made directly to AP: a $5,000 estimate for December legal fees and a $2,250 sales tax adjustment. Neither is a vendor bill. The $5,000 moves to accrued liabilities and the $2,250 to sales tax payable. Now both reports say $141,350.
Then the real work starts:
| What the year-end review found | Effect on AP | Effect on 2026 profit |
|---|---|---|
| A $3,800 supplier bill entered twice in November | −$3,800 | +$3,800 |
| A $1,900 overpayment to a vendor, moved to vendor receivables | +$1,900 | None |
| December bills found in the January search | +$9,600 | −$9,600 |
| Two invoices on vendor statements that were never entered | +$2,450 | −$2,450 |
| December freight and utilities, no bill yet (accrued liabilities, not AP) | None | −$4,200 |
From the AP aging to the real year-end AP balance
Hypothetical cleaning supply company, December 31
- Raises AP
- Lowers AP
- Total
Hypothetical example. 141,350 − 3,800 + 1,900 + 9,600 + 2,450 = 151,500. Accrued liabilities of $9,200 ($5,000 legal plus $4,200 freight and utilities) sit in a separate account.
Show the numbers
| AP aging total | $141,350 |
| Duplicate removed | −$3,800 |
| Debit balance moved | +$1,900 |
| Late December bills | +$9,600 |
| Statement differences | +$2,450 |
| Year-end AP | $151,500 |
Year-end AP ends at $151,500, about $10,000 more than the aging showed before the review, and 2026 profit drops by $12,450 (a $3,800 increase from the duplicate, less $9,600, $2,450 and $4,200 of costs that belonged to the year). That's not a disaster, and it's much easier to fix in January than after the tax return is filed.
A December and January calendar
Early December
Request statements
Ask top vendors for statements as of November 30. Chase old credits and debit balances while people are still answering email.
Mid December
Clean the vendor list
Merge duplicate vendors, check every 1099 vendor has a W-9, and void stale open bills with approval.
December 31
Cutoff
Note the last check number and last ACH. Anything received by today belongs in this year.
Days 1–10 of January
Tie out
Reconcile the aging to the ledger, compare December statements, fix duplicates and journal entries.
Through late January
Search and accrue
Review January bills and payments for December costs, book accruals and keep the schedule.
By January 31
1099s
1099-NEC forms are due to recipients and the IRS. They're based on what you paid in the calendar year.
Common mistakes
Journal entries straight to the AP account. It's the fastest way to make the aging and the ledger disagree. Use bills for vendors and a separate accrued liabilities account for estimates.
Reconciling only the balance. If the aging matches the ledger but both are full of duplicates, they still match. The vendor statements and the January search are what prove completeness.
Mixing AP with 1099 reporting. 1099s follow what you paid to a vendor during the calendar year, not what you were billed. For payments made in 2026, the 1099-NEC threshold is $2,000 (it was $600 before 2026), per the IRS instructions. A December bill paid in January counts toward next year's 1099. Our year-end 1099 workflow covers the rest, and the 1099-NEC tracker helps you keep totals by vendor.
When to get help
If you have a few dozen vendors, enter every bill through your software and pay through it too, you can do this yourself in an afternoon in December and a morning in January. The year-end bookkeeping checklist puts AP in context with everything else.
Get help when the gap between the aging and the ledger is large and old, when you've switched bookkeepers mid-year, or when a lender or auditor is about to look. If bill paying itself is the problem, it may be worth automating accounts payable first. Fintrix Consulting's payroll and AP service lines bills up for your approval, collects W-9s when a vendor is added and prepares 1099s every January, so year-end AP is a check rather than a cleanup.
Frequently asked questions
Why doesn't my AP aging match my balance sheet?
Almost always because something was posted to the accounts payable account without a vendor attached, usually a journal entry. Run the AP account's general ledger detail and look for entries that aren't bills, bill payments or vendor credits.
Do I need vendor statements from every vendor?
No. Cover your largest vendors by spend and any vendor with credits, disputes or old balances. For a small business that's often five to fifteen statements.
What's the difference between accounts payable and accrued liabilities?
Accounts payable is bills you've received and not paid. Accrued liabilities are costs you've incurred but haven't been billed for yet, recorded as estimates. Keeping them separate keeps your vendor aging clean.
How far into January should I look for unrecorded bills?
Until most of December's bills have come in, typically 30 to 60 days after year-end. If you close the books earlier, accrue anything you know about and check again before the tax return is prepared.
The bottom line
A year-end AP reconciliation is two jobs: make the aging and the ledger agree, then prove the aging is complete. The first job is usually a few stray journal entries. The second (vendor statements, duplicates, debit balances and the January search) is where the real money moves. Do both every year, keep estimates out of AP, and your year-end balance sheet will hold up when someone looks closely.
Sources
This article is general information, not advice for your situation. Rules change and details matter, so talk to us or your CPA before acting on it.
More articles
- Journal entries and adjusting entries, with examples
November 19, 2026
- Bookkeeping for consultants and freelancers
November 19, 2026
- Catching up your books when statements and receipts are missing
November 19, 2026
Have a question about this article?
Ask us. A real person will reply by email within one business day. Your question isn’t published.
Ready for books you can trust?
Book a free 30-minute consultation. We'll review where your finances stand today and show you exactly how we'd help.