It's the last week of June, and the feeling is back. You know the one. Somewhere between Sunday night and Monday morning, it settles in — that low-grade dread that comes with knowing what the next five days are going to look like. You have to pull reports from every distributor, calculate every royalty holder's share, generate statements, send emails, and do it all before the people you owe money to start wondering where their numbers are.
The dread is real and it's seasonal. Every small publisher who pays royalty holders knows this week. It comes four times a year — or twice, if you've chosen a semi-annual cadence — and it never gets easier just because you've done it before. The volume resets. The stakes don't shrink. And the quiet fear that you'll get a number wrong and have to send a correction sits underneath the whole thing like a low hum.
If that's where you are right now — or where you will be in a few days — this post is your playbook. Not theory. Not principles. A literal day-by-day plan for getting through quarterly statements in under a week, starting Monday morning and finishing Friday afternoon.
Why statement week feels worse than it is
The dread doesn't come from any single task being impossible. If you've been following this series, you already know how to do every piece. You know the monthly report rhythm. You know how to handle co-author splits. You've thought through currency conversion, statement structure, advance tracking. Each of those is manageable on its own.
The problem is that statement week is when all of them happen at once. Gathering, calculating, splitting, documenting, sending — five different kinds of work, compressed into one deadline, with real people waiting on the other end. That's what makes it feel like a mountain. It's not one hard thing. It's ten medium things stacked on top of each other.
The fix is sequencing. Give each kind of work its own day, and the mountain turns into a staircase.
Monday: Download day
Monday has one job: gathering.
Log into every distributor account you use. KDP, IngramSpark, ACX, Findaway, Draft2Digital — whatever your list looks like. Download last quarter's reports from each one. All of them, in one sitting, into one folder. Label the folder with the quarter and the year. Label each file with the distributor name so you're not guessing later.
Don't open the reports yet. Don't start entering numbers. Monday is not the day for math. Monday is the day for making sure you have everything. Check your distributor list — if you keep one from when you first set up your system, or from the triage exercise in last week's post, use it. If a distributor is late posting their report, note it and move on. You'll circle back.
When you close your laptop Monday evening, every available report should be in one folder, clearly labeled. That's the only goal.
Tuesday: The numbers day
Tuesday is mechanical. Open each report. Enter the data into your master spreadsheet — one row per distributor per title, or whatever grain your system uses. If you're using the simple five-column structure from the first post in this series, this is where it earns its keep. If your system is more granular, same principle: get the raw numbers in.
Convert currencies as you go. Use one source — xe.com, your bank's posted rate, whatever you've standardized on — and apply one day's rates consistently across everything. The currency conversion post from a few weeks ago covers why this matters: three different rates touch every international earning, and consistency beats precision.
If a number looks off, flag it. Put a note in the cell, highlight the row, whatever your system is. Don't chase it today. Tuesday is for data entry, not investigation. Chase the anomalies Wednesday morning if they're still bothering you. Most of them will resolve themselves once all the numbers are in and you can see the full picture.
Wednesday: The splits day
Wednesday is where the real work lives. This is the day you apply royalty holder percentages — who gets what, on which titles, in which formats, for this quarter.
If you set up a co-author agreement using the framework from earlier in this series, Wednesday is when that document pays for itself. You shouldn't be deciding percentages this week. You should be applying ones you already agreed on. Pull up the agreement, confirm the split, calculate each holder's share from the numbers you entered Tuesday.
If you have advances outstanding, Wednesday is also when you check earn-out status. Pull up your advance tracker. Apply this quarter's earnings against the remaining balance. Has the advance earned out? If yes, this is the first quarter the royalty holder gets a percentage-based payment instead of nothing. If no, note the remaining balance — it goes on their statement so they can see progress.
By the end of Wednesday, every royalty holder should have a number next to their name for every title they have a stake in, for this quarter. The math is done. Everything from here is documentation and delivery.
Thursday: The statements day
Thursday is about documents, not numbers. The numbers are finished. Now you're turning them into something you can send.
Build each statement using the structure that makes it trustworthy: a header with the period and the recipient's name, a body table showing distributor, title, gross earnings, split percentage, and their share, a deductions section for returns or advance recoupment, and a clear total at the bottom. Every number should be traceable. Every deduction should be explained in plain language.
If you built a template after reading the statement post earlier in this series, now's when you use it. If you haven't, build one Thursday morning — it takes thirty minutes, and you'll reuse it every quarter from now on.
Review each statement before you move on to the next. Read it as if you're the person receiving it. Can you understand every line? Can you see where each number came from? If a royalty holder emails you with a question, will you be able to answer it from what's on the page? If yes, the statement is ready. If no, add the context that's missing.
Friday: The send day
Friday's job is delivery and communication. Send each statement with a short, human email. Not a form letter. Not a one-liner. Something that says: here are your numbers for Q2, here's when payment will arrive, and here's how to reach me if anything looks off.
If payments go out with the statements, include the payment confirmation or reference number. If payments follow on a different schedule — net 15, end of the following month, whatever your cadence is — say when. The clarity matters more than the speed. A royalty holder who knows they'll be paid on July 15 is far more comfortable than one who received a statement with no mention of timing.
When you close your laptop Friday afternoon, every person you owe has their numbers, their statement, and a clear expectation. Statement week is done. The dread was worse than the doing.
When the week goes sideways
Not every week follows the plan. A distributor posts their report late. A number doesn't reconcile and you spend half of Tuesday chasing it. A royalty holder emails about last quarter before you've finished this one.
The survival guide still works — you just shift a day. The structure is forgiving because it separates the five kinds of work into distinct phases. When one phase hits a snag, the others aren't affected. You're not jumping between downloading and calculating and emailing in the same afternoon. That chaos is what makes statement week feel unbearable. The day-by-day structure prevents it.
How Royaltally handles this part
I built Royaltally because I lived this week too many times. The system compresses the entire Monday-to-Friday sequence into about twenty minutes: upload your distributor reports, and Royaltally parses them, matches earnings to titles, converts currencies, applies royalty splits, checks advance balances, and generates PDF statements ready to send. The five-day survival guide becomes upload Monday morning, send statements Monday afternoon.
Royaltally is in open beta — week nine. You can start with up to 3 titles for free at royaltally.com. If twenty minutes sounds better than five days, come take a look.
But I want to be clear about something: the survival guide above works. It works without software. It works with a spreadsheet and a calendar and five days of focused effort. If that's your path right now, take it. The playbook is yours.
You just built a whole toolkit
This is the twelfth post in this series, and it's the last one. Over the past twelve weeks, we've covered a lot of ground together — the monthly rhythm that keeps you from drowning in reports, the moment your spreadsheet stops keeping up, the quiet doubt about whether your numbers are right, co-author splits that don't strain friendships, currency conversion that doesn't silently eat your margins, statements that people actually trust, payment cadence, advances, format changes, inherited catalogs, and now the quarterly crunch that pulls all of it together into one intense week.
That's a complete toolkit. Not perfect. Not permanent. Tools wear out, businesses evolve, and you'll adapt as yours does. But the publisher who started reading this series twelve weeks ago and the publisher finishing it now are not in the same place. You have systems where you had anxiety. You have checklists where you had guesswork. You have a week-long plan where you had dread.
I started writing these posts because I know what it feels like to sit alone with a spreadsheet and wonder if you're the only one who finds this hard. You're not. And you never were.
Whatever your statement week looks like — this one and all the ones after it — you know how to get through it now. Not perfectly. But completely. And that's enough.