The three numbers every ad account should reconcile daily

1. How should you reconcile billed spend?

This is the simplest check and the one most ad buyers skip. Open your ad platform dashboard. Note yesterday's spend. Now open your billing console, credit card statement, payment history in Meta Ads Manager, Google Ads transaction log, and compare.

Match the account ID, currency, reporting time zone, and date before comparing. When the numbers differ, check these mechanical causes first:

• Billing timing. A payment-method charge can cover a different period from the dashboard date being reviewed.
• Currency conversion timing. When the payment method and ad account use different currencies, settlement timing can change the converted amount.
• Account-level adjustments. Credits and invalid-activity adjustments can make served cost differ from billed cost.

Google says the daily spending limit is 2 times the average daily budget for most campaigns, while the monthly spending limit is 30.4 times the average daily budget for most campaigns. It also distinguishes served cost from billed cost after adjustments such as invalid activity. See Google Ads bidding and spending limits. A high-cost day is therefore not automatically a billing error. Investigate any remainder that has no documented timing or adjustment explanation.

2. How should you reconcile recorded conversions?

Choose one business outcome, such as an accepted lead or paid order, and write its definition above the sheet. Pull the platform count and the CRM or commerce count with the same time zone and status rules. Keep view-through outcomes separate when the platform provides them.

Some gap is normal because ad platforms, GA4, and business systems can use different event definitions, attribution rules, and time fields. The useful signal is not whether they match exactly, but whether each count follows its documented definition and whether the difference changes after data settles.

When is conversion data mature enough to compare?

Do not treat yesterday's platform count as final. Google Ads says reporting lags can take 24 to 48 hours and recommends conversion-time columns when comparing its data with third-party analytics. See Google Ads conversion tracking data.

GA4 can take longer to settle for attribution. Google says attributed conversion data for each channel can be updated for up to 12 days after the conversion is recorded. See GA4 modeled key events. Log the provisional daily number, then review the mature date range before changing strategy.

What the gap tells you that no single dashboard can

A widening conversion gap is an early-warning system for three classes of failure:

1. Collection failure. If the platform count falls while CRM outcomes stay steady, check the tag, consent state, event diagnostics, and import job.
2. Business-system change. If the platform count stays steady while accepted CRM outcomes fall, check event quality, duplicate handling, refunds, and sales-stage mapping.
3. Definition change. If a reporting setting or conversion window changes, record it in the sheet so the new series is not compared blindly with the old one.

This is not a number to force to zero. Establish the account's own range using mature data, then investigate unexplained movement outside that range.

3. How should you calculate budget pace?

Use cumulative spend rather than one day alone. Compare cumulative actual spend with cumulative planned spend, then calculate the pace required across the remaining active days.

The formula:

Required daily pace = (Remaining budget) ÷ (Remaining days in the billing cycle)

Worked example with stated assumptions: assume a $15,000 budget, $6,000 spent, and 15 active days remaining. The remaining budget is $9,000, so the required daily pace is $600. If a platform's average daily budget is lower than the pace required from that platform, the plan cannot catch up without an approved budget-setting change or a reallocation from another channel.

Why does cumulative pacing beat a one-day check?

Each platform paces only the budget it can see. An account-level sheet can include all channels, approved changes, and the total business budget.

• Daily variation. Google documents that most campaigns can spend up to 2 times the average daily budget on a given day while remaining subject to a monthly limit.
• Budget changes. A planned increase or decrease needs its own dated line, or the sheet will report a management decision as an anomaly.
• Multi-platform accounts. No platform dashboard knows what every other platform spent. The account-level plan must reconcile the combined total.

What is the pacing decision rule?

Investigate when the remaining budget cannot be delivered across the remaining active days under the current settings, or when the current settings would exceed the approved total. This rule is based on what the account can recover, not an invented universal variance threshold.

4. What should the daily reconciliation table contain?

Each number catches a different failure mode. Together they form a 10-minute safety net that no single dashboard provides.

Cross-platform measurement is not standardized. In a 2025 survey of more than 79 advertisers, agencies, publishers, and technology providers across 27+ European markets, 58% named lack of standardization as a barrier to wider adoption of measurement solutions. See the IAB Europe study.

When costs or outcomes cannot be explained, a structured ecommerce tracking audit can trace the event from the ad click through GA4, the storefront, and the reporting layer.

5. What is the daily ad account reconciliation workflow?

Use one sheet per ad account and preserve the definitions above the table. Follow the same order each day:

1. Freeze the comparison rules. Record the account IDs, time zone, currency, event definition, attribution view, and budget period.
2. Pull cost. Export platform cost and billed cost. Explain adjustments and timing differences.
3. Pull outcomes. Export attributed conversions and business-system outcomes. Label immature dates instead of treating them as final.
4. Calculate pace. Compare cumulative actual spend with the cumulative plan, then calculate the pace required for the remaining active days.
5. Classify the exception. Mark it as billing, tracking, outcome quality, pacing, or a planned change.
6. Assign the next check. Name the owner, the evidence needed, and the date when delayed data will be reviewed again.

A spreadsheet is enough when it preserves definitions and explanations. Automation becomes useful after the manual comparison is stable, because an automated report will reproduce unclear definitions faster.

6. When are three numbers not enough?

This ritual covers the operational layer, the mechanical failures that cost money and go unnoticed because no single dashboard shows them. It does not replace:

• Creative performance analysis. The conversion gap tells you that tracking is working. It does not tell you which creative is driving the conversions. That is a separate workflow.
• Audience and placement diagnostics. If pace is on track but CPA is climbing, the problem is not pacing, it is audience saturation or creative fatigue. The three numbers flag the symptom (spend is fine, conversions are drifting) but diagnosing the cause requires drilling into the campaign layer.
• Attribution modeling. If your business has a 30-day sales cycle and you are checking daily conversion gaps, the number will be noisy. For long-cycle businesses, run this ritual weekly on a 7-day rolling window instead of daily. The mechanics are the same; the frequency matches the sales cycle.

The point of this ritual is not to make you a better analyst. It is to make sure nobody has to be an analyst to catch the things that burn money while everyone is looking at ROAS.