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

Reports with customer job missing

I am looking to run a report to find transactions that might be lost because for one reason or another the customer job field was left blank.  I know I can run reports with any name, but is there a work around or way I can run a report for any/all transactions with no customer job/name so I can find and fix the error?

 

Thank you,

Damien

11 Comments 11
Rea_M
Moderator

Reports with customer job missing

I'll make sure you can pull up the report you need in QuickBooks Desktop (QBDT), @Damien1. This way, you can manage your transactions accordingly.

 

Based on your description of the issue above, you can pull up a QuickReport for the specific bank or account that holds your transactions. Then filter it so you can easily find and fix any/all transactions with no customer job/name. To do this, here's how:

 

  1. Go to the Lists menu.
  2. Select Chart of Accounts.
  3. Find and click to highlight the account. Then, right-click and select the QuickReport: [Account name] option.  82.jpg
  4. On the report page, select the Customize Report button.
  5. Go to the Filter tab.
  6. Search Name, then choose the All other names option. 83.jpg
  7. Click OK.

 

Also, QBDT provides different reports that cater to your business needs. It displays them based on a set of instructions that's extracted from the data file and shown as a set of transaction lines. To learn more how QuickBooks generates reports, I'd recommend checking out this article: Understand reports.

 

Let me know if you have other reporting concerns and questions about managing transactions in QBDT. Please don't hesitate to drop a comment below, and I'll gladly help. Take care, and I wish you continued success, @Damien1.

Damien1
Level 2

Reports with customer job missing

Thank you so much.  

Ok, I did a test and in some accounts it works well, but in others it doesn't.  I tested it in Dues & Subscriptions expense account because I knew there were a dozen or so transactions that fit the bill.  I ran it several times and every time it brought up 1 transaction but not the others.  I am looking for why 1 but not the others were pulled.

Rea_M
Moderator

Reports with customer job missing

I appreciate your immediate response and update, @Damien1. Let me share further details about this.

 

With the QuickReport pulled up, you'll have to make sure you've filtered the appropriate Dates (From and To). Then, check the account's (Dues & Subscriptions) total amount or Balance for that specific transaction. This way, you're able to verify if that's the only one that doesn't have or with no customer job/name or there are still others. Please see the screenshot below for your reference.

 

 

Also, you can set your reports' preferences in QBDT. Doing so will let you customize them to fit your personal style and business needs. To know more about this, I'd recommend checking out this article: Set report preferences.

 

Please know that I'm always around to help if you need further assistance in managing your transactions in QBDT. Take care, and stay safe, @Damien1.

Damien1
Level 2

Reports with customer job missing

Thanks for responding, the first thing I checked were the dates, and that is not the problem.  I also checked what other difference there are between them all and cannot find one yet.  I have had odd glitches with QB before with items not showing up in reports and if I delete them and re-enter them they appear with absolutely nothing different.

MarsStephanieL
QuickBooks Team

Reports with customer job missing

Hello @Damien1.

 

Thank you for following the instructions given by my colleague and sharing an update. 

 

I see that you're not able to see the transaction that you've wanted and you've mentioned the glitches you've encountered before. With this, I'd recommend updating your QuickBooks Desktop App to the latest release. This is done to check if there are data issues or an update that might be affecting the program.

 

Here's how:

 

  1. Open QuickBooks Desktop and go to the Help menu.
  2. Click Update QuickBooks Desktop.
  3. Go to the Update Now tab. Tip: You can select the Reset Update checkbox to clear all previous update downloads.
  4. Select Get Updates to start the download.
  5. Once done, accept the option to install the new release.

To give you more insight and a visual guide on how to update QuickBooks Desktop, please check out this article: Update QuickBooks Desktop to the latest release.

 

If this doesn't work, let's try downloading the QuickBooks Tool Hub. This tool is designed to automatically diagnose and fix common issues within the software.

 

Below are the instructions on how to do it:

  1. Close the QuickBooks program.
  2. Download the most recent version (1.4.0.0) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it.
  3. Open the file you downloaded (QuickBooksToolHub.exe).
  4. Follow the on-screen steps to install and agree to the terms and conditions.
  5. When the installation finishes, double-click the icon on your Windows desktop to open the tool hub.
  6. Once the  QuickBooks Tool Hub is open, select Program Problems.
  7. Select Quick Fix my Program.
  8. Start QuickBooks Desktop and open your data file.

 

