GSTR 9 Annual Return Filing 2023-24 | Complete Practical

[@phaniraju143]

very nice and very useful sir

[@SatyamSingh-r5l]

Form read karke video banane ke liye sukriya

[@hammadahmad8043]

Amazing sir

[@JsrH-i7l]

Sir at where in table 7, itc will be reversed if goods are nil rated

[@krishnakumar-co6hq]

Sir wo compare ka option kaha se aaya confusion ho rahi hai

[@harshitakukreja4502]

Kahan se aaya??

[@anjalikalwani3729]

No code found. Please specify where is it exactly

[@GK-TK-xx1vr]

Sub ReconcileGSTR2B()
Dim wsGSTR As Worksheet, wsTally As Worksheet
Dim lastRowGSTR As Long, lastRowTally As Long, i As Long, j As Long
Dim found As Boolean

Set wsGSTR = ThisWorkbook.Sheets("GSTR-2B")
Set wsTally = ThisWorkbook.Sheets("Tally")

lastRowGSTR = wsGSTR.Cells(wsGSTR.Rows.Count, 1).End(xlUp).Row
lastRowTally = wsTally.Cells(wsTally.Rows.Count, 1).End(xlUp).Row

' Clear old results
wsGSTR.Columns("F").ClearContents
wsTally.Columns("F").ClearContents

' Compare entries from GSTR-2B with Tally
For i = 2 To lastRowGSTR
found = False

For j = 2 To lastRowTally
If wsGSTR.Cells(i, 1).Value = wsTally.Cells(j, 1).Value Then
If wsGSTR.Cells(i, 4).Value = wsTally.Cells(j, 4).Value And _
wsGSTR.Cells(i, 5).Value = wsTally.Cells(j, 5).Value Then
found = True
Exit For
End If
End If
Next j

If Not found Then
wsGSTR.Cells(i, 6).Value = "Mismatch with Books"
End If
Next i

' Compare entries from Tally with GSTR-2B
For j = 2 To lastRowTally
found = False

For i = 2 To lastRowGSTR
If wsTally.Cells(j, 1).Value = wsGSTR.Cells(i, 1).Value Then
found = True
Exit For
End If
Next i

If Not found Then
wsTally.Cells(j, 6).Value = "Entry Found in Tally but Not in GSTR-2B"
End If
Next j

' Compare entries from GSTR-2B with Tally
For i = 2 To lastRowGSTR
found = False

For j = 2 To lastRowTally
If wsGSTR.Cells(i, 1).Value = wsTally.Cells(j, 1).Value Then
found = True
Exit For
End If
Next j

If Not found Then
wsGSTR.Cells(i, 6).Value = "Entry Found in GSTR-2B but Not in Tally"
End If
Next i

MsgBox "Reconciliation Completed"
End Sub

[@mimanshabhambhani7688]

Sir agar hum gstr-1 me koi sale lena bhul gye h pr gstr-3B me tax pay kr diya hai to ab usko kaha show karenge

[@CAMitra24]

Table 4

[@mohann8136]

There will be a difference in table 8 D of gstr9 due to temporary reversal, which is nowhere mentioned in this video.

[@ans-e1k]

GSTR 2b Reconciliation comparsion excel code

[@SantoshBadwaniya-j6e]

excel ka function batane ke liye video banaya

[@ravesh9731]

Hi Sir
In the GST 9,I have post the wrong figure in the column 7 (E) As per section 17(5) i.e 50k extra in it
Due to this I have found short amount in the 7 J (Net ITC Available for Utilization (6O - 7I) as compared the actually amount Rs50K.)
But I have the correct amount in the GST 3B with all ITC
Can I consider the GST 3B data ,or there is any solution for claim 50k.Please help on this.

[@KhushbooSoni-fs6gf]

Outward me igst amount aur table 9 me diff ha igst ka

[@harshitjain7935]

