Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.
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:
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!
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?
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:
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here