udiMagic Excel templates

Download all the Standard excel templates for the latest udiMagic version (including templates for older versions).

Download udiMagic Standard Templates

For reference, a list of latest excel templates is given underneath :-

Template Name Voucher types Supported Other Features Remarks
Vouchers-V11-Stock-Journal.xls Stock Journal For uploading Consumption, Production entries.
Vouchers-V12-Sales-Purchase-Without-Stockitems-Basic.xls Sales, Purchase, Debit Note, Credit Note Basic format with GST, without Inventory
Vouchers-V12-Sales-Purchase-Without-Stockitems-Advanced.xls Sales, Purchase, Debit Note, Credit Note GST, Cost Centre, Cost Category
Vouchers-V12-Sales-Purchase-With-Stockitems-Basic.xls Sales, Purchase, Debit Note, Credit Note Basic format with GST Can be used with or without StockItems.
Vouchers-V12-Sales-Purchase-With-Stockitems-Advanced.xls Sales, Purchase, Debit Note, Credit Note, Sales Order, Purchase Order, Delivery Note, Receipt Note GST, StockItem, Godown, Tracking-No, Batch-No, Despatch-details, Buyer-details Can be used with or without StockItems.
Vouchers-V11-Receipts-and-Payments-with-multiple-references.xls Receipt, Payment, Journal Multiple Refs or Bill by Bill E-Commerce Settlement / Receipt / Journal entries. Useful for Flipkart, Amazon, Snapdeal.
Vouchers-V11-Physical-Stock-Journal.xls Physical Stock Journal For uploading the Physical Stock qty.
Vouchers-V11-Journal-with-multiple-references.xls Receipt, Payment, Journal Multiple Refs or Bill by Bill E-Commerce Settlement / Receipt / Journal entries. Useful for Flipkart, Amazon, Snapdeal.
Vouchers-V12-Horizontal-Sales-Without-Stockitems.xls Sales, Credit Note GST Useful for uploading Sales without Items. Variable columns.
Vouchers-V12-Horizontal-Purchase-Without-Stockitems.xls Purchase, Debit Note GST Useful for uploading Purchase without Items. Variable columns.
Vouchers-V11-Horizontal-Financial-Transactions.xls Receipts, Payment, Journal, Contra Multiple Debit and Credit Ledgers Horizontal format with multiple Dr,Cr ledgers. Useful for uploading Expenses / other vouchers. Variable columns.
Vouchers-V11-Financial-Transactions-Single-line-entry-Basic.xls Receipts, Payment, Journal, Contra One Debit, Credit Ledger Ledgers appear Column-wise / horizontal format.
Vouchers-V11-Financial-Transactions-Single-line-entry-Advanced.xls Receipts, Payment, Journal, Contra One Debit, Credit Ledger with Cost Category, Cost Centre Ledgers appear Column-wise / horizontal format.
Vouchers-V11-Financial-Transactions-Basic.xls Receipts, Payment, Journal, Contra Basic format Ledgers appear Row-wise / vertical format.
Vouchers-V11-Financial-Transactions-Advanced.xls Receipts, Payment, Journal, Contra Multiple Ref or Bill by Bill; Cost Category, Cost Centre Vertical format with ledgers having multiple Refs; Cost Category, Cost Centre
Vouchers-V11-Bank-statement.xls Receipts, Payment, Contra With 2 columns for Debit/Credit amount.
Vouchers-V11-Bank-statement-Single-Column-Dr-Cr.xls Receipts, Payment, Contra With 1 column for Debit/Credit amount.
Master-UnitMaster.xls
Master-StockItemMaster.xls GST Includes StockGroup, Category, Alternate units, Default Ledgers and VAT Class etc
Master-StockGroupMaster.xls
Master-StockCategoryMaster.xls
Master-LedgerMaster.xls GST Includes Opening Balance, Bill by bill, Contact details etc
Master-GSTClassification.xls
Master-GroupMaster.xls
Master-GodownMaster.xls
Master-Employee.xls
Master-CostCentreMaster.xls
Master-CostCategoryMaster.xls
Master-Budgets.xls

Other Excel to Tally templates
Bank templates
Multi-Currency in Tally
Amazon Sales