Amazon, Flipkart, Meesho, Snapdeal, Udaan Sales and Settlement Import in to Tally | Best Software to import Ecommerce data into Tally Prime and 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

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
7. AMAZON SETTLEMENT VIEW AND VIEW 2 FORMATS

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

FLIPKART SETTLEMENT
1. SPECIAL SETTLEMENT VOUCHER
2. WITH MULTIPLE REFERENCE ENTRY
3. DIRECET GET CSV OR XLS 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 FLIPKART SETTLEMENT FORMAT

MEESHO
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 MEESHO 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

MEESHO SETTLEMENT
1. SPECIAL SETTLEMENT VOUCHER
2. WITH MULTIPLE REFERENCE ENTRY
3. DIRECET GET CSV OR XLS 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 MEESHO SETTLEMENT FORMAT

SNAPDEAL
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 SNAPDEAL 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

UDAAN
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 UDAAN 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

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 INVENTORY VOUCHER
1. IMPORT VOUCHERS WITH MULTIPLE LEDGERS, MULTIPLE STOCK ITEMS, MULTIPLE BATCHES ETC
2. FOR ALL TYPE INVENTORY VOUCHER (SALES, PURCHASE, ORDER VOUCHERS ETC.)
3. WITH COSTCENTER AND COST CATEGORY DETAILS

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/kLwPbIuZz40
WEBSITE : www.Learnwells.com and E2T.in
EMAIL : Learnwells@outlook.com
YOUTUBE : https://www.youtube.com/learnwell/c
FACEBOOK: https://www.facebook.com/learnswell/
CONTACT NO. +91-9131810293 (ASHISH SINGH)

DOWNLOAD EXCEL TO TALLY ECOMMERCE SOFTWARE WITH BELOW LINK:

Free TDL for Stock Item Import | Free Excel to Tally Item Import for Tally Prime | Free Text to Tally Item Import for Tally Prime | Stock Import into Tally Prime

 

With this free TDL code we can import stock items into Tally Prime with Item name, Group and unit. It will very helpful to create bulk stock master into Tally. We can use Excel or Text file as our data to import items.

 
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple tdl code to import inventory into Tally Prime.

HOW TO USE:

        1. Load below Stock Master import TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now a line will show in the name of import stock item into our tally home screen.
        3. Click on Import stock item tab and give your file name and excel path that you want to import into tally and press enter.
        4. You can see your excel or text file imported into tally and after import a report of error or successfully import message will generated.

This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will perfectly work with Tally Prime.

TDL Code : 


































































































































































HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

This free Tally Prime TDL code Also can download with below TDL download button:

Bank Reconciliation TDL | Bank Clearing Date in Ledger | Best Bank Tally TDL for Tally Prime and Tally ERP9 | Best Tally Prime TDL 2021

 With this free TDL code we can add bank reconciliation date in ledger or bank clearing date in  bank account statement of Tally. With this we can easily reconcile bank entries in regular basis without any mistake, because these bank reconciliation dates and bank entry dates will show in same place of bank ledger account.

 
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple tdl code to reconcile bank.

HOW TO USE:

        1. Load below bank date in bank ledger TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now open bank account ledger to see with bank date in front of voucher number.
        3. Now you can see the dates of bank reco and now you will able to find out entries that are clear or not clear in bank.

