Sometimes Leanpub authors want to know which specific sales contributed to their specific royalty payments.
We don't have an automatic report for doing this, but it can be done using the data we provide, and a little bit of Excel work.
Get a Spreadsheet Showing All Your Available Sales Data
To get a spreadsheet with all your available Leanpub sales data, please go here:
On that page, click the link that says "download a CSV file":
In a few minutes, you will receive an email from Leanpub with a .csv file attached.
This .csv file will have your sales data displayed in a number of columns.
The relevant column for this article is the column named "Date Author Royalty Was Paid":
View a List of All Your Leanpub Royalty Payments
You can find a list of all your Leanpub royalty payments, showing the date and the amount, on the "Royalty Payouts" page here:
(Please not we've blurred out the data in this screenshot, but you will see your own data when you visit the page in your account!)
Sorting in Excel to Match Sales Data to Your Royalty Payments
We're not going to presume to teach much Excel in this article!
However, what you may want to do next is:
- Select all the data in the spreadsheet
- In the Excel menu, select Data > Sort...
- Choose to sort on the "Date Author Royalty Was Paid"
That should get you close to what you're looking for.
OK, that's it!
If you have any feedback or questions about this article, please email the Leanpub team about it at hello@leanpub.com!
If you have any questions or thoughts on writing and self-publishing with Leanpub, please join our global community of authors in our Authors Forum here!
Are you interested in self-publishing, and creating your first Leanpub book? Here are some quick tutorials for our most popular writing modes: http://help.leanpub.com/en/articles/3088382-quick-walkthroughs-for-getting-started-on-a-leanpub-book
Are you looking for great deals on Leanpub ebooks, ebook bundles, and courses? Sign up for our Weekly and Monthly newsletter sales here!
To learn about amazing new books and authors, subscribe to our YouTube channel here: https://www.youtube.com/leanpub.
You can also follow Leanpub in lots of other places!
