Skip to content

Monthly Cash Forecast Template for Small Businesses

Why a monthly cash forecast matters

Cash is how bills get paid. A simple monthly cash forecast tells you if you’ll have enough cash this month and next. It helps you decide when to delay spending, speed up invoices, or pull a small line of credit.

How to use this template (5 minutes a week)

  1. Fill one row per cash item (sales, payroll, rent, vendor bills).
  2. Use actuals for past months and estimates for the next 3 months.
  3. Update weekly for big changes (large orders, late customers).
  4. Make one decision from the checklist below if the forecast shows a shortfall.

Simple rules to act on the numbers

  • If ending cash < 5 days of operating payroll — prioritize payroll funding immediately.
  • If ending cash negative for any month — delay discretionary spending (marketing, new equipment).
  • If shortfall is 1–2 weeks and predictable — speed up invoices and push collections.
  • If shortfall > 1 month or repeat each month — consider a small loan or raise prices.

One-page monthly cash forecast (copy-paste CSV)

Copy and paste this into Excel or Google Sheets. Replace example numbers. Columns: Item, Type (in/out), Amount, Jan, Feb, Mar, Notes.

Item,Type,Amount,Apr,May,Jun,Notes
Beginning Cash,Balance,0,5000,4200,3500,
Customer Sales,In,Monthly,15000,15000,15000,Regular sales
Credit Card Sales,In,Monthly,4000,4000,4000,High fee
Collections (late AR),In,One-time,2000,0,0,Expected April
Payroll,Out,Monthly,-8000,-8000,-8000,Includes taxes
Rent,Out,Monthly,-2000,-2000,-2000,Office rent
Supplier Bills,Out,Monthly,-3000,-3000,-3000,Net 30
Loan Payment,Out,Monthly,-500,-500,-500,Small equipment loan
Capital Purchase,Out,One-time,-2500,0,0,New laptop
Owner Draw,Out,Monthly,-1500,-1500,-1500,Owner take
Ending Cash,Calc,,5000,4200,3500,=(Beginning Cash + SUM(In) + SUM(Out))

Tip: Put positive numbers for inflows, negative for outflows. Use formulas: Beginning Cash for month N = Ending Cash for previous month. Ending Cash = Beginning Cash + SUM(all inflows and outflows).

Fill-in-the-blank quick template (plain rows)

Use these rows and replace text.

Beginning Cash: __________
+ Customer Sales (expected): __________
+ Other Inflows (list): __________
- Payroll (total): __________
- Rent/Lease: __________
- Supplier Bills: __________
- Loan Payments: __________
- Taxes (estimate): __________
- Owner Draw / Distributions: __________
= Ending Cash: __________

Example: 3-month snapshot

Numbers show how to read results.

Beginning Cash Apr: 5,000
Net inflows Apr: 9,500
Net outflows Apr: -9,300
Ending Cash Apr: 5,200
Beginning May: 5,200
Net inflows May: 6,500
Net outflows May: -7,500
Ending Cash May: 4,200
Beginning Jun: 4,200
Net inflows Jun: 5,000
Net outflows Jun: -4,700
Ending Cash Jun: 4,500

Interpretation: Ending cash stays positive but trend is down from April to May then stabilizes. If ending cash falls below 3,000, use decision checklist below.

Decision checklist when forecast shows trouble

  • Are any invoices overdue? — Call top 5 largest customers today to ask for payment or partial payment.
  • Can you delay purchases? — Pause non-essential orders and equipment purchases.
  • Can you delay payroll or change timing? — If yes, notify staff and adjust pay dates (use sparingly).
  • Can you negotiate vendor terms? — Ask top vendors for Net 30–60 or split payments.
  • Can you get a short-term loan or line? — Compare one-month cost vs lost sales risk. If shortfall < 30% of monthly revenue, consider small credit line.

Weekly checklist (5–15 minutes)

  • Update actual bank balance and key unpaid invoices.
  • Mark any new expected inflows or one-time expenses.
  • Run the forecast for next 3 months and check ending cash each month.
  • If any month shows negative cash, pick one action from Decision checklist and assign an owner and date.

Who should own this?

Assign one person (owner, bookkeeper, or office manager). Weekly updates, monthly review at a regular meeting. If you use a bookkeeper, ask them to prepare the forecast and flag risks.

Quick templates you can paste now

Google Sheets columns: Month, Beginning Cash, Total Inflows, Total Outflows, Ending Cash (formula).

Month,Beginning Cash,Total Inflows,Total Outflows,Ending Cash
Apr,5000,13000,-8000,=B2+C2+D2
May,=E2,6500,-7500,=B3+C3+D3
Jun,=E3,5000,-4700,=B4+C4+D4

Final tips

  • Be conservative: underestimate inflows, overestimate outflows.
  • Keep a 2-week cash buffer if possible.
  • If forecasts repeat shortfalls, adjust pricing or cut fixed costs.