Sign in
Enter your registered email. There is no password. Only emails registered by an administrator can open the dashboard.
Upload the first monthly report
Choose the AR & AP aging workbook. The dashboard summarises it in graphs and saves it for the team. Upload next month's report the same way and the dashboard shows whether things improved.
What the file needs to contain
Use the monthly WK & EK – AR & AP Aging workbook as it is. The dashboard reads one sheet per company for each side:
- Receivables —
WK AR as of …andEK AR as of …. If there is more than one date, the sheet matching the report date is used. - Payables —
WK V18 AP UnfoldedandEK V18 AP-Unfolded. V11 sheets are left out, the same as on the Summary sheet. - Report date — the “as of” line on the
Summarysheet.
Each of those sheets needs its header row with the aging columns
(Not due or At Date, 1 - 30 … Older).
Dashboard, PDC and PO sheets are ignored.
Receivables by age
Payables by age
Month by month
Total receivables, payables and net at each saved report
Largest customer balances
Largest vendor balances
Account tables
Accounts receivable
Accounts payable
Register an email
Only the emails registered here can open the dashboard. There is no password — each person signs in by typing their email.