Inventory Reconciliation Report

Inventory Reconciliation Report

Info
Software Plan: Growth & Enterprise
Info
Account Type : Seller Account & Aggregator 3PL
Info
Inventory Type : Serialized & Non-Serialized

Feature description

This report offers a comprehensive SKU-level inventory reconciliation, ensuring accurate tracking of stock movement. It presents the opening and closing inventory balances for each SKU, with detailed breakdowns of all relevant transactions, including GRNs, sales, returns, and cancellations. This allows users to verify the integrity of inventory data and identify any discrepancies.

Use Case

An online retailer utilizes the SKU-level inventory reconciliation report to maintain accurate stock levels. This daily report compares opening and closing inventory, providing a detailed breakdown of GRNs, sales, returns, and cancellations. By analyzing this data, the retailer identifies discrepancies, such as unexpected sales or return volumes, enabling them to investigate and correct errors. This proactive approach ensures optimal stock levels, minimizes stockouts and overstocking, and enhances overall inventory accuracy for improved customer satisfaction and reduced financial losses.

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 date range and click "Queue Report."

Info
Inventory reconciliation data can only be exported for one month at a time.
Click OK to confirm



Step 4: Download the sheet by going to the Export Section


Your sheet will be downloaded


How is the Reco data calculated?

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.
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 adjusted through inventory adjustments. 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 + Returns/Cancel + Available--Discard
Warning
In case of a discrepancy in the calculation of the closing balance, please contact the Easyecom Support team.

    • 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 ...

    • 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. ...

    • 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 ...

    • Manage Inventory - Starter Plan

      Software Plan: Starter Account Type: Seller Account & Aggregator 3PL Inventory Type: Non-Serialized Feature Description This knowledge base article provides a clear and concise guide for sellers using the Easyecom Starter Plan on how to manage their ...

    • Inventory Planning by Days Report

      What is the “Inventory Planning by Days” Report? The "Inventory Planning by Days" report is a comprehensive analysis that provides data to help plan the inventory using historical data over a specified time period. This report is designed to assist ...