How to build a financial forecast for a small business

Financial forecasting for a small business starts with estimating sales, expenses and when cash will move in or out. If you’re starting without trading history, build a 12-month cash flow forecast and base your estimates on expected sales, costs and market conditions. This gives you a practical starting point, not a fixed prediction.

It’s understandable to focus on whether the business will be profitable. But profit on paper doesn’t always mean cash will be available when bills fall due. A useful forecast tracks both, helping you spot tight periods early and make informed decisions about spending, stock and growth.

This guide explains how to build a business forecast, choose a spreadsheet or accounting software, and update projections as actual results come in. You’ll also learn how best-case, worst-case and most-likely scenarios can help you weigh decisions about cash flow, tax and profit. Regular reviews let you adjust the plan as your business changes.

How to create a financial forecast for a new business?

Build the forecast from expected sales, operating expenses, tax obligations and loan repayments, then map when cash moves. Compare best-case, base-case and worst-case scenarios to see how different sales and cost assumptions could affect your decisions.

1. Estimate Revenue Conservatively

   Start with sales you can reasonably expect, not the target you hope to reach. For a product business, multiply expected units sold by the price per unit. For a service business, estimate likely bookings and fees.

   If trading history is unavailable, use market research, industry trends and consumer behaviour to support your assumptions. Set out how many customers you expect, what they may buy and when sales could occur. Avoid assuming every prospect converts or that demand rises steadily. For example, if past sales have risen by 10% annually, that rate can provide a baseline for the next year, not a guaranteed outcome.

2. Project Fixed and Variable Expenses

   List fixed expenses that recur regardless of sales, then estimate variable expenses that change with activity. Rent and regular software costs may be fixed; materials, packaging or transaction fees may rise with each sale.

   Use supplier quotes, current bills and planned staffing to build each estimate. For example, calculate materials based on the units in your sales forecast instead of keeping the amount flat as sales increase. Include less frequent costs in the period they are expected, and don’t assume expenses will stay unchanged as the business grows. This makes your budget more realistic and shows how operating costs affect profit.

3. Prepare Financial Statement and Cash Flow Forecasts

   Create an income projection showing sales, expenses and profit for each forecast period. Base revenue and expense projections on your assumptions, then record relevant Australian tax items, such as GST payable, PAYG withholding, superannuation contributions and company tax obligations.

   Prepare a separate cash flow forecast covering incoming and outgoing cash over 12 months. Record when customers are expected to pay, when suppliers and staff need payment, and when tax and loan repayments fall due. An invoice counts as forecast revenue, but it doesn’t become available cash until payment arrives. Keeping the statements separate helps reveal a cash shortfall that a profit projection may not show.

4. Compare Best-Case, Base-Case, and Worst-Case Scenarios

   Build three versions of the forecast by changing the assumptions, not the underlying structure. Use the base case for your most supportable estimates, the best case for stronger sales, and the worst case to test pressure on cash flow. One downside test is sales 20% below expectations; another is costs double the expected amount.

   Compare the expected profit and cash position in each scenario, then identify the decisions each outcome might prompt. For example, you might delay discretionary spending if lower sales leave less cash for repayments. Financial forecasting for a small business is more useful when each scenario links the figures to a practical action, rather than treating one projection as certain.

What Is Cash Flow Forecasting for Small Businesses?

A cash flow forecast maps when money is expected to enter and leave your business. Compare it with income and balance sheet forecasts to see whether projected profit translates into cash available for repayments and operating costs.

1. Build the Cash Flow Forecast

   Set up a monthly forecast covering 12 months, with separate lines for expected receipts and payments. Use invoices, supplier terms, payroll dates and historical bank activity to estimate timing. Australian small businesses may wait 30-60 days for customers to pay invoices, so record expected collection dates rather than treating every sale as immediate cash.

   Prepare an income statement forecast for sales, expenses and profit, alongside a balance sheet showing assets and liabilities. A cash flow statement then tracks actual and expected cash movements. For example, a business might invoice A$20,000 in March but collect A$12,000 that month. If A$10,000 in fixed costs and A$5,000 in variable costs are also due, the business shows A$5,000 paper profit but a negative A$3,000 cash position. The different statements reveal why.

