This is Excel to Tally Automationto automate your Data Entry with Tally. It is very helpful to import Excel Datainto Tally, easy and quickly. With this Excel to Tally import software we canimport Masters and Vouchers with every detail. It work perfectly with TallyERP9 and other latest version of Tally. Support GST and Vat Entries. It holdsbelow 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 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.
ü Direct buttons for Vouchers with Inventory, Vouchers without Inventory, Masters and many direct import for GSTR 2A, Vat related entries, Bank import etc.
ü Alter features for all type vouchers and Masters
ü Completely made in Microsoft Excel, no additional software required.
This Macro Enabled workbook contains below simple sheets with direct buttons to powerup Data Entry work:
TO MAKE SIMPLE ENTRIES BUTTONS ADDED TO HOME SCREEN:
· BUTTON: VOUCHER IMPORT WITH INVENTORY
· BUTTON: VOUCHER IMPORT WITHOUT INVENTORY
· BUTTON: EXTRA DIRECT IMPORT SHEETS FOR GSTR 2A, BANK ETC.
· BUTTON: MASTER IMPORT AND ALTER LIKE LEDGER MASTER, STOCK MASTER, UNIT AND COSTCENTRE (MASTERS ALSO CAN CREATE WITH VOUCHERS)
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
FULL DETAILED INVENTORY VOUCHERS
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
FULL DETAILED WITHOUT INVENTORY VOUCHERS
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.
MULTI BATCH WISE INVENTORY VOUCHERS
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.
SPECIAL MULTI INVENTORY VOUCHERS WITH MULTI BATCHES
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
SIMPLE INVENTORY VOUCHERS
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.
SIMPLE VOUCHERS
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 IMPORT VOUCHERS
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 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)
Awasome tdls sir
Thank you❤🌹