Exercise 9

Purchase Vouchers Without Inventory

Published 30 Sep 2026

---

This exercise imports Purchase Vouchers that don't have stock items — just an invoice-level amount against a Purchase Ledger. It mirrors the Sales Vouchers Without Inventory exercise, with the Supplier and Purchase Ledger taking the opposite sides of the entry.

The Excel sheet

---

Step 1 — Create the Ledger masters

First, we need to write tags for creating Ledger masters for the Supplier (Column C) and the Purchase Ledger (Column D) — before the voucher can be posted. udiMagic processes MASTER tags before VOUCHER tags, so both ledgers get created automatically in the same import if they don't already exist.

<!-- Supplier Ledger, created under Sundry Creditors -->
<MASTER TYPE="LEDGER">
    <NAME.LIST>
        <NAME COLUMNREFERENCE="C"/>
    </NAME.LIST>
    <!-- Additional Name refers to the Mailing Name field in Tally -->
    <ADDITIONALNAME COLUMNREFERENCE="C"/>
    <PARENT>Sundry Creditors</PARENT>
</MASTER>

<!-- Purchase Ledger, created under Purchase Accounts -->
<MASTER TYPE="LEDGER">
    <NAME.LIST>
        <NAME COLUMNREFERENCE="D"/>
    </NAME.LIST>
    <PARENT>Purchase Accounts</PARENT>
    <AFFECTSSTOCK>No</AFFECTSSTOCK>
    <USEFORVAT>No</USEFORVAT>
</MASTER>

Step 2 — Write the Voucher tags

The quickest way to get the exact tags Tally expects for a voucher is to let Tally generate them for you: enter one sample Purchase Voucher manually in Tally Prime, then export it as Gateway of Tally >> Display >> Daybook >> Alt+E. This produces a Daybook.xml file — open it and look inside the <TALLYMESSAGE> tag for the voucher structure Tally actually uses (see udiMagic XML tags for how udiMagic's COLUMNREFERENCE attribute then maps each of those tags back to your Excel columns).

A Purchase Voucher without inventory maps to something like this:

<VOUCHER>
    <!-- A unique identifier for each record -->
    <GUID FORMULA="=&quot;1d2e&quot; &amp; A# &amp; &quot;-&quot; &amp; B#"/>
    <DATE COLUMNREFERENCE="B"/>
    <EFFECTIVEDATE COLUMNREFERENCE="B"/>
    <VOUCHERTYPENAME>Purchase</VOUCHERTYPENAME>
    <VOUCHERNUMBER COLUMNREFERENCE="A"/>
    <REFERENCE COLUMNREFERENCE="A"/>
    <NARRATION COLUMNREFERENCE="E"/>
    <ISINVOICE>No</ISINVOICE>

    <!-- Purchase A/c is to be Debited -->
    <ALLLEDGERENTRIES.LIST>
        <LEDGERNAME COLUMNREFERENCE="D"/>
        <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
        <AMOUNT FORMULA="=+Round(F#,2)*-1"/>
    </ALLLEDGERENTRIES.LIST>

    <!-- Supplier A/c is to be Credited -->
    <ALLLEDGERENTRIES.LIST>
        <LEDGERNAME COLUMNREFERENCE="C"/>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT FORMULA="=+Round(F#,2)*1"/>
        <BILLALLOCATIONS.LIST>
            <NAME COLUMNREFERENCE="A"/>
            <BILLTYPE>New Ref</BILLTYPE>
            <AMOUNT FORMULA="=+Round(F#,2)*1"/>
        </BILLALLOCATIONS.LIST>
    </ALLLEDGERENTRIES.LIST>
</VOUCHER>

---