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

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

Solved
Best answer August 12, 2022

Accepted Solutions
emmam6
Moderator

Customer / Supplier Account Balances

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.

View solution in original post

12 REPLIES 12
JonpriL
Moderator

Customer / Supplier Account Balances

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.

lizhoughton
Level 1

Customer / Supplier Account Balances

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

Ashleigh1
QuickBooks Team

Customer / Supplier Account Balances

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

emmam6
Moderator

Customer / Supplier Account Balances

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.

Lee Gold
Level 2

Customer / Supplier Account Balances

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!

Ashleigh1
QuickBooks Team

Customer / Supplier Account Balances

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

Arden7
Level 2

Customer / Supplier Account Balances

I have had similar issues but on the Supplier side. I am very angry with QBO/Intuit right now for making my life difficult by not incorporating they already had in desktop versions of QuickBooks.

 

Supplier running balance option needed urgently

We urgently need an option for a running balance column in our suppliers.

Currently we have to export to Excel and create a running balance column (see below).

We deal in multicurrency, home currency is £, We have over 300 supplies on many countries and exporting to excel each time is stupid! If a supplier calls us from USA and asks us, What was the balance on 30/Nov/2023, or 31/Oct/2023 in US$, we are unable to immediately reply to them. We have to export to excel, create a running balance column and only then can we answer their question. And when you do eventually make this column- the columns should be available in the foreign currency.

I believe on the Customer side you (Intuit) is having the same problem...and the solution offered was on the lines of you can see it on the statements!!!! 

 

Excuse me Intuit, we need to this this information live on the ledger!  

 

 

 

Supplier Name 
 TypeNo.ClassMemoBalanceTotalStatusrunning balance
15/12/2023BillFPL 00003 23  0.009,625.60paid-500.28
08/12/2023BillFV EX 00041 23  0.005,429.76paid-10,125.88
07/12/2023BillFPL 00002 23  0.008,693.64paid-15,555.64
05/12/2023Bill Payment (Cheque)bank z  -22,784.00-23,894.72unapplied-24,249.28
21/11/2023Bill Payment (Cheque)bank z  0.00-5,701.28applied-354.56
20/11/2023Billfpl 00001 23Biscuits 0.005,346.72paid5,346.72
20/11/2023Billfv ex 00039 23Biscuits 0.008,154.90paid0.00
06/11/2023Bill Payment (Cheque)bank z  0.00-8,138.74applied-8,154.90
20/10/2023BillFV EX 00033 23  0.0014,438.40paid-16.16
19/10/2023Bill Payment (Cheque)bank z  0.00-6,244.64applied-14,454.56
06/10/2023Bill Payment (Cheque)bank z  0.00-4,331.52applied-8,209.92
05/10/2023Bill Payment (Cheque)bank z  0.00-3,862.24applied-3,878.40
22/09/2023BillFV EX 28 23  0.001,535.20paid-16.16
22/09/2023BillFV EX 00029 23  0.006,128.80paid-1,551.36
18/09/2023Bill Payment (Cheque)bank z  0.00-7,680.16applied-7,680.16
Arden7
Level 2

Customer / Supplier Account Balances

It is fundamental and it is causing issues with many QB customers. Intuit please resolve this issue immediately.

thank you.

Arden7
Level 2

Customer / Supplier Account Balances

running balance in supplier accounts:

this post was is 2022, and the issue is not resolve! Can you escalate this matter. It seems Intuit are not listening to their customers.

 

Arden7
Level 2

Customer / Supplier Account Balances

in 2020 you said your "Our engineers are doing their best to improve our system so you and other customers can work well with it base on your needs". Clearly this is not the case since: (1) the running balances option is still not available in the supplier account, this may also be the case in customer accounts.

(2) A/P Summary foreign amounts- needs to be available immediately as well.

 

There are other many issues i have come across where QBO is failing, but lets get this improvement done step-by-step. However if its taking too long for QBO/Intuit to improve things(the basics, the fundamentals) then the question arises to choose another accounting software product from another supplier.

Kevin_C
QuickBooks Team

Customer / Supplier Account Balances

I hear your sentiments, Arden7. I recognize the convenience of having a way to easily determine the running balance of your suppliers and the foreign amounts of A/P summary reports in QuickBooks Online (QBO).

 

It would be nice to have the option to review the running balances of your suppliers' accounts, as it will help you monitor your business seamlessly. Rest assured that I'll relay this message to our team in concern here on my end and add your vote for this one.

 

You can also send your thoughts about this to our developers. Ideas like this help identify the features our customers want the most for consideration in future enhancements. Here's how:

 

  1. Go to the Gear icon at the top.
  2. Select Feedback.
  3. Enter your comments or product suggestions.
  4. Click Next to submit them.

 

Additionally, you can check out these resources that you can check out to learn more about memorising and personalising reports in QuickBooks Online for reference:

 

 

Drop me a comment below if you have any other questions besides running reports in QBO. I'll be happy to help you some more. Stay safe!

Barheys
Level 3

Customer / Supplier Account Balances

With respect, the issue was raised years ago and is still being complained about. I have previously done as you have suggested and nothing ever comes back - no response at all. Now I don’t see the point in complaining…….. 

 

the things being asked for as not exactly difficult or even unreasonable. Surely you can see more and more accountants use your software - what on earth can’t you make it look like what an accountant would expect to see - debit and credits etc ? 

Need to get in touch?

Contact us