Use outstanding balances only. Items due today are current; overdue bands use UTC calendar days.
Reconciliation / Accounts receivable reviewer
Open Balance Bands
Break open balances into due-date bands for a dated review.
01 / Inputs
Working sheet
Edit any cell to recalculate. Use anonymous references. Data stays in this browser tab and clears when you reload.
| Invoice code | Due date | Review date | Open EUR | Row |
|---|
02 / Review
Decision sheet
| 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 |
Discuss an anonymised receivables review
€99 one-time pilot after scope agreement for an ageing report and editable deck.
The free tool runs independently on your device.