Skip to content

Build a Simple Monthly Budget and Forecast for Your Small Business

Why a monthly budget and forecast matters

Monthly budgets and forecasts tell you whether you’ll have enough cash to run the business and where to focus to improve profits. They don’t need to be complex—just accurate enough to make decisions.

Quick overview: 5 steps

  1. Gather last 3 months of actuals (sales, costs, bank balances).
  2. Separate fixed vs variable costs.
  3. Forecast sales for each coming month.
  4. Build the monthly budget (revenue minus expenses = expected profit).
  5. Turn budget into a cash forecast and review weekly.

Step 1 — Gather the right numbers

What to pull:

  • Sales receipts or invoices for past 3 months.
  • Bank and credit card statements.
  • Payroll or owner pay records.
  • Monthly bills (rent, utilities, subscriptions).

Checklist: Do you have these? Yes / No

  • Last 3 months sales: ___
  • Last 3 months expenses: ___
  • Current bank balance: ___

Step 2 — Categorize costs: fixed vs variable

Fixed costs: don’t change much with sales (rent, insurance, loan payments). Variable costs: change with volume (materials, shipping, contractor hours).

Why this helps: if sales drop, variable costs fall too; fixed costs determine your break-even level.

Step 3 — Forecast sales (simple methods)

Choose one method:

  • Average method — use the average monthly sales of the last 3 months.
  • Trend method — if sales grew or fell steadily, add or subtract the average monthly change.
  • Known events — adjust for planned promotions, seasonality, or one-time contracts.

Example: last 3 months sales = $12k, $14k, $13k. Average = $13k. If you plan a small promo, add 10% = $14,300 forecast.

Step 4 — Build the monthly budget

Create a simple table with three rows: Revenue, Total Expenses (fixed + expected variable), Net Profit (Revenue − Expenses).

Example monthly budget:

  • Forecast Revenue: $14,300
  • Fixed costs: Rent $2,000 + Insurance $200 + Loan $500 = $2,700
  • Variable costs: Materials $4,000 + Shipping $300 + Subcontractors $1,000 = $5,300
  • Total Expenses = $8,000
  • Net Profit = $6,300

Decision rule — if Net Profit < $1,000 consider actions (see next section).

Step 5 — Convert budget into a cash forecast

Income timing matters. A sale doesn't mean cash today if you invoice. List expected cash in and cash out by week.

Simple weekly cash forecast example (month of 4 weeks):

  • Week 1: cash in $3,000, payroll + bills $2,500 → balance change +$500
  • Week 2: cash in $2,000, bills $3,000 → change −$1,000
  • Week 3: cash in $4,000, bills $1,500 → change +$2,500
  • Week 4: cash in $5,300, bills $1,000 → change +$4,300

Start with current bank balance and apply each week’s change to see low points.

Practical rules for decisions

  • Buffer rule: keep at least 2 weeks of payroll + fixed costs in the bank.
  • Raise price rule: if gross margin < 30%, raise prices or reduce variable costs.
  • Cut-cost rule: if you need to reduce expenses quickly, cut variable costs first, then non-essential fixed costs, then consider renegotiating long-term contracts.

Monthly review checklist

  • Compare actual vs budget for revenue and major expenses.
  • Track cash low point and rebuild buffer if below target.
  • Adjust next month’s forecast for known changes (new contract, slow season).
  • Note 3 things that went well and 3 things to change.

Simple templates you can build in 15 minutes

  1. One-sheet budget: columns for Category, Amount, Fixed/Variable, Notes.
  2. Weekly cash sheet: columns for Week, Cash In, Cash Out, Net Change, Running Balance.
  3. Monthly summary: Forecast Revenue, Forecast Expenses, Net Profit, Bank Low Point.

Example one-month run-through (compact)

Starting bank $5,000. Forecast revenue $14,300. Total expenses $8,000. Weekly timing as above. Lowest weekly balance = $4,500. Buffer rule passed (2 weeks payroll + fixed costs = $3,400).

Common pitfalls and how to avoid them

  • Pitfall: Counting sales, not cash — track when cash arrives.
  • Pitfall: Ignoring seasonality — adjust forecasts several months ahead.
  • Pitfall: Letting subscriptions pile up — review recurring charges quarterly.

Next steps — what to do this week

  1. Pull last 3 months of sales and bank statements.
  2. Fill the one-sheet budget and weekly cash sheet with your numbers.
  3. Set a calendar reminder to review budget vs actual on the same day each month.

Use this process, not perfection. Start simple, update as you learn, and you’ll reduce surprises and make better decisions.