MSME TDL FOR TALLY PRIME

2024 Most Popular MSME TDL for Tally Prime | Optimizing MSME Operations with TallyPrime

5/5 - (1 vote)

MSME TDL for Tally Prime file can help you to customize your TallyPrime to suitable with Micro, Small, and Medium Enterprises (MSMEs) Businesses. Tally Prime, a popular accounting and business management software, offers a powerful solution of everything with the help of TDL files. In this blog post, we delve into the world of MSME TDL (Tally Definition Language) customization for Tally Prime, exploring its features and benefits.

With this Tally TDL we can add MSME number and MSME type in Company Details, Party Ledgers, Ledger Statements, Billwise outstandings and also in Invoice Printing.

Understanding MSME TDL for Tally Prime file:

TDL, or Tally Definition Language, serves as the customization language of Tally Prime. It allows users to extend the functionality of Tally Prime to suit specific business needs. MSMEs, with their unique requirements, can leverage TDL to optimize their accounting and operational processes.

Importance of Tally Prime MSME TDL:

MSMEs often face challenges such as complex invoicing, GST compliance, inventory management, and the need for customized financial reports. MSME TDL in Tally Prime becomes a valuable asset in overcoming these challenges, offering tailored solutions to streamline operations.

Change Display and Entry language in Tally Prime

MSME TDL FOR TALLY PRIME

Key Features of Tally Prime MSME TDL:

Invoice Customization:

MSMEs can customize their invoices through TDL to reflect their MSME Number and Type Along with Customer’s MSME Number and Type. It will show in Company Details and in Buyer and Consignee Details

Ledger and Outstanding Reports:

MSMEs can create customized financial reports using TDL, tailoring them to their specific needs. This includes Ledger statements and Bill wise outstanding statements. This MSME TDL for Tally Prime will help to add MSME number and MSME Type in Reports.

MSME Number and Type in Company Detail and Party Ledger Details:

We can add MSME Number and MSME type of our company in Company section in Tally Prime and also We can add MSME Number and MSME type of our company in Ledger Creation section in Tally Prime.

MSME TDL Tally Prime Download Link :

Download full MSME TDL for Tally Prime with Below Link:

MSME TALLY PRIME TDL:

HOW TO USE TDL CODE:
  • Download above TDL code and create a text file.
  • Save text file and load in Tally
  • Fill MSME number and MSME type in Company Creation Screen.
  • Fill MSME Number and MSME type in Party Ledger.
  • Now you can see MSME Number and MSME type in Ledger Statements, and Bill Wise Statements and also in Print.

This is best TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

How to Create MSME TDL Code Video:

See the below video to learn how to Create MSME TDL file for Tally Prime:

Watch above videos to learn :

  • How to Modify Company and Ledger Details and Add Own Details in Tally through TDL Code.
  • How to Use Ledger UDF fields in Report and Invoice Print.
  • How to create MSME TDL for Tally Prime.
  • How to use TDL files in Tally Prime.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\MSMETDL.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your GST Summary TDL file for Tally Prime is ready to use.

Change Display and Entry Language in Tally Prime 4.0

Best Method to Change Display and Entry Language in Tally Prime 4.0

5/5 - (1 vote)

Here is Best Method to Change Display and Entry Language in Tally Prime 4.0. In India there are multiple languages used by people. We use languages like, Hindi, Gujarati, Tamil, Telugu, Kannad, Malyalam etc languages. Local language will be better to understand our business and people. And in Tally Prime we can change data entry language and also display language.

In this blog post, we’ll delve into the seamless language-changing capabilities of Tally Prime, with a focus on languages like Hindi, Gujarati, Tamil, Telugu, Arabic, Kannada, Malayalam, and more.

Change Display and Entry Language in Tally Prime 4.0:

Tally Prime makes it easy for users to switch the display language, ensuring that the software interface is accessible and user-friendly for individuals from different linguistic backgrounds. Here’s a step-by-step guide on how to change the display language in Tally Prime:

  1. Open Tally Prime
  2. Goto Help – Setting – Language
  3. There are two Options 1st is Display language and 2nd is Data Entry language
  4. We can select more options of languages in Data Entry languages. (But in Display language have only English. Follow below steps to add more languages in Display language also)
Change Display and Entry Language in Tally Prime 4.0

Also See Movement Analysis Reports

More TDL Related files on E2T Website

Add More Languages in Tally Prime Display Language Section:

Download Languages files from above button and follow below steps:

Goto Tally Installation folder

tally languages

Find language Folder and Paste Downloaded languages files into folder

tally prime language
tally prime language

Now Restart Tally and goto Tally Setting – languages -display language to change Tally Language for More Details watch below video:

Movement Analysis Tally Prime TDL

2024 New GST Details in Movement Analysis Tally Prime TDL | GST, Address, Mobile, HSN, Item Tax Rate in Movement Analysis Tally Prime

5/5 - (1 vote)

In this post we will add GST Details in Movement Analysis Tally Prime TDL that will help to track customer details along with there GST Number, Address and Mobile Number. We also add Stock Item GST details like GST Rate and HSN code.

Movement Analysis in Tally Prime plays a pivotal role in understanding the movement of goods, tracking stock transfers, and analyzing sales and purchases.

GST Details in Movement Analysis Tally Prime TDL:

By incorporating GST details within Movement Analysis, businesses can streamline their GST-related processes, ensuring compliance and facilitating seamless transactions.

Movement Analysis Tally Prime TDL

How to Access Movement Analysis in Tally Prime:

Movement analysis report is used for comparative studies. They give an insight into the flow characteristics of the stock in an organization. It also helps in finding out the slow moving items which cause blockages in the flow of the working capital of the organization.

● Go to Gateway of Tally > Display More Reports > Statement of Inventory > Movement Analysis .

Also Read How to Access Movement Analysis Reports in Tally Prime

Movement Analysis Tally Prime TDL Code:



