One remittance is meant to pay several invoices

The remittance advice is the instruction, not the bank credit

The bank credit tells you a total and a date. It does not tell you which invoices the buyer intended to settle. That intent lives in the buyer's remittance advice, portal payment note or covering message, and that document is where the allocation starts. Pull the stated invoice references before opening the ledger, and copy them into the worksheet exactly as the buyer wrote them.

If no remittance advice arrived, the allocation is unconfirmed from the first minute. Request the breakdown from the buyer's accounts-payable contact rather than reconstructing it from amounts. A reconstruction that matches neatly is still a reconstruction; the buyer can have combined invoices you consider separate, paid one invoice twice by mistake, or included an invoice you have not issued yet.

List candidates from one buyer's account only

Draw the candidate list from the open invoices of the buyer who sent the remittance. Include each invoice's number, open balance, currency and due status, and mark any that are already disputed or part-paid. Do not quietly drop rows that make the arithmetic awkward; a candidate that refuses to fit is information, not clutter.

Keep the boundary at the buyer's own account. An amount that matches an open invoice belonging to a different buying entity or a different customer does not authorize you to allocate across those accounts. Cross-entity allocation is a commercial decision that requires its own authorization from the buyer in a form your records can keep; the remittance total alone supplies none.

Apply stated references first, amounts second

Apply the received amount to the references the buyer stated, even where a stated reference's amount differs from that invoice's open balance. QuickBooks' model supports this directly: the payment record identifies the customer, the invoice and the amount, and a partial payment simply leaves a balance on that invoice rather than forcing a choice between all and nothing. Record the applied amount per reference and the balance each invoice keeps.

Then sum the allocations and compare the total with the verified received amount. If they agree, the allocation is complete only to the extent the stated references cover it. If they differ, the difference stays on the worksheet as a leftover or a shortfall. Do not absorb a leftover into whichever invoice is nearest, and do not stretch a shortfall across invoices the buyer did not name.

Record the allocation so it survives later editing

Use the payment record's reference or memo field for the buyer's remittance identifier, so anyone reviewing the entry later can see why the money was split this way. The goal is that the ledger entry, the worksheet and the buyer's advice all point at each other without a verbal explanation from the person who did the work.

QuickBooks cautions that linked transactions require care when edited and that deletion can be irreversible. Treat corrections to an allocation the same way: preserve what was originally recorded and add the correction as a traceable change rather than quietly rewriting history. If an allocation turns out to be wrong, the record of the wrong version is part of how you explain the fix to the buyer.

Leave the unidentified amount explicitly unresolved

A remainder can be an overpayment, a reference to an invoice outside your candidate list, or a buyer error. QuickBooks' guidance distinguishes an erroneous overpayment from an intentional extra, and only the payer can say which this is. Until the buyer answers, the unidentified amount stays as its own line with a named owner, not as a rounding entry or a quiet credit.

Send the buyer's accounts-payable contact a specific question: the remittance total, the references you applied, and the exact unidentified figure. Name the finance contact inside your business who holds the open item, so it is neither silently closed nor applied twice when the answer arrives. If missing remittance detail keeps originating in how your checkout or invoicing flow captures references, a Prism consultation can review that storefront question; confirm scope, responsibilities, fees and terms before work begins.

Remittance allocation worksheet

Complete one sheet per received remittance. The buyer's stated references control the allocation; amounts support but never replace them. Mark the allocation confirmed only where a stated reference or a written buyer answer covers it, and keep full bank details in your authorized systems rather than on this sheet.

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.