Another approach is to keep a separate transaction log sheet where every stock-in and stock-out entry is recorded. Then use QUERY, SUMIFS, or Pivot Tables to calculate current inventory automatically. It takes a little setup initially, but it's easier to audit and scales much better as inventory...
