multicurrencies report

Welcome to the QuickBooks Community, @Samer-Wehbe.

Having a report that suits your business is a great way to focus only on the data you need the most. However, in QuickBooks Desktop (QBDT), you can only run the Profit and Loss report in your home currency. 

As a workaround, you can add a column for Euro Currency and export the report to excel to edit and remove columns or rows you don’t need. Here's how:

1. Open the Profit and Loss Detail report.
2. From the report page, click the Customize Report button.
3. Set the Report Date Range to Custom. Select the From: (1/1/2021) and To: (6/31/2021) date. 
4. Next, go to the Display tab, and select Currency, Foreign Amount, Amount and other columns you'll want to show on the report.
5. Then, click OK. 

Once done, you'll now see EUR and USD currencies in the report.  To edit the columns and rows of the report so it will only show EUR currency, you can export the report to excel and modify it from there. Let me guide you on how:

1. Click the Excel dropdown and choose Create New Worksheet.
2. Select Export.
3. You'll be routed to the Excel spreadsheet. 
4. You can now edit the columns and rows from there. 

You can also look for a third-party app that integrates with QBDT so you'll be able to generate the report you need. To do so, please go to our QuickBooks Apps Store page.

To keep you updated on the latest news of the product, I encourage you to visit our Firm of the future page. From there, you'll see newly released features and other resources that'll help manage your business. 

QBDT makes it easy to save your report customization so you'll be able to use it in the future. To do so, simply click the Memorize button in the reports window. 

If you need further assistance running a profit and loss report for foreign currency, feel free to post a reply below. I'm always here to help. 

@Samer-Wehbe 

You should explore a business intelligent app to do so.

thank you

got any suggestions?