2. Plan Cash Flow Around Debt Repayments

   Enter each loan repayment in the period cash leaves the account, including principal and interest if the repayment schedule separates them. Compare those payments with expected customer receipts and other essential outgoings. This shows whether income is likely to arrive before the repayment date or whether the timing could create a shortfall.

   Test the forecast against slower collections or lower sales before committing cash to new investment. If customer payments arrive later than expected, for instance, check whether the forecast still covers scheduled repayments, suppliers and payroll. Keep debt obligations visible in the cash flow projection rather than treating them only as expenses in the income statement. A forecast supports planning; it doesn’t replace the repayment schedule.

3. Check Business Cash Flow Health

   Each month, compare actual bank movements with forecast receipts and payments, then investigate the differences. A quarterly review can reveal recurring late collections, rising supplier costs or expenses missing from the original estimate. Use what you find to update the next forecast instead of carrying forward assumptions that no longer match trading.

   Check the balance sheet as well as cash flow. Current assets are expected to be consumed or converted into cash within 12 months, while current liabilities are expected to be paid within 12 months. Compare these balances with upcoming payments to understand near-term pressure. A business with growing profit but overdue invoices may still face tight cash flow, so track receivables and payment timing alongside income.

Accounting software, spreadsheets and advisor support

Choose tools that make assumptions easy to update and actual results easy to compare. A spreadsheet may be enough for a simple forecast; accounting software can help organise transactions and reports.

1. Choose Forecasting Tools and Templates

   Start with a spreadsheet or accounting software your team can maintain consistently. A template can include rows for income, fixed expenses, variable expenses and cash movements, with columns for each forecast period. Check that its structure fits your business instead of copying assumptions from an unrelated template.

   For example, a Melbourne retailer might track expected sales by product category, while a consultant may forecast client work by project. Use formulas to carry assumptions through projections, but label them clearly so changes are easy to follow. Keep a copy of the original forecast to compare with actual results.

   Keep the working forecast in one reliable place, even if its source information comes from several records. Avoid separate versions without clear ownership. Otherwise, people may use different figures for the same period, leaving cash balances or expense estimates inconsistent.

2. Use Forecasting Software and KPIs

   Use software to organise financial information, then choose key performance indicators (KPIs) that explain what drives your results. A sales-based business might track average order value and units sold; a service business could monitor project bookings and completed work. Choose measures directly connected to income, costs or cash needs.

   Review some KPIs weekly and others monthly, depending on how quickly they change. Compare each measure with the assumption behind your forecast. If bookings fall below expectations, update projected income and consider whether variable expenses will change too. A tool can display figures, but it can’t make an unrealistic assumption useful.

   Use dashboards and reports for specific tasks, such as spotting a change in sales or checking whether expenses match the plan. Keep definitions consistent: if one report counts booked work and another counts completed work, their totals aren’t directly comparable. Balance useful detail with the time needed to maintain it. A small set of clear measures is easier to act on than a crowded dashboard.

   Schedule a quarterly review to compare actual figures with projections and revise assumptions. An adviser can help interpret unusual movements, examine tax-related assumptions and connect the forecast with business planning. Bring your current forecast and recent records to the discussion. This makes it easier to identify whether a variance reflects timing, a changing sales pattern or an expense that needs attention.

Financial projections versus forecasts and financial modelling

Give each tool a clear purpose: projections explore assumptions, forecasts track expected results, and modelling tests how changes affect the figures. Together, they can connect business plans with practical decisions.

1. Distinguish Projections from Forecasts and Models

   Label each document by purpose. A forecast shows the results you currently expect, based on available trading information and current assumptions. A financial projection explores a possible outcome if stated assumptions hold, such as a new service gaining customers or sales growing at a chosen rate.

   Financial modelling is the structure behind those estimates. It links assumptions, such as sales volume or operating costs, to projected income, cash flow and balance sheet figures. Keep assumptions visible so you can see what drives each result. Pro forma statements can present possible outcomes, but may exclude one-time expenses and don’t typically comply with generally accepted accounting principles.

