An invoice overpayment needs a verified reconciliation

Confirm the excess is real before explaining it

Start with the posted receipt in the bank record, not a report or an expectation: the amount, the currency, the date and a masked reference. Then recompute what was actually owed. An invoice's current balance can be wrong because a credit note, an earlier partial payment or a price correction was never reflected, and an apparent overpayment can shrink to nothing once the true balance is used.

Keep the comparison in one currency and against one invoice. An excess measured against the wrong invoice, or against a converted figure, is an artifact of the comparison rather than of the payment. Only when the posted amount demonstrably exceeds the verified balance does the question become which of the explanations fits.

Test the duplicate-remittance explanation

One record explanation is that the buyer paid the same invoice twice: two transfers in the same payment run, a portal payment and a bank transfer, or a retry before the first payment had visibly posted. Pull every receipt on that buyer's account for the period, compare references and dates, and check whether two of them name the same invoice.

A duplicate remittance is a buyer error with a clear correction path, but the path still runs through confirmation. Record both receipts, the invoice they both reference, and the amount that is genuinely unowed. Do not net the duplicate against a different open invoice as a shortcut; that converts the buyer's error into your allocation decision, and the buyer never authorized it.

Test the allocation-error explanation

The second record explanation is that the money was intended for a different invoice or a different buyer entity and was applied here by mistake — by the buyer, or by your own recording. QuickBooks' payment record ties together customer, invoice, amount and an optional reference or memo; read the reference the payment actually carried against the invoice it landed on. A reference naming another invoice is the allocation error made visible.

If your side misapplied the payment, correct it transparently. QuickBooks cautions that linked transactions require care when edited and that deletion can be irreversible, so preserve the original entry's trail and record the correction as a change with a reason, not as a silent rewrite. If the buyer misdirected the payment, their written confirmation is what moves it; your worksheet records the finding either way.

Confirm intent through an established channel

When neither record explanation fits, the excess is a genuine overpayment candidate, and intent becomes the deciding fact. QuickBooks distinguishes an erroneous overpayment from an intentional extra such as a tip; the same excess can be either, and only the payer knows. Ask through the contact channel your records already hold for that buyer — not through contact details supplied inside or alongside the payment itself.

Treat refund instructions that arrive with the payment itself as unverified, not as a service request. A message saying the sender overpaid and asking for the difference to be sent to a new account, a different name or a new bank destination has not been verified by arriving alongside the payment. Do not act on it, do not reply with account details, and hand the case to the designated owner who verifies the payer through the established channel before anything moves.

Close only with an authorized disposition

The verified findings point at three dispositions: a refund of a confirmed duplicate or erroneous excess through the payer's established route and the provider's actual process, a documented credit the buyer has accepted in writing, or a held balance while the buyer decides. Each requires the merchant's designated owner to authorize it, and the worksheet records who authorized what, on which evidence. Not every excess is refundable through a particular method, and none is simply spendable.

Keep the receipt, the payer confirmation and the disposition linked so the correction can be traced in a later audit or dispute. Legal and tax treatment of overpayments belongs with qualified review, not this page. If the excess originated in how your checkout or invoicing flow collects payments, a Prism consultation can review that storefront question; confirm scope, responsibilities, fees and terms before work begins.

Overpayment reconciliation sheet

Use one sheet per excess amount. Work the record explanations before asking about intent, and confirm intent before any disposition. Record masked references and record locations only; never enter full bank details, card data or identity documents.

Worksheet entries are not submitted by Prism’s worksheet and are not saved by the site. Use record types, availability, anonymized observations, or match/mismatch results. Do not enter government identifiers, customer names or addresses, customer messages, receipt-access links, card or bank details, passwords, or keys. Send sensitive documents only through the provider’s verified secure channel.

These are temporary notes. Leaving or reloading this page may clear them. Worksheet entries are not sent automatically. If you copy notes into the consultation message and submit the form, Prism receives them as part of your request.