Build a Cash Flow System You Can See Every Week
Cash problems rarely start with profit. They start with timing.
You can be “doing well” on paper and still run out of cash because deposits arrive late, payroll hits early, and a tax bill lands on the worst week of the month.
A weekly cash flow system fixes that. Not by guessing. By making the next 13 weeks visible.
A 13-week cash forecast is a rolling view of cash in and cash out, week by week. It gives you a short runway you can manage. It also forces you to face reality early enough to act.
This is not complicated finance. This is a simple spreadsheet and a weekly habit.
Finance teams call a 13-week rolling forecast a standard tool for liquidity management, updated weekly to stay current.
Why financial stress drops fast when cash is predictable
Most owners feel stress when they do not know what next week looks like.
When you can see the next 13 weeks, you stop reacting and start choosing.
That matters because cash flow is one of the top reasons small businesses fail. One widely cited stat is that 82% of small businesses fail due to cash flow problems.
At the same time, many owners still report uncertainty. In the U.S. Chamber of Commerce Small Business Index (Q4 2025), 74% said they were comfortable with cash flow, but fewer said they were very comfortable. That gap is where stress lives.
You are building a system so you are not guessing.
What a 13-week cash forecast is (and why 13 weeks works)
A 13-week forecast is a week-by-week cash plan across one quarter. Each week shows:
Starting cash
Expected deposits
Expected payments
Ending cash
Then you roll it forward every week. Week 1 drops off. A new Week 13 gets added.
Why 13 weeks?
Because it covers a full quarter and matches how a lot of major expenses show up, quarterly taxes, annual renewals, insurance cycles, debt payments, and seasonal swings.
Short quote you should remember: Intuit calls a 13-week rolling forecast “the operational gold standard” for managing liquidity.
Set up the spreadsheet in 30 minutes
Use Google Sheets or Excel. Keep it plain. Fancy templates make people stop updating it.
Tab 1: Assumptions
Put your key inputs in one spot:
Current cash balance (bank balance you can spend)
Average weekly deposits (if you have to start with an estimate)
Payroll dates and amounts
Fixed monthly bills and due dates
Debt payments and due dates
Tax payment schedule (monthly or quarterly)
Owner draws (if any)
Tab 2: 13-week forecast
Create columns like this:
Week ending date (pick a consistent week end, Friday is common)
Starting cash
Expected deposits (collections)
Total cash available
Payroll (by pay period)
Rent
Loans and credit lines
Software subscriptions
Insurance
Taxes
One-time bills (equipment, legal, repairs)
Total outflows
Ending cash (available minus outflows)
Notes (what changed, what to watch)
Tab 3: Actuals
Each week, record what happened:
Actual deposits
Actual payments
Actual ending cash
Then compare forecast vs actual. Your goal is not perfection. Your goal is tighter accuracy every month.
Track the four cash categories that matter
You asked for a simple weekly tracking system. This is the core list.
1) Expected deposits by week (collections)
This is the lifeblood line.
What to include:
Deposits you expect to hit the bank this week
Any known delayed payments
Large invoices with a specific promise date
Rules:
Use deposit date, not invoice date
Be conservative on anything uncertain
Separate “likely” vs “wishful thinking” in your notes
If deposits slip, your forecast shows the pain early enough to collect faster or cut spending.
2) Payroll by pay period
Payroll is often the largest and least flexible expense.
Track it like this:
Put payroll only on the exact week it leaves your account
Include taxes and benefits if they draft separately
Add bonuses only when they are committed
If you run payroll every two weeks, your cash plan needs that rhythm.
3) Rent, loans, software, insurance, taxes
These are your fixed drains.
List each item with:
Amount
Due date
Draft date (often earlier than due date)
For subscriptions, group small ones into a single weekly line if it keeps you consistent. Consistency beats detail.
Taxes are where owners get surprised. Put them in early, even if you estimate, then revise as you get closer.
4) One-time bills (equipment, legal, repairs)
This category is where cash forecasts pay for themselves.
If you do not list one-time bills, your forecast becomes a lie.
Add anything that is not “normal monthly.”
Examples:
New computer purchases
Repairs
Legal and accounting spikes
Vendor annual renewals
Build-out costs
If you cannot predict the exact week, park it in the most conservative week and write a note.
The weekly routine that makes this work
A cash forecast fails when it becomes a monthly chore.
Keep it weekly. Same day. Same time. Same steps.
Weekly cash meeting (20 minutes)
Do this every week:
Update starting cash from your bank balance
Paste in actual deposits and payments from last week
Adjust the next 2 weeks first (that is where accuracy matters most)
Review the lowest cash week in the next 13 weeks
Choose actions (collect faster, delay a purchase, change timing, reduce draws)
That is it.
This is not a budget meeting. This is a timing and survival meeting.
What to do when a “low cash week” shows up
When your forecast shows a dip, you have choices. You need a playbook.
Here are common moves:
Collect past-due invoices this week, not next week
Move a non-urgent purchase to a higher-cash week
Split a vendor bill into two payments (ask, do not assume)
Pause owner draws for one cycle
Use a line of credit on purpose, not in panic
Pre-sell a package or annual plan (only if it fits your business model)
The point is not to avoid dips. The point is to see them early enough to respond without chaos.
Mistakes that break cash forecasts
Most cash systems fail for boring reasons.
Avoid these:
Mixing accrual numbers with cash numbers
A forecast is about bank timing, not accounting profit.Forgetting tax drafts and annual renewals
These hit hard because they feel “random.”Not separating payroll timing
A two-week cycle can create repeated cash cliffs.Not updating weekly
If you do not update weekly, the sheet becomes a story, not a tool.
A 13-week cash forecast works best as a rolling habit, updated with real data.
Call to action: coaching inquiry
If you want help building this as a simple weekly system, I can help.
We will:
Set up the 13-week sheet for your business
Define the categories that match your real cash cycle
Build a weekly rhythm so it stays current
Create a short “low cash week” action plan
To start, use the coaching page (/coaching) or the contact form (/contact) on AG Management Consulting Inc.