2. Use Projections to Plan Business Goals

   Connect each projection to a decision, such as expanding capacity, seeking funding or improving profitability. A year-by-year three-year projection can help organise midterm planning. Show how expected revenue, costs and cash needs may change as your business pursues each goal.

   For a funding discussion or major expansion, set out the forecast assumptions and how funds would support planned activity. Test whether extra sales would also require more stock, staff or working cash. Use reports and historical trends to support estimates where available. For a new business, market research can inform assumptions before trading records build up.

3. Compare Actual Results with Projections

   Compare actual results with projected figures for the same period, using consistent revenue and expense categories. Review each line item, not just total profit. A sales shortfall might reflect fewer orders, lower prices or delayed work, and each cause may call for a different response.

   Investigate forecast variances greater than 10-15% in any line item. Check whether the difference reflects timing, a changed business trend or an assumption that needs revision. Record the reason and the action taken, then carry that learning into the next estimate. This turns monthly reports into a practical record of decisions and outcomes.

4. Update Estimates and Projection Frequency

   Set a review schedule that matches how quickly your business is changing. Small businesses are advised to update forecasts at least quarterly, or monthly if operations move quickly. During the first year or so, prepare projections monthly or quarterly to track early trading patterns.

   At each review, replace outdated estimates with current information, then compare the revised outlook with your business goals. Established businesses can use a rolling 12-month forecast, adding a new period as time passes. If conditions change sharply, such as a delayed launch, adjust the relevant assumptions rather than leaving the old projection untouched.

Financial forecasting and business decisions

A forecast earns its place when it informs a decision. Use its assumptions to test options, then compare expected outcomes with actual results before committing cash or capacity.

1. Set a decision before changing the forecast. Name the choice you need to make, such as ordering more stock, hiring or delaying an expansion. Then identify the figures that could affect it: expected sales, operating costs, cash timing or loan repayments. This keeps the analysis focused. A sales forecast should show the assumptions behind revenue, not just a headline total.

   For example, separate confirmed orders from sales that depend on winning new customers. If the new work doesn’t arrive, the difference helps show whether the business can still cover its planned costs.

2. Stress-test costs and timing before approving a plan. For a start-up budget, the Small Business Development Corporation advises adding 20 per cent to the cost forecast for unexpected expenses. Include that allowance in the relevant start-up costs, then consider whether the business has enough cash to meet them.

   Test how a delayed launch or slower customer payments would affect planned spending. Record which assumptions changed and whether the decision still makes sense. This reveals pressure points without treating a single estimate as certain.

3. Use projections to choose the scale of growth. Compare the expected revenue from a growth plan with the extra resources it requires. More sales may call for additional inventory, raw materials, staff hours or borrowing. Estimate those needs alongside expected income, then check the cash flow impact before increasing commitments.

   For instance, a business considering a larger stock order can compare projected demand with storage, supplier payment timing and available cash. If the forecast shows a mismatch, adjust the order size or timing. A projection is most useful when it links a goal to the practical steps needed to reach it.

4. Turn warning signs into specific review actions. Track actual performance against assumptions and note the cause of each meaningful variance. If a current ratio remains below two to one, use the forecast to assess options for improvement, such as reviewing receivables, payment timing or short-term commitments.

   Record the action, its expected effect and when you’ll review it. At the next quarterly check, compare actual figures with that expectation. This helps distinguish a temporary timing issue from a trend that calls for a broader change to business planning.

For support connecting projections with growth and business planning, discuss your business planning needs.

Brown Hamilton Partners: Tax Advisory

Brown Hamilton Partners can help connect business decisions with tax and longer-term planning. Its Tax Advisory and Business Planning & Coaching can support owners reviewing their plans, while Business Tax Returns address business tax reporting. Estate Planning may also be relevant when considering how personal and business priorities fit together over time.

For a discussion, bring the decisions you’re weighing and the financial information behind them. Brown Hamilton Partners can help you consider how tax, business planning and estate planning relate to your goals. Contact Brown Hamilton Partners to discuss your next steps.

Turn your forecast into a confident next step

