gst Reconciliation Excel | gst reconciliation & mismatch | gst Reconciliation | gst reco

gst Reconciliation Excel | gst reconciliation & mismatch | gst Reconciliation | gst reco
Topic Covered
gst reconciliation
gst sales reconcliation
gst reconciliation in excel
Full GST Cource : • gst course in hindi | ...
Practice file ( File - Download - xlsx : docs.google.co...
GST reconciliation involves matching of sales and purchase data between different returns as well as sales and purchase registers. The article attempts to explain it in detail.
What is GST reconciliation and matching?
In general, reconciliation means comparing two sets of data entries to identify any differences or variances. It is done to correct the unintentional errors earlier committed or any omissions.
Under taxation, reconciliation holds importance because it can give rise to tax short paid or not paid or excess paid as well. Following mismatches or differences can be noticed by taking up following matching and reconciliation exercise:
Why is GST Reconciliation required?
There are several reasons why reconciliation for GST returns data is required by businesses under GST.
Taxpayers will be able to claim ITC only if the invoice is present as a part of their GSTR-2B. Due to this, taxpayers will now need to do a reconciliation wherever the ITC as per their purchase register and GSTR-2B data is not matching. Upto July 2020, taxpayers were comparing the GSTR-2A with purchase register. Due to the introduction of static return in form GSTR-2B, the monthly reconciliation has moved from GSTR-2A to GSTR-2B. However, for the yearly reconciliation, GSTR-2A which is dynamic return is preferred. But as an exception, one must still refer to GSTR-2A for TDS and TCS credits.
GST returns are filed monthly or quarterly basis. Finally, after the financial year gets over, annual returns must be filed before the 31st December of subsequent FY. This would need consolidation of the data reported over the FY. In order to ensure the correctness of the declaration made and to avoid duplications, taxpayers must reconcile the data, then consolidate the values and make the declaration.
Certain deadlines are stipulated in the GST laws for making amendments to GST returns data or to claim ITC. As per CGST Act, following actions must be taken, at the earlier of filing the return under section 39 for the month of September* following the end of the financial year to which a particular invoice pertains, or the furnishing of the relevant annual return:
Claim eligible ITC against any invoice raised in a FY.
Any apportionment of ITC belonging to a FY, as eligible and ineligible not made earlier must be affected before the deadline.
Declare CDNs issued against any Invoices raised in a FY.
File Amendments to information reported in the GST Returns filed in a FY.

[@becominganexpert]

Practice file: Click-file-Downlow-xlsx : docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit#gid=933065464

[@soulofarmies282]

Best video sir ❤
Mujhe kal GST reconciliation Krna hai usse ehle mujhe apne bhot achhe se bta diya thanku so much ❤

[@becominganexpert]

Thank you

[@becominganexpert]

Practice file ( File - Download - xlsx ) = docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit?usp=sharing&ouid=114971401011962481309&rtpof=true&sd=true

[@umeshmishra2010]

your shortcut idea for GST reconciliation is very nice to do so within short periods. thanks

[@becominganexpert]

Thanks

[@vivaindian]

Very helpful for annual reconciliation of GST. Thanks 👍🙏

[@nileshmahajan2237]

Aditya You Are Done very well job Ty Your video is very helpfull for Begineers 🎉

[@becominganexpert]

Thanks Nilesh

[@swethaborem5087]

Thank you so much sir this video is really very helpful
And I prepared my BRS in my own
Thank you so much sir

[@becominganexpert]

Thanks

[@lakshitprajapat1077]

I found some points very helpful
Very Useful video for me
Thanks for sharing

[@madhangopal325]

Very useful, thank you so much

[@user-ef4sc3ld2m]

Good explanation very useful thanks...

[@becominganexpert]

Thanks

[@tishyacraftingtube6010]

🎉❤😊😊😊

[@PavanKumar-nw7mg]

Very simply Teached

[@becominganexpert]

Glad you think so!

[@jayaramans3203]

Thank you sir. Execellant teaching.

[@becominganexpert]

Thanks

[@venkateshgopalakrishnan196]

sir aapke vidoes bahut aache hai
.. aap gst jaise hi tds reconciliation par bhi ek video bana dijiye

[@mukeshgujarnawalgarhrajast2018]

Very good

[@user-qi8qc2sx2m]

Nice video sir

[@jatinsaxena4986]

Excellent video sir thanks

[@mohanjhanginia3115]

Good knowledge provide by you 🙏

[@becominganexpert]

Thanks

[@ramavtarsingh146]

nice presentation

[@ramavtarsingh146]

mind blowing

[@PrinceSingh-gc6ke]

Very helpful 👍 thanks

[@becominganexpert]

Thanks

[@abdulparvez8913]

Very helpful sir🙏 , keep it up

[@becominganexpert]

Thanks

[@AshishSoni-oy7sr]

GREAT SIR

[@becominganexpert]

Thanks

[@avishekghosh904]

I checked you both videos of reco of R1 vs 3B & 2A vs 3B. both are very informative. thanks for that. i just wanted to know that how you extracted date wise party name wise ,Invoice wise & CGST ,SGT & IGST wise report from the tally. awaiting your response.

[@becominganexpert]

Open tally-display-account book-purchase register-open any month-select period-F8 for Columnar-select what you want-export in excel

[@kansingh5968]

Nice video thanks sir.

[@becominganexpert]

Thanks

[@anjumshuana6174]

Thank you

[@mayankgoyal912]

nice work

[@raghuveerpandy6760]

Thanks very Nice

[@krsharma6074]

Very useful video bro

[@becominganexpert]

Thanks

[@kansingh5968]

Nice video

[@deepikagatne370]

Thank you sir

[@becominganexpert]

Thanks

[@RohitKumar-uy7cx]

Nice vedio bhai

[@becominganexpert]

Thanks Bhai

[@vishalji4478]

Nice information

[@mukund6614]

nice sir

[@DevKumar-xm8sp]

1 No

[@becominganexpert]

Thanks 😊

[@shrikantpise8436]

Thanks sir ji

[@becominganexpert]

Thanks

[@dharmeshdudhwala738]

Good👍

[@officialvermaji92]

Nyc working

[@sujayrkxit4097]

Bhaiya business accounting and taxation may mujhe trading manufacturing service sector export import ki bookeeping preparation of financial statements and gstr filing itr filing tds file kar sakta hu.. Kya market may aur ca firm may acchi value ban sakti hay?

[@Myswamiji-Nrj]

Very nice sir

[@becominganexpert]

Thanks

[@priyankavast2052]

Thank u 🌼

[@becominganexpert]

Thanks

[@innovativelearning8212]

For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....

[@ranifav1681]

Thank u sir 🙏

[@becominganexpert]

Thanks

[@bhavikjain5472]

Very helful

[@becominganexpert]

Thanks Sir

[@user-pp6wv6wl8o]

Sar namaskar

[@ABHISHEKYADAV-st2nx]

Hello sir,
I've watched your videos and it's been very useful for me in preparing data,
I would like to learn more advanced, do you provide courses on Reco ?
Let me know, I'll be waiting for the response
Thanks.

[@becominganexpert]

Currently not but i will start soon

[@neerajprajapati6725]

Nice

[@aadarshyadav1681]

sir , please upload party and vender reconcilation video. thank you

[@sureshkumargopi6272]

nice info sir

[@becominganexpert]

Thanks

[@user-pp6wv6wl8o]

Mujhe Apne invoice ke bare mein jankari leni hai kuchh kya aap bata sakte hain Sahi kaise ki ja sakti hai

[@deepakgaur2706]

Jab diffrence mil jaye to uska kya kare....

[@motilalmukherjee6808]

Sir gst ka upar excel and tally ka ek basic to advance lebel par ek video banaye.

[@becominganexpert]

Sure

[@pranaliruge1193]

Thanks so much please provide complete gst course

[@becominganexpert]

Thanks

[@deveshsoni98641]

Good

[@becominganexpert]

Thanks

[@VisualEntertainments9]

Sir, Jo data apne rally se extract kiya tha vo r1 thi ya 3b?

[@becominganexpert]

Mai R1 me jakar sales ke export karata hu.
3b aur r1 me same hi rahega

[@debarghyachatterjee2400]

Sir, app gst ki portal se jo csv file ka data copy kiya aur paste jaha pe kiye uska format kaha se milega

[@becominganexpert]

Sir description me link hai
Usapar click karana
File- Download-xlsx

[@venkateshgopalakrishnan196]

bro how to reconcile gst when we pay gst with interest

[@praveensharma-wv4uf]

Nice sir

[@becominganexpert]

Thanks Sir

[@rakeshtannautmtfinance1673]

You explain very well, but our 80% sales are b2c then there is any way to reconcile b2c transaction

[@becominganexpert]

B2C also reflect 3B and R1

[@rakeshtannautmtfinance1673]

@@becominganexpert B2C transaction is not bill wise it is available state wise, if one bill change then I am not able to find the same

[@avinashmohanty3508]

Sir I have missed two invoices of fy 21-22,how can I take itc of that bills pls guide me

[@becominganexpert]

Sir
If you miss any itc or extra claim
You can claim or reverse itc in sep-22 gstr 3b. After sep-22 you cannot claim without any government notification.

[@ranjeetsinghsingh680]

Monthly reconciliation ka bi vedio bana dijiye

[@becominganexpert]

Sure

[@unitedec4806]

Sir can u pls brief on gst3b and input tax on purchase and where it reflects on gst summary report

[@becominganexpert]

Yes Sir
Tax liability means sales
ITC means purchase credit.
You can download whole comparison

[@becominganexpert]

ruclips.net/video/a5Q99BWpOvM/видео.html

[@nadishbansal4274]

Can we download taxable value with igst,cgst,sgst

[@becominganexpert]

No sir
We have to open every gstr-3b for taxable

[@viswanathanandhy7194]

It is very useful

[@becominganexpert]

Thanks

[@arunranga3646]

Sir pivot table advance and vlookup advance

[@becominganexpert]

Sure
Pivot table ke aur bhi video banaye hai. Please playlist me jakar dekhiye.

[@deepsharma3027]

Sir last year ke amendments kab tak kar sakte hain? 30th November of the following year or filing of annual return, whichever is earlier. Ye dikha ra h google pe search h kia toh

[@becominganexpert]

30 Oct rahata hai
Lekin is bar 30 nov tak extend kiya hai.

[@dineshsharma-iv8qc]

Good morning sir
Me jese pivot table lagta hu to date me months nhi aate date wise aata hai

[@becominganexpert]

Right click on date-group-remove selection of day and year. Only month blue hona chahiye.

[@shrlkhm5159]

Credit note & debit note 2a & 2b main kaise recon karee??

[@becominganexpert]

Same invoice jaise hi
2b me credit note hai matalab aapake books me debit note hogi
And debit note hai to aapake book me credit note hogi

[@shrlkhm5159]

@@becominganexpert thankuuu Soo much for your video💟💟...
Apka wp no. mil sakta hain??

[@becominganexpert]

@@shrlkhm5159 9404776008

[@kamleshparmar1150]

❤

[@SachinSharma-it4oi]

2 b bisy win se kase match kare

[@arshadalisiddiqui5649]

Sir firm ke case kaise kerte hai sales tax department me

[@becominganexpert]

Gst to same hota hai

[@SachinSharma-to6qk]

I deal in sales tax cases. Kindly connect at email : [e-mail]

[@nehachaturvedi7246]

Sir treatment ment kese kare gst r1 or 3b ka books bhi nahi he

[@becominganexpert]

Means GSTR-1 & 3B me nahi hai
Lekin books me hai. Right?

[@aadityasingh1299]

M bhi इसी तरीके से कर्ता hu 😂😂😂😂same to same

[@becominganexpert]

Thanks

[@mr.kd_bhai9673]

Hello bhai

[@AmandeepSingh-zr6xi]

Sir Major Cheez Koi Kyo Nhi Sikhana Chahta... Error to Find Out Ho Jaati Hai Uska Solution To Btaye Please......

[@becominganexpert]

Sir difference ko 3B and R1 me adjust karana padega.

[@AmandeepSingh-zr6xi]

@@becominganexpert Sir Adjust krane Ke Liye Kya Treatment Jarrori Hota Hai Wo Jaroor Btye Aap, Pls Request Haii

[@abuzarshaikh4583]

Q: sir ji sale return k liye without gst credit note bnayenge (bcz gst already hmne file kiya aur debtor itc le chuka) too accounting m kuch issue hoga ?
Can u share ur no. Sir for accounting quarey..

[@becominganexpert]

@@abuzarshaikh4583 9404776008
Whatsapp

[@thinkingforyou786]

*Please provide Excel sheet.💓*

[@becominganexpert]

docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit?usp=sharing&ouid=114971401011962481309&rtpof=true&sd=true

[@becominganexpert]

Practice file = docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit?usp=sharing&ouid=114971401011962481309&rtpof=true&sd=true

[@oyeamit-gn4xw]

Sir aapne rcm or export ka data kyun nhi liya

[@becominganexpert]

RCM ko reconcile karane ki jarurat nahi thi kyonki ham jitana sales me dikhate hai utana hi purchase me dikhatr hai.
Agar aapako karana hai to alag se kar sakate hai.
Mera export nahi tha isaliye nahi liya
Agar aapaka hai to le sakate hai

[@manisharawat125]

Sir GSTR-1 Ka sales data kaha se download kiya aapne?

[@becominganexpert]

Video me dekhiye
Comparison nikalate hai tabhi automatic summary aayegi. aapako invoice wise nikalana hai kya?

[@girishchand2451]

​@@becominganexpert Yes how to generate invoice wise summary sir

[@becominganexpert]

@@girishchand2451 50 invoices tak free me karega

[@girishchand2451]

@@becominganexpert Kha sai hoga sir wo

[@BabyManvikNegi]

Best video i have ever seen
ruclips.net/video/9OcPyWOvisw/видео.html

[@rajasveersingh2569]

GST filing me iska kya kaam hota hai?

[@becominganexpert]

Annual return ke liye reconciliation ke kam aata hai.

[@vikrant1780]

Sir monthly 3b working banti h uski tally data se reconciliation kaise hogi

[@becominganexpert]

ruclips.net/video/yaGKuP51BrU/видео.html
Gstr1 ki jagah par 3b working ka data use karana

[@sonyshaw1438]

😊

[@becominganexpert]

Thanks

[@bulbulgotiya9834]

Couldn't find this on my official site

[@becominganexpert]

Regular Taxpayers or composition Taxpayers?

[@shyamallrounder]

Sir GST 1 ki sale kaise download kare

[@becominganexpert]

Comparison me 3b & 1 sath me aayenge

[@kuldeep.1397]

how to find import itc?

[@becominganexpert]

Same process
5 input tax credit import

[@sahoo7ankit]

GST PORTAL PAR TAX LIABILITIES AND ITC WALA OPTION KO DETAIL ME BATAYE SIR

[@becominganexpert]

Sure

[@URBNT]

Sir mere last 3-4 month ke kuch invoices Gstr1 or Gstr3b mein show nhi kiye tou usse next month me kar skte hai ??

[@becominganexpert]

Yes

[@URBNT]

@@becominganexpert sir old invoices ka tax gstr3b mein breakup tax liability ke throw show krege ya direct kr skte ??

[@becominganexpert]

@@URBNT 9404776008
Whatsapp

[@Bindass_jattni_hr26]

Taxable values bhi asa hi minus kni h

[@becominganexpert]

Yes seles ka credit note ka
And purchase ke debit ka.

[@kishorkumar-dr5bq]

How to download data this data from Tally

[@becominganexpert]

Display
Account book
Sales Register
Columner
Export in excel

[@johncysamuel]

👍❤🙏

[@yatendrasengar2221]

all gst return e filling ka vedio ka link send kren

[@becominganexpert]

ruclips.net/video/sVx93guEHp4/видео.html

[@becominganexpert]

Thanks Sir
Please share our videos with your all contacts. I need your help.

[@avinashmuley8615]

Is se acha software lo

[@amitghanekar7492]

R1 ka kuch data delete kyu kiya?

[@becominganexpert]

No

[@amitghanekar7492]

9.20

[@becominganexpert]

@@amitghanekar7492 vo difference nikal raha tha isaliye.
Utane amount ka difference aa jayega jyo delete kiya hai.

[@amitghanekar7492]

@@becominganexpert smja sir, jo delete kiya utna differance aana chahiye pivot table mein.
Thank you sir for replying.

[@jayeshkapadia792]

too long process

[@thakurgauravraghav4895]

Sir mujhe ye format chahiye

[@becominganexpert]

Normal format hai
Poŕtal se download karake formatting karana padega.
Otherwise 9404776008 par aapaka mail id whatsapp kijiya

[@thakurgauravraghav4895]

@@becominganexpert ok sir

[@albetrisemariyadenny6741]

Shall I get this class in English

[@becominganexpert]

Yes
7387600847
Whatsapp me

[@CAAMEYA80772]

🏆🏆🏆🏆🏆🏆🎉🎉🎉🎉🎉🎉❤❤❤❤❤❤

[@gorachandsingha406]

Sir pls gst advance course

[@becominganexpert]

Sure

[@gorachandsingha406]

@@becominganexpert thanks for reply

[@learner4443]

@@becominganexpert when 🙁

[@dheerajjha9208]

Bhai vedio 11 minutes ka or sikha doge 5 mon m ye kya logic h

[@becominganexpert]

Bhai karane me 5 minutes lagata hai
Sikhane me time lagega na
Itana bat kiya usame aur ek company ka kar deta

[@rahultiwari9042]

Ms office konsa h apka

[@becominganexpert]

Isame 2019 use kiya hai

[@rahultiwari9042]

@@becominganexpert sir apka windows 10 nahi fir bhi ms office 2019 work kese kar raha h please batao

[@akblearnmore]

Bro thoda achhe se samjhjye. Kuchh v samanj nehin aa raha hee

[@becominganexpert]

Gst me kam karate ho kya?
Aapako basic malum hona chahiye

[@akblearnmore]

@@becominganexpert sir jii agar mujhe malum hota too video kiun dekhta 🤷

[@becominganexpert]

@@akblearnmore Right ✅
Pahale aap ye video dekhiye
ruclips.net/video/BN80DWEjRPE/видео.html
Jabatak aapaka basic strong nahi hoga tabatak reconciliation samaz me nahi aayega.

[@ramitasharma7]

Sir sales ke figure kha se nikale

[@becominganexpert]

Aap jyo accounting software use karate hai usase

[@kiransingh5519]

​@@becominganexpert sir mujhe gstr1 or gstr3b Excel m comparison Krna h kaise kru please help

[@becominganexpert]

@@kiransingh5519 sir ye video usi ke bare me hai
Whatsapp [phone]

[@madanmadhav7213]

Kuch samj nahi aaya

[@becominganexpert]

Kaise

[@madanmadhav7213]

@@becominganexpert itne sare deta ek saath samj nhi aa rha

[@sudhiac7065]

Learn basic Gst , pivot table etc first and then watch .It is very simple. Igst,cgst and sgst comparison.

[@mrsinghofficial37]

🤣🤣🤣🤣🤣