Cash flow forecast for a small team: a 13-week sheet, who updates it, and a Monday check in Slack
Most small firms that build a cash flow forecast build it once. The sheet looks good for three weeks, then the Monday update slips, the numbers drift from the bank balance, and a quarterly tax payment or a client who pays 30 days late arrives as a surprise. One finance writer calls building the forecast once and never touching it again "probably the most common" forecasting mistake.
This guide is for the founder or operations lead of a 5 to 100 person team that keeps its books in QuickBooks Online or Xero. It gives you a 13-week layout, a table that says which accounting report feeds each line, a named owner and trigger for the weekly update, and a Slack routine that pulls the numbers every Monday so the update takes minutes instead of an afternoon.
The short answer
A cash flow forecast stays useful when four things are true:
- It covers the next 13 weeks, one column per week, starting from today's cash.
- Every line has a source: an accounting report or a named person's estimate.
- One person owns the update, and it happens at a fixed time, such as Monday at 9am.
- Each week you replace last week's estimate with what actually happened, look at the difference, and add a new week at the end.
The rest of this article fills in those four points for a small team.
Why the forecast goes stale
The current guides agree on the routine. A CPA firm's guide says to, each Monday, "Enter the prior week's actual inflows and outflows", "Replace forecast amounts with actuals", and "Roll the model forward by adding Week 14". A small-business guide from Timberwolf Analytics gives a similar weekly checklist: replace estimates with actual results, review the difference, update expected collections, update upcoming expenses, add another week.
Neither guide says who does it. The CPA guide says "Assign clear ownership of this process" and stops there. At a company with a controller, that is the controller. At a 12-person agency, it is whoever has the QuickBooks login and a free hour, which on a busy Monday is nobody.
The update also has a hidden cost: collecting the inputs. Before you can type a single actual into the sheet, someone has to open the accounting tool, check the bank balance, list who owes what and when, and list which bills are due. That is three or four screens and some copying. A founder who posted a weekly forecasting tool on Hacker News described the spreadsheet version plainly: "it was working but it was a pain" (one owner's report).
A cash flow forecast goes stale because the Monday update has no named owner and no trigger, not because the template is wrong, so fix the owner and the trigger before you change the spreadsheet.
A 13-week cash flow forecast layout you can copy
Keep the sheet small. One tab, one row per line below, one column per week labelled with the week-ending date (for example, the Friday). The example figures are made up; fill in your own.
| Row | What goes in it | Example (made up) |
|---|---|---|
| Opening cash | Cash in the bank at the start of the week | $84,000 |
| Client payments expected | Invoices you expect to be paid that week | $22,500 |
| Other cash in | Loan proceeds, refunds, interest | $0 |
| Payroll | Net pay plus payroll taxes on pay dates | $31,000 |
| Bills due | Supplier and contractor bills due that week | $9,400 |
| Rent and fixed costs | Rent, insurance, software on monthly billing | $6,200 |
| Taxes | Estimated tax payments, sales tax remittances | $0 |
| Irregular costs | Annual renewals, equipment, bonuses | $0 |
| Net cash flow | Cash in minus cash out | -$24,100 |
| Closing cash | Opening cash plus net cash flow | $59,900 |
| Below floor? | Yes if closing cash is under your minimum | No |
Two rules from these guides shape every row. First, put cash in the week it actually arrives. Timberwolf's warning is short: "an invoice is not the same as cash in the bank". If your terms are net 30 and a client always pays at day 45, forecast day 45. Second, set a minimum cash floor and flag any week that falls below it. The CPA guide calls this a minimum operating threshold and leaves the number to you.
Why 13 weeks? It is a quarter, long enough to see a quarterly tax payment and a slow month coming, and short enough that your estimates of who pays when are still reasonable.
Which report feeds each line
None of the guides above maps their rows to an accounting report, and collecting those numbers is most of the weekly work. Most lines of a small team's 13-week forecast can be refreshed from three accounting reports, bank summary, aged receivables and aged payables, so the weekly update is mostly a data pull, and only the estimates for taxes, renewals and payroll changes need a person's judgement.
| Forecast line | Source | Who decides |
|---|---|---|
| Opening cash | Bank summary report in QuickBooks or Xero | Report, checked against the bank if they differ |
| Client payments expected | Aged receivables report: who owes what and how overdue | Report for amounts, account lead for timing of slow payers |
| Bills due | Aged payables report: what you owe and when it is due | Report for amounts, owner for anything to delay |
| Payroll | Payroll calendar | Owner, when headcount or pay changes |
| Rent and fixed costs | Last month's profit and loss as a guide | Fixed until something changes |
| Taxes | Your accountant and the IRS schedule | Owner and accountant |
| Irregular costs | Contracts, renewal emails, equipment plans | Owner |
Taxes deserve their own row because they are lumpy. The IRS says the year is divided into four payment periods, each with a specific due date, and that individuals, including sole proprietors, partners and S corporation shareholders, generally have to make estimated tax payments if they expect to owe $1,000 or more, while corporations generally must if they expect to owe $500 or more. Check the dates for your situation on that IRS page or with your accountant; this guide gives no tax advice. Timberwolf also lists the costs people forget: annual subscriptions, tax payments, bonuses, repairs, professional fees, or equipment purchases.
If you already review receivables weekly, the aged receivables report guide covers how to read that report; the forecast simply moves those expected payments into the weeks they will land.
Who owns the Monday update
On a team without a finance hire, pick one owner by name. Usually it is the founder, the operations lead or an office manager who already handles invoices. The owner does not have to do every step. Their job is to make sure the update happens and to make the judgement calls.
A workable split for a small team:
- The owner runs the update, sets the cash floor, decides timing for slow payers, and keeps the tax and irregular rows current.
- Account leads answer one question when asked: "will this client pay this week, next week or later?"
- Your bookkeeper or accountant, if you have one, keeps the books reconciled so the reports are right, and reviews the forecast monthly.
If you are deciding whether that bookkeeper should own the forecast too, the article on whether you need a bookkeeper yet walks through what to hire for and what to keep in-house. The weekly forecast is a good test: if the owner can do it in 20 minutes with the inputs ready, it does not need a hire.
The Monday checklist
Use this as written, or paste it into the top of the sheet:
- Pull the bank summary, aged receivables and aged payables reports.
- Replace last week's estimates with actual cash in and out.
- Note any line where actual and forecast differ by more than 10 percent, and why (this threshold is a suggestion; pick your own).
- Update expected client payments from the receivables report, moving slow payers to the week they will really pay.
- Update bills due from the payables report.
- Check the tax and irregular rows for anything new.
- Add week 14.
- Look at the lowest closing cash in the 13 weeks, not only the last week. If any week is under the floor, decide now: chase a payment, move a bill, or arrange credit.
A forecast that ends healthy in week 13 can still dip below zero in week 6, which is why step 8 checks the lowest week.
Running the Monday check in Slack
Steps 1, 2, 4 and 5 are mostly copying numbers between tools. That is the part that makes the update slip, and it is the part you can hand off before you hire anyone. Here is how a Slack-first team can do it with the Kipwise Agent, using only what it does today.
Set it up once. In your finance or ops channel, mention the agent and ask it to post a cash snapshot every Monday at 8am. The agent runs requests on a schedule in plain language and posts the result in the channel, using the same tools and permissions as a live request from you. Creating the scheduled task needs your approval once; later runs do not ask again.
Each Monday. The agent runs the bank summary, aged receivables and aged payables reports in QuickBooks Online or Xero, with your own access to the company or organisation you connected, and says which one it read. The totals land in the channel thread before the owner starts the update.
Update the sheet from the thread. The owner replies in the same thread, with no new mention needed. An illustrative exchange (made up):
> Owner: Add last week's actuals to the Cash forecast sheet and flag any week where closing cash is under $40,000. > > Agent: I read rows 1 to 14 of the Cash forecast sheet. I'll update week 43 with opening cash $84,000, client payments $22,500 and bills paid $9,400 from the reports above. Week 49 closes at $36,200, under your $40,000 floor. [Approve] [Deny]
The agent can read a range in a Google Sheet, add rows and update cells, and each change waits for your Approve card, which only the person who asked can use.
Follow up on the dip. In the same thread, the owner can ask which invoices make up the week 49 shortfall, and the agent can look up the contact's outstanding balances and open the invoice. If the right move is to chase a client, that is a separate, explicit request; the agent writes nothing to your books unless you ask.
What stays with a person: the cash floor, the timing guess for slow payers, the tax and irregular rows, and every decision about delaying a bill or drawing on credit. The agent pulls and places numbers; it does not predict when a client will pay, it does not read your bank feed directly, and it does not move money.
For teams already on QuickBooks, the QuickBooks agent page shows the report reads with each teammate's own connection. Kipwise costs $10 per user per month, or $108 per user per year, with a minimum of 3 users.
Failure modes and how to handle them
The reports are wrong because the books are behind. If bank transactions are not reconciled, the bank summary and the receivables report will be off. The forecast inherits the error. Keep reconciliation on your bookkeeper's or owner's monthly list, and if the snapshot looks odd, check the bank before you approve the update. The month-end close checklist covers the monthly side.
Collections are too optimistic. Forecasting every invoice on its due date overstates cash when clients pay late. Ask account leads about anything over 30 days old and move it out.
The update happens but nobody reads it. Ask for the weeks under your floor in the Monday thread, so the dip shows up in Slack where the team already reads.
The owner is away. Name a backup. The scheduled snapshot still posts, so the backup has the numbers ready.
A big change mid-week. We recommend updating the forecast the same day when a large payment lands or a client cancels, rather than waiting for Monday.
How to tell it is working
After four weeks, check three things. Did the update happen every Monday? Is the gap between forecast and actual cash shrinking, especially on client payments? And did the forecast warn you about any low week before it arrived? If all three are yes, the routine is working. If the update is still slipping, the problem is the owner or the trigger, not the sheet.
What to do next
This week, open a new Google Sheet with the 13-week layout above, name the owner of the Monday update, and set the cash floor. Then fill week 1 from your bank summary, aged receivables and aged payables reports. If you want the reports pulled for you, connect QuickBooks or Xero and Google Sheets to the Kipwise Agent and ask it for one Monday cash snapshot in your ops channel.
