This article is part of our Complete Guide to Royalty Management.
If you publish internationally, your inbox is a parade of currencies. Amazon KDP pays you in USD for US sales and EUR for sales on its European marketplaces. Lightning Source sends GBP for UK sales, AUD for Australian sales, and so on. Each payment arrives in a different currency at a different time, and somehow you need to calculate accurate royalties for your authors in a single, consistent currency.
Most publishers try to solve this with exchange rate lookup tables. That approach sounds reasonable until you try to make it work at scale. There is a better way.
The exchange rate table trap
The traditional workflow looks something like this. You download a sales report showing 500 units sold in Germany at various EUR price points. You look up the EUR/USD exchange rate for the relevant month, apply it to every line, and record the converted amounts in your royalty spreadsheet.
The problem is that exchange rates move constantly. The rate on the day you look it up may differ from the rate your distributor actually used when converting the payment. It may also differ from the rate your bank applied when receiving the funds.
These small differences compound across hundreds of sales lines, multiple distributors, and several currencies. By the end of a quarter, your calculated royalties and your actual bank deposits no longer agree. You are left with a reconciliation gap that is difficult to trace and time-consuming to resolve.
For a detailed look at what this costs in practice, see our article on the hidden cost of manual currency conversion.
Why timing mismatches make it worse
Exchange rates are not the only variable. Distributors convert currencies at different points in the payment cycle. Amazon might convert EUR to USD on the 15th of the month. Lightning Source might convert GBP to USD on the 28th. Your bank might apply yet another rate when the funds actually arrive.
When you pick a single exchange rate for an entire month (as most spreadsheet workflows require), you are smoothing over these timing differences. The result is a small but persistent mismatch between what you calculated and what you received.
Over a full year of royalty processing across five or six currencies, these mismatches can add up to hundreds or even thousands of dollars. That is money your authors might question, and money you cannot easily explain.
The income-first approach
There is a fundamentally different way to handle multi-currency royalties. Instead of converting sales figures using an external exchange rate, you start with the actual income payment you received from the distributor.
Here is the logic. Your distributor sends you a sales report in EUR and a payment in USD. The payment represents the real-world value of those sales after the distributor’s own currency conversion. By linking the sales report to the payment, you can derive the implicit exchange rate, the rate that was actually applied to your money.
This is not an approximation. It is arithmetic. If a sales batch totals EUR 10,000 and the corresponding payment is $10,850, then the effective rate is 1.085. Every sales line in that batch is converted at the same rate, and the total matches your bank deposit to the penny.
No lookup tables. No timing mismatches. No reconciliation gaps.
How this works in practice
The workflow for an internationally distributed publisher typically looks like this:
- Download sales reports from each distributor (Amazon KDP, Lightning Source, Ingram, and others).
- Import the sales data into your royalty system. If you are using Royalties HQ, this means uploading the original files. RHQ natively supports 10 distributor formats including Amazon KDP, Lightning Source, and ACX.
- Record your publisher income, the actual payment you received in your publisher currency for each batch of international sales.
- Link the income payment to the relevant sales batch. The system calculates the conversion rate automatically.
For sales already in your publisher currency, no income payment is needed. The system handles those automatically.
This approach means you never need to look up an exchange rate, maintain a rate table, or argue about which date’s rate to use. The rate is a fact, derived from the money that actually changed hands.
If you want a broader overview of best practices, download our free guide for a complete walkthrough of the royalty management process.
What about negative batches?
Returns and adjustments can create sales batches with negative totals. These are tricky because there is no positive income payment to link against.
A good royalty system will handle this by looking up the exchange rate for the end of that batch’s sales month and applying it automatically. You should also have the option to adjust the lookup date if your actual payment timing differs.
How Royalties HQ handles this
Royalties HQ was built around this income-first reconciliation model. When you add a publisher income payment and link it to one or more international sales batches, RHQ calculates the exchange rate automatically based on the actual amount you received. Every sales line in the linked batches is converted at the derived rate, so your royalty calculations always tie back to real income.
For negative international batches, RHQ automatically looks up the exchange rate at the end of the sales month and lets you adjust the date if needed. Sales in your publisher currency are handled without any manual steps at all.
The result is that currency conversion stops being a source of errors and becomes invisible. You spend your time on the parts of royalty management that actually require your judgment, not on chasing down exchange rate discrepancies in a spreadsheet.
Practical tips for managing multi-currency royalties
Keep distributor payments separate. When your distributor sends payments for different marketplaces or currencies, record each one individually. Lumping payments together defeats the purpose of linking income to specific sales batches.
Process royalties after all payments arrive. International payments often arrive later than domestic ones. Wait until you have received every payment for a given period before running royalties. This ensures every sales batch can be linked to its corresponding income.
Reconcile as you go. Do not wait until the end of the quarter to link income payments to sales batches. Doing it as payments arrive keeps the process manageable and surfaces any missing data early.
Review the derived rates. After linking, check that the implied exchange rates look reasonable. A rate that is far outside the market range for that period could indicate a data entry error in the income amount or a mismatch in the linked sales batch.
Multi-currency royalty conversion does not have to be complicated. When you reconcile against actual income rather than estimated exchange rates, the numbers simply work.