This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

 [#Line: DSP VchAccTitles]
  add: Right Field : After : DSP VchNumberTitle :LearnWellBDT
[Field:LearnWellBDT]
use:Medium Prompt
Set As:”Bank Date”

[#Line: DSP VchDetail]
   Add :  Right Fields        : AFter :  DSP VchNumber :LearnWellBD
[Field:LearnWellBD]
Use:Date Field
Set as  :  $AllLedgerEntries[-1].BankAllocations.BankersDate
width:20

[#Collection: Vouchers of Ledger]
Fetch : AllLedgerEntries.BankAllocations.BankersDate



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

All in one Excel to Tally Import

EXCEL TO TALLY – AUTOMATION 12.0 | BEST EXCEL TO TALLY DATA TRANSFER UTILITY | EXCEL TO TALLY PRIME IMPORT | EXCEL TO TALLY ERP9 IMPORT

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)

 

 

Item HSN, GST, MRP, Alias, Price at Invoice Time | Best Tally Prime TDL

With this free TDL code we can add Item HSN, GST, MRP, Alias, Price at Invoice Time in Voucher screen of Sales, Purchase, etc. at item selection time. that will help to  increase productivity and accuracy of our work.
 
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code to work with Item all detail at invoice time.

HOW TO USE:

        1. Load below Item all detail at invoice time TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing in sales voucher / purchase voucher and select Item to bill.
        3. Now you can see all the details of item like,Item HSN, GST, MRP, Alias, Price etc.

This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Collection:VCH Stock Item Extract]
add:format:$Name,20
add:format:$GSTHSNCODE
add:format:$GSTIGSTRATE
add:format:$STANDARDCOST
add:format:$STANDARDPRICE
add:format:$MRPDetails[last].mrpratedetails[last].MRPRate



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

GST and Mobile number in Voucher Screen TDL | Best Tally TDL 2021

With this free TDL code we can add Party Mobile Number and Party GST Number in Voucher screen of Sales, Purchase, etc.that will help to communicate with customer and increase productivity and accuracy of our work.
 
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code to work with party mobile number and GST number at invoice time.

HOW TO USE:

        1. Load below Party Mobile and GST TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing in sales voucher / purchase voucher and select party to bill.
        3. Now we can see Mobile number and GST number of billing Party.
        4. No changes in invoice printing.


This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Line:EI Consignee]
Field:MobileLWT
Left Fields:MobileLWD,GSTLWD
Border:Thin Bottom

[Field:MobileLWT]
use:Medium Prompt
Set As:”MoNo/GST”


[Field:MobileLWD]
Use:Name field
Set As:$LedgerMobile:Ledger:#EIConsignee
Color:Blue
skip:Yes

[Field:GSTLWD]
Use:Name field
Set As:$PartyGSTIN:Ledger:#EIConsignee
Color:Blue
skip:Yes



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

Best of Tally Prime TDL Reports | Way to use SQL for Tally reports | Use Narration to get Best Tally Reports

Yes! you are in right place if you use Tally software. In this post we will understand, how to collect best Tally reports and export it into tally with the help of SQL query. We can use SQL query in Tally Narration and collect reports as per our requirement. It is very simple process for all type report collection from tally.

We can retrieve information from Tally ERP9 and Tally Prime by using below SQL method in Tally narration:

1. Press Ctrl+N to go to Tally Calculator

2. In Tally Calculator write SELECT and SQL command to get information.

The syntax to write SQL Query in Tally is:

SELECT [<Method Name/s> / <*>] FROM <Collection/Table> WHERE <Condition> ORDER BY <Method Name/s>

For Example collect name from Ledgers copy below SQL and paste in Narration then press enter to get ledger name details:

SELECT $Name FROM Ledger

or

SELECT $Name FROM ODBCTables
    Method names always will start with $ (dollar) sign – as in above example we used $Name

Report Examples:

We can collect below type reports with SQL query by type below texts in Narration field of Tally and press enter:

1. Collect All Information of Ledgers:

SELECT * FROM Ledger

2. Collect All Information of Stock Items:

SELECT * FROM StockItem

3. Collect All Information of Units:

SELECT * FROM Unit

4. Collect All Information of Voucher Types:

SELECT * FROM VoucherType

5. Collect All Information of Cost Centre:

SELECT * FROM CostCentres

6. Collect All Information of Godown:

SELECT * FROM Godown

7. Collect All Information of Stock Group:

SELECT * FROM StockGroup

8. Collect All Information of Stock Category:

SELECT * FROM StockCategory


NOW WE KNOW ALL METHOD NAMES OF LEDGERS, ITEMS ETC. SO CAN TRY BELOW COLLECTIONS ALSO:

9. To retrieve more than one method from a collection, separate the method names with a comma. For example, to retrieve $Name and $ClosingBalance of Ledger collection

SELECT $Name, $ClosingBalance FROM Ledger


10. Also we can use WHERE method to retrieve Debit Credit or other reports

SELECT $Name FROM Ledger WHERE $$IsDr: $ClosingBalance

11. to get Credit closing balance can use below method with NOT $$IsDr

SELECT $Name FROM Ledger WHERE NOT $$IsDr: $ClosingBalance


12. Get closing balance between two amounts as between 10000 and 11000

SELECT $Name FROM Ledger WHERE $ClosingBalance BETWEEN 10000 AND 11000

