Bookshelf | Reports | Community | KDP Select

Home » Amazon KDP Support » Publisher Support » Account Issues

Thread: Reports not matching and not making sense


This question is not answered. Helpful answers available: 2. Correct answers available: 1.

Reply to this Thread Reply to this Thread Search Forum Search Forum Back to Thread List Back to Thread List

Permlink Replies: 9 - Pages: 1 - Last Post: Jul 2, 2012 10:34 PM Last Post By: clemlaw
weikelm2

Posts: 14
Registered: 11/25/11
Reports not matching and not making sense
Posted: Jun 18, 2012 1:40 PM
 
Click to report abuse...   Click to reply to this thread Reply
Has anyone seen this? Last week I gave away about 7,600+ copies and sold about 80 copies and had 30 borrows, minus 3 refunds according to month to date sales.

On the six weeks sales report, it shows about 7,500+ "sold" with 5 refunds at 70% for an average of 4 cents each.

What's strange is there are also about 100+ "sold" at 35% with N/A for the file data. Not sure how they got 35% since the book retails for $3.99 and is not available through any other channel.

I'm totally baffled. The mismatch on refunds I get since people might have returned free copies, but beyond that, it looks to me like they tried to make the downloads match the royalties and not the other way around.

Message was edited by: weikelm2

Message was edited by: weikelm2
tigerofdarkness

Posts: 92
Registered: 02/14/11
Re: Reports not matching and not making sense
Posted: Jun 18, 2012 2:47 PM   in response to: weikelm2 in response to: weikelm2
 
Click to report abuse...   Click to reply to this thread Reply
If you have selected 70% royalty for your book, you can still get sales at 35%.

It all depends on where the customer lives as to what royalty you get - if they are in the list of countries where the 70% applies, you get 70%, if they are elsewhere you get 35%. The list of countries is on the page where you set the price and royalty, as I recall.
weikelm2

Posts: 14
Registered: 11/25/11
Re: Reports not matching and not making sense
Posted: Jun 18, 2012 2:56 PM   in response to: tigerofdarkness in response to: tigerofdarkness
 
Click to report abuse...   Click to reply to this thread Reply
I hope that's the case. They have about 175 sales at 35% of $3.99, but they've tallied that up to about $12.
david19271

Posts: 193
Registered: 05/21/12
Re: Reports not matching and not making sense
Posted: Jul 1, 2012 6:27 AM   in response to: weikelm2 in response to: weikelm2
 
Click to report abuse...   Click to reply to this thread Reply
As far as I can tell, Amazon pays a very small royalty on free downloads, and then manipulates the royalties due on your actual sales in order to offset that.

If an auditor looked at my report he would probably recommend hiring a lawyer, but the total amount of royalties due at the bottom are very close to what they would have been had Amazon just listed all the free downloads at 0.00 for everything, and then properly reported the paid sales.

Only a handful of line items on my royalty report bear any resemblance to reality. All the rest are completely fabricated with no explanation. I have no idea why they do it this way when a proper accounting would be easier to prepare, easier to explain to an auditor, and more likely to stand up when they get sued.

As long as the amount of money they owe me comes close to squaring with what I expect as a result of the sales report, I guess I can't complain.

I am not planning any free promos in July, so at the end of the month I'll see if the sales and royalty reports make any more sense.
gldrummond

Posts: 3,683
Registered: 05/08/09
Re: Reports not matching and not making sense
Posted: Jul 1, 2012 9:13 AM   in response to: david19271 in response to: david19271
 
Click to report abuse...   Click to reply to this thread Reply
No, Amazon doesn't pay anything on free downloads. That's why they're 'free'. ;)

What you're most likely seeing is the Average Offer Price, which is a pretty useless bit of information that constantly confuses people.

The equation for it is ALL sales of one title, divided into ALL prices it was listed for and that have been added together. When you have a free promo or two during that week, you end up with extremely low Average Offer numbers.

Six copies sell, but 5 are free downloads. Cover price is $3.00.

