QuickBooks HelpQuickBooksHelpIntuit

Mixing currencies in journal entries in QuickBooks Online

by Intuit Updated 3 months ago

You received this alert because your accounting has journal entries that mix currencies for customers or suppliers. These should be corrected because they may lead to incorrect open balances for them, or incorrect exchange gains or losses in your accounting.



How the problem happened

When working with multiple currencies in QuickBooks Online, all transactions for a customer or supplier must be recorded in the currency you assigned to that customer or supplier. This means when you are creating a journal entry that includes accounts receivable (A/R) or accounts payable (A/P), the currency of the transaction, the A/R and A/P accounts, and the customers/suppliers must all match.

QuickBooks Online now blocks journal entries that mix currencies for customers or suppliers because these may lead to incorrect open balances for them, or incorrect exchange gains or losses in your accounting.

If your A/R or A/P reports do not match your balance sheet or open customer/supplier balances, you may have a historical journal entry that mixes currencies. There are several reasons these could have happened. Here are two common ones:

  • You invoiced your customer in one currency, but the customer paid you in another and you used a journal entry to convert the payment.
  • You recorded an advance to a supplier in one currency, but the supplier sent the bill in another and you used a journal entry to convert the advance.


Find the problem journal entries

QuickBooks Online has a new report called Invalid Journal Transactions that only appears if you have journal entries that mix currencies for a customer or supplier. It is located in the For my accountant section of the Reports tab.

If you work with an accountant, we recommend that you share this article and the Invalid Journal Transactions report with them. If you don't work with an accountant, please see the steps below to correct the invalid journal entries. When you have finished, the Invalid Journal Transactions report will be empty.

Note: By default, the report will only show problem journal entries in This fiscal year. If you also want to correct invalid journal entries in past years, you can modify the report to show All dates.



Fix the problem journey entries

For each journal entry that mixes currencies for a customer or supplier, you should:

  1. Create a backup copy of the problem journal entry.
    1. Select the journal entry in the Invalid Journal Transactions report to open it.
    2. From the More button at the bottom-right of the screen, select Transaction Journal.
    3. When the Transaction Journal appears, select the Gear icon at the upper right of the report to customize it. In the customization window, select the Show More link, then select these checkboxes:
      • Customer
      • Supplier
      • Exchange Rate
      • Foreign Debit
      • Foreign Credit
      • Any other options you feel are useful.
    4. Using the buttons on the top right of the Transaction Journal, export it to Excel or print it. You now have a backup copy of the journal entry
  2. Delete the problem journal entry.
    1. Return to the Invalid Journal Transactions report and select the journal entry you just backed up to reopen it.
    2. From the More button, select Delete.
      Note: Do not reverse the journal entry before deleting it.
  3. Create a replacement for the problem journal entry in one of these ways:

    Option 1 (recommended)

    In most cases, you can recreate the problem journal entry so that the transaction currency, A/R or A/P currencies, and customer or supplier currencies are all the same. This may require you to manually convert one currency to another using the exchange rate from the deleted journal entry.

    Example: If you created a journal entry for a foreign-currency customer or supplier in your home currency, you could create a replacement journal entry in the foreign currency by manually dividing the home-currency amounts by the exchange rate from the deleted journal entry.

    We recommend noting the actual currency you received in the Memo field of the journal entry.

    Option 2

    1. Create a duplicate of the customer or supplier from your original journal entry and assign the second currency you want to use. You will need to use a slightly different Display Name for the duplicate.
      For example, if your original customer was assigned CAD but wants to pay you in EUR, create a duplicate customer, assign it EUR, and put space-hyphen after the Display Name.
    2. Void any open transactions for the original customer or supplier that are in the first currency but should be in the second.
    3. Recreate these transactions using the duplicate customer or supplier, so they will be in the correct currency. Refer to your printout of the deleted journal entry for the exchange rate, home currency, and foreign currency amounts to recreate these transactions.

      Example: If you invoiced your customer in CAD but your customer paid you in USD, you would:

    • Create a duplicate of the customer in USD
    • Receive the customer’s USD payment against the USD invoice
    • Void the CAD invoice to the customer
    • Recreate the invoice using the USD copy of the customer, with prices in USD

      Option 3
      If you are comfortable with accounting, you can use a home-currency wash account and two journal entries to move a receivable or payable from one customer or supplier to another in a different currency.

  4. Create an empty cash-on-hand bank account in your home currency. This wash account will only be used for currency transfers and should not carry a balance.
    For example, if your home currency is USD, create the wash account in USD.
  5. Create a duplicate of the customer or supplier from your original journal entry and assign the second currency you want to use. You will need to use a slightly different Display Name for the duplicate.
    For example, if your original customer was assigned CAD but wants to pay you in EUR, create a duplicate customer, assign it EUR, and put space-hyphen after the Display Name.
  6. Create a journal entry to move the receivable or payable from the original customer or supplier to the home-currency wash account:
    • Currency – same as the original customer or supplier on your deleted journal entry
    • Exchange rate – same as on your deleted journal entry
    • Credit A/R or A/P – the same amount as on your deleted journal entry in the currency of the original customer or supplier
    • Debit wash account – the same amount as on your deleted journal entry in the currency of the original customer or supplier
  7. Create a second journal entry to move the receivable or payable from the wash account to the target customer or supplier, in their currency:
    • Currency – same as the target customer or supplier
    • Exchange rate – should be set so that the home currency value of this journal entry matches the home currency value of the journal entry you created in Step 2, so that there will be no remainder left in the wash account. Usually, this equals the home currency amount of the first journal entry divided by the target currency amount. Note: if your target currency is the same as your home currency, there will be no exchange rate (as it is 1:1).
    • Credit wash account – the target currency amount
    • Debit A/R or A/P – the target currency amount. Assign the target-currency duplicate customer or supplier to this line item.
  8. Close the original open transaction with the original customer or supplier by applying the credit from the first journal entry to it.
  9. The receivable or payable has now been transferred to the duplicate customer or supplier in the target currency.

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.

More like this