Question

Transaction list balance

Forum|Forum|7 years ago
January 16, 2019
2 replies
0 views

Customer transactions list has a total at the bottom, all invoices have been paid and any estimates created were closed/completed and invoices were created from those estimates. Why is there a total at the bottom that is the sum of the estimates (and in one case, a sales receipt)? It should be zero - everything is paid but it's like it is adding the original estimates up.

QuickBooks Online

M

MaryGraceS

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:

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

For additional reference, I've added some articles about 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:

Go to https://help.quickbooks.intuit.com/en_US/contact.
At the top right, select your QuickBooks version.
Select a topic.
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.

LynneOOAuthor

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!

M

MaryGraceS

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.