cancel
Showing results for 
Search instead for 
Did you mean: 
SDM2
Level 3

Is there a way to get a total for Received Payments for a time period?

The Invoices and Received Payments do not give a total at the bottom, I always have to do that manually, is there a way to get this total in the report itself?
Solved
Best answer February 19, 2020

Best Answers
vpcontroller
Level 11

Is there a way to get a total for Received Payments for a time period?

@SDM2 

@Kristine Mae 

 

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

 

Recently paid and money received.PNGmoney received.PNG

 

 

View solution in original post

7 Comments 7
Kristine Mae
Moderator

Is there a way to get a total for Received Payments for a time period?

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:

  1. Click Reports.
  2. Enter Transaction List by Customer in the Find report by name field.
  3. Click Customize, then go to Filter.
  4. Click the Transaction Type drop-down arrow, then select Payment.
  5. Click Run report.

 

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. 

vpcontroller
Level 11

Is there a way to get a total for Received Payments for a time period?

@SDM2 

@Kristine Mae 

 

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

 

Recently paid and money received.PNGmoney received.PNG

 

 

91766
Level 1

Is there a way to get a total for Received Payments for a time period?

Does this work for Desktop version of Quickbooks? 

Lolouila
Level 1

Is there a way to get a total for Received Payments for a time period?

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.

LieraMarie_A
QuickBooks Team

Is there a way to get a total for Received Payments for a time period?

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.

 

  1. Go to the Reports menu.
  2. Choose Customers and Receivables and select Customer Balance Detail.
  3. Click the Customize Report button.
  4. Modify the reporting date.
  5. Select the Filters tab.
  6. In the Search Filters field, look for "Transaction Type."
  7. From the Transaction Type drop-down list, select Payments.
    Capture.PNG
  8. You can also change the report title from the Header/Footer tab.
  9. When you're ready, click OK.

 

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.

Steve Select
Level 1

Is there a way to get a total for Received Payments for a time period?

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

Tom Az
Level 1

Is there a way to get a total for Received Payments for a time period?

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

Need to get in touch?

Contact us