Showing results for 
Search instead for 
Did you mean: 
Everything you need to know about banking in QuickBooks Online - Discover more
Level 1

spot transactions

I need help. I have Euro and USD bank accounts and sometimes I make spot transactions with a third party company. The transaction is at a negotiated exchange rate. I record the transactions in the system as a transfer and enter manually the negotiated rate. However, on the currency accounts after transaction, the balance does not match with the statement. It looks like the system uses its own exchange rate to calculate account balance. What can I do in this situation to have the same balance as on statement?

QuickBooks Team

spot transactions

Hello Gosiana, 


Welcome to the Community page, 


On the transaction, you should be able to change the exchange rate to what it should be at that time so then the balance will show the same as what it is showing on the statement. 

Level 3

spot transactions

Hi gosiana,


Negotiated or spot rate on a currency transaction with a third-party is seldom correct in producing the expected conversion to the exact penny when you recalculate after the deal has been agreed and settled. Furthermore, QBs exchange rate box can hold up to 6 digits after the decimal.


I suggest you always work out the exchange rate on a calculator, round up or down to 6 decimal points, and use that in the Funds Transfer form on QBs. Of course you may have to wait until you have all the paperwork to find out the exact amount paid in GBP or Home currency for the exact amount of foreign currency credited to your account.


Very occasionally you may encounter a cent rounding up or down difference in the currency figure, but that's another issue that requires a workaround.

Need to get in touch?

Contact us