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 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:
- Make a Text file of above code
- Save it in to your computer
- Copy the text file path including Name and extension (as – C:\Users\HP\Desktop\rec\GSTSummary.txt)
- Open Tally Prime Software
- Click on Help and click on TDL & Addon (for Tally Prime)
- Press F4 (to open a Box)
- Set Load TDL file on Startup – Yes
- Paste The path in blank space
- Press enter and save
- 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.
