Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
CorinneMcKay
Level 1

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

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

3 Comments 3
Fiat Lux - ASIA
Level 15

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

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

 

Mark_R
Moderator

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

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.

CorinneMcKay
Level 1

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

Thank you!

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us