Skip to main content
January 27, 2021
Question

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?

  • January 27, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

RenjolynC
January 27, 2021

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!