How Do You Record Foreign Exchange Transactions?

Step-by-Step Solution

1. Enable Multicurrency
   • Go to Settings (gear icon) > Account and Settings.
   • Pick Advanced > Currency.
   • Turn on Multicurrency. If asked, set your Home Currency.
   • Click Save > Done.
2. Enter a Foreign-Currency Invoice
   • Head to + New > Invoice.
   • Select the customer and add your line items.
   • In the Currency dropdown, pick the foreign currency.
   • QuickBooks converts the amount to your home currency using the spot rate from when you entered it.
   • Click Save and send.
3. Record a Foreign-Currency Payment
   • Go to + New > Receive Payment.
   • Choose the customer from the dropdown.
   • Under Outstanding Transactions, check the invoice you’re paying.
   • In the Payment method dropdown, select the foreign currency account (like “Euro Bank Account”).
   • Enter the foreign currency amount you received. QuickBooks converts it to your home currency using the spot rate from the payment date.
   • Click Save and close.
4. Handle Exchange Gains or Losses (Realized)
   • After saving the payment, go to Accounting > Chart of Accounts.
   • Look for the Exchange Gain/Loss account (it’s created automatically if multicurrency is on).
   • Check the journal entry to confirm the realized gain or loss is posted to the right account.

What if the foreign currency payment method isn’t showing up?

If you’re not seeing the foreign currency payment method you expect, head to Accounting > Chart of Accounts, edit the account, and double-check two things: the account type must be “Bank,” and the currency setting needs to match the foreign currency you’re working with. Once those are correct, the payment method should appear in your Receive Payment screen.

How do I handle unrealized gains or losses at month-end?

At the end of each month, you’ll want to revalue your open foreign currency balances. Go to Accounting > Chart of Accounts, find your foreign currency bank account, and click Run Revaluation. Set the Revaluation Date to the last day of the month, use the Closing Rate from your bank or a trusted FX source, and click Revalue. Any gains or losses will post to the Exchange Gain/Loss account. This keeps your books accurate and compliant with accounting standards.

Can I manually adjust exchange rates in QuickBooks?

If QuickBooks is using the wrong exchange rate, you can fix it manually. Go to +New > Journal Entry, then enter a debit to the foreign bank account and a credit to Exchange Gain/Loss. In the Currency column, enter the correct rate in the Rate field, add a memo like “Manual FX adjustment – [date],” and save. This is handy when you catch an error or need to use a specific rate for compliance.

What’s the best way to avoid exchange rate errors?

Always use the exchange rate that’s current on the day of the transaction or payment. Avoid using old rates unless you’re correcting a mistake—spot rates reflect real market conditions at that moment. According to IFRS Foundation, this is required under IAS 21 (as of 2026). Also, turn on automatic revaluation in Settings > Account and Settings > Advanced > Currency by setting Revalue Open Balances to “Monthly.” It’s a simple way to stay compliant and cut down on manual errors.

How do I document my company’s foreign exchange policy?

Write down a clear FX policy for your team. Something like: “All foreign transactions will be recorded at the spot rate on the transaction date. Gains or losses will be recognized in the Exchange Gain/Loss account and reviewed monthly.” Keep it short and share it with anyone who handles foreign transactions. This matches the approach recommended by FASB ASC 830 for foreign currency matters and keeps everyone on the same page.

What’s the easiest way to monitor exchange rate changes?

Large swings in exchange rates can really impact your cash flow and profitability, so it pays to stay on top of them. Sign up for alerts from a reliable FX service like OANDA. As of 2026, QuickBooks’ multicurrency dashboard even integrates with real-time FX APIs, so you can get up-to-date rates without leaving the app. A little monitoring goes a long way in keeping your finances stable.

Why do I need to revalue open balances monthly?

Revaluing open balances at month-end isn’t just busywork—it’s how you track unrealized gains or losses from currency fluctuations. Without it, your financial statements could be misleading. By using closing rates at the end of each month, you reflect the true value of your foreign currency positions. It’s a key step in following accounting standards and making sure your books are always in good shape.

What happens if I forget to revalue at month-end?

If you skip the monthly revaluation, your foreign currency accounts won’t reflect the latest exchange rates. That means your balance sheet and income statement could be off, which might lead to compliance issues or misinformed business decisions. Honestly, this is one of those tasks that’s easy to automate—so there’s really no excuse not to do it.

Can I use historical exchange rates for corrections?

Spot rates must reflect market conditions at the time of the transaction, per IFRS (IAS 21). Historical rates are only for fixing past mistakes, not for recording new transactions. If you need to adjust something, use a manual journal entry with the correct historical rate and a clear memo explaining why you’re making the change.