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.