Talk to an expert

Tell us what you need and we will call you back.

🇮🇳 +91

    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.

    • Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Read the full entry

    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

    1. List masters

      Every stock item, unit of measure, stock group, godown and batch in the old system.

    2. 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.

    3. Confirm the valuation method

      FIFO or weighted average must match, or opening values must be recomputed.

    4. Load opening stock

      Item by item as at the cut-off date.

    5. 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.

    Review and sources

    Written by Gautami Deshpande, reviewed by CA Puja Pradhan

    Talk to an expert

    Tell us what you need and the right person calls you back.

    🇮🇳 +91

      By sending this form you agree to our privacy policy.

      Get compliance due-date alerts on WhatsApp. Join →