How to Reconcile Accounts Payable to the General Ledger in QuickBooks

Your balance sheet has one line called Accounts Payable. Behind it is a detailed list of every unpaid bill by vendor. The single line is the control account; the detailed list is the subledger.

They must always agree. Not approximately — exactly. The subledger is the explanation of the control account, and if the explanation does not add up to the thing it explains, one of them is wrong and you cannot tell which without looking.

The same logic applies to receivables, inventory and fixed assets. AP is where it breaks most often in small businesses, because it is the one where journal entries get posted directly by people trying to fix something else.

• The period end date you are reconciling to, used identically on both reports.
• Your accounting basis — accrual or cash. Know which before you start, because it determines whether a difference is even meaningful.
• Bank reconciliations already complete for the period. Payments still uncategorized in the bank feed will move the payable balance under you mid-investigation.

1. Run the AP aging summary

Reports → What you owe → Accounts payable aging summary. Set the report date to the last day of the period, not today. Note the grand total.

The date matters more than it looks. An aging run today shows what you owe today, which is not what you owed on the 31st, and comparing it to a balance sheet dated the 31st guarantees a difference that means nothing.

2. Run the balance sheet

Reports → Business overview → Balance sheet, as of the identical date. Find Accounts Payable under current liabilities. Note the figure.

3. Compare

Equal is done. Record the reconciliation and move on — the whole exercise takes five minutes in a month where nothing went wrong, which is most months once the process is established.

Not equal: the difference is your investigation. Write it down, including the sign. Knowing whether the control account is higher or lower than the subledger immediately narrows the cause.

1. A journal entry posted straight to accounts payable

This is the overwhelming favorite. A journal entry moves the general ledger without creating a vendor bill, so the control account changes and the subledger does not. The tie breaks by exactly the entry amount.

To find them, run a transaction report on the accounts payable account and filter to journal entries only. In QuickBooks, open the account register from the chart of accounts, or run Reports → For my accountant → Transaction detail by account filtered to Accounts Payable.

Every hit is a candidate. Some are legitimate corrections made by an accountant at year end and will have documentation. Most are someone forcing a number to look right.

2. A payment coded to accounts payable instead of applied to a bill

Someone pays a vendor by writing an expense or a check and codes it directly to Accounts Payable, rather than recording a bill payment applied against the open bill. The control account drops. The bill stays open on the aging.

The tell is a vendor showing an old open balance you are certain was paid — and it was, just not in a way the subledger recognizes.

3. Basis mismatch

Covered above. Check it before spending an hour on the other three.

4. Unapplied vendor credits and prepayments

A vendor credit that has not been applied to a bill, or a deposit paid in advance, can sit in the control account while the aging presents it differently or nets it in a way you did not expect. Less common than the first two, but it is the one people miss after ruling those out.

Fix each cause at the transaction that created it. A journal entry to the control account gets reversed and re-recorded as an actual bill against the actual vendor. A misdirected payment gets deleted and re-entered as a bill payment applied to the open bill.

Then re-run both reports and confirm the tie. Do not assume the fix worked — the second most common way this goes wrong is fixing one cause while a second is still present, seeing a smaller difference, and concluding you are finished.

If the period is already locked by a closing date, make the correction in the current period with a clear memo, rather than reopening a closed month. Reopening a closed period changes numbers you have already reported.

A clean tie proves the subledger and control account agree. It does not prove either is right. Three things pass a reconciliation while still being wrong:

• Duplicate bills. A bill entered twice appears in both the aging and the control account, so the tie holds perfectly while both are overstated. Sort the aging by amount to surface identical pairs — the same vendor and amount twice is worth thirty seconds of checking.
• Bills never entered at all. An invoice sitting in someone's inbox is in neither place. The tie is silent about it, and your liabilities are understated.
• Bills coded to the wrong expense account. The payable is right, the P&L is wrong. Reconciliation cannot see this; only reviewing the expense detail can. This is where the job margin picture quietly degrades.

Reconciling proves internal consistency. Judgment is still required, which is the part no checklist replaces.

Tying the subledger to the control account proves your books agree with themselves. It says nothing about whether they agree with your vendors. That is a second reconciliation, and for your largest suppliers it is worth doing quarterly.

Request a statement of account from each major vendor and compare it line by line against their record in your aging. Four differences are normal and each means something different:

• An invoice on their statement that is not in your books. You never received it, or it was received and never entered. Your liabilities are understated and this will surface eventually as an unexpected demand.
• An invoice in your books that is not on their statement. Usually a duplicate on your side, occasionally a billing error on theirs. Either way one of you is wrong about what you owe.
• A payment they have not applied. You paid, they credited it to the wrong account or have not processed it. Left alone, this turns into a credit hold on a business that has paid every bill.
• A credit note you never recorded. Money you are owed and were not counting on, which is the one pleasant category.

The larger the vendor relationship, the more this matters. A supplier representing a significant share of your material spend is the one where a year of small unreconciled differences accumulates into a genuine dispute, and disputes are resolved far more easily when you can produce a reconciled position rather than an argument.

The asymmetry is the argument for doing it monthly. A single month's break has few candidate transactions and you will find it quickly. A year's accumulated drift means multiple overlapping causes, and you cannot isolate them because each month's difference contains all the previous ones.

The procedure is not hard. What makes it expensive is that it is unforgiving about frequency — skip it for six months and the cost of catching up is an order of magnitude higher than the cost of never having skipped it.

That is a bad fit for a job that depends on an owner remembering to do something with no external deadline forcing it. Nothing bounces. No bank calls. It simply drifts.