QuickBooks provides you with a powerful, and time saving tool within your items list, which is often under utilized and often misunderstood — the QuickBooks Group Item.
5 Reasons To Use QuickBooks Group Items:
- Creating and using Group Items is useful for quickly entering a group of individual items that you have already set up as single items in your Item List.
- Group Items are versatile – you can choose to print – or – not to print the items within the group, meaning you can track more detail than your customer needs to see.
- Group Items ensure that you don’t “leave something out” – which means lost dollars on your part.
- Group Items speed up the creation of Estimates and Invoices – imagine being able to pull in 19 items with a single click of a mouse.
- Group Items allow you to bridge the difference in units of measure used to buy and sell products or materials.
“Back in the day”, as my son-in-law would say, before QuickBooks had a Unit of Measure option – I think it was introduced with QuickBooks 2007 – we had to rely on QuickBooks group items to perform Unit of Measure calculations.
Using Group Items to bridge differences in units of measure used to buy and sell materials.
Suppose you are an Electrician and buy wire in spools of 1,000 feet, but when you invoice your customers you do so by the foot. By using group items we could effectively bridge this difference by following the steps below.
1. Verify that Inventory & Purchase Orders are active, by choosing Edit, Preferences, Purchases & Vendors, Company Preferences
2. Add a Sub-Account to your main Inventory Asset Account on your Chart of Accounts called Wire
3. Create an Inventory Part item for a foot of wire, called “Feet of Wire” and assign it to the “Wire” Account from your Chart of Accounts
4. Create a Group Item called “Spool of Wire”
5. Add the “Feet of Wire” Inventory Item with quantity of 1000
How we used these items once they were created:
When you buy the wire, use the “Spool of Wire” Group Item on your Purchase Orders, your checks, or bills and QuickBooks will add 1000 feet of wire to Inventory.
When you sell the wire, use the “Feet of Wire” Inventory Part Item on your Estimates, Sales Orders, or Invoices and QuickBooks will remove those amounts of wire from Inventory.
Would you believe that even though QuickBooks now comes with a Unit of Measure ability, there are still some people that prefer this method?
How many of you remember this method of creating a Unit of Measure using Group Items?
QuickBooks provides you with a powerful, and time saving tool within your items list, which is often under utilized and often misunderstood — the QuickBooks Group Item.
5 Reasons To Use QuickBooks Group Items:
- Creating and using Group Items is useful for quickly entering a group of individual items that you have already set up as single items in your Item List.
- Group Items are versatile – you can choose to print – or – not to print the items within the group, meaning you can track more detail than your customer needs to see.
- Group Items ensure that you don’t “leave something out” – which means lost dollars on your part.
- Group Items speed up the creation of Estimates and Invoices – imagine being able to pull in 19 items with a single click of a mouse.
- Group Items allow you to bridge the difference in units of measure used to buy and sell products or materials.
The following example deals with the CSI MasterFormat Cost Code section 03.20.00 for Concrete Reinforcing.
How to create a Group Item
In the QuickBooks Item list, you’ll want to have the individual items set up (03.21.00 through 03.24.00) as double-sided items.
Once these items are in place.
From the Item List, click the Item button at the bottom of the list window -> select New. From the New Item window choose Group from the Type drop down menu. In the Group Name/Number type in 02.20.00 Concrete Reinforcing, in the Item column select each of the individual components on the Concrete Reinforcing section. I’ve even added an Subtotal and Overhead & Profit item to the group. My group now contains a total of 10 line items.
IF you want your customer to see all 10 lines within the group, click into and place a check in the “Print items in group” option. IF you do not want your customer to see all 10 line items, leave this option unchecked and they will see ONLY 03.20.00 Concrete Reinforcing, while YOU still see all the detail.
How to Use the Group Item After It’s Created
Open an Estimate or Invoice form, click into the Item Column, find the Group Item and enter you cost amounts (enter costs ONLY if you are using an Overhead & Profit item within the group). As you enter the cost associated with each line item, QuickBooks calculates and updates the subtotal, overhead & profit (if the item is setup as a percentage), sales tax (if applicable), and Estimate total.
When you use the Item list for job costing (on vendor bills, checks, etc.) you would still job cost against the individual items in the item list.
Tomorrow, in Part 2, find out how to use Group Items to bridge differences in units of measure.
Beginning on Tuesday evening, June 15, 2010, many Intuit websites and services became unavailable due to a power outage at their data center. Even though you may be using the Desktop version of QuickBooks, this could have had a major impact on your ability to conduct business. Charlie Russell, from the Practical QuickBooks blog wrote a very interesting piece yesterday that he is continuing to update, if you would like more information.
Even though I use the desktop version, when I went to do payroll VERY early yesterday, before I knew about all of this, I did a payroll update and tried to process payroll but no taxes were withheld. Once I realized what was going on with Intuit servers I knew what the problem was – I couldn’t connect to the servers, therefore I couldn’t obtain updates or validate my subscription and therefore QuickBooks thought I no longer had a payroll subscription.
Not a biggie for me as payday is Friday and I was just trying to get one step ahead…..others were not so lucky. There are a lot of really angry people on the Intuit Community forums
Everything is fine today, just had to go online and validate my payroll subscription before doing payroll this morning.
All in all, not a very good past couple of days for Intuit or the people who rely on web-based offerings by Intuit such as credit card processing, payroll or those who use the QuickBooks online edition to run their business.
A very pertinent question for ALL of us – do we each have a backup plan if we face a power outage or some other event that is beyond our control?
The June 2010 edition of the QuickBooks for Contractors Newsletter, published on a quarterly basis by Sunburst Software Solutions, Inc. is now available.
This quarters newsletter is all about job costing equipment in QuickBooks:
- Determining Equipment Costs per Hour – explains how equipment costs-per-hour is determined by adding together three (3) distinct pieces of information.
- Equipment Cost Calculator – an Excel spreadsheet designed to calculate the ACTUAL hour rate it costs you to have a specific piece of equipment on the jobsite. The spreadsheet has formulas, based on the calculations in the article above.
- QuickBooks Tips & Techniques – Advanced Job Costing – Getting Equipment Costs into Job Costing Reports – a FREE 17-page eBook which guides you step-by-step in getting your equipment costs into your job costing reports.
Get the current issue by clicking here.
