How do I break open balances into due-date bands for a dated review?
Use outstanding balances only. Items due today are current; overdue bands use UTC calendar days.
Open Open Balance BandsTry the worked example
These are the example inputs from Open Balance Bands. Replace them in the tool to run your own case.
| Invoice code | Due date | Review date | Open EUR |
|---|---|---|---|
| I-17 | 2026-10-15 | 2026-11-01 | 180 |
| I-32 | 2026-09-15 | 2026-11-01 | 260 |
| I-40 | 2026-11-02 | 2026-11-01 | 300 |
Example result
€440.00 past due
Who uses this?
Accounts receivable reviewer. The free online tool runs the calculation in your browser. To edit the files and use the tools offline in one business, see the €49 offline edition.
Where the idea came from
Break open balances into due-date bands for a dated review. The business case pairs prepared back-office work with a person responsible for exceptions. Benchcraft designed this tool’s inputs, decision rule and example for this office task.
Original video