Reporting
A multi-company weekly financial dashboard
One dashboard gathering receivables and payables across several companies, producing a weekly summary.
- Usage
- Bespoke project
- Role
- Design, development, data migration
- Year
- 2026
- Duration
- Delivered
01
Problem
In a group of several companies, seeing the cash position meant opening each company’s file and adding them up. Before the weekly meeting somebody had to sit down and compile a summary by hand; the numbers were then argued over during the meeting, because nobody was sure which file was the latest.
02
Approach
We defined the companies as hierarchical groups, so a single company and a group total can be read from the same dashboard. Data entry happens in panels that open without leaving the list — the user never changes page. The existing spreadsheets were cleaned and imported, and export was left in the same shape so the habits on the accounting side were not disturbed.
03
Result
The weekly summary is no longer compiled by hand; it is read off the dashboard. With receivables and payables in one place, it is visible before the meeting which company needs cash. XLSX import and export were kept.
Next system
