Every distributor you have ever used is the seller of record, so the report they send you is already net of tax. The first time you sell from your own shop, you are the seller, and the money that lands has the VAT sitting inside it. Here is why that quietly overpays anyone on a royalty share, the ten-minute spreadsheet fix, and the UK trap where ebooks are zero-rated but audiobooks are not.

It's the last week of the quarter and the dread has arrived on schedule. Reports to pull, splits to calculate, statements to send — and everyone you owe is quietly wondering where their numbers are. Here's a day-by-day survival guide for getting through statement week in under five days, starting Monday morning.

Someone handed you a publishing catalog — maybe through inheritance, maybe through a business transition — and now you're responsible for titles earning royalties across distributors you've never logged into, owed to people you may not have met. Here's the first five things to do, in order, so you can stop feeling lost and start feeling like you have a plan.

Sooner or later a distributor sends a report no tool recognises — a smaller store, a foreign publisher, or a big one that just moved its columns. Here's a durable way to map any format by hand so a change never breaks your spreadsheet again, plus the new Royaltally wizard that reads any CSV or spreadsheet, learns it once, and imports it in one click after that.

You download the latest report, open it, and the columns have moved. Your formulas break. Your import macro throws errors. And you're doing detective work instead of royalty work. Here's how to build a spreadsheet that expects format changes — and a fifteen-minute fix when they hit.

You paid an advance against future royalties, and now the book is earning across KDP, ACX, Findaway, IngramSpark, and Draft2Digital. Each reports at different times, in different formats. At what point has the advance earned out — and how do you catch the exact month it flips? Here's a manual tracker that answers both questions.

Most small publishers never make a deliberate decision about payment frequency — they default to whatever feels right and deal with the consequences later. Monthly is appreciated but brutal to administer. Quarterly is the industry standard for a reason. Semi-annual saves time but strains trust. Here's how to choose, and why consistency matters more than frequency.

You've done the math. Now you have to show it to someone — a co-author, a narrator, an agent — and the PDF you send is the only thing standing between "everything's fine" and "are you sure about this?" Here's what makes a statement trustworthy, plus a template you can use today.

You earned £2,400 in UK sales last year according to your distributor dashboards. But what actually arrived in your USD bank account was smaller — not by a lot, but by more than rounding. Three exchange rates touch every international earning, none of them agree, and the compounding drift is real. Here's how to find your annual conversion cost and decide what to do about it.

You agreed on 50/50 and moved on to writing. Then the book started earning across four distributors, in two currencies, with returns showing up months late — and "fifty percent" became a surprisingly complicated question. Here's a five-item agreement template that answers it before either of you has to ask.

You've been tracking numbers, sending statements, paying people — but you've never been fully confident the numbers are right. Not wrong enough to be obviously broken, but not right enough that you'd bet money on them. Here's where that doubt actually comes from, and a five-step audit protocol that converts vague anxiety into a specific answer.

You built the spreadsheet yourself, and for a long time it worked. Then something shifted — a new distributor, a co-author, a month you fell behind. Here are the specific moments a royalty spreadsheet stops serving you, plus a five-question health check to know where yours stands.

You check the KDP deposit, open the dashboard to cross-check, and the numbers don't match. You're not reading it wrong — the two are answering different questions. Here are the five reasons they disagree, and a simple worksheet for reconciling them every month.

You opened a spreadsheet, looked at it for a long minute, and quietly closed it again. If you've ever tried to figure out what you actually earned last month across KDP, ACX, Findaway, IngramSpark, and everywhere else, you know the feeling. Here's a 30-minute monthly rhythm that gets you to one honest number — and an honest look at when even that stops being enough.