[#Line:STKLAnalLine]
Add:Field:After:DSPACCName:LWMA

[Field: LWMA]
Use:Small Size Field
Set as:"GSTIN: " + $PartyGSTIN + " | Address: " + $$FullList:Address:$Address + "  | Mobile: " + $LedgerMobile
Color:Red
	
[#Line:STK AnalLine]
Add:Field:After:DSPACCName:LWMLdRateHSN

[Field:LWMLdRateHSN]
Use:Name Field
Set as:"GSTIN: " + $$String:$GstDetails[Last].STATEWISEDETAILS[1].RateDetails[1, @@IsIGST].GSTRate + "%" + "  | HSN: " + $$String:$HSNDetails[Last].HSNCode
Color:Red

Movement Analysis Tally Prime TDL:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file.
  • Save text file and load in Tally
  • Now go in Movement Analysis Report.
  • You can see additional details with ledgers and stock items.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

Movement-Analysis Tally Prime TDL Video:

See the below video to learn how to customize Reports in Tally Prime through TDL:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to customize tally Reports through TDL.
  • How to access movementanalysis of Tally.
  • How to add GST details of Ledgers and Stock Items.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\MovementAnalysis.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Custom MovementAnalysis TDL for Tally Prime is ready to use.

Integrating GST details within Movement Analysis in Tally Prime using TDL empowers businesses to streamline their operations, enhance compliance, and facilitate smoother transactions. By customizing the software to incorporate these essential details, businesses can navigate the complexities of GST requirements with greater ease and efficiency.

Custom Invoice Tally Prime TDL

2024 Popular Custom Invoice Tally Prime TDL | Invoice Customization TDL for Tally Prime

5/5 - (1 vote)

If you use Tally and have a fixed format of Invoice Print that looks basic, then you can try this Custom Invoice Tally Prime TDL.

With this Invoice Customization TDL for Tally Prime you can change font and size of heading of your Invoice and also can change font and size of your company details in invoice that looks better and professional.

Custom Invoice Tally Prime TDL:

With this Custom Invoice Tally Prime TDL we can modify the layout and design elements of invoices. Here’s what you can achieve through this customization:

Font and Size Modification of Invoice in Tally:

Heading Customization: You have the flexibility to change the font style, color and size of the invoice heading, making it more prominent and aligned with your brand’s visual identity.
Company Details: Customize the font and size of your company details on the invoice.

Grid Lines on Item Details of Invoice in Tally:

Grid lines on item details area make Invoices more professional and clear look of Item details.

Enhanced Professionalism of Invoices in Tally:

By fine-tuning the fonts and sizes, you can create a more polished and professional look for your invoices, leaving a lasting impression on clients and stakeholders.

Also checkout Amazing GST Summary TDL

Custom Invoice Tally Prime TDL

Invoice Customization TDL for Tally Prime TDL code:

[#Line:Expinv INVDetails]
Local:Field:Default:Border:Thin Box

[#Line:EXPINV Title]
Local:field:simple field:Style:LearnwellStyle
Local:field:Default:Border:Totals
Local:field:Default:Print BG:Grey

[#Line:EXPINV Company]
Local:field:Default:Style:LearnwellStyle2

[Style:LearnwellStyle]
Use:Normal Bold
Height:15
Font Name:Stencil

[Style:LearnwellStyle2]
Use:Normal Bold
Height:20
Font Name:Raleway

Custom Invoice Tally Prime TDL:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file.
  • Save text file and load in Tally
  • Create an invoice and See Print Preview.
  • You can see changes in Invoice print.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

Invoice Customization TDL for Tally Prime Video:

See the below video to learn how to customize Invoice in Tally Prime through TDL:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to customize tally Invoices through TDL.
  • How to font in Invoice of Tally.
  • How to color Tally invoice.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\CustomInvoice.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Custom Invoice TDL for Tally Prime is ready to use.

In the competitive business landscape, every interaction with clients and stakeholders matters. Invoices, often overlooked as mere financial documents, present an opportunity to reinforce your brand’s professionalism. With the Custom Invoice Tally Prime TDL, you can transform the appearance of your invoices from basic to sophisticated, leaving a lasting impression and elevating your brand image.

GST SUMMARY TDL

2024 MOST AMAZING GST SUMMARY TDL | GST SUMMARY TDL FOR TALLY PRIME

Rate this post

If you want to file GST returns on Time without any error, then this GST Summary TDL is for you. With this GST Summary TDL for Tally Prime and Tally ERP9 you can see Invoice wise and Party wise and State wise GST Totals. It works like Pivot Table, that can help you submit your GST returns on time without wrong GST filing.

GST Summary TDL:

  • The GST Summary TDL enables users to access granular insights, breaking down GST totals at multiple levels—Invoice-wise, Party-wise, and State-wise. This level of detail ensures a thorough understanding of GST data before filing returns.
  • By functioning like a Pivot Table, this TDL minimizes the chances of errors in GST filings. Users can review and reconcile data accurately, significantly reducing the risk of incorrect GST submissions.
  • The ability to view GST data across different parameters. You can see Sales, Credit Note, Purchase vouchers in Single Screen.
GST SUMMARY TDL

GST Summary TDL code:

[#Menu : Gateway of Tally]
Add : Item : LearnWell GST :Display :Learnwell GST Summary

[Report :Learnwell GST Summary]
Title:GST Summary
Variables : SV CurrentCompany
Form :Learnwell GST Summary
Variable : SVFromDate,SVToDate
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Set : Is Day Book : Yes

[Form :Learnwell GST Summary]
Part :DSP AccTitles, LWTitles, LWGSTPurchase,LWDBTitle2Bot
Buttons : ChangeDybkDate,ChangePeriod
Background :Light Autumn Green
Page Break :LWPageBreak2
Width : 100 % Page
Height : 100 % Page
Space Bottom : 0.50
Space Left : 0.50
Space Right : 0.50
Space Top : 0.50
Vertical Align : Center
Horizontal Align : Center


[Part: LWPageBreak2]
Part: LWTitles

[Part : LWTitles]
Use : LWGSTPurchase
Delete : Repeat
Delete : Scroll
Border : ColumnTitles
Local : Field : Default : Type : string
Local : Field : LWParty: Set As : "Party Name"
Local : Field : LWGST : Set As : "GST No" 
Local : Field : LWRef : Set As : "Ref No"
Local : Field : LWVCHv : Set As : "VCH No" 
Local : Field : LWVCHd: Set As : "VCH Date"
Local : Field : LWVCHT: Set As : "VCH Type"
Local : Field : LWVCHs: Set As : "State"
Local : Field : LWRefDate : Set As : "Ref Date"
Local : Field : LWtotal1 : Set As : "Basic Amount"
Local : Field : LWtotal3 : Set As : "CGST "
Local : Field : LWtotal4 : Set As : "SGST "
Local : Field : LWtotal2 : Set As : "IGST "
Local : Field : LWtotal5 : Set As : "Invoice Amount"
Local :Field : Default : Style : Small Bold
Local: Field: Default: Align: Center 
Local: Field: Default: Background: Very Light Orange
Border : Totals

[Part :LWGSTPurchase]
Line : LWGSTPurchase
Repeat :LWGSTPurchase :LearnwellCollGSTPur
tOTAL : LWtotal1,LWtotal2,LWtotal3,LWtotal4,LWtotal2,LWtotal5
Common Border : Yes
Scroll : Vertical

[Line :LWGSTPurchase]
Field :LWVCHT,LWVCHv,LWVCHd,LWRef,LWRefDate,LWParty,LWGST,LWVCHs,LWtotal1,LWtotal2,LWtotal3,LWtotal4,LWtotal2,LWtotal5
Option : Alter on enter
Option : DisplayOnAltEnter 

[Field :LWRefDate]
Use : Short Date Field
Set As : $ReferenceDate
Border : Thin Right 
Format:"Short Date"
Style:Small
[Field :LWVCHd]
Use : Short Date Field
Set As : $Date
Border : Thin Right 
Format:"Short Date"
Style:Small
[Field :LWVCHv]
Use : Name Field
Set As : $VoucherNumber
Border : Thin Right 
Width:10
Style:Small
[Field :LWVCHT]
Use : Name Field
Set As : $VoucherTypeName
Border : Thin Right 
Width:10
Style:Small
[Field :LWVCHs]
Use : Name Field
Set As : $StateName
Border : Thin Right 
Width:10
Style:Small
[Field : LWParty]
Use : NAme Field
Set As : $LedgerName
Width : 30
Border : Thin Right 
Alter : Voucher
Display : Ledger Vouchers:$$ISLedger
Variable: Ledger Name
Style:Small
[Field : LWGST]
Use : Name Field
Set As :$PartyGSTIN:Ledger:$PartyLedgerName
Width : 11
Border : Thin Right 
Style:Small
[Field : LWRef]
Use : NAme Field
Set As : $REFERENCE
Width : 10
Border : Thin Right
Align:Center
Style:Small

[Field : LWtotal1]
Use : Amount Field
Set As: $$CollAmtTotal:allinventoryEntries:$Amount + $$FilterAmtTotal:LedgerEntries:BASIC1:$Amount + $$FilterAmtTotal:LedgerEntries:BASIC2:$Amount
Border : Thin Right
Format:"DrCr,NoZero"
[Field : LWtotal3]
Use : Amount Field
Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
Border : Thin Right 
Width : 10
Format:"DrCr,NoZero"
[Field : LWtotal4]
Use : Amount Field
Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount
Border : Thin Right 
Width : 10
Format:"DrCr,NoZero"
[Field : LWtotal2]
Use : Amount Field
Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount
Border : Thin Right 
Width : 10
Format:"DrCr,NoZero"
[Field : LWtotal5]
Use : Amount Field
Set As : $Amount 
Format:"DrCr,NoZero"
[System: Formula]
SGST :$$FilterAmtTotal:LedgerEntries:SGST1:$Amount
SGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SGST"
CGST :$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
CGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"CGST"
IGST :$$FilterAmtTotal:LedgerEntries:IGST1:$Amount
IGST1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"IGST"
BASICS :$$FilterAmtTotal:LedgerEntries:BASIC1:$Amount
BASIC1 :$Name:Ledger:$LedgerName Contains $$LocaleString:"SALE"
BASICP :$$FilterAmtTotal:LedgerEntries:BASIC2:$Amount
BASIC2 :$Name:Ledger:$LedgerName Contains $$LocaleString:"PURCHASE"

[Collection : LearnwellCollGSTPur]
Type : Ledger
Type : Vouchers 
Walk : allLedgerEntries
Filter : LWVoucherType
Fetch : Date,Amount,VoucherTypeName ,PArtyLedgerName,VoucherNumber,REFERENCE,ReferenceDate, GSTDutyAmount,BASICBUYERNAME,CGSTAmount,SGSTAmount,IGSTAmount
Fetch : *.*

Compute:IGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100 
Compute:CGSTAmount :$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2
Compute:SGSTAmount:$$CollAmtTotal:InventoryEntries:$Amount * $(Stockitem,$stockitem).GSTIGSTRate / 100/2

[Part: LWDBTitle2Bot]
Lines : daybookTotalLine2
[Line: daybookTotalLine2]
Use : LWGSTPurchase 
Local: Field: Default : Style : Small Bold
Local: Field: Default: Align: Right
Local : Field : LWParty: Set As : "Total"
Local : Field : LWRef : Set As : ""
Local : Field : LWtotal1 : Set As : $$Total:LWtotal1
LOCAL : FIELD: LWtotal3:Set as:$$Total:LWtotal3
LOCAL : FIELD: LWtotal4:Set as:$$Total:LWtotal4
LOCAL : FIELD: LWtotal2:Set as:$$Total:LWtotal2
LOCAL : FIELD: LWtotal5:Set as:$$Total:LWtotal5
Border : Totals
Local: Field: Default: Background: Very Light Orange

[System: Formula]
LWVoucherType : $$IsPurchase:$VoucherTypeName or $$IsSales:$VoucherTypeName or $$IsDebitNote:$VoucherTypeName or $$IsCreditNote:$VoucherTypeName
CSTFilter2 : not ##IsRevChargeAppl

GST SUMMARY TALLY PRIME TDL:

HOW TO USE TDL CODE:
  • Copy or Download above TDL code and create a text file.
  • Save text file and load in Tally
  • In Gateway of Tally you will find Learnwell GST Tab.
  • Click the Learnwell GST summary Tab to See the GST Reports.
  • Change Tally Period 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 it for lifetime. This free TDL Code will perfectly work with Tally Prime.

GST Summary TDL Code Video:

See the below video to learn how to See GST Summary in Tally Prime:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to see GST Summary of Tally in one place.
  • How to change period in tally for GST.
  • How to customize GST report in Tally Prime.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\GSTSummary.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your GST Summary TDL file for Tally Prime is ready to use.

The GST Summary TDL for Tally Prime and Tally ERP9 is a remarkable addition to the arsenal of tools available for businesses navigating GST compliance. Its ability to offer intricate insights, prevent errors, and expedite the filing process is invaluable in today’s regulatory landscape.

GST Number in GSTR3B

GST Number in GSTR3B – Tally Prime 3 TDL

5/5 - (1 vote)

If you use Tally Prime 3 , there is no GST number in GSTR3B report, but we required sometime. so with this TDL file we can add GST number in GSTR3B report Also.

For businesses accurate and comprehensive reporting is crucial. Tally Prime 3, a prominent accounting software, is widely utilized for its robust functionalities, yet some users encounter limitations, particularly the absence of the GST number in the GSTR-3B report. Addressing this gap by customizing the report through TDL (Tally Definition Language) can prove beneficial.

GST Number in GSTR3B:

The GSTR-3B report acts as a vital summary, encapsulating essential tax details for a specific period under GST regulations. However, the absence of the GST number within this report in Tally Prime 3 could pose challenges for businesses needing this critical information for their records or compliance obligations.

Also checkout Most Amazing Invoice Customization TDL

GST Number in GSTR3B

GST Number in GSTR3B in Tally Prime 3 TDL Code:

[#Line:GSTRSTATVCHSColTitle1]
field:LWTitleGST
[field:LWTitleGST]
Set as:"GST Number"
Background:Yellow
Color:Red
[#Line:GSTRStatVCHSDtls]
Border:Thin Box
Field:LWGSTNu
[Field:LWGSTNu]
Set as:$GSTVCHPartyGSTIN
Background:Yellow
Color:Red

GST Number in 3B Report TDL:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file.
  • Save text file and load in Tally
  • Goto see GSTR3B report, there you will find GST Numbers of Party along with Party name (watch the below video for more details).
  • Now You can see GST Numbers in 3B report in Tally Prime 3.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

GST Number in GSTR3B in Tally Prime 3 TDL Code Video:

See the below video to learn how to customize GST 3B report in Tally Prime:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to add own details in Tally TDL
  • How to create TDL file.
  • How to customize GST 3B report in Tally Prime.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\3BTDL.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your GSTR3B TDL file for Tally Prime is ready to use.

Customized Invoice Tally Prime TDL

2023 Most Amazing Customized Invoice Tally Prime TDL | Normal & E-Invoice Format TDL

5/5 - (1 vote)

With this Customized Invoice Tally Prime TDL we can provide professional invoices to our customers, even want to create Normal Invoice or E- Invoice. In these invoice format can show your logo and company details like address and GST and QR in top of Invoice. And also change Item listing in header colors and font.

This is best and good looking invoice format for both Normal & E-Invoice. With Tally Definition Language (TDL), users can further personalize their invoices to meet specific business needs

Customized Invoice Tally Prime TDL:

Normal invoices are the standard format used for billing purposes. This Invoice TDL allows users to customize these invoices extensively. With this Normal & E-Invoice Format TDL, businesses can:

Adding Company Logo and Details:

Incorporate your company logo, address, GST details, and other pertinent information at the top of the invoice for a personalized touch.

QR Code Integration:

In normal invoices adding QR code of Bank Payment detail and and in E- Invoice, E- Invoice QR code along with Bank Payment QR code.

Invoice Details and Party Details in Horizontal form:

To save extra spaces of invoice changed invoice details like, Invoice number, Date, references etc. and Buyer and Consignee Details in Horizontal form in Invoice.

Changing Item Listing looks:

Modify the item listing section’s colors, fonts, and layout in the header to align with your brand aesthetics.

Customized Invoice Tally Prime TDL

Also checkout Manual Books TDL for Tally Prime

Customized E- Invoice and Normal Invoice TDL code:

Tally Prime’s flexibility combined with TDL empowers users to create tailored invoices that reflect their brand identity and meet regulatory requirements.

[#Part: EXPINV SaleTopLeft]
Height      : If ($$InExportMode OR $$InMailAction OR $$InUploadAction) AND ($$IsSysNameEqual:Excel:##SVExportFormat OR $$IsSysNameEqual:HTML:##SVExportFormat) THEN +
							(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry)  ELSE +
							(10 + 10 + @WithOrderVch + @WithOrderTerms + @WithBuyer + @WithCountry) % page
	
	Delete: Parts: EXPINV Company	
	
[#Form: Printed Invoice]
Add:Parts:LWCMPDetails,LWTaxTitle,LearnwellEQR

[Part:LWTaxTitle]
Add:Line:LwTTLine
Border:thin bottom
Space Top:.5
[Line:LwTTLine]
Add:Field:LWTTF
Border:Thin Top
[Field:LWTTF]
Set as:"Tax Invoice"
Full Width:Yes
Align:Centre
Style:Invstyle
[Style:Invstyle]
Use: Normal Bold
Height:15

[Part:LWCMPDetails]
Add:Parts:CMPLogo,CMPdtl,LWSCPay
Space Bottom:.5
Width:100% page
[Part:CMPLOGO]
Part :LearnWellLOGO
Vertical : Yes
[Part :LearnWellLOGO]
Horizontal Alignment :Left
Vertical : No
Lines :LWLG
Graph Type: ##SALogoPath
Height : 12% page
Width : 15% Page
[Line :LWLG]
Field :LWLGF
[Field :LWLGF]
Set As : ""

[Part:CMPdtl]
Lines:LWCMPName,LWCMPAdd
Repeat:LWCMPAdd:CompanyAddress
[Line:LWCMPName]
Field:LWCMPName
[Field:LWCMPName]
Use:name field
Set as:@@CMPMailNAme
Full Width:Yes
Align:Centre
Style:Cmpstyle
[Line:LWCMPAdd]
Field:LWCMPAdd
[Field:LWCMPAdd]
Set as:$address
Align:Center
Full Width:Yes
Style:ADDStyle
[Style:Cmpstyle]
Use: Normal Bold
Height:20	 
[Style:ADDStyle]
Height:10
Use:Normal  
[#Part: EXPINV Signature]
Delete:Border
[#Part: EXPINV Column]
Border:Thick Box
Delete:Line:EXPINV Column2
Local : Field : Default : Style :Normal Bold
Local : Field : Default : Print FG :White
Print BG:Black

[#line : EXPINV invdetails]
option:bg print:@@oddline
[!line:bg print]
local : field : default : print bg :Light grey
[system:formulae]
OddLine : $$IsOdd:$$Line

;---------------------------------------------
[#Part: EXPINV OpPageBreak]
Delete: Parts:EXPINV Title
Delete:Parts:EXPINV Leading
Add:Parts:Before:EXPINV Column:LearnwellInvNo1,LearnwellInvNo

[#Part : Expinv Rightsign]
Delete : Bottom Parts
Add:Bottom Part:EXPINV Signature
                        
[Part:LearnwellEQR]
Add:Part:LWEInv1,LWEInvQR,LearnwellBankQR
Border:Thin box
Invisible: NOT ##SAGSTWithQRInfo OR $$IsEmpty:@@eInvoiceQRCValue OR NOT @@IsVchGSTeInvAppl
[Part:LWEInv1]
Line: LWExpinv IRN, LWExpinv AckNo, LWExpinv AckDate
Local: Line	: LWExpinv AckNo		: Space top		: 0.10
Local: Line	: LWExpinv AckDate	: Space top		: 0.10
Space Top:.5
[Line: LWExpinv IRN]
Use	: LWeInv IRN Details Template
Local: Field: Medium Prompt	: Set as	: $$LocaleString:"IRN"
Local: Field: Name Field	: Set as	: @@GSTeInvIRN
Local: Field: Name Field	: Width		: 30% Page
Local: Field: Name Field	: Line		: 03
[Line: LWExpinv AckNo]
Use	: LWeInv IRN Details Template
Local: Field: Medium Prompt	: Set as	: $$LocaleString:"Ack No."
Local: Field: Name Field	: Set as	: If ##IseInvPSPrintAfterSave Then ##eInvPSAckNo Else $IRNAckNo
[Line: LWExpinv AckDate]
Use	: LWeInv IRN Details Template
Space Bottom: 0.25
Local: Field: Medium Prompt	: Set as	: $$LocaleString:"Ack Date"
Local: Field: Name Field	: Set as	: If ##IseInvPSPrintAfterSave Then $$String:##eInvPSAckDate Else $$String:$IRNAckDate
[Line: LWeInv IRN Details Template]
Field: Medium Prompt, Name Field
Local: Field: Medium Prompt	: Width		: 4			
Local: Field: Medium Prompt	: Style		: Small
Local: Field: Name Field	: Style		: Small Bold

[Part:LWEInvQR]
Part:LWeInvoice QRC Title2, LWeInvoice QRC Title
Vertical: Yes
[Part: LWeInvoice QRC Title]
Line: LWeInvoice QRC Title
[Line: LWeInvoice QRC Title]
Field: LWeInvoice QRC Title
Space Bottom: 0.5
[Part: LWeInvoice QRC Title2]
QRCode: @@eInvoiceQRCValue : Yes
Line: LWeInvoice QRC Title2
Width: 20% page
Height: 10% Page
[Line: LWeInvoice QRC Title2]
Field: Info Field
[Field: LWeInvoice QRC Title]
Use	: Simple Field
Set as: $$LocaleString:"e-Invoice"
Style: Small Bold
Width: Normal
	
[Part :LearnWellBankQR]
Parts :EXPINV BankDetails,LearnWellQrP
Border:Thin box
Space Top:.5
[Part :LearnWellQrP]
Part :LearnWellQRCode
Vertical : Yes
[Part :LearnWellQRCode]
Horizontal Alignment : Right
Vertical : No
Lines :LWQrL
QR code: ("upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No. "+$$String:$voucherNumber) : True
Height : 12% page
Width : 15% Page
[Line :LWQrL]
Field :LWQrF
[Field :LWQrF]
Set As : ""

[Part:LWSCPay]
Part :LearnWellQRIn,qrtxt
Vertical : Yes
Invisible:NOT $$IsEmpty:@@eInvoiceQRCValue
[Part :LearnWellQRIn]
Lines :LWQrLn
QR code: ("upi://pay?pa=9131810293@ybl&pn=AshishKumarSingh&tn=Bill No."+$$String:$voucherNumber) : True
Height : 8% page
Width : 12% Page
[Line :LWQrLn]
Field :LWQrFn
[Field :LWQrFn]
Set As : ""
[Part:qrtxt]
Line:as
[Line:as]
Field:as
[Field:as]
Use:name field
Set as:"Scan to Pay"

[Part:LearnwellInvNo]
Parts:EXPINV Consignee, EXPINV ConsigneeContact, EXPINV Buyer, EXPINV Contact
Bottom Parts: EXPINV Country
Vertical    : No
Border:Thin box
[Part:LearnwellInvNo1]
Parts:LWBSLeft,LWBSMiddle,LWBSRight
Vertical:Yes
Border:thin box
[Part:LWBSLeft]
Parts       : EXPINV Number,EXPINV Date,EXPINV SupplierRef,EXPINV DelNote,EXPINV ShipDate
Vertical    : No
[Part:LWBSRight]
Parts       : EXPINV DueDate, EXPINV OtherRef, +
              JWInOutInv MotorVehicleNo, +
			  EXPINV PlaceOfRcpt, EXPINV PortDischarge, JMInOutInv ProcessingDuration
Vertical    : No
[Part:LWBSMiddle]
Parts: EXPINV OrderNumber, EXPINV OrderDate, EXPINV ShipDoc,EXPINV Destination,JWMTIn ChallanNo,EXPINV PreCarr, EXPINV Vessel, EXPINV PortLoading, JMInOutInv EmptyPart
Border:thin box

Invoice TDL:

HOW TO USE TDL CODE:
  • Copy or Download above TDL code and create a text file.
  • Save text file and load in Tally
  • Goto print and sales invoice, and enable bank details etc. (watch the below video for more details).
  • You can see changed invoice format.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

Customized Invoice Tally Prime TDL Video:

See the below video to learn how to use Custom Invoice TDL in Tally Prime:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to add own details in Tally TDL
  • How to create TDL file.
  • How to customize invoice with TDL.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\InvoiceTDL.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Invoice TDL file for Tally Prime is ready to use.

By leveraging Tally Prime’s TDL capabilities, you can craft professional and personalized invoices for both Normal and E-Invoice formats. Incorporating your company logo, details, QR codes, and adjusting the visual aspects of the item listing allows you to present a consistent brand image while meeting the necessary invoicing standards. This level of customization not only enhances the professionalism of your invoices but also helps strengthen your brand identity with every interaction.

Manual Books TDL

2023 Most Amazing Manual Books TDL for Tally Prime

5/5 - (1 vote)

Manual Books TDL for Tally Prime will be very beneficial for our business. With this Tally Prime TDL we can customize our Tally Ledgers as old type Khata Books. This will help a lot to reconcile our Statements / Ledgers.

Also with this TDL fetch all details of ledger like, Cheque Number, Reference Number, Voucher Number etc. Additionally, it allows you to view ledgers with separate debit and credit sections. In this blog post, we’ll explore the significance of this TDL and how it can revolutionize your accounting experience.

Manual Books TDL:

The Manual Books TDL is a custom Tally TDL code designed to bridge the gap between modern accounting practices and the timeless charm of Khata Books. It empowers businesses to customize their Tally Ledgers for a more familiar and intuitive experience. The TDL simplifies the process of reconciling statements and ledgers, making it more intuitive and efficient.

Also Checkout HSN SAC code list at Entry Time TDL for Tally Prime

Manual Books TDL

Manual Books TDL Code for Tally Prime:

Customize your Tally Ledgers Statement to resemble the format of traditional Khata Books, providing a familiar and user-friendly interface.

[Button :LearnwellCashbook]
Key : CTRL+7
Title : "Manual Books"
Action :Display Collection:LearnwellMBook
[#Form :Default]
    Add:Top Button:At Beginning:LearnwellCashbook
[Collection: LearnwellMBook]
Type : Ledger
Belongs To : Yes
Variable : LedgerName
Report :LearnweLDRSt
Trigger :LearnweLDRStCll

[Report :LearnweLDRStCll]
Use : Collection Variable
Local : Line : Collection Variable : Add : Field :LearnwellSttment

[Field:LearnwellSttment]
Use : Name Field
Variable : LedgerName
Modifies : LedgerName
Table : LearnwellMBook
Show Table : Always

[Report :LearnweLDRSt]
Variable : SVFromDate, SVToDate
Set : SVfromDate:$$FinYearBeg:##StartDate:$StartingFrom:Company:##SVCurrentCompany
Set : LedgerName : ##LedgerName
Variable : IsMultiPage, InNewPages
Set : IsMultiPage : yes
Set : InNewPages : yes
Set : SVToDate : ##SVCurrentdate
Form :LearnwellSttmForm
Variable : GroupName
Set : Is Ledger Report : Yes
Set : DSPWithOpening : Yes

[Form :LearnwellSttmForm]
Height : 100% Screen
Width : 100% Screen
Space Top : If $$InPrintMode Then 0.5 Else 0 inches
Button : Change Period,ChangeLedger,Print Button,Export Button,BottomToolBarBtn6,BottomToolBarBtn7,BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11
Parts :LearnwellSttmTitle,LearnwellSttmDetl

[Part :LearnwellSttmTitle]
Space Bottom : 0.2 inch
Add:Lines:At End:LearnwellSttmPrty,LearnwellSttmPeriod


[Line:LearnwellSttmPrty]
Field:LearnwellSttmPrtyField

[Field:LearnwellSttmPrtyField]
Use :Name Field
SetAs:##LedgerName
Width:150 mms
Local:STYLE:DEFAULT:Height:12
Full Width:Yes
Align:Center

[Line:LearnwellSttmPeriod]
Field:LearnwellSttmPeriodField
Space Top:0.5
Border:thin bottom

[Field:LearnwellSttmPeriodField]
Use:name field
Set as:$$LocaleString:"From " + $$String:##SVFromDate + " to " + $$String:##SVToDate
Align : Center
Full Width : Yes
Local:Style:defualt:Height:15
Style:large bold

[Part:LearnwellSttmDetl]
Right Part:LearnwellSttmDetlRight
Left Part:LearnwellSttmDetlLeft

[Part:LearnwellSttmDetlLeft]
Line:LWTTlinfoL,LWTTlbalL,LWTTlbalLTTLf
Repeat:LWTTlbalLTTLf:LWTTlbalcollL
Bottom Line:LWTTCLGTotalL,LWTTCLGTotalLField
Bottom Line:LWTTCLGTotalL1,
Scroll:Vertical
Float:no
Common Border:Yes
Total:LWLVCHDebitAmt

[Part:LearnwellSttmDetlRight]
Line:LWTTInfoR,LWTTBALR,LWTTTitleR
Repeat:LWTTTitleR:LWTTInfoRColl
Bottom Line:LWTTInfoRTotal, LWTTCLGTotalLFieldRT
Bottom Line:LWTTInfoRTotal1,
Scroll:Vertical
Float:no
Common Border:Yes
Total:LWLVCHCreditAmt

[Line:LWTTlbalL]
Fields:LWOpBalTT
Right Fields : LWOpBalD
Border: Thin BOttom

[Field:LWOpBalTT]
info :$$localestring:"Opening Balance :"
width : 50
Inactive: If $$IsEmpty:#LWOpBalD then Yes Else No
Align:Right
Background:Light Blue

[Field:LWOpBalD]
Use : Amount Field
Set as : If $$IsDr:$Openingbalance:Ledger:##LedgerName then $Openingbalance:Ledger:##LedgerName else ""
Skip : Yes
style : Tiny Bold
Format : "Symbol,DrCr"
Width : 16
Background:Light Blue

[Line:LWTTCLGTotalL]
Fields:LWCLbalLTtot
Right Fields: LWCLbalLtot
Border: Thin Top

[Field:LWCLbalLTtot]
info :$$localestring:"Debit Total :"
width : 50
Align: Right
Widespaced: Yes
Background:Crystal Blue

[Field:LWCLbalLtot]
Use : Amount Field
Set as : $$Total:LWLVCHDebitAmt + #LWOpBalD
Skip : Yes
style : normal
Format : "Symbol,DrCr"
Width : 16
Align:Right

[Line:LWTTCLGTotalL1]
Fields:LWCLbalLTtot1
Right Fields: LWCLbalLtot1
Border: Totals

[Field:LWCLbalLTtot1]
info : $$localestring:"Current Total :"
Width : 50
Widespaced: Yes
Align: Right
Background:Crystal Blue

[Field:LWCLbalLtot1]
Use : Amount Field
Set as : #LWCLbalLtot + #LWCLbalL
Skip : Yes
style : normal bold
Width : 16
Align: Right


[Line:LWTTCLGTotalLField]
Fields:LWCLbalLT
Right Fields: LWCLbalL



[Field:LWCLbalLT]
info :$$localestring:"Closing Balance :"
width : 50
Inactive: If $$IsEmpty:#LWCLbalL then Yes Else No
Widespaced: Yes
Align: Right
Background:Light Blue

[Field:LWCLbalL]
Use : Amount Field
Set as : If $$IsDr:$ClosingBalance:Ledger:##LedgerName then 0 else $ClosingBalance:Ledger:##LedgerName
Skip : Yes
style : Normal Bold
Format : "Symbol,DrCr"
Width : 16
Align:Right

[Line:LWTTlinfoL]
Field:LWLVCHDDate,LWLVCHDParticulars,LWLVCHDType,LWLVCHDReference,LWLVCHDChqNum,LWLVCHDebitAmt
Local:Field:LWLVCHDDate:Info:"Date"
Local:Field:LWLVCHDParticulars:Info:"Particulars"
Local:Field:LWLVCHDReference:Info:"VCH No."
Local:Field:LWLVCHDChqNum:Info:"Ch./Ref. No."
Local:Field:LWLVCHDType:Info:"Vch.Type"
Local:Field:LWLVCHDebitAmt:Info:"Debit Amount"
Border:THIN TOP BOTTOM
Local:Style:Default:Height:10
Local:Field:default:Background:Crystal Blue


[Line:LWTTBALR]
Fields:LWOPebalRT
Right Fields: LWOPebalR
Border: Thin BOttom

[Field:LWOPebalRT ]
info : $$localestring:"Opening Balance :"
width : 50
Inactive: If $$IsEmpty:#LWOPebalR then Yes Else No
Align: Right
Widespaced: Yes
Background:Light Blue

[Field:LWOPebalR]
Use : Amount Field
Set as : If Not $$IsDr:$Openingbalance:Ledger:##LedgerName then $Openingbalance:Ledger:##LedgerName else ""
Skip : Yes
style : normal bold
Format : "Symbol,DrCr"
Width : 16
Align:Center
Background:Light Blue

[Line:LWTTInfoRTotal]
Fields:LWCLbalRTtot
Right Fields: LWCLbalRtot
Border: Thin Top

[Field:LWCLbalRTtot]
info :$$localestring:"Credit Total :"
width : 50
Widespaced: Yes
Align: Right
Background:Crystal Blue

[Field:LWCLbalRtot]
Use : Amount Field
Set as : $$Total:LWLVCHCreditAmt+#LWOPeBalR
Skip : Yes
style : normal
Format : "Symbol,DrCr"
Width : 16
Align:Right

[Line:LWTTInfoRTotal1]
Fields:LWCLbalRTtot1
Right Fields: LWCLbalRtot1
Border: Totals

[Field:LWCLbalRTtot1]
info :$$localestring:"Current Total :"
width : 50
Widespaced: Yes
Align: Right
Background:Crystal Blue

[Field:LWCLbalRtot1]
Use : Amount Field
Set as : #LWCLbalRtot + #LWCLbalR
Skip : Yes
style : normal bold
Width : 16
Align:Right

[Line:LWTTCLGTotalLFieldRT]
Fields:LWCLbalRT
Right Fields:LWCLbalR

[Field:LWCLbalRT]
info :$$localestring:"Closing Balance :"
width : 50
Inactive: If $$IsEmpty:#LWCLbalR then Yes Else No
Widespaced: Yes
Align: Right
Background:Light Blue

[Field:LWCLbalR]
Use : Amount Field
Set as : $ClosingBalance:Ledger:##LedgerName
Set as : If not $$IsDr:$ClosingBalance:Ledger:##LedgerName then 0 else $ClosingBalance:Ledger:##LedgerName
Skip : Yes
style : NORMAL BOLD
Format : "Symbol,DrCr"
Width : 16
Background:Light Blue


[Line:LWTTlbalLTTLf]
Field:LWLVCHDDate,LWLVCHDParticulars,LWLVCHDType,LWLVCHDReference,LWLVCHDChqNum,LWLVCHDebitAmt,DSPVCHMASTERIDNO
Option : AlterVchOnEnter : Yes

[field:LWLVCHDDate]
Use:uni date field
Set as : $Date
Format : "full Date"
Width :12
Style : tiny
Border : Thin right
Align : Left

[field:LWLVCHDParticulars]
Use : Name Field
Set as:If $$IsSales:$VoucherTypeName then $AllInventoryEntries.AccountingAllocations.LedgerName else If $$IsDebitNote:$VoucherTypeName then $AllInventoryEntries.AccountingAllocations.LedgerName else $$LocaleString:$AllLedgerEntries[1].LedgerName
Width : 37
Style : tiny
Border : Thin right

[Field:LWLVCHDReference]
Set As : $VoucherNumber
Width : 10
Align : center
Style : tiny
border : thin right

[field:LWLVCHDChqNum]
Use : Name Field
Set as : If $$IsPayment:$VoucherTypeName then $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER +
else If $$IsContra:$VoucherTypeName then $AllLedgerEntries[-2].BankAllocations.INSTRUMENTNUMBER +
else If $$IsReceipt:$VoucherTypeName then $AllLedgerEntries[-1].BankAllocations.InstrumentNumber +
else If $$IsPurchase:$VoucherTypeName then $Reference +
else If $$Issales:$VoucherTypeName then $Reference +
Else $AllLedgerEntries.BankAllocations.InstrumentNumbers
Width : 8
Style : tiny
Border : Thin right


[field:LWLVCHDType]
Use : Name Field
Set as : $VoucherTypeName
Width : 10
Style : tiny
Border : Thin Right

[field:LWLVCHDebitAmt]
Use : Amount Field
Set as : $$AsDrAmt:$TotLedDrAmt
Full Width : Yes
Border : Thin right
Space Right:1
Style:tiny

[Line:LWTTInfoR]
Field:LWLVCHCDate,LWLVCHCParticulars,LWLVCHCType,LWLVCHCReference,LWLVCHCChqNum,LWLVCHCreditAmt
Local:Field:LWLVCHcDate:Info:"Date"
Local:Field:LWLVCHcParticulars:Info:"Particulars"
Local:Field:LWLVCHcReference:Info:"VCH No."
Local:Field:LWLVCHCChqNum:Info:"Ch./Ref No"
Local:Field:LWLVCHCType:Info:"Vch. Type"
Local:Field:LWLVCHCreditAmt:Info:"Credit Amount"
Border:THIN TOP BOTTOM
Local:Style:Default:Height:10
Local:Field:default:Background:Crystal Blue

[Line:LWTTTitleR]
Field:LWLVCHCDate,LWLVCHCParticulars,LWLVCHCType,LWLVCHCReference,LWLVCHDChqNum,LWLVCHCreditAmt,DSPVCHMASTERIDNO
Option : AlterVchOnEnter : Yes

[field:LWLVCHCDate]
Use:uni date field
Set as : $Date
Format : "DD/MMM/YYYY"
Width : 12
Style : tiny
Border : Thin Left Right
Align : Left

[field:LWLVCHCParticulars]
Use : Name Field
Set as:If $$IsPurchase:$VoucherTypeName then $AllInventoryEntries.AccountingAllocations.LedgerName else If $$IsCreditNote:$VoucherTypeName then $AllInventoryEntries.AccountingAllocations.LedgerName else $$LocaleString:$AllLedgerEntries[1].LedgerName
Width : 39
Style : tiny
Border : Thin right

[Field:LWLVCHCReference]
Set As : $VoucherNumber
Width : 10
Align : center
Style : tiny
border : thin right

[field:LWLVCHCChqNum]
Use : Name Field
Set as : If $$IsPayment:$VoucherTypeName then $AllLedgerEntries[-1].BankAllocations.INSTRUMENTNUMBER +
else If $$IsContra:$VoucherTypeName then $AllLedgerEntries[-2].BankAllocations.INSTRUMENTNUMBER +
else If $$IsReceipt:$VoucherTypeName then $AllLedgerEntries[-1].BankAllocations.InstrumentNumber +
else If $$IsPurchase:$VoucherTypeName then $Reference +
Else $AllLedgerEntries.BankAllocations.InstrumentNumbers +$VoucherNumber
Width : 8
Style : tiny
Border : Thin right

[field:LWLVCHCType]
Use : Name Field
Set as : $VoucherTypeName
Width : 10
Style : tiny
Border : Thin right

[field:LWLVCHCreditAmt]
Use : Amount Field
Set as : $$AsCrAmt:$TotLedCrAmt
Width : 16
Full Width : Yes
Style : tiny
Border : Thin right
Space Right:1

[Collection : LWTTlbalcollL]
Use : Total Ledger Vouchers
Aggr Compute : VchDrTotal : Sum : $$OrigVchLedDrTotal:#LedgerName
Filter : FilterDspVchDrAmt
[Collection : LWTTInfoRColl]
Use : Total Ledger Vouchers
Aggr Compute : VchCrTotal : Sum : $$OrigVchLedCrTotal:#LedgerName
Filter : FilterDspVchCrAmt
[System:formula]
FilterDspVchDrAmt: NOT $$IsEmpty:$TotLedDrAmt AND (NOT @@ShowForex OR NOT $$IsBaseCurrency:$TotLedDrAmt)
FilterDspVchCrAmt: NOT $$IsEmpty:$TotLedCrAmt AND (NOT @@ShowForex OR NOT $$IsBaseCurrency:$TotLedCrAmt)

[Collection: Total Ledger Vouchers]
Type : Vouchers : Ledger
Child of : ##pvsLedgerName
ParmVAR : pvsLedgerName : String : #LedgerName
Sort : @@InCreasing: -$TBSort,$IsForexLine, $Date

Fetch : AllLedgerEntries.LedgerName, AllLedgerEntries.Amount
Fetch : AllLedgerEntries.BankAllocations.*
Fetch : Date, VoucherTypeName, VoucherNumber,Narration,Reference


Compute : TotalLedDLWRVCHAmt : If NOT ##InNewPages Then $$OrigVchLedDrTotal:#LedgerName else $$OrigVchLedDrTotal:#LedgerName
Compute : TotalLedCLWRVCHAmt : If NOT ##InNewPages Then $$OrigVchLedCrTotal:#LedgerName else $$OrigVchLedCrTotal:#LedgerName
Compute : TotLedDrAmt : $$OrigVchLedDrTotal:#LedgerName
Compute : TotLedCrAmt : $$OrigVchLedCrTotal:#LedgerName

Manual Books TDL:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file.
  • Save text file and load in Tally (Method provided below the code)
  • Goto the ledger statements to see Khata Type Books.
  • You can change Period and other things by provided button.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

Manual Books TDL Video:

See the below video to learn how to use Manual Books or Khata Bahi TDL in Tally Prime:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to add own details in Tally TDL
  • How to create TDL file.
  • How to change in Codes.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\Manual Books.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your Manual Books TDL file for Tally Prime is ready to use.

The Manual Books TDL for Tally Prime seamlessly marries the classic charm of Khata Books with the efficiency of modern accounting software. Its ability to customize Tally Ledgers

HSN SAC Code List at Entry Time TDL

2023 Popular HSN SAC Code List at Entry Time TDL for Tally Prime

5/5 - (1 vote)

This Popular HSN SAC Code List at Entry Time TDL for Tally Prime will provide you HSN description and HSN code List at Ledger and item Creation Time. Correctly assigning HSN (Harmonized System of Nomenclature) and SAC (Service Accounting Code) codes is a crucial aspect of GST compliance.

Now, with this Free Tally Prime TDL code can add HSN/SAC Table in Ledger and Item creation and alter screen of Tally Prime. You can add and manage HSN codes and descriptions list according to your business and integrate directly in Tally Prime.

This revolutionary tool simplifies the process, ensuring accurate classification of goods and services. In this blog post, we’ll explore the significance of this TDL and how it empowers you to take control of your HSN/SAC codes in Tally Prime.

HSN SAC Code List at Entry Time TDL:

Take full control of your HSN and SAC codes by adding, editing, and organizing them directly within Tally Prime with this HSN SAC Code List at Entry Time TDL. Access the Custom HSN/SAC Table within Tally Prime Ledger and Item Creation and Alter Screen to add, edit, or manage your HSN and SAC codes and descriptions.

Also Checkout Online GST Details Tracker Tool

HSN SAC Code List at Entry Time TDL

HSN SAC Code List at Entry Time TDL Code for Tally Prime:


[#Field:GSTMSTInfoHSNSAC]
    Table:LearnwellHSNTB,NotApplicable
    Show Table:On Empty

[Collection:LearnwellHSNCode]
    Data Source:File XML :"C:\Users\ssonu\OneDrive\Desktop\HSN\HSN.xml"
    XML Object Path:DATA:1:ROOT
    Client Only:Yes

[Collection:LearnwellHSNTB]
Title:$$LocaleString:"HSN Code List"
Source Collection:LearnwellHSNCode
Fetch :Hsn,Desc
Format:$Hsn,20
Format:$Desc,200
Unique:$HSN

HSN SAC Code List at Entry Time TDL:

HOW TO USE TDL CODE:
  • Copy above TDL code and create a text file or Click on Above Download Button.
  • Extract downloaded Zip folder and Change XML file Path in TDL Code.
  • Save text file and load in Tally (Method provided below the code)
  • Goto create Ledger or Stock item, you will find HSN filed with HSN code and Description.
  • You can search HSN or SAC details by typing HSN/SAC code or Description.

This is best free TDL to have in your Tally. Must have TDL file for Tally ERP9 and Tally Prime that can use it for lifetime. This free TDL Code will perfectly work with Tally Prime.

HSN SAC Code List at Entry Time TDL Video:

See the below video to learn how to create Tally TDL file and how to add HSN XML in Code and How to use HSN SAC TDL in Tally:

Watch above videos to learn :

  • How to use TDL files in Tally.
  • How to add own details in Tally TDL
  • How to create TDL file.
  • How to Add XML code in TDL Code.
  • More videos related to free TDL files on youtube/learnwell
  • Get More TDL files on https://e2t.in/
FOLLOW THE BELLOW INSTRUCTIONS TO LOAD TDL FILE IN TALLY:
  1. Make a Text file of above code
  2. Save it in to your computer
  3. Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\HSN.txt)
  4. Open Tally Prime Software
  5. Click on Help and click on TDL & Addon  (for Tally Prime)
  6. Press F4 (to open a Box)
  7. Set Load TDL file on Startup – Yes
  8. Paste The path in blank space
  9. Press enter and save
  10. Now your HSN/SAC Tracker TDL file for Tally Prime is ready to use.

The Custom HSN/SAC Table TDL for Tally Prime is a game-changer for businesses striving for seamless and accurate GST compliance. Its ability to manage HSN and SAC codes directly within Tally Prime not only ensures accuracy but also saves valuable time and resources.

Online GST Details Tracker

2023 Free Amazing Online GST Details Tracker Direct from Portal

5/5 - (3 votes)

With this Amazing Online GST Details Tracker Direct from Portal, can track Party GST Numbers and Get all details direct from GST Portal and also can track HSN details.

Managing GST details and HSN codes can be a time-consuming process, but what if there was a way to streamline it? Introducing the Online GST Details Tracker directly from the GST portal. This incredible tool empowers businesses to effortlessly track party GST numbers and access all necessary details directly from the GST portal through API. Additionally, it enables easy monitoring of HSN details, to find correct HSN.

In this blog post, we’ll delve into the significance of this tool and how it can revolutionize your GST compliance process.

Online GST Details Tracker:

Access party GST details and HSN codes directly from the GST portal in real-time, ensuring accuracy and up-to-date information.

Online GST Details Tracker

Also Checkout Extra column in Voucher TDL

How to Use Online GST Details Tracker Tool:

Download Online GST Details Tracker from above download link and follow below steps:

  1. Open Online GST Details Tracker Macro workbook.
  2. Enable Macro (How to enable Macro in Excel)
  3. In GST Details Sheet fill GST numbers in column A and Press Get Details Button
  4. In HSN Details Sheet fill HSN Codes to get HSN description

Note: If details not getting then GST Number and HSN code are incorrect. When processing data by clicking on button your internet should be connect.

Watch the below video for More Details:

How to use GST Video:

How to use HSN Video:

The Online GST Details Tracker is a game-changer for businesses striving for seamless and accurate GST compliance. Its ability to retrieve information directly from the portal not only ensures accuracy but also saves valuable time and resources.

By incorporating this powerful tool into your GST management process, you can revolutionize your compliance efforts and stay on top of your financial responsibilities.