Glossary · Accounting & Bookkeeping
Inventory Voucher Mapping
Definition
Inventory voucher mapping is the plan that matches each stock voucher type, item and unit of measure in an old accounting system to its equivalent in a new one. It is prepared before stock data is migrated. It makes sure quantities, rates and stock values carry across correctly, so the stock ledger and cost of goods sold stay right.
At a glance
- Category
- Accounting & Bookkeeping
- In this entry
- Inventory vouchers vs accounting vouchers How it works · Example
In detail
01 Inventory vouchers vs accounting vouchers
An inventory voucher moves only quantity and stock value. An accounting voucher moves ledger balances and records the sale, purchase and tax. For example, a delivery note reduces stock when goods leave the godown; the sales invoice raised later records the receivable and the GST. Mapping links the two so stock does not leave without a sale being recorded.
In Tally, common inventory vouchers include the receipt note, delivery note, rejections in, rejections out and stock journal.
How it works
02 How it works
- List masters
Every stock item, unit of measure, stock group, godown and batch in the old system.
- Map voucher types
Purchase, sales, stock journal, delivery and receipt notes to their equivalents in the new system. Where there is no direct equivalent, use a stock adjustment.
- Confirm the valuation method
FIFO or weighted average must match, or opening values must be recomputed.
- Load opening stock
Item by item as at the cut-off date.
- Reconcile
Both quantity and value, item by item, to the old stock summary.
Worked example
03 Example
An example, not advice on your facts.
A Vadodara trading firm moves to new software. Its old system values stock at weighted average.
| Item | Old system | New system | Check |
|---|---|---|---|
| Stock items | 1,240 | 1,240 | Codes and units matched |
| Total quantity (all items) | 58,600 units | 58,600 units | Ties |
| Opening stock value | ₹22,00,000 | ₹22,00,000 | Ties |
The firm confirmed the new software uses the same valuation method before loading. Had it not, the ₹22,00,000 would have needed recomputing.
Watch out
04 Common mistakes
- Loading weighted-average values into a system that uses a different method, without recomputing.
- Leaving a voucher type unmapped, so stock adjustments are lost.
- Reconciling quantity but not value (or the other way round).
- Dropping godown or batch details, which breaks traceability.
- Leaving delivery notes that were never converted into invoices, so stock is reduced but no sale or GST is recorded.
Need help mapping stock in a migration? See our Migration: Tally to Zoho Books or Inventory Accounting & Costing.
