Fintrix Consulting LLC

Bookkeeping

Reconciling accounts payable before year-end

November 19, 2026 · 10 min read

← All articles
Overhead view of hands holding a calculator and pen over an open folder of stamped documents, surrounded by colored folders on a wooden desk
Photo via Pexels

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:

  1. 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.
  2. 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.
  3. 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 findWhat it usually meansWhat to do
Invoice on their statement, not in your booksBill never entered, or sent to the wrong inboxGet a copy, confirm the goods or service arrived, enter it
Invoice in your books, not on theirsDuplicate entry, or a bill entered under the wrong vendorFind the original, delete or move the extra one
Payment on your side, not on theirsPayment in transit, or applied to another customer accountSend proof of payment with the invoice number
Credit memo on their statement, not in your booksReturn or price adjustment never recordedEnter 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 foundEffect on APEffect 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,900None
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
$0$50k$100k$150k$200kAP aging total: $141,350$141kAP agingtotalDuplicate removed: −$3,800−$3.8kDuplicateremovedDebit balance moved: +$1,900+$1.9kDebitbalancemovedLate December bills: +$9,600+$9.6kLateDecemberbillsStatement differences: +$2,450+$2.5kStatementdifferencesYear-end AP: $151,500$152kYear-end AP

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

Year-end AP reconciliation calendar
  1. 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.

  2. Mid December

    Clean the vendor list

    Merge duplicate vendors, check every 1099 vendor has a W-9, and void stale open bills with approval.

  3. December 31

    Cutoff

    Note the last check number and last ACH. Anything received by today belongs in this year.

  4. Days 1–10 of January

    Tie out

    Reconcile the aging to the ledger, compare December statements, fix duplicates and journal entries.

  5. Through late January

    Search and accrue

    Review January bills and payments for December costs, book accruals and keep the schedule.

  6. 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.

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.

Have a question about this article?

Ask us. A real person will reply by email within one business day. Your question isn’t published.

Protected by reCAPTCHA. Google’s Privacy Policy and Terms apply.

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.