How do I handle currency conversion for international e-commerce sales?
Most e-commerce platforms handle currency conversion before the money reaches you. When a customer in Germany pays in euros through Amazon or Shopify, the platform converts it to USD and deposits dollars in your account. Your books stay entirely in US dollars because that’s what you actually receive.
The conversion happens automatically, but the fees don’t disappear. Platforms typically charge 1-3% for currency conversion, and this amount is buried in your payout calculations. Look at your settlement reports to find these fees. They should be tracked as a separate expense in your books, not lumped into general marketplace fees. Over a year of international sales, conversion fees add up to real money worth monitoring.
Record your revenue at the amount deposited to your bank, not the original foreign currency amount. If a European customer paid €100 and you received $104 after conversion and fees, your revenue is $104. Don’t try to record €100 and then track the conversion separately. That creates unnecessary complexity for most e-commerce sellers.
If you receive payments directly in foreign currency through PayPal or your own payment processor, things get more complicated. You need to convert the transaction at the exchange rate on the sale date for your records. When you later convert that foreign balance to USD, any difference between the recorded amount and what you actually receive becomes a foreign exchange gain or loss. These gains and losses are real income or expense items that show up on your tax return.
Reconcile your platform payouts to your bank deposits weekly or at least monthly. International sales often have longer settlement times and different fee structures than domestic sales. Catching discrepancies early saves hours of detective work later when you’re trying to figure out why your bank balance doesn’t match your records.
Your accounting software can help if configured correctly. QuickBooks and Xero both have features for multi-currency transactions, though most sellers operating primarily in USD don’t need to enable full multi-currency mode. The simpler approach works when platforms convert before paying you.
If you’re selling in multiple countries and seeing significant international volume, consider working with a Scottsdale bookkeeper who understands e-commerce payment flows. The platform reports can be confusing, and small tracking errors multiply across hundreds of transactions. Getting the system right once prevents ongoing headaches with reconciliation and tax reporting.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How do I handle tip reporting and payroll for servers?
Employees report tips to you monthly, and you withhold taxes on those tips through payroll. The challenge is setting up systems to capture cash tips and integrating credit card tip data from your POS.
Read answerWhat's the best way to track Amazon seller fees in QuickBooks?
The key is breaking apart Amazon's net deposits into gross sales and individual fee categories. You can do this manually using settlement reports or automate it with integration tools like A2X.
Read answerHow do I reconcile accounts that haven't been reconciled in months?
Start with the oldest unreconciled month and work forward chronologically. Gather all your bank and credit card statements, then tackle one account at a time until you're current.
Read answerWhat does an outsourced controller do for a small business?
An outsourced controller handles financial oversight and reporting above basic bookkeeping. They manage your monthly close process, prepare meaningful financial statements, establish internal controls, and give you confidence your numbers are accurate.
Read answerHow do I track labor costs by project?
Track labor costs by having employees record hours daily to specific projects, capturing fully burdened costs in your accounting software, and reconciling weekly. The key is real-time tracking, not reconstructing timesheets later.
Read answerWhy can't I figure out where my money is going?
The problem is usually looking at the wrong information. Bank statements show transactions but not patterns. Properly categorized books with monthly review show exactly where every dollar went.
Read answer