cancel
Showing results for 
Search instead for 
Did you mean: 
siewlan-tay
Level 1

Where i can download the exchange table adopted by QB for the year for auditor?

 
1 Comment 1
Catherine_B
QuickBooks Team

Where i can download the exchange table adopted by QB for the year for auditor?

We use the most recent market rates, siewlan-tay. 

 

While we don't have the option to download or export the list of market rates within last year, we can directly ask a list from Markit. 

 

We can also pull up the Transaction List by Customer report and add the Exchange rate and Currency column. This way, we can get an overview of what rates we used for these transactions. I'll show you how:

  1. Go to the Reports menu. 
  2. In the Search field, enter and select Transactions List by Customer
  3. Click the Customize button. 
  4. Modify the Report period to last year. 
  5. Select Rows/Columns, click Change columns
  6. Check the Exchange rate and Currency box. 
  7. Click Run report

You might want to export the reports to Excel by selecting the export icon at the upper-right. Hit Export to Excel

 

Feel free to get back to me if you need anything else. Thanks!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up