Simple Monthly Cash Flow Forecast for Small Businesses

What a cash flow forecast is (and why it matters)

A cash flow forecast shows how much cash you expect to come in and go out next month. It helps you see problems early, so you can act before money gets tight. Think of it like a traffic map for your bank account.

Your goal: Know your cash balance at the end of each week in the coming month. Update it every week. It should take 15–30 minutes.

What you need (10 minutes to gather)

• Starting bank balance (today)
• List of customer payments due next month and expected dates
• List of bills due next month and due dates (rent, payroll, suppliers, software, loans, taxes)
• Any planned one-time items (equipment, deposits, refunds)

Set up a simple layout

Use a sheet with these columns:

• Week Starting Date (e.g., Mon)
• Starting Cash
• Cash In (by source)
• Cash Out (by category)
• Net Change (In − Out)
• Ending Cash (Starting + Net Change)

Categories to use:

• Cash In: customer payments, other income (grants, refunds)
• Cash Out: rent, payroll/contractors, inventory/supplies, utilities/internet/phone, software, marketing/ads, taxes, debt payments, owner pay, one-time purchases

Quick rules for timing (very important)

• Record money when cash moves, not when you send invoices or get bills.
• If a client “usually” pays in 30 days, put the cash in the week after 30 days. If they pay late, shift it when you update.
• Split big items by real pay dates. Example: payroll on the 15th and 30th goes in those weeks.
• Sales tax and payroll tax: put them in the week they leave your bank.

Step-by-step: Build next month in 20 minutes

1. Write your starting cash balance at the top of Week 1.
2. List Cash In for each week. Add customer names and amounts on the week you expect to receive payment.
3. List Cash Out for each week. Use due dates. Add rent, payroll, vendors, software, loan payments, taxes, etc.
4. Add up Cash In and Cash Out for each week. Calculate Net Change and Ending Cash.
5. Scan for any week where Ending Cash goes below your minimum comfort level (see simple rule below).

Simple comfort rule

Pick a minimum cash cushion. Good starting rule: keep at least 2 weeks of payroll + rent in the bank. If your Ending Cash drops below that, plan actions now.

Worked example (numbers)

Assume starting cash is $18,000. Payroll is $8,000 twice a month. Rent is $3,000 due Week 1. You expect $25,000 in customer payments: $10,000 in Week 2, $15,000 in Week 4.

Minimum cushion (example): 2 weeks of payroll ($16,000) + rent prorated weekly ($750) ≈ $16,750. You end around $17,800, slightly above cushion. If Client B pays late, Week 4 would end near $2,800. That’s a red flag you can catch early.

Five levers to pull if a shortfall shows up

• Speed up cash in: send reminders, offer 2% discount for payment this week, take card/ACH, require deposits on new jobs.
• Slow down cash out: ask vendors for Net 30–45, move non-urgent buys to next month.
• Trim spending: pause ads that don’t convert, cut unused software, delay owner draws.
• Bridge finance: use a line of credit for timing gaps (not for ongoing losses). Pay it down when big payments arrive.
• Reschedule work: push labor-heavy jobs to the week after cash arrives.

Weekly 15-minute update routine

1. Open last week’s forecast and your bank account.
2. Replace “expected” with actuals for Cash In and Cash Out.
3. Shift any late/early items to the correct week.
4. Roll forward the Ending Cash to the next week’s Starting Cash.
5. Add one new week so you always see at least 4–6 weeks ahead.

Checklist: What to include every month

• Starting cash balance
• All customer payments expected and dates
• Rent, payroll/contractors, taxes (sales, payroll, income estimates)
• Vendors/suppliers by due date
• Software, subscriptions, insurance
• Loan/credit card payments
• Owner pay/distributions
• One-time items (repairs, equipment, deposits, refunds)

Simple decision rules

• If Ending Cash next week is below the cushion, act today. Pull at least two levers (speed up cash in + slow cash out).
• If two or more weeks show a shortfall, set up a call with your top three customers to confirm payment dates and ask vendors for extended terms.
• If you borrow to cover payroll, make a 4-week plan to pay it back. If you can’t, reduce expenses immediately.

Common mistakes to avoid

• Counting invoices as cash before they’re paid.
• Forgetting taxes and annual renewals.
• Ignoring small, regular charges (they add up).
• Not updating weekly—things change fast.
• Being too optimistic on payment timing; be conservative.

Copy-and-use template (structure)

Columns:

• Date (Week Starting)
• Starting Cash
• Cash In: Customer A, Customer B, Other
• Total Cash In
• Cash Out: Rent, Payroll, Contractors, Inventory/Supplies, Utilities, Software, Marketing/Ads, Taxes, Debt Payments, Owner Pay, One-time
• Total Cash Out
• Net Change (In − Out)
• Ending Cash

Tip: Keep all numbers positive in In/Out columns. Do the math in Net Change.

Monthly review (30 minutes)

• Compare last month’s forecast vs. actual. Where were you off?
• Update your payment timing assumptions based on real behavior.
• Set a target: raise your cushion by one week this quarter.

If you only do three things

1. Update the forecast every Friday.
2. Keep a 2-week payroll cushion.
3. Invoice fast and follow up faster (reminder at 3, 7, and 14 days before due date).