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 account for returns, refunds, and chargebacks in e-commerce bookkeeping?
Returns and refunds reduce revenue and should be recorded as credit memos or negative invoices in QuickBooks Online. Chargebacks include an additional processor fee that needs to be categorized as a separate expense. Each type requires different treatment in your books.
Read answerHow do I reconcile insurance reimbursements with patient charges in QuickBooks?
Record every service at the full billed amount, then post insurance payments alongside contractual adjustment line items. Tracking the gap between charges and collections gives you your net collection rate, which is one of the most important financial health indicators for any medical practice.
Read answerWhat paperwork does a California employer need when hiring a new employee?
California employers need federal and state tax withholding forms, an I-9 within three days, a new hire report to the EDD within 20 days, and several California-specific notices. Missing any of them can result in fines.
Read answerHow does California sales tax work and what are my CDTFA filing requirements?
California charges a 7.25% base sales tax rate plus local district taxes that vary by location. Most tangible goods are taxable while most services are not. You file returns with the CDTFA, typically quarterly for small businesses.
Read answerHow do I handle shipping costs in bookkeeping — expense them or include in COGS?
It depends on the direction. Inbound shipping from your supplier should be included in inventory cost and flow into COGS. Outbound shipping to customers can be a separate expense or part of COGS, but pick one approach and stick with it.
Read answerWhat is California use tax and when does my business need to pay it?
Use tax is California's complement to sales tax. You owe it when you buy tangible goods and the seller doesn't collect California sales tax, most commonly from out-of-state vendors. The rate is the same as your local sales tax rate.
Read answer