Bulk-import journal vouchers from Excel into Tally with udiMagic — accurate ledger mapping, cost centre support, and multi-reference journals made simple.
Importing journal entries into Tally becomes far easier when your accounting data already lives in Excel. udiMagic is an Excel-to-Tally import utility built to move bulk accounting data—Journal, Receipt, Payment, and Contra transactions—directly into Tally using standard voucher templates. Beyond ready-made formats, udiMagic also supports custom template mapping, so even spreadsheets that don't match a standard layout can still be imported accurately.
For journal entries specifically, the goal isn't just moving rows from Excel into Tally—it's ensuring each row represents a valid accounting transaction, with the correct voucher date, ledgers, amounts, and narration. Whether you need a simple single debit-credit entry or a complex journal with multiple ledgers, cost centres, and bill-by-bill references, udiMagic's standard templates offer the right structure for the job.
Import straightforward one-debit, one-credit journal vouchers into Tally with the Single-line-entry Basic template. Supports multi-currency entries with automatic rate of exchange conversion, plus multi-company imports from a single Excel file. Perfect for high-volume, low-complexity journal accounting entries.
Using the Single-line-entry Advanced template, get everything in the Basic format plus full Cost Category and Cost Centre support on both the debit and credit ledgers. Ideal for expense allocations, project-based cost tracking where each transaction must be attributed to a specific cost centre for accurate reporting.
The Journal with Multiple References template lets you import journals with up to 10 debit or credit ledgers in a single voucher, complete with bill-by-bill reference tracking for each ledger. Data is entered horizontally across columns, making it ideal entries affecting several accounts at once.
The Financial Transactions Advanced template lets you enter each ledger line as its own row, linked by a shared Unique ID, for journals with many lines per voucher. Supports multiple bill-by-bill references, multiple Cost Categories and Cost Centres, and multi-currency and multi-company imports — ideal for complex, row-wise journal entry and easy auditing.
With the Horizontal Financial Transactions template, map as many debit or credit ledgers as your transaction needs — limited only by Excel's maximum column count. No fixed ledger cap means this format scales effortlessly for large migrations.