$3.00 divided by 6 = Average Offer Price of $0.50

You're actually receiving the appropriate royalty for cash sales, which in my example would be about $2.10 (minus delivery charge) for that one cash sale.
david19271

Posts: 193
Registered: 05/21/12
Re: Reports not matching and not making sense
Posted: Jul 1, 2012 10:16 AM   in response to: gldrummond in response to: gldrummond
 
Click to report abuse...   Click to reply to this thread Reply
Yes, I understand this, but on the royalty report, they actually show a small royalty in the royalty column on the free downloads. Then they show a royalty far below what it should be on actual sales. Like I said, the bottom line appears to be very close to what it should be for the actual sales, but it would make a lot more sense if they would just account for each type of sale or download separately rather than manipulating the numbers. It would also help if the numbers on the sales report matched the numbers on the royalty report. They don't.
gldrummond

Posts: 3,683
Registered: 05/08/09
Re: Reports not matching and not making sense
Posted: Jul 1, 2012 11:52 AM   in response to: david19271 in response to: david19271
 
Click to report abuse...   Click to reply to this thread Reply
Which report are you looking at?

The Prior Six Weeks report isn't all that fantastic to use as a means of keeping track, due to there often being a mix of sales from previous and current months in the first or last week of the month that's posted.

Since you're talking about royalties, I'm guessing that's the one you're looking at, because the Month to Date report doesn't show any royalty amounts.

Usually, the Month to Date matches the Prior Month's report (which isn't posted until the 15th of the month).

I haven't run any promotions in the past six weeks, so can't check mine to get a clearer idea of what you're seeing. But I know that free downloads don't generate any royalties.

Amazon was mixing free downloads and sales together for a while, but then began separating the two a few months back because that was causing a lot of people to contact KDP thinking that they were being gypped out of sales/royalties due to the math involved (or not understanding that promo day 'sales' were indeed, free downloads).

Would you feel okay about posting an edited screen shot here, so that I can see what you're seeing? Maybe of just the columns that show it?
susanzeb2

Posts: 10
Registered: 05/08/12
Re: Reports not matching and not making sense
Posted: Jul 1, 2012 5:27 PM   in response to: weikelm2 in response to: weikelm2
 
Click to report abuse...   Click to reply to this thread Reply
I, too, have had free promotions where the next day the sales are calculated at a 35% royalty. There's also a discrepancy in the amount of books sold and the royalty I received. The report currently shows over 400 books sold but my royalty amount is no where near the $800 it should be for selling that amount.
txpublisher

Posts: 67
Registered: 04/04/12
Re: Reports not matching and not making sense
Posted: Jul 1, 2012 6:56 PM   in response to: david19271 in response to: david19271
 
Click to report abuse...   Click to reply to this thread Reply
gldrummond is correct.

There is no payment for free downloads.

Ignore the six week report numbers. They are confusing. You will see exact figures in the monthly sales reports on the 15th.

The numbers in the six week reports can not be balanced. Don't try. Rely on the monthly reports. Those will reflect sales/free promos/borrows and payment for each.
clemlaw

Posts: 1,390
Registered: 06/10/11
Re: Reports not matching and not making sense
Posted: Jul 2, 2012 10:34 PM   in response to: weikelm2 in response to: weikelm2
 
Click to report abuse...   Click to reply to this thread Reply
They have about 175 sales at 35% of $3.99, but they've tallied that up to about $12. <<<<

In that case, you had a total of 175 downloads in countries with the 35% royalty. This includes Australia, which is apparently the biggest market with that rate.

In your case, it was about 9 paid sales, and 166 free downloads. On the 8 paid sales, you got 3.99 x .35 = $1.3965 per sale, for a total of $12.57. For the 166 free copies, you got 35% of zero, which is zero.

Yes, the report is somewhat confusing in this regard.

Legend
Helpful Answer
Correct Answer

Point your RSS reader here for a feed of the latest messages in all forums