Cash Flow Forecast Template for Agencies & Consultants

Agencies sell time and expertise, so almost all costs are people, paid monthly. Clients, meanwhile, pay on 30 to 60 day terms, sometimes longer, and project milestones slip. An agency can be fully booked, profitable and still unable to make payroll because the cash from last quarter’s work hasn’t arrived yet.

Why agency cash flow is different

• Payroll is fixed, income isn’t. Salaries and freelancers are paid monthly, regardless of when clients pay.
• Payment terms are long. Many corporate clients pay on 45 or 60 day terms, and some pay late on top.
• Project work is lumpy. Milestones slip when clients are slow to approve work.
• Media spend passes through you. If you buy media for clients, you may pay the platforms before the client reimburses you.
• A few clients dominate. Losing or delaying one large client can remove a big share of monthly receipts.

A worked example

An agency bills $85,000 a month: $47,000 in retainers, $17,000 in project milestones, $8,500 hourly and $12,750 in media passed through to clients. Staff and freelancers cost $54,400 a month.

Only 10 percent of the milestone arrives in the month it’s invoiced, 60 percent next month and 25 percent the month after. If two or three milestones are invoiced in the same month, the agency carries tens of thousands of dollars of work it has done but hasn’t been paid for.

How to build an agency cash forecast

1. List retainers by client, with the day they usually pay.
2. Schedule project milestones by expected invoice date, then apply each client’s payment delay.
3. Add hourly billing from your utilisation forecast.
4. Enter media you buy on clients’ behalf in the week you pay the platform, and reimbursements when they arrive.
5. Add salaries, freelancers, software, office and insurance.
6. Keep a buffer of at least one month of payroll.

Common mistakes

Forecasting on invoice dates. Paying media platforms from your own cash without a deposit. Hiring against a pitch you haven’t won. And not tracking how concentrated your income is in one or two clients.

What the template gives you

The Consulting & Agency template includes a Project Billing tab that converts milestone invoices into collections based on how fast clients really pay, and a Media Pass-Through tab so ad spend and client reimbursements are forecast together. The cash flow vs profit guide explains why this gap matters.

Key assumptions built into the Consulting & Agency template

• The Project Billing tab turns what you invoice into cash actually collected for “Project milestones”. The example assumes 10% is paid in the month invoiced, 60% the following month and 25% two months later. Invoices sent before the start date are entered separately so the first months are right, and anything never collected shows as bad debt, so you can see what slow payers cost you.
• The Media Pass-Through tab calculates media paid for clients at 97% of media pass-through. Change a percentage once and every month of the forecast updates, so costs rise and fall with the sales that drive them.
• 5 cash in lines and 7 cash out lines are already named for consulting & agency businesses, and every one can be renamed or extended.
• The example figures follow a fairly even year, which suits most consulting & agency businesses; add your own seasonal pattern if you have one.

Every assumption sits in a yellow input cell, so you replace the example with your own numbers in minutes. The same figures flow through a 13-week weekly view, a 12-month monthly view and a 3-year outlook, and a dashboard shows your lowest balance, the weeks that fall below your minimum buffer and your cash runway.

Free or premium?

If you only need the basics, the free 12-month template or the free 13-week template will get you started today. The premium Consulting & Agency template saves the setup time and adds the tabs above, best and worst case scenarios, and an actual vs forecast tracker that shows where your forecast was wrong, so next month’s is better.

Consulting & Agency cash flow forecasting: questions

How can an agency improve cash flow?

Invoice milestones on time, ask for deposits on projects, bill retainers in advance, collect media spend before paying platforms, and follow up overdue invoices every week.

How much cash should an agency keep in reserve?

At least one to two months of payroll, more if a single client makes up a large share of revenue.

Should media spend be in an agency’s cash flow forecast?

Yes. Even if it’s billed at cost, you often pay the platform before the client pays you, so it affects cash timing.