Agency Cash Flow: How to Forecast the Lean Months

Paul Boards ·

To forecast an agency's lean months, build a 12-month cash flow projection with three layers: recurring revenue already under contract, likely revenue with an estimated date, and all fixed and seasonal expenses. A lean month shows up when the projected balance drops below the minimum reserve you've set, and the forecast shows it weeks or months in advance.

Most agencies only feel the crunch when it arrives because they look at the bank statement, which shows the past. A forecast looks ahead. This guide explains how to build one, what data to use, and how to act when it points to a gap.

Why agencies have predictable lean months

A marketing agency lives on contracts that start, end, and change size. Costs, on the other hand, are almost all fixed: payroll, tools, rent or remote setup, taxes. That mismatch creates patterns that repeat.

  • 13th-month salary and vacation pay: costs known months in advance, but many agencies don't set money aside for them.
  • Contract end dates: launch projects or campaigns with a fixed term stop billing on a date that's already in the contract.
  • Late payments: the client pays in 30 or 45 days, but salaries are due on the fifth business day.
  • Client seasonality: a retail client may cut budget after the year-end sales.

All of these events have a date. If the date is on record, the lean month can be calculated.

The three layers of the forecast

1. Contracted revenue

List every active contract with its monthly value, due date, and end date. A contract with no end date should have a review date, because renewal isn't guaranteed. This layer is the most reliable and should be the basis for decisions.

2. Likely revenue

Proposals under negotiation, verbally agreed amendments, and one-off projects the client has hinted at. Record the amount, the expected date, and an honest probability. A proposal sent yesterday isn't worth the same as one about to be signed. If you use a CRM pipeline, the stages help you assign that probability.

3. Expenses

Split them into fixed (salaries, owner's draw, tools, accountant), variable (freelancers, video production, pass-through ad boosts), and seasonal (13th-month salary, vacation pay, annual license renewals, quarterly taxes where applicable).

How to build the forecast in practice

  1. Set up 12 columns, one per month. Start with the current month.
  2. Fill in contracted revenue based on the month the money comes in, not the month the service is delivered.
  3. Add likely revenue on a separate row, multiplied by its probability.
  4. Enter all expenses, including seasonal ones in the month they're due.
  5. Calculate the running balance: opening balance plus inflows minus outflows, month by month.
  6. Mark the minimum reserve, for example two months of fixed costs, and highlight the months that fall below it.

Make two versions of the balance: one with contracted revenue only and one that includes likely revenue. The gap between them shows how much of your future depends on deals that haven't closed yet.

Reading example

Picture a six-person agency whose biggest client, a gym chain, has a contract through August. The contracts-only forecast shows a comfortable balance through July and a sharp drop in September, which coincides with the annual payment for a design tool. With that information in March, the agency has five months to renew, replace the revenue, or negotiate installments on the license.

Is your cash still in a standalone spreadsheet? Record transactions, categories, and bank accounts in one place that connects to your projects. Organize your agency's finances for free

Where to keep this data

A spreadsheet works at first, but it tends to fall out of date because it depends on someone copying transactions from the bank and invoices. Ideally, you record receivables and payables in the same place where the agency manages clients and projects. In Scrumboards, a Brazilian work management platform, the finance module has transactions, customizable categories, bank accounts, recurring transactions, and a document vault. Access is restricted to people with permission, which matters when the whole team uses the system for tasks.

Well-defined categories make a difference when forecasting. Separate "recurring revenue," "project revenue," "payroll," "tools," and "taxes" so you can read the pattern of each line instead of one blended total.

What to do when the forecast points to a bad month

Bring forward or reschedule receivables

Negotiate with long-standing clients to move their due date to before payroll. For new projects, ask for a deposit at signing. These changes are easier to propose months in advance than in the week of the crunch.

Reduce dependence on a single client

If one contract makes up a large share of revenue, its end becomes the lean month. The forecast makes this visible in hard numbers, which helps you prioritize prospecting.

Adjust variable expenses

Freelancers and outsourced production can be rescheduled. Fixed expenses require bigger decisions and should be the last lever.

Give sales a deadline

When the forecast shows a gap in September, the sales target gets a date: the new contract needs to be signed by July to bill in time. The CRM pipeline starts being read alongside cash flow.

A 30-minute monthly routine

  • Reconcile the month that just closed against the bank statement.
  • Update contract end dates and renewals.
  • Review the probabilities of open proposals.
  • Add the new month at the end of the forecast so you always have 12 ahead.
  • Record the decision made for each month below the reserve.

Done every month, this routine turns cash flow into a decision-making tool. Without it, the forecast becomes a nice-looking file nobody opens.

Warning signs before the crunch

Some signs show up weeks before the balance drops and deserve attention in the monthly review:

  • Overdue receivables growing from one month to the next.
  • A key contract with no renewal conversation three months before it ends.
  • Proposals stuck in the same pipeline stage for more than a month.
  • Variable expenses, such as freelancers, rising without matching new revenue.

When two of these signs show up together, it's worth redoing the forecast right away, without waiting for month-end. An agency that notices in May that a language school client hasn't responded about the July renewal still has time to act. By July, all that's left is cutting costs.

Common mistakes

  • Booking revenue in the month the service is delivered instead of the month it's received.
  • Counting proposals as if they were closed.
  • Forgetting annual costs that come due only once.
  • Mixing the partners' personal finances with the agency's.

Frequently asked questions

What's the ideal forecast horizon?

A rolling twelve months, updated every month. The first three are the most accurate.

How much should I keep in reserve?

A common benchmark is two to three months of fixed costs, but the amount depends on each agency's risk. Set it with your accountant.

Is a cash flow statement the same as an income statement?

No. The income statement (P&L) shows results on an accrual basis; cash flow shows when money comes in and goes out.

Do I need software, or will a spreadsheet do?

A spreadsheet works if someone updates it with discipline. Software cuts rework when transactions are already linked to clients and accounts.

How should I handle a client who always pays late?

Forecast the payment on their actual average payment date, not the contract date.

Start with the next three months

If a 12-month forecast feels like too much work, start with the next three: contracts, payroll, and annual bills. Creating your agency account and recording your first transactions doesn't require a credit card. To see how finance connects to clients and projects, explore the Scrumboards modules or check out the available plans.