Pular para as informações do produto
Author and Self-Publisher Business Suite 1

Author and Self-Publisher Business Suite – Excel & Google Sheets Templates

$29.00
Comprar agora

Know which of your books have paid back what they cost, which ads to stop and when each store's royalties will really arrive. 8 Excel workbooks for the independent author-publisher or small press, 29 dollars once, no subscription, no macros.

Built for an author who publishes under one or two pen names, often with an assistant and freelancers paid per job. A small press can read the pen-name column as an author column. With 1 to 3 books you use most parts with a few rows. Author sales-tracking software is usually billed every month, and the fee often rises as income rises. This is 29 dollars, once.

What you can do

  • See which titles have paid back their production cost, which are on track and which are behind.
  • Rank every ad campaign as stop, hold or raise against your own break-even.
  • Match what each store earned to what it paid, and total the short payments to claim.
  • Find the step where readers drop between book 1 and the next book.
  • Work out your net on direct sales, hand-sold stock and each event.
  • See cash 12 months ahead, a tax set-aside pot and a safe owner draw.

What is inside: 8 workbooks

  • Catalogue, Series Plan and Releases
  • Production Costs and Break-Even
  • Sales and Royalties Ledger
  • Ads and Price Promotions
  • Readers, Newsletter and Launches
  • Series, Title and Pen-Name Performance
  • Direct Sales, Stock, Events and Rights
  • Cash, Tax, Expenses and Author Shares

Each workbook has 20 tables, 18 tools, 12 forms, 12 documents, 12 checklists, 34 ready-to-send message texts, 30 dashboard numbers, 22 charts and 6 gauges. In all: 160 tables, 144 tools, 96 forms, 96 documents, 96 checklists, 272 message texts, 240 dashboard numbers, 176 charts and 48 gauges. Every part comes as a blank workbook and as a copy filled with sample data.

Not for: a writing or word-count planner. Nothing reads your store accounts: you type or paste monthly totals. It gives no legal or tax advice.

How it works

  • Open the workbook for the job.
  • Replace the sample rows with your own totals in the coloured cells.
  • Read the dashboard and the verdicts of the tools.

File format

Standard xlsx files for Microsoft Excel, Google Sheets and LibreOffice. No macros. Formula cells are locked against accidental edits, with no password.

Guarantee

If a file does not work as described, we fix it, replace it or refund you within 14 days.

More answers are in the FAQ.

What it does for you

  • Know which titles have paid back their production cost, and which are behind
  • See the copies and months an edition needs to earn back what it cost
  • Decide on audio, large print or a translation before you spend, in three cases
  • Match what each store earned to what it paid, and name the short payment to claim
  • See when royalties really arrive, store by store, in Base, Best and Worst
  • Stop, hold or raise every ad campaign against your own break-even
  • Find out whether a price promotion paid back, and in how many days
  • Check every launch step, rank your reviewers and see what a subscriber costs
  • Spot the step where readers drop between book 1 and the next book
  • See profit by pen name, and keep, reprice or retire each title
  • Know your net on direct sales, hand-sold stock and each event
  • See cash 12 months ahead, set tax aside and know what each author is owed

Questions

Does it work in Google Sheets?
Yes. The files are standard .xlsx files for Microsoft Excel, Google Sheets and LibreOffice. Suites built with the same engine were tested in Google Sheets. There are no macros.

Can I use my own currency and date format?
Yes. Dates follow your computer's regional format, and the currency symbol is changed in one cell. Each store's exchange rate is a number you type.

What if I have only 1 to 3 books and no team?
Use the parts you need with a few rows each. Costs, royalties, ads and cash work with one title, and the sample data shows how a full catalogue looks.

Can a small press use it for several authors?
Yes. Read the pen-name column as an author column. Part 6 shows profit by author, and Part 8 tracks what each author is owed and checks that shares add up.

Does it read my store accounts?
No. There is no store login and no live feed. You type or paste your monthly totals, and the dashboards and tools do the rest.

What if a file does not work?
If a file does not work as described, we fix it, replace it or refund you within 14 days. It is a one-time price of 29 dollars with no subscription.

Você também pode gostar