Integrate a Receipt Voucher Entry Module with Tally Prime (using udiMagic)

Published · Updated

This article illustrates how to integrate the "Receipt Voucher entry" module of your Software with the Tally Software. Each field on the Receipt entry screen — voucher type, date, receipt number, party ledger, narration and the ledger amounts — corresponds to a Tally XML tag. udiMagic builds that XML from your data and sends it to Tally Prime to create the Receipt voucher.

CAUTION

The Receipt entry

To begin with, consider a Receipt Voucher entry done manually in Tally Prime. The following input is required:

Voucher Type Receipt
Date 01-Apr-2025
Receipt No 1
Account Cash
Particulars Shweta Softwares
Amount 1000
Narration Received a sum of...

Field → Tally XML tag mapping

To identify the related fields in your database, the table below maps each Tally XML tag to a sample value. Fill in the last column with the matching field name from your table.

Tally XML Tag XML Tags Example Field name in your table
(fill in this space)
<VOUCHERTYPENAME> <VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
<DATE> <DATE>01-Apr-2025</DATE>
<VOUCHERNUMBER> <VOUCHERNUMBER>1</VOUCHERNUMBER>
<PARTYLEDGERNAME> <PARTYLEDGERNAME>Shweta Softwares</PARTYLEDGERNAME>
<NARRATION> <NARRATION>Received a sum of...</NARRATION>
<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>
<LEDGERNAME>
<AMOUNT>
</ALLLEDGERENTRIES.LIST> 		This section contains the Credit Ledger A/c details:

<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERNAME>Shweta Softwares</LEDGERNAME>
<AMOUNT>1000</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>
<LEDGERNAME>
<AMOUNT>
</ALLLEDGERENTRIES.LIST> 		This section contains the Debit Ledger A/c details:

<ALLLEDGERENTRIES.LIST>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<LEDGERNAME>Cash</LEDGERNAME>
<AMOUNT>-1000</AMOUNT>
</ALLLEDGERENTRIES.LIST>

Remarks

  1. The accounting effect of the above entry is:
    Cash A/c — 1000 Dr
    Shweta Softwares A/c — 1000 Cr
  2. Party account credited. The party A/c Shweta Softwares is credited, so the <AMOUNT> is shown as POSITIVE and <ISDEEMEDPOSITIVE> is set to No.
  3. Cash account debited. The Cash A/c is debited, so the <AMOUNT> is shown as NEGATIVE and <ISDEEMEDPOSITIVE> is set to Yes.

GUID (RemoteID)

GUID is a 16-byte number used to uniquely identify a record in a database. It is passed to Tally Prime as the REMOTEID attribute and the <GUID> tag on the voucher, so that re-sending the same record updates the existing voucher instead of creating a duplicate.

For more information, see What is Unique ID?

XML tags for Receipt Voucher entry (for Tally Prime)

The XML tags required for creating the Receipt Voucher as per the illustration above are given below. The values that udiMagic fetches from your database are marked with comments.

<ENVELOPE>
  <HEADER>
    <TALLYREQUEST>Import Data</TALLYREQUEST>
  </HEADER>
  <BODY>
    <IMPORTDATA>
      <REQUESTDESC>
        <REPORTNAME>All Masters</REPORTNAME>
      </REQUESTDESC>
      <REQUESTDATA>
        <TALLYMESSAGE xmlns:UDF="TallyUDF">
          <!-- REMOTEID / GUID: unique id fetched from your database -->
          <VOUCHER REMOTEID="7811598w-849g-790n-221j-562536936384-00000002" VCHTYPE="Receipt" ACTION="Create">
            <ISOPTIONAL>No</ISOPTIONAL>
            <USEFORGAINLOSS>No</USEFORGAINLOSS>
            <USEFORCOMPOUND>No</USEFORCOMPOUND>
            <!-- voucher type fetched from your database -->
            <VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
            <!-- date fetched from your database (format YYYYMMDD) -->
            <DATE>20250401</DATE>
            <EFFECTIVEDATE>20250401</EFFECTIVEDATE>
            <ISCANCELLED>No</ISCANCELLED>
            <USETRACKINGNUMBER>No</USETRACKINGNUMBER>
            <ISPOSTDATED>No</ISPOSTDATED>
            <ISINVOICE>No</ISINVOICE>
            <DIFFACTUALQTY>No</DIFFACTUALQTY>
            <NARRATION/>
            <ASPAYSLIP>No</ASPAYSLIP>
            <!-- GUID: unique id fetched from your database -->
            <GUID>7811598w-849g-790n-221j-562536936384-00000002</GUID>
            <!-- reference / receipt number fetched from your database -->
            <REFERENCE>1</REFERENCE>
            <!-- party ledger name fetched from your database -->
            <PARTYLEDGERNAME>Shweta Softwares</PARTYLEDGERNAME>

            <LEDGERENTRIES.LIST>
              <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
              <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
              <LEDGERFROMITEM>No</LEDGERFROMITEM>
              <TAXCLASSIFICATIONNAME/>
              <!-- credit ledger name fetched from your database -->
              <LEDGERNAME>Shweta Softwares</LEDGERNAME>
              <!-- credit amount fetched from your database (POSITIVE) -->
              <AMOUNT>1000.00</AMOUNT>
            </LEDGERENTRIES.LIST>

            <LEDGERENTRIES.LIST>
              <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
              <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
              <LEDGERFROMITEM>No</LEDGERFROMITEM>
              <TAXCLASSIFICATIONNAME/>
              <!-- debit ledger name fetched from your database -->
              <LEDGERNAME>Cash</LEDGERNAME>
              <!-- debit amount fetched from your database (NEGATIVE) -->
              <AMOUNT>-1000.00</AMOUNT>
            </LEDGERENTRIES.LIST>

          </VOUCHER>
        </TALLYMESSAGE>
      </REQUESTDATA>
    </IMPORTDATA>
  </BODY>
</ENVELOPE>

Once the XML is ready, udiMagic sends it to Tally Prime to create the Receipt voucher.

Ready to import your Excel data into Tally?

Download udiMagic and start a 14-day free trial — no credit card required.

Download udiMagic View Pricing