Which invoices make this deposit?
A deposit against forty open items. Exact subset-sum over minor units — no floating point.
- Runs
- In this tab
- Data sent
- None
- Rounding
- Once, at the end
- Also in
- The Chrome extension
Which invoices make this deposit?, worked
Showing a worked example — type over it
Result
How the which invoices make this deposit? works.
Subset finder: A deposit of 14,203.55 against 40 open invoices: which combination sums to it? Meet-in-the-middle over minor units — exact, not floating point.
Quoted from the toolbelt spec, the document this tool was built against.
Where these numbers come from.
Negatives are parenthesised because that is what a statement does. The rest is four promises.
Minor units, never floats
Amounts are integers in the currency's smallest unit, end to end. A float never touches a cent.
Rounded once
Rounded once, at the end — never per operand, which is how a split stops summing to the whole.
Unit tested
The arithmetic lives in one unit-tested module, shared without reimplementation with the extension.
No network
There is no request to make. What you type stays in this tab and is gone when you close it.
More in reconciliation & investigation
- Difference diagnoserOut by 8,100? That is divisible by 9 — a transposition. This says which error fits the gap.
- Two-list matcherBank against ledger: exact, then reference, then a date window, then one-to-many — and what is left on both sides.
- Duplicate paymentsSame vendor, same amount, close in time — plus the same reference whatever the date.
- Benford & round numbersTwo cheap tests over a pasted column. Neither proves anything; both tell you where to look.
The same number, elsewhere.
A calculator answers the question once. These carry the answer into a product, name what it computed, and argue the method.
- ComponentCashApplicationThe highest-value screen in AR. Every case, not just the happy one.
- ComponentPaymentSuggestionInvoice combinations summing exactly to a lump sum.
- ComponentUnappliedCashPanelNever revenue; net credit balances flagged as liabilities.
- TermApplicationAssigning received cash to specific invoices
- TermUnapplied cashCustomer cash received but not yet assigned to an invoice. It reduces that customer's AR; only a net credit balance is reclassified to a liability at period end
- TermDeposit in transitA receipt recorded in the book cash account but not yet on the bank statement — added to the bank balance in a reconciliation
- DocOrder to cash (AR)The complete receivables stack: quote → order → fulfilment → invoice → collection → cash application → revenue.
- DocCurrency decimal placesHow many decimals each ISO 4217 code is stored at — JPY 0, USD 2, KWD 3.