Do your book numbers add up?

  1. Plan what each book costs you, and see what you have spent against it.
  2. Try three prices side by side for paperback and ebook, with KDP's print costs and royalty rules already in.
  3. Enter your sales for the year and see your royalties by month and by book.
  4. Log your Amazon ads each week and see which campaigns make money.
  5. See how many readers carry on from book 1 to the next book in your series.

Get the kit for $17

One payment. If it isn't useful, email me within 7 days of buying and I'll refund you in full.

Chris Baird

Here is what the sheets look like

The Price planner sheet with example numbers: three prices side by side for paperback and ebook, with print cost, lowest allowed list price and royalty per sale
Price planner: three prices side by side
The Sales and royalties sheet with made-up example numbers: twelve months of ebook and paperback sales for each book, with totals
Sales and royalties: twelve months, book by book
The Ads tracker sheet with made-up example numbers: weekly rows of spend, ad sales and orders with ACOS and profit or loss
Ads tracker: one row a week, with profit or loss

What is inside

  1. Start here: what each sheet is for
  2. KDP figures: print costs, royalty thresholds and ebook delivery costs for Amazon.com, .co.uk and .de, each with KDP's help page and the date I checked it
  3. Book budget: up to 20 books, planned against actual
  4. Price planner
  5. Sales and royalties
  6. Ads tracker
  7. Series read-through
  8. Sales goal: how many sales a month you need for the income you want
  9. A 4-page PDF guide

Sheets 3 to 8 also come with an example copy filled in with made-up numbers, so you can see how each one works before you add your own. The yellow cells are yours to fill in. The rest is locked, with no password.

Who it is for

Authors who publish on Amazon KDP and want to work out their own numbers. You open the file in Excel. The guide shows how to open it in Google Sheets or Apple Numbers.

Who it is not for

If you want someone to do the work for you, the kit won't do that. Look at my 1-on-1 coaching instead.

Questions

What do I get?

An Excel file and a 4-page PDF guide. You get the download link straight after you pay.

What if it isn't useful?

Email me within 7 days of buying and I'll refund you in full. The 7 days count from the date you bought it.

Are the KDP figures current?

They were checked on 16-Nov-26. KDP changes its rules from time to time, so each figure sits in a yellow cell with a link to KDP's own page. If a number has changed, you type the new one in.

Get the kit for $17