Blog

You are currently viewing Excel2Tally-Automation_AllinOne

Excel2Tally-Automation_AllinOne

Excel to Tally Import with unique features

This is Excel to Tally Automation to automate your Data Entry with Tally. It is very helpful to import Excel Data into Tally, easy and quickly. With this software we can import Masters and Vouchers with every detail. It work perfectly with Tally ERP9, Tally Prime and other latest version of Tally. Support GST and Vat Entries.

It holds below features that make it best Excel to Tally Data Import software :

  • Real time connection with Tally
  • Match Excel sheet Ledgers and Stock Items direct with Tally and generate uncreated masters list.
  • Change Tally ledger name and Item name direct from Excel.
  • Dual Entry System (Direct One click Entry and XML generation also)
  • Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button
  • Every time 25000 Entries with one click
  • Very supportive formats for every type work.
  • Small and supportive file, work with every version of Excel
  • With cancel and deletion options.
  • Different Buttons (Master Sheets, Voucher with Inventory, Voucher Without Inventory, Other Useful sheets) for easily working.
  • Get Data from Tally Buttons for Master and Vouchers

Check out this Video for more detail

Master and Voucher Import Facilities

Master Import:

Ledger Masters:

  1. OWN GROUP
  2. ALIAS
  3. FULL ADDRESS WITH CONTACT DETAILS
  4. FULL GST DETAILS
  5. OTHER DETAIL ENABLING OPTION
  6. CREDIT LIMIT
  7. LEDGER DESCRIPTION
  8. TDS DETAILS
  9. BANK DETAILS
  10. OPENING BALANCES
  11. EXPORT LEDGER MASTER FROM TALLY WITH EVERY DETAIL
  12. UPDATE ALL LEDGER DETAILS
  13. CHANGE LEDGER OLD NAME TO NEW NAME
  14. LEDGERS WITH INTEREST OPTION
  15. FULL ADDRESS AND CONTACT DETAILS

Item Masters:

  1. OWN GROUP AND CATEGORY
  2. ALIAS AND PART NUMBER
  3. OPENING WITH BATCH AND GODOWN
  4. FULL GST DETAILS
  5. MRP DETAILS
  6. UQC OPTION
  7. STANDERD RATES AND SELLING RATES
  8. OPENING BALANCES WITH GODOWN AND BATCH
  9. EXPORT ITEM MASTER FROM TALLY WITH EVERY DETAIL
  10. UPDATE ALL ITEM DETAILS
  11. CHANGE ITEM OLD NAME TO NEW NAME
  12. BOM (BILL OF MATERIAL) FACILITY
  13. ITEM DESCRIPTION AND REMARK OPTION
  14. ALTERNATE UNIT DETAILS
  15. OTHER DETAIL SETTINGS (YES, NO) OPTION

Stock Unit:

  1. FORMAL NAME
  2. DECIDE DECIMAL PLACES

CostCentre Master:

  1. OWN COSTCENTRE GROUP
  2. OWN COSTCENTRE CATEGORY

Voucher Import:

  • Accounting Vouchers
  • Inventory Vouchers
  • Random Vouchers
  • Multi Currency Vouchers
  • Stock Journal and Manufacturing Vouchers
  • Material In and Material Out Vouchers
  • Rejection In and Rejection Out Vouchers
  • Sales Order and Purchase Order Vouchers
  • Receipt Note and Delivery Note Vouchers
  • Bank Vouchers

Import Vouchers with below facilities :

  1. MULTI LEDGER ACCOUNTING AND INVENTORY VOUCHERS
  2. DIRECT CONNECTION WITH TALLY
  3. SHOW LEDGER NAMES AND STOCK ITEMS OF TALLY IN EXCEL COLUMN WITH REAL TIME CONNECTION WITH TALLY
  4. MULTIPLE DEBIT AND CREDIT OPTIONS
  5. IMPORT ALL TYPE VOUCHERS WITH ONE SHEET AT A TIME
  6. YOUR OWN VOUCHER TYPE
  7. NO BOUNDATION FOR DATES, USE LIFETIME
  8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
  9. RANDOM DATES, RANDOM AMOUNTS, RANDOM STOCK ITEM OPTIONS.
  10. VOUCHERS WITH MULTI LEDGERS, MULTI STOCK ITEMS WITH MULTI BATCH AND MULTI GODOWN
  11. MULTI GST AND MULTI TAXABLE LEDGER OPTION IN SINGLE VOUCHER
  12. VALIDATION OPTION TO AUTO CALCULATE MULTI ITEM IN SINGLE VOUCHER
  13. DUAL ENTRY SYSTEM – DO RECEIPT AT SAME TIME AGAINST SALES
  14. MULTI COSTCENTRE OPTION FOR EVERY LEDGER
  15. MULTI ITEM DESCRIPTION OPTION
  16. SCRAP OPTION IN MANUFACTURING JOURNAL
  17. ADDITIONAL EXPENSE OPTION IN MANUFACTURING JOURNAL
  18. GODOWN TO GODOWN TRANSFER OPTION
  19. ZERO VALUE ENTRY OPTION
  20. BUYER AND CONSIGNEE DETAILS WITH ADDRESS AND GST OPTIONS
  21. VOUCHERS WITH TRANSPORTER DETAILS
  22. VOUCHERS WITH E-WAYBILL DETAILS
  23. NATURE OF RETURNS OPTION IN DEBIT, CREDIT NOTES
  24. VOUCHERS WITH DISPATCH DETAILS
  25. WITH MULTI BILLWISE ENTRIES
  26. GET VOUCHER DATA FROM TALLY AND ALTER IT TO REPOST IN TALLY
  27. ALTER VOUCHERS DIRECT IN TALLY BY WRITING Alter IN EXCEL SHEET
  28. CANCEL AND DELETE TALLY VOUCHERS FROM EXCEL
  29. RANDOM VOUCHERS WITH LIVE CONNECTION OF LEDGERS AND ITEMS
  30. BANK IMPORT AND GSTR 2A IMPORT SHEETS
click to download
Excel2Tally-Automation_Ecommerce
Excel2Tally-Automation_Payroll
Tags: , , , , , , , , , , , , , , , , , , , , , ,