A forecast can do more than organise figures. Used consistently, it can help shape decisions around the business you want to build while keeping tax planning and cash flow in view. Financial forecasting for a small business is more valuable when it supports a clear direction instead of sitting untouched in a spreadsheet.

If you’re weighing a change in structure, planning for growth or considering how business decisions may affect tax, tailored advice can help connect those choices. Brown Hamilton Partners offers Tax Advisory, Business Planning & Coaching and Business Tax Returns to support business owners with tax and planning needs.

Bring the decision you’re considering and the figures you’re working from. A focused conversation can help you identify what to examine next and keep your plans grounded in the numbers.

Contact Brown Hamilton Partners to discuss your business plans, and take the next step with clarity.

Frequently Asked Questions

What tools can help you forecast your financials?

A spreadsheet or accounting software can organise your forecast if you can update assumptions and compare them with recorded transactions. Before choosing, check whether it can clearly separate income categories, recurring costs and one-off items. For example, a business with seasonal sales could use separate monthly columns to make quieter periods visible. Keep one controlled working version and document who updates it, so decisions rely on consistent figures.

How should a startup do revenue projections?

A startup should estimate revenue from its customer offer, expected demand and ability to deliver. Identify likely buyers, how customers will find the business, and how much work or stock can be supplied. A café, for example, could consider seating capacity, opening hours and likely customer traffic before estimating sales. Treat untested demand as an assumption, then revise it as enquiries and completed sales provide evidence.

What Are Financial Projections?

Financial projections estimate future results based on stated assumptions. They help you explore a possible business outcome, such as adding a product line or changing staffing levels. Make the assumptions clear so readers can see what would need to happen for that outcome. A projection can support planning, but it isn’t a record of actual performance or a promise that results will match estimates.

What Is the Difference Between Profit and Cash Flow?

Profit measures the difference between income earned and expenses incurred over a period; cash flow tracks money received and paid. The timing can differ. A business may complete work and record income before a customer pays, while wages or supplier bills are due earlier. So a profitable period can still bring cash pressure. Review both measures to understand performance and whether available funds can meet upcoming payments.

How do you create a financial forecast for a small business step by step?

Start by gathering sales records, bills, payroll information and planned purchases. Set assumptions for revenue and costs, organise them by period, then estimate when receipts and payments will occur. Prepare projected income, cash movements and financial position, and test how changes in sales or expenses affect the results. As trading continues, compare the forecast with actual records and update assumptions that no longer reflect the business.

What financial statements and data are needed to prepare a business forecast?

Use recent profit and loss statements, balance sheets and cash flow statements as a starting point where available. Add details behind the totals, such as unpaid customer invoices, supplier bills, payroll commitments, stock records and planned equipment purchases. A new business can use quotes, proposed contracts and market research to support assumptions. Estimates linked clearly to a record or decision are easier to review.

How do you forecast cash flow, revenue, expenses and profit?

Estimate sales from expected customer activity, then subtract the costs of delivering those sales to assess gross profit. Include operating expenses to estimate overall profit. Separately, place expected receipts and payments in the periods when cash is likely to move. This distinction helps identify timing pressure. For example, a large planned purchase may affect cash immediately, while its impact on reported expenses may be spread across accounting periods.

How often should a small business update its financial forecast?

Review your forecast at least quarterly, and more often if sales, costs or operations change quickly. Revisit it after a major decision, such as hiring, changing prices or delaying a launch. Compare new results with assumptions, record why key figures changed, and adjust future periods accordingly. Regular reviews keep the forecast useful without requiring you to rebuild every estimate when a minor transaction differs from plan.

Article by

Rochelle Hamilton

Rochelle has Bachelor Degrees in both Commerce and Law and was admitted to practice as a solicitor in 1995.

Having moved directly into tax consulting in her professional career, she now has 20+ years of experience in providing tax advice to a wide variety of clients across many and varied issues. This has given her a great depth of knowledge and understanding of tax issues and the impact they have on both individuals and businesses.

Rochelle is not just about tax. She is passionate about seeing businesses succeed and enjoys helping business owners understand the figures behind their business so that together they can develop the strategies necessary to achieve the goals they are aiming for.