# Google Ads automatic-payment reconciliation

Account/customer ID: ___  
Billing country and payment setting: ___  
Currency: ___  
Month: ___  
Report time zone, filters and export date: ___  
Billing document/export date: ___  
Prepared by / checked by: ___

Use one account and currency. Positive balances mean owed to Google; a credit balance is negative. Keep evidence references beside every input. Amounts in the named input rows are positive unless the balance itself is a credit. Add explicit signed rows for refunds, reversals and other events.

## 1. Report to billing

Report cost total: ___

| Item not already included in report total | Signed effect | Posting date | Original service month | Evidence |
| --- | --- | --- | --- | --- |
| ___ | ___ | ___ | ___ | ___ |

Adjusted report subtotal (report cost total + listed signed effects): ___  
Matched billing costs and non-payment adjustments: ___  
Unexplained report-to-billing difference (matched billing costs and non-payment adjustments − adjusted report subtotal): ___

Do not subtract a credit that is already included in the starting report. Keep prior-service-month adjustments separate from the current month's advertising activity.

## 2. Google balance

| Row | Amount | Evidence |
| --- | --- | --- |
| A. Opening balance owed | ___ | ___ |
| B. New costs, taxes and fees | ___ | ___ |
| C. Other debit adjustments | ___ | ___ |
| D. Non-payment credits applied | ___ | ___ |
| E. Successful payments Google records | ___ | ___ |
| F. Calculated closing: A + B + C − D − E | ___ | Calculation |
| G. Documented closing balance | ___ | ___ |
| Residual: G − F | ___ | Investigate unless zero |

Record each extra event and its sign before modifying the formula. Google can put payments in a Credits column; payment event type belongs in E, not also D.

## 3. Individual payment matches

| Local reference | Google date / status | Amount / currency | Bank posting date | Receipt and bank evidence |
| --- | --- | --- | --- | --- |
| ___ | ___ | ___ | ___ | ___ |

Successful payments Google records this month: ___  
Add earlier Google payments the bank posts this month: ___  
Subtract this month's Google payments the bank posts later: ___  
Add other separately evidenced bank effects with their sign (fees, reversals, currency differences): ___  
Expected bank postings: ___  
Actual bank postings: ___  
Residual, actual minus expected: ___

A later bank posting needs an actual match, or remains an open reconciling item awaiting confirmation. Pending authorizations are not duplicate completed payments. Do not add a carried closing Google balance to the timing adjustment for payments already recorded by Google: they are different items.

## 4. Open items and handoff

| Unexplained amount | Exact missing or unmatched item | Next check and owner | Evidence/status |
| --- | --- | --- | --- |
| ___ | ___ | ___ | ___ |

Handoff: report cost ___; current-service credits ___; prior-service adjustments ___; opening Google balance ___; closing Google balance ___; Google payments ___; proven bank timing effects ___; bank postings ___; residuals ___; unresolved items and owner ___.

This worksheet reconciles records. It does not prescribe accounting or tax treatment of prior-period adjustments.