Replace the monthly report someone builds by hand
Board packs, funder returns and management reports assembled from several spreadsheets at the end of every month. We bring the figures into one source and make the report refresh on a schedule.
What it looks like today
At the end of each month or quarter, someone exports figures from the finance system, the CRM and two or three spreadsheets, pastes them into a template and adjusts the formulas until the totals look right. It is careful work, done under deadline, and it often depends on one person who knows which columns to use.
The figures are only as reliable as the last copy and paste. Definitions drift between months. When a trustee, a board member or a funder asks how a number was produced, the honest answer is often that it would take a while to reconstruct.
What we build
We bring the figures your reports depend on into one place, with each definition written down once: what counts as an active case, a new supporter or a completed job. The sources feed that place automatically on a schedule. The report reads from it, so it is ready when it is needed rather than when someone has had time to build it.
Depending on the size and shape of your data, the single source is an Airtable base or a PostgreSQL database. Where a base has outgrown the platform, reporting reads from a database underneath it so that it stays answerable as volumes grow.
What you get
- A written list of every figure in the report, where it comes from and how it is calculated.
- The automated feeds, with a log that shows when each source last updated.
- A report that refreshes on a schedule, with the same definitions every time.
Where it fits
Performance and board reporting in public bodies. Funder, grant and trustee reports in charities, where the same figures are often requested in several formats. Weekly and monthly management reporting in smaller businesses, where the person building the report is usually also doing another job.
If the report is genuinely a one-off, automation is not worth it, and we will say so.
Is this costing you time?
Describe how the process runs today. We will tell you whether it is worth automating, and what it would involve, before anything is agreed.