Skip to main content
Jun 12, 2020 6:36 PM UTC
Solved

Customer / Supplier Account Balances

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 ??   

emmam6Answer
Aug 12, 2022 11:53 AM UTC

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.

17 replies

Jun 12, 2020 8:40 PM UTC

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.

Jul 20, 2022 1:17 PM UTC

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

Jul 20, 2022 3:52 PM UTC

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
Aug 12, 2022 11:53 AM UTC

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.

Sep 14, 2022 11:30 AM UTC

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!

Sep 14, 2022 2:20 PM UTC

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