I owe a big thanks to
Author EMS for these templates. THANKS!
Sample Spreadsheets
If you’re looking for a way to track sales, you might want to start with one of the below Excel spreadsheet templates. Click the link to download.
1.
Sales Tracking: Spreadsheet built to track daily sales of one title across multiple distributors. Includes space to jot notes on promotions, book pricing and ranking to see how those affect sales. Make copies of this template for each book for each year. In .xls format.
2.
Sales Royalty Reconciliation: Spreadsheet built to track monthly royalty earnings for one title across multiple distributors. Fields built to allow for matching up royalty payments with earnings. Feeds info to a Totals page that shows earnings and sales total for the book in numbers and as a graph. In .xls format.
3.
Writing Sales Report: Spreadsheet built to track sales of multiple titles across multiple distributors. Color-coded with instructions on how to adapt. In .xls format. This report created by Pepper Phillips and Donna Caubbareaux.