How can I track inventory day to day?

[Guest]

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

 

[Guest]

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,D21000)
Then copy and paste down Column F.