I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.

porthgwarra · ‎July 20, 2019

When I come to reconcile I have two duplicate entries... mine, which is correctly associated with the invoices, and the bank's. Exact same date and GBP amount, but I can only 'Add', and not 'Match' transactions. Is there a workaround please?

Rasa-LilaM · ‎July 20, 2019

Thanks for dropping by the Intuit Community, porthgwarra.

Let’s select the Foreign currency option so you can match the transaction. I’m here to help accomplish this task.

Here’s how:

Log in first to your account to access and select the Banking menu to open the Bank and Cards screen.
From there, choose the appropriate account you’re working.
Under For Review, locate and select the transaction to open it.
Mark the radio-button for Find Match.
Once the Match transactions window opens, choose the Foreign currency radio button.
In the Select transactions to match section, you’ll see lists of possible matches and select the right one.
Click on Save.

For more in-depth information on how QuickBooks analyses your bank transactions and matches them: Add and match downloaded bank transactions.

If there’s anything else I can help you with, click on the Reply button and post a comment. I’ll be right here to assist further. Wishing you the best.

View solution in original post

Rasa-LilaM · ‎July 20, 2019

Thanks for dropping by the Intuit Community, porthgwarra.

Let’s select the Foreign currency option so you can match the transaction. I’m here to help accomplish this task.

Here’s how:

Log in first to your account to access and select the Banking menu to open the Bank and Cards screen.
From there, choose the appropriate account you’re working.
Under For Review, locate and select the transaction to open it.
Mark the radio-button for Find Match.
Once the Match transactions window opens, choose the Foreign currency radio button.
In the Select transactions to match section, you’ll see lists of possible matches and select the right one.
Click on Save.

For more in-depth information on how QuickBooks analyses your bank transactions and matches them: Add and match downloaded bank transactions.

If there’s anything else I can help you with, click on the Reply button and post a comment. I’ll be right here to assist further. Wishing you the best.

porthgwarra · ‎November 05, 2019

Hello again Rasa-LilaM,

This question follows on from the answer you helpfully provided in July...

I've receieved USD payment into my Undeposited Funds a/c, within QBO.

My GBP bank download shows the funds arriving, in sterling

As you taught me, I can 'find match' by selecting the foreign currency button...

BUT... when I click 'save', I get the error message...

"Something’s not quite right

The currency of the transaction is invalid for customer/supplier/account."

The currency for the customer is USD, and correct.

To me, this seems no different from the transactions I've handled since your last advice

I hope you're able to help, again. Many thanks, Peter

GraceC · ‎November 05, 2019

Hello there, @porthgwarra.

You can create a bank deposit to match your banking. Let me guide yo how.

Click the Create (+) icon.
Choose Bank Deposit.
Update the Account and Date.
Make sure the correct Currency is selected.
Click Save and close.

From the bank deposit change the currency to show the USD payment that you create.

Don't hesitate to drop your comment below if you have any other questions. Have a nice day!

Topics

Training

Community

Resources

I invoice US customers in USD. They pay in USD to my GBP bank a/c. I receive the funds against the invoice, using the exchange rate. But can't 'match' with bank feed.