Transactions with no Customer:Job allocated

Thanks for checking in with us, FC Matt.

In QuickBooks Desktop, we can customize the report as to Job-status that gives you a way to keep track of each job. When creating a customer list report, QuickBooks includes the status of each job on the report. You can also see the status of a job by clicking a job in the Customers & Jobs list and looking at the Job Info tab. We can run a Customer:Job report and choose the status to None to see transactions that have not been allocated to a job. Just follow the steps below:

1. Go to Reports on the top menu.
2. Choose Company & Financial.
3. Select Profit & Loss by Job.
4. Click Customize Report tab.
5. Choose Customer:Job in the Display columns by section.
6. Tick Filters.
7. Enter Job Status in the Choose Filter field.
8. Select None in the Job Status field.
9. Enter Transaction Type in the Choose Filter field.
10. Choose the transaction in the Transaction Type field. 
11. Press OK and OK.

To learn more about customizing customer or job reports, see the Customize customer, job, and sales reports in the QuickBooks Desktop article. Feel free to visit our Reports page for more insights about creating and managing reports.

You can always update us on the result of this troubleshooting in the comment below. I'd like to ensure this is resolved for you. You have a good one.

Thank you RCV.

That didn't get me to where I want to go.  Your solution seemed to get me to jobs that have not had their Job Status updated.

I am trying to find the transactions (checks, bills, cc charges) that have been entered but were never assigned to a job.

Hello there, @FC Matt.

We can run the Transaction Detail report in QuickBooks Desktop (QBDT). Then, filter it to show the check, bill, and credit card charges.

Here's how:

1. Go to the Reports menu.
2. Hover over Custom Reports, and click Transaction Detail.
3. Select Customize Report.
4. Click the Filters tab.
5. On the search bar, type Billing Status.
6. Select OK.

Also, here are some articles that you can read to help speed up the reporting process in QuickBooks Desktop:

• Customize reports
• Create, access, and modify memorized reports

Feel free to visit here again if you have other questions. We're always here to help.

Hello,

Did you ever find this report or a work around?

Hi, Vashley.

I appreciate you for dropping by here in the Community. I'm here to share some information that'll help you view customer information and items that they purchased. Here's how:
 

1. Open your QuickBooks Company file.
2. Click Reports.
3. Choose Sales.
4. Select Sales by Customer Detail.

If none of these steps works, you can export the report to Excel to modify customer information and items.

In addition, I've included this article to learn more about customizing sales reports: Customize customer, job, and sales reports in QuickBooks Desktop.

Please know that I'm just a post away if you have more questions about running customer reports in QuickBooks. Take care.

This report is only showing expenses that are allocated to a job.  I'm looking for a report that shows expenses not allocated to a job.  I want to run a report at the end of the week and see transactions that do not show a job name.

If I run a P&L by class, I can see the unclassified.  I want to see something that will show be transactions not allocated to a job.  Every item or expense will have a job.

Hi there, @Busy B. 

The closest way to view transactions not allocated to a job is by creating a custom report. This report lists all your transactions within the specified date. Under the Name column, review the transactions not assigned to a job.

Here's how:

1. Go to the Reports menu.
2. Select Custom Reports and select Transaction Detail.
3. Modify the reporting date and click OK.

Check out this link for more info about tracking how much money you spend and make for each job: Track job costs.

Feel free to comment if you need more help with getting the information you need. I'm always here to help.

I'm trying to get a report that will show what hasn't been allocated to a customer. When I used the report that you described, I have to add source name to see if a customer's name was added.  How do I have the report only show the ones that aren't allocated to a job/customer? 

Thank you for coming back to the Community, Busy B.

I appreciate you for following the solution provided by my peer and sharing the result. Let me point you in the right direction about your concern.

Adding a built-in report that will automatically show transactions that are not allocated to a job is beneficial to a lot of users. This will help save time since they no longer have to customize it.

Thus, I recommend submitting this idea to our Product Development Team. Feedback like this will guide them on what specific feature to add or enhancements to include in future updates.

Here’s how:

1. In your company file, head to the Help menu at the top bar to choose Send Feedback Online and Product Suggestions.
2. In the QuickBooks Feedback window, click the Type of Feedback drop-down to select Product Suggestion.
3. This will open the QuickBooks Feedback window.
4. From there, tap the Product Area drop-down and choose Product Suggestion.
5. Click the Product Area drop-down and pick the correct area in QuickBooks you wish to improve.
6. Enter your thoughts and ideas in Here is my suggestion box.
7. Fill in the remaining fields.
8. Click Send Feedback.

