cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
paul-scott
Level 2

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.

 
Solved
Best answer September 01, 2019

Accepted Solutions
paul-scott
Level 2

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.

That's good, thank you. However it is a pity that QBO seems unable to allow this fully without having to resort to an excel export. If a supplier account is set up in a foreign currency it should be possible to report the full detail - with full running balances - in that currency, without having to make an excel workaround.

View solution in original post

3 REPLIES 3
JessT
Moderator

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.

paul-scott
Level 2

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.

That's good, thank you. However it is a pity that QBO seems unable to allow this fully without having to resort to an excel export. If a supplier account is set up in a foreign currency it should be possible to report the full detail - with full running balances - in that currency, without having to make an excel workaround.

JessT
Moderator

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.

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.

Need to get in touch?

Contact us