Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
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.

No text available
paul-scottAnswer
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.

View in thread

3 replies

JessT
JessTModerator
Moderator
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.

    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
    JessTModerator
    Moderator
    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.

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement