ARTICLEReconciliation

How to reconcile agency and ad account spend

When a team works through several agencies, money is rarely lost in big sums. It goes in small mismatches nobody reconciled for months.

11 November 2026

What to reconcile

Every agency has three numbers that must agree:

  • top-ups — what you transferred to the agency;
  • spend — what actually ran in that agency's ad accounts;
  • balance — top-ups minus spend minus fees.

If the balance in your books differs from the agency sheet, find the gap right away while it is small.

How often

Daily — pull spend per ad account. Weekly — reconcile each agency balance. Monthly — the final check before closing the period.

A weekly check takes 10–15 minutes per agency. A quarterly one, after it piles up, takes days and awkward conversations.

Where money gets lost

  • an ad account moved to another buyer but spend still goes to the previous one;
  • the agency changed its fee and the books still use the old rate;
  • a refund of unused balance never arrived or arrived with another amount;
  • time zones: a day in the ad account and in the agency sheet do not match;
  • FX: top-ups in one currency, spend in another.

Step by step

  • export spend per ad account for the period;
  • map accounts to the agency and the buyer they belong to;
  • work out the expected balance: top-ups − spend − fees;
  • compare it with the balance the agency shows;
  • log every gap with a reason and close it with an adjustment or a claim to the agency.

The key is the account → agency → buyer mapping. Without it reconciliation becomes a needle-in-a-spreadsheet hunt.

Automation

In FinanceCore agency sheets are matched automatically to ad accounts and the buyer behind each one, top-ups and spend are kept apart and the agency balance is reconciled against the real one. More on media buying accounting in FinanceCore.

NEXT

Want the same without spreadsheets?

We will show FinanceCore on numbers like yours. Twenty minutes on Telegram is enough to see if it fits.

01We show the screens
02We connect your sources
03We close the first month together

Book a free demo

We will show FinanceCore on numbers like yours. Leave your contacts — we will reply within one business day.

What do you need?

Or message us on Telegram

PricingFree demo