cancel
Showing results for 
Search instead for 
Did you mean: 
cannonpointechir
Level 2

Transaction totals for the year

A customer of ours would like to know how much they paid us during the year. We would like a simple report of all the payments that were made to us from the customer with a total at the bottom. For the life of me I cannot find this anywhere. A couple of people tried to answer this in previous posts, but the directions did synch with Quickbooks Pro 2016.  Please help. 

Solved
Best answer December 27, 2018

Best Answers
FritzF
Moderator

Transaction totals for the year

Welcome back to the Community, @cannonpointechir.

 

I appreciate you checking other posts to look for a solution about this. I'm here to help walk you through pulling up a report that'll show the total payments your customer made this year on QuickBooks Desktop (QBDT) Pro 2016.

 

You can pull up the Sales by Customer Detail report and use the customize option to filter the date and the specific customer that is asking for the total payment. Here's how:

 

1. Go to the Reports menu at the top, then pick Sales on the drop-down.
2. Choose the Sales by Customer Detail to get the report.
3. Select the Customize Report on the upper left, then go to the Display tab.
4. Click the Dates drop-down, then choose This Fiscal year.
5. Now go to Filters tab, then enter Name on the Search bar.
6. On the Name drop-down, select the specific customer, then OK.

 

I also attached some sample screenshots below for your visual guide.

 

 

 

 

 

Once done, you can send this report to your customer by clicking the Email option at the top, then choose how you want to send it.

 

 

For future reference, you may check out this article for further guidance: Customize customer, job, and sales reports.

 

That should do it! Please let me know how it goes or if I can be of additional assistance. I'd be glad to answer if you have any follow-up concerns. Wishing you and your business continued success.

View solution in original post

3 Comments 3
FritzF
Moderator

Transaction totals for the year

Welcome back to the Community, @cannonpointechir.

 

I appreciate you checking other posts to look for a solution about this. I'm here to help walk you through pulling up a report that'll show the total payments your customer made this year on QuickBooks Desktop (QBDT) Pro 2016.

 

You can pull up the Sales by Customer Detail report and use the customize option to filter the date and the specific customer that is asking for the total payment. Here's how:

 

1. Go to the Reports menu at the top, then pick Sales on the drop-down.
2. Choose the Sales by Customer Detail to get the report.
3. Select the Customize Report on the upper left, then go to the Display tab.
4. Click the Dates drop-down, then choose This Fiscal year.
5. Now go to Filters tab, then enter Name on the Search bar.
6. On the Name drop-down, select the specific customer, then OK.

 

I also attached some sample screenshots below for your visual guide.

 

 

 

 

 

Once done, you can send this report to your customer by clicking the Email option at the top, then choose how you want to send it.

 

 

For future reference, you may check out this article for further guidance: Customize customer, job, and sales reports.

 

That should do it! Please let me know how it goes or if I can be of additional assistance. I'd be glad to answer if you have any follow-up concerns. Wishing you and your business continued success.

cannonpointechir
Level 2

Transaction totals for the year

This was absolutely fantastic.  I appreciate you helping me fix this problem. 

 

FritzF
Moderator

Transaction totals for the year

Thanks for getting back to me, @cannonpointechir.

 

I'm happy to know that I was able to help you get the report that you need for your customer.

 

Also, thanks for being a part of our QuickBooks family! Should you have any other concerns, don't hesitate to post again or leave a comment below. I'm always here to help you out. Take care and enjoy your weekend.

Need to get in touch?

Contact us