Cash Receipt Vouchers

Published 11 Sep 2026

This exercise imports Cash Receipt Vouchers — money received against a Party or an Income ledger — from Excel into Tally Prime. It follows the same pattern as the Sales Vouchers exercise: create the Ledger masters first, then write the Voucher tags.

A typical Excel sheet

A Cash Receipt sheet usually carries one row per receipt, laid out like this:

Step 1 — Create the Ledger masters

<!-- Party / Income Ledger the receipt is against -->
<MASTER TYPE="LEDGER">
    <NAME.LIST>
        <NAME COLUMNREFERENCE="B"/>
    </NAME.LIST>
    <PARENT>Sundry Debtors</PARENT>
</MASTER>

The Cash ledger normally already exists in every Tally company under the built-in "Cash-in-Hand" group, so it usually doesn't need a MASTER tag of its own.

Step 2 — Write the Voucher tags

As with any voucher type, the safest way to get the exact tags Tally expects is to enter one sample Cash Receipt manually in Tally Prime and export it via Gateway of Tally >> Display >> Daybook >> Alt+E — then match the tags inside <TALLYMESSAGE> against your Excel columns using COLUMNREFERENCE (see udiMagic XML tags). A Cash Receipt typically maps to something like this:

<VOUCHER>
    <DATE COLUMNREFERENCE="A"/>
    <VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
    <NARRATION COLUMNREFERENCE="C"/>
    <ALLLEDGERENTRIES.LIST>
        <!-- Cash — debited with the amount received -->
        <LEDGERNAME>Cash</LEDGERNAME>
        <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
        <AMOUNT COLUMNREFERENCE="D"/>
    </ALLLEDGERENTRIES.LIST>
    <ALLLEDGERENTRIES.LIST>
        <!-- Party / Income Ledger — credited with the amount received -->
        <LEDGERNAME COLUMNREFERENCE="B"/>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT FORMULA="=-D#"/>
    </ALLLEDGERENTRIES.LIST>
</VOUCHER>