Overdue by age
Open balance past its due date, by how long it has been late. One row per company.
Overdue invoices
Oldest first. Key accounts are grouped with their own subtotal, the way the finance team wanted to see them.
Waiting and overpaid
Not yet due, and paid more than invoiced. Both need a different action than a reminder.
What the real version did.
The same tables, inside Google Sheets, built by an Apps Script from five exports: the accounting system plus each marketplace. Column cleanup, the split into overdue, waiting and overpaid, subtotals for the key accounts, the age buckets, and a roll-up sheet with one column per company. The team kept working in the spreadsheet they already knew. They just stopped building it by hand.
If your finance team builds something like this every week, the first project is this report on your own exports, in a week, from €400. Tell me what the exports look like ›