How to match one payment to multiple invoices

Start with the payer name, customer ID, bank originator, remittance email, check number, and any invoice references. Map known parent-company or treasury names through explicit aliases that a reviewer can inspect.

Do not search every invoice across every customer solely because the totals might agree. Coincidental combinations become common as the open invoice list grows.

Keep only open invoices with compatible currency, a plausible customer relationship, and dates consistent with the payment. Prefer directly referenced invoices. Apply a documented limit to candidate count and combination size.

Narrowing improves both speed and quality. It also makes the final explanation easier to review because every candidate passed the same initial scope rules.

Convert amounts to cents and search subsets that equal the payment. A bounded depth-first search or dynamic approach can work for a small, narrowed list. Stop or warn when limits are reached rather than allowing a large import to freeze the interface.

Return every plausible exact combination within the limit. If two sets produce the same total, the result is ambiguous until other evidence separates them.

Show invoice number, date, customer, open balance, and proposed applied amount for every selected invoice. The payment total should equal the sum of applications plus any visible unapplied amount.

When one invoice is only partly covered, preserve its remaining balance. A combined payment can contain full and partial applications in the same decision.

Create separate links between the payment and every invoice rather than storing a comma-separated invoice list. The audit record should include the matching method, reasons, reviewer, source file, and decision.

After confirmation, verify the destination accounting ledger and keep any remittance evidence according to the organization's retention policy.