Financial Forecasting for Small Business: Plan With Confidence

Why Forecast?

Financial forecasting answers the most important question in business: what is likely to happen next? Not with certainty - the future is inherently uncertain - but with enough confidence to make better decisions than guessing.

A forecast helps you:

• Anticipate cash flow shortfalls before they happen
• Plan for hiring, equipment purchases, and expansion
• Set realistic targets for revenue and profitability
• Prepare for seasonal fluctuations
• Communicate your financial trajectory to investors, lenders, or partners

Types of Financial Forecasts

Revenue Forecast

A revenue forecast projects your future income. There are two approaches:

Top-down: Start with the total market and estimate your share. This works for new businesses entering a known market. Example: "The local personal training market is $2 million. We aim for 5% share = $100,000."

Bottom-up: Start with your capacity and work up. This is more accurate for established businesses. Example: "We have 3 trainers, each available for 25 sessions per week at $80 per session. At 80% utilisation = $480,000 per year."

For most small businesses, bottom-up is more practical and reliable.

Expense Forecast

Project your costs for the forecast period:

Fixed costs - Start with current fixed costs and adjust for known changes (rent increases, new hires, insurance renewals).

Variable costs - Estimate as a percentage of forecasted revenue, based on historical patterns.

Capital expenditure - Planned purchases of equipment, vehicles, or other assets.

Tax obligations - GST, PAYG, super, and income tax based on projected profit.

Cash Flow Forecast

The most important forecast for small businesses. It combines revenue and expense forecasts with the timing of payments:

• When will revenue actually arrive in your bank account? (Not when it is invoiced, but when it is paid)
• When are expenses actually due? (Not when they are incurred, but when they must be paid)

The gap between these two determines your cash needs.

Profit Forecast

Revenue minus expenses gives you projected profit. This is your profit and loss forecast, and it tells you whether your business is heading toward profitability, breakeven, or loss.

Building Your Forecast: Step by Step

Step 1: Gather Historical Data

Pull 12 to 24 months of actual financial data. You need monthly revenue, expenses by category, and cash flow. SortBooks keeps your data categorised correctly, making this step straightforward.

Step 2: Identify Trends and Patterns

Look at your historical data for:

• Revenue growth or decline trends
• Seasonal patterns (monthly peaks and troughs)
• Cost trends (are expenses rising as a percentage of revenue?)
• Customer concentration (what percentage of revenue comes from your top 3 clients?)

Step 3: Make Assumptions

Every forecast is built on assumptions. Document yours explicitly:

• Revenue growth rate: "We assume 10% growth based on the last 12 months' trend"
• New client acquisition: "We assume 3 new clients per month at an average value of $2,000"
• Price increases: "We plan to increase prices by 5% in July"
• Cost inflation: "We assume material costs increase by 3% annually"
• Hiring: "We plan to hire one additional staff member in April"

Write these assumptions down. When you review the forecast against actual results, you can identify which assumptions were right and which were wrong.

Step 4: Build the Forecast

Create a monthly spreadsheet (or use a forecasting tool) with:

• Revenue by stream (recurring, project, other)
• COGS by category
• Gross profit
• Operating expenses by category
• Net profit
• Cash inflows (when revenue is actually received)
• Cash outflows (when expenses are actually paid)
• Net cash position

Step 5: Create Scenarios

Build three versions of your forecast:

Optimistic - Revenue at the high end of expectations, costs at the low end. This is your best-case scenario.

Base case - Your most likely projection based on realistic assumptions.

Pessimistic - Revenue at the low end, costs at the high end. This is your stress test.

Having three scenarios helps you prepare for different outcomes and make contingency plans.

Using Your Forecast

Monthly Comparison

Each month, compare actual results to your forecast:

• Did revenue meet expectations?
• Were costs in line with projections?
• Was cash flow on track?

For any significant variance (more than 10%), investigate why and adjust future months accordingly.

Decision Support

Use your forecast to evaluate decisions:

• "If I hire this person, how does it affect my net profit forecast?"
• "If I invest in this equipment, what is the impact on cash flow?"
• "If this major client leaves, what does my revenue look like?"

Rolling Updates

Update your forecast monthly with actual data and revised projections. A forecast that was created in January and never updated is useless by March. A rolling forecast - updated every month with the latest information - remains relevant and actionable.

Common Forecasting Mistakes

Being too optimistic with revenue - The most common mistake. Always err on the conservative side.

Forgetting about cash timing - Profitable does not mean cash-positive. A forecast that ignores payment timing will mislead you.

Not including all costs - Forgetting about tax obligations, super, insurance renewals, and other periodic costs creates a false sense of profitability.

Set-and-forget - A forecast only works if you use it. Review and update regularly.

Over-complexity - A simple forecast you actually use is better than a complex one you avoid. Start simple and add detail as you get comfortable.

Tools for Forecasting

• Spreadsheets - Google Sheets or Excel. Flexible and free, but manual.
• Float - Cash flow forecasting that integrates with Xero and QuickBooks
• Futrli (Sage) - Business planning and forecasting
• Spotlight Reporting - Reporting and forecasting for advisory firms
• Your accounting software - Xero and QuickBooks have basic budgeting and reporting that can support simple forecasts

Whatever tool you use, the data quality matters most. SortBooks keeps your transaction data accurately categorised, so your historical data - the foundation of your forecast - is reliable.

Financial forecasting is not about getting the future exactly right. It is about reducing uncertainty, preparing for likely outcomes, and making better decisions with the information you have. Start simple, stay consistent, and your forecasting will improve over time.