Google Play earnings to dashboard
Two currencies, one dashboard: your Play earnings report.
Pull the monthly earnings report out of Google Play Console, drop the CSV here, and the two currency systems in it stop fighting each other. Amounts in buyer currency are kept separate from amounts in merchant currency, Taxes Collected is excluded from revenue because Google remits it, and Financial Status separates charges from refunds so the net figure is genuinely net.
Prefer the full explorer? Open the app, or start from the generic dashboard builder.
Why the earnings report has two of every money column
A Play earnings report describes each sale twice. Once in the buyer's currency, which is what the person in Brazil actually paid, and once in your merchant currency, which is what the money became by the time it reached you. Between those two columns sits a Currency Conversion Rate, and the whole trio exists because Google settles in one currency while selling in dozens. Total the buyer column across a global month and you have added reais to rupees to euros. Total the merchant column and you get a real number.
The tax column is the other place people lose money that was never theirs. In most markets Google acts as the seller of record for tax purposes, collects the local rate, and remits it. That amount sits in Taxes Collected, it is in your file, and it is not revenue. Count it and every VAT-heavy market looks more profitable than it is. This page treats it as pass-through by default and shows it as its own panel so you can still see the scale of it.
How to export from Google Play Console
- Open Play Console and go to Financial reports Sign in at play.google.com/console, pick the developer account rather than a single app, and open Download reports, then Financial. Reports are account-level, so an app filter comes later.
- Choose the earnings report Earnings is the row-level financial file with the currency columns. Estimated sales is a different, lighter report and Statistics is a different beast again. For revenue questions you want Earnings.
- Notice it lives in Google Cloud Storage There is no ordinary download button. Play Console hands you a Cloud Storage bucket path, and you either browse it in the console or copy the files down with gsutil. This throws people the first time.
- Grab one file per month The earnings report is written monthly, so a quarter is three separate files and a year is twelve. Download the months you want before you start, and keep the naming so you can tell them apart.
- Drop the file here Country, Product Type and Financial Status become filter chips immediately, and the merchant currency total is the one the revenue panel leads with.
If you have several months to look at, merge them into one file first and keep a single header row. The report format is stable month to month, so a merged file behaves exactly like a single large one.
Try with sample Google Play Console data (the same columns, 110 rows, no upload needed).
What the dashboard shows
Every panel below is built from a column that is actually in the export, named the way Google Play Console names it.
- Net earnings by month. Date on the axis and the merchant currency amount as the value, with refund rows pulling the line down where they belong.
- Charged against Refund. Financial Status as two series, giving you a refund rate by value rather than the count-based figure the console shows.
- Product type mix. Subscriptions against in-app products against paid app installs, which is usually the split that decides where the next quarter of work goes.
- Country and buyer currency. Country on the map, with buyer currency as a companion dimension so you can see which markets carry conversion exposure.
- Taxes collected as its own panel. Not folded into revenue, but visible, because knowing how much tax passes through your account is useful even when none of it is yours.
- Device and SKU detail. SKU ID ranked by earnings, and Device as a filter, which together answer whether a tablet-only feature is worth building.
Date,Package Name,Product ID,Product Type,Country,Buyer Currency,Amount (Buyer Currency),Currency Conversion Rate,Merchant Currency,Amount (Merchant Currency),Charged Amount,Taxes Collected,Financial Status,Device,SKU IDWhat makes a Play earnings report awkward
- Every amount exists twice. Buyer currency and merchant currency, joined by a conversion rate. Only the merchant column is safe to total across countries, and only the buyer column tells you what a customer paid.
- Taxes Collected is not yours. Google remits it in most markets as seller of record. Including it inflates revenue by the local VAT or GST rate in exactly the markets where that rate is highest.
- Financial Status is the sign. Refund rows sit alongside Charged rows. Filter to Charged and your refund rate reads as zero; forget the column entirely and refunds may add to revenue instead of subtracting.
- The report lives in a storage bucket. There is no simple download button. You reach it through a Cloud Storage path from Play Console, which means the first pull usually involves gsutil and a permissions detour.
- One file per month, always. Monthly granularity is the unit of the report. Three files for a quarter, and no single download that spans them, so merging is a standard step rather than an edge case.
- Conversion rate varies within a month. It is applied per transaction, so two identical sales a week apart can produce different merchant amounts. Averaging the rate column and back-calculating will not reproduce the totals.
Read the merchant currency column, leave the tax column out of revenue, and keep the refund rows in. Play earnings reports are dense, but they are honest once you stop asking one column to answer two questions.
Frequently asked questions
Which amount column is my actual revenue?
Amount in Merchant Currency, which is your money after conversion. The buyer currency amount tells you what the customer paid in their own money and cannot be summed across markets, since it mixes units. Charged Amount is what was billed including tax in some report versions, so it runs higher. When in doubt, total merchant currency and treat the rest as context.
Should I count Taxes Collected as income?
No. In most countries Google is the seller of record for the transaction, collects the local sales tax or VAT, and remits it to the authority directly. That money passes through your report without ever being yours. Counting it makes high-VAT markets look disproportionately valuable and will not match your payout. This page keeps it visible but out of the revenue figure.
Where do I actually download the earnings report?
Play Console does not give you a normal file download for it. Under Download reports, then Financial, you get a Google Cloud Storage bucket path for your developer account. You can browse it in the Cloud console or copy the files with gsutil from a terminal. It is the one genuinely unfriendly step, and it catches almost everyone the first time they need historical data.
How do I look at a full quarter?
Download the three monthly files and merge them into one, keeping a single header row. The schema does not change between months, so the merged file behaves like one large report. Once merged, the Date column gives you a proper time axis and month-over-month comparisons stop being a manual exercise in three separate spreadsheets.
Do refunds already reduce the totals?
They do if you keep them. Refund rows carry a Financial Status of Refund and a negative amount, so a straight total nets them out correctly. The failure mode is filtering to Charged only, which quietly removes every refund and reports gross as net. The dashboard here keeps all rows and shows the two statuses as separate series so the gap is visible.
Is my developer data sent anywhere?
No. The file is parsed by JavaScript in your browser and the charts are drawn from memory. An earnings report reveals your revenue, your market mix and your product pricing, which is competitively sensitive even though it contains no customer names. There is no upload endpoint here, no account, and nothing retained after you close the tab.
Related tools
Open an earnings report with both currencies handled
110 rows across a month: several buyer currencies with conversion rates, tax collected in the markets where Google remits it, and a handful of refund rows.
Open the sample Google Play Console dashboard