Skip to main content
P
paul-scott
August 31, 2019
Solved

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.

  • August 31, 2019
  • 1 reply
  • 0 views
Original commenter did not share additional details
Best answer by paul-scott

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.

1 reply

JessT
JessT
August 31, 2019

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.

    P
    paul-scottAuthorAnswer
    September 1, 2019

    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
    JessT
    September 1, 2019

    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.

    Terms & ConditionsAccessibility statement