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

How can I get Supplier balance detail reports to show running balances?

When I run customised report showing paid as well as unpaid bills- the balances column is all zero, except regarding unpaid bills. I am trying to look at the history of bills and payments
6 REPLIES 6
GeorgiaC
QuickBooks Team

How can I get Supplier balance detail reports to show running balances?

Hello jane-abhamilton-

 

Thanks for joining the Community. 

 

The balance column is a running total of all bills and payments. Does the column continue to show as zero for paid bills when running the report on a different web browser, and do you expect to see a positive or negative balance there? 

jane-abhamilton-
Level 1

How can I get Supplier balance detail reports to show running balances?

I would expect to see either a positive or a negative balance depending on relative dates of bills and payments

The report shows balances in both columns until you run it as a customised report including paid bill- at which point only unpaid bills appear in the totals columns

This applies both in Safari and Chrome

Ashleigh1
QuickBooks Team

How can I get Supplier balance detail reports to show running balances?

Hello Jane-abhamilton, thanks for coming back to us, so it sounds like the report is broken, can you please reach out to our chat support or our phone support so this can be looked into more and can set up a screenshare with the agent so it can be looked into more properly for you and get it resolved for you. The number for support is 0808 234 5337 the line is open mon to fri 8am to 7pm and is free from any UK landline or mobile.

jane-abhamilton-
Level 1

How can I get Supplier balance detail reports to show running balances?

I did this yesterday - spent the best part of an hour online and was told the functionality was not available- is this correct

Ashleigh1
QuickBooks Team

How can I get Supplier balance detail reports to show running balances?

Hello Jane, I would suggest you reach out to support on chat or phone in so it can be looked into further for you. 

Gilbey
Level 3

How can I get Supplier balance detail reports to show running balances?

I've had the same problem and spoken to support.

 

There are two balance columns available. Open Balance and Balance.

 

Open Balance shows the open balance on an individual invoice or payment (if not allocated).

Balance appears to show the total of the individual open balances.

 

Like Jane I want to see the balance on an account at a particular date which is simply each invoice or payment added to the previous to give you a running balance disregarding whether the invoice paid or not, like in the desktop version.

Need to get in touch?

Contact us