1. Your earnings report
Needs a Transaction Type column and Amount (Merchant Currency) (the Estimated sales report’s Financial Status and Charged Amount also work). Used when present: Transaction Date, Product Title, Product Type, Buyer Country and Merchant Currency. Choose several files (for example one per month) and they are combined.
2. Assumptions (edit these)
Only used when the file needs them. The fee percentage applies only to a report with no Google fee rows. Base currency and rates apply only when a file mixes merchant currencies; a rate says what one unit of that currency is worth in the base currency.
Choose a file or paste the text, then click Analyze.
Result
By product type
| Type | Charges | Refunds | Google fee | Fee rate | Net |
|---|
By product
| Product | Charges | Refunds | Refund rate | Net |
|---|
By country (top 12)
| Country | Charges | Net |
|---|
By month (last 12 in the file)
| Month | Charges | Refunds | Google fee | Net |
|---|
The model, and what it leaves out
- Net is the sum of the merchant-currency amounts in the file with each row signed by its direction: charges positive; refunds and Google fees negative; fee refunds positive. Tax rows are shown on their own line and stay in the net exactly as the report gives them.
- Reconciles. The product type rows, product rows and month rows each add up to the same net figure in the summary line.
- Effective fee is Google fee rows (less fee refunds) over charges net of refunds. If buyer tax is inside the charge amount the rate reads slightly low; check against your payout statement.
- Refund rate is refunded value over charged value. Refunds appear in the month Google records them, not always the month of the sale.
- Estimates: a report with no fee rows gets the fee percentage you enter, and every fee and net figure is then labelled an estimate.
- Findings ignore groups under five charges. This tool cannot see your fee-tier enrollment.
- Not modelled: payout timing and payment-processor fees outside the report, taxes you owe, other income, ads, and anything not in the file.
Common questions
How do I see what Google Play actually paid me, by app and country?
Download the Earnings report from Play Console (Download reports, then Financial) and drop the CSV here. The tool adds up charges, refunds, Google fee rows and taxes by product, product type, country and month. The file is read in your browser and never uploaded.
How do I see the fee Google took?
The Earnings report has a Google fee row for each charge. The tool adds them, shows the effective fee as a share of charges net of refunds overall and per product type, and lets you see whether subscriptions sit near the reduced 15% tier while paid apps and in-app products sit near 30%.
What if I only have the Estimated sales report?
That report has charges and refunds but no fee rows. The tool then applies the fee percentage you enter (default 15%) to net charges and labels every fee and net figure as an estimate. Use the Earnings report for the real fee.
How are refunds counted?
Refund rows subtract from charges; the refund rate is refunded value over charged value, shown per product. A product needs at least five charges before it is ever flagged for refunds.
How does it handle currencies?
The Earnings report already gives an amount in your merchant currency, so no rate is needed for a normal account. If a file mixes merchant currencies, the most common one is the base; rows in another currency are left out and named until you type a rate such as EUR=1.10.
Are the column names right for my report?
They are matched by alias from memory of Play Console reports and no real report was available when this was built. If your file is not read, the page names the rows it skipped and why. Buyer city, postcode and order numbers are never read.
Is this tax or financial advice?
No. It applies arithmetic to your file and the assumptions you enter. It is independent of Google and is not affiliated with or endorsed by Google LLC.