cancel
Showing results for 
Search instead for 
Did you mean: 
BethR_Ballentine
Level 2

Currency Reporting

I'm using QuickBooks Online.  My home currency is USD, but I have expenses in multiple currencies.  What report can I run with filters to get a list of transactions in a certain currency, for the past six months?  Periodically, I'm asked to forecast how much I will need to cover expenses in for each currency, and I can't find a report to give me the information I need.

3 Comments 3
MelroseV
QuickBooks Team

Currency Reporting

I've got your back, Beth. I'm here to help generate a report that shows all your expenses transactions with different currencies.

 

You can run the Transaction List by Vendors report and use filters to get your desired result. Here's how you can do it:

 

  1. In the left navigation panel, select Reports.
  2. In the search bar, type Transaction list by Vendors.
  3. Click Switch to classic view.
  4. In the right corner, click Customize.
  5. Under Rows/Columns, select Change columns.
  6. Tick Currency.
  7. Go to Filters.
  8. From the Transaction Type, select the appropriate transaction type.
  9. Click Run report.

 

You can also export this report by clicking the Export icon and then Export to Excel.

 

Let me know if you have more questions about managing reports. I'll be around to assist further. Have a great day!

BethR_Ballentine
Level 2

Currency Reporting

Thank you, I understand what you are suggesting, but it doesn't appear that I can filter by currency.  I was hoping to not have to export the information to excel and then manipulate the data.  Is there a report that lets me filter by currency?

Rasa-LilaM
QuickBooks Team

Currency Reporting

Hello there, BethR.

 

The option to filter the Transaction List by Vendor report by currency is currently unavailable. We always consider our customers' feedback and suggestions when making product improvements or adding new features. This will give us an idea of how we may refine the functionality of QuickBooks Online (QBO) to meet users' needs and enhance working experience.

 

You can submit feedback about adding the filter function for currencies straight to our engineers. They'll see your recommendation and may consider it for future releases.

 

Here's how:

 

  1. Tap the Gear icon in the upper right and choose Feedback under Profile.
  2. Enter a description of your product suggestions in the field box.
  3. Click Next to submit it.

 

Feel free to visit the QuickBooks Blog for the most recent product updates and tools to help you expand your business. These links also provide information on a variety of topics related to multicurrency and customizing the design and information on reports: 

 

 

Keep in touch if you have additional questions about multicurrency and building reports. I'll get back to assist you further. 

Need to get in touch?

Contact us