Skip to main content
R
rkumar1
May 22, 2020
Solved

Customer GBP invoice was paid in USD so how to record this transaction?

  • May 22, 2020
  • 2 replies
  • 0 views

A GBP 19k sales invoice was issued in Jan 2020 and USD equivalent was USD 25,088.74. Today the customer paid GBP 19k but the USD equivalent I received is USD 23,179.61. How to record below journal entry to receive this payment, however, since the customer account created is GBP so I get below error to post. "The currency of your deposit account and currency of the customer must be same.? 

 

Dr. Cash USD 23,179.61

Dr. Foreign Currency Exchange Loss USD 1,909.13

Cr. Accounts Receivable USD 25,088.74

 

 

Best answer by RenjolynC

Hi rkumar1,

 

When creating the receive payment for the invoice, you can manually adjust the rate by following these steps:

 

  1. Go to Sales > Customers.
  2. Select the customer's name and click the Receive payment link of the invoice you want to pay.
  3. Under the Customer drop-down menu, enter the new rate. You will be prompted to changed the exchange rate of the British Pound Sterling (GBP). You can select to Use for this transaction only or Use for all new transactions in British Pound Sterling (GBP).
  4. Make sure to select Undeposited Funds from the Deposit to drop-down menu.
  5. Click Save and close.

Once done, follow these steps to deposit the payment:

 

  1. Go to + New > Bank Deposit.
  2. Select the bank account where you want to deposit the payment.
  3. Choose the currency from the drop-down and enter the exchange rate.
  4. Put a check mark on the transaction and then click Save and close.

 

Then, run the Exchange Gain or Loss account to see the details by going to Accounting > Chart of Accounts.

 

I'm also adding these articles for more information about multicurrency:

 

Let me know if you have any additional questions or other concerns. Take care and stay safe.

2 replies

RenjolynC
RenjolynCAnswer
May 22, 2020

Hi rkumar1,

 

When creating the receive payment for the invoice, you can manually adjust the rate by following these steps:

 

  1. Go to Sales > Customers.
  2. Select the customer's name and click the Receive payment link of the invoice you want to pay.
  3. Under the Customer drop-down menu, enter the new rate. You will be prompted to changed the exchange rate of the British Pound Sterling (GBP). You can select to Use for this transaction only or Use for all new transactions in British Pound Sterling (GBP).
  4. Make sure to select Undeposited Funds from the Deposit to drop-down menu.
  5. Click Save and close.

Once done, follow these steps to deposit the payment:

 

  1. Go to + New > Bank Deposit.
  2. Select the bank account where you want to deposit the payment.
  3. Choose the currency from the drop-down and enter the exchange rate.
  4. Put a check mark on the transaction and then click Save and close.

 

Then, run the Exchange Gain or Loss account to see the details by going to Accounting > Chart of Accounts.

 

I'm also adding these articles for more information about multicurrency:

 

Let me know if you have any additional questions or other concerns. Take care and stay safe.

R
rkumar1Author
May 22, 2020

Thank you very much for a very simple answer to my query. 

 

To follow-up on this what is the reason to Receive Payment and enter the exchange rate and deposit this into put in Undeposited Funds an this from Undeposited Funds using the exchange rate entered earlier and transfer this to the bank account?

A
AileneA
May 22, 2020

Hello, @rkumar1. 

 

Thank you for posting back to the Community. I'd be happy to share with you some insight into Undeposited funds and Receive payment. Undeposited funds, it’s a special temporary account that QuickBooks uses to hold funds until you are ready to deposit them.

 

While Receiving payments in QuickBooks helps maintain accurate accounts receivable balanced. When a payment is entered into QuickBooks, the accounts and financial statements are affected.

 

It serves as the default Deposit to account when you receive payments, uses a payment item on an invoice, or enter a sales receipt. Once payment received, the transaction will record it at your Bank register. When you reconcile your account this will help you balance everything in your book. 

 

I'm also adding this article for more detailed information how Undeposited funds works in QuickBooks: How to Use the Undeposited Funds Account to Receive Payments in QuickBooks Online. 

 

Let me know if there's anything that I can assist you with QuickBooks by clicking a Reply below. I'm always glad to help in any way I can. Have a great rest of the day!

Fiat Lux - ASIA
Fiat Lux - ASIA
May 22, 2020

@rkumar1 

As for future reference, you may utilize a 3rd party payment service to deal with multi currency transactions. You may release invoice and get paid in USD, and you customer pays it in their local currency (e.g GBP).

https:// veem.grsm.io/veems

 

Terms & ConditionsAccessibility statement