Skip to main content
June 12, 2020
Solved

Customer / Supplier Account Balances

  • June 12, 2020
  • 2 replies
  • 0 views

I am having a lot of trouble reconciling customer and supplier account balances in Quickbooks with other systems that some of my clients use. As a for instance, one of my clients runs a nursery and issues invoices to parents every month. However, parents rarely pay the invoiced amount and will often pay whatever they can afford - in some instances, they will even over-pay at certain times of the year to build up credit they can use at other times of the year (so I have deferred income). The Quickbooks method of showing invoices and payments in a customer account is not very helpful in a situation like this because it is forcing my client to try and create matches between payments and invoices when really they don't exist - reconciling accounts then becomes an absolute nightmare because you cant actually see the payments received on the account screen (what you see is the matches created). Surely it would be easier if there was an option to essentially treat an account as a box in such a case into which invoices and payments are posted and a running total is maintained (perhaps is could be a particular account type or something) and the view on the screen would be like a bank statement (with debits, credits and balances showing all transcations in their entirety) - you can of course use customer statements to approximate something like that but it is a very unsatisfactory way of dealing with what ought to be a straightforward issue - I can't imagine I am the only one who has this hedache ??   

Best answer by emmam6

Hello Community Users! We appreciate that the customer / supplier account balances can be difficult to manage when balances are partially paid for example. We have customer statements which you can print or view as well as the customer balance summary/detail reports. Any other users who have found this difficulty please add your thoughts onto this thread. We'll continue to pass on feedback to our engineers, we do take your comments seriously.

2 replies

June 12, 2020

Hello @Barheys,

 

I want to let you know that your voice matters and I'm taking notes of the feedback you shared. Know that we always value our customers' opinions and consider them to help you manage your business the easiest way possible.

 

Our engineers are doing their best to improve our system so you and other customers can work well with it base on your needs. You can also check out our blog for the latest update: The QuickBooks Blog.

 

If you have more something to tell us, please tap our shoulder anytime. We always want to hear from you. I hope you're okay. Keep safe.

July 20, 2022

Hi

This post was made two years ago and QB were "looking into it".

I would concur with this user; why is there no simple way of showing a customer/supplier balance in QB. It's not even possible to create a running total/balance for a supplier to enable easy reconciliation between us and them! It used to be there many years ago!!

I have spoken with QB on this and it's always "thanks for your feedback, we'll look into it" Nothing ever seems to happen.

Liz

July 20, 2022

Hello Liz, thanks for posting on this thread, we take on board what you are saying and have passed them to the relevant team. 

emmam6Answer
August 12, 2022

Hello Community Users! We appreciate that the customer / supplier account balances can be difficult to manage when balances are partially paid for example. We have customer statements which you can print or view as well as the customer balance summary/detail reports. Any other users who have found this difficulty please add your thoughts onto this thread. We'll continue to pass on feedback to our engineers, we do take your comments seriously.

September 14, 2022

Yes, this makes absolutely no sense.

When on the supplier page there's a selection, of columns that can be displayed, but not a running balance!

I would think this is an absolute basic!

September 14, 2022

 Hello Lee, thanks for posting on this feedback on this thread, we will be sure to pass it onto your developers.