cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
OEC
Level 2

Invoiced in CAD and received payment in USD

I invoiced a customer for 3 invoices totalling $139,000 CAD.  However, he sent the payment as $138,933.86 USD, which the bank converted at a rate of 0.7461016.  How do I receive payment for the 3 invoices?  When I try doing it, it tells me "Transactions can have only one foreign currency at a time".  My home currency is CAD.  Thank you. 

5 Comments 5
JamesM
QuickBooks Team

Invoiced in CAD and received payment in USD

Hi there,

 

I appreciate you reaching out to the Community. It's important you're able to record the transaction correctly and I'll be happy to help. 

 

Based on what you've described, you'll need to click on the Plus icon > Receive Payment > enter the amount you received in CAD, not USD. What you're doing here is converting the amounts from USD into CAD. While you're on the Receive Payment screen, select all 3 invoices. After saving this transaction, the customer will have a credit of the left over amounts. I did the conversion from USD to CAD and based on the exchange rate you provided, I came up with 1.3404 which turns to $186,213.06 which the amount the customer paid you in CAD. 

 

Let me know if this helps. Otherwise, if you need further assistance, please contact our support team using this link here.

Fiat Lux - ASIA
Level 15

Invoiced in CAD and received payment in USD

@OEC 

Explore this service if you deal with any multi-currency transaction. It supports QBO.

https://veem.grsm.io/veems

 

Hope it helps.

ts192
Level 1

Invoiced in CAD and received payment in USD

I'm having the same issue. Did you get it figured out?

OEC
Level 2

Invoiced in CAD and received payment in USD

So this is the entries that worked to fix this problem:

 

1- Receive payment for the 3 individual invoices, in CAD.

 

2- do a journal entry:  

DT USD account - $103,658.78

DT F.X. account - $35,341.22

CT CDN account -  $139,000

 

My invoices were marked as paid and the correct currency exchange is recorded as well.

 

Hope it helps.

Marie Hazel_2020
Level 1

Invoiced in CAD and received payment in USD

hello good morning,

 

i've been reading the preview on the QnA.

 

in addition to this situation, 1 customer, with CAD and USD account.

 

they paid more than in their USD account, so from their over payment USD, they want to apply it in their CAD account with the present rate. once applied to their CAD account, what will happen to the floating amount in their USD account which has been applied to their CAD account?

 

how are we going to reconcile it?

 

thanks 

 

hazel 

Need to get in touch?

Contact us