Examples
Examples
Try the starting example
- JSON Invoices [ID,invoice amount currency,receipts/credits currency,due YYYY-MM-DD] (USD)
- [["A",200,50,"2026-10-27"],["B",100,0,"2026-10-07"],["C",400,100,"2026-09-07"]]
- Report civil date (YYYY-MM-DD)
- 2026-10-22
- Aging cutoffs (increasing days)
- 0,30,60
- Invoice [ID,unpaid currency,days past due] (USD)
- [["A",150,-5],["B",100,15],["C",300,45]]
- Total unpaid (USD)
- $550.00
- Aging buckets (USD)
- [150,100,300,0]
Try another scenario
- JSON Invoices [ID,invoice amount currency,receipts/credits currency,due YYYY-MM-DD] (USD)
- [["A",200,50,"2026-10-27"],["B",100,0,"2026-10-07"],["C",400,100,"2026-09-07"]]
- Report civil date (YYYY-MM-DD)
- 2026-11-15
- Aging cutoffs (increasing days)
- 0,30,60
- Invoice [ID,unpaid currency,days past due] (USD)
- [["A",150,19],["B",100,39],["C",300,69]]
- Total unpaid (USD)
- $550.00
- Aging buckets (USD)
- [0,150,100,300]
Calculation method
Calculation method
Invoice [ID,unpaid currency,days past due] (USD)
Unpaid=invoice−receipts; age=report date−due date in civil days.
Total unpaid (USD)
Sum unpaid invoice balances.
Aging buckets (USD)
≤first cutoff, then (previous,next], then >last cutoff; sum unpaid in each.
Symbols and units
- a
- JSON Invoices [ID,invoice amount currency,receipts/credits currency,due YYYY-MM-DD] (USD)
- b
- Report civil date (YYYY-MM-DD)
- c
- Aging cutoffs (increasing days)
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
- Receipts and credits must be allocated to their invoices; no overpayments (credits≤invoice). Negative days are not yet due. One common currency. Supported limits: At most 1000 invoices; nonnegative amounts, allocated credits≤invoice; 1–20 increasing integer cutoffs.
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.