Key takeaway: Investigate old accounts payable item by item. Confirm the obligation, original posting, payment and vendor credit before changing it. An old balance may be valid, and an unapplied payment may affect open-item presentation without overstating net A/P.
This article is part of our guide to QuickBooks cleanup and bookkeeping controls.
An aging report with old bills deserves attention, but age alone does not prove an accounting error. A vendor may still be owed, an issued check may be awaiting deposit, or a payment may be recorded correctly but linked to the wrong invoice. Cleanup should explain these differences and correct supported errors while preserving the evidence behind each decision.
Separate three questions before making an entry
What is still owed? The invoice, receiving records, contract, vendor statement and correspondence establish the commercial facts. A bill can remain payable despite an overdue date or a missing statement.
What has been recorded? Review the accounts and vendor assigned to each bill, credit and payment. Two records for the same transaction can create a duplicate, but two transactions with matching amounts can also be unrelated. An equipment invoice affects an asset account; its correction should not automatically become a current expense adjustment.
What happened to the money? Confirm issuance, delivery, bank clearance, returns and refunds. Payment initiation, payment recording and bank settlement occur at different stages. A bookkeeping void does not itself stop a check at the bank or resolve the vendor’s underlying claim.
Preserve a useful starting point
Choose a review cutoff, then save the A/P aging detail, vendor balances, general-ledger A/P detail, trial balance, outstanding-check list and bank reconciliations for that date. Keep the report settings, accounting basis and filters with the exports so comparisons use the same population. Include historical records when an item crosses periods.
Distinguish a reference export from a recoverable backup. Intuit’s QuickBooks Online export instructions cover reports, lists and other data; an Excel export is not automatically a complete file that can restore every transaction and attachment. Confirm the recovery coverage available for your product before substantial changes. Preserve original invoices, payment evidence and approval records separately.
Create a working list with one line for each questioned item: vendor, invoice or check reference, date, amount, reason flagged, supporting documents, proposed action, approver and unresolved follow-up. Keep the starting list unchanged and add the resolution history. That makes a later review possible without reconstructing what the books looked like before cleanup.
Read open items and net A/P together
Suppose a $2,400 bill credits A/P and a separately recorded $2,400 payment debits A/P for that same vendor. If they are not linked, the report may still display the open bill and offsetting payment. The net A/P effect is zero. Applying the existing payment fixes the connection; recording another $2,400 expense or payment would create a new error.
The outcome differs if the original payment was coded directly to an expense while the bill also recorded that expense. That can duplicate expense and leave the bill payable in the ledger. Inspect the transaction details before choosing a correction. A matching amount is a lead to investigate, not proof that a credit represents that payment.
QuickBooks Online can show Unapplied Cash Bill Payment Expense on a cash-basis profit-and-loss report when bill payments precede bills or remain unmatched. Review the actual vendor, dates and source documents. Do not invent a bill or change its date solely to remove that report line. A software cash-basis presentation also does not settle the federal tax treatment.
Accounts Receivable and Payable is covered in more depth in our related article, “Accounts Receivable and Payable: What Your Financial Statements Reveal.”
Choose the action supported by the records
| Finding | What to establish | Supported next step |
|---|---|---|
| Old unpaid bill | Goods or services received, agreement, vendor balance and any dispute | Keep the valid obligation; arrange payment or document the actual resolution |
| Unapplied payment | Original posting, correct vendor and intended invoice | Link or correct the existing transaction; separately track clearance |
| Apparent duplicate bill | Whether both entries refer to the same underlying purchase | Correct the duplicate in the appropriate period with an approval trail |
| Legitimate unused vendor credit | Credit memo, restrictions, applications and remaining entitlement | Apply to the proper bill, obtain a refund or retain documented follow-up |
| Uncashed check | Bank history, delivery, replacement activity and continuing obligation | Control the original instrument before replacement; assess unclaimed property |
| Unsupported balance | Missing invoice, migration entry, opening balance or other origin | Request evidence and escalate unresolved material items |
For a duplicate, trace associated payments, credits, sales tax, inventory and project allocations as well. Removing one record without inspecting its links may reopen a bill, erase valid history or leave another account wrong. If a correction affects a closed period, agree on the accounting treatment before editing the old transaction.
Give legitimate vendor credits a resolution path
First determine whether the credit represents returned goods, an allowance, a prepayment, an overpayment or an incorrect posting. Compare the vendor’s credit memo with applications already made. Request a current statement when the remaining amount is uncertain.
For a verified credit against bills in QuickBooks Online, the vendor-credit and Pay bills workflow lets you apply the credit to the chosen bill. Review the amount applied and any remaining payment before saving. For a cash refund, the workflow depends on whether the original purchase was a bill, expense or check; paid-bill refunds require the appropriate A/P links. Use Intuit’s vendor-credit and refund instructions for the matching transaction type.
If the business will no longer buy from that vendor, ask whether the credit can be refunded and retain the response. If entitlement is disputed, or the vendor has closed, document the remaining rights and recovery efforts for review. Do not erase a supported credit simply because no new bill is available. Likewise, a refund already received should not remain available for a second application.
Handle outstanding checks without paying twice
A correctly issued bill payment can be applied to its invoice before the bank clears the check. The bank reconciliation then carries the outstanding item until it clears or another supported event changes its status. Waiting for clearance before linking every bill payment confuses these separate tasks.
Before replacing a lost check, confirm that it has not cleared, contact the vendor, and follow the issuing bank’s stop-payment or cancellation procedure where appropriate. Record the status and duration of any stop order, the replacement reference and the vendor’s instructions. Coordinate with whoever approves payments so the original and replacement are not both released or paid.
If the check was sent through QuickBooks Bill Pay, use that service’s cancellation or void-request process and verify its completion. A request can still be processing. Intuit’s current Bill Pay instructions distinguish scheduled payments and shipped checks. Do not treat editing the accounting record as confirmation that the payment service has stopped the funds.
Unresponsive payees require a separate unclaimed-property review. Identify the property type, owner address, last relevant activity and applicable state. Florida’s current Chapter 717 provides dormancy, holder due-diligence, reporting and remittance rules. An old check is not automatically available income for the business. A bank’s stale-check policy and the state’s abandonment rules serve different purposes.
Review tax consequences separately from the software correction
A cancellation of debt, a purchase-price adjustment and a recovery of a prior deduction can produce different tax consequences. Review the actual event and original treatment before using a current-year expense reversal as a catch-all entry.
IRS Publication 334’s deductible-debt example explains the distinction for unpaid accounting services. A cash-method taxpayer generally has no cancellation income to the extent paying the liability would have created a deduction. An accrual-method taxpayer that already deducted the expense generally includes the forgiven amount in income, absent an applicable exclusion. The example assumes genuine forgiveness; merely deleting a bill does not establish it.
Section 108(e)(2) and (5) separately address deductible liabilities and qualifying seller reductions of purchase-money debt. A qualifying price reduction can adjust property basis. Preserve the agreement and asset history rather than treating every reduction as ordinary income or an expense credit.
Provide the preparer with the business’s actual tax classification, accounting method, filed returns and original deductions. An LLC label alone does not establish which return or taxpayer is affected. Material prior-period errors, asset changes and debt settlements may require treatment beyond the current bookkeeping entry.
Reconcile and document the completed work
Rerun the vendor detail and aging using the original cutoff and settings. Tie the vendor subledger total to the general-ledger A/P control account. Investigate differences such as direct journal entries without the correct vendor, inconsistent dates or filters, and transactions assigned to another A/P account. A clean-looking aging report alone is insufficient.
Complete the bank reconciliation separately, retaining supported outstanding checks and deposits in transit. Check that each correction affected cash, expenses, assets and vendor balances as intended. Keep a before-and-after comparison and explain material changes. Unresolved items should have an owner and a follow-up date; they do not need to disappear for the review to be documented honestly.
Confirm the cleanup engagement
CPA Firm South Florida’s published preparation pricing includes bookkeeping cleanup needed for the quoted tax return. Record condition affects the quote. Standalone reconstruction beyond that agreed return scope and ongoing bookkeeping are separate engagements; cleanup does not become an add-on merely because the necessary return work is substantial.
When requesting help, identify the affected periods, unresolved vendor balances, available statements and any filed-return concerns. Ask the engagement description to specify the review cutoff, responsibilities, deliverables and treatment of work outside the agreed scope. A record-correction engagement does not by itself mean an assurance review of financial statements.
Frequently asked questions
Should old vendor bills be written off automatically?
No. Age triggers investigation. A supported unpaid obligation remains a liability until a documented event justifies changing it; a duplicate or erroneous entry needs a different correction.
Does an unapplied payment always overstate accounts payable?
No. If the payment already debited A/P, it may offset the open bill in the net balance while both items remain visible. Trace the posting and application before changing amounts.
Must a check clear before I apply its bill payment?
A correctly issued and recorded bill payment can be linked to its bill before bank clearance. Reconciliation separately confirms whether the check cleared or remains outstanding.
How should an unused vendor credit be handled?
Confirm its origin and remaining value with the vendor. Apply it to an eligible bill, request a refund where available, or document why it remains open while rights or disputes are investigated.
Can a cleanup affect a filed tax return?
Yes. The original deduction, asset treatment, tax method and correction period matter. Review the tax consequences before changing a closed period or assuming that every adjustment belongs in current-year expenses.