Match Plumbing Invoice Payments in QuickBooks Without Duplicates

Understand match versus new record

Intuit describes matching as linking downloaded transactions to records already in QuickBooks. Categorizing can create a new record instead. Its guidance also warns users to verify actual payment before matching to an open invoice or bill. Official source

Those are product behaviors documented by Intuit as reviewed in September 2026. Menu labels and availability can change; use the linked official instructions for the current interface. Official source

The workflow below adds an original plumbing-office review checklist. It does not replace an accountant's reconciliation process.

Find the invoice and payment evidence first

Check the invoice number, customer, amount, date, and transaction reference. If one payment covers several jobs, identify the allocation rather than assuming the bank amount belongs to only one invoice.

A similar amount is useful evidence but not sufficient on its own. Two customers can owe the same amount on the same day. A stable payment reference and the associated customer or invoice record make the relationship clearer.

Review a proposed match

Payment-match review
Downloaded transaction reference: [ID]
Bank amount and posting date: [details]
Existing invoice/payment references: [IDs]
Customer identity verified: [yes/no]
Gross payment, fee and net deposit relationship: [details]
Partial or multi-invoice allocation: [details or none]
Already matched or reconciled elsewhere: [check]
Evidence supporting the match: [references]
Reviewer and result: [name/date]

Do not create a second sale simply because the existing record is not immediately visible. Investigate the record, filters, and connection behavior first.

Handle differences as questions, not rounding errors

Suppose a fictional customer payment is $500 but the bank receives $485 after an illustrative $15 processing fee. The $15 difference needs the correct accounting treatment; it is not automatically a customer short payment or a discount.

A payout containing several payments creates another kind of difference. Keep the batch-to-payment relationship visible instead of forcing the full deposit against one invoice.

The amounts here are examples, not actual processor fees or instructions for a particular journal entry. Have your accountant establish the treatment used in your books.

Check partial payments carefully

If a customer pays $200 toward an illustrative $600 invoice, the allocation should leave $400 due, assuming no other adjustments. Do not match an unrelated $400 deposit merely because it equals the remaining balance.

A reported payment is not necessarily verified. Use the actual transaction evidence and status before changing the invoice record.

Correct mistakes through the supported process

Intuit provides instructions for undoing or unmatching downloaded transactions. It specifically advises consulting an accountant before changing transactions that have already been reconciled.

Preserve the original references and document what was corrected. Deleting records without understanding their relationships can make later reconciliation harder.

Make the handoff repeatable

Give the bookkeeper a list of unmatched items with invoice references, transaction evidence, and the specific question to resolve. “QuickBooks is wrong” is less useful than “this batch deposit contains three payments but only two allocations are identified.”

A reliable matching process explains every relationship. It should not depend on someone recognizing an amount from memory.