Purchase with Inventory
Import Purchase and Debit Note vouchers with stock item, quantity, rate, batch, and inventory details using the supplied Purchase templates with stock items.
Import Purchase vouchers from Excel to Tally Prime — Stock, Godown, Batch & GST Ready
Move your purchase bills from Excel straight into Tally Prime. Keep purchase details such as suppliers, GST, stock items, and bill amounts organized while reducing repetitive data entry.
Recording every Purchase Voucher by hand in Tally Prime takes time and can lead to mistakes, especially when supplier invoices, item details, and GST amounts already exist in Excel sheet. udiMagic lets you import Purchase Vouchers directly from Excel or CSV into Tally Prime, with correct party, item, quantity, rate, and tax details.
For accountants, business owners, and implementation teams handling bulk Purchase data, udiMagic provides ready-to-use Excel templates mapped to standard Tally voucher fields. You can import accounting-only Purchase Vouchers or entries with stock items, apply Multi GST details, include the Order Number where required, and record Purchase Returns as Debit Notes. This workflow helps end users move Excel-based purchase information into Tally more efficiently.
Core Features
Purchase without Inventory
Import accounting-based Purchase Vouchers using supplier, purchase ledger, and GST details, without stock item tracking, through the standard no-stock Purchase templates.
Multi GST Purchase
Use Purchase templates with IGST, CGST, and SGST columns to record multiple GST rates in a single Purchase Voucher, matching your Tally tax configuration.
Additional Ledgers
Add extra ledger columns in the Purchase templates for freight, discounts, or other charges linked to a Purchase Voucher, alongside the main purchase ledger entries.
Debit Note for Purchase Return
Record Purchase Return transactions as Debit Notes using the voucher type, reference number, date, and original Purchase Voucher details in the supplied template.
Supplier Details
Import optional Supplier Details such as name, address, pin code, state, and GSTIN with a Purchase Voucher when the invoice differs from the main Party Ledger.
Cost Centre Details
Use the Advanced Purchase templates with Cost Category and Cost Centre fields when your Purchase Voucher data needs allocation across departments or projects.
Bulk Purchase Import
Process large volumes of Purchase Voucher records from Excel or CSV through the udiMagic Tally import workflow, instead of entering each voucher manually.
Order Number Needed
Enter the Order Number in the Purchase Voucher data where an order number is required for the import, alongside the standard voucher and party fields.
How It Works
-
Start Tally Prime and Open a Company
Open Tally Prime and select the company into which you want to import the Purchase data.
-
Start udiMagic Software
Launch the udiMagic software.
-
Select “Excel to Tally”
From the udiMagic main screen, select the Excel to Tally option to begin importing data from an Excel file into Tally.
-
Select “Import Data into Tally”
Choose Import data into Tally to open the import workflow where you can select the Excel template and prepare the data for import.
-
Browse and Select an Excel Template
Click the Browse button to select the Excel file you want to use for the import.
-
Click Start
Click the Start button to start the import process.
Frequently Asked Questions
Yes. udiMagic supports custom purchase Excel template mapping, allowing an existing Excel format to be mapped to the required udiMagic Template. This reduces the need to redesign the source spreadsheet before importing.
udiMagic supports separate Party and Supplier fields within the same Purchase Voucher, including name, address, and GSTIN. This lets the billing party differ from the actual supplier on the invoice.
Yes. The Purchase templates include IGST, CGST, and SGST columns, so a single Purchase Voucher can carry multiple GST rates that match your Tally tax configuration.
Yes. The Order Number, along with other supporting details such as reference number and date, can be imported with the Purchase Voucher using the supplied udiMagic Template.
Yes. Purchase Return transactions can be imported as Debit Notes using the voucher type, reference number, date, and original Purchase Voucher details in the supplied template.