Skip to main content
F
Fr3do
August 18, 2023
Question

FX precision in QBO gets dropped when exporting to excel

  • August 18, 2023
  • 1 reply
  • 0 views

Hello - I have a mix of USD and CAD sales that I am reporting on. To show sales by project, I am generating the sales reporting using the newly developed Sales by Customer Detail report provided. 

 

The default report is stated in CAD equivalent using transaction rates in effect at the time of transaction. I would like to be able to show the impact in USD for my US Account Managers who get paid commission in $USD. There is no foreign amount field in the dataset - so I exported to excel to calculate the impact manually. I customized the report to add the exchange rate which displays perfectly to 6 decimals; my rate  = 1.337981 . When I export the data to excel the fx rate rounds to 2 decimals - the previous rate is now 1.34. 

 

Any thoughts on how to capture the USD amount or the full fx rate with better precision?? Seems silly that this happens

 

1 reply

A
Alex M
August 18, 2023

Hi there Fredo2,

 

It's important that all your transactions are correctly entered for your books to be well balanced. QuickBooks Online is a great tool able to help you track your sales and expenses so you can see the profitability of your company. I can point you in the right direction for assistance with exporting reports.

 

If the amount of the exchange rate when exporting doesn't match the one seen in the original report in QuickBooks Online, I recommend reaching out to the QuickBooks Online support team outside of the Community. They'll be able to provide some troubleshooting steps to help get this resolved, as well as collect the necessary information to notify the engineers of the error if it persists. You can reach out using these steps:

 

Schedule a Callback or start a Chat: click (?)Help in the upper right > type and enter "Contact support" into the QB Assistant > click Contact Us > explain your situation > click Let's Talk > choose Get a callback or Start a Chat.
Social Media: Facebook and Twitter

 

If you have any other questions, feel free to reach out here.

Terms & ConditionsAccessibility statement