Build a Monthly Cash Forecast in 15 Minutes
Most business owners don’t have a cash problem because they’re unprofitable. They have a cash problem because they don’t know what’s coming in and going out until the bank balance already feels tight.
Build a Monthly Cash Forecast in 15 Minutes
A monthly cash forecast is a simple running view of money expected in, money expected out, and the likely ending balance for each month. List your starting cash, expected receipts, fixed costs, and planned variable spending. Update it monthly so you can spot shortfalls early and make calmer decisions before cash gets tight.
Start with four numbers only
You do not need accounting software gymnastics to forecast cash. You need four numbers: opening cash, expected cash in, expected cash out, and closing cash. Put them in a spreadsheet with one column per month and you have a practical money system in minutes, not hours.
Start with your opening cash balance. That is the actual amount in business bank accounts today, not what “should be” there. Next, estimate cash in from invoices, retainers, product sales, or subscriptions that are likely to land this month. Then list cash out: rent, payroll, contractors, software, taxes, debt payments, and any planned owner draw.
If you want a simple version, use one line for each category. For example: opening cash $18,000; cash in $24,000; cash out $29,500; closing cash $12,500. That ending number tells you whether the month feels safe, tight, or risky.
Use a 12-row structure that takes minutes to maintain
The easiest forecast is a one-page table with months across the top and cash categories down the side. Keep the rows limited to the things that actually move cash. A useful setup is: opening balance, customer receipts, other income, fixed overhead, payroll, contractor costs, marketing, tax set-asides, owner pay, and closing balance.
Do not split hairs on every coffee or one-off purchase. If a line item is small and irregular, bundle it into “other operating costs.” The goal is not perfect accounting. The goal is seeing whether the month ends at $8,000 or $800.
A practical rule: if a category can swing by more than 10% month to month, give it its own row. If not, group it. That keeps the forecast usable instead of turning it into another abandoned spreadsheet.
If you already review your receivables regularly, pair this with Create a Simple Invoice Follow-Up System so your cash-in line is based on expected payment timing, not hopeful thinking.
Estimate receipts and expenses with a conservative bias
The best forecast is slightly pessimistic. If you think a client will pay on the 15th, assume the 22nd. If you think a project will close for $12,000, forecast $9,500 until the contract is signed. Cash forecasts fail when they are built on best-case timing.
For receipts, use three buckets: already invoiced and due, likely to invoice this month, and possible but not yet certain. Put only the first two into your main forecast. Keep the third bucket in a notes column so you can see upside without depending on it.
For expenses, split them into fixed and variable. Fixed costs include rent, subscriptions, salaries, insurance, and loan payments. Variable costs include contractor work, ad spend, shipping, commissions, and any project-based spend. If you know fixed costs are $14,200 a month, that number should be stable. Variable costs deserve a tighter review because they often expand quietly.
Here is a simple example. You begin the month with $20,000. You expect $32,000 in receipts. Your fixed costs total $18,000. Variable costs are estimated at $11,000. Your closing balance is $23,000. If contractor work rises by $6,000, your closing balance drops to $17,000. That is still healthy, but now you know the margin.
Spot shortfalls before they become emergencies
The forecast becomes valuable when you check the ending balance against a minimum cash floor. Many owners use a floor equal to one month of fixed costs, plus payroll if they have staff. For a lean business with $12,000 in fixed monthly costs, an ending balance below $12,000 is a warning. Below $8,000 is a real problem.
Look for three warning signs: a month that ends lower than the previous month, a gap between billed revenue and collected cash, and two or more large payments hitting in the same week. A “profitable” month can still create a cash squeeze if money arrives late and bills arrive early.
When the forecast shows a shortfall, act immediately. Delay discretionary spending. Pause new hires. Rework payment terms. Ask for deposits. Push non-urgent contractor work into the next month. Even moving one supplier payment by 15 days can make the difference between a calm month and a panicked one.
This is also why you should tie cash visibility to pipeline reality. A business that tracks sales momentum alongside cash flow sees problems sooner. If you need that companion system, Build a Weekly Client Pipeline Review helps you connect future sales to future cash.
Use the forecast to make calmer spending and hiring decisions
Good cash forecasting changes behavior. Instead of asking, “Can we afford this right now?” you ask, “What does this do to the next three months?” That small shift prevents a lot of emotional spending.
For example, if you are considering a $4,000 monthly hire, add that cost to the next three forecasted months before you decide. If the ending balance stays above your cash floor in all three months, the hire is probably safe. If month two drops below the floor, the answer is not yet.
The same logic works for software, ads, equipment, and owner pay. One-time purchases feel small in isolation, but a forecast shows their real effect. A $7,500 laptop is not just a purchase. It is a reduction in your cash runway and flexibility.
Use the forecast to set spending rules. For example: no new recurring expense unless the three-month forecast still ends above the cash floor; no new hire unless the lowest projected month stays above 1.5 times fixed overhead; no owner bonus unless two consecutive months finish above target.
Make it a 15-minute monthly habit
To keep this system alive, review it once a month on the same day. Use the first 5 minutes to update opening cash and actual receipts from the previous month. Use the next 5 minutes to adjust expected income and known bills. Use the last 5 minutes to check the ending balance and flag any month that falls below your cash floor.
If you want the habit to stick, attach it to another monthly process like payroll, owner pay, or bookkeeping review. The forecast should not feel like a separate project. It should be part of how you run the business.
Keep a short notes section at the bottom with decisions. Example: “Delay contractor expansion until June,” “Increase deposits to 50%,” “Move SaaS renewals to annual billing next quarter.” Those notes turn the forecast from a report into an operating tool.
Open a spreadsheet today, build the four-number monthly forecast, and fill in the next three months before you finish work. Then review it on the same date every month so you spot shortfalls early, spend more calmly, and make hiring decisions with cash, not hope.