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
What is the cost of setting up payroll for a small business in California?
The upfront setup cost is just the beginning. Between payroll software, employer taxes, workers' comp insurance, and potential setup fees, expect total payroll overhead to add 20-30% on top of gross wages for a small team.
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 handle 1099 preparation for independent contractors at year end?
Any non-corporate contractor you paid $600 or more during the year needs a 1099-NEC filed by January 31. The actual year-end work is simple if you collected W-9 forms upfront and tracked payments by vendor throughout the year.
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 bookkeeping records does a trucking company or owner-operator need to keep?
Trucking companies and owner-operators need to keep fuel receipts broken out by state for IFTA, maintenance logs, per diem documentation, toll receipts, load sheets with mileage, insurance records, and settlement statements from carriers. The IRS expects detailed documentation for at least three years.
Read answerHow do I handle tip reporting and tip credits for restaurant payroll in California?
California does not allow tip credits. You must pay every tipped employee the full state minimum wage of $16.50 per hour before tips. All tips, including cash, must be reported as employee income and tracked through payroll.
Read answer