cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover the updated GST rates in QuickBooks Online Singapore Find out more
jackie27
Level 1

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

Is there a currency exchange rate report by day for the past 12 months ?
1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

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

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.