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

Show payments received from certain customer or for a specific job

I have not found a way to see all payments received by customer/job, or run a report to show this.  I use Quickbooks Desktop 2020, Contractor edition, and when I click on a customer or a customer:job in Customer center, there are no transactions listed, even though I have Deposits entered in checking account with Job Income associated with that customer:job.

Solved
Best answer March 14, 2023

Best Answers
DivinaMercy_N
Moderator

Show payments received from certain customer or for a specific job

It's nice to see you here in the Community, @solarken. I want to ensure you'll be able to see all payments or deposits assigned to a customer/job in QuickBooks Desktop (QBDT).

 

In QBDT, you can only see certain transactions on the Customer Information page. Such as estimates, sales orders, invoices, statement charges, sales receipts, payments, credit memos, and refunds. That said, deposit entries won't be displayed. Refer to the screenshot below:

 

 

To help you with this, you can run a transaction detail report and filter it by customers/jobs. This will let you view all the payments, deposits, and other transactions assigned to a specific name. Here's how:

 

  1. Go to the Reports menu and select the Custom Reports section.
  2. Then, choose Transaction Detail.
  3. Select the Customize Report button and set the correct date range. 
  4. Next, click the Filters tab. From the Choose filter section, type Name and select All customers/jobs.
  5. You can also add additional filters and columns based on the data you need.
  6. Once done, select OK

 

I also added this helpful guide that you can use to help you manage customer transactions in QBDT: Get started with customer transaction workflows in QuickBooks Desktop.

 

I'm just around the corner if you have any other concerns seeing all payments received by a customer/job in QuickBooks. Have a good one and stay safe. 

View solution in original post

6 Comments 6
Kurt_M
QuickBooks Team

Show payments received from certain customer or for a specific job

Hello, @solarken. I'll walk you through the process so you can review all the payments you've received from your customers in QuickBooks Desktop (QBDT).

 

You'll want to ensure that you applied the appropriate filters when viewing transactions that you've done with a specific customer. In QBDT, you can filter the date when the transaction happened or filter it by the type of transactions you've processed for that customer. I'll write down the steps below. To begin, here's how:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Customers menu.
  3. Select Customer Center.
  4. Choose the customer that you'd like to review the transactions.
  5. Below the Transactions tab, in the Show section, select All Transactions.
  6. In the Date section, choose All.

 

Also, another way to get around this is to run the Job Profitability Detail report. These are the steps:

 

  1. Access your QuickBooks Desktop company.
  2. Go to the Reports menu.
  3. Select Job Costing, and then click Job Profitability Detail.
  4. Filter the report to show transactions you've done for a specific customer.

 

Additionally, I've got you this handy article to help you modify your reports and add more details to it in QBDT: Customize reports in QuickBooks Desktop.

 

You can also check this page to help you keep your current report settings: Create, access and modify memorized reports.

 

Feel free to post here again if you need further assistance with this, @solarken. I'll make sure to get back to you as soon as possible. Stay safe, and have a nice day!

solarken
Level 3

Show payments received from certain customer or for a specific job

Thanks for the reply.

 

The 6 steps that you describe to use in Customer Center do not work. That is the reason for my original post. No payments/deposits are listed for any of my customers. When I record purchases for COGS for a specific customer:job, I select the customer:job to associate with the purchase. Likewise, when I receive a check from a customer, I enter a deposit, I select the customer: job to associate with the payment/deposit.  I don't understand why the transactions don't appear under each customer.

I now see there is a Receive Payments menu item under Customers, but I dont use that, I just click on Record Deposits from the home screen. When I hover mouse on the Record Deposits icon, an pop-up displays "Record the deposit of one or more customer payments to your bank account".

 

The job profitability detail does show the payments received from the customer for the job. So that works. But why can't I see them in Customer Center?

 

DivinaMercy_N
Moderator

Show payments received from certain customer or for a specific job

It's nice to see you here in the Community, @solarken. I want to ensure you'll be able to see all payments or deposits assigned to a customer/job in QuickBooks Desktop (QBDT).

 

In QBDT, you can only see certain transactions on the Customer Information page. Such as estimates, sales orders, invoices, statement charges, sales receipts, payments, credit memos, and refunds. That said, deposit entries won't be displayed. Refer to the screenshot below:

 

 

To help you with this, you can run a transaction detail report and filter it by customers/jobs. This will let you view all the payments, deposits, and other transactions assigned to a specific name. Here's how:

 

  1. Go to the Reports menu and select the Custom Reports section.
  2. Then, choose Transaction Detail.
  3. Select the Customize Report button and set the correct date range. 
  4. Next, click the Filters tab. From the Choose filter section, type Name and select All customers/jobs.
  5. You can also add additional filters and columns based on the data you need.
  6. Once done, select OK

 

I also added this helpful guide that you can use to help you manage customer transactions in QBDT: Get started with customer transaction workflows in QuickBooks Desktop.

 

I'm just around the corner if you have any other concerns seeing all payments received by a customer/job in QuickBooks. Have a good one and stay safe. 

khephnes
Level 1

Show payments received from certain customer or for a specific job

This does NOT work.   I just want to see the amount of the deposit.  Befor it is cut up into payments.   When you have a dispute with a tennant he wants to see EACH CHECK FROM THE TENANT AND THE AMOUNT IT WAS FOR.

Lets say the tennants rent is $1000 a month and he pays me $3000.  Now its 3 months later and I am having a dispute with him alls I can tell from quickbooks is that 3 $1000 invoices were paid.  Quick Books CAN'T DO IT.

  Quick books can't do a lot of simple tasks.  I could go on and on.  I tell people, when they have a problem with QB, Do a work around with some other software.

I have bank of America I put the tennants name in the comment field and then it will list them and I add them up manually

khephnes
Level 1

Show payments received from certain customer or for a specific job

Does not work for me either

Nicole_N
QuickBooks Team

Show payments received from certain customer or for a specific job

We take your feedback seriously and will do our best to address any issues you've encountered, @khephnes. Let me help you see the amount of the deposit in QuickBooks Desktop (QBDT).

 

We can run the Deposit detail report to see a list of all your recorded bank deposits and their amount. I'll guide you on how:
 

  1. Navigate to the Reports menu in the top bar of your company file and select Report Center.
  2. Go to the Banking section and look for the Deposit Detail report.


     
  3. Click the Run icon.
  4. Select the Customize Report button and set the date range.
     

For additional resources, you can go over this guide: Record and make bank deposits in QuickBooks Desktop. It includes instructions on how to consolidate multiple transactions into a single record, as well as how to manage your bank deposits and recurring entries.


Moreover, I'm adding these articles that discuss how to deposit payments into the Undeposited Funds account and handle your deposits and payments processed in QuickBooks Payments:

 

 

If you require further assistance finding the amounts of your deposits or completing specific tasks in QBDT, just leave your reply below and I'll get back to you as soon as possible.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us