Inventory Reconciliation Report
Software Plan: Growth & Enterprise
Account Type : Seller Account & Aggregator 3PL
Inventory Type : Serialized & Non-Serialized
Overview
This report provides SKU-level inventory reconciliation by comparing the opening and closing inventory balances for each SKU over a selected period. It includes stock movements such as GRNs, sales, returns, cancellations, inventory adjustments, and inventory assignments from supported inventory statuses to help verify inventory movement and identify discrepancies.
Use Case
Use this report to reconcile SKU-level inventory for a selected period. It helps verify inventory movement by comparing opening stock, GRNs, sales, returns, cancellations, inventory adjustments, and closing stock.
Workflow
Step 1: Go to Reports (main menu) > Inventory Report > Inventory Stock Status
Step 2: Select the report type: Inventory Reconciliation Report (Beta)
Step 3: Select the required date range and click Queue Report
Inventory reconciliation data can only be exported for one month at a time.
Click OK to confirm
Step 4: Download the sheet from the Exports Section
Your sheet will be downloaded
How is the Reconciliation data calculated?
If inventory is assigned to orders using Inventory Assignment Rules based on Inventory Status, the report displays the corresponding inventory status in separate reconciliation columns, wherever applicable.
Refer Inventory Assignment Rules KB
Refer Inventory Assignment Rules KB
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 |
In case of a discrepancy in the calculation of the closing balance, please contact the Easyecom Support team.
FAQ
1. Why do I see columns such as Repair--Reserved or Fraud--Reserved in the report?
A. These columns indicate that inventory was assigned to orders from the respective inventory status through Inventory Assignment Rules. The columns appear where applicable based on inventory transactions for the selected report period.
Other Related Articles
Related Articles
Inventory Ledger Report / Inventory Reconciliation
What is inventory ledger report ? The Inventory Ledger report is like a bank statement for a warehouse inventory. It provides end-to-end inventory reconciliation capability by showing your starting inventory balance, received Inventory, customer ...Inventory Planning by Days Report
Overview The Inventory Planning by Days report helps you plan inventory using historical order data for a selected number of days and the current available inventory. The report provides SKU-level data based on the number of orders received during ...Creating In-House Inventory Adjustment - Status to Status Transfer
Software Plan : Growth & Enterprise Account Type : Seller Account, Aggregator, 3PL Inventory Type : Serialized & Non-Serialized (UoM Supported) Overview Use this to change the status of inventory without changing its bin. When to Use This Feature Use ...Inventory Snapshot
Inventory snapshot reports help retailers in keeping a track of their inventory and thereby help you in inventory analytics. EasyEcom’s inventory snapshot is beneficial to retailers like you as it provides you with: 1. Status Report- This report ...Creating STN order in Easyecom
Software Plan: Growth & Enterprise Account Type: Seller Account Inventory Type: Serialized & Non Serialized Feature description A stock transfer note is created to authorise the movement of inventory from one location to another different location. ...