Isme kya b2b me crnote / dr note bhi include hote hai kya

[@keshavkaiwart3424]

Table No 6 B ka aur 6 A ka difference ko kaise karenge sir
A me As ka 3 B ka aata hai but B me To jo hamare 2A me hai usko Denge na sir samne Wale party let se kiye to uska jo Difference aa raha hai usko kya karna hai
Difference Rahne Dena hai ki kuch karna hai sir

[@umendrapratapsingh9752]

Sir teligram par nahi hai

[@chandrabhandhakad7168]

How to recd Comparison table

[@Mr.Jadugar.]

VBA code is not available on telegram

[@bhagwandassjindal]

Point 14 in 9c ,is mandatory or optional

[@babulalkumawat2258]

Sir aap GSTR9 File karne ka kya fee h

[@saikatsinha1106]

pivot table me sab ek hi column me ho data aa raha hain kese thik kare

[@CAMitra24]

Drag to specific Tab

[@Beaware00]

WhatsApp ke group ya telegram ke group link toh de do

[@CAMitra24]

Link in description

[@lalitgupta9890]

17(5) ka reversal kha dikhana hai 6a mein 2b ka total aa rha hai .

[@yourown4631]

What about minor mismatches in amounts let's say under or above 5 rupees

[@CAMitra24]

Can ignore

[@VinayKumar-fm6xe]

Does anyone found the code

[@madhucharan5892]

Nill rated suppliers petrol and diesel 17 table hsn summary show or no

[@vishalratdiya1234]

Show it's required

[@YashSharma-bd2se]

Sir Share the VBA code

[@theentertainmentshow3030]

Can somebody send the VBA code for excel reconciliation

[@aanalshah6506]

What does negative amount in gstr 9 table 6b- inward supply inputs mean?

[@swraj1947]

Hsn kya sabke k liye optional h , ya fir turnover pr based h.. Pl confirm

[@CAMitra24]

Mandatory for all

[@amitechsharma]

KYA FRIEGHT RCM KA HSN CODE ANNUAL RETURN ME JAYEGA OUTWARD ME?

[@CAMitra24]

Only for outward supply

[@kapilagrawal4311]

sir, 5 minute mein kaise hoga....hsn outward summary toh dalna padega na

[@CAMitra24]

If gstr 1 filed with hsn it will fetch

[@kapilagrawal4311]

How to fetch gstr 1 data in gstr9..pls batana na

[@jayjagannath8212]

already paid sir but did not receive the utility yet.

[@CAMitra24]

Send payment receipts on 8005211668

[@casunitasaraf7684]

Can you please share code

[@hasubhaisenta2313]

Rcm paid fy 23 -24 rcm claim and reversal of fy 24/25 fy 23/24 ma leneka ya fy 24/25 me Lena he

[@CAMitra24]

Query not clear sir

[@brijbhatia7699]

Zero nai hoga sir because GSTR2B se data araha hai

[@CAMitra24]

??

[@priyanshusaxena2497]

VBA Code not available

[@CAMitra24]

Already shared in Telegram channel

[@JAGJEETSINGH-pq2hb]

Sir
Interested to purchase utility

[@sarfarazkhan8086]

Table Number 6 me 22-23 ka input claim kara hua hai
Ye 22-23 k input ka details yaha dena hai ya nhi. ?

[@Ankitkumar-gq9ik]

6M

[@pavansurya2467]

i have paid amount for 2B reconciliation tool,,... Still Not received.. anyone who will take care of this?? whom to contact??

[@CAMitra24]

Send payment receipt on 8005211668

[@rameshchandravarma6859]

Sir please send me utility the payment for the same sent on 6th December

[@CAMitra24]

Send payment receipts on 8005211668

[@sureshlongani7546]

Great Video Sir

[@CAMitra24]

Ty❤️

[@travelbygauravrajput554]

Share code

[@CAMitra24]

Shared

