Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowOn transactions involving FX translations, there are many times when the FX rate the bank uses is different than the FX rate QB uses. And even when I try to change the QB FX rate to come close to the USD bank payment, the system will not allow a match even if the difference between the bank payment and QB is $.01. This is not correct. It should show it as a translation adjustment.
I appreciate the effort you've made in adjusting the QuickBooks exchange rate to match the USD bank payment, KJ. QuickBooks uses specific criteria to ensure bank transactions match your records accurately.
It looks for an exact match on the amount, date, and payee. Even a difference as small as $0.01 prevents the system from automatically matching the transaction.
The mismatch occurs because the exchange rate changes between the time the invoice is created and when the payment is received. When you enter an entry in a foreign currency, QuickBooks locks in the exchange rate for that day to calculate its value in your home currency.
But when your client pays, the bank uses its exchange rate on the day the payment is processed. This rate is almost always different from the one on the invoice date.
It's also helpful to know that QuickBooks uses exchange rates from an external provider, IHS Markit, which updates the rates every few hours. This reason explains why the rate on the invoice date in QuickBooks doesn't always match the rate your bank uses when processing the payment.
To match an invoice, you need to use a bank account that uses the same currency as the payment. While QuickBooks doesn't automatically adjust for foreign currency payments, you can create a Dummy Bank account to handle payments from foreign bills.
Then, transfer the money from your foreign currency bank account into this Dummy Bank account. Also, ensure the Multicurrency feature is enabled in your settings.
Here's how to create the account:
After completing these steps, you can receive the USD payment by following these steps:
Afterward, transfer the USD amount from the Dummy Bank account to your foreign currency bank account using the bank transfer feature.
For more detailed guidance, check out this reference: Receiving and making payment for a foreign invoice/bill with a foreign currency. The steps apply to all regions, even though this article is for Singapore.
This thread will remain open if you have further queries. We're always here to help.
Thanks for the feedback. However, QuickBooks's approach is much more complex than it should be. Creating a dummy bank account and using it to match bank FX transactions is “overkill.” A more straightforward method (although not ideal) is to delete the downloaded bank transaction and make a reconciliation adjustment to offset the cash differences. QuickBooks needs to find a software solution to this issue that does NOT add an extra step, like a dummy bank account or reconciliation adjustment, to this process.
I was able to fix this the following way:
I was able to fix this the following way:
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here