One payment, several invoices: Build a controlled allocation

Required evidence

• bank row with payer/payee and reference;
• remittance advice where available;
• candidate invoices and their current open balances;
• corrections, credits, or agreed deductions;
• currency and bank-fee detail;
• owner or client explanation for unclear allocation.

Worked allocation: two trainer invoices, one payment

A synthetic Pilates studio pays one trainer €800.00. Two approved freelance invoices are open:

The supplier identity, invoice references and bank beneficiary support the split, and the allocations sum exactly to the bank amount. If the bank amount were €790.00, the €10.00 would stay open until a documented deduction, correction or second payment explained it. It would not be spread proportionally merely because the candidate invoices are close.

The arithmetic does not approve a discount or correction. Supporting agreement and professional review are required.

Review sequence

1. Confirm the legal counterparty and currency.
2. Freeze the payment amount available for allocation.
3. List current open balances before this payment.
4. Apply explicit references and remittance advice first.
5. Add documented credits or deductions.
6. Calculate and display every residual.
7. Review period and accounting consequences.
8. Preserve the final allocation and evidence.

Common complications

The payment may include invoices from two periods, settle a part payment, deduct a customer fee, include a credit note, or arrive net of currency charges. A supplier batch payment can also include many payees behind one payment file. Do not assume the simplest split if the reference and documents disagree.

DeinHans can prepare and represent a bank payment with several candidate invoice allocations and a sum-to-bank control. Current support is deliberately bounded: some allocations require an explicit bookkeeper or accountant action, and ambiguous deductions remain open. DeinHans does not promise that every one-to-many or many-to-one case will be allocated automatically. The accountant retains control over the accepted split and treatment.

Escalate when

• candidate invoices belong to different legal entities;
• the reference conflicts with the amount;
• the proposed discount has no document;
• currency or fee detail is missing;
• an allocation would reopen a settled invoice;
• the same invoice appears in another payment.

The desired result is an evidenced allocation, not merely a fully consumed bank amount.

Allocation controls for suppliers and customers

Customer receipts and supplier batch payments use the same arithmetic but different evidence. A customer may send remittance advice; an outgoing payment run should have an approval list. In both cases, freeze invoices’ open balances immediately before allocation and ensure another payment has not already used them.

If one bank line contains several currencies or the bank nets a fee, do not spread the euro residual proportionally without evidence. Reconcile the original currency first, document the rate and separate the bank charge. A proportional allocation can be a management convenience but must not masquerade as a customer instruction or tax conclusion.

Reverse the allocation safely

If later evidence shows the split was wrong, retain the original allocation history, undo it through the controlled workflow and apply the corrected split. Re-check each affected open item and period. Do not edit invoice balances directly, because that makes the payment appear to have always followed the corrected explanation.

At month end, compare unallocated payment portions with the clearing balance. Age every residual by the date the evidence became available, not only bank date. A stale small residual can reveal a repeated fee, discount practice or report-boundary problem that deserves a policy decision.

Handoff output

Provide the original payment, final allocation table, documents, approved deductions, remaining open items and reviewer. A later user should be able to reproduce the total without reading an email thread. If the payment affects more than one period, show those links explicitly so a correction reopens only the necessary cases.