Budget Pacing Formula: How to Calculate Pacing (With Examples)

Every agency ends up building the same spreadsheet. A column for the monthly budget, a column for spend so far, and a third column that turns those two into a number you can put in front of a client. The maths behind that third column is not complicated. What trips people up is that two different formulas both get called "pacing", they answer different questions, and picking the wrong one is how an account ends up $3,000 short on the 29th.

This post covers both, with the numbers worked through. If you would rather skip the arithmetic entirely, our free budget pacing calculator runs it in the browser. If you're new to the concept, start with our guide to budget pacing and come back.

Formula 1: pacing percentage (where you stand)

This is the reporting number. It compares what an account has actually spent against what it should have spent by today, and expresses the gap as a percentage.

Take a $10,000 monthly budget in a 31-day month. Daily share is $322.58. By the end of day 12, the account should be sitting at $3,870.96. It's actually spent $4,300. Divide one by the other and you get 111%. The account is running about a tenth hot.

The reason to express it as a percentage rather than a dollar gap is that percentages compare across accounts. A $429 overspend means something very different on a $10,000 budget than on a $200,000 one. Pacing percentage puts a boutique retainer and an enterprise account on the same axis, which is exactly what you want when you are scanning thirty of them on a Monday morning.

What counts as good

Those bands loosen at the start of the month. On day 2, one heavy day can throw pacing to 140% and mean nothing at all, because there's barely any denominator to divide by. Most teams ignore pacing entirely for the first three or four days, then start paying attention. By the back third of the month the same bands become urgent, because there is much less runway left to correct in.

Formula 2: daily spend target (what to do next)

Knowing an account sits at 111% doesn't tell anyone what to change. That is the second formula's job, and it is the one that does the real work:

Same account. $10,000 budget, $4,300 spent, 19 days left. Remaining budget is $5,700, so the target for tomorrow is exactly $300, down from the $322.58 it would have run at if the month had started on plan. The overspend gets absorbed across the rest of the month rather than sitting there as a debt.

The difference between this and dividing the monthly budget by 30 is self-correction. A flat daily figure assumes every previous day landed on target, and no day ever does. Recalculating from what is actually left folds yesterday's miss into today's number automatically. Recalculate every morning and the account converges on its budget. Use a fixed daily figure and whatever gap opened in week one is still sitting there in week four, waiting for someone to notice it.

A flat daily figure assumes every previous day landed on target, and no day ever does.

Both formulas on one account, over a month

Notice the pacing column walking back toward 100% on its own. Nobody intervened after day 5. The daily target dropped by $22, the account held that number, and the overspend dissolved. That's the argument for recalculating daily rather than reporting weekly.

The Excel and Google Sheets version

Put the monthly budget in B1, spend to date in B2, and the date you are calculating for in B3. Then:

EOMONTH is doing the quiet work here: it handles February, leap years and 30-day months without anyone hard-coding a 30. Format the pacing cell as a percentage, then add conditional formatting that turns it amber below 90% or above 110% and red below 80% or above 120%. Once that's in place you stop reading the sheet row by row and start reacting to colour, which is the only version of this that survives twenty accounts.

One warning about the sheet. It's only as current as the last person who pasted spend into column B. The formulas stay correct. The input goes stale by Wednesday. Most pacing failures I see aren't maths errors. They're a spreadsheet nobody updated over a long weekend.

Where the simple formula breaks

The two formulas above cover a straightforward monthly budget on a single account. Four situations bend them.

Weekends and paused days

A B2B account that spends nothing on Saturday and Sunday shouldn't be counting those as active days. Divide by weekdays remaining instead of calendar days remaining, or the maths will tell you to spend $300 tomorrow when tomorrow is a Sunday and the real weekday number is $420. Our pacing calculator has a weekday-only toggle for exactly this.

Flight dates that ignore the calendar

Plenty of campaigns run on their own clock: a six-week product launch, a 10-day sale. Swap "days in month" for "days in flight" and "days elapsed" for "days since the flight started". The formula shape is identical; only the denominators change. Forcing a flight budget into a calendar-month view is how a campaign ends up 60% paced on the day it finishes.

Spend the formula cannot see

This one does the most damage. If you pace against the campaigns under your management but the account also carries campaign-budget-optimised ad sets, manually-run campaigns, or campaigns someone excluded and forgot, then your spend-to-date figure is lower than the real account-wide number. Pacing looks healthy while the invoice runs over. Always reconcile against the platform's account-level month-to-date spend, not just the sum of the campaigns you are watching.

Platform overspend rules

Setting a daily budget is a request, not a cap. Google can spend up to twice a daily budget on any given day, balancing it out over the month. Meta smooths across the delivery period in its own way. If your target says $300 and Google spends $520 on a high-traffic Tuesday, the formula is fine but reality moved anyway. That's why the daily recalculation matters more than getting the initial number perfect. We covered the specifics in what changed in Google's pacing rules.

When the formula stops being the hard part

Two accounts in a spreadsheet is a solved problem. The maths doesn't get harder at thirty accounts. The operations do. Thirty accounts across five platforms means roughly 150 spend figures to collect before any formula runs at all, every day, and the collection is where the time goes and where the errors creep in.

That's the point where teams either accept a weekly cadence and eat the drift, or automate. Budget pacing tools mostly differ in how much of the loop they close: some just surface the pacing percentage, others recalculate the daily target, and a few write the new budget back to the platform. Pace runs the second formula every day across Google, Meta, LinkedIn, Microsoft, TikTok, Reddit, X Ads and Amazon Ads, then applies the resulting daily budget gradually, with hard day-over-day limits so nothing swings wildly on one bad data point.

The arithmetic doesn't change either way. Whether a person or a system runs it is a question about how many accounts you have, not about the maths.

Frequently asked questions

Jordan Parrello

Founder of Pace. Ran an agency pacing sheet by hand for years before building the thing that checks it every 5 minutes. About Pace or LinkedIn