13. Collect ledger names that contain names like Sales (As Sales Account, GST Sales etc.)

SELECT $Name FROM ledger WHERE $name LIKE ‘%sales%’


14. Also we can collect reports with sort in order by order keyword : (in below example DESC for descending order) 

SELECT $Name, $ClosingBalance FROM Ledger WHERE $$IsDr: $ClosingBalance ORDER BY $ClosingBalance DESC

Also we can collect information with the help of TDL Collections: (click the below link)

Select Alias at Billing Time – Free TDL Code | Best Tally TDL Codes 2021

With this free TDL code we can select stock Alias name instead of Stock item name and also can see alias in item scroll bar with all alias and items. And in invoice print show full description of Item.
 
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code to work with stock item alias at invoice time.

HOW TO USE:

        1. Load below Tally Prime Item Alias TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing in sales voucher / purchase voucher and select Item to bill.
        3. Now we can see all alias list with item, and also we can choose alias instead of item name.
        4. No changes in invoice printing.


This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Collection: Vch Stock Item Extract]
Fetch : Aliasname
Add : Format : $Aliasname,20

[#Object : Stockitem]
Aliasname : $$Alias



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

HSN and GST Rate in Stock Summary | Free TDL Code 2021

With this free TDL code we can add Item HSN code and Item GST Rate in Stock summary detail. Yes! now with this tally tdl we can use hsn and gst in stock summary and export details in excel or any other format from tally.

We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code to see stock summary with HSN and GST rate of Stock Items
HOW TO USE:

        1. Load below Tally Prime stock summary with HSN and GST Rate TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go to Stock summary, here we can see stock summary details with hsn and gst rates.
      3. Now we can export stock summary report into excel sheet to do our work easily. 


This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Field:DSPQ QTYTitle]
add:fields:after:DSP DispTitle:LearnwellSHsnT,LearnwellSRT
invisible:##DSPShowInwards
[Field:LearnwellSHsnT]
Set as :”HSN”
color:blue
style:bold
[Field:LearnwellSRT]
Set as :”GSTRate”
color:blue
style:bold

[#Field:DSP CLQty]
add:fields:after:DSP DispName:LearnwellSHsn,LearnwellSR
invisible:##DSPShowInwards
[Field:LearnwellSHsn]
Set as :$GSTHSNCode
width:20
color:red
[Field:LearnwellSR]
Set as :$GSTIGSTRate
width:20
color:red



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.

Last Purchase Rate Notification for Every Item | Tally TDL Free Code

We sale product and go to invoice for customer and forgot purchase rate of item and put wrong amount in sale bill. Oh! that’s horrible thing stop it. Yes now we can stop inputting  wrong selling price with this Tally Prime and Tally ERP 9 free TDL code. This TDL code will notify for purchase rate of item when goto sell.
We can modify this TDL code according to our need. We can add some additional fields, we can remove extra fields, and it is very simple to work with Tally Erp9 and Tally Prime. Best simple code for Last purchase rate notification.

HOW TO USE:

        1. Load below Tally Prime rate notification TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now go for invoicing , when you select item and go for enter rate detail it will popup a last purchase rate of item.
      3. Now we can prevent wrong invoicing with this TDL code. 


This is best free TDL to have in your Tally . Must have TDL file for Tally ERP9 and Tally Prime that can use for lifetime. 

This free TDL Code will work in all Tally versions. for more detail watch above Video.

TDL Code : 

[#Field:VCHBatchRate]
On:Focus:Yes:Set:LstPurRate:$$Number:$LastPurcPrice:StockItem:#VCHStockItem
Notify:MSGNotice:@@IsSales
[System:Formula]
MSGNotice:$LastPurcPrice:StockItem:#VCHStockItem

[#Field:VCHBatchRateUnits]
On:Focus:Yes:Set:LstSaleRate:$$Number:$LastSalePrice:StockItem:#VCHStockItem
Notify:MSGNotice:@@IsSales
[System:Formula]
MSGNotice:$LastSalePrice:StockItem:#VCHStockItem



HOW TO UPLOAD ABOVE CODE IN TALLY:

FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:

1. Copy the code and paste in a Text file.
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)
5b. Click on Help and click on TDL & Addon  (for Tally Prime)
5. Press F4 (to open a Box)
6. Load TDL file on Startup – Yes
7. Paste The path in blank space
8. Press enter and save 


Now your TDL is ready to use.