Finance Toolkit — free template
13-Week Cash Flow Forecast Template
A rolling weekly cash forecast for project-based firms: receipts by client and milestone, disbursements including payroll, and a clear opening-to-closing cash position every week. The early-warning system every project firm should be running.
What it is
A 13-week cash flow forecast is a week-by-week projection of money in and money out over the next quarter — roughly one quarter ahead, the horizon where most project firms can realistically predict receipts and disbursements. Unlike a monthly P&L, which reports what already happened, the 13-week forecast tells you where cash is heading: when the balance tightens, when it loosens, and what you can do about it while there's still time.
For project-based firms, this is the single highest-leverage finance discipline. Milestone billing means receipts arrive in lumps; payroll and subcontractors go out every week without fail. The gap between those rhythms is where liquidity surprises live. The template closes that gap by putting receipts, disbursements, and the resulting weekly cash balance on one page.
What's inside
The template is organized as a weekly grid — 13 columns, one per week — with the sections below. Each section rolls up to an opening and closing cash position per week.
Weekly receipts
Cash you expect to collect, broken down by source so the forecast stays tied to real activity: client payments by project or invoice, milestone receipts tied to billing schedules, retainer and fixed-fee collections, and any other operating inflows. Receipts are dated by the week you expect cash to arrive — not the week you invoice, and not the month the revenue posts. This discipline alone fixes most forecasting errors.
Weekly disbursements
Cash going out, in the categories that matter for a project firm: payroll and benefits (always the largest line — timed to your actual pay cycle), subcontractor and vendor payments, rent and facilities, debt service and equipment payments, and operating expenses. Disbursements are dated by the week cash leaves the account. Large, lumpy payments — a quarterly insurance premium, an annual software renewal — get placed in the exact week they hit, which is where generic monthly budgets go wrong.
Opening and closing cash
Each week starts with an opening balance, adds receipts, subtracts disbursements, and lands on a closing balance — which becomes next week's opening. A summary row tracks net cash flow per week and the cumulative position. A second row marks your minimum operating threshold (many firms use 4–8 weeks of disbursements) so dips below it are visible at a glance.
Variance section
The forecast is only as good as its accuracy, so the template includes a variance comparison: each week, you record actuals against the forecast and note the drivers of any meaningful difference — a client payment that slipped, a milestone delayed, a payroll run that was higher than expected. Over a few weeks, the variance notes teach you where your assumptions are optimistic and make the forecast sharper.
How to use it
The template works only if it becomes a weekly rhythm. The rhythm that works for most firms is simple — thirty minutes, same time each week:
1. Update actuals
Replace last week's forecast columns with what actually happened. Record the closing cash balance and the big variance drivers — slipped receipts, timing shifts, unexpected payments.
2. Re-forecast receipts
Walk the receivables aging and the milestone schedule. For each expected payment, confirm the week cash will actually land — call the client if an invoice is near terms. Move anything that slipped to its new week.
3. Re-forecast disbursements
Confirm payroll timing, upcoming vendor payments, and any large one-off outflows in the next 13 weeks. Add anything new — a hire, a project expense, a loan payment.
4. Read the cash line
Look at the closing balances across all 13 weeks. Where does the line dip near or below your minimum threshold? Those weeks get action now — accelerate a milestone billing, defer a discretionary payment, draw on a line of credit before you need it.
5. Roll forward
Drop the completed week and add a new week 13, so the horizon always covers a full quarter. The forecast never goes stale.
Review the forecast with whoever controls billing and whoever controls spending — usually the owner and the operations lead. Decisions change when both of them can see the same cash line: milestone invoices go out earlier, client follow-up gets more consistent, and discretionary spend gets timed to strong weeks instead of tight ones.
Who it's for
This template is built for owners and finance leads at project-based firms of 10–250 people — IT and technology consulting, engineering and EPC, architecture and design, and professional services firms — where billing arrives in milestones or uneven project cycles while payroll goes out like clockwork. If you've ever checked the bank balance on a Friday and felt surprised, or delayed a payment because a client invoice was "almost in," this is the discipline that replaces that anxiety with a plan.
It's also the right starting point if your firm has outgrown gut-feel cash management but isn't ready for a full finance function: one spreadsheet, one weekly meeting, and a cash position you can defend to partners, lenders, or yourself.
Get the template
Template downloads are being prepared — check back soon. The walkthrough above covers everything the template contains, so you can start building your own version now or wait for the finished file.
Coming soon
Want the discipline without building it yourself? Cash-flow visibility is a core part of a Mesfonic engagement — the forecast gets built, maintained, and reviewed with you every week. See the Cash Flow & Financial Visibility service.
Run your projects with financial confidence.
Talk to a finance advisor who speaks project economics — backlog, bench, WIP, and margin — not just accounting.