Transaction list balance

Hi there, @LynneOO.

Thank you for joining the Community. I'd be happy to help share some information about the Transaction List by Customer report.

The total amount on the Transaction List by Customer report is not based on the transaction's status. It groups the transactions by customer name, and show all activity or transactions related to each customer.

If you wish to see a list of all your transactions, without the total, you can run the Transaction List by Date report.

Here's how:

1. From the left pane, select Reports.
2. Search and select Transaction List by Date.
3. Choose the transaction date range.
4. Click Run report.

For additional reference, I've added some articles about reports: 

• How to customize reports 
• How to memorize reports 

If you need to reach out for more help, feel free to call our phone support. They have the tools that can help you further.

Here's how:

1. Go to https://help.quickbooks.intuit.com/en_US/contact.
2. At the top right, select your QuickBooks version.
3. Select a topic.
4. Click on the Get Phone Number or Start a Message button.

That should do it. 

Drop me a comment below if you have any other questions about the Transaction List by Customer report. I'll be happy to help you out. 

Hi @MaryGraceS

I thought I replied to this the other day, but I don't see my response so I will try again.  It isn't in the transaction list report that I am seeing this, it is in the Customer Center.  When the customer is selected there is a list of all the transactions with a balance (total) at the bottom.  That balance is incorrect, as it appears to be including Estimates that were turned into Invoices and closed.  My client asked why those customers have a balance showing, so I was trying to find out why.

Thank you!

Hello there, @LynneOO.

Thank you for getting back with me and for providing more details about the transaction list in the customer center.

Yes, you're right. When you create an invoice for an estimate, the amount shows on the BALANCE column. When you create a payment on that invoice, it clear that amount on the total balance. 

Additionally, QuickBooks Online automatically shows the current total customer balance at the top right of the Transaction List. I've attached some screenshots for reference.

That should take care of it. 

I'm just a post away if you have any other questions about the total balance in the customer center. I'll be happy to help you further. 

Thank you @MaryGraceS.  The interesting thing is - if you look at the screen shot that I attached to the first post you can see that all of the estimates are closed and all of the invoices are paid.  There should be no balance at the bottom, but yet there is and it equals the amount of the closed estimates.  

Greetings, LynneOO.

It's good to see you again here in the Community. I'd like to add to my colleague's MaryGraceS answer and provide additional information regarding the Total.

You're correct when you said that the Total column adds the amounts of estimates and invoices even if they're closed or paid. However, I assure you that it is working as designed since it's only meant to summarize the total of your transactions regardless of their status.

On the other hand, I recommend that we focus more on the Balance instead of the Total. The reason why is because it's the one designed to keep track of the remaining balance of your transactions.

That said, I reviewed the screenshot you provided, and I'm happy to tell you that everything is working perfectly fine on your end. It's showing zero balance, as it should since your estimates and invoices are already Closed and Paid.

Keep in touch if you have additional questions about this, or if there's anything else I can do for you. I always have your back. Thanks for reaching out, wishing you all the best.

@AldrinS  Hello Again!  While I understand what you are saying, I would submit that the design doesn't make any sense.  Why would you want to see a "Total" that essentially includes duplicate amounts?  There is no value to totaling these all up when you are double counting an estimate (or a sales receipt) that became an invoice (or was applied to one).  What purpose does this total column serve but to alarm or confuse the user?

Thank you,

Lynne

Hi there, LynneOO.

You can send your feedback about Total columns directly to our engineers so they can take a look at it. I will also pass them what you've shared here in the QuickBooks Community. Just go to the Gear icon and click Feedback. 

Visit us again if you have other questions. 

Has this BUG been fixed yet? I can not fathom how a software program that is literally meant to do accounting cannot give you a correct balance - not only is the "total" given under the customer center a total of ALL TRANSACTIONS ADDED TOGETHER (what??) it's also the same for Transaction List report - my client doesn't owe us $23,000.00 that is the TOTAL AMOUNT OF PAYMENTS, INVOICES and ESTIMATES. This blows my mind every time I have to deal with this. And it honestly should not fall on the CUSTOMERS to get this fixed by emailing some nebulous "Tech Support". We pay thousands of dollars for a software program that forces me to manually add things up WITH A CALCULATOR! It's embarrassing. 

Thanks for joining the thread, @gennieosg. 

I can see how frustrating it is to sign up for a service that doesn't work as you think it should. Let me share further insights on how QuickBooks calculates totals in the Customers' window and Transaction List report. 

The TOTALS column in the Customers window will show the total of your open invoices and estimates. Once an invoice is paid (offset by payments), it will automatically be removed from the totals leaving the estimates. Since estimates are non-posting transactions and can't be offset, their amount remains in the TOTALS column.

When it comes to the Transaction List by Customer report, this will sum up all your posting and non-posting transactions, including invoice payments. You can filter it to show specific accounts or customers, or format the layout. 

You can also send feedback to our product developers. That way, they can review your suggestions and help us improve your experience in QuickBooks. Here's how:

1. Select the Gear icon at the top, then click Feedback.
2. Enter your comments or product suggestions and select Next to submit feedback.

You can track feature requests through the QuickBooks Online Feature Requests website.

You can also visit our Community Help website which shares helpful articles to read on topics like account management, banking, reports, and more. Just select a subject from the Topics drop-down menu.

Please feel free to reach back out if you have any other questions on how QuickBooks calculates totals. Assistance is only a comment or posts away.

Good day 

I am trying to create a Transaction List with balance on the far right.. Columns wanted are 

Date

Transaction Type

No.

Amount 

Balance 

Unfortunately i cannot find the balance option.