Items vs Expense for Job Costing

I’ve been discussing how to setup and use Items in QuickBooks.   What I’ve seen is many really don’t understand how Items work in QuickBooks, from bookkeepers to accountants to QuickBooks consultants. I will admit that for many years, I was guilty of this, too – but I thought I understood them (just as many others do)!

Items let you see detail in your business instead of having to put all the detail in your Chart of Accounts (which is often what I see).  On an Invoice, you have no choice but to use an Item.  However, that’s not the case for a bill (or check or credit card charge).  You have a choice of using either the Expense tab or the Items tab. Most people use the Expense tab and select an expense or Cost of Goods account (like Job Materials).  But for contractors who want to job cost in QuickBooks, I recommend using the Items tab.

6:9 Pic 1

While the Expense or Cost of Goods account may be the correct account for that expense, several of your reports will be incomplete.  How often have you run a Job Profitability report and then needed to double-click on “No Item” to get your detail?  So you end up running/printing 2 reports instead of one.  In the above example, that expense will be a part of that “No Item” number on a Job Profitability Detail report.  “No Item” simply means you did not use an Item when you entered the expense. (The numbers get even more confusing if you did not have an expense or Cost of Goods associated with the Item, as shown in our article on Item Setup).

6:9 Pic 2

So when do you use which tab?   A good rule of thumb is to use the Items tab when it’s for a customer job/project and the Expense tab for Overhead. When you use the Items tab, you can then select the appropriate Item from your Items List.

6:9 Pic 3

So here’s that same expense only now as an Item and notice the change in the report. Also note how much easier it is to review your labor and materials detail here instead of having to look in two places.

6:9 Pic 4

So for those of you who work with projects or jobs, take a look at your Job Profitability Detail Report or your Estimated vs Actual Detail and see if you have many “No item”.  That “little” change can make a big difference in your reporting.

Once you start using this new system, your reports will start to be more meaningful and take less time to create, and use less paper!

Contact our office if you have questions or need any assistance.

This entry was posted in Job Costing, QuickBooks, Reports and tagged , , , , , , , , . Bookmark the permalink.

4 Responses to Items vs Expense for Job Costing

  1. Adam Scheffler says:

    hello. i use a 3rd party company for payroll and i make a general journal entry for job costing the gross labor per job. The gross labor is listed as “no item” in my job prof reports because the journal entry doesn’t work with items. Its not the worst problem in the world because the only thing in “no item” is the gross labor. however, i would love it if there was a way to have the gross labor listed in the report as an item. is that possible??

  2. Catie Ziessler says:

    If I input all of my Bills as an item rather than an expense, will they still show up in our P&L Report?

  3. Yes. When you set up an item, you specify where on the chart of accounts you want it to post

  4. There are a couple ways to get the labor to show – use a work around for job costing or bring payroll in-house (either with Intuit’s Enhanced Payroll or Assisted Payroll) and I can get you discounts on both products.

Leave a Reply

Your email address will not be published. Required fields are marked *