Be sure to check back in with me here and let me know how this goes. I'm always around to help you in any way I can. Have a good one. 

Damien1
Level 2

Reports with customer job missing

Thanks for the response.  I cleared the updates and updated now and still have the same results.  Before I spend time with the tool hub I want to make sure we are talking about finding the same thing. I am testing an account with known issues as a test.  I am using the dues and subscriptions expense account and trying to find where it is blank under the customer job drop down.  I have brought up the account quick report for that expense account during the correct time period and under filters selected names and then all other names.  It provides 1 correct expense but not the others fitting the same parameters.

You feel the tool hub will help me solve this issue?

JoesemM
Moderator

Reports with customer job missing

Thanks for getting back to us and asking a clarifying question about the solution shared by my colleague, @Damien1

 

Performing the QuickBooks Tool Hub can fix odd behavior in QuickBooks like company issues, PDF and printing errors, etc. For now, you can perform the Verify Rebuild Tool since the report is missing a customer job. 

 

The Verify will detect any damaged data while a rebuild will attempt to fix the damaged data detected. It also allows your QuickBooks software to refresh the data inside the company file.

 

Here's how:

 

  1. In QuickBooks Desktop go to the Window tab and select Close All to close all opened windows.
  2. Then, go to the File menu and choose Utilities
  3. Click Verify Data.  
  4. Fix any error message if it says "Your data has lost integrity", continue to Rebuild Data.
  5. Navigate to the File menu, pick Utilities, then click Rebuild Data
  6. Confirm to back up your company file. 
  7. Choose where you want to save your backup, then tap OK.
  8. Wait until the backup is finished so the Rebuild Data utility tool starts. 
  9. Hit OK if Rebuild has been completed

 

For more details about the process, please see this article: Verify and Rebuild Data in QuickBooks Desktop.

 

I also suggest running the Transaction List by Accounts or Profit and Loss reports. Just filter and click the account together with the amount. To learn more about running and customizing reports in QBDT, you may check this article: Customize reports in QuickBooks Desktop.

 

Also, may I ask how did you create the transaction and what specific report did you pull up, or it's just the Quick report? Any additional details can help us narrow things down.

 

I've collected these articles that will guide you with your future tasks like exporting and memorizing your reports:

 

 

I'll be right here to continue helping if you have any other concerns or questions about managing reports, Damien1. Have a good one.

Damien1
Level 2

Reports with customer job missing

I verified the data and it found no problems.  I rebuilt the data anyway and it found and fixed 1 error with a specific transaction which was not related.  I tried the reports again, and no change still not pulling the transactions needed.

Adrian_A
Moderator

Reports with customer job missing

I appreciate your time and effort in trying the steps shared by my colleague, Damien.

 

Since you're still unable to pull up the report you needed, I'd recommend contacting our Customer Support team. Our agents there have the tools that can isolate the issue further.

 

You can get in touch with them by clicking the Help menu. Then, select QuickBooks Desktop Help.

 

Once you're able to pull up the report and you want to modify it, you can check these references:

 

 

Keep me in touch if you have other concerns. I'll get back to you the soonest. Keep safe, Damien.

Damien1
Level 2

Reports with customer job missing

Thanks, but I have tried to call in and the few people I spoke with gave me another number to call so I don't feel they understand it either.

DivinaMercy_N
Moderator

Reports with customer job missing

I got you covered, @Damien1.

 

You can also contact our phone support team outside your QuickBooks Desktop (QBDT) program. I'll show you how:

  1. Go to the Contact us link.
  2. Select QuickBooks Desktop and then, click Continue.
  3. Choose your QBDT edition and enter a brief description of your concern.
  4. Then, select Continue.
  5. Choose either Chat or Callback.

 

To ensure you'll be assisted immediately, you can visit our support hour's page.

 

In case you need helpful articles to guide you in performing QuickBooks tasks, feel free to visit our Help articles page. From there, you can easily search for topics you need. You can also bookmark the articles for easy access in the future.

 

Post here again in the Community if you have any other QuickBooks-related concerns. I'll be always around to assist you. Have a good one. 

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

Need to get in touch?

Contact us