GST and Mobile Number in Group Summary | Best Tally Trick 2021 | Free TDL code for Tally Prime and Tally ERP9

 

In a business always we need to collection outstanding to run our business properly. In this we download outstanding reports like , payable or receivable or group details and there we need party GST number and there mobile number. If you use Tally for accounting then we can simplified it with adding GST and Mobile number in group summary. and can download a complete report for outstanding collection.

So let’s see how can we do it with some Simple TDL codes to modify Tally.

With this free TDL code we can add GST and Mobile number in Tally Group Summary.

 
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 collect outstanding reports with GSTIn and Mobile number of party.

HOW TO USE:

        1. Load below Group Summary with GST and Mobile Number TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now GST Number and Mobile Number lines will show in Group Summary of Ledgers.
        3. We can Export it into Excel and 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 perfectly work with Tally Prime.

Watch above video to learn :
1. How to add extra fields and lines in Group Summary of tally.
2. How to add GST number and Mobile Number and other tings in field value.
3. And Many More…….

TDL Code : 

[#Line:DSP ACCLine]
Option:LWTT
[!Line:LWTT]
Add:fields:LearnwellGSTD,LearnwellMob
[Field:LearnwellGSTD]
Set As:$PartyGSTIN
Width:@@Ledger
Color:Red

[Field:LearnwellMob]
Set As:$LedgerMobile
Width:@@Ledger
Color:Blue

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

Item wise Party detail in Invoice | Tally Small but Smart Trick | Best free TDL Code for Tally Prime and ERP9 for Voucher

 

If you do cash billing and also want to add party ledger name for items or do purchase from multiple suppliers and want add every item supplier name in invoice voucher, then you are in right place.

Yes! we can add party ledger name in front of every item at invoicing time and save it with tally storage to see details later.

With this free TDL code we can bill party wise items for Sale, Purchase, Debit Note, Credit Note etc., can do with every voucher that have 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 tdl code to make vouchers with separate ledger name of item.

HOW TO USE:

        1. Load below inventory invoicing with supplier detail TDL code in Tally ERP9 or in Tally Prime (Method provided below the code)
        2. Now a line will show in voucher screen in the name of Party detail after Item name.
        3. We can choose party ledger name for every item and save it with voucher.

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.
Watch above video to learn :
1. How to add extra fields and lines in voucher of tally.
2. How to add table of Ledgers, Items or other tings in field value.
3. How to make UDF Collection to store/Save own data/fields into Tally.
4. And Many More…….

TDL Code : 

[#Line:EI ColumnOne]
Option:LWPartyDT
[!Line:LWPartyDT]
Add:Field:after:VCH ItemTitle:LWPartyDetailT
[Field:LWPartyDetailT]
Use:Name Field
Info:”Party Detail”
Align:Centre
Width:40
Skip:Yes


[#Line:EI InvInfo]
Option:LWPartyD
[!Line:LWPartyD]
Add:Field:after:VCH StockItem:LWPartyDetail
[Field:LWPartyDetail]
Use:Name Field
Table:ListofLedgers,EndOfList
Show Table:Always
Width:@@NarrWidth
Storage:LearnwellStorage

[System:UDF]
LearnwellStorage:String:1021

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.



6 Digit HSN/SAC Guidelines 01-04-2021 | How to Update HSN Code in Tally | How to find HSN/SAC Code

 

As per Indian government guidelines 6 Digit HSN Codes are mandatory for Stock Items from 1st April 2021 * HSN/SAC Code turnover Up to rupees five crores – put 4 digits of HSN code * HSN/SAC Code turnover more than rupees five crores- put 6 digits of HSN Code What is HSN code? HSN (Harmonised System of Nomenclature) is an internationally accepted product coding system. In India, HSN coding is currently used under Excise, Customs, and state Value Added Tax (VAT) laws and is now also proposed to be used under Goods and Services Tax (GST) law, for classification of products/goods. Codes under GST: Under GST law, the HSN code to be used by a taxpayer for classification of goods will be based on the taxpayer’s turnover. The HSN code needs to be declared on the tax invoice and also to be reported while filing the GST returns. The HSN codes for mandatory mapping/classification of goods that need to be used by a taxpayer are as follows; ~Taxpayers whose turnover is Rs. 5 crore and above shall use 6 digit HSN code, ~Taxpayers whose turnover below Rs. 5 crore shall use 4 digit HSN code, ~8-digit HSN code for export and import of goods Primary benefit of HSN codes: When goods and offerings are recognised via their specific HSN codes, which are globally acceptable, the identification of goods becomes easy, and resultantly possibilities of misinterpretation tend to reduce. While filing GST returns online, HSN code in respect of the supply of goods and Services Accounting Code in respect of the supply of services will have to be uploaded, and there will be no need for entering the description of the goods or services while filing GST returns.

CLICK BELOW DOWNLOAD BUTTON TO DOWNLOAD EXCEL TO TALLY SOFTWARE TO UPDATE HSN CODES IN BULK in Tally :

CLICK BELOW DOWNLOAD BUTTON TO DOWNLOAD HSN CODE LIST IN EXCEL FORMAT:


2022 Best Tally TDL for Tally Prime and ERP9 | All in One GST TDL 2022 | GST Report TDL for All type Vouchers

 

To making Tally more simple we use this Daybook GST Report TDL files for Tally Prime and for Tally Erp9. It is very special TDL file that can solve your GST return filling problems. This is Free TDL file for Tally to do GST work in simple way. We generate monthly or weekly reports for sale or purchase data to filling our GST returns. Sometime we need information like GST number GST percentage, Voucher and Bill Details and there IGST, CGST, SGST amounts with all voucher type. In tally when we generate GST reports of sale or purchase or Credit Note, Debit Note or other voucher types like Journal, Receipt, Payment etc., if our data has GST ledger , It will generate all vouchers GST reports together. We can call it Daybook GST Report TDL.

With this free GST TDL code we can Export GST reports into Excel and work on it according to us. It will very helpful to file GST returns with Tally. We can use this TDL file for Tally Prime and Tally ERP9

 
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 Generate GST Reports.

HOW TO USE:

        1. Download with given link and Load Daybook GST Report TDL code in Tally ERP9 or in Tally Prime (Method provided below )
        2. Now a line will show in the name of Learnwell-GST in our tally home screen Gateway of Tally.
        3. Click on it  and provide date for the period that you want to see and Export GSTIN report.
        4. You can also give a range to filter GST reports according to your need.

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. 


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:

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.