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
Do I need separate QuickBooks files for each medical entity or can I use class tracking?
For healthcare groups with distinct legal entities like LLCs and professional corporations, separate QuickBooks Online files are generally the better choice. Class tracking in a single file can work for two or three entities but creates problems as you grow.
Read answerWhat chart of accounts should a dental or medical practice use in QuickBooks?
Medical and dental practices need a chart of accounts with revenue split by provider or service line, insurance versus self-pay income, and expense categories for supplies, malpractice insurance, equipment leases, and EHR subscriptions. The standard QuickBooks template doesn't include these.
Read answerHow do I set up inventory accounting in QuickBooks for a wholesale distribution business?
Enable inventory tracking in QuickBooks Online, set up products with accurate costs, and organize by category or product line. Most wholesalers with hundreds of SKUs will need a third-party inventory app that syncs with QBO to handle landed costs, reorder points, and real reporting.
Read answerHow should a nephrology or dialysis practice handle bookkeeping for multiple clinic locations?
Each clinic location needs its own set of books with a standardized chart of accounts so you can produce location-level P&L reports. Shared costs like admin, billing staff, and EMR systems require documented allocation methods that hold up under audit.
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 answerWhat is the best way to track intercompany transactions between healthcare entities in QuickBooks?
Set up Due To and Due From accounts in each entity's QuickBooks file to log every payment made on behalf of another entity. QuickBooks Online lacks built-in intercompany elimination, so you'll need manual journal entries and monthly reconciliation between entities.
Read answer
