Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
sbhajikhau91
Level 1

While integrating helcim transactions in QBO, QBO applies an exchange rate of 1 USD = 1 CAD. This leads to incorrect foreign exchange gain/loss entries. Any solution?

We create invoices in USD, and in QBO they are recorded correctly with the appropriate exchange rate applied, resulting in accurate CAD values. However, when payments are processed through Helcim in USD and synced to QBO, the transactions are deposited into our USD bank account, but QBO applies an exchange rate of 1 USD = 1 CAD. This leads to incorrect foreign exchange gain/loss entries. It appears that the correct exchange rate is not being passed to QBO during the sync process. Could you please investigate this issue? This discrepancy is impacting the accuracy of our financial reporting, so we would appreciate your prompt assistance.

1 Comment 1
RhoiceW
QuickBooks Team

While integrating helcim transactions in QBO, QBO applies an exchange rate of 1 USD = 1 CAD. This leads to incorrect foreign exchange gain/loss entries. Any solution?

Hi there, sbhajikhau91. When Helcim syncs payments into QuickBooks Online, the exchange rate applied to those transactions is controlled by the data Helcim sends through the system. If Helcim does not include the specific exchange rate with the payment data, QBO defaults to a 1:1 rate.

 

Since the exchange rate on the payment doesn't match the rate on your original invoice, QBO calculates the difference and records it as a gain or loss. To resolve this, you can manually update the exchange rate by going to the Gear icon > Currencies > locate the currency > Edit currency exchange.

 

Once you've updated the rate, QBO will automatically recalculate the foreign exchange gain/loss based on the corrected exchange rate, and your financial reports should reflect the accurate amounts.

 

If you need anything related to QuickBooks, don't hesitate to reply here. We're here to help.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us