Opening Stock | The opening balance represents the inventory available at the start of the month. For example, in the inventory reconciliation report from January 1st to 31st, 2025, the opening balance for January 1st will be the closing balance from December 31st, 2024. You may refer to columns N, O, U and V from the Historical Inventory Snapshots Report. To tally the Opening Balance: Opening Balance = Reserved (Not Picked) + Reserved (Picked) + Available Quantity + Available Quantity (Bin Locked) |
GRN Stock | The GRN stock count in this sheet can be verified against the GRN count in the Putaway Activity Report. You may refer to column E in the Putaway Activity Report. |
Sales | The sales count should match the sum of the item quantity in the Tax Report. |
Sales With Inventory | The "Sales with Inventory" column includes orders that were assigned inventory as soon as they were received in the system. |
Sales Without Inventory | The "Sales without Inventory" column includes orders processed without inventory being deducted. For example, this includes orders imported in "Shipped" status or orders synced to Easyecom but processed directly through the marketplace. |
Return/Cancel | Returns and cancellations can be verified against the Return/Cancel Count in the Putaway Activity Report. You may refer to column E in the Putaway Activity Report. |
Available--Discard | The 'Available--discard' column reflects inventory adjustments made through the inventory adjustment process. You may go to Inventory Adjustment and queue the report for your preferred date range. |
Closing Stock | The "Closing Stock" column represents the end-of-month balance. To tally the closing stock: Closing Stock = Opening Stock + GRN Count + Sales With Inventory + Returns/Cancel + Available--Discard |