Work · Finance · Treasury
13 wks Of rolling cash visibility, refreshed daily
A finance team was steering cash from a spreadsheet that one person updated by hand. We built a rolling 13-week forecast that pulls from bank and billing feeds and refreshes itself every day, so the current cash picture is always one screen away.
13 week
Rolling view
Refreshed
Daily
Fed by
Bank and billing data
01The problem
Most firms forecast cash in a spreadsheet. One person owns it. They pull bank balances, check what invoices are outstanding, guess at what will land when, and paste it all together, usually once a week if things go well.
That creates two problems. The forecast is stale the day after it is built, and it stops existing when the owner is out. Decisions about hiring, purchases, and debt get made against a picture of cash that is already days or weeks old.
- Forecast updated by hand, on whatever schedule the workload allowed
- Bank, billing, and payroll data living in separate systems, stitched together manually
- No shared view, so leadership asked for the number instead of looking it up
02What we built
We replaced the spreadsheet with a system that maintains itself. It connects directly to the firm's bank accounts and billing platform, pulls fresh data every day, and rebuilds the forecast without anyone touching it.
The forecast covers a rolling 13 weeks. Each week rolls forward automatically, so the horizon never shrinks and never needs resetting. Inflows come from open invoices and billing schedules. Outflows come from payroll, recurring vendors, and known one-off payments.
Actuals replace estimates as they clear. When a payment lands, the forecast absorbs it and reprojects the weeks ahead. The team can still add manual items, a planned purchase or an expected receipt, and the system carries them forward alongside the automated feeds.
Everyone who needs the cash picture sees the same one, current as of that morning, with no version confusion and no key-person dependency.
03What changed
The firm now has 13 weeks of rolling cash visibility, refreshed daily, fed directly by bank and billing data. The forecast is no longer a document someone produces. It is a view that is simply there.
Conversations about cash changed shape. Instead of debating whether the numbers are current, leadership starts from a shared, up-to-date picture and spends the meeting on decisions. Tight weeks show up on the horizon early enough to act on, not after the fact.
The person who used to maintain the spreadsheet got that time back, and the forecast no longer depends on their calendar. The quality of the cash picture stopped varying with how busy the team was.
A real engagement, anonymized. Client details are withheld under confidentiality.
Next step
Still forecasting cash in a spreadsheet?
We build the same system inside your stack, connected to your bank and billing data, in your vocabulary. Tell us what you run on and we will scope it.
More work