{"product_id":"author-publisher-excel-suite","title":"Author and Self-Publisher Business Suite – Excel \u0026 Google Sheets Templates","description":"\u003cp\u003eKnow 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.\u003c\/p\u003e\u003cp\u003eBuilt 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat you can do\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eSee which titles have paid back their production cost, which are on track and which are behind.\u003c\/li\u003e\n\u003cli\u003eRank every ad campaign as stop, hold or raise against your own break-even.\u003c\/li\u003e\n\u003cli\u003eMatch what each store earned to what it paid, and total the short payments to claim.\u003c\/li\u003e\n\u003cli\u003eFind the step where readers drop between book 1 and the next book.\u003c\/li\u003e\n\u003cli\u003eWork out your net on direct sales, hand-sold stock and each event.\u003c\/li\u003e\n\u003cli\u003eSee cash 12 months ahead, a tax set-aside pot and a safe owner draw.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eWhat is inside: 8 workbooks\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eCatalogue, Series Plan and Releases\u003c\/li\u003e\n\u003cli\u003eProduction Costs and Break-Even\u003c\/li\u003e\n\u003cli\u003eSales and Royalties Ledger\u003c\/li\u003e\n\u003cli\u003eAds and Price Promotions\u003c\/li\u003e\n\u003cli\u003eReaders, Newsletter and Launches\u003c\/li\u003e\n\u003cli\u003eSeries, Title and Pen-Name Performance\u003c\/li\u003e\n\u003cli\u003eDirect Sales, Stock, Events and Rights\u003c\/li\u003e\n\u003cli\u003eCash, Tax, Expenses and Author Shares\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eEach 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eNot for:\u003c\/strong\u003e a writing or word-count planner. Nothing reads your store accounts: you type or paste monthly totals. It gives no legal or tax advice.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eHow it works\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eOpen the workbook for the job.\u003c\/li\u003e\n\u003cli\u003eReplace the sample rows with your own totals in the coloured cells.\u003c\/li\u003e\n\u003cli\u003eRead the dashboard and the verdicts of the tools.\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eFile format\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eStandard xlsx files for Microsoft Excel, Google Sheets and LibreOffice. No macros. Formula cells are locked against accidental edits, with no password.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eGuarantee\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eIf a file does not work as described, we fix it, replace it or refund you within 14 days.\u003c\/p\u003e\u003cp\u003eMore answers are in the FAQ.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat it does for you\u003c\/strong\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eKnow which titles have paid back their production cost, and which are behind\u003c\/li\u003e\n\u003cli\u003eSee the copies and months an edition needs to earn back what it cost\u003c\/li\u003e\n\u003cli\u003eDecide on audio, large print or a translation before you spend, in three cases\u003c\/li\u003e\n\u003cli\u003eMatch what each store earned to what it paid, and name the short payment to claim\u003c\/li\u003e\n\u003cli\u003eSee when royalties really arrive, store by store, in Base, Best and Worst\u003c\/li\u003e\n\u003cli\u003eStop, hold or raise every ad campaign against your own break-even\u003c\/li\u003e\n\u003cli\u003eFind out whether a price promotion paid back, and in how many days\u003c\/li\u003e\n\u003cli\u003eCheck every launch step, rank your reviewers and see what a subscriber costs\u003c\/li\u003e\n\u003cli\u003eSpot the step where readers drop between book 1 and the next book\u003c\/li\u003e\n\u003cli\u003eSee profit by pen name, and keep, reprice or retire each title\u003c\/li\u003e\n\u003cli\u003eKnow your net on direct sales, hand-sold stock and each event\u003c\/li\u003e\n\u003cli\u003eSee cash 12 months ahead, set tax aside and know what each author is owed\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eQuestions\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it work in Google Sheets?\u003c\/strong\u003e\u003cbr\u003eYes. 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCan I use my own currency and date format?\u003c\/strong\u003e\u003cbr\u003eYes. 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat if I have only 1 to 3 books and no team?\u003c\/strong\u003e\u003cbr\u003eUse 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eCan a small press use it for several authors?\u003c\/strong\u003e\u003cbr\u003eYes. 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.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eDoes it read my store accounts?\u003c\/strong\u003e\u003cbr\u003eNo. There is no store login and no live feed. You type or paste your monthly totals, and the dashboards and tools do the rest.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWhat if a file does not work?\u003c\/strong\u003e\u003cbr\u003eIf 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.\u003c\/p\u003e","brand":"Dar Templates","offers":[{"title":"Default Title","offer_id":68449801863472,"sku":null,"price":29.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1007\/1887\/0832\/files\/image_cbce45c9-753f-4dec-88d4-e35df0209abc.jpg?v=1794776963","url":"https:\/\/darjob.myshopify.com\/pt\/products\/author-publisher-excel-suite","provider":"Dar Templates","version":"1.0","type":"link"}