Customer / Supplier Account Balances

Barheys · ‎June 12, 2020

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

emmam6 · ‎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.

View solution in original post

JonpriL · ‎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.

lizhoughton · ‎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

Ashleigh1 · ‎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.

emmam6 · ‎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.

Lee Gold · ‎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!

Ashleigh1 · ‎September 14, 2022

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

Arden7 · ‎February 04, 2024

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
	Type	No.	Class	Memo	Balance	Total	Status	running balance
15/12/2023	Bill	FPL 00003 23			0.00	9,625.60	paid	-500.28
08/12/2023	Bill	FV EX 00041 23			0.00	5,429.76	paid	-10,125.88
07/12/2023	Bill	FPL 00002 23			0.00	8,693.64	paid	-15,555.64
05/12/2023	Bill Payment (Cheque)	bank z			-22,784.00	-23,894.72	unapplied	-24,249.28
21/11/2023	Bill Payment (Cheque)	bank z			0.00	-5,701.28	applied	-354.56
20/11/2023	Bill	fpl 00001 23	Biscuits		0.00	5,346.72	paid	5,346.72
20/11/2023	Bill	fv ex 00039 23	Biscuits		0.00	8,154.90	paid	0.00
06/11/2023	Bill Payment (Cheque)	bank z			0.00	-8,138.74	applied	-8,154.90
20/10/2023	Bill	FV EX 00033 23			0.00	14,438.40	paid	-16.16
19/10/2023	Bill Payment (Cheque)	bank z			0.00	-6,244.64	applied	-14,454.56
06/10/2023	Bill Payment (Cheque)	bank z			0.00	-4,331.52	applied	-8,209.92
05/10/2023	Bill Payment (Cheque)	bank z			0.00	-3,862.24	applied	-3,878.40
22/09/2023	Bill	FV EX 28 23			0.00	1,535.20	paid	-16.16
22/09/2023	Bill	FV EX 00029 23			0.00	6,128.80	paid	-1,551.36
18/09/2023	Bill Payment (Cheque)	bank z			0.00	-7,680.16	applied	-7,680.16

Arden7 · ‎February 04, 2024

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

thank you.

Arden7 · ‎February 04, 2024

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 · ‎February 04, 2024

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 · ‎February 04, 2024

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:

Go to the Gear icon at the top.
Select Feedback.
Enter your comments or product suggestions.
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 · ‎February 04, 2024

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 ?

Arden7

Unfortunately your "engineers" are too slow to to make improvements your own clients are requesting.

I also have a part-payment issue and in addition i have a

Question: Supplier account - is there any way to see a cumulative balance column?

I can get a balance on an invoice....but i really need a cumulative balance column...

Arden7

Are there any developments //

Unfortunately your "engineers" are too slow to to make improvements your own clients are requesting.

I also have a part-payment issue and in addition i have a

Question: Supplier account - is there any way to see a cumulative balance column?

I can get a balance on an invoice....but i really need a cumulative balance column...

GeorgiaC

Hi Arden, thanks for adding to this thread. We don't have any further developments to share on this at the moment; unfortunately, not all feedback is able to be implemented as it is based on factors such as feasibility and demand.

There is no way to add a column for the cumulative balance on the Supplier account. To view this data, you would need to run a report such as the Supplier Balance Detail report.

Thanks for reaching Intuit support. I'm just a post away if you have further questions or require additional assistance.

Arden7

Georgia, this is very dissapointing.

Unfortunately the Supplier Balance Detail report.also does not give the the cumulative of anything in foreign currency.

So the only way is to export the supplier to excel and then do additional work to get what is needed. QBO falls short of the minimum standard here.

QBO is extremely weak on this topic. Are you aware of any 3rd party apps that could bridge QBO's short-comings in the purchase ledger?

GeorgiaC

Hi Arden, thanks for your feedback. Reports in QBO always run of the home currency and there no way to make them run in a foreign currency.

We don't have specific recommendations for 3rd party app, but you can check the full range of available apps on our app store. We'll be here if you need any further support.

Topics

Training

Community

Resources

Customer / Supplier Account Balances