To making Tally more simple we use this Daybook GST Report TDL file 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.
Daybook GST TDL Code:
[#Menu:Gateway of Tally]
Add:Key Item:before:@@locQuit:Learnwell-GST:L:Display:LEARNWELLGST
[Report : LEARNWELLGST]
Title: GST-REPORT-www.Learnwells.com
Variables : SV CurrentCompany
Form :GSTLEARNWELL
Variable : SVFromDate,SVToDate
Set : SVFromDate : $$MonthStart:##SVCurrentDate
Set : SVToDate : $$MonthEnd:##SVCurrentDate
Set : Is Day Book : Yes
[Form :GSTLEARNWELL]
Space Right : 1.5
Space left : 1.5
Part :DSP AccTitles, LWTDB2, GSTLEARNWELL,LWTDB22
Buttons : ExplodeFlag,ChangeDybkDate,ChangePeriod
BottomButton: BlankButton, RelReports, InvReports, AcctReports, Report Operations, FilterButton, ValueButton
Buttons : PrintButton, ExportButton, UploadButton, MailButton
Bottom Toolbar Buttons : BottomToolBarBtn1, BottomToolBarBtn2_EditVch, BottomToolBarBtn3, BottomToolBarBtn4, BottomToolBarBtn5, BottomToolBarBtn6, BottomToolBarBtn7, BottomToolBarBtn8, BottomToolBarBtn9, BottomToolBarBtn10, BottomToolBarBtn11, BottomToolBarBtn12
Background : @@SV_BALANCESHEET
Page Break : LearnwellPG2 , LearnwellPGb2
Vertical Align : Center
Horizontal Align : Center
Width : 100 % Page
Height : 100 % Page
[Part: LearnwellPG2]
Lines : LearnwellPG2
[Line: LearnwellPG2]
Fields : Simple Field
Local : Field : Simple Field : Set As : "Continued..."
Local : Field : Simple Field : FullWidth : Yes
Local : Field : Simple Field : Align : Right
Border : Full Thin Top
[Part: LearnwellPGb2]
Parts : LWTitle2, LWTDB2
Vertical : Yes
[Part: LWTitle2]
Line: LWTitle2, LWTDB2
[Line: LWTitle2]
Fields : Simple Field
Local : Field : Simple Field : Set As : @@CmpMailName
Local : Field : Simple Field : Align : Center
Local : Field : Simple Field : FullWidth : Yes
Local : Field : Simple Field : WideSpaced: Yes
SpaceBottom : 1
[Line :LWTDB2]
Field : Simple Field
Local : Field : Simple Field : Info : "GSTLEARNWELL from " + $$String:##SVFromDate +" to " + $$String:##SVToDate
[Part : LWTDB2]
Use : GSTLEARNWELL
Delete : Repeat
Delete : Scroll
Border : ColumnTitles
Local : Field : Default : Type : string
Local : Field : LWVoucher Srl2 : Set As : "Sr.No"
Local : Field : LWVoucherParty2: Set As : "Party Name"
Local : Field : LWVchTIN2 : Set As : "GST No"
Local : Field : LWVchVtp : Set As : "VoucherType"
Local : Field : LWVchNo1 : Set As : "VCH No"
Local : Field : LWVoucher Date1 : Set As : "VCH Date"
Local : Field : LWVchNo2 : Set As : "Ref No"
Local : Field : LWVoucher Date2 : Set As : "Ref Date"
Local : Field : IGST PER:Set as:"%"
Local : Field : LWVchAmount2x : Set As : "Basic Amount"
Local : Field : LWVchfNo2 : Set As : "CGST "
Local : Field : LWVchfNo3 : Set As : "SGST "
Local : Field : LWVchfNo4 : Set As : "IGST "
Local : Field : LWVchTotAmount2x : Set As : "Total Amount"
Local :Field : Default : Style : Normal
Local: Field: Default: Align: Center
[Part :GSTLEARNWELL]
Line : GSTLEARNWELL
Repeat :GSTLEARNWELL :LWVoucher Rep Collection2
tOTAL : LWVoucher Srl2,LWVchAmount2x,LWVchfNo4,LWVchfNo2,LWVchfNo3,LWVchfNo4,LWVchTotAmount2x
Common Border : Yes
Scroll : Vertical
[Line :GSTLEARNWELL]
Field :LWVoucher Srl2,LWVoucherParty2,LWVchTIN2,LWVchVtp,LWVchNo1,LWVoucher Date1,LWVchNo2,LWVoucher Date2,IGST PER,LWVchAmount2x,LWVchfNo4,LWVchfNo2,LWVchfNo3,LWVchfNo4,LWVchTotAmount2x
Option : Alter on enter
Option : DisplayOnAltEnter
Explode : LearnWellExplode : ##ExplodeFlag or $$KeyExplode
Option:Colorfull display:$amount>10000
[!Line:Colorfull Display]
Local:Field:LWVoucherParty2:Color:DARK red
Local:Field:LWVchAmount2x:Color:dark red
[Part: LearnWellExplode]
Lines : LearnWellExplode
Repeat : LearnWellExplode : ledger Entries
Scroll : Vertical
[Line : LearnWellExplode]
Field : LearnWellExplodeItem
Indent : 5
[Field: LearnWellExplodeItem]
USe : Name field
Set as : $LedgerName
[Field :LWVoucher Srl2]
Use : Number Field
SET AS:$$LINE
Width : 4% Screen
Align: Right
Border : Thin LEFT Right
[Field :LWVoucher Date1]
Use : Short Date Field
Set As : $Date
Border : Thin Right
Format:"Short Date"
[Field :LWVoucher Date2]
Use : Short Date Field
Set As : $ReferenceDate
Border : Thin Right
Format:"Short Date"
[Field : LWVoucherParty2]
Use : NAme Field
Set As : $LedgerName
Width : 35
Border : Thin Right
Alter : Voucher
Display : Ledger Vouchers:$$ISLedger
Variable: Ledger Name
[Field : LWVchVtp]
Use : Name Field
Set As :$VoucherTypeName
Width : 11
Border : Thin Right
[Field : LWVchTIN2]
Use : Name Field
Set As :$PartyGSTIN:Ledger:$PartyLedgerName
Width : 11
Border : Thin Right
[Field : LWVchNo1]
Use : NAme Field
Set As : $VoucherNumber
Width : 10
Border : Thin Right
Align:Center
[Field : LWVchNo2]
Use : NAme Field
Set As : $REFERENCE
Width : 10
Border : Thin Right
Align:Center
[Field:IGST PER]
Use: Number Field
Set as:$(Stockitem,$stockitem).GSTIGSTRate
Format : "NoZero,Percentage"
Set Always: Yes
Border : Thin Right
Align:Center
Width:4
[Field : LWVchAmount2x]
Use : Amount Field
Set As: $$CollAmtTotal:allinventoryEntries:$Amount
Border : Thin Right
[Field : LWVchfNo2]
Use : Amount Forex Field
Set as:$$FilterAmtTotal:LedgerEntries:CGST1:$Amount
Border : Thin Right
Width : 10
[Field : LWVchfNo3]
Use : Amount Forex Field
Set as : $$FilterAmtTotal:LedgerEntries:SGST1:$Amount
Border : Thin Right
Width : 10
[Field : LWVchfNo4]
Use : Amount Forex Field
Set as : $$FilterAmtTotal:LedgerEntries:IGST1:$Amount
Border : Thin Right
Width : 10
[Field : LWVchTotAmount2x]
Use : Amount Field
Set As : $Amount
Border : Thin Right
[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"
[Collection : LWVoucher Rep Collection2]
Type : Ledger
Type : Vouchers
Walk : allLedgerEntries
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: LWTDB22]
Lines : LearnWellDBT3
[Line: LearnWellDBT3]
Use : GSTLEARNWELL
Local: Field: Default : Style : Small Bold
Local: Field: Default: Align: Right
Local : Field : LWVoucher Srl2 : Set as:$$NumItems:LWVoucherRepCollection2
Local : Field : LWVoucherParty2: Set As : "Total"
Local : Field : LWVchNo2 : Set As : ""
Local : Field : LWVchAmount2x : Set As : $$Total:LWVchAmount2x
LOCAL : FIELD: LWVchfNo2:Set as:$$Total:LWVchfNo2
LOCAL : FIELD: LWVchfNo3:Set as:$$Total:LWVchfNo3
LOCAL : FIELD: LWVchfNo4:Set as:$$Total:LWVchfNo4
LOCAL : FIELD: LWVchTotAmount2x:Set as:$$Total:LWVchTotAmount2x
Border : Totals
CSTFilter2 : not ##IsRevChargeAppl
;~~~~~~~~~~~~~~~www.learnwells.com~~~~~~~~~~~~~~~~~~~~~~~~~~
;~~~~~~~~~~~~~~~~~~~~~E2T.in~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~How to Daybook GST Report TDL code:
HOW TO USE TDL CODE:
- Copy above TDL code and make a text file.
- Save text file then load in Tally Prime (Method provided below the code)
- Now a line will show in the name of Learnwell-GST in our tally home screen Gateway of Tally
- Click on it and provide date for the period that you want to see and Export GSTIN report.
- 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. This free TDL Code will perfectly work with Tally Prime.
How to use Daybook GST TDL video:
Watch above video to learn :
- How to see daybook GST reports in Tally.
- How to filter details of voucher.
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\daybookGST.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 Daybook GST Report TDL is ready to use
