How to prepare a monthly cash-flow forecast for a small business
A monthly cash-flow forecast helps you see when money will come in and go out so you can avoid surprises and make smarter decisions. This guide walks you through a clear, repeatable process you can complete in about 1–3 hours each month. Use a spreadsheet or simple software to keep it updated and actionable.
Step 1: Gather last 12 months data
Collect bank statements, receipts, invoices, payroll records, and sales reports for the past 12 months. Reviewing a full year reveals seasonality and typical timing patterns so your forecast is based on real behavior, not guesswork.
[Illustration: stack of bank statements, invoices, and receipts on a desk with a laptop showing spreadsheets]
Step 2: Create a simple template
Set up a spreadsheet with rows for cash inflows and outflows and columns for each day or each week of the coming month; most small businesses use weekly columns for detail and monthly totals for overview. Include separate sections for sales receipts, accounts receivable, payroll, rent, taxes, loan payments, and one labeled 'other' for miscellaneous items.
[Illustration: open spreadsheet template with labeled rows and columns, blank cells ready for numbers]
Step 3: Project sales receipts
Estimate cash receipts for the month by combining expected sales and collections from outstanding invoices. Use a realistic collection rate (for example 70–90% of invoices due) and adjust for known large one-time orders or seasonal dips to avoid overstating incoming cash.
[Illustration: sales chart with incoming cash arrows and highlighted invoice due dates]
Step 4: Schedule fixed outflows
Enter fixed, known payments such as rent, loan payments, insurance, and recurring subscriptions with their due dates. These predictable amounts — say $2,500 rent on the 1st and $1,200 loan payment on the 15th — form the backbone of your forecast and should not be omitted.
[Illustration: calendar page with rent and loan payment entries on specific dates]
Step 5: Estimate variable costs
Forecast variable expenses like materials, utilities, and shipping based on expected activity; use unit costs and planned volume (for example 100 units at $12 each = $1,200). Apply conservative margins: add 5–10% to account for price increases or extra usage.
[Illustration: workbench with boxes, utility bill, and calculator showing cost multiplications]
Step 6: Incorporate timing differences
Adjust for timing gaps between sales and cash receipts and between expenses and payments, e.g., if suppliers allow 30-day terms, schedule payments accordingly rather than on purchase date. Mapping timing prevents false shortfalls and shows when you might need short-term funding.
[Illustration: timeline diagram showing invoice date, payment terms, and cash receipt date offsets]
Step 7: Add contingency and ending balance
Include a contingency buffer — commonly 5–10% of total outflows or a minimum cash cushion such as $5,000 — and calculate the ending cash balance for each period to see surplus or shortfall. If a projected balance falls below your buffer, plan corrective actions like delaying discretionary spend or arranging a $10,000 line of credit.
[Illustration: calculator beside a highlighted cash balance row with buffer amount noted]
Step 8: Review and update monthly
Compare forecasted vs. actual cash flows at month end and update assumptions for the next month based on variances; spend 30–60 minutes monthly to refine collection rates, expense estimates, and timing. Continuous revision improves accuracy and builds confidence for decision-making.
[Illustration: person updating spreadsheet on laptop with comparison columns for forecasted and actual values]
Step 9: Communicate plan with stakeholders
Share the forecast summary with partners, your bookkeeper, or your bank to align expectations and secure support if needed; include clear action steps if low-cash situations arise, such as delaying purchases or accelerating collections. Transparent plans make it easier to get help and implement solutions quickly.
[Illustration: small team gathered around a table reviewing a printed cash-flow summary chart]
- Use weekly columns if cash is tight; daily columns are useful during crunch periods.
- Keep at least one month of payroll in reserve; for a $20,000 monthly payroll, consider a $20,000 buffer.
- Automate data imports from your bank to save 15–30 minutes each month and reduce errors.
- Flag large one-off items (over $1,000) so they’re not mixed into recurring averages.
- Reconcile accounts receivable weekly; chase invoices older than 30 days to improve collections by 10–20%.
- Stress-test the forecast by reducing inflows 20% or increasing costs 15% to see how long the cash runway lasts.
- Do not overstate future sales — optimistic forecasts commonly cause unexpected shortfalls.
- Avoid ignoring timing differences; recording revenue when invoiced instead of when paid can hide cash shortages.
- Do not use the forecast as a substitute for a separate profit-and-loss statement; they answer different questions.
- Avoid mixing personal and business cash flows; this distorts the forecast and can create tax complications.
Was this guide helpful?
More Finance & Business guides
How to negotiate a lower interest rate with your credit card issuer
Negotiating a lower interest rate with your credit card issuer is often easier than you think and can save you hundreds of dollars a year. With a little preparation and the right approach, you can increase your chances of getting a meaningful reduction. This guide walks you step-by-step through what to do, what to say, and when to follow up.
How to set up automatic transfers to multiple savings goals using one bank account
Setting up automatic transfers to multiple savings goals helps you build habits, reduce stress, and make progress without thinking about it. With one checking account and the right plan, you can funnel money into separate goals like an emergency fund, vacation, and down payment on a steady schedule. This guide walks you through a practical, checkable process you can complete in a few sessions.
How to protect yourself from identity theft and financial fraud online
Identity theft and online financial fraud can feel overwhelming, but small consistent habits make a big difference. This guide gives practical, easy-to-follow steps you can start using today to reduce your risk and protect your money.