2. Save the text file into your computer.
3. Copy the text file path including Name and extension (as – C:UsersHPDesktoprecParty Detail.txt)
4. Open Tally ERP9 OR Tally Prime
5a. Press F12 and goto Product and Features (for Tally ERP9)
This is Excel to Tally Automation to Import your E-Commerce Data Entry into Tally wit 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 :
ü Realtime connection with Tally
ü Master and Voucher Creation in Same Sheet
ü Change Tally ledger name and Item name direct from Excel.
ü Import Text, CSV, Excel formats Directly in this sheet
ü Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button
ü Upto 25000 entries with one click
ü Very supportive formats for every type work.
ü Small and supportive file, work with every version of Excel
ü Lifetime Use, No renewal required, 24×7 free support.
Contains below Sheets to powerup Data Entry work:
LEDGER MASTER:
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
STOCK MASTER:
1. OWN GROUP
2. ALIAS
3. BATCH DETAILS
4. GST DETAILS
5. MRP DETAILS
6. STANDERD RATES
7. OPENING BALANCES
UNIT MASTER:
1. FORMAL NAME
2. DECIMAL PLACES
Amazon B2C
1. FULL DETAILED INVENTORY VOUCHER.
2. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
3. GET CSV, TEXT, EXCEL FORMATS DIRECTLY IN TO THE SHEET.
4. AUTO CALCULATION FIELDS TO RELATE VOUCHERS AND ITEMS.
5. SAME AMAZON SHEET FORMAT
6. WITH TCS AND GST EFFECTS
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. DEBIT CREDIT WILL CALCULATE AUTOMATIC
10. ALL LEDGERS WITH SHIPPING, WRAP, DISCOUNT, GST ,TCS ETC.
11. PARTY STATE AND PLACE OF SUPPLY
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL FOR CREDIT AND DEBIT NOTES
Amazon B2B
1. FULL DETAILED INVENTORY VOUCHER.
2. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
3. GET CSV, TEXT, EXCEL FORMATS DIRECTLY IN TO THE SHEET.
4. AUTO CALCULATION FIELDS TO RELATE VOUCHERS AND ITEMS.
5. SAME AMAZON SHEET FORMAT
6. WITH TCS AND GST EFFECTS
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. DEBIT CREDIT WILL CALCULATE AUTOMATIC
10. ALL LEDGERS WITH SHIPPING, WRAP, DISCOUNT, GST ,TCS ETC.
11. PARTY STATE AND PLACE OF SUPPLY
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL FOR CREDIT AND DEBIT NOTES
FLIPKART
1. FULL DETAILED INVENTORY VOUCHER.
2. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
3. GET CSV, TEXT, EXCEL FORMATS DIRECTLY IN TO THE SHEET.
4. AUTO CALCULATION FIELDS TO RELATE VOUCHERS AND ITEMS.
5. SAME FLIPKART SHEET FORMAT
6. WITH TCS AND GST EFFECTS
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. DEBIT CREDIT WILL CALCULATE AUTOMATIC
10. ALL LEDGERS WITH SHIPPING, WRAP, DISCOUNT, GST ,TCS ETC.
11. PARTY STATE AND PLACE OF SUPPLY
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL FOR CREDIT AND DEBIT NOTES
AMAZON SETTLEMENT
1. SPECIAL SETTLEMENT VOUCHER
2. WITH MULTIPLE REFERENCE ENTRY
3. DIRECET GET TEXT FILES INTO THE SHEET
4. AUTOMATIC CALCULATIONS AND SUMMURISED IN SAME SHEET
5. WITH CLEAR, IMPORT, VALIDATE, POST MASTER NAD POST VOUCHER BUTTONS.
6. SAME AMAZON SETTLEMENT FORMAT
RANDOM
1. SIMPLE ACCOUNTING VOUCHERS
2. SALES, PURCHASE, RECEIPT, PAYMENT, CONTRA,JOURNAL ETC IN SAME SHEET.
3. YOUR OWN VOUCHER TYPE
4. NO BOUNDATION FOR DATES, USE LIFETIME
5. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
6. SEPARATE DEBIT LEDGERS AND AMOUNT, CREDIT LEDGERS AND AMOUNT
7. SHEET HAS MACRO BUTTONS TO DIRECT POST IN TALLY.
8. SHEET HAS MACRO BUTTONS TO CALCULATE RANDOM DATE AND AMOUNT VOUCHERS.
BANK-VCH:
1. BANK IMPORT WITH SIMPLE BANK FORMAT
2. AUTOMATIC VOUCHER SELECTION
3. SEPARATE CONTRA VOUCHER TYPE
4. NO BOUNDATION FOR DATES, USE LIFETIME
5. ENTRIES DONE WITH RECONCILATION
6. DEBIT AND CREDIT LEDGER OPTION IN SAME COLUMN
7. SHEET HAS MACRO BUTTONS: MASTER CHECK, TALLY LEDGER ALTER, POST IN TALLY.
MULTIPURPOSE SETTLEMENT:
1. IMPORT VOUCHERS WITH UNLIMITED LEDGERS (ONE VOUCHER WITH THOUSANDS OF LEDGER)
2. IDAL FOR FLIPKART SETTLEMENT AND SALARY IMPORT
3. INCLUDE ALL TYPE VOUCHERS- SALES, PURCHASE, JOURNAL, PAYMENT, RECEIPT, CONTRA WITHOUT INVENTORY
4. WITH SINGLE AND MULTIPLE BILL WISE DETAILS
5. WITH COSTCENTER AND COST CATEGORY DETAILS
UTILITY ALSO HAVE HELP SHEET, READ CAREFULLY BEFORE USE.
EVERY BUTTON HAS HELP OPTION WITH IT. RIGHT CLICK ON BUTTONS TO GET HELP.
VIDEO HELP: https://youtu.be/6qL2_eJmfFg
WEBSITE : www.Learnwells.com and E2T.in
EMAIL : <Learnwells@outlook.com> and <ssonu@live.com> (Personal Email id)
YOUTUBE : https://www.youtube.com/learnwell/c
FACEBOOK: https://www.facebook.com/learnswell/
CONTACT NO. +91-9131810293 (ASHISH SINGH)
Now your TDL is ready to use.
Now your TDL is ready to use.
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 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 Oneclick Entry and XML generation also)
ü Auto Calculation columns of Cell address, Round off, Taxable Value etc with Validate Button
ü Every time Unlimited Entries with oneclick
ü Very supportive formats for every type work.
ü Small and supportive file, work with every version of Excel
ü Lifetime Use, No renewal required, 24×7 free support.
Contains below Sheets to power-up Data Entry work:
LEDGER MASTER:
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
STOCK MASTER:
1. OWN GROUP
2. ALIAS
3. BATCH DETAILS
4. GST DETAILS
5. MRP DETAILS
6. STANDERD RATES
7. OPENING BALANCES
UNIT MASTER:
1. FORMAL NAME
2. DECIMAL PLACES
F-D-Invt-VCH
1. FULL DETAILED INVENTORY VOUCHERS
2. ITEMS WITH BATCH, GODOWN, DESCRIPTION, MFG-EXPIRY DATES
3. UNLIMITED STOCK ITEMS WITH EVERY VOUCHER
4. AUTOMATIC CELL ADDRESSES TO RELATE ITEMS WITH VOUCHER
5. TAXABLE LEDGER FOR EVERY ITEM FOR ITEM ALLOCATION
6. YOUR OWN VOUCHER TYPE
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. NO DEBIT CREDIT OPTION (IT WILL CALCULATE AUTOMATIC)
10. 22 LEDGERS IN ONE VOUCHER TO SUPPORT ALL GST RATES WITH EXEMPTED (IT MAY INCREASE)
11. INCLUDE TRANSPORTING CHARGE, OTHER CHARGE, DISCOUNT, ROUND OFF LEDGERS.
12. SUPPORT BILLWISE DETAILS
13. GST DETAIL COLUMNS FOR CREDIT AND DEBIT NOTES
14. CONSINGEE AND BUYER DETAILS WITH GST TYPE, GST NUMBER, PLACE OF SUPPLY ETC.
15. FULL DESPATCH DETAILS.
16. TAX CLASSIFICATION DETAIL COLUMN
17. SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, TALLY STOCK ITEM ALTER, VALIDATE, DIRECT POST IN TALLY WITH XML GENERATE
F-D-VCH:
1. FULL DETAILED VOUCHERS
2. YOUR OWN VOUCHER TYPE
3. NO BOUNDATION FOR DATES, USE LIFETIME
4. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
5. DEBIT CREDIT OPTION FOR EVERY LEDGER
6. 22 LEDGERS IN ONE VOUCHER TO SUPPORT ALL GST RATES WITH EXEMPTED (IT MAY INCREASE)
7. INCLUDE TRANSPORTING CHARGE, OTHER CHARGE, DISCOUNT, ROUND OFF LEDGERS.
8. SUPPORT BILLWISE DETAILS
9. GST DETAIL COLUMNS FOR CREDIT AND DEBIT NOTES
10. CONSINGEE AND BUYER DETAILS WITH GST TYPE, GST NUMBER, PLACE OF SUPPLY ETC.
11. FULL DESPATCH DETAILS.
12. TAX CLASSIFICATION DETAIL COLUMN
13. SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, VALIDATE, POST IN TALLY.
M-B-Invt-VCH:
1. MULTI BATCH INVENTORY VOUCHER
2. FULL DETAILED INVENTORY VOUCHERS
3. ITEMS WITH MULTIPLE BATCHES, GODOWN, DESCRIPTION, MFG-EXPIRY DATES ETC.
4. UNLIMITED STOCK ITEMS AND UNLIMITED BATCH FOR EVERY ITEM WITH EVERY VOUCHER
5. AUTOMATIC CELL ADDRESSES TO RELATE ITEMS WITH VOUCHER AND BATCHES WITH ITEMS
6. YOUR OWN VOUCHER TYPE
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
9. NO DEBIT CREDIT OPTION (IT WILL CALCULATE AUTOMATIC)
10. SUPPORT BILLWISE DETAILS
11. GST DETAIL COLUMNS FOR CREDIT AND DEBIT NOTES
12. SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, TALLY STOCK ITEM ALTER, VALIDATE, DIRECT POST IN TALLY.
SMPL-Invt-VCH:
1. SIMPLE INVENTORY VOUCHERS
2. ITEM NAME, UNIT, RATE, AMOUNT
3. YOUR OWN VOUCHER TYPE
4. NO BOUNDATION FOR DATES, USE LIFETIME
5. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
6. SEPARATE DEBIT LEDGERS AND AMOUNT, CREDIT LEDGERS AND AMOUNT
7. SHEET HAS MACRO BUTTONS : MASTER CHECK, TALLY LEDGER ALTER, TALLY STOCK ITEM ALTER, VALIDATE, DIRECT POST IN TALLY.
SMPL-VCH:
1. YOUR OWN VOUCHER TYPE
2. NO BOUNDATION FOR DATES, USE LIFETIME
3. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER
4. DEBIT LEDGERS, CREDIT LEDGERS AND THERE AMOUNT
5. SHEET HAS MACRO BUTTONS: MASTER CHECK, TALLY LEDGER ALTER, POST IN TALLY.
BANK-VCH:
1. BANK IMPORT WITH SIMPLE BANK FORMAT
2. AUTOMATIC VOUCHER SELECTION
3. SEPARATE CONTRA VOUCHER TYPE
4. NO FOUNDATION FOR DATES, USE LIFETIME
5. ENTRIES DONE WITH RECONCILIATION
6. DEBIT AND CREDIT LEDGER OPTION IN SAME COLUMN
7. SHEET HAS MACRO BUTTONS: MASTER CHECK, TALLY LEDGER ALTER, POST IN TALLY.
UTILITY ALSO HAVE HELP SHEET, READ CAREFULLY BEFORE USE.
EVERY BUTTON HAS HELP OPTION WITH IT. RIGHT CLICK ON BUTTONS TO GET HELP.
VIDEO HELP: https://youtu.be/f6bReb0fuR4
WEBSITE : www.Learnwells.comand E2T.in
EMAIL : Learnwells@outlook.com and ssonu@live.com(Personal Email id)
YOUTUBE : https://www.youtube.com/learnwell/c
FACEBOOK: https://www.facebook.com/learnswell/
CONTACT NO. +91-9131810293 (ASHISH SINGH)