EXCEL TO TALLY – AUTOMATION

Rate this post

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)

Tags: No tags

Add a Comment

Your email address will not be published. Required fields are marked *