There's a spreadsheet on your computer that you are quietly, reasonably proud of. You built it yourself. Nobody showed you how. You figured out the columns through trial and error, you taught yourself the formulas the hard way, and for a good long stretch it did exactly what you needed it to do. Every time someone in an indie publishing forum asked how they should track their royalties, you half-wanted to send them a copy of yours.
And then, somewhere in the last few months, something shifted. Maybe it takes longer to update than it used to. Maybe you've started dreading the day you sit down to do it. Maybe you fell a month behind, and then two, and now the catch-up feels like a project instead of a task. Maybe nothing's dramatically wrong, but you've stopped fully trusting the bottom-right number.
If that's where you are, I want to start by saying something you probably need to hear: your spreadsheet isn't broken, and neither are you. You've just outgrown a tool that worked perfectly for the business you had when you built it. That's a growth event, not a failure. Let's talk about what's actually happening.
Why homemade spreadsheets age out
A spreadsheet is a snapshot. You calibrate it once, to the business you have that week, and it freezes in that shape. The problem is that your business keeps moving. You add a distributor. You take on a co-author. Returns start showing up from three months ago. The pound gets stronger for a while, then weaker. The spreadsheet doesn't know about any of that. It just sits there, rigid, while the inputs quietly multiply around it.
Everybody who tracks royalties in a spreadsheet hits this wall eventually. The only variable is when.
The five moments it actually breaks
These aren't abstract failure modes. They're the specific, named moments when a working spreadsheet stops working, and if you've been doing this for more than a year or two, at least one of them will sound like something that happened to you last Tuesday.
You add a royalty holder, and totals aren't enough anymore. Up to this point, your sheet answered one question: what did you earn? That's a single column you can sum. The moment you owe somebody else a share, you need to know per-title earnings, per-edition earnings, per-format earnings, maybe split percentages that vary by book, possibly different percentages for audio versus ebook versus print. You try to bolt splits onto the side of an earnings tracker and the whole thing starts to tip. What used to be five clean columns is suddenly fifteen, and three of them don't quite add up.
The currency column has been quietly wrong for months. You've been converting GBP and EUR and whatever else at "roughly the right rate" — whichever day you looked it up, whichever site you used, whichever column you copied the formula from last time. It looked right. It still looks right. But the cumulative drift between your spreadsheet and your actual deposits has become real money, and you won't spot it until you sit down and actually reconcile a year's worth at once. (I'll go deeper on this in a few weeks; it's its own post.)
You copy the wrong formula, and the number is close enough to look right. This is the scariest failure mode, because nothing obvious breaks. The cell next to it shows a plausible number. The totals at the bottom still sum. You don't catch it for three months, and by then the error is downstream of every statement you've sent to every royalty holder. The moment you realise, you have to go back and rebuild not just the spreadsheet but the trust.
Advances turn the sheet into a detective case. Tracking an advance against earn-out across five distributors means keeping a running cumulative total that pulls from every income stream, in every currency, every month, without fail. Miss a month and the running total is wrong. Paste a value where a formula should be and you'll never notice. The moment the advance earns out, the royalty holder flips from "nothing this period" to "their full percentage" — and you need to catch that transition in the exact right month. In a spreadsheet, that catch is entirely down to you remembering to look.
Quarterly statement time arrives and the structure isn't there. Your sheet was built to handle monthly totals, not per-author breakdowns in a presentable format. Statement week becomes a rebuild: copy the totals into a new tab, split them by royalty holder, reformat them into something you can send, paste into a Word doc, generate a PDF, double-check everything, send. Every quarter. From scratch. Because the structure for it was never in the sheet to begin with.
A five-question health check
Before you decide anything, do this. It takes about ten minutes and it will tell you honestly where your spreadsheet stands.
- Can you answer "what did I earn last month?" from this sheet in under a minute?
- Could a co-author or narrator look at your spreadsheet and reconstruct their share without you in the room?
- Is there a single source of truth for currency conversion, or is it whatever rate you grabbed that day?
- If you found a wrong number today, could you trace it back to the source report in one or two steps?
- When a distributor changes its report format, do you know exactly which cells in your sheet will break?
Score yourself honestly. Four or five yeses means the spreadsheet is still serving you — keep going, and come back to this check every six months. Two or three means the seams are starting to show, and it's worth thinking about what the next version looks like before something forces the decision. Zero or one means you're not maintaining a spreadsheet anymore. You're fighting one.
Either way, you've now got language for where you are. That by itself is worth the ten minutes.
The permission slip
I want to say this clearly, because almost nobody says it to indie publishers: outgrowing the spreadsheet you built is a good thing. The tool wasn't wrong. The business got bigger than the tool. That's what growth looks like from the inside — it looks like the thing that used to be easy getting harder, right before you replace it with something that fits the business you actually have now.
You're not bad at spreadsheets. You built something that carried you through years of real work. The fact that it can't carry you through the next five is a story about the next five, not about the sheet.
How Royaltally handles this part
I built Royaltally because mine broke in exactly these ways. I'm an indie audiobook publisher and a narrator, and I lived in a spreadsheet that did the first three items on that list beautifully and the last two not at all. Advances and statements were what finally tipped me.
Royaltally parses your distributor reports directly, so there's no copy-paste chain to break. Currency conversion runs off a single consistent daily source, so the drift stops being invisible. Royalty splits are first-class — per title, per edition, per royalty holder — rather than something you bolt on. Advances track their own earn-out across every income stream. Statement generation is a button, not a week.
You can track up to 3 titles free, no credit card, if you want to see what that looks like against your own reports. Come take a look.
And if you'd rather stay with the sheet — that's a completely reasonable choice. A spreadsheet that passes the health check above is a fine tool, and there's no prize for moving before you're ready. Run the check, keep the rhythm, and when the day comes that it stops working, you'll already know exactly why.
Either way: you've got this. You built the sheet in the first place. You can tell when it's time to build the next thing.