Skip to main content
March 3, 2022
Question

Is there a report on currency exchange rate by date for a past 12 months

  • March 3, 2022
  • 1 reply
  • 0 views
Is there a currency exchange rate report by day for the past 12 months ?

1 reply

March 3, 2022

Thanks for checking in with us, jackie27. 

 

In QuickBooks Online (QBO), we can run reports like Transaction Detail by Account and customise the column to include the Exchange rate and Currency columns. Then, choose the date for the past twelve months in the Report period field. Here's how:

  1. Go to Reports on the left menu.
  2. Enter Transaction Detail by Account in the search field.
  3. Click Customise tab.
  4. Tap Rows/Columns field.
  5. Select Exchange rate and Currency columns.
  6. Enter the date for the past twelve months in the Report period field.
  7. Press Run report

 

Once done, you'll be able to see accounts with different currencies on the report. Here's an article you can read for more details: Customise reports in QuickBooks Online. Just in case you want to memorise this report, feel free to check out this article for the detailed steps and information: Memorise reports in QuickBooks Online.

 

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day and be safe.