Exercise 15

Cash Payment Voucher

Published 15 Oct 2026

---

This exercise imports Cash Payment Vouchers — expenses paid in cash — from Excel into Tally Prime. Each row is one voucher: the expenses are spread across several columns (one column per expense ledger) and the Total is credited to Cash. It builds on the Cash Receipt Vouchers exercise, and shows how SCROLLHORIZONTALLY reads the expense columns one after another and how SKIP ignores the empty ones.

The Excel sheet

The expense ledger names are the column headings from column E onward. An empty cell means that expense does not apply to that voucher.

Step 1 — Create the Expense Ledger masters

SCROLLHORIZONTALLY repeats the MASTER tag for every column starting from column E, moving to the right, for as long as the condition holds true — here, until a column has no heading. Columns whose amount is zero are skipped through SKIP. The ledger name is the heading in row 1 (E$1), and the group is fixed as "Expenses Indirect".

<!--  Master for the Expense Ledger
    Uses SCROLLHORIZONTALLY to read all the columns starting from Column E, moving to the right, for
    as long as a condition holds true.
-->
<MASTER TYPE="LEDGER" SKIP="=+Round(E#,2)=0" SCROLLHORIZONTALLY="=Len(trim(E$1))>0">
    <NAME.LIST>
        <NAME FORMULA="=+E$1"/>
    </NAME.LIST>
    <!--  Group is fixed here  -->
    <PARENT>Expenses Indirect</PARENT>
    <ISBILLWISEON>No</ISBILLWISEON>
    <AFFECTSSTOCK>No</AFFECTSSTOCK>
    <ISCOSTCENTRESON>No</ISCOSTCENTRESON>
</MASTER>

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

Step 2 — Write the Voucher tags

The voucher is a Payment voucher. The same SCROLLHORIZONTALLY and SKIP attributes are used on the ALLLEDGERENTRIES.LIST tag, so one debit entry is created for every expense column that has an amount. The amount is multiplied by -1 and ISDEEMEDPOSITIVE set to "Yes" (debit). The last entry credits the ledger named in column C (Cash) with the Total from column D (ISDEEMEDPOSITIVE "No").

<VOUCHER>
    <GUID FORMULA="=A# & &quot;-&quot; & B# & &quot;-&quot; & "payment""/>
    <DATE COLUMNREFERENCE="B"/>
    <EFFECTIVEDATE COLUMNREFERENCE="B"/>
    <VOUCHERTYPENAME>Payment</VOUCHERTYPENAME>
    <VOUCHERNUMBER COLUMNREFERENCE="A"/>
    <!--  
        Ledger Entries for the Expenses: Starting from Column E, keep reading columns one after another, moving to the right, for
        as long as a condition holds true.
        - Stop when a column has no heading.
        - Skip if the amount in the column is zero.
    -->
    <ALLLEDGERENTRIES.LIST SKIP="=+Round(E#,2)=0" SCROLLHORIZONTALLY="=Len(trim(E$1))>0">
        <LEDGERNAME FORMULA="=+E$1"/>
        <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
        <AMOUNT FORMULA="=ROUND(E#,2)*-1"/>
    </ALLLEDGERENTRIES.LIST>
    <!-- Cash or Bank ledger -->
    <ALLLEDGERENTRIES.LIST>
        <LEDGERNAME FORMULA="=+C#"/>
        <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
        <AMOUNT FORMULA="=ROUND(D#,2)"/>
    </ALLLEDGERENTRIES.LIST>
    </VOUCHER>
</XMLTAGS>

---