Inventory Ledger Report / Inventory Reconciliation

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 orders, customer returns, adjustments, removals, and ending balance for the warehouse. EasyEcom shows data for the available inventory


How to get inventory ledger report 


Step 1: In the Toggle Menu, Please Navigate to Reports >> Inventory Report >> Inventory Ledger Report



Step 2: Select Start and End Date as per your requirement.



Step 3: Enter SKU and then click on the “Submit” button



You will get the following count on screen 

  • Opening Inventory (in selected date range)

  • GRN done (Inventory inward in selected date range)

  • Sales Count (The quantity sold in the selected date range)

  • Returns Count (The quantity that got return after sales in the selected date range)

  • Adjustment (If any quantity got adjusted via Inventory Adjustment)

  • Physical Kit Produced (The quantity of physical kit produced)

  • Lite Kit Produced (it will reflect when the Lite Kitting setting is enabled)

  • Used in Lite Kitting (the quantity of child SKUs inventory used during Lite Kitting - only visible when Lite Kitting is enabled)

  • Closing Inventory (in selected date range)



OR



To get the detailed data report of GRN, Sales Count, Return count and Adjustment, you may download the CSV by clicking the download action button (highlighted in the snap below)



Following is the data available in the CSV


  1. GRN


  1. Adjustment

  2. Sales Count

  3. Returns Count 




    • Related Articles

    • 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 ...
    • 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 ...
    • B2B Handover / Dispatch Report

      Software Plan : Growth & Enterprise Account Type : Seller Account Inventory Type : Serialized & Non-Serialized Description The B2B Handover / Dispatch Report provides details of all B2B orders that have been shipped or handed over, including ...
    • 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 ...
    • How to manage Dynamic Virtual Inventory in Easyecom

      Software Plan: Startup, Growth & Enterprise Account Type: Seller Account Inventory Type: Serialized & Non Serialized Feature description The Dynamic Virtual Inventory feature allows you to push more inventory than you have in stock across different ...