Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Solved! Go to Solution.
Invoices and Received Payments Report—this is supposed to be a great report but unfortunately, someone designed this report very poorly and not a useful financial tool at this time.
If you're looking total received payment, I would use the left Sales panel and select All Sales and here you can filter it by money received or recently paid or paid invoices. All will give you the total. (But the negative number, why?)
I've replicated your concern on my sample company file, SDM2. We're unable to get a report that will show the total payments for a specific period.
You can only get the total payments per customer when pulling up the Transaction List by Customer report. Here's how:
It's a good idea to have a report that'll show total customer payments. I'll share your concern to our management team. They'll submit this to our software developers. This will be assessed and may be included in future program updates.
If you have additional questions, don't hesitate to keep in touch. Just click the Reply button and we'll get back to you as soon as we can.
Invoices and Received Payments Report—this is supposed to be a great report but unfortunately, someone designed this report very poorly and not a useful financial tool at this time.
If you're looking total received payment, I would use the left Sales panel and select All Sales and here you can filter it by money received or recently paid or paid invoices. All will give you the total. (But the negative number, why?)
Does this work for Desktop version of Quickbooks?
I follwed your directions using a desktop QB. I get the report, but it does not include the tallies that your example shows. So, it breaks down by customer and payments, but still does not do the addition to provide the total, as shown in your gray bars. Thanks.
Look no further, @Lolouila. I have all the steps you'll need.
The best way to get your desired report achievable in QuickBooks Desktop is by running the Customer Balance Detail report. It can be customized to show the received payments only and its balance. I'd be glad to show you how.
That will give you all the received payments, as well as the Total for each customer.
Check out this article to understand different reports available in QuickBooks Desktop that cater to your business needs: Understand reports.
You can also export them to Excel to help give you the flexibility to use them. Simply click the Export button and select Create New Worksheet.
Should you need further assistance, drop a comment below. I'm always here ready to help. Have a great day.
I think I figured it out... with Quickbooks Online, I went to REPORTS, in Find Reports I chose "Transaction List by Customer".. then clicked on Customize, then Group By - Transaction Type (instead of by customer), then Filter Transaction Type to Payment.. then RUN REPORT..
and yes I do accept cash or gifts if you feel obligated..
4 years later and simple but essential figure requires multiple contortions to obtain? Really? I'm a new user and I'm still on the learning curve but totaling that column is the definition of "no-brainer". -Tom C
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here