Last March, a Moncton-area agency owner sent us their books. Revenue was up 22% year over year. They still couldn’t make payroll that month.
That’s not a rare story. It’s what happens when a $50,000 contract clears over five months but the payroll run doesn’t wait five months for anything.
Service businesses live with a specific kind of danger: you can be profitable on paper and still be weeks from a cash crunch, and most owners don’t see the gap until it’s already closed in on them.
This guide is the fix — a 12-month cash flow model built for exactly this problem, the tools worth using, the mistakes that cause it, and a few things about running a service business near Moncton that generic templates skip.
Why Service Businesses Get Hit Harder Than Product Businesses
A retailer can sit on inventory and sell it whenever demand shows up. You can’t do that with time.
If an hour goes unbilled today, it’s gone. There’s no shelf to store it on for next month. That’s the structural reason service firms fall into the “profitable but insolvent” trap so much more often than product companies do — your costs run on a calendar, but your revenue runs on someone else’s approval process.
Worth sitting with that for a second before you open a spreadsheet.
Building the 12-Month Cash Flow Model
A rolling 12-month forecast tracks what’s coming in and going out, month by month (or week by week if you want more precision). Done well, it’s basically an early warning system — you see the dip coming three months out instead of finding it in your bank balance.
Step 1 — Start With What’s Actually There
Your opening balance is your real, liquid cash across all accounts today. Not what’s invoiced, not a credit line you haven’t drawn on — just what’s sitting in the bank right now.
Step 2 — Forecast Collections, Not Sales
Here’s where a lot of models quietly fall apart: a signed contract is not cash. A cleared payment is.
Pull your historical Days Sales Outstanding, group your inflows by type (retainers, milestones, one-off work), and apply some realistic confidence weighting to anything still sitting in the pipeline.
One thing most forecasting guides never bring up: not all clients pay at the same speed, so averaging them into a single DSO number actually hides the problem instead of revealing it. A government contract and a small private client behave completely differently.
| Client Type | Why It’s Slow (or Fast) | Realistic Collection Window |
| Government / institutional | Multiple sign-offs, budget cycles | 60–90 days |
| Enterprise retainer clients | Finance team review | 30–45 days |
| SME / private clients | One decision-maker | 15–30 days |
| First-time clients | No track record yet | Add 10–15 days |
Blend these together and your “average DSO” tells you nothing useful about where your actual cash gap is coming from.
Step 3 — Map Every Outflow
Split your costs into three honest categories:
- Fixed — rent, subscriptions, insurance, salaried payroll
- Variable — contractors, project materials, bonuses
- Periodic — annual renewals, quarterly taxes, equipment upkeep
Nothing revolutionary here, but skipping this step is how the “irregular expense ambushes you in month 9” problem happens.
Step 4 — Don’t Forget Bench Cost (Nobody Talks About This One)
Bench cost is what you’re paying staff or contractors who are between billable projects. It’s real money going out, but it hides inside “payroll” on most reports instead of getting called out on its own.
The way to catch it early is a simple utilization check, run monthly:
Utilization Rate = Billable Hours Delivered ÷ Total Paid Hours
Once that number drops under roughly 75–80%, your payroll is quietly outrunning what you’re bringing in — and it usually shows up in your actual cash position two or three months later, right when a slow sales quarter makes it worse.
Spreadsheets or Accounting Software?
| Spreadsheets | Accounting Software | |
| Best for | Early-stage firms, custom scenarios | High invoice volume, established firms |
| Upside | Free, fully flexible | Bank feeds, automated tracking |
| Downside | Manual entry, formula errors | Costs more, needs clean bookkeeping |
| Bottom line | Fine for your first real model | Worth it once volume grows |
The bigger risk with spreadsheets isn’t the formulas breaking outright — it’s what you might call slow drift. Your model is dead accurate in January. By April someone’s deleted a column or typed a number over a formula, and nobody catches it until the forecast and the actual bank balance are miles apart.
A decent habit to build: once a month, check last month’s forecasted ending balance against what actually landed. If it’s off by more than 10%, go find out why before it happens again.
Handling the Parts You Can’t Predict
Client scopes shift. Payments get delayed. A few habits keep the forecast honest anyway.
Keep a buffer. Three to six months of baseline operating costs, sitting somewhere liquid. It’s what stops a stalled project from turning into a missed payroll run.
Get paid up front, at least partly. A 25–50% deposit on project work covers your initial labor and materials, and it tells you a lot about a client before you’re deep into the job.
Have financing lined up before you need it. Growth stretches cash thin faster than most owners expect — hiring ahead of a big project, taking on a new location, whatever it is. A flexible Business Loan Moncton gives you room to bridge that gap without slowing down to wait for invoices to clear.
What Moncton’s Market Actually Does to Your Timing
This is the part a national template just won’t tell you.
Greater Moncton’s economy leans heavily on government and public administration, logistics (it’s genuinely a transportation hub for the region), healthcare, and a growing professional services scene. If your client mix touches any of that, your cash flow has a rhythm to it whether you’ve noticed or not.
Public-sector and larger institutional clients tend to finalize budgets around the fiscal year-end in March. Practically, that means inflows often bunch up in Q1 and Q4, and mid-summer goes quiet — the people who approve your invoices are harder to reach in July and August than in any other month.
If that sounds like your client base, build the seasonality into the model directly instead of assuming demand is flat year-round. Otherwise you end up being the business that’s suddenly hunting for working capital financing in Moncton every August, not because anything’s actually wrong, but because the forecast never accounted for a lull everyone could have seen coming.
The Mistakes That Show Up Again and Again
Treating a signed contract like cash. Booking $50,000 in month one when the client’s actually paying over five months sets your whole model up wrong from the start. Only count cash when it clears.
Trusting stated payment terms. Net 30 on paper rarely means day 30 in reality. Look at your actual collection history and adjust — if it’s really Net 45 or Net 60, model that instead of what the invoice says.
Forgetting the once-a-year expenses. Insurance renewals, quarterly tax remittances, seasonal bonuses — these get missed constantly because they don’t show up monthly. Give them their own line and set money aside for them ahead of time.
Building the forecast once and shelving it. A model made in January and never touched again is basically a historical document by June. Update it with real bank numbers, ideally monthly.
Waiting too long to look for financing. This one costs businesses the most, and it’s rarely discussed. Financing takes time to underwrite — days at minimum, sometimes weeks. Most owners notice their cash gap the same month it starts to hurt, then apply under pressure and end up with worse terms than they’d get otherwise. The better move: treat your forecast as a trigger. The moment it shows your cash dipping toward your buffer line, start that conversation. Lenders offering a small business loan in Moncton will generally give better terms to a business that’s planning ahead of a dip than one that’s already stuck in it.
A Simple Way to Sort Your Receivables
Nothing fancy — just three buckets, checked monthly.
Current (0–30 days): Standard follow-up. Forecast it at full confidence, no discount needed.
Watch (31–60 days): Time for an actual phone call, not another email. Discount this to around 80% confidence in your model.
At risk (60+ days): Get someone senior involved. This is also where invoice factoring or short-term financing starts making sense, rather than letting the delay snowball. Drop confidence to 50% or lower until it’s actually paid.
Run this monthly and two things happen — your forecast stays realistic instead of optimistic, and you get an early, low-stress signal that it might be time to look into a business line of credit in Moncton before an at-risk invoice turns into an actual payroll problem.
Where This Leaves You
That agency owner from March? Same revenue, same clients, same contracts. The only thing that changed six months later was that they could see the payroll gap coming in July instead of discovering it in July.
That’s really all a good forecast does. It doesn’t create cash — it just gives you enough warning to go get it before you’re desperate for it.
So this week, do three things: check your real cash position, not what’s invoiced. Map the next 90 days of what’s actually coming in and going out. And if that map shows a gap on the horizon, start the conversation about a Business Loan Moncton now, while you’re choosing the lender instead of the lender choosing the terms.
