Detailed Ledger TDL for TallyPrime: All Master Info on One Screen!

With this Detailed Ledger TDL for TallyPrime you will find All Master Info on One Screen. If you use Tally Prime daily for accounting, you already know the frustration of opening ledger masters one by one just to check a client’s address, verify a GST number, or find a mobile number. It is a time-consuming process that interrupts your workflow.

But what if you could see all that crucial information perfectly organized on a single screen?

Today, we are thrilled to share a 100% Free Detailed Ledger TDL that solves this exact problem.

Why You Need This Detailed Ledger TDL for TallyPrime

By default, Tally Prime requires you to drill down into individual ledgers to view specific master details. This custom TDL alters that behavior by generating a comprehensive, wide-view report of all your ledgers.

At a single glance, you can now track and verify:

• Ledger Name & Alias
• Parent Group (e.g., Sundry Debtors, Indirect Expenses)
• Complete Address (Address 1 & Address 2)
• State
• Mobile Number
• PAN Number
• GST Type & GST Number
• Opening Balances

Whether you are conducting a quick audit, preparing for GST filing, or just trying to clean up your data, this all-in-one view is an absolute game-changer.

Created Effortlessly with Learnwell’s TDL Studio

You might be wondering how many lines of complex code it took to build this multi-column report. The answer? Zero hand-coding.

This entire detailed ledger report was generated using Learnwell’s TDL Studio. If you have ever wanted to customize Tally Prime for your specific business needs but felt intimidated by TDL programming, our TDL Studio bridges that gap. It allows you to design powerful, custom reports visually and effortlessly.

JOIN TDL COURSE

How to Load the Free TDL in Tally Prime

Ready to save time? Follow these simple steps to activate the report in your system:

;; ===== LW_Batch Scaffold =====

;; Reports
[#Menu: Gateway of Tally]
    Add : Item : Before : @@locQuit : "DETAILED LEDGER" : Display : LW_Report1
[Report: LW_Report1]
    Form    : LW_Form1
    Title   : "Custom Report 1"
    ;; -- Report attributes (relevant)
    ;; Use : DSP Template
    ;; Variable : SVFromDate, SVToDate
    ;; Set : SVFromDate : $$Date
    ;; Print Set : Report Title : "Trial Balance"

;; Forms
[Form: LW_Form1]
    Part    : LW_Part1
    Width   : 100% Page
    Height  : 100% Page
    ;; -- Form attributes (relevant)
    ;; Add : Part : At Beginning : MyPart
    ;; Delete : Part : OldPart
    ;; Buttons : Print Button, Export Button
    ;; Key : Ctrl+P : Print
    ;; On : Form Accept : $$IsEmpty:#MyVar

;; Parts
[Part: LW_Part1]
    Line    : LW_Part1_Line1_Heading, LW_Part1_Line1_Body
    Repeat  : LW_Part1_Line1_Body : LW_Collection1
    Scroll  : Vertical

    ;; -- Part attributes (relevant)
    ;; Add : Line : At End : MyLine
    ;; Delete : Line : OldLine
    ;; Break On : $$IsEmpty:$Name
    ;; Space Top : 1
    ;; Space Bottom : 1
    Common Border : Yes
    ;; Background : Yellow
    ;; Border : Thin Box
    ;; Total : Field1, Field2

;; Lines
[Line: LW_Part1_Line1_Heading]
    Field   : LW_Field1, LW_Field2, LW_Field3, LW_Field4, LW_Field5, LW_Field6, LW_Field7, LW_Field8, LW_Field9, LW_Field10, LW_Field11, LW_Field12
    Local   : Field : LW_Field1 : Info : "SR.No"
    Local   : Field : LW_Field2 : Info : "Ledger Name"
    Local   : Field : LW_Field3 : Info : "Alias"
    Local   : Field : LW_Field4 : Info : "Parent"
    Local   : Field : LW_Field5 : Info : "Address1"
    Local   : Field : LW_Field6 : Info : "Address2"
    Local   : Field : LW_Field7 : Info : "State"
    Local   : Field : LW_Field8 : Info : "Mobile Number"
    Local   : Field : LW_Field9 : Info : "Pan Number"
    Local   : Field : LW_Field10 : Info : "GST Type"
    Local   : Field : LW_Field11 : Info : "GST NUmber"
    Local   : Field : LW_Field12 : Info : "Opening"
    Local	: field:default:Border	: Thin Box
    ;; -- Line attributes (relevant)
    ;; Option : Alter On Enter
    ;; Option : Explode
    ;; Explode : ExplDetails
    ;; Space Top : 1
    ;; Space Bottom : 1
    ;; Border : Thin Bottom

[Line: LW_Part1_Line1_Body]
    Field   : LW_Field1, LW_Field2, LW_Field3, LW_Field4, LW_Field5, LW_Field6, LW_Field7, LW_Field8, LW_Field9, LW_Field10, LW_Field11, LW_Field12
     Local	: field:default:Border	: Thin Box
    ;; -- Line attributes (relevant)
    Option : Alter On Enter
    ;; Option : Explode
    ;; Explode : ExplDetails
    ;; Space Top : 1
    ;; Space Bottom : 1
    ;; Border : Thin Bottom

;; Fields
[Field: LW_Field1]
    Use     : Number Field
    Set as  :$$Line
    Width   : 5
    ;; -- Field attributes (relevant)
    ;; Type : String
    Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field2]
    Use     : Name Field
    Set as  : $Name
    Width   : 50
    Alter	: Ledger
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field3]
    Use     : Name Field
    Set as  : $Onlyalias
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field4]
    Use     : Name Field
    Set as  : $Parent
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field5]
    Use     : Name Field
    Set as  : $_Address1
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field6]
    Use     : Name Field
    Set as  :$_Address2
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field7]
    Use     : Name Field
    Set as  : $LedStateName
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field8]
    Use     : Name Field
    Set as  : $LedgerMobile
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field9]
    Use     : Name Field
    Set as  : $IncomeTaxNumber
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field10]
    Use     : Name Field
    Set as  : $Ledgstregdetails[last].GSTRegistrationType
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field11]
    Use     : Name Field
    Set as  : $Ledgstregdetails[last].GSTIN
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

[Field: LW_Field12]
    Use     : Name Field
    Set as  : $OpeningBalance
    Width   : 20
    ;; -- Field attributes (relevant)
    ;; Type : String
    ;; Align : Left
    ;; Format : "@Alpha"
    ;; Style : Normal Bold
    ;; Border : Thin Bottom
    ;; Table : YesNo
    ;; Inactive : $$IsEmpty:$Name
    ;; Skip : Yes

;; Collections
[Collection: LW_Collection1]
    Type    : Ledger
    Fetch   : Name, Parent, ClosingBalance, OpeningBalance
    ;; -- Collection attributes (relevant)
    ;; Child Of : $$GroupName
    ;; Belongs To : Yes
    ;; Filter : MyFilter
    ;; By : Name : $Name
    ;; Sort : Name
    ;; Search Key : $Name

1. Copy the Free TDL File and Save as Text or .TDL in your computer
   
2. Open Tally Prime and click on Help (F1) from the top menu.
3. Navigate to TDLs & Add-Ons.
4. Press F4 (Manage Local TDLs).
5. Set the option “Load selected TDL files on startup” to YES.
6. Paste the file path of the downloaded TDL file and save the screen.

That’s it! You can now navigate to the new Custom Report menu and view all your ledger details instantly.

Watch the Full Tutorial

Want to see this TDL in action and learn exactly how it was made? Check out our complete walkthrough video on the Learnwell YouTube channel: