How can I track inventory day to day?

A

Anthony

I work for a Gutter installation company and I want to keep track of my
inventory on a day to day basis. Where as I put what we have in inventory on
excel then in other colums i put material used daily and when I order new
material and add it to inventory, so that i can see each day approxamitly
what i have on hand so when quarterly audit comes up i don't have to spend so
much time hand counting. I have Excel 2003. Is there a template of somesort
where I can just plug numbers in to itbecause I am not all that great with
the program yet. Thanks
 
J

Jim Jackson

One way would be like this: with Columns A,C,E used for descriptions (B for
inventory added, D for inventory used, F for On-Hand numbers.

In Column E list all the items you will use whether they are on hand ot not.
In F2 place this formula:
=SUMIF(A2:A1000,E2,B2:B1000) - SUMIF(C2:C1000,E2,D2:D1000)
Then copy and paste down Column F.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top