Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 19, 2026
Question

Is there any option in Quickbooks to export the Currency exchanges for an year

  • March 19, 2026
  • 1 reply
  • 2 views
Need to understand any way of exporting the Currency exchanges from Quickbooks into an excel for the transactions.

    1 reply

    Tori B
    QuickBooks Team
    March 19, 2026

    Good morning, @Renukumar-Mundackal-Vikraman.

     

    Thanks for taking the time to reach out to the QuickBooks Community. I hope your day is going great so far. 

     

    You can export transactional data including currency exchange details to Excel in QuickBooks Online by using the Export Data tool under settings. While you cannot directly export a dedicated "exchange rate report" that shows historical rates for every transaction, you can export a Transaction Detail report and add the exchange rate column to Excel. I'm including some steps below to walk you through the process.

     

    1. Go to the Gear icon.
    2. Under Tools, select Export Data.
    3. On the Reports tab, set the date range to year-to-date.
    4. Add items from the Reports/Lists tabs by toggling the slider.
    5. Press Export to Excel.

     

    In Excel, you can identify the foreign currency, home currency, and transaction exchange rate to analyze the data. 

     

    For more information about exporting, check out Export your QuickBooks Online data

     

    That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Take care!