Free tool for agency owners

Marketing Agency cash flow forecast for the next 13 weeks

An agency forecast is mostly payroll against collections. Put each client invoice in the week that client usually pays.

Cash in the bank today$ Customer payments per week, on average$ Payroll per run, all-in$ Payroll schedule Next payroll is in Fixed bills per month, paid on the 1st$ Other spending per week (supplies, fuel, card)$

Add one-off items (tax payment, equipment, a big invoice)

Negative for money going out, positive for money coming in.

Lowest point

Safe line (2 payrolls)

cash you never want to drop under

Weeks under the safe line

of the next 13

Week of	Comes in	Payroll	Bills and other	Cash at week end

The starting numbers are an example for a marketing agency. Replace them with yours.

Getting the forecast right for a marketing agency

Use how fast each client usually pays.
Show pass-through spend going out and coming back as separate lines.
Put new hires in from their start date, before the new client pays.

An example

An agency signs a $12,000 a month retainer and hires a strategist to start on the 1st. It bills at month end on 45-day terms. The strategist gets paid four times before the first payment arrives. The forecast shows that gap before you sign, so you can negotiate terms or time the hire.

What to watch

One client growing past a quarter of revenue
Pass-through ad spend you paid before the client paid you
Hiring ahead of a signed contract

Get your full forecast every Monday

One Page CFO builds your 13-week forecast from your QuickBooks, invoice by invoice, and a CFO checks it before it reaches you.

Check if I fit →