Most small businesses use their books to answer one question: what happened? Sales last quarter, the GST/HST owing, the numbers the accountant needs in April. Call it historical bookkeeping. It's necessary, and for a lot of owners it's where the books stop being useful.
Forward-looking bookkeeping uses the same records to answer different questions. Can we afford a second technician in March? What happens to cash if our biggest client pays 30 days late? How much can we spend on marketing this fall without dipping into the line of credit?
The transactions are identical in both cases. The difference is whether anyone turns them into a budget, a forecast and a monthly comparison. For businesses that do, the books become a practical planning tool. For those that don't, they're a compliance cost.
What Is Forward-Looking Bookkeeping?
Forward-looking bookkeeping means using your current, categorised financial records to plan ahead instead of only reporting on the past. It rests on four practices: keeping clean and up-to-date books, building a budget from last year's actual trends, running scenarios before big decisions, and comparing actual results to the budget every month. Together, they give you a cash flow forecast you can act on.
The Foundation: Clean, Current Data
Photo: Austin Distel on Unsplash
A forecast is built out of your past transactions, so every mistake in the books gets carried forward. If fuel and vehicle repairs share one "truck" category, you can't tell which one is climbing. If March was never reconciled, your starting cash figure is a guess, and every month after it inherits the error.
Three things need to be true before forecasting is worth the effort. The books are reconciled to the bank at least monthly, so the opening balance is real. Transactions are coded to a chart of accounts detailed enough to show what drives your costs, with subcontractors kept apart from payroll and software subscriptions apart from office supplies. And receivables are tracked, so you can see the gap between invoicing a client and getting paid, which is where most cash crunches start.
That groundwork is what Startup Office’s bookkeeping support provides every month: categorisation, bank reconciliation, payables and receivables. It's also why our financial planning work starts from the bookkeeping instead of a separate spreadsheet someone has to keep in sync.
Building a Realistic Budget From Last Year's Numbers
Photo: 2H Media on Unsplash
The most common budgeting mistake is starting from a revenue target and working backwards. Last year's books are a better starting point, because they already contain your seasonality, your real margins and the expenses you forgot you had.
Pull twelve months of actuals, month by month rather than as an annual total. A landscaping company might bring in $70,000 in June and $9,000 in January. An annual average hides that, and a budget built on the average will show a winter surplus that never appears in the bank account.
Then sort expenses by how they behave. Fixed costs like rent, insurance and software carry forward with any increases you already know about, such as a lease that steps up in May or payroll costs that rise when new CPP and EI rates take effect in January. Variable costs like materials, fuel and subcontractors work better as a percentage of revenue: if materials ran at 32% of sales last year, a month forecast at $50,000 in sales gets $16,000 for materials. Discretionary spending, meaning marketing, equipment and training, is where you set limits on purpose instead of by habit.
The last step turns the budget into a cash flow forecast by moving each line to the month the money actually moves. A client on net 45 terms invoiced in September pays in late October or November. GST/HST you collect isn't yours to spend; it goes back to the CRA on your filing schedule. The Business Development Bank of Canada recommends preparing monthly cash flow projections alongside the annual budget for this reason (BDC).
Scenario Planning: Asking "What If?" Before You Commit
Photo: Kevin Grieve on Unsplash
Once the budget exists, you can change one assumption and watch what happens to cash. That's scenario planning, and most owners find it the most useful part of the whole exercise.
Take a plumbing company weighing a second technician. Wages, CPP and EI, a truck lease, tools and insurance might come to $8,500 a month. Fully booked at 25 billable hours a week and $120 an hour, the new hire brings in close to $13,000 a month. On paper, that's an easy yes.
The forecast adds timing. In month one, the technician is still ramping up and nothing they bill has been paid yet. In month two, you're collecting on a partial first month while paying a full second one. Run it through the cash flow and the business is roughly $12,000 out of pocket before the hire starts paying for themselves. Knowing that in advance means you can arrange a line of credit before month one instead of scrambling for one in month two.
Marketing works the same way. Say you're thinking about raising ad spend from $2,000 to $5,000 a month. Your books already show your average job value and margin. If a typical job is worth $1,500 and leaves $600 after direct costs, the extra $3,000 needs to bring in five more jobs a month just to break even. That's a target you can check in 90 days.
BDC suggests building optimistic, most likely and pessimistic versions of your projections. Run the hire against the pessimistic one, and you'll know whether you could carry it through a slow quarter.
Scenario planning is part of Startup Office’s financial planning and analysis support. For clients who also use our payroll service, the cost of a new hire in those models comes from your actual deductions and remittances, not a rule of thumb.
The Monthly Review: Budget vs. Actual
Photo: Vitaly Gariev on Unsplash
A budget written in January and opened again in December doesn't change anything. Once each month's books are closed and reconciled, compare every line to what you planned and look for the gaps that matter.
A $300 overspend on office supplies isn't worth a meeting. Materials running six points over budget two months in a row is: either a supplier raised prices or jobs are being quoted too low, and both get more expensive the longer they run. Revenue ahead of plan in April might mean you can bring that second hire forward to June.
The review only works if the books close quickly. With the reconciliation done by the middle of the following month, there's still time to reprice a job or delay a purchase. A February review done in June is just history. BDC recommends checking projections against actual results monthly, with a deeper look each quarter.
Startup Office clients get monthly financial statements on a set schedule, and budget variance analysis is part of our financial planning service, so the comparison is ready when you sit down with your account manager.
From Recording to Planning
None of this needs new software or a finance department. It needs books that are reconciled every month, a budget built from last year's real numbers, a habit of testing big decisions before making them, and thirty minutes a month comparing plan to reality.
For most growing businesses, the analysis is the easy part. The hard part is keeping the books clean enough, month after month, that the analysis can be trusted, and that's usually the first thing to slip when the owner is also running jobs, managing staff and chasing invoices.
Startup Office handles both halves. Our team keeps your bookkeeping and payroll current, then uses those same records for budgeting, cash flow forecasting and scenario planning, all for a fixed monthly price agreed up front. Most clients are fully onboarded within 30 days, and you get direct access to an account manager who knows your numbers.
Ready to use your numbers to plan the next year? Book your free consultation with Startup Office. We'll look at where your books stand today and what it would take to turn them into a forecast you can use.
Frequently Asked Questions
How do you forecast cash flow for a small business?
Start from reconciled books so your opening cash balance is accurate. List expected cash in and cash out month by month, placing each item in the month the money actually moves rather than when it's invoiced or billed, and include GST/HST remittances and loan payments. Update the forecast monthly as actual results come in. Some businesses also keep a 13-week rolling forecast for tighter short-term control.
How do I build a budget from last year's numbers?
Export twelve months of actual income and expenses by month. Carry fixed costs forward with known increases, set variable costs as a percentage of forecast revenue, and decide limits for discretionary spending such as marketing and equipment. Then adjust for timing to turn the budget into a cash flow forecast.
What is scenario planning for a small business?
Scenario planning means changing one assumption in your budget, such as hiring an employee, raising prices or increasing ad spend, to see the effect on profit and cash before you commit. Building optimistic, most likely and pessimistic versions shows how much risk a decision carries.
How often should I compare my budget to actual results?
Monthly, as soon as the month's books are reconciled, with a deeper review each quarter. Monthly reviews catch problems like rising material costs or slow-paying clients while there's still time to act.
Can a bookkeeper help with forecasting, or do I need an accountant?
Forecasting depends on accurate, current bookkeeping, so it's often best handled by the same team that keeps your books. Many outsourced bookkeeping firms, Startup Office included, offer budgeting, cash flow forecasting and scenario planning alongside monthly bookkeeping. Your accountant can then use those records for tax planning and year-end work.
Sources
4 key steps to plan your cash flow in the coming year — Business Development Bank of Canada
Photos from Unsplash. Photographers are credited under each image.
Startup Office Team
Back-Office Specialists
