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")
' 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
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.
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
@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
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
very nice and very useful sir
Form read karke video banane ke liye sukriya
Amazing sir
Sir wo compare ka option kaha se aaya confusion ho rahi hai
Kahan se aaya??
excel ka function batane ke liye video banaya
No code found. Please specify where is it exactly
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
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.
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
Table 4
Outward me igst amount aur table 9 me diff ha igst ka
Isme kya b2b me crnote / dr note bhi include hote hai kya
There will be a difference in table 8 D of gstr9 due to temporary reversal, which is nowhere mentioned in this video.
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
Great Video Sir
Ty❤️
Point 14 in 9c ,is mandatory or optional
What does negative amount in gstr 9 table 6b- inward supply inputs mean?
How to recd Comparison table
GSTR 2b Reconciliation comparsion excel code
What about minor mismatches in amounts let's say under or above 5 rupees
Can ignore
pivot table me sab ek hi column me ho data aa raha hain kese thik kare
Drag to specific Tab
17(5) ka reversal kha dikhana hai 6a mein 2b ka total aa rha hai .
Sir teligram par nahi hai
Sir Share the VBA code
VBA code is not available on telegram
Sir
Interested to purchase utility
Nill rated suppliers petrol and diesel 17 table hsn summary show or no
Show it's required
KYA FRIEGHT RCM KA HSN CODE ANNUAL RETURN ME JAYEGA OUTWARD ME?
Only for outward supply
Sir aap GSTR9 File karne ka kya fee h
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
Query not clear sir
sir, 5 minute mein kaise hoga....hsn outward summary toh dalna padega na
If gstr 1 filed with hsn it will fetch
How to fetch gstr 1 data in gstr9..pls batana na
Can somebody send the VBA code for excel reconciliation
already paid sir but did not receive the utility yet.
Send payment receipts on 8005211668
Can you please share code
Hsn kya sabke k liye optional h , ya fir turnover pr based h.. Pl confirm
Mandatory for all
Table Number 6 me 22-23 ka input claim kara hua hai
Ye 22-23 k input ka details yaha dena hai ya nhi. ?
6M
Does anyone found the code
Zero nai hoga sir because GSTR2B se data araha hai
??
VBA Code not available
Already shared in Telegram channel
Sir please send me utility the payment for the same sent on 6th December
Send payment receipts on 8005211668
i have paid amount for 2B reconciliation tool,,... Still Not received.. anyone who will take care of this?? whom to contact??
Send payment receipt on 8005211668
Sir ji koi link to do
Link in description
Bhai aap karte kya ho taxation profession m ?
Ca mitra ki taraf se code mai bej deta hu
Where to show difference of turnover if i have paid gst on advance
Advance amount doesn’t include in Turnover
@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
2b me tu 22-23 input b h tu oska difference kha dikhaye table 8 m
Table 6 column M
Nahi abhi Report Nahi hoga
Kyuki ab 2B se Compare karta hai Portal
So 8A woh Already Including hai
Sir code share karo do pls
Shared
Share code
Shared
Sir WhatsApp per channel kis name s h
Ca mitra24
Sir is name s to show nhi ho rha channel
148 paid karke Mil jayega Kya Link Sir ?
You willing receive Software
@CAMitra24 VBA Coding Kidhar Hai but sir ? Aapne bola hai description me hai kidhar dikh to nhi raha hai
Sir please check my payment and send utility, thanks
Send Payment Receipts on 8005211668
Sir payment done Excel utility not found yet please guide
Sent
Not received sir
@@CAMitra24kab Kiya and kish mail pe kiya please confirm
@@radheshyammishra8442 which you have given while payment
@@radheshyammishra8442Bhai aap karte kya ho taxation profession m ?
shared code sir not available in telegram pleas again share
Shared
Not found
Sir please check mail and send me utility, payment for the same
I have sent you
Sent …please check spam folder of email
@@CAMitra24sorry to say that I have checked spam, but didn't get utility
@@rameshchandravarma6859 send payment receipt on 8005211668
@@CAMitra24 I have sent receipt, please send me excell utility
@@CAMitra24 sir please send excell utility I have sent receipt on WhatsApp 1
WhatsApp ke group ya telegram ke group link toh de do
Link in description
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
👍
WhatsApp group link please
VBA code is not available on telegram