How do I handle multi-currency transactions for an import business in QuickBooks?
Before you do anything, understand that enabling multi-currency in QuickBooks Online is a one-way switch. Once you turn it on, you cannot turn it off. It changes how QBO handles every foreign-currency vendor and customer going forward. This isn’t a reason to avoid it if you need it, but make sure your chart of accounts and existing data are clean before you flip that switch. Back everything up and get your current books reconciled first.
Once multi-currency is active, you assign a currency to each vendor. When you create a bill for a supplier in China, you enter the amount in Chinese yuan. QBO automatically pulls the exchange rate for that transaction date and records the equivalent in US dollars. You don’t need to do the conversion manually. The bill shows both the foreign amount and the USD equivalent so you can see exactly what happened.
The important part for importers and wholesalers is what happens between the bill date and the payment date. Say you receive a bill for ¥100,000 when the exchange rate gives you a USD equivalent of $13,800. Two weeks later when you actually wire the payment, the rate has shifted and you end up paying $14,100. That $300 difference is a realized exchange gain or loss. QBO recognizes this automatically when you record the payment and posts it to an Exchange Gain or Loss account.
These fluctuations can significantly impact your cost of goods sold. If you’re importing containers of product and paying suppliers in foreign currency, even small rate movements on large invoices add up fast over a quarter. The problem is that QBO rolls these gains and losses into a single account, which makes it hard to see how much exchange rates are actually affecting your margins on specific product lines or shipments.
Track the exchange rate impact on COGS separately. One approach is to create a sub-account under COGS specifically for currency adjustments so you can isolate how much of your cost variance comes from rate changes versus actual price increases from suppliers. This gives you a much clearer picture of whether your landed costs are going up because the supplier raised prices or because the dollar weakened.
A few practical tips that help with day-to-day operations. Always review the exchange rate QBO pulls before saving a transaction. The default rate is sometimes a day behind or slightly off from what your bank actually charges. You can manually override it with the rate from your wire transfer confirmation. Also, try to record bills and payments promptly so the rates QBO captures are close to what actually happened.
If you’re running an import business and haven’t set up multi-currency yet, or if it’s enabled but your books are a mess because of it, working with bookkeepers in Buena Park who understand both QuickBooks configuration and import operations can save you from compounding errors that become expensive to fix later.
Orange County's Small Business Bookkeeper
The Next Step:
A Short Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote with no surprises.
More Questions
How do I track inventory across multiple e-commerce platforms in QuickBooks?
QuickBooks Online's built-in inventory can't sync stock levels across Amazon, Shopify, and wholesale channels. You need a dedicated inventory management system that connects all your sales channels and pushes the financial data into QuickBooks.
Read answerHow do I track restricted vs. unrestricted donations in QuickBooks?
Use separate income accounts for donations with and without donor restrictions, and track specific restrictions using classes in QuickBooks Online. When the restriction is fulfilled, release the funds through a journal entry.
Read answerIs QuickBooks Online HIPAA compliant for medical practice bookkeeping?
No. QuickBooks Online is not HIPAA compliant and Intuit does not sign Business Associate Agreements. Medical practices can still use QBO for bookkeeping, but only summary financial data should go in. Patient health information belongs in your practice management or EHR system.
Read answerHow do I handle sales tax nexus for an e-commerce business selling across multiple states?
After the 2018 Wayfair Supreme Court decision, most states can require you to collect sales tax once you cross their economic nexus threshold. For California-based e-commerce sellers, that means collecting CA sales tax plus registering and filing in every other state where you hit the threshold.
Read answerHow do I handle booth rental vs. employee stylists in salon bookkeeping?
Booth rental income and employee wages are recorded completely differently in your salon books. Booth rent is rental income with no payroll obligations, while employee stylists create wage expenses, payroll tax liabilities, and tip reporting requirements. California's ABC test adds another layer by making worker misclassification a costly risk.
Read answerHow do I separate personal and business expenses when a doctor owns the practice building?
The standard approach is to hold the building in a separate LLC from the medical practice. The practice pays fair market rent to the property LLC, and both entities maintain completely separate books.
Read answer