Kindle Forum banner

1 - 11 of 11 Posts

·
Registered
Joined
·
1,655 Posts
Discussion Starter · #1 ·
Hi everyone:

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

I've downloaded the Summary Report, but it's not very easy to read and understand.

Thanks in advance for your help.

Sincerely,

Ethan
 

·
Registered
Joined
·
483 Posts
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. 
 

·
Registered
Joined
·
1,237 Posts
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 :p
 

·
Registered
Joined
·
176 Posts
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 :p
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.
 

·
Registered
Joined
·
2,050 Posts
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.
 

·
Registered
Joined
·
1,655 Posts
Discussion Starter · #9 ·
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
 

·
Registered
Joined
·
2,050 Posts
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.
 
1 - 11 of 11 Posts
Top