Tracking Inventory In Quickbooks - Plumbing Zone

CentralPlumbing · 01-30-2009, 11:39 PM

Does anybody use quick books to track inventory? Is it even worth doing? How do you use quick books to track your inventory against your job invoices?

WestCoastPlumber · 01-30-2009, 11:42 PM

I have seen, I have looked at, and I have not started it. It would be easy to do for me since I am fully computerized in the van, but geeze, more work?

I have a really organized van, so it is easy for me to know what i have on the shelves. I also have apretty good idea of investment, very important for IRS.

CentralPlumbing · 01-30-2009, 11:45 PM

Thanks for the quick response!
So you just keep a file of your purchases for IRS to pay taxes on anything lest over at the end of the year?

WestCoastPlumber · 01-30-2009, 11:51 PM

oh boy, hope the IRS does not see this, it is an estimated amount...

close though. I could go in and make a list anytime, this is how organized my van is

Hows Albuquerque? miss it, trying to get the wife to vacation over there, I have alot of friends in Albuquerque and Santa fe, love it, very pretty, just hard ot make the $$

CentralPlumbing · 01-31-2009, 12:00 AM

Well an estimate is good enough

, the company i work for has hundreds of thousands of dollars in stock on their trucks and in the store room and believe me there is no way they can keep track of it all with out putting somebody on full time. I think i would like to track what I sell every day just so i can restock that every few days. Nothing worse that not having something you need on the truck!

CentralPlumbing · 01-31-2009, 12:04 AM

Albuquerque is good. The HAVC side is hurting bad, not a lot of people are willing to shell out the thousands of dollars needed to install AC systems. But plumbing is steady, it has slowed a little but people need their plumbing so they usually go with the estimates. There are a few companies going under here though that have a lot vested in HVAC. In fact one i worked for before i got fired is going under, cant say im sorry for them!

WestCoastPlumber · 01-31-2009, 12:07 AM

Quote:

Originally Posted by CentralPlumbing

Well an estimate is good enough

, the company i work for has hundreds of thousands of dollars in stock on their trucks and in the store room and believe me there is no way they can keep track of it all with out putting somebody on full time. I think i would like to track what I sell every day just so i can restock that every few days. Nothing worse that not having something you need on the truck!

I keep a note book in reach and make it a habit to write down everthing I take from the van, the larger jobs I purchase at the supply house.

Very important to write down what you take, once the paper is full, or I have a good list of truck stoch to refill, I put it on the visor for when I am at the supply house, I then purchase it as truck stock.

It takes some time getting used to, but write it down and refill it later.

Wiser · 01-31-2009, 01:44 AM

Using Quickbooks to inventory Water heaters, toilets and big items would be worth it. The small parts and pieces will drive you nuts.

Example: You buy all your fill valves from ABC Co. and record that in Quickbooks. You sell the item and it is deducted from inventory. Couple of weeks later, you need more, but rather than get them at ABC Co., you go to Co. D because you need Amer. Standard items and ABC is a Kohler dealer & you're not making two supply house runs. New numbers and slightly different pricing on the fill valves, but you aren't going to drive an extra 5 miles to save 35 cents either.

Then one day you go to Lowes and Fill Valves are half price, so you pick up two dozen. Try to account for that mess! Plus, plumbing incidentals fluctuate in price (sometimes week to week). Our pricing also fluctuates depending on the quantity of any given item ordered.

01-30-2009, 11:39 PM	#1
CentralPlumbing Member Join Date: Jan 2009 Posts: 72 My Photos	Tracking Inventory In Quickbooks Does anybody use quick books to track inventory? Is it even worth doing? How do you use quick books to track your inventory against your job invoices?

01-30-2009, 11:42 PM	#2
WestCoastPlumber Plumber Manhattan Beach Join Date: Jun 2008 Location: Los Angeles (South Bay) Posts: 828 My Photos	I have seen, I have looked at, and I have not started it. It would be easy to do for me since I am fully computerized in the van, but geeze, more work? I have a really organized van, so it is easy for me to know what i have on the shelves. I also have apretty good idea of investment, very important for IRS. __________________ Robert Plumber Manhattan Beach, Plumber Hermosa Beach,Plumber Marina Del Rey, Plumber Redondo Beach, Tankless water heaters Los Angeles Tankless repair Los Angeles

01-30-2009, 11:51 PM	#4
WestCoastPlumber Plumber Manhattan Beach Join Date: Jun 2008 Location: Los Angeles (South Bay) Posts: 828 My Photos	oh boy, hope the IRS does not see this, it is an estimated amount... close though. I could go in and make a list anytime, this is how organized my van is Hows Albuquerque? miss it, trying to get the wife to vacation over there, I have alot of friends in Albuquerque and Santa fe, love it, very pretty, just hard ot make the $$ __________________ Robert Plumber Manhattan Beach, Plumber Hermosa Beach,Plumber Marina Del Rey, Plumber Redondo Beach, Tankless water heaters Los Angeles Tankless repair Los Angeles

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
another quickbooks problem	WestCoastPlumber	Business, Marketing, and Sales	12	03-04-2009 10:45 PM
Quickbooks Help	BatonPlumbing	Business, Marketing, and Sales	5	12-31-2008 04:10 AM
Anyone interested in learning about GPS Tracking?	NeroGPS	Business, Marketing, and Sales	23	12-03-2008 04:51 PM

01-30-2009, 11:45 PM	#3
CentralPlumbing Member Join Date: Jan 2009 Posts: 72 My Photos	Thanks for the quick response! So you just keep a file of your purchases for IRS to pay taxes on anything lest over at the end of the year?

01-31-2009, 12:00 AM	#5
CentralPlumbing Member Join Date: Jan 2009 Posts: 72 My Photos	Well an estimate is good enough , the company i work for has hundreds of thousands of dollars in stock on their trucks and in the store room and believe me there is no way they can keep track of it all with out putting somebody on full time. I think i would like to track what I sell every day just so i can restock that every few days. Nothing worse that not having something you need on the truck!

01-31-2009, 12:04 AM	#6
CentralPlumbing Member Join Date: Jan 2009 Posts: 72 My Photos	Albuquerque is good. The HAVC side is hurting bad, not a lot of people are willing to shell out the thousands of dollars needed to install AC systems. But plumbing is steady, it has slowed a little but people need their plumbing so they usually go with the estimates. There are a few companies going under here though that have a lot vested in HVAC. In fact one i worked for before i got fired is going under, cant say im sorry for them!

01-31-2009, 01:44 AM	#8
Wiser Registered Member Join Date: Jul 2008 Posts: 913 My Photos	Using Quickbooks to inventory Water heaters, toilets and big items would be worth it. The small parts and pieces will drive you nuts. Example: You buy all your fill valves from ABC Co. and record that in Quickbooks. You sell the item and it is deducted from inventory. Couple of weeks later, you need more, but rather than get them at ABC Co., you go to Co. D because you need Amer. Standard items and ABC is a Kohler dealer & you're not making two supply house runs. New numbers and slightly different pricing on the fill valves, but you aren't going to drive an extra 5 miles to save 35 cents either. Then one day you go to Lowes and Fill Valves are half price, so you pick up two dozen. Try to account for that mess! Plus, plumbing incidentals fluctuate in price (sometimes week to week). Our pricing also fluctuates depending on the quantity of any given item ordered.