Excel is the way to go. If it sounds too complicated.... maybe a legal pad and a #2 pencil... j/k HAHA....

Or hire someone with Inventory Control experience to audit your inventory weekly or biweekly...