Exercise 3

Sales Vouchers Without Inventory

Published 11 Sep 2026

---

This exercise imports Sales Vouchers that don't carry stock item line items — just an invoice-level amount against a Sales Ledger. It's the simplest possible voucher import, and a good first voucher exercise before tackling item-wise sales.

The Excel sheet

---

Step 1 — Create the Ledger masters

Column C (Party Name) and Column D (Sales Ledger) both need a matching Ledger master in Tally before the voucher can post — udiMagic processes MASTER tags before VOUCHER tags, so both ledgers get created automatically in the same import if they don't already exist.

<!-- Party Ledger, created under Sundry Debtors -->
<MASTER TYPE="LEDGER">
    <NAME.LIST>
        <NAME COLUMNREFERENCE="C"/>
    </NAME.LIST>
    <PARENT>Sundry Debtors</PARENT>
</MASTER>

<!-- Sales Ledger, created under Sales Accounts -->
<MASTER TYPE="LEDGER">
    <NAME.LIST>
        <NAME COLUMNREFERENCE="D"/>
    </NAME.LIST>
    <PARENT>Sales Accounts</PARENT>
</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 Sales 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 Sales Voucher without inventory maps to something like this:

<VOUCHER>
    <DATE COLUMNREFERENCE="B"/>
    <VOUCHERTYPENAME>Sales</VOUCHERTYPENAME>
    <VOUCHERNUMBER COLUMNREFERENCE="A"/>
    <NARRATION COLUMNREFERENCE="E"/>
    <ALLLEDGERENTRIES.LIST>
        <!-- Party Ledger — debited with the invoice amount -->
        <LEDGERNAME COLUMNREFERENCE="C"/>
        <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
        <AMOUNT COLUMNREFERENCE="F"/>
    </ALLLEDGERENTRIES.LIST>
    <ALLLEDGERENTRIES.LIST>
        <!-- Sales Ledger — credited with the invoice amount -->
        <LEDGERNAME COLUMNREFERENCE="D"/>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT FORMULA="=-F#"/>
    </ALLLEDGERENTRIES.LIST>
</VOUCHER>

---