Free tools for CAs & accountants
Freight Invoice to Tally Prime XML Converter
Paste your freight invoices from Excel and download a file Tally Prime can import as sales vouchers, with the right GST ledgers.
Rules last checked 16 November 2026. A guide, not tax advice: confirm with your CA for your case.
Freight invoices
- Vouchers
- 3
- Parties
- 3
- Invoice total
- ₹2,29,925.00
<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>Vouchers</REPORTNAME>
<STATICVARIABLES></STATICVARIABLES>
</REQUESTDESC>
<REQUESTDATA>
<TALLYMESSAGE xmlns:UDF="TallyUDF">
<VOUCHER VCHTYPE="Sales" ACTION="Create" OBJVIEW="Accounting Voucher View">
<DATE>20261117</DATE>
<VOUCHERTYPENAME>Sales</VOUCHERTYPENAME>
<VOUCHERNUMBER>GB/26-27/001</VOUCHERNUMBER>
<REFERENCE>GB/26-27/001</REFERENCE>
<PARTYLEDGERNAME>Shree Balaji Traders</PARTYLEDGERNAME>
<PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW>
<NARRATION>Jaipur to Surat</NARRATION>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Shree Balaji Traders</LEDGERNAME>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<ISPARTYLEDGER>Yes</ISPARTYLEDGER>
<AMOUNT>-50925.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Freight Income</LEDGERNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<AMOUNT>48500.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Output CGST</LEDGERNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<AMOUNT>1212.50</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Output SGST</LEDGERNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<AMOUNT>1212.50</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
<TALLYMESSAGE xmlns:UDF="TallyUDF">
<VOUCHER VCHTYPE="Sales" ACTION="Create" OBJVIEW="Accounting Voucher View">
<DATE>20261118</DATE>
<VOUCHERTYPENAME>Sales</VOUCHERTYPENAME>
<VOUCHERNUMBER>GB/26-27/002</VOUCHERNUMBER>
<REFERENCE>GB/26-27/002</REFERENCE>
<PARTYLEDGERNAME>Mahavir Steel</PARTYLEDGERNAME>
<PERSISTEDVIEW>Accounting Voucher View</PERSISTEDVIEW>
<NARRATION>Mumbai to Delhi</NARRATION>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Mahavir Steel</LEDGERNAME>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<ISPARTYLEDGER>Yes</ISPARTYLEDGER>
<AMOUNT>-147500.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Freight Income</LEDGERNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<AMOUNT>125000.00</AMOUNT>
</ALLLEDGERENTRIES.LIST>
<ALLLEDGERENTRIES.LIST>
<LEDGERNAME>Output IGST</LEDGERNAME>
<ISDEEMEDPOSI
…Create the party and tax ledgers in Tally first (the ledger template tool lists them), and keep the ledger names exactly as typed here. Tally skips a voucher whose ledger it cannot find. Try it on a test company before your live books.
Add this tool to your website or blog
Free for CA firms, associations and bloggers. Pick where you’ll paste it, copy, done.
Recommended. Works on WordPress, Blogger, Wix, Webflow, Squarespace and plain HTML. Fits its own height automatically.
<div data-bilty-tool="freight-invoice-to-tally-xml"><a href="https://getbilty.in/tools/freight-invoice-to-tally-xml">Freight Invoice to Tally Prime XML Converter by getBilty</a></div> <script async src="https://getbilty.in/embed/v1.js" integrity="sha384-paQi8Gf5HXoUubYwxVp8sgPzBaTCRkQcp994KUXDEkJFJXe/XrJTPKeMME5QotFA" crossorigin="anonymous"></script>
Where do I paste it?
- WordPress: add a "Custom HTML" block, then paste.
- Blogger: switch the post to "HTML view", then paste where you want the tool.
- Wix: Add → Embed code → "Embed HTML", then paste.
- Webflow / Squarespace: add an "Embed" or "Code" block, then paste.
- Not sure what your site uses? Look for a block called "HTML", "Embed" or "Code". If scripts are not allowed, use the "No-script" tab.
Safe to embed: the tool runs in a sandboxed frame, so it cannot read or change anything on your page.
How the import file is built
Each invoice becomes one sales voucher. The party is debited for the invoice total, freight income is credited for the taxable amount and each tax ledger is credited for its share, so every voucher balances to zero.
Dates are converted to Tally’s YYYYMMDD form and special characters in names are escaped so a name like Shah & Sons does not break the file.
Frequently asked questions
What do I need in Tally before importing?
The party ledgers, the freight income ledger and the CGST, SGST and IGST ledgers, with the same names you typed in the tool. Tally skips a voucher when a ledger name does not match. The ledger template tool lists the ones a transporter needs.
How do I import the file?
In Tally Prime go to Import (Alt+O), then Data. Choose the XML file and set Behaviour to Ignore Duplicates or Modify as you prefer. Try a test company first.
How are CGST and SGST split?
Tax is worked out on the taxable amount, rounded to paise, then halved. SGST takes any odd paisa so the two always add back to the whole. For inter-state rows the full tax goes to IGST.
What about reverse-charge bills?
Put 0 as the GST rate. The voucher then has only the party and freight ledgers and no tax ledger, which is how a GTA bill under reverse charge looks. Record the recipient’s own liability in their books.
Is my data uploaded?
No. The file is built in your browser and never sent to a server.
Law behind this tool
- Tally Prime XML import format — Voucher and ledger entries follow Tally’s documented import structure; confirm with a test company, as Tally releases can differ.
More free tools for CAs & transporters
Who pays GST on road freight, at 5% or 18%, and what the invoice must say.
1% or 2% TDS, the ₹30,000 and ₹1,00,000 limits and the 10-truck exemption.
Fill in and download the no-TDS declaration a transporter gives with PAN.
Deemed income per truck: ₹1,000 per ton a month for heavy vehicles, ₹7,500 for others.
Every GSTR, TDS and Annexure V date for the year. Add it to your calendar.
Type an amount, copy it in words for an invoice or cheque, in English or Hindi.
Every ledger a transport business needs in Tally, under the right group. Excel and import XML.
The invoice you raise yourself when an unregistered transporter charges you freight.
Last day to pay a micro or small supplier, and whether the deduction is at risk.
Paste a party ledger and get the ageing buckets for every party. Download as CSV.
Search the SAC codes for freight, truck rental, hamali, warehousing and GTA services.
Your transporter clients still on paper or Excel?
getBilty makes the bilty, GST invoice and party ledger in one place, with the right GTA tax treatment on every bill. Free 14-day trial.
- No credit card required
- 14-day full free trial
- Works on mobile & WhatsApp
- GST & E-Way Bill ready
Want to talk to someone first?
Leave your mobile number. A transport desk specialist will call you back soon and help you with your questions.