EXCEL2TALLY-Automation_12.0

Share
  • Compressed File
  • 3 MB
₹ 8,980₹ 7,540
Description

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 :
 Realtime 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 oneclik
 Very supportive formats for every type work.
 Small and supportive file, work with every version of Excel
 Lifetime Use, No renewal required, 24x7 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
11. EXPORT LEDGER MASTER FROM TALLY WITH EVERY DETAIL
12. UPDATE ALL LEDGER DETAILS
10. CHANGE LEDGER OLD NAME TO NEW NAME
STOCK MASTER:
1. OWN GROUP
2. ALIAS
3. BATCH DETAILS
4. GST DETAILS
5. MRP DETAILS
6. STANDERD RATES
7. OPENING BALANCES
8. EXPORT ITEM MASTER FROM TALLY WITH EVERY DETAIL
9. UPDATE ALL ITEM DETAILS
10. CHANGE ITEM OLD NAME TO NEW NAME
UNIT MASTER:
1. FORMAL NAME
2. DECIMAL PLACES
COST CENTRE MASTER:
1. COST CENTRE NAME
2. COST CENTRE GROUP
3. COST CENTRE CATEGORY

ACCOUNTING VOUCHERS
1. MULTI LEDGER ACCOUNTING VOUCHERS
2. DIRECT CONNECTION WITH TALLY
3. SHOW LEDGER NAMES OF TALLY FOR EVERY COLUMN WTH REALTIME CONNECTION
4. MULTIPLE DEBIT AND CREDIT OPTIONS
5. IMPORT ALL TYPE VOUCHERS IN 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

RANDOM VOUCHERS
1. MULTI LEDGER ACCOUNTING VOUCHERS
2. DIRECT CONNECTION WITH TALLY
3. SHOW LEDGER NAMES OF TALLY FOR EVERY COLUMN WTH REALTIME CONNECTION
4. MULTIPLE DEBIT AND CREDIT OPTIONS
5. IMPORT ALL TYPE VOUCHERS IN 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 AND RANDOM AMOUNT OPTIONS.
10. ALL CELLS HAVE AUTO CALCULATE OPTION

E-COM + MULTIPURPOSE VOUCHERS
1. MULTI LEDGER VOUCHERS WITH MULTIPLE INVENTORY OPTION
2. DIRECT CONNECTION WITH TALLY
3. SHOW LEDGER NAMES OF TALLY FOR CUSTOMER LEDGER WITH REALTIME CONNECTION
4. MULTIPLE DEBIT AND CREDIT OPTIONS
5. IMPORT ALL TYPE VOUCHERS IN 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. ITEMS WITH MULTIPLE BATCH AND MULTIPLE GODOWN OPTION
10. MULTIPLE LEDGER OPTION FOR TAXABLE ACCOUNT AND TAX ACCOUNT
11. DUAL ENTRY SYSTEM – DO RECEIPT AT SAME TIME AGAINST SALES
12. MULTIPLE COSTCENTRE OPTION
13. DUAL ITEM DESCRIPTION OPTION

STOCK JOURNAL AND MANUFACTURING JOURNAL VOUCHERS
1. MULTIPLE INVENTORY OPTION WITH BATCH GODOWN
2. DIRECT CONNECTION WITH TALLY
3. ADD STOCK ITEMS WITH REALTIME CONNECTION WITH TALLY
4. SCRAP OPTION
5. ADDITIONAL EXPENSE OPTION
6. YOUR OWN VOUCHER TYPE
7. NO BOUNDATION FOR DATES, USE LIFETIME
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

MATERIAL IN OUT AND REJECTION IN OUT VOUCHERS
1. MULTIPLE INVENTORY OPTION WITH BATCH GODOWN
2. DIRECT CONNECTION WITH TALLY
3. ADD STOCK ITEMS WITH REALTIME CONNECTION WITH TALLY
4. GODOWN TRANSFER OPTION
5. ADDITIONAL EXPENSE LEDGERS
6. ADDRESS OPTION
7. ZERO VALUE ENTRY OPTION
8. MANUAL AND AUTOMATIC VOUCHER NUMBER SUPPORT WITH REFERENCE NUMBER

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.
SPCL-M.Invt-VCH:
1. SPECIAL MULTI INVENTORY VOUCHERS
2. MULTI INVOICE, MULTI VOUCHERS, MULTI INVENTORY, MULTI BATCH, MULTI GST, MULTI SALES TAXABLE.
3. ALL AUTO CALCULATION FIELDS
4. MASTER AND VOUCHERS IMPORT IN SAME SHEET, SAME TIME.
5. DIRECT EFFECT IN TALLY GST
6. MOST SIMPLE FORMAT, SAME AS YOUR DATA
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 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.

*NOW WITH RECEIPT NOTE, DELIVERY NOTE IMPORT, MULTI CURRENCY VOUCHER IMPORT WITH AND WITHOUT ITEM, MARG GST REPORT IMPORT WITH DIRECT IMPORT OPTION.
*NOW WITH TALLY VOUCHER ALTERATION FEATURE DIRECTLY FROM EXCEL
*NOW WITH RANDOM VOUCHER ENTRY WITH LIVE CONNECTION OF TALLY LEDGERS
*NOW WITH MATERIAL IN-OUT AND REJECTIONS IN-OUT VOUCHERS ENTRY
*NOW WITH CANCEL AND DELETE OPTION
*NOW WITH 2A IMPORT
*NOW WITH RANDOMIZED INVENTORY INVOICES

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.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)