Examples
Examples
Try the starting example
- Invoices: ID, due date, face $, discount deadline, discount %
- A,2026-10-22,100,2026-10-20,2 B,2026-10-25,200,2026-10-01,0 C,2026-10-31,150,2026-10-01,0
- Payment date
- 2026-10-20
- Include invoices due through
- 2026-10-31
- Cash budget ($)
- 250
- Full-invoice cash payments in due-date order ($)
- A: 98.00; C: 150.00
- Total cash paid ($)
- $248.00
- Face value settled ($)
- $250.00
- Discount taken ($)
- $2.00
- Unused cash budget ($)
- $2.00
- Unsettled invoice face values ($)
- B: 200.00
Try another scenario
- Invoices: ID, due date, face $, discount deadline, discount %
- A,2026-10-22,100,2026-10-20,2 B,2026-10-25,200,2026-10-01,0 C,2026-10-31,150,2026-10-01,0
- Payment date
- 2026-10-20
- Include invoices due through
- 2026-10-31
- Cash budget ($)
- 300
- Full-invoice cash payments in due-date order ($)
- A: 98.00; B: 200.00
- Total cash paid ($)
- $298.00
- Face value settled ($)
- $300.00
- Discount taken ($)
- $2.00
- Unused cash budget ($)
- $2.00
- Unsettled invoice face values ($)
- C: 150.00
Calculation method
Calculation method
Full-invoice cash payments in due-date order ($)
Sort eligible due dates, use a discount only if payment date is on/before its deadline, and pay the full discounted invoice if it fits the remaining cash budget; otherwise skip it.
Total cash paid ($)
Sum accepted full payments.
Face value settled ($)
Sum original face values of accepted invoices.
Discount taken ($)
Settled face−cash paid.
Unused cash budget ($)
Entered budget−cash paid.
Unsettled invoice face values ($)
List every invoice not settled by this run, including future invoices beyond the cutoff.
Symbols and units
- a
- Invoices: ID, due date, face $, discount deadline, discount %
- b
- Payment date
- c
- Include invoices due through
- d
- Cash budget ($)
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A deterministic full-invoice payment selection in due-date order, not an optimal discount strategy or payment authorization. Discounts are supplied contract assumptions. No partial payment or bank transfer is performed.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
OpenStax: financial-accounting model background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.