Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 25, 2021
Question

Transactions with no Customer:Job allocated

  • February 25, 2021
  • 18 replies
  • 118 views

Hi,

 

Quickbooks Pro 2021

 

I've recently changed office people and as I was going through the Jobs reports I noticed that there were some checks and credit card charges that never got allocated to their specific job.  Specifically I'm talking about the ITEMS not the EXPENSES. It seems there's quite a few of ITEM transactions not allocated to any job.  

 

My question is:  Is there a way to run a report that will show me which transactions have not been allocated to a job?  

 

I have run the P&L > Show Columns > Customer:Job >No Name and that isn't what I'm looking for.  That seems to get me transactions that don't have a name in the "purchased from" cell of a transaction.

 

Thank you in advance.

18 replies

QuickBooks Team
February 26, 2021

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.

FC MattAuthor
February 26, 2021

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.

 

QuickBooks Team
February 26, 2021

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:

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

March 4, 2022

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. 

June 2, 2022

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.  

November 21, 2022

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.

Moderator
November 22, 2022

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.

November 30, 2022

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.

January 6, 2023

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!