Perimattic
Free Tool

Multi-Channel Inventory Audit

The ERPPlugs Multi-Channel Inventory Audit compares your TallyPrime closing stock with inventory files from Shopify, Amazon India, Flipkart or any other channel, joined by SKU. It flags listings above Tally stock, live listings with no stock, channel SKUs missing from Tally, unlisted stock, negative stock and quantity drift, and exports the results to Excel without uploading your files.
Overhead view of a person working on a laptop beside a calculator

Use the free tool

Your files stay on your device. Everything is processed in your browser. Nothing is uploaded to ERPPlugs or anyone else, and no account is needed.

1

TallyPrime closing stock

Your stock summary or stock item list from TallyPrime, exported item by item with closing quantity. Add the part no / SKU column if you keep one.

2Channel inventory files

Add up to 4 channels. Leave a channel empty to skip it, or remove it.

Shopify inventory

Shopify inventory export (CSV). Uses the SKU and Available columns; rows for several locations are added up.

Amazon India inventory

An Amazon Seller Central inventory or listings report. Uses seller-sku and quantity (or afn-fulfillable-quantity for FBA).

Flipkart inventory

A Flipkart Seller Hub listings file. Uses Seller SKU Id and your stock count.

Load the Tally file and at least one channel file, or click Use sample data on each, to run the audit.

How It Works

How the Multi-Channel Inventory Audit Works

  1. 1

    Load Tally stock

    Export closing stock item by item from TallyPrime to Excel or CSV, with the part no or SKU column if you keep one. Or start with the sample files.

  2. 2

    Add your channels

    Add up to four channel files: a Shopify inventory export, an Amazon India inventory or listings report, a Flipkart listings file, or any file with SKU and quantity. Choose whether the channels share one stock pool.

  3. 3

    Fix what is flagged

    Every SKU is checked for oversell risk, negative stock, SKUs missing from Tally, unlisted stock and drift. Filter by issue and download Summary, All SKUs and Issues sheets.

Guide

How to Run a Useful Multi-Channel Stock Audit

Export everything at the same moment

Stock moves all day, so export Tally and every channel file as close together as you can, ideally before dispatch starts or after it ends. Orders that are in a channel but not yet billed in Tally will otherwise show up as differences.

Export Tally stock item by item rather than by stock group. Group totals have no SKU and would be compared as if they were items.

What to fix first

Rows are sorted with the most serious issues on top.

  • Critical: negative Tally stock, live listings with no Tally stock, and channels listing more than Tally holds. These can lead to orders you cannot ship.
  • Warning: channels that together exceed a shared pool, SKUs that exist on a channel but not in Tally, and quantity drift.
  • Info: stock in Tally that is not listed on any channel you loaded.

Inactive listings

If a channel file has a status column, listings marked inactive, blocked, suppressed, closed, draft or archived are shown but not counted as live, so they never raise oversell flags. Without a status column, every listing is treated as live.

FAQ

Frequently Asked Questions

From TallyPrime: closing stock exported item by item to Excel or CSV, with item name and closing quantity (quantities such as "120 Nos" or "(-)5 Nos" are read correctly) plus the part no or SKU if you keep one. From each channel: any inventory or listings export with a SKU column and a quantity column, such as the Shopify inventory export (SKU and Available), an Amazon India report (seller-sku with quantity or afn-fulfillable-quantity) or a Flipkart listings file (Seller SKU Id and stock count). Excel (.xlsx) and CSV both work.

By SKU, after ignoring case, spaces, dashes and leading zeros. Rows for the same SKU in one file, such as one row per Shopify location, are added together. For Tally items with no SKU, the tool tries the channel SKU against the Tally item name, then the channel product name against the Tally item name, and shows which key was used. A channel SKU that matches nothing is reported as not in Tally.

Listed above Tally stock: one channel shows more units than Tally holds. Live with no Tally stock: Tally is at zero or below but a live listing still has quantity. Channels together exceed stock: with a shared pool, live listings add up to more than Tally holds. Not in Tally: a channel SKU with no Tally item. Unlisted stock: a Tally item with stock that is in none of the channel files. Negative stock: Tally closing quantity below zero. Quantity drift: with the shared pool off, a channel differs from Tally by more than your tolerance.

Turn it on (the default) when every channel sells from the same Tally stock and you split units between channels: the audit then checks that live listings add up to no more than Tally stock. Turn it off when each channel is meant to show your full Tally quantity: the audit then flags any channel whose quantity differs from Tally by more than the tolerance you set, in units.

No. The audit compares quantities only and does not read sales history, so it cannot tell how fast an item sells. The closest signal is unlisted stock: items with units in Tally that are not listed on any channel you loaded.

No. All files are read and compared inside your browser. Nothing is sent to ERPPlugs or anyone else, there is no sign-up, and closing the tab clears the data.

ERPPlugs

Ready to eliminate manual data entry?

Start a 7-day free trial and see results in 5 minutes. No credit card required. Works with TallyPrime, Zoho, SAP and more.
  • Free consultation
  • No commitment
  • Tailored to your team

All product names, logos, and brands mentioned on this site are the property of their respective owners. ERPPlugs is not affiliated with, endorsed by, or sponsored by any of the third-party companies referenced. Use of these names is for identification purposes only and does not imply any association or endorsement.