Use the sample monthly inventory report to record monthly inventory then upload the report here. This excel sheet calculates the totals for you; simply enter the box totals for the brands listed.