# How to Reconcile Accounts Payable in QuickBooks

- Author: PreciseBankFlow (https://www.precisebankflow.com)
- Published: 2026-03-18
- Updated: 2026-03-18
- Category: Reconciling in accounting software
- Canonical: https://www.precisebankflow.com/blog/how-to-reconcile-accounts-payable-in-quickbooks

> How to reconcile accounts payable in QuickBooks: the aging summary to the balance sheet, open bills already paid, and vendor credits that never applied.
To reconcile accounts payable in QuickBooks, run the A/P Aging Summary and the Balance Sheet for the same date on the accrual basis, and compare the two totals. If they differ, find the cause. Then review the aging itself for bills that were already paid, vendor credits that never applied and journal entries that skipped the vendor detail.

## What does reconciling accounts payable in QuickBooks prove?

Reconciling accounts payable in QuickBooks proves two things. First, the payables balance on the balance sheet equals the sum of what you owe each vendor. Second, each open bill on the aging is a real amount still unpaid. A bank reconciliation proves neither, because it only checks cash.

Accounts payable is a control account. The balance sheet shows one number, and the A/P aging breaks it down by vendor and by age. When the two agree, every dollar in the account belongs to a named vendor. When they disagree, some entry reached the account without the vendor detail the aging needs.

Agreement is only half the job. An aging can tie to the penny and still list a bill you paid in March, if the payment was recorded as an expense that never touched the bill. In that case both the expense and the open bill sit in the books. Expenses are overstated, and so is the liability. The second half of the review, reading the aging line by line, is where those errors show.

Businesses with related companies add another layer. Amounts owed between entities often run through payables, and they must agree on both sides. [Recording intercompany transactions in QuickBooks](/blog/intercompany-transactions-in-quickbooks) covers how to keep those balances matched across company files.

## Running the QuickBooks A/P aging summary against the balance sheet

The first test compares two reports run the same way: the A/P Aging Summary and the Balance Sheet, both as of the period end and both on the accrual basis. If the settings differ, the totals differ for reasons that have nothing to do with errors. Fix the settings before you look for problems.

Intuit's help article [Match your aging reports](https://quickbooks.intuit.com/learn-support/en-us/help-article/financial-reports/get-aging-reports-match/L9T7gcIJw_US_en_US) is written for QuickBooks Online and lists the settings that cause false differences:

- **Aging method.** The article says a mismatch is usually because the aging report defaults to current. Open the report, select **Customize report**, and under **General Options** set **Aging** to the **Report date** option.
- **Accounting method.** Run the Balance Sheet or Trial Balance on **Accrual**. A cash-basis balance sheet strips out unpaid bills, so it cannot agree with an aging.
- **Date range.** Both reports must be as of the same date.
- **Right numbers.** Compare the A/P total on the aging with the A/P line on the balance sheet, not with total current liabilities.

The article walks through the receivables aging, so check that your payables aging uses the same choices. Then compare.

### A worked A/P tie-out

The figures below are an example for a small company at September 30. They are made up to show the method.

| Line | Amount |
| --- | --- |
| Accounts payable per Balance Sheet (accrual, Sept 30) | 48,615.00 |
| A/P Aging Summary total (report date aging, Sept 30) | 47,365.00 |
| Difference to explain | 1,250.00 |
| Journal entry crediting A/P with no vendor, Sept 28 accrual | 1,250.00 |
| Remaining difference | 0.00 |

Once the totals agree, the work moves to the aging lines themselves. In this example, a closer read later finds one bill of 2,180.00 already paid by check and one vendor credit of 400.00 left unapplied. Neither changes the tie-out, because both sides of each error are already in A/P. Both still need fixing.

## QuickBooks open bills that were already paid by check or expense

A bill stays open in QuickBooks when the payment was entered as a check or expense instead of through Pay bills. The check credits the bank and debits an expense account. The bill still credits A/P. Nothing links them, so the expense is counted twice and the bill ages forever.

You find these by sorting the aging detail by vendor and looking for old bills from vendors you pay promptly. A 90-day-old utility bill is a strong sign. Open the vendor's transaction list and look for a check or expense near the bill's date for the same amount.

There are two ways to fix it:

1. **The bank line is not reconciled yet.** Delete or void the check, then record the payment through **Pay bills**, using the same date, bank account and check number. The bank register shows the same amount, and the bill closes.
2. **The bank line is already reconciled.** Leave the cleared amount alone. Change the check's category line from the expense to Accounts Payable, with the vendor named. That is the pattern Intuit's help on supplier refunds uses to link a deposit to a vendor credit. Then link the check to the bill through **Pay bills** with a total payment of 0.00. Test this on one bill first, and confirm the reconciled bank balance does not move.

Watch the period. If the check fell in a closed month, the expense change alters a period that may already be reported. Post the correction in the current period with a note, or ask whoever signed off on the close.

## Vendor credits in QuickBooks that never applied

An unapplied vendor credit is a credit memo from a vendor that sits in A/P without being matched to a bill. The aging shows it as a negative line, and the vendor's open bills look larger than what you really owe. The fix is to apply the credit to a bill or to a refund.

Intuit's article on [entering supplier credits and refunds](https://quickbooks.intuit.com/learn-support/en-global/help-article/supplier-credits/enter-refund-supplier/L2y1KARni_ROW_en) describes the steps. Create a **Pay bills** transaction and select the bill. QuickBooks applies the available credit, and you check the **Credit Applied** amount before you save. If the vendor sent the credit back as cash, record a bank deposit with the vendor in **Received From**, choose Accounts Payable on the line so it links to the credit, then use **Pay bills** to match them with a total payment of 0.00.

Before applying old credits, confirm with the vendor that each credit still exists. A credit memo entered two years ago may already have been taken on a payment outside QuickBooks, or the vendor may have expired it. Applying a credit the vendor no longer honors understates what you owe.

## Which journal entries to QuickBooks A/P distort the aging?

Journal entries distort the aging when they post to Accounts Payable without the right vendor, or when they record an amount a bill already records. Accruals, reclasses and opening balances are the usual sources. Every A/P line in a journal entry needs a vendor, and every accrual needs a reversal.

Look for three patterns in the A/P account's transaction detail:

- **An accrual with no reversal.** A month-end accrual for a bill that has not arrived should reverse when the real bill is entered. If it does not, the liability is counted twice.
- **A reclass between vendors.** Moving a balance from one vendor to another with a journal entry works on the balance sheet, but it leaves both bills open on the aging.
- **An opening balance entry.** Converting from another system often brings the A/P balance in as one journal line. The aging then has no detail for it until someone enters the individual open bills.

Take an example: a 1,250.00 accrual posted on September 28 with no vendor. The balance sheet includes it, but the aging cannot, so the two totals differ by exactly that amount. Adding the vendor on that line, or recording the bill and reversing the accrual, closes the gap.

The same three patterns appear in larger systems. A company that moves from QuickBooks to NetSuite carries its payables tie-out habits with it, and the cash side of that system is covered in the [NetSuite bank reconciliation guide](/blog/netsuite-bank-reconciliation).

## Checking QuickBooks payables against vendor statements

A tied-out aging can still be wrong if a bill was never entered. The aging cannot show what is missing from the books. A vendor statement can. Compare each major vendor's statement balance at the period end with that vendor's balance on the aging, and explain the difference.

Differences usually fall into a few groups:

- **Payments in transit.** You paid on the 29th, and the vendor recorded it on the 2nd. This is timing and needs no entry.
- **Bills not entered.** The vendor billed in September, and the bill is still in someone's inbox. Enter it in September.
- **Credits on one side only.** The vendor issued a credit you never recorded, or you recorded a credit the vendor never issued.
- **Pricing or quantity disputes.** These need a decision, not an entry, until they are settled.

Pick vendors by size and by risk. Your five largest suppliers and any vendor whose balance moved sharply are a sensible start. Payables kept in Quicken work differently, because Quicken tracks a register rather than a vendor ledger; [matching a statement in Quicken](/blog/quicken-reconcile) covers that side.

## When not to clear old QuickBooks payables with one adjustment

Do not write off a block of stale open bills with a single journal entry until you know why each one is open. Old bills can hide duplicate payments, vendors that do not exist or payments made outside the books. A blanket adjustment erases the evidence along with the balance.

Investigate first, and sort each stale bill into one of three groups:

1. **Paid but not linked.** Fix it with the steps for open bills paid by check or expense.
2. **Truly owed.** Keep it, and ask the vendor why they have not chased it.
3. **Unexplained.** Hold it in a list with the vendor name, amount, date and who entered it.

The third group deserves attention. A pattern of round-sum bills from one vendor, a vendor with a home address that matches an employee's, or bills paid twice by different methods can point to fraud rather than sloppy entry. The [difference between a forensic audit and a financial audit](/blog/forensic-audit-vs-financial-audit) explains when that kind of finding calls for a different engagement.

On the cash side of the same review, PreciseBankFlow foots each bank statement and flags duplicate payments with the same payee and amount on close dates, which is often where a double-paid bill first shows. It is opening to CPA and audit firms in small groups, and you can [request access](/get-started).