Bring your Receipt and Payment entries from Excel into Tally Prime. Handle multiple money received and money paid transactions together, without entering every receipt or payment manually.
Manually entering Receipt and Payment vouchers into Tally is slow and leads to many mistakes — a missed reference or an unmatched ledger amount can throw off your outstanding bills and bank reconciliation. udiMagic solves this by letting you import Receipt and Payment data directly from Excel, posting each voucher into Tally Prime with accurate party, amount, reference, and ledger details.
Built to match Tally's own voucher structure, udiMagic supports bill-by-bill references, multiple ledger allocations, and cash or bank ledger mapping in a single voucher. It handles real-world needs like instrument and bank date details for reconciliation, cheque-based payments, and multi-reference receipts from a single sheet. Imports can be reviewed and undone anytime, and with fast processing for thousands of records, udiMagic makes Receipt and Payment voucher entry quick and reliable.
Import Receipt and Payment vouchers complete with party ledger, amount, and voucher type directly into Tally. Perfect for accountants and finance teams, this feature ensures every imported voucher accurately reflects the transaction and keeps your books and bank records perfectly synchronised.
Import Receipt and Payment vouchers with bill-by-bill references, ideal for adjusting a single receipt or payment against several outstanding invoices. The template supports multiple reference rows per voucher, giving you the flexibility to import multi-invoice settlements with ease.
The Receipt and Payment templates fully support bulk processing of transactions. Simply prepare your Excel data, and each imported voucher is posted into Tally accurately, saving time while ensuring reliable, error-free entries across thousands of records.
Import Receipt and Payment vouchers that need more than one ledger, such as principal, discount, or tax amounts. The template supports up to ten ledger name and amount pairs per voucher, keeping every allocation accurate and properly recorded in Tally.
Import transactions with reference number, reference amount, and reference type for accurate bill-by-bill allocation. Each Receipt or Payment voucher is matched to the right outstanding bill, keeping your receivables and payables reports clean and reliable.
Prepare instrument number, instrument date, transaction type, and bank date details included in the Receipt and Payment template. Cheque and bank-related information travels into Tally with the voucher, reducing manual cross-checking later.
Map the cash or bank ledger and its corresponding amount clearly against every Receipt and Payment voucher. This ensures each transaction settles against the correct account, keeping your cash and bank books accurate.
Include a clearly labeled Bank Date field with every voucher, making it easier to reconcile Receipt and Payment entries against bank statements during month-end and year-end closing.
Open Tally Prime and select the company into which you want to import the Receipts and Payments.
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.