Inventory Voucher Mapping
Inventory voucher mapping is the plan that matches each stock voucher type and item in an old system — sales, purchase, stock journal, delivery and receipt notes — to the equivalent transaction and item master in a new one, so inventory migrates accurately. It is set before a stock migration. It matters because inventory drives both the stock ledger and the cost of goods sold, so a mis-mapped voucher distorts valuation and margin.
What Is Inventory Voucher Mapping?
Inventory voucher mapping is the stock counterpart of ledger mapping. Every inventory movement in the old system is recorded through a voucher — a purchase adds stock, a sale removes it, a stock journal adjusts it — and each of those voucher types, along with every item master and unit of measure, must be matched to its equivalent in the new system. The mapping decides how quantities, rates and valuations carry across.
An Indian business meets this whenever a stock-carrying entity changes software. A Vadodara trading firm moving systems must map its item masters, units and each stock voucher type so that opening stock, valuation method and item-wise quantities all reconcile after migration. Because inventory feeds cost of goods sold, an error here does not just misstate the stock ledger — it flows straight into gross profit and, ultimately, taxable income.
Key terms
- Outstanding Balances Migration — Bringing open debtor and creditor items across in a migration.
- GST History Extraction — Extracting GST data tied to stock transactions.
- Double-Entry Bookkeeping — The debit-credit basis the stock entries ultimately post through.
How Inventory Voucher Mapping Works
Stock data migrates through a mapping and reconciliation sequence:
- 1List item masters and units
Every stock item, unit of measure and group in the old system is inventoried — the base the mapping works from.
- 2Map voucher types
Each stock voucher type — purchase, sales, stock journal, delivery/receipt note — is matched to the new system's equivalent.
- 3Set the valuation method
The costing method (FIFO, weighted average) is confirmed so migrated stock is valued consistently.
- 4Migrate opening stock
Item-wise opening quantities and values are loaded as at the cut-off date.
- 5Reconcile stock and value
Item-wise quantities and total stock value in the new system are tied back to the old stock summary.
How Inventory Voucher Mapping Is Handled in Accounting Software
Tools import item masters and stock movements, but voucher-type and valuation choices must be mapped deliberately.
| Software | How it handles inventory voucher mapping | Watch-out |
|---|---|---|
| Zoho Books / Zoho Inventory | Items import via template; sales/purchase map to invoices and bills, with stock adjustments for journals. | Zoho's valuation is FIFO — a source on weighted average needs its opening values recomputed. |
| Tally / TallyPrime | Stock items, units and inventory vouchers import via XML with their voucher types. | Godown/batch details must be mapped, or stock lands without location or batch. |
| Xero | Tracked inventory items import via template; not all voucher types have a direct equivalent. | Xero's inventory is lighter — complex stock journals may need manual adjustment. |
| Odoo | Products and stock moves import into Inventory; valuation set per product category. | Real-time vs periodic valuation setting changes how cost posts — confirm before import. |
Inventory mapping must reconcile on both quantity and value — matching one without the other still misstates stock.
Inventory Voucher Mapping: A Practical Example
| Particulars | Amount (INR) | Treatment |
|---|---|---|
| Opening stock, old system (weighted avg) | 22,00,000 | Item-wise quantities and values |
| Item masters mapped | — | Codes and units matched to new system |
| Sales/purchase vouchers mapped | — | To new invoices and bills |
| Migrated stock value reconciled | 22,00,000 | Ties to old stock summary |
A Vadodara trading firm migrates inventory by mapping its item masters, units and each stock voucher type to the new system, and confirming the weighted-average valuation. Its ₹22,00,000 of opening stock is loaded item by item, and both the item-wise quantities and the total value are reconciled back to the old stock summary. Because stock feeds cost of goods sold, this tie-out protects the migrated gross profit as well as the stock ledger.
Mismatched valuation method: Loading weighted-average stock into a FIFO system without recomputing distorts value → align or recompute the valuation before import.
Common Mistakes With Inventory Voucher Mapping
Stock migrations fail quietly when quantity and value drift apart:
- Mismatched valuation method — Loading weighted-average stock into a FIFO system without recomputing distorts value → align or recompute the valuation before import.
- Unmapped voucher types — A stock journal with no destination equivalent drops adjustments → map every voucher type, using stock adjustments where needed.
- Reconciling quantity but not value — Matching units while value drifts misstates stock and COGS → reconcile both quantity and value.
- Losing batch or godown detail — Dropping location/batch data breaks traceability → map godowns and batches explicitly.
Inventory voucher mapping is the plan that matches each stock voucher type and item in an old system — sales, purchase, stock journal, delivery and receipt notes — to the equivalent transaction and item master in a new one, so inventory migrates accurately. It is set before a stock migration. It matters because inventory drives both the stock ledger and the cost of goods sold, so a mis-mapped voucher distorts valuation and margin.
Need help with Inventory Voucher Mapping?
Inventory Voucher Mapping sits inside your day-to-day books. Patron's CA-led team keeps them accurate, compliant and audit-ready.
Applicable framework: Inventory valuation per AS 2 / Ind AS 2; migration practice; Companies Act 2013 (Schedule III). For general information only, not professional advice. Verify the current position for your entity before acting.