[@sachin.sharma333]

Sir ji koi link to do

[@CAMitra24]

Link in description

[@badshahjadhav9661]

Bhai aap karte kya ho taxation profession m ?

[@umendrapratapsingh9752]

Sir code share karo do pls

[@CAMitra24]

Shared

[@Abhi7018]

148 paid karke Mil jayega Kya Link Sir ?

[@CAMitra24]

You willing receive Software

[@Abhi7018]

@CAMitra24 VBA Coding Kidhar Hai but sir ? Aapne bola hai description me hai kidhar dikh to nhi raha hai

[@shivangiagarwal6022]

Sir WhatsApp per channel kis name s h

[@CAMitra24]

Ca mitra24

[@shivangiagarwal6022]

Sir is name s to show nhi ho rha channel

[@MakeAccountsEasy]

Where to show difference of turnover if i have paid gst on advance

[@CAMitra24]

Advance amount doesn’t include in Turnover

[@MakeAccountsEasy]

@CAMitra24 sir it's showing on portal in table no 4 (F). And that's why the same amount difference in my books and portal.. pls can you suggest me what to do

[@kunalsharma7204]

2b me tu 22-23 input b h tu oska difference kha dikhaye table 8 m

[@Ankitkumar-gq9ik]

Table 6 column M

[@SameerKhan-lw8qh]

Nahi abhi Report Nahi hoga
Kyuki ab 2B se Compare karta hai Portal
So 8A woh Already Including hai

[@lalitgarg3779]

Ca mitra ki taraf se code mai bej deta hu

[@rameshchandravarma3271]

Sir please check my payment and send utility, thanks

[@CAMitra24]

Send Payment Receipts on 8005211668

[@lalitgarg3779]

Sub CompareColumns()
Dim ws As Worksheet
Dim rng1 As Range, rng2 As Range
Dim i As Long
' Set your worksheet and ranges
Set ws = ThisWorkbook.Sheets("Sheet1")
Set rng1 = ws.Range("A1:A100") ' First range
Set rng2 = ws.Range("B1:B100") ' Second range
' Loop through the ranges
For i = 1 To rng1.Rows.Count
If rng1.Cells(i, 1).Value rng2.Cells(i, 1).Value Then
' Highlight mismatched cells
rng1.Cells(i, 1).Interior.Color = RGB(255, 0, 0) ' Red for Range 1
rng2.Cells(i, 1).Interior.Color = RGB(255, 0, 0) ' Red for Range 2
End If
Next i
MsgBox "Comparison complete!"
End Sub

[@CAMitra24]

👍

[@radheshyammishra8442]

Sir payment done Excel utility not found yet please guide

[@CAMitra24]

Sent

[@radheshyammishra8442]

Not received sir

[@radheshyammishra8442]

​@@CAMitra24kab Kiya and kish mail pe kiya please confirm

[@CAMitra24]

@@radheshyammishra8442 which you have given while payment

[@badshahjadhav9661]

​@@radheshyammishra8442Bhai aap karte kya ho taxation profession m ?

[@prathammasrani2309]

shared code sir not available in telegram pleas again share

[@CAMitra24]

Shared

[@vivekprasad48]

Not found

[@rameshchandravarma6859]

Sir please check mail and send me utility, payment for the same
I have sent you

[@CAMitra24]

Sent …please check spam folder of email

[@rameshchandravarma6859]

​@@CAMitra24sorry to say that I have checked spam, but didn't get utility

[@CAMitra24]

@@rameshchandravarma6859 send payment receipt on 8005211668

[@rameshchandravarma6859]

​@@CAMitra24 I have sent receipt, please send me excell utility

[@rameshchandravarma6859]

​@@CAMitra24 sir please send excell utility I have sent receipt on WhatsApp 1

[@casunitasaraf7684]

WhatsApp group link please

[@nikhilbhudolia1332]

VBA code is not available on telegram