Retail for Square: Inventory by Category totals to not match Inventory Items report

[Random1]

When I run my Inventory by Category report as of today, why do the totals NOT match when I export my Inventory by Items as of today and total them up? It's off in every category plus/minus, and the overall total doesn't match up. Isn't the Report pulling from my Inventory Items list?

[AshleyK]

Hey @Random1!

The Inventory by Category report looks at the value of your entire stock (Total Inv. Value) received with a cost, and calculates the profit margin based on the potential sale value. Viewing your item library by category is intended to give you a higher level overview — so you can compare the potential profit and profit margin for entire categories.

Keep in mind, the Inventory by Category report is generated one hour after your scheduled close of day.

It’s important to bear in mind that the Projected Profit report is calculated based on FIFO (first in, first out) sales of items received with a cost. It currently does not account for recounts or marking items as damaged, stolen (theft) or as a loss.

[Paulyester]

Is there any way to 'reset' the system so that, now that we know to put costs in EVERY time, it would report correctly. And why doesn't the system account for recounts and damaged/lost items? Adjustments are made to make the inventory correct, shouldn't the calculation take these additions/deletions/losses into the calculation?  What use is the report if it's not 'real?'