Payment, Receipt & Journal Voucher to Tally XML — Free Converter
Convert your Excel payment, receipt, journal, and contra entries directly into Tally Prime import XML. Unlike GST-invoice-based Purchase/Sales tools, this handles simple double-entry vouchers — cash payments, bank receipts, journal adjustments, and fund transfers. The built-in Auto-Create Ledgers feature saves time by embedding missing ledger definitions in the same XML, so you can create ledgers and import vouchers in a single step.
1 Company Name & Settings
Saved automatically in your browser. Leave blank to import into any open company.
Auto-Create Missing Ledgers
When ON, ledger master blocks are added to the XML for any row that has a Debit/Credit Group specified.
Uses ACTION="Alter" — safe to re-import without duplicate ledger errors.
2 Download the Excel Template
9 columns: Date · VoucherType · VoucherNo · DebitLedger · DebitGroup · CreditLedger · CreditGroup · Amount · Narration
The template includes a strict VoucherType dropdown (Payment, Receipt, Journal, Contra) and a soft Group dropdown from the standard Tally group list.
3 Upload Your Filled Excel File
Drag & Drop your Excel file here
or click to browse (.xlsx, .xls)
📋 What this tool handles:
- • Payment: Cash/bank going out (e.g. vendor payment, expense)
- • Receipt: Cash/bank coming in (e.g. customer payment, income)
- • Journal: Non-cash adjustments (e.g. depreciation, provisions)
- • Contra: Fund transfers between Cash & Bank ledgers
- • Auto-Create Ledgers: Adds ledger blocks inline — one import for both ledgers & vouchers
4 Preview & Validate
Showing first 10 rows. All rows will be processed.
5 Generate & Download XML
Review the summary above, then click to generate your Tally-ready Voucher XML file.
Press Ctrl+D to Bookmark this free tool for your daily accounting.
No signup required. 100% Free forever.
How to Use the Payment, Receipt & Journal XML Creator
Follow these steps to convert your voucher data to Tally XML:
-
1
Download and fill the Excel template
Click "Download Template" above. Open in Excel or Google Sheets. Each row = one voucher entry. The template has 9 columns — only Date, VoucherType, DebitLedger, CreditLedger, and Amount are required.
-
2
Select the correct VoucherType from the dropdown
The VoucherType column has a strict dropdown — you must pick exactly one of these four values:
Payment — Money going out. e.g. rent paid, vendor payment, staff salaryReceipt — Money coming in. e.g. customer payment received, interest incomeJournal — Non-cash adjustments. e.g. depreciation, TDS liability, provisionsContra — Fund transfer between Cash & Bank ledgers only -
3
Fill DebitGroup and CreditGroup (only if using Auto-Create Ledgers)
The DebitGroup and CreditGroup columns are optional. They are only needed when the "Auto-Create Missing Ledgers" toggle is ON — each ledger name that has a Group specified will get a
LEDGERmaster block in the XML. Leave them blank for ledgers that already exist in Tally. The Group column has a soft dropdown with all standard Tally groups, but you can type any valid group name. -
4
Upload, preview, and download
Upload the filled Excel file. Review the preview table — rows with errors are highlighted in red. Check the error count in the toast notification. Then click "Generate Voucher XML" to download your file.
Understanding Auto-Create Missing Ledgers
What it does
When enabled, the tool scans all rows for DebitLedger + DebitGroup and CreditLedger + CreditGroup pairs. For each unique ledger name that has a Group specified, it generates a LEDGER master block in the same XML, placed before the voucher entries.
✅ Safe to re-import
Uses ACTION="Alter" (not Create). If the ledger already exists in Tally, it updates harmlessly. No duplicate-ledger errors on the second import.
⚠️ Group is required
Ledgers without a Group column value are silently skipped from auto-creation. The voucher row is still processed, but Tally will error on import if that ledger doesn't already exist.
🏷️ One import for both
The same single XML file handles both ledger creation and voucher creation. Import it once via Import → Transactions and Tally processes ledgers first, then vouchers.
How to Import This XML into Tally Prime
Once you've downloaded the XML file, follow these steps inside Tally Prime:
-
1
Open Tally Prime and select your Company. Make sure any ledgers referenced in the file already exist in Tally (or enable Auto-Create Ledgers with Group values filled).
-
2
Go to Import (Alt+O) → Transactions. (In older Tally ERP 9: Gateway of Tally → Import of Data → Vouchers). Do not use the Masters path — that is only for the standalone Ledger Master XML Creator tool.
-
3
Browse to the downloaded XML file (e.g.
Tally_Vouchers_1234567890.xml) and press Enter. -
4
Tally processes the import. If Auto-Create Ledgers was ON, it will first create/update the ledgers, then import the vouchers. On success it displays "Vouchers created: X".
-
5
Verify: Go to Day Book to check all vouchers. If you see ledger-not-found errors, check that the ledger names in your Excel match exactly what's in Tally (case-sensitive).
Excel Template Column Guide
All 9 columns in the Payment/Receipt/Journal template explained:
| Column | Required? | Example | Notes |
|---|---|---|---|
| Date | Required | 01/04/2026 | DD/MM/YYYY, YYYY-MM-DD, DD-MM-YYYY, or Excel serial date. Timezone-safe parsing — no off-by-one errors. |
| VoucherType | Required | Payment | Must be exactly: Payment, Receipt, Journal, or Contra. The template has a strict Excel dropdown. Case is normalized automatically. |
| VoucherNo | Optional | PV-001 | Optional voucher reference number. Leave blank to use Tally's auto-numbering. |
| DebitLedger | Required | Rent Expense | The ledger to be debited. Must match the exact ledger name in Tally (case-sensitive). |
| DebitGroup | Auto-Create | Indirect Expenses | Required only if Auto-Create Ledgers is ON. The Tally parent group for the Debit Ledger. Template has a soft dropdown with all 29 standard groups. |
| CreditLedger | Required | SBI Current A/c | The ledger to be credited. Must match the exact ledger name in Tally (case-sensitive). |
| CreditGroup | Auto-Create | Bank Accounts | Required only if Auto-Create Ledgers is ON. The Tally parent group for the Credit Ledger. |
| Amount | Required | 15000 | Numeric value only. Must be positive and greater than zero. Formatted to 2 decimal places automatically. No commas. |
| Narration | Optional | Paid April rent | Transaction description stored in Tally's NARRATION field. Special characters (&, <, >, etc.) are escaped automatically. |
💡 Need ledgers with full GST details instead?
This tool's Auto-Create Ledgers feature creates basic ledgers (name + group) as a convenience. For ledgers that need full GSTIN, address, PAN, opening balance, and GST registration type — especially customers and suppliers for Purchase/Sales vouchers — use the dedicated Ledger Master tool:
📒Ledger Master XML Creator →
Bulk-create ledgers with GSTIN auto-fill, address, opening balance — full detail
Payment, Receipt & Journal Tool — FAQ
What voucher types are supported?
This tool supports four voucher types: Payment (money going out — vendor payments, expenses, salary), Receipt (money coming in — customer payments, income), Journal (non-cash adjustments — depreciation, TDS entries, provisions, interest accruals), and Contra (transfers between Cash and Bank ledgers only). These cover all simple double-entry transactions that don't use GST invoice format.
What does Auto-Create Missing Ledgers do exactly?
When the toggle is ON, the tool scans all your data rows for DebitLedger+DebitGroup and CreditLedger+CreditGroup pairs. For each unique ledger name that has a Group column value filled, it generates a LEDGER master block using ACTION="Alter" and places it before the voucher entries in the same XML file. When you import this file into Tally via Import → Transactions, Tally processes the ledger masters first, then the vouchers — so both happen in a single import step.
Is it safe to re-import the same file twice?
Yes — for the ledger creation part. The tool uses ACTION="Alter" for all auto-created ledger blocks. This means if the ledger already exists in Tally, Tally will update it harmlessly (no error). In contrast, ACTION="Create" would throw a "ledger already exists" error on the second import. The voucher entries themselves will be duplicated in Tally if re-imported — so verify your Day Book after import and only re-import if needed.
Do I need to know the exact Tally Group name?
The template provides a soft dropdown on the DebitGroup and CreditGroup columns with all 29 standard Tally parent groups (Bank Accounts, Sundry Debtors, Sundry Creditors, Indirect Expenses, etc.) sourced from a hidden Reference sheet. "Soft" means you can still type any custom group name that's not in the list — if you have custom groups in your Tally company. The exact name must match what's in your Tally company for the ledger to be created under the correct group.
What's the difference between this and the Bank Statement tool?
The Bank Statement Converter is designed specifically for parsing bank statement exports — it has columns for Withdrawal/Deposit (not Debit/Credit Ledger), automatically detects Payment vs Receipt based on which column has a value, and generates Advanced Bank Entries format with BANKALLOCATIONS for bank reconciliation in Tally. This tool is for manual/any-source double-entry data where you specify both ledgers explicitly per row — useful for journal entries, contra vouchers, and vouchers from non-bank sources. Use the Bank Statement tool for bank exports; use this tool for everything else.
What's the difference between this and the Ledger Master tool?
The Ledger Master XML Creator is a standalone tool for bulk-creating ledger accounts with full details: GSTIN, address, PAN, opening balance, GST registration type — ideal for party ledgers (customers/suppliers) before importing Purchase/Sales vouchers. This tool's Auto-Create Ledgers feature is a convenience shortcut that creates basic ledgers (just name + group) embedded in the same voucher XML. Recommendation: use the Ledger Master tool first for any GST-registered party ledgers, then use this tool for the voucher import.