In the meantime, I suggest following the alternative steps shared by my colleagues to build the report you need.

You can also browse this article to see how QuickBooks Desktop (QBDT) generates reports: Understand reports. From there, you’ll learn about the source and targets in each statement.

Additionally, configuring your reports preferences will help you tailor statements based on your personal style and business needs. Click here for more details about this feature.

Stay in touch if you have additional concerns about building reports in QuickBooks. I’ll be around to assist further. Have a good one.

I finally found a workaround, although it requires a bit of knowledge in excel if/then functions.  I created a find report of all of my transactions that had the accounts that I normally assign "customer:jobs" to, mostly my cost of goods sold jobs, 

1. I then customized it to show the name and source name - THIS IS IMPORTANT TO SELECT THESE TWO
2. I only included transaction types of bills, checks, credits, credit card charges, etc.
3. I then chose a date range
4. I chose to sort by name - A/Z
5. I filtered out the irrelevant columns, added the billing status column - to show if it had already been billed
6. I changed the header to Transactions with no Job Name
7. I memorized that bad boy
8. I exported my report to a new excel spreadsheet
9. I added a column to the left of the name column & formatted it to general formatting
10. Finally I created this if/then function:  =IF(G3=H3," ",G3)
    1. If a bill or any of the transaction types doesn't have a job name the vendor will show in both columns which is the g3=h3 portion of the formula
    2. but we want that to be blank so that the transaction type that don't have a job name will show up blank, which is the middle portion of the formula " "
    3. And finally if the name DOESN'T equal the source name, that means that that transaction type DOES have a customer job name.  
11. Then I named the column that I created the function in to "job name"
12. Sort the spreadsheet by the "job name" column 
13. all of your transactions that don't have a job name (the blank ones) - will be sorted at top - normally blanks sort at the bottom, but since this has a formula in it, it's technically not blank. 
14. Delete all the transaction rows that AREN'T blank, and there you go. 

I know this is cumbersome, but it works better than what Quickbooks came up with...which is nothing. 

Hi  I follow a version of this in QB desktop which makes the updating quicker as you are already on the errant transactions in QB. The full P&L Detail report is run for the period you are checking. Customise and add "source name" to the columns displayed. Invoices are obviously assigned to a Customer:Job so either ignore or filter them out or filter again and select "All ordinary expense accounts".  Review on screen and if the source name and name are the same in the report, then the cost has not been allocated to a job.  In the attached example two of the three transactions are affected. They have to be opened and in the most effective way you find you update the customer job.  

I was looking for the exact same thing,

on the next update, the same as when Class tracking is used

"Unclassified" "Unassigned Jobs" or whatever name should be added in a column automatically

just as it does for class tracking.

I was looking for the exact same thing,

on the next update, the same as when Class tracking is used

"Unclassified" "Unassigned Jobs" or whatever name should be added in a column automatically

just as it does for class tracking.

Hello, NEP. 

We understand that each business has unique needs, and each version of QuickBooks has unique features. 

We're always looking for suggestions and ideas from our users. So, I would recommend sending feedback to our developers about the option to add job name automatically in QBDT. 

You can follow my colleagues @Rasa-LilaM steps on how to send feedback in QBDT. 

In case you want to make your form templates more personalized and include only the data you need, you can easily customize them in QBDT. 

If you're still in need of assistance, please don't hesitate to post again here. I'm just a post away to help. Have a good one.

So your answer is a non-answer to submit a ticket to the next update for QBDT......wonderful...just what we've all been looking for @AileneA ......NOT.

Oddly, QB used to just add a default column that was labelled 'No Name' on the P&L by Job report.  Perhaps the Developers could actually ask someone if they were using a feature before they delete it.

My people make this 'No Job' mistake, as do I, so I think it is fairly common and needs a 'no brainer' solution.

Just add a line of code that says "If customer/job=nil, then go to column nil"

I may have found a report that is helpful to at least show items that are not allocated to jobs (expenses not allocated to jobs will show in the other reports mentioned elsewhere in this thread so you'll have to look at two separate reports each week to pick up expenses versus items), but try this:

Purchases by Product/Service Detail Report

Customize to add customer column

Hope this helps!

Try the report called "Purchases by Product/Service Detail Report" and customize to add a "customer" column.  This will at least show all 'items' that are not allocated to a job.  Expenses not allocated to a job can be seen in a basic P&L with the customer column added.  It means having to look at two different reports, so still annoying, but doable.