A rolling grid where forecasts turn into actuals
A budget should not be a static PDF you export in January and file away until December. It should be a living grid where what you planned and what actually happened sit side by side.
As we built out the cash flow grid in Zeno Budget, three design decisions shaped how it works.
1. Closed periods become actuals automatically
In a rolling cash flow, time is always moving. Last week is history; next week is a plan.
In Zeno Budget, each period switches from forecast to actual as it closes. Closed periods show actuals synced from QuickBooks. Open and future periods show your forecast. You do not have to copy numbers between two different sheets or manually close out columns every Friday.
Each period’s starting balance cascades from the prior period’s ending balance. If last week closed with $4,200 more cash than expected, this week’s starting balance reflects that immediately, and every future week updates from there.
2. Three views of the same numbers
Different questions require different time horizons, so the grid lets you switch between weekly, monthly, and annual views of the exact same underlying forecasts and actuals:
- Weekly is for operational cash management: making payroll, timing vendor payments, and spotting a tight week before it arrives. Any week that dips below the cash reserve you set is clearly marked, not only by color.
- Monthly is for managing the annual budget and seeing seasonal patterns across grants, tuition, donations, or recurring bills.
- Annual is for stepping back to look at multi-year sustainability and major commitments.
3. Every category is always a row
One small detail makes a big difference when an organization is getting started: the grid always shows every category as a row, even when there is no data yet.
Nothing kills momentum faster than connecting your accounting software and seeing a blank screen that says “No forecasts found.” In Zeno Budget, a new organization lands on a structured table of its QuickBooks categories that it can type into right away, and any cell can be clicked to drill down into the transactions behind the number.