Ad payout reconciliation calculator
Enter the final U.S. dollar payout confirmed by one ad partner and the bank deposits you can match to that same payout. For a split payout, add the deposits that have posted so far.
More sharing options
Worked example
- Confirmed payout amount: 4,000 USD
- Matching bank deposits: 3,950 USD
Payout gap (expected minus received) · $50.00
See the formula
Confirmed payout amount − total matching bank deposits.
How to interpret the result
A positive gap means the deposits you matched are short. A negative gap means the deposits are higher than the confirmed payout. A zero gap means the amounts match. Verify the payer and payout reference even when the totals match. If no funds have landed, enter $0 and check the due date and payment status before treating the gap as overdue.
Publisher example
In this example, an ad partner confirms a $4,000 payout and the bank shows $3,950. Start with the $50 gap. If the partner documents a $50 amount deferred to its next statement, use the revised $3,950 confirmed amount for this payout and track the $50 on the next one. If a second $50 transfer posts for the same payout, total the two deposits and keep the $4,000 confirmed amount. A $4,050 deposit against $4,000 would return −$50. Check for a prior-period credit or an unrelated deposit before you record that amount.
Related reading: Why ad revenue can fall when CPM goes up
For AdSense, Google explains where finalized earnings and payments appear. Use the actual payment for the payout you’re checking, especially when the account balance includes credits or balances from earlier months.
For Raptive, an ad management company for publishers, open Payments, then Payment History, and use the individual payment confirmation to identify the payout you can match to your bank. If a deposit combines different periods, compare the full confirmed batch or use the allocation the payer provides.
A billing adjustment already reflected in the payout belongs in the confirmed amount. Under Google Ad Manager’s Open Bidding Direct Pay setup, the ad partner pays the publisher, while Google bills its own fee separately. Match the ad partner’s deposit first and reconcile the Google invoice on its own.