AdSense earnings versus bank payment: separate the three stages
Updated · 2 min read
Estimated AdSense earnings are not a bank-payment amount. Separate estimated earnings, finalized earnings and the specific issued payment, then check actual bank receipt. An estimate/finalized difference does not identify individual invalid clicks or prove that the entire difference is one adjustment.
The desktop apps export date, description, and amount as CSV. Open CSV in Excel to save an XLSX workbook. Statement support varies: verify the result against your own PDF.
Classify account and transaction type before totaling
- Select the actual AdSense payments account before downloading history; keep YouTube’s account separate.
- Use detailed transactions with the intended dates and type filters; retain the Automatic payment receipt as an individual object.
- Separate estimated performance from finalized earnings and the account’s debits/credits. Preserve the account and billing time zones.
- Calculate the remaining account balance from its supported components, then check each issued payment against independent bank receipt evidence.
What the downloaded teaching files demonstrate
The fictional typed CSV contains opening 20 EUR, estimated 100, finalized 95 and issued payment−110 for AdSense-A, plus a separate YouTube-B balance 9. We read and filtered it by account and type:20+95−110=5 remains. Blindly adding every row yields 114, which is not a valid balance. The estimate 100 and other account 9 have different meanings. Neither the 110 issued payment nor the remainder 5 establishes the bank’s received amount.
Fictional CSV: tp-236-typed-account-values
Executed worksheet results. These local checks read only constructed files. They do not test vendor accounts, bank receipt, actual fee rates, imports or native report formats.
Preserve time zone and finalization boundaries
Google’s earnings definitions distinguish the account time zone used for estimates from the America/Los_Angeles billing time zone used for finalized earnings/payments. The payments-account balance also includes debits, credits and earlier amounts, not only the selected period’s estimate.
AdSense and YouTube payments accounts have separate thresholds. The payment timeline also describes holds and balances that roll forward. Payment pending indicates issuance, not a confirmed bank-credit date; do not promise arrival on a fixed day.
Check a balance without turning it into a deposit
Keep account identity, currency, transaction types, receipt reference and bank destination/amount in the review record. Preserve missing adjustments or receipt evidence as unresolved. These are stated teaching amounts, not an export, current threshold or claim that every deduction appears as an individual line.
Review worksheet
| Synthetic object | Amount | Meaning |
|---|---|---|
| Estimated earnings | 100 | Performance estimate |
| Finalized earnings | 95 | Not the whole account balance |
| Prior balance | 20 | Earlier account amount |
| Payment / remainder | 110 / 5 | 95 + 20 − 110 = 5 |
For a bank source available only as PDF, download LocalExtract. It processes one PDF locally into date,description,amount CSV; check the extracted rows against the issued statement before using them.
Related guide: Bank statement reconciliation: balances, matches and exceptions.
Documentation for the added task checked October 17, 2026.
LocalExtract Team
We build LocalExtract, a desktop bank statement converter. Questions or corrections? Contact · Editorial policy