FORUM
ARTICLES
BLOGS
PROJECTS
PRODUCT REVIEWS
REWARDS
COMMUNITY NEW POSTS
Home » Forum » Business Discussion » Business » Quickbooks Item Numbers
Quickbooks Item Numbers
Thread Tools
Search this Thread
Display Modes
09-05-2009, 01:09 PM
#1
JGMConstruction
Quickbooks Item Numbers
New Guy
Just curious as to what those of you who use Quickbooks do for item numbers. Mostly I am looking for ideas for those of you who are GC's and do a little of everything. I'm trying to streamline my QB database and make it better/easier to find items when estimating.
Trade: General Contractor Join Date: Jul 2008 Location: Centerville, OH Posts: 26 Rewards Points: 25
Thanks. __________________ John John 14:6
Warning: The topics covered on this site include activities in which there exists the potential for serious injury or death. ContractorTalk.com DOES NOT guarantee the accuracy or completeness of any information contained on this site. Always use proper safety precaution and reference reliable outside sources before attempting any construction or remodeling task!
Advertisement
Advertisement
09-06-2009, 02:05 PM
#2
AustinDB
Re: Quickbooks Item Numbers
Contractor
I use QB for invoicing/payroll and general bookkeeping but when it comes to proposals and contracts the writeup is a word document template which is very thorough. I rarely use the QB for the customer's invoice since the contract has the info-it works for my situation but would like to hear from others who utilize it more than I.
Advertisement Trade: Remodeling & Home Additions Join Date: Sep 2006 Location: Austin, TX Posts: 4,054 Rewards Points: 556
09-06-2009, 08:05 PM
#3
rwa
Re: Quickbooks Item Numbers
Pro
I'd suggest numbers which correspond with CSI divisions. At the very least use sets with sub sets. Sets for categories, sub sets for items, ie 03-1111 whereas 03 would refer to concrete and 1111 would refer to a specific item pertaining to concrete.
Trade: Construction Manager Join Date: May 2009 Location: Frisco, Texas Posts: 523 Rewards Points: 348
Advertisement 09-07-2009, 03:04 AM
#4
CScalf
Re: Quickbooks Item Numbers
Official CT Greeter!
Roofing = Roof Siding = Sdng
and so on...abbreviations usually work good for me.... __________________ Trade: General Construction Join Date: Dec 2008 Location: Athens, AL Posts: 1,270 Rewards Points: 500
"Your problem does not constitute an emergency on my part" I do it for the love of God, Country, The Corps, Apple Pie, & Poontang!
09-07-2009, 08:18 AM
#5 Re: Quickbooks Item Numbers
bert0168 Money Changer
Quote:
Originally Posted by 72chevy4x4 I use QB for invoicing/payroll and general bookkeeping but when it comes to proposals and contracts the writeup is a word document template which is very thorough. I rarely use the QB for the customer's invoice since the contract has the info-it works for my situation but would like to hear from others who utilize it more than I. Trade: Residential Remodeling Join Date: Jan 2008 Location: Bucks County, PA Posts: 804 Rewards Points: 500
Pretty much what I do as well except I use an Excel spreadsheet for estimating and an MS Access for contracts (found it here and modified it for me ) On larger jobs they get a seperate scope sheet as well. A QB invoice is sent for any due payments. I find that I need to many QB 'items' to make it work for estimating anything more than small, limited scope jobs. I also haven't figured out how to use items to estimate without having a long itemized list show in the estimate. I still will send out an initial Estimate from QB with a general description for small stuff and initial pricing. I'm curious 72, if you don't use QB for the invoice, how do you tie payments received to customers and how do you track expenses per job/cust. to see if you are on target with your estimates and pricing? __________________ www.ddcontractors.net Quote:
Originally Posted by CCCo. Yep, you guessed, sold by a fancy white guy, installed by the brown army.
Last edited by bert0168; 09-07-2009 at 08:22 AM.
09-07-2009, 08:38 AM
#6
HSConstruction
Re: Quickbooks Item Numbers
Pro
I do not use QB for estimates, it would take forever to set up all the various line items. I use a very modified version of National Estimator for estimates and then QB for invoicing. I know everyone hates Natl Est but I have created templates for the most common projects we do,i.e Bathroom, kitchen, addition, decks and so on. In each of those templates are every aspect of the work line by line. It helps me to "remember" everything and makes a complex estimate seem easier when going thru it 1 line item at a time. __________________ Kitchen and Bath Remodel Warren County NJ, Sussex County NJ, Morris County NJ
Trade: Remodeler Join Date: Mar 2009 Location: NW NJ Posts: 416 Rewards Points: 250
09-09-2009, 01:34 AM
#7
darbrownlee
Re: Quickbooks Item Numbers
Registered User
I have previously used QB using standard accounting COA with account numbers; 1000 - 1999: asset accounts 2000 - 2999: liability accounts 3000 - 3999: equity accounts 4000 - 4999: revenue accounts 5000 - 5999: cost of goods sold 6000 - 6999: expense accounts 7000 - 7999: other revenue (for example, interest income) 8000 - 8999: other expense (for example, income taxes)
Trade: Developer Join Date: Sep 2009 Location: Western, Kentucky Posts: 1 Rewards Points: 10
I used classification to identify Labor, Material & sub-contract and others... I set up items as per CSI Div and built the catalog as needed. This provided great costing data and cash flow. I had managed draws with AIA spreadsheets in Excel. Manually updated form with percentage formulas and manually input data into div and classes in QB. I never felt that the estimate to progress billing was flexible enough. I also felt that running budgets outside of QB kept the numbers more accurate and easier to balance - more likely to catch mistakes. I have been out of the business for a time and am now setting up a new accounting project. I have COA accounts from NAHB which includes more detailed breakdown in the cost of goods account in the COA as to division of work accounts. NAHB uses the 'Work in Progress' asset account, and I feel that for longer jobs this would make a really true track and measure in the balance. Looks like extra work though... Question: Has anyone out there hit the right balance as to the detail in the COGS accounts in the COA? Why does everyone not like National Estimator? Attached Files NAHB Chart of Accounts.pdf (88.4 KB, 1694 views)
09-09-2009, 05:25 AM
#8 Re: Quickbooks Item Numbers
AustinDB Contractor
Quote:
Originally Posted by bert0168 I'm curious 72, if you don't use QB for the invoice, how do you tie payments received to customers and how do you track expenses per job/cust. to see if you are on target with your estimates and pricing?
Trade: Remodeling & Home Additions Join Date: Sep 2006 Location: Austin, TX Posts: 4,054 Rewards Points: 556
after the contract is signed and deposit received, in QB's I'll make an invoice with a line item called 'bid by project' and enter the project amount. then checks written out can be attributed to that 'job' and payments received credited accordingly.
09-09-2009, 06:28 AM
#9
jimmys
Re: Quickbooks Item Numbers
JimmyS
I don't estimate in QB, but I do all my company bookkeeping in it. For jobs, I use what QB calls an estimate, but which I have re-named Payment Schedule. The Payment Schedule lists all the regular Progress Payments (draws) I've planned, with dates. Then when it's time for billing the customer, I open the Estimate (payment schedule) and bill 100% or whatever portion of that line is appropriate. When we get a Change Order approved, I add each as a line item to the Estimate (payment schedule) so I can bill it. That system works fairly well, as it makes it hard to miss a billing. We rarely use T&M billing. Jim
Trade: General contractor Join Date: May 2009 Location: Mass Posts: 224 Rewards Points: 150
09-09-2009, 07:42 PM
#10
samccard
Re: Quickbooks Item Numbers
Pro
I use AccountingPRO, it has an item list with more than 330 catagories. You can use it to set up estimates in Quickbooks then compare estimate to actual cost. Works great after you get use to it.
Trade: Property Preservation and Remodeling. Join Date: Aug 2007 Location: Ga. Posts: 100 Rewards Points: 75
09-10-2009, 08:17 AM
#11
woodchuck2
Re: Quickbooks Item Numbers
Head Grunt
I use an older quickbooks program from 2007 and it still works well. I also use it for estimating so what i did was break up all my parts/supplies into numbered catagories. Examples would be, All wiring supplies start with the #1. All conduit sizes, fittings, adaptors, glue straps, etc all start with the #2. All switches, recepticles, wall plates, dimmers, remotes, etc all start with the #3. All boxes whether steel, plastic or fiberglass, indoor, outdoor, junction boxes, etc all start with the #4. I put anything misc. like screws, bolts, lags, paint, stain, stencils, caulk, etc start with the #5. I put all lumber starting with the #6. All equipment rental prices start with the #7. All misc. light fixtures start with the #8. All labor, sub labor, inspector costs, generator installation cost, etc all start with the #9. So all i have to do is scroll to the # and search through that #series to find what i need and then click on it. Once you get the #s right you will remember them and just hitting the begining # will jump you right to what you are looking for. This works well for me so far.
Trade: Electrical Contractor&Home Maintenance Join Date: Feb 2008 Location: North Creek, NY/Lower Adirondacks Posts: 3,270 Rewards Points: 2,196
09-12-2009, 03:21 AM
#12 Re: Quickbooks Item Numbers
custrel Noob
Quote:
Originally Posted by darbrownlee I have previously used QB using standard accounting COA with account numbers; 1000 - 1999: asset accounts 2000 - 2999: liability accounts 3000 - 3999: equity accounts 4000 - 4999: revenue accounts 5000 - 5999: cost of goods sold 6000 - 6999: expense accounts 7000 - 7999: other revenue (for example, interest income) 8000 - 8999: other expense (for example, income taxes)
Trade: Commercial Interior Finish Join Date: Jun 2009 Location: Pacific Northwest Posts: 301 Rewards Points: 250
I used classification to identify Labor, Material & sub-contract and others... I Which version of QB do you use? Are you using the job costing features?
Advertisement
Sponsored Links by Taboola
You May Like 4 reasons why people are switching to N26 banking N26 - The Mobile Bank
ADSL Alles-in-1 Pakket - Nu 6 maanden lang € 20 Korting Excite Search
25 Funniest Photobombs Ever Comic News
10 body care tips to save money - Healthy-Sporty-Beautiful Healthy, Sporty & Beautiful
20 of the World’s Scariest Bridges Viral X Files
Play this for 1 minute and see why everyone is addicted Vikings: War of Clans
17 Photos of Melania That Donald Trump Wishes We'd Forget LifeDaily.com
Ever Wonder Why Donald Trump Doesn't Talk About His Daughter Tiffany? Here's Why LifeDaily.com
« Previous Thread | Top of Page | What's New | Next Thread » Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off Forum Rules
Similar Threads Thread
Thread Starter
Forum
Replies
Last Post
Quickbooks Contractor 09
MHI1976
Accounting Software & Discussion
4
08-30-2009 12:18 PM
Quickbooks Contractor version
Builder1624
Accounting Software & Discussion
12
05-03-2009 06:32 PM
Lets talk Quickbooks
FairGC
Accounting Software & Discussion
11
08-21-2008 11:52 AM
Quickbooks & AIA
Norge
Business
2
11-18-2007 06:45 PM
QuickBooks 2004 and Internet Explorer 7
firemike
Technology
1
02-07-2007 08:14 PM
Search
Recent Product Reviews
View All
Wolverine Wolverine Contractor LX CONTRACTOR LX
Surebonder Ryobi® to Makita® Battery Adapter MAK-18V
Recent Projects
View All
Screen Room with Cable Railing
by kate@phoenix
Recent Blog Posting
View All
Roof Maintenance Tips Every Homeowner Should Know by lge77 Dust Free Remodeling by philcav7 Five Common Exterior Remodeling Mistakes, and How to Avoid Them by kevinmckenzie
Community Rules | Terms of Service | Copyright | Privacy Policy | Search | Contact Us | Advertise With Us
Our Pro Network:
Copyright © 2018 VerticalScope Inc. All rights reserved.
DrywallTalk.com | ElectricianTalk.com | HVACSite.com | PaintTalk.com | PlumbingZone.com | RoofingTalk.com | DIYChatroom.com
