You are currently viewing Excel2Tally-Automation_Ecommerce

Excel2Tally-Automation_Ecommerce

Import E-commerce entries with less effort in few minutes

This is Excel to Tally Automation to Import your E-Commerce Data Entry into Tally with Easy and quick way. With this software we can import Masters and Vouchers with every detail. It work perfectly with Tally ERP9 and Tally Prime. Support GST and Vat Entries. It holds below features that make it best Excel to Tally E-Commerce Data Import software :

  • Real time connection with Tally
  • Match Excel sheet Ledgers and Stock Items direct with Tally and generate uncreated masters list.
  • Direct One Click entry.
  • Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button
  • Every time 25000 Entries with one click
  • Different sheet of different E-Commerce portal.
  • Direct Import buttons to choose E-Commerce portal files without any changes.
  • Small and supportive file, work with every version of Excel
  • Prevent Duplicate Entries. (Same voucher number entries will not done twice).
  • Auto track to support multiple item in single voucher entry.
  • Different Buttons (Clear, Import File, Validate, Post Master, Post Voucher) in every sheet.
  • Most simple import process make it best in this segment.

See this video to learn how to use excel to tally ecommerce data import utility

Master and Voucher Import Facilities:

Master Import:

This Excel to Tally – E-Commerce Data import software have below master creation sheets (Masters also can create from Voucher sheets)

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. FULL ADDRESS AND CONTACT DETAILS

Item Masters:

  1. OWN GROUP
  2. ALIAS
  3. OPENING WITH BATCH AND GODOWN
  4. FULL GST DETAILS
  5. MRP DETAILS
  6. STANDERD RATES AND SELLING RATES

Stock Unit:

  1. FORMAL NAME
  2. DECIDE DECIMAL PLACES

Voucher Import:

  • Vouchers with Inventory
  • Vouchers without Inventory
  • Random Vouchers
  • Sales Order and Purchase Order Vouchers
  • Bank Vouchers
  • GSTR 2A of government portal
  • MTR (Sales, Credit Notes) Reports
  • Settlement (Bank Receipt) Reports

Import Vouchers with below facilities :

  1. MULTI LEDGER ACCOUNTING AND INVENTORY VOUCHERS
  2. DIRECT CONNECTION WITH TALLY
  3. DIRECT E-COMMERCE DATA SHEET IMPORT OPTION WITHOUT ANY CHANGES IN FILE.
  4. MULTIPLE DEBIT AND CREDIT OPTIONS
  5. IMPORT ALL TYPE VOUCHERS WITH A 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, OPTIONS IN RANDOM SHEET.
  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. BUYER AND CONSIGNEE DETAILS WITH ADDRESS AND GST OPTIONS
  17. VOUCHERS WITH TRANSPORTER DETAILS
  18. NATURE OF RETURNS OPTION IN DEBIT, CREDIT NOTES
  19. VOUCHERS WITH DISPATCH DETAILS
  20. WITH MULTI BILLWISE ENTRIES
  21. ALTER VOUCHERS DIRECT IN TALLY BY WRITING Alter IN EXCEL SHEET
  22. BANK IMPORT AND GSTR 2A IMPORT SHEETS
  23. GENERATE GST REPORTS EASILY WITHOUT ANY ERROR.
  24. SUPPORT ALL TYPE E-COMMERCE PLATFORM.
  25. SEPARATE SALES, CREDIT NOTE AND PAYMENT SETTLEMENT SHEETS FOR EVERY PLAT FORM.
  26. AFTER ENTRY CAN TRACK PENDING ORDERS IN TALLY, THAT PAYMENTS NOT RECEIVED.
  27. BANK IMPORT ENTRIES WITH BANK VOUCHER SHEET WILL BE AUTO RECONCILED.
  28. DO ENTRIES OF SALES, PURCHASE, CREDIT NOTE, DEBIT NOTE, JOURNAL, SALES ORDER, PURCHASE ORDER, PAYMENT, RECEIPT, CONTRA TYPE VOUCHERS WITH OWN VOUCHER TYPE.
  29. UTILITY CAN BE USE FOR LIFE TIME, NO RENEWAL REQUIRED.
  30. DO UPTO 25000 ENTRIES AT A TIME