A cash flow forecast is the one financial document a creative agency needs before any other. Not a P&L, not an annual budget, not a revenue forecast sitting in a spreadsheet nobody opens. Cash flow is the daily operational reality: money in, money out, and the timing gap between the two. Getting that timing wrong is what sends profitable agencies to the wall.
The film industry calls it "float." Production companies live or die on whether they can fund a shoot before the client invoice is settled. A video studio in Melbourne faces exactly the same pressure. You win the job in May, spend on crew and gear in June, and wait until September for the final payment. The forecast is what tells you whether June is survivable before it arrives.
What a cash flow forecast actually is (and isn't)
A cash flow forecast is not a profit-and-loss statement. Profit is an accounting concept; cash is the physical thing in your bank account. You can be profitable on paper and insolvent in practice. The forecast tracks when money is expected to arrive and when it's expected to leave, over a rolling 13-week or 12-month window.
Three columns drive the whole document:
- Opening balance: the cash you start the period with.
- Cash in: payments expected to land, by date, not invoice date.
- Cash out: every committed outgoing, from contractor payments to rent to software subscriptions.
The closing balance at the end of each week or month becomes the opening balance of the next. If it goes negative, you have a problem. If it goes negative in week 7 of a 13-week forecast, you have 6 weeks to fix it.
Building the "cash in" column honestly
Most agencies overestimate the timing of inflows. They enter invoice amounts on the date the invoice was sent, not the date the client historically pays. Those two dates are almost never the same.
Pull 12 months of payment data. Calculate average days-to-pay per client. A government client with 45-day standard terms and a habit of paying on day 52 is not a 45-day client. Use the actual number. For new clients with no payment history, apply your worst-case average from existing clients.
Retainer revenue is the most predictable line on the forecast because it arrives in a fixed cycle. Retainer agreements that specify payment in advance rather than in arrears dramatically improve cash timing. If you haven't structured your retainers that way, the forecast will make that gap visible in a hurry.
Project milestones are trickier. Map them to the contract, then subtract your average delay. A "50% on delivery" milestone is a delivery-day payment in theory. In practice it's delivery plus 30 days, plus however long it takes the client to approve the invoice internally. Factor that in.
Building the "cash out" column without gaps
Fixed costs are easy. Rent, salaries, software subscriptions, insurance: these hit on predictable dates and don't move. Pull them directly from your bank statements and sort them by date of debit rather than month.
Variable costs are where agencies typically undercount. Freelance contractors are the biggest variable line for most studios. The cost is real the day the contractor works, even if you invoice the client four weeks later. Don't put contractor costs in the forecast on the date you expect to recoup them. Put them on the date you pay them.
Tax obligations belong in the forecast too: quarterly BAS payments to the Australian Taxation Office, PAYG instalments, and annual income tax if you're operating as a company. Many small agencies treat tax as a surprise, which means they haven't built it into the forecast. Use your accountant's estimate and schedule it as a fixed outgoing on the correct ATO deadline date.
Equipment hires, travel, and production materials tend to spike around active shoot periods. Review your project pipeline and overlay those costs against your shoot schedule. The forecast should show a cash dip every time a major production is underway, which is exactly when you want visibility rather than a surprise.
The 13-week rolling forecast
A 12-month annual forecast is useful for strategic planning. A 13-week rolling forecast is useful for actually running the business. Thirteen weeks is long enough to see problems forming and short enough that the numbers are grounded in real, known commitments rather than speculation.
Update it every week. Move the window forward by one week, add the new week at the far end based on what you know, and adjust any week within the window where reality has diverged from the plan. A client payment that was due Monday and didn't arrive needs to move forward in the forecast immediately, because it changes every subsequent closing balance.
The discipline is the update. An agency that builds the forecast once and checks it quarterly hasn't built a cash flow management tool. It's built a document that will be confidently wrong when it matters most.
What to do when the forecast shows a gap
A negative closing balance in the forecast is information. It's not a crisis yet; it's a warning with a lead time. The options are narrow but clear:
Accelerate inflows. Chase outstanding invoices before they're due. Offer early-payment discounts to clients who can clear invoices ahead of schedule. Bring forward a project milestone if the client can approve it. Invoice on the day of delivery rather than accumulating invoices at month-end.
Defer outflows. Negotiate payment terms with suppliers. Push a non-critical software purchase to the following month. Delay a hire by four weeks if the forecast shows that's enough to clear the gap.
Access a facility. A business overdraft or line of credit doesn't solve a structural cash problem, but it bridges a short timing gap. The time to arrange that facility is before you need it. A bank will extend credit to a business with clean financials and a documented forecast. It won't extend it to a business asking for emergency funds because payroll is due Friday.
Review your pricing model. If the forecast shows recurring gaps every quarter, the problem isn't cash management, it's project economics. A thorough look at project profitability often reveals that certain job types are structurally underwater, which no amount of cash timing can fix.
Linking the forecast to project decisions
The cash flow forecast should inform which projects you take on and when. A large project starting in August that requires significant upfront production spend could create a gap in September even if the project is profitable. The forecast lets you see that before you sign the contract, not after the September bank statement arrives.
Some agencies use the forecast to decide when to hire. If the rolling window shows three consecutive months of comfortable positive balance with confirmed work in the pipeline, a new staff member is a defensible decision. If the window shows a flat balance with one large project driving all the comfort, the hire can wait.
This is what separates a forecast from a hope. It converts gut feelings about pipeline into a dated, numbered view of what's actually coming. Build it once, update it weekly, and the surprises get smaller every quarter.