Understanding Inventory ledger

There might be instances where you need to investigate stock discrepancies, trace missing inventory, or explain sudden changes in available quantities. This is where the Inventory Ledger Report becomes essential. It helps you to:

Track stock movement at the ESIN level
Reconcile inventory across systems
Identify losses, additions, or errors
Audit inventory by product, facility, or channel
Prepare MIS reports for finance and ops

In this article, you will learn about the inventory ledger report and how to download it from the workspace.

The Inventory Ledger Report is a comprehensive record of stock movement across a specified time period. It shows:

Opening stock
Closing stock
Inward movements (inward consignments, returns)
Outward movements (B2C/B2B orders, removals)
Adjustments

You can view inventory movement in the Summary view, the Detailed view and the Status view.

Summary view

The summary view of the inventory ledger shows a SKU-wise summary of complete stock movement in a given time period as follows:

Opening stock: Initial stock at the beginning of the reporting period.
Inwards: Items inward in the given time period.
Returns: Orders for which a return was created in the given time period.
B2C orders: Orders marked ready to ship in the given time period.
B2B orders: Orders marked as packed in the given time period.
Removals: None of the above events.
Closing stock: Remaining stock at the end of the reporting period. Closing stock is equal to Opening stock + Inward + Return - B2C orders - B2B orders - Removals + Adjustments.
Adjustments: Includes inventory movements such as draft returns, excess item returns, other item returns, migration inventory counts, and internal adjustments data.

Inventory Report Sample: https://docs.google.com/spreadsheets/d/10u9uXRwXAi8JtO80USXay4-AxT5_fvqQRnZDqDPlwqI/edit?usp=sharing

Detailed view

The Detailed View of the inventory ledger shows a transaction-wise summary report for each type of inventory movement. Instead of a combined overview, it provides a separate report for the following categories:

Report	Description	Fields
Sales report	Records inventory deducted due to customer sales fulfilled across various sales channels.	Learn about sales order report here.
B2B report	Records inventory dispatched against bulk business orders raised by partner accounts.	Learn about B2B order report here.
Draft returns report	Records inventory from customer returns that are initiated but not yet processed or verified	Learn about draft returns report here.
Removals report	Records inventory moved out of the facility due to removal, destruction, or transfer requests.	Learn about removals report here.
Adjustments report	Records inventory changes made due to cycle counts, damages, or reconciliation activities. Inventory adjustments happen due to the following reasons: Stock loss, like damage, theft, or expiry Stock gain from over-receipt or missed inward entries Audit corrections after physical stock audits Inventory write-offs for discontinued or unsellable products System sync corrections to fix mismatches between systems	Adjustment ID: A unique identifier for the inventory adjustment transaction. ESIN: Eshopbox Standard Identification Number, a unique code for product identification. SKU: Stock Keeping Unit, a unique product variant identifier. EAN: European Article Number, used for product identification via barcode. Quantity: The number of units affected by the adjustment. Reason code: A predefined code explaining why the inventory was adjusted (e.g., damage, audit). Event Name: The specific event or action that triggered the adjustment (e.g., stock audit, inventory correction). Inventory adjustment: The type of adjustment made (e.g., addition, deduction). Transaction date: The date when the inventory adjustment was recorded in the system. Reference ID: An associated reference number for the adjustment (e.g., related order ID, consignment number).

Steps to export the inventory ledger report

You need to follow the steps below to export the inventory ledger report:

Step 1: Log in to your Eshopbox workspace.
Step 2: From the header, navigate to "All Products"> "Export".
Step 3: You will be redirected to the Inventory Export page. From the All Products dropdown, select "Inventory Ledger Summary Report."
Step 4: Choose the view in which you want to download the inventory ledger report.
- To download the report in summary view, select 'Summary View', specify the location, and select the desired date range.
- To download the report in detailed view, select 'Detailed view' and apply the desired filters, including transaction type, location, and date range.
Step 5: Click on Export CSV.
Step 6: The report will get downloaded. You can access your inventory ledger summary report by navigating to File > Export.

You can also schedule the reports based on your requirements. Learn how to schedule reports here.

FAQs

Q1. How do I reconcile my physical inventory with my accounting books?

The inventory ledger is available by SKU for each location, listing a unique transaction ID and event type for each transaction. To reconcile the inventory with your books of accounts, you need to:

Export the details of each transaction recorded in your books. This export must have a unique transaction ID and SKU available for each event type recorded in your books.
Reconcile the transactions in your books with each event mentioned in the detailed view of the inventory ledger. You can use the combination of a unique transaction ID and SKU to reconcile each transaction. If any event is missing from your books, then you need to record it.
Additionally, you need to record all adjustments shown with the event type 'Adjustments' to document the adjustments made for any exceptions that have impacted your inventory, such as an item missing in return or a return lost in transit.

Q2. How can I identify discrepancies between the stock displayed on the sales channel and in the Eshopbox workspace?

You can use the Inventory Ledger to identify discrepancies between stock levels shown on sales channels versus those in Eshopbox. This shows detailed information about:

Buffer stock settings that affect available inventory allocations.
Inventory holds for unfulfillable or exception orders.
Sync delays with marketplaces due to API limits or failures.

To analyse the root cause, you can compare sellable quantities and sync timestamps in the Inventory Ledger with the listings on your sales channel.