Skip to main content
C
CorinneMcKay
July 21, 2022
Question

Multicurrency question: customer billed in CAD, payment in USD, amounts don't match

  • July 21, 2022
  • 1 reply
  • 0 views

Hello: I'm looking for suggestions related to the multicurrency feature in QuickBooks Online. Here's the situation I'm dealing with:

 

I live in the US and have multiple customers in Canada who I bill in Canadian dollars. They pay by wire transfer into my US bank account, and the amounts are automatically converted into US dollars. To complicate things, sometimes this client pays multiple invoices at once, and sometimes they deduct their wire transfer fees from the payments.

 

I (and my bookkeeper) can't figure out how to mark these invoices as paid in QBO because the amounts received in USD are always different and never match the exchange rate stated in QBO. Has anyone found a way to handle this other than retroactively creating new invoices that match the payment received in USD?

 

Thanks!

Corinne

1 reply

Fiat Lux - ASIA
Fiat Lux - ASIA
July 22, 2022

Utilize a clearing account

https:// quickbooks.intuit.com/learn-support/en-us/help-article/banking/use-clearing-accounts-accounting-system-paypal/L25uK5wzJ_US_en_US?uid=l5vtnxms

 

    M
    Mark_R
    July 22, 2022

    Hello there, @CorinneMcKay.

     

    I've come with a solution that can help you manage invoice payments with a different currency.

     

    When recording payments received, QuickBooks is only able to use the home currency bank account or the bank account with the currency that matches the invoice. To handle this scenario, you'll want to create a new dummy bank account in the home currency to facilitate the movement between 2 different foreign currencies. Here's how:

     

    1. Sign in to your QuickBooks Online (QBO) account.
    2. Click the Gear icon, then select Chart of Accounts.
    3. Select New.
    4. In the Account Type drop-down, select Cash and cash equivalent. Then choose Cash on hand under Detail Type. 
    5. Enter Dummy Bank from the Name field. 
    6. Make sure it is in the home currency, then click Save.

     

    Once done, record the payment of the foreign invoice. To do so, you can go to the Receive Payment page and select the Dummy Bank from the Deposit To field. Also, make sure to take note of the home currency (USD) amount displayed at the bottom right.

     

    After receiving the payment, you'll have to transfer the amount from Dummy Bank to the CAD bank account.

     

    I'm adding this article for more guidance: Receiving and making payment for a foreign invoice/ bill with a foreign currency. This article is for the Singapore region but it also applies to the other region.

     

    You may want to learn more about multicurrency. This article will give you further information: About Multicurrency.

     

    Please let me know how things go, @CorinneMcKay. I'll be around to provide further assistance.

      Terms & ConditionsAccessibility statement