Overdue balance divided by all outstanding EUR.
Days past due
Invoices due today are current. Each open balance appears once.
How the rows add up
Invoice details
| Invoice ID | Issued | Due | Invoice EUR | Paid by date | Open EUR | Status / exception | Action |
|---|
How dates, receipts and exclusions work
Use one currency, EUR. Each invoice has one positive total. Enter each receipt as YYYY-MM-DD=amount and separate multiple receipts with a semicolon. Blank means no receipts. Payments on the reporting date count. Payments after that date stay in the row and are excluded from cash received at the snapshot date.
Every row sharing an invoice ID is excluded, ignoring letter case and spaces at either end. Future invoices, missing dates, due dates before issue, invalid amounts, overpayments and receipts preceding issue are excluded. Overpayments are checked against all entered receipts, including future ones. Credit notes and mixed currencies need a separate ledger.
Import or save a private CSV
CSV columns must be id,issued,due,amount,receipts,note. A quoted field can contain commas or a line break. Import replaces the current rows after confirmation. The data stays in this browser tab.
Prepare the review slides
Download a three-slide snapshot with an editable balance summary, ageing table and meeting note. The PowerPoint includes aggregate amounts and your meeting note. Individual invoice IDs, row notes and email addresses from the ledger are omitted.
Adapt the review to your team
Ask about a scoped dashboard or editable presentation using an anonymised example and your reporting definitions.
Request a scoped review ↗Local working copy · No account connection, automatic upload, payment collection or recovery after you close the tab. Download your CSV to keep a copy of the rows.