Upload your Sales and Sales Return Excel data into Tally Prime
Manually entering Sales Vouchers into Tally is slow and prone to errors, a single wrong tax rate or missed ledger can throw off your books and GST filings. udiMagic solves this by letting you import Sales Vouchers directly from Excel or CSV, posting each voucher into Tally Prime with accurate party, item, and tax details, while automatically creating any missing ledgers or stock item masters.
Built to match Tally's own voucher structure, udiMagic supports both inventory-based and purely accounting sales, is fully GST-ready, and handles real-world needs like dispatch details, multi-currency invoices, and multi-company imports from a single sheet. Imports can be reviewed and undone anytime, and with fast processing for thousands of records, udiMagic makes Sales Voucher entry quick and reliable.
Import Sales and Sales Return (Credit Note) vouchers complete with stock item details, godown, batch number, and expiry date directly into Tally. Perfect for traders and manufacturers, this feature ensures every imported Sales voucher accurately reflects inventory movement, keeping your stock records and accounting books perfectly synchronized.
Import Sales and Sales Return vouchers into Tally without stock item tracking, ideal for service providers and consultants. The columnar template supports up to 30 ledgers, while the Horizontal format handles unlimited ledgers, giving you the flexibility to import purely accounting-based Sales entries with ease.
The Standard Sales Voucher templates fully support GST taxes including quantity-based Cess. Simply map your Excel columns, and each imported Sales voucher is posted into Tally fully GST-compliant, saving time while ensuring accurate, error-free tax calculations on every invoice.
Import Sales vouchers using either Tally's Accounting Mode or Invoice Mode, matching your preferred billing workflow. This flexibility ensures every imported voucher displays exactly as your team expects in Tally.
Import Sales vouchers along with Order No, Order Date, Dispatch Document No, Dispatched Through, Destination, and Vehicle No. directly into Tally. This keeps a complete logistics trail from order to delivery, helping businesses maintain accurate shipment records alongside every imported Sales invoice.
Import Sales or Credit Note vouchers where the buyer and consignee have different names, addresses, states, and GSTINs. This is especially useful for bill-to-one, ship-to-another transactions, ensuring every imported Sales voucher accurately reflects both billing and delivery details in Tally.
Import multiple Sales vouchers with Bill-by-Bill references, including Ref-type, Ref-No, Ref-Amt, and Bill Credit Period, wherever required. This keeps outstanding receivables accurate in Tally, linking each imported Sales invoice to its correct bill reference for easier tracking and timely settlement.
Import Sales vouchers with additional accounting ledgers applied before tax or after tax, such as loading charges, freight, or discount. udiMagic lets you map multiple pre-tax ledgers with their own cost category and centre, ensuring every imported Sales invoice reflects accurate pre-tax adjustments in Tally.
Import Sales vouchers along with e-Invoice details such as Acknowledgement No, Acknowledgement Date, IRN, and IRN QR Code directly into Tally. This helps businesses bring historical or externally generated e-Invoice data into their books without manually re-entering or regenerating each Sales voucher.
Import Sales vouchers with Cess, including quantity or rate-based Cess, along with TCS details under Section 206C such as Buyer Type, PAN, and TCS Rate. udiMagic ensures both components are accurately posted to the correct ledgers for every imported Sales voucher in Tally.
Allocate Sales vouchers to a Cost Centre at either the voucher or ledger level while importing into Tally.
Import both B2B and B2C Sales vouchers into Tally using the same udiMagic template. Party GSTIN, registration type, and place of supply are captured for every voucher, preserving the correct classification between registered and unregistered customers for accurate GST return filing.
Import Point of Sale Sales vouchers into Tally, including split payment details across Gift Vouchers, Credit/Debit Card, Bank, and Cash ledgers. This makes it easy to bring retail counter-sale data from external POS systems into Tally accurately and in bulk, without manual re-entry.
Import Sales vouchers in INR, USD, or any other currency your business trades in, using Currency, Rate of Exchange, and Forex amount details.
Import Sales vouchers into multiple Tally companies directly from a single Excel sheet. Simply specify the Company Name for each row, or leave it blank to import into the currently open company, making it easy for businesses managing sales data across several branches or entities.
Import Sales vouchers into Tally companies with multiple GST registrations, tagging each voucher to the correct State, GST Registration Name, and GSTIN. This ensures every imported Sales voucher is booked under the right registration when your business operates from more than one GST-registered location.
Open Tally Prime and select the company into which you want to import the Sales data.
Launch the udiMagic software.
From the udiMagic main screen, select the Excel to Tally option to begin importing data from an Excel file 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.
Click the Browse button to select the Excel file you want to use for the import.
Click the Start button to start the import process.