Can I run a report of a supplier account whish is held in euros, showing both euro and sterling values? The report should show balances in each currency.

Yes, you can Paul-Scott! I'll guide you through it.

Let's open the Supplier's Balance Detail report, and add the Foreign Open Balance column and Currency columns to it. This will give you the supplier's balance based on your home currency and their assigned currency.

The said columns can be selected from the Gear icon I pointed out in the screenshot.

Since the Foreign Open Balance column doesn't display a total amount, you can export the report to Excel. Then, get the sum of that column.

On the other hand, you can click on Save customization to save your report in the Custom reports list. This way, you won't have to do the same steps when you need it.

If you need help in getting data like this one, just send us a short reply below.

You're welcome, Paul-Scott.

I can see the point of having a total amount in the Foreign Open Balance column. Mostly, small details like this have high impacts on reports. I'll pass this along to our product engineers.

Feedback and product suggestions have been very helpful to us. Through them, we know what our clients need. They also give us an idea of what to add or change in the QuickBooks interface.

If you have other observations like this one, let us know.