This article is part of our Complete Guide to Royalty Management.
If you publish internationally, you are converting currencies every single royalty period. Amazon pays you in EUR for German sales, Lightning Source sends GBP for UK sales, and each payment has to be translated into your publisher currency before you can calculate what you owe your authors. Most publishers handle this manually, and most of them are losing money because of it. Not in dramatic, obvious ways, but in small, persistent errors that compound over time.
The “which date?” problem
Exchange rates move constantly. The EUR/USD rate on March 1 might be 1.085. By March 15 it could be 1.092. By the time your distributor actually converts the payment, it might be 1.088. So when you sit down to convert a batch of European sales into dollars, which rate do you use?
Most publishers pick a rate from somewhere reasonable. Maybe the rate on the day they process royalties, or a monthly average from a financial website, or whatever Google shows when they type “EUR to USD.” The trouble is that none of these rates are the rate that was actually applied to your money.
Your distributor converted your EUR sales into USD on a specific date using a specific rate. Your bank may have applied a slightly different rate when receiving the funds. The rate you looked up is a third number entirely. You now have three different versions of the truth, and your royalty spreadsheet reflects whichever one you happened to grab.
How small errors compound
A 0.5% error on a single currency conversion sounds trivial. On a $10,000 EUR payment, that is $50. Annoying but survivable. Now multiply that across the reality of an internationally distributed catalog.
Say you receive payments in five currencies each quarter. Each currency has its own conversion, and each conversion carries a small error in one direction or the other. Some errors will cancel out, but many will not, because the biases in manual conversion tend to be systematic rather than random. If you consistently look up rates a few days after your distributor converts, you will consistently get a slightly different number.
Across a full year, a publisher processing $200,000 in international sales with an average 0.5% conversion error is looking at roughly $1,000 in unexplained variance. That is $1,000 that does not match your bank statements, that you cannot confidently attribute to any specific author, and that you will spend hours trying to reconcile.
For larger catalogs or publishers working in more currencies, the numbers grow proportionally. A 1% error rate on $500,000 in international sales is $5,000 of variance you need to explain to your accountant, your authors, or both.
The reconciliation gap
The real cost of manual currency conversion is not just the dollar amount of the errors. It is the reconciliation gap between your calculated royalties and your actual bank deposits.
When you convert sales using a looked-up exchange rate, your total converted revenue will almost never match the payment you actually received. The difference might be $30 on one payment and $150 on another. These gaps accumulate in your accounts, and they create two problems.
First, you cannot tell whether a discrepancy is a conversion rounding error or an actual mistake in your sales data. Did you receive less than expected because the exchange rate was slightly different, or because your distributor shorted you 50 units? When every payment has a small unexplained difference, you lose the ability to catch real errors.
Second, your authors’ royalty statements will not tie back to your income. If an author ever asks you to walk through the math on their international sales, you will hit a point where the numbers do not quite add up. That conversation erodes trust, even if the actual impact on their payment is small.
The hidden time cost
Beyond the financial errors, manual currency conversion is a significant time sink. Each period, you need to look up rates for every currency, apply them to every sales batch, and then try to figure out why the totals do not match your bank deposits.
Publishers who manage royalties in Excel often maintain separate rate tables or conversion worksheets. These add another layer of formulas that can break, another set of cells that can be accidentally overwritten, and another thing that only one person in the office knows how to maintain.
If you want to understand the full scope of what modern royalty management looks like, download our free guide for a comprehensive walkthrough.
How Royalties HQ handles this
Royalties HQ eliminates manual currency conversion entirely by using an income-first reconciliation model. Instead of looking up exchange rates, you tell the system how much you actually received from your distributor in your publisher currency. RHQ then links that payment to the corresponding sales batch and calculates the conversion rate automatically.
Here is what that looks like in practice. Your distributor sends you a sales report in EUR and a payment of $10,850. You import the sales report, record the income payment, and link the two. RHQ divides the payment by the EUR total to derive the actual exchange rate, then applies it to every sales line in the batch. The converted total matches your bank deposit exactly, because it was derived from your bank deposit.
For sales already in your publisher currency, no income payment is needed. RHQ handles those automatically. For negative batches caused by returns, the system looks up the exchange rate at the end of the sales month and lets you adjust the date if needed.
The result is that your royalty calculations always tie back to real money. There are no reconciliation gaps, no timing mismatches, and no spreadsheets full of exchange rate lookups that may or may not reflect reality. For a deeper look at how income-first conversion works across multiple currencies, see our article on multi-currency royalty conversion.
Stop guessing at exchange rates
Manual currency conversion is one of those processes that feels manageable until you look at the cumulative cost. The errors are small enough to ignore individually but large enough to matter over a year. The time spent chasing reconciliation gaps is time you could spend on publishing. And the trust deficit with authors who notice that the math does not quite work is harder to quantify but just as real.
The fix is not finding a better exchange rate source or being more careful with your spreadsheet. The fix is removing the guesswork entirely by reconciling against the income you actually received.