cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here
fplhamine
Level 1

Hi all, For my auditors to test the revaluations, I need to extract daily exchange rates in QuickBooks, from 1st January up to 31st December. How can I extract it on QB?

 
1 Comment 1
RenjolynC
QuickBooks Team

Hi all, For my auditors to test the revaluations, I need to extract daily exchange rates in QuickBooks, from 1st January up to 31st December. How can I extract it on QB?

I have a report that you can run and export, fplhamine.

 

You can customise the General Ledger report and it only takes a few easy steps:

 

  1. On the left panel, Reports.
  2. Type General Ledger in the search field.
  3. Click the Customise button and expand the Rows/Columns section.
  4. Press the Change columns link.
  5. Put a check mark on the Exchange rate box.
  6. Hit Run report
  7. Select the Export icon and select Export to Excel or Export to PDF.

Please see these sample screenshots for a visual reference:

 

 

For more details, you can read this article: Learn about exchange rates in QuickBooks Online. To view other guides and tutorials, feel free to visit our general help topics page.

 

I'm always here to lend a helping hand. Please don't hesitate to reach out to me. Have a great day!