A Payment Calendar for Your Agency: Advances, Milestones, Contractors
If your agency can adopt only one financial tool, it should be the payment calendar. Not a profit report, not fancy analytics — the calendar, the one that shows how much money will be in the account tomorrow, next week and next month. Because an agency's main financial pain isn't losses, it's cash gaps, and the calendar is exactly what catches them ahead of time.
What's specific about an agency is that both the money coming in and the money going out are a mixed bag: advances, project milestones, retainers on one side; payroll, contractors, taxes, advertising on the other. Let's break down how to build a payment calendar for an agency specifically, and how to actually use it. For a general, niche-agnostic walkthrough, see How to Build a Payment Calendar.
What a payment calendar is and why an agency needs one
A payment calendar is a schedule of all your upcoming inflows and outflows by date, from which you can read the account balance for each day ahead. In essence it's a cash-flow forecast in calendar form. It has one job: to show you a future shortfall before it hits, so you have time to react — ask for an advance, move a payment, or dip into a reserve.
Without a calendar, an agency finds out about a gap on payday. With one, it finds out two weeks ahead, while there's still something you can do.
What to enter: inflows
Inflows in an agency are anything but uniform, and each type has its own date. Advances — on the project start date. Milestones — on the schedule for delivering interim results. Retainers — on the day of the month the client pays. It's important to enter real dates adjusted for payment terms: if a client pays net-30, put the inflow not on the date of the sign-off, but on the date the money actually lands. Client ad budgets that pass through you in transit don't belong in your income calendar — that isn't your money.
What to enter: outflows
With outflows, dates matter just as much. Payroll — on schedule (advance/main). Contractors — on the agreed payment terms. Taxes — on the tax authority's calendar; these are the most often "forgotten" large payments. Rent, subscriptions, services — on their charge dates. The more completely you enter your outflows, the fewer "surprises" you get: most gaps come from exactly one forgotten recurring payment that happened to land during a lull in income.
How to read the calendar: catching a gap two weeks out
The calendar isn't useful in itself — the daily balance is. Look at the projected balance for each day: if on some day it turns negative, that's a future gap. Spotting it in advance gives you time to maneuver — ask a client to pay earlier, agree with a contractor to push a payment, raise the advance on a new project. The very same levers are covered in detail in Cash Gaps in an Agency: How to Avoid Them.
Example: a week in an agency's calendar
Monday: balance 80k. Tuesday: advance on a new project +90k (balance 170). Thursday: payroll advance −120k (balance 50). Friday: payment to two contractors −40k and a tax −25k (balance −15). There it is, a gap on Friday — but you can see it back on Monday.
What to do: ask the client on a milestone due next week to pay a day early (+60k), or move one contractor's payment to Monday. Either step clears the minus. The point is that you make this call calmly on Monday, not in a panic on Friday evening.
How to start keeping one
Start with a short horizon — 4–6 weeks ahead. Enter the inflows you know about on their real dates and every mandatory outflow, and look at the projected balance every day. Within a week of keeping it, you'll see your gaps ahead of time for the first time. For the wider context of getting your agency's finances in order, see Management Accounting for a Marketing Agency: Getting Started.
You can keep a calendar by hand in Excel, but it's constantly going out of date. In Finmap the payment calendar builds itself from your transactions and updates the projected balance automatically — the gap is visible ahead of time. Try it free for 7 days.
Frequently asked questions
A profit report shows how much you earned. A payment calendar shows how much money will be in the account on each day ahead. You can have a profit and still have no cash on hand at that moment — and that's exactly what the calendar catches.
To start, 4–6 weeks ahead is enough. That's enough to see the nearest gaps and react in time. Later you can extend the horizon to 2–3 months.
On the date the money actually lands, not the date of the sign-off. If a client pays net-30, the inflow goes in a month later — otherwise the calendar shows money that isn't there yet.
Because that's pass-through money, not your income. If it moves through your account, keep it separately so it doesn't distort the forecast of your own balance.
