Hi Damon,
Been using QB pro since 2000 or so, previous to that I was an excel junkie.
I do have QB fully loaded with item costs for everything. Everything from SQ' prices if I need to price that way, or (which) I prefer Room costs. Every type of surface interior / exterior or room that i have ever painted has been program'd in with a set price (I refer to the set price as a base price, cause i + or - as needed after visual inspection). I buy mostly from 2 sources, so my materials costs are always up-todate.
When choosing materials i have it set up where i can select the products individually which shows my cost (not really a big deal if you consider I typically use usually the same 6 products on every job), and allows me to throw a markup in there also. The printed/email estimate doesn't show that information, it spits out (all one 1 line) as Materials....... $X (no break down shown for materials, cause i like it that way)
Programming each thing takes a min or two, but I add things only as they come up, but once they're in there, u don't have to ever do it again, and editing, making changes cause u realize something should be alittle more or less only takes a few seconds.
For labour, I preprogrammed in a base price for certain rooms, it's literally this easy (I'll use fake numbers).
I type "Dining Rm"... (click tab to next line)
***on the estimate it shows as (if u know QB imagine the alignment being better than my example)
Room: Description Qty: Rate:
Dining Room Prep and paint dining room with 2 coats...etc 1 200
For materials
I type "602" tab... qty "2" tab
I type "mur" tab... qty "1" tab
*** on the estimate it looks like
Materials Description Qty Rate
Paint materials Topline Paint materials req'd 1 150
etc. etc....
Note: I have done alot of customization of the boxes/colours/fields/formats to affect the look of my estimates/invoices. It doesn't look like I bought QB off the shelf, and used the standard templates.
I know u aren't asking for this much, but i'll mention a couple other things about QB incase anyone is curious... and is looking for something to use for thier business..
so the above was for estimates....
Those that know QB's, know u can turn any estimate into an invoice, to print/email etc...which covers the Income portion of your bookkeeping. I'll later on punch in receipts into QB's for my expenses. While doing so, I make sure to select from the drop down box "job/project" to associate what expense was incurred from which job i was working on. Useful if u run a P&L statement to analyse which jobs were makin u money.... When my statements come in (bank/CC), i check see if anything got missed.
GST time comes, I click GST button (which i added on my desktop view), copy numbers from that to the real deal, Done.
Year End comes I click "back up" company file, upload to my server space (my webguy set that up for me, I prefer this, cause if ur house burns down, ur back up's r still online)... My accountant deals with QB's, so he get's his own Login/PW, downloads it on his end, (I manually bring in the few folders) he does his thing, Done.
Note: For anyone who still wants to do some things with Excel, U can export ur estimates to Excel, play with it how u see fit, then import it back in. It's complicated to explain, just know that it can be done.
For me, a small paint contractor, QB's Pro does everything I need.