GooglePlay Earnings Report - Is there an easy way to figure out payments?

Hi Ethan, I'm glad you asked that question. I finally published my books on Google, and sometimes the report is blank and then a day later there are indications that I have sold some books. However, I can't figure out what is going on, other than, I know the titles which may have sold. I never see a total of the money I will receive until it shows up as paid out.

If there is anyone out there who can address this topic, please do so. 

Google Play seems to not update the report (completely at least) for 24-48 hours after a sale. So I always pull it with end date at least 2-3 days ago.

Once you have the excel file, highlight all of the 'Total Publisher Earnings' column (column H for me), then go to the Formulas tab at the top and click 'autosum'. It will put the total earned at the bottom of column H.

Hope that helps and is what you meant

Adam Poe said:

Google Play seems to not update the report (completely at least) for 24-48 hours after a sale. So I always pull it with end date at least 2-3 days ago.

Once you have the excel file, highlight all of the 'Total Publisher Earnings' column (column H for me), then go to the Formulas tab at the top and click 'autosum'. It will put the total earned at the bottom of column H.

Hope that helps and is what you meant

Click to expand...

Just be careful and make note of what countries you're selling in (column D) because they show royalties in that countries currency and it can get out of hand quickly when you sell books in places like Indonesia where $1 USD = ~13k Indonesian Rupiah.

What I do is just sum up the books sold and multiply that by how much each one pays in royalties. It takes a few minutes longer, but it's accurate.

Thank you Adam and OE.  Got it.

I just pull my transaction report once a day during the month. No matter what country it's in, each sale is worth basically the same amount of dollars, so I just calculate it up that way. Your final earnings report for the month can be found under "Payment Center". You just click the profil, and a popup will come where you can download each month's spreadsheet.

You can find your payment amounts by clicking the "Payment Center" link in the side menu and then, under "Earnings Reports" click "Open".

I just check my checking out once a month for Google Play payments.  Their sales overview is a joke since the chart rounds up the money number (4.99 goes to 5).

As a side note, does anyone know if you can have them notify you if a payment was sent?

Thanks for the advice. I'll try to figure this out on the weekend.
It would be nice if they notified you when a payment was sent or informed you how often they pay you, as Kobo and Smashword do.
Sincerely,
Ethan

They pay every month. They usually send out payments for prior month sales on the first business day of the month. The latest I think I've seen them send out a payment is the 5th.

I haven't received any payments yet, but this is good to know.
Thanks,
Ethan