cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
akber-rao-gmail-
Level 2

How can I match the payment received / paid of an invoice / bill from the bank in a different currency than that of the invoice / bill itself?

I have a bill made in USD but the payment will be made from PKR bank account. Same is the case with sales invoices
Solved
Best answer December 25, 2022

Best Answers
Bryan_M
QuickBooks Team

How can I match the payment received / paid of an invoice / bill from the bank in a different currency than that of the invoice / bill itself?

Hi there, akber.

 

Let me help you match your bill from a different currency.

 

Beforehand, QuickBooks Online is able to use Invoice/Bill in different foreign currencies. However, when recording payments received/made, we are only able to use the home currency bank account or the bank account with the currency that matches the Invoice/Bill.

 

You'll need to turn on your Multicurrency feature in order to receive and make payments with a foreign currency.

 

First, we'll have to create a new dummy bank account in the home currency to facilitate the movement between 2 different currencies.

 

  1. Select the Gear icon, then select Chart of Accounts
  2. Select New
  3. Under the Account Type column, select Cash and cash equivalent. Under the Detail Type column, select Cash on hand. And under the Name column, type in Dummy Bank
  4. Before saving and closing, make sure that it is in the home currency.

 

We must record the payment of the foreign invoice. In the Receive payments module, set the Deposit To field to dummy Bank. Ensure to take note the home currency amount displayed at the bottom right before saving the transaction.

 

Next, we'll have to transfer this USD from the dummy bank to the PKR bank account:

 

  1. Select + New.
  2. Select Transfer.
  3. Under the Transfer Funds From column, select Dummy Bank from the drop-down arrow.
  4. Under Transfer Funds To, select PKR Bank from the drop-down arrow.
  5. Under the Currency column, select USD from the drop-down arrow.
  6. Under the Transfer amount column, type in the amount.
  7. Under the Exchange rate, the exchange rate will automatically appear. You can manually change the rate.

 

Note: This article receiving and making payment for a foreign invoice/ bill in a foreign currency from Singapore. However, can be applied to all regions.

 

After performing the steps above, you can refer to this article to categorize and match online bank transactions in QuickBooks Online.

 

Feel free to read these articles for more information about multiple currencies. 

 

 

Feel free to reply to this post if you have further questions about matching transactions with different currencies. I'll be happy to lend a hand. Have a good one!

View solution in original post

3 Comments 3
Bryan_M
QuickBooks Team

How can I match the payment received / paid of an invoice / bill from the bank in a different currency than that of the invoice / bill itself?

Hi there, akber.

 

Let me help you match your bill from a different currency.

 

Beforehand, QuickBooks Online is able to use Invoice/Bill in different foreign currencies. However, when recording payments received/made, we are only able to use the home currency bank account or the bank account with the currency that matches the Invoice/Bill.

 

You'll need to turn on your Multicurrency feature in order to receive and make payments with a foreign currency.

 

First, we'll have to create a new dummy bank account in the home currency to facilitate the movement between 2 different currencies.

 

  1. Select the Gear icon, then select Chart of Accounts
  2. Select New
  3. Under the Account Type column, select Cash and cash equivalent. Under the Detail Type column, select Cash on hand. And under the Name column, type in Dummy Bank
  4. Before saving and closing, make sure that it is in the home currency.

 

We must record the payment of the foreign invoice. In the Receive payments module, set the Deposit To field to dummy Bank. Ensure to take note the home currency amount displayed at the bottom right before saving the transaction.

 

Next, we'll have to transfer this USD from the dummy bank to the PKR bank account:

 

  1. Select + New.
  2. Select Transfer.
  3. Under the Transfer Funds From column, select Dummy Bank from the drop-down arrow.
  4. Under Transfer Funds To, select PKR Bank from the drop-down arrow.
  5. Under the Currency column, select USD from the drop-down arrow.
  6. Under the Transfer amount column, type in the amount.
  7. Under the Exchange rate, the exchange rate will automatically appear. You can manually change the rate.

 

Note: This article receiving and making payment for a foreign invoice/ bill in a foreign currency from Singapore. However, can be applied to all regions.

 

After performing the steps above, you can refer to this article to categorize and match online bank transactions in QuickBooks Online.

 

Feel free to read these articles for more information about multiple currencies. 

 

 

Feel free to reply to this post if you have further questions about matching transactions with different currencies. I'll be happy to lend a hand. Have a good one!

akber-rao-gmail-
Level 2

How can I match the payment received / paid of an invoice / bill from the bank in a different currency than that of the invoice / bill itself?

Thank you, Bryan. 

MirriamM
Moderator

How can I match the payment received / paid of an invoice / bill from the bank in a different currency than that of the invoice / bill itself?

Hello there, @akber-rao-gmail-.

 

I am glad to know that the recommended steps provided by my colleague worked for you. 

 

In case you need tips and related articles in the future about the "How Do I" steps in QuickBooks Online, visit our QuickBooks Community help website for reference: QBO Self Help.

 

If you need additional help with QuickBooks, please let us know. We’ll be right here to further assist. Take care, and I wish you continued success.