Skip to main content
paul-scott
Aug 31, 2019 12:43 PM UTC
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.

Original commenter did not share additional details
paul-scottAnswer
Sep 1, 2019 9:36 AM UTC

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 in thread

3 replies

JessT
JessT
Aug 31, 2019 1:28 PM UTC

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-scottAuthorAnswer
    Sep 1, 2019 9:36 AM UTC

    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
    Sep 1, 2019 10:33 AM UTC

    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