Two-sided weekly cash forecasting: AP + AR, inflow vs outflow
How a CFO at a ~$5M ARR SaaS company reads the next six weeks of cash without rebuilding a pivot table: every scheduled receipt on the AR side and every scheduled disbursement on the AP side, lined up week by week, with the net weekly position sign-aware so shortfalls surface before they hit the bank.
A two-sided cash forecast shows both sides of the ledger on the same timeline — money you expect to come in (accounts receivable, recurring revenue receipts, renewals, autopays) and money you expect to go out (accounts payable, payroll, vendor runs, processor fees, contractor payouts). The net of those two rows each week is your cash position, not a guess.
Weekly beats monthly for a CFO because the failures are not evenly distributed. A renewal lands on a Wednesday, payroll runs every other Friday, and a single oversized vendor invoice can flip a week from positive to negative. Monthly granularity averages those shocks into something that looks healthy and hides the week you actually need a line of credit for.
AP-only or AR-only forecasts fail for the same reason — they answer one half of the question. Knowing you are owed $1.2M next month tells you nothing about whether the $180K payroll and the $115K vendor run hit the same week. The cash answer lives in the join between the two, not in either side alone.
Six weeks of weekly cash position for a ~$5M ARR SaaS
Each row is one week. The Inflows and Outflows columns show the scheduled line items; the Net column sums the two. A red net cell means the week closes below zero against the scheduled ledger — the early warning a CFO needs before the wires clear.
| Week | Date range | Inflows | Outflows | Net weekly position |
|---|---|---|---|---|
Wk 1 | Jul 6 – 12 | $95,000
| $148,000
| Net −$53,000 |
Wk 2 | Jul 13 – 19 | $215,000
| $158,000
| Net $57,000 |
Wk 3 | Jul 20 – 26 | $130,000
| $165,000
| Net −$35,000 |
Wk 4 | Jul 27 – Aug 2 | $240,000
| $148,000
| Net $92,000 |
Wk 5 | Aug 3 – 9 | $130,000
| $118,000
| Net $12,000 |
Wk 6 | Aug 10 – 16 | $185,000
| $162,000
| Net $23,000 |
All numbers are illustrative — a ~$5M ARR SaaS sample showing the kind of weekly visibility a unified AP+AR ledger produces. The shape is the point, not the figures.
A spreadsheet forecast hides the week that matters
Spreadsheet single-sided forecasting usually means one workbook for AR receipts and another for AP outflows, reconciled by a pivot table before each board meeting. That works until the two weeks of the quarter disagree about timing — the AR sheet says a $145K renewal lands on a Wednesday and the AP sheet says a $95K payroll run leaves on the Friday of the same week. The spreadsheet does not know those are the same week, so neither does the forecast.
AP-only dashboards answer "what do we owe and when" — useful for treasury, blind to whether the receipts have actually landed. An AP-only forecast will tell you the next payroll is covered without telling you the flagship renewal slipped two weeks, which is precisely the cash crisis a CFO needs to know about on Monday morning, not at month-end close.
AR-only dashboards mirror that failure in the other direction: they celebrate a $215K renewal week that drops straight into a $165K outflow week, leaving the CFO to discover the net on the bank reconciliation a week too late. In the worked example above, week 3 closes at −$35K against the scheduled ledger — a single-sided view that only tallies inflows shows $130K of healthy receipts; a single-sided view that only tallies outflows shows $165K of normal activity. Only the two-sided view surfaces the shortfall.
See it on your own ledger
The example above is built from a static ledger so the methodology reads cleanly. The full forecasting engine reads from your live AP and AR schedules and runs the same weekly rollup against real numbers.
Want a heads-up when the full forecasting engine ships? Join the waitlist →