Open Balance Bands
Break open balances into due-date bands for a dated review.
Prepare your sheet
Use one row per invoice code observation. Enter Due date, Review date, Open EUR. Check that every row belongs to the same review scope.
Decision rule
Use outstanding balances only. Items due today are current; overdue bands use UTC calendar days.
Worked result
The fictional example contains 3 input rows. Its result is €440.00 past due.
| Invoice | Days past due | Band | Open |
|---|---|---|---|
| I-17 | 17 | 1–30 | €180.00 |
| I-32 | 47 | 31–60 | €260.00 |
| I-40 | 0 | Current | €300.00 |
Run it on your own inputs
- Open the tool and choose Start empty or edit the example.
- Enter the inputs, resolve validation messages and review the decision sheet.
- Download the text report or print the summary for the responsible person.
Source and support
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. Reviewed source · Greg Isenberg at 1:45.
Discuss an anonymised receivables review. €99 one-time pilot after scope agreement for an ageing report and editable deck.