These are the fields worth recording per lump payment so the one-to-many split stays clear and any single invoice can be traced back to it. Treat the per-invoice lines as a small repeating block inside the record.
- Allocation record name / ID
- A stable label for the payment itself, e.g. PAY-2026-0412-Northgate, so invoices can reference it.
- Payment date
- The date the money was received, distinct from any invoice date.
- Total amount received
- The single lump figure that arrived; the per-invoice allocations must sum to this.
- Payment method and reference
- Bank transfer, check number, or card settlement, plus any reference the client quoted.
- Paying client
- Which client sent the payment, so it is filed in the right client area and misapplied-to-wrong-client cases are obvious.
- Per-invoice line: invoice number
- One line for each invoice the payment touched, identified by its invoice number.
- Per-invoice line: invoiced amount vs allocated amount
- The invoice's full amount alongside the portion of this payment applied to it, so partial coverage is visible.
- Resulting invoice status
- Paid in full or partly paid with the remaining open balance, mirrored onto the invoice record itself.
- Correction note
- If re-allocated, a dated note of the original mapping, what moved, and why.
- Remittance attachment
- The deposit confirmation, check image, or client remittance advice supporting the split.