1. BayView
    Offline

    BayView Contributing Member Contributor

    Joined:
    Sep 6, 2014
    Messages:
    5,643
    Likes Received:
    5,120

    Amazon Royalty Reports

    Discussion in 'Publishing' started by BayView, May 31, 2016.

    Has anyone found a good way to translate Amazon royalty reports into income-per-book without going completely blind with paperwork?

    Part of the problem is all the different currencies, obviously... so I have to wait to see how the foreign currency is converted to Cdn currency, but that doesn't work too well because I keep my sales records in US currency, since that's how everyone but Amazon pays me, so I have to take the total sales for, say, Amazon.uk, wait until I receive it and it's converted to Cdn, then imaginarily convert that amount to US, then figure out the ration of UK sales attributed to each book and apply that ratio to the US amount, and record that as my sales for that book (so I can compare what's making money).

    I could cut out one of the steps by getting a US bank account, I think, assuming Amazon will agree to send the money there. They wouldn't send it to my US$ account based in Canada, for some reason.

    Anyway - is there an easier way to do all this? The more I play with self-publishing, the more I think I should be keeping better track of how much I'm actually making from different revenue sources so I can plan future efforts, but... it's not easy!
     
  2. Mike Kobernus
    Offline

    Mike Kobernus Contributing Member

    Joined:
    Oct 23, 2013
    Messages:
    301
    Likes Received:
    127
    Location:
    Norway
    I am thinking about creating a macro driven template in Excel. But no, going blind appears to be part of the business. I am all ears on this question, believe me!
     
    BayView likes this.
  3. joeh1234
    Offline

    joeh1234 Active Member

    Joined:
    Jun 10, 2016
    Messages:
    128
    Likes Received:
    86
    Hey I have never sold a book on amazon (or in the real world either). However I work as a support consultant for a Microsoft Gold partner. So without blowing my own trumpet I am pretty good on computers. As I am sure a lot of people are on WF.
    Anyway are you able to confirm what information is in the royalty report? What format do you receive it in? DO you view it online or is it downloadable?
    I ask because in excel you will definitely be able to create something to do the work for you. I would happily look into this for you if you could provide an example of what information you receive for amazon, on the premise that when my book is finished and it needs critiquing I can call on you :D
     
  4. joeh1234
    Offline

    joeh1234 Active Member

    Joined:
    Jun 10, 2016
    Messages:
    128
    Likes Received:
    86
    Hey I have never sold a book on amazon (or in the real world either). However I work as a support consultant for a Microsoft Gold partner. So without blowing my own trumpet I am pretty good on computers. As I am sure a lot of people are on WF.
    Anyway are you able to confirm what information is in the royalty report? What format do you receive it in? DO you view it online or is it downloadable?
    I ask because in excel you will definitely be able to create something to do the work for you. I would happily look into this for you if you could provide an example of what information you receive for amazon, on the premise that when my book is finished and it needs critiquing I can call on you :D
     
  5. BayView
    Offline

    BayView Contributing Member Contributor

    Joined:
    Sep 6, 2014
    Messages:
    5,643
    Likes Received:
    5,120
    It comes in Excel format and is downloadable.

    I don't know if I can attach a file to this post or not - I'll try... No, it won't let me upload a spreadsheet. If you can tell me how to share a spreadsheet with you I can send you a copy of what I get.

    The main information I want extracted from it is how much each book is making overall, world-wide, rather than separately in each different format and each different jurisdiction. I can add this up manually (although the foreign currency conversions are far from precise) but it takes a long time.
     
  6. joeh1234
    Offline

    joeh1234 Active Member

    Joined:
    Jun 10, 2016
    Messages:
    128
    Likes Received:
    86
    Ok that sounds fine if they give it you in excel, I will be able to create something for you. Ill PM you.
     
  7. Necronox
    Offline

    Necronox Active Member

    Joined:
    Sep 1, 2015
    Messages:
    131
    Likes Received:
    85
    Location:
    Victoria, Australia
    It might be nice to put up it up here on the forums when you done as some form of template or something (perhaps as a resource?) It's sounds pretty useful, though I personally have no need of it at this present moment. I'm sure other people will.
     
    joeh1234 likes this.
  8. joeh1234
    Offline

    joeh1234 Active Member

    Joined:
    Jun 10, 2016
    Messages:
    128
    Likes Received:
    86
    Yeah I will get it working for @BayView first. And I am not sure what the forum roles would be on sharing it via the forum. But I have no issue with sharing it once its done.
     

Share This Page