gst Reconciliation Excel | gst reconciliation & mismatch | gst Reconciliation | gst reco
HTML-код
- Опубликовано: 20 авг 2024
- 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.
Practice file: Click-file-Downlow-xlsx : docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit#gid=933065464
Best video sir ❤
Mujhe kal GST reconciliation Krna hai usse ehle mujhe apne bhot achhe se bta diya thanku so much ❤
Thank you
Practice file ( File - Download - xlsx ) = docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit?usp=sharing&ouid=114971401011962481309&rtpof=true&sd=true
your shortcut idea for GST reconciliation is very nice to do so within short periods. thanks
Thanks
Very helpful for annual reconciliation of GST. Thanks 👍🙏
Aditya You Are Done very well job Ty Your video is very helpfull for Begineers 🎉
Thanks Nilesh
Thank you so much sir this video is really very helpful
And I prepared my BRS in my own
Thank you so much sir
Thanks
I found some points very helpful
Very Useful video for me
Thanks for sharing
Very useful, thank you so much
Good explanation very useful thanks...
Thanks
🎉❤😊😊😊
Very simply Teached
Glad you think so!
Thank you sir. Execellant teaching.
Thanks
sir aapke vidoes bahut aache hai
.. aap gst jaise hi tds reconciliation par bhi ek video bana dijiye
Very good
Nice video sir
Excellent video sir thanks
Good knowledge provide by you 🙏
Thanks
nice presentation
mind blowing
Very helpful 👍 thanks
Thanks
Very helpful sir🙏 , keep it up
Thanks
GREAT SIR
Thanks
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.
Open tally-display-account book-purchase register-open any month-select period-F8 for Columnar-select what you want-export in excel
Nice video thanks sir.
Thanks
Thank you
nice work
Thanks very Nice
Very useful video bro
Thanks
Nice video
Thank you sir
Thanks
Nice vedio bhai
Thanks Bhai
Nice information
nice sir
1 No
Thanks 😊
Thanks sir ji
Thanks
Good👍
Nyc working
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?
Very nice sir
Thanks
Thank u 🌼
Thanks
For complicated and high volume reconciliations with multiple files, I have been using Foxpro programs since a long time....
Thank u sir 🙏
Thanks
Very helful
Thanks Sir
Sar namaskar
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.
Currently not but i will start soon
Nice
sir , please upload party and vender reconcilation video. thank you
nice info sir
Thanks
Mujhe Apne invoice ke bare mein jankari leni hai kuchh kya aap bata sakte hain Sahi kaise ki ja sakti hai
Jab diffrence mil jaye to uska kya kare....
Sir gst ka upar excel and tally ka ek basic to advance lebel par ek video banaye.
Sure
Thanks so much please provide complete gst course
Thanks
Good
Thanks
Sir, Jo data apne rally se extract kiya tha vo r1 thi ya 3b?
Mai R1 me jakar sales ke export karata hu.
3b aur r1 me same hi rahega
Sir, app gst ki portal se jo csv file ka data copy kiya aur paste jaha pe kiye uska format kaha se milega
Sir description me link hai
Usapar click karana
File- Download-xlsx
bro how to reconcile gst when we pay gst with interest
Nice sir
Thanks Sir
You explain very well, but our 80% sales are b2c then there is any way to reconcile b2c transaction
B2C also reflect 3B and R1
@@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
Sir I have missed two invoices of fy 21-22,how can I take itc of that bills pls guide me
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.
Monthly reconciliation ka bi vedio bana dijiye
Sure
Sir can u pls brief on gst3b and input tax on purchase and where it reflects on gst summary report
Yes Sir
Tax liability means sales
ITC means purchase credit.
You can download whole comparison
ruclips.net/video/a5Q99BWpOvM/видео.html
Can we download taxable value with igst,cgst,sgst
No sir
We have to open every gstr-3b for taxable
It is very useful
Thanks
Sir pivot table advance and vlookup advance
Sure
Pivot table ke aur bhi video banaye hai. Please playlist me jakar dekhiye.
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
30 Oct rahata hai
Lekin is bar 30 nov tak extend kiya hai.
Good morning sir
Me jese pivot table lagta hu to date me months nhi aate date wise aata hai
Right click on date-group-remove selection of day and year. Only month blue hona chahiye.
Credit note & debit note 2a & 2b main kaise recon karee??
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
@@becominganexpert thankuuu Soo much for your video💟💟...
Apka wp no. mil sakta hain??
@@shrlkhm5159 9404776008
❤
2 b bisy win se kase match kare
Sir firm ke case kaise kerte hai sales tax department me
Gst to same hota hai
I deal in sales tax cases. Kindly connect at email : taxdotsolution@gmail.com
Sir treatment ment kese kare gst r1 or 3b ka books bhi nahi he
Means GSTR-1 & 3B me nahi hai
Lekin books me hai. Right?
M bhi इसी तरीके से कर्ता hu 😂😂😂😂same to same
Thanks
Hello bhai
Sir Major Cheez Koi Kyo Nhi Sikhana Chahta... Error to Find Out Ho Jaati Hai Uska Solution To Btaye Please......
Sir difference ko 3B and R1 me adjust karana padega.
@@becominganexpert Sir Adjust krane Ke Liye Kya Treatment Jarrori Hota Hai Wo Jaroor Btye Aap, Pls Request Haii
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..
@@abuzarshaikh4583 9404776008
Whatsapp
*Please provide Excel sheet.💓*
docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit?usp=sharing&ouid=114971401011962481309&rtpof=true&sd=true
Practice file = docs.google.com/spreadsheets/d/1Zwlj0i2to-x_3izEIhL1UXI-diHAINHO/edit?usp=sharing&ouid=114971401011962481309&rtpof=true&sd=true
Sir aapne rcm or export ka data kyun nhi liya
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
Sir GSTR-1 Ka sales data kaha se download kiya aapne?
Video me dekhiye
Comparison nikalate hai tabhi automatic summary aayegi. aapako invoice wise nikalana hai kya?
@@becominganexpert Yes how to generate invoice wise summary sir
@@girishchand2451 50 invoices tak free me karega
@@becominganexpert Kha sai hoga sir wo
Best video i have ever seen
ruclips.net/video/9OcPyWOvisw/видео.html
GST filing me iska kya kaam hota hai?
Annual return ke liye reconciliation ke kam aata hai.
Sir monthly 3b working banti h uski tally data se reconciliation kaise hogi
ruclips.net/video/yaGKuP51BrU/видео.html
Gstr1 ki jagah par 3b working ka data use karana
😊
Thanks
Couldn't find this on my official site
Regular Taxpayers or composition Taxpayers?
Sir GST 1 ki sale kaise download kare
Comparison me 3b & 1 sath me aayenge
how to find import itc?
Same process
5 input tax credit import
GST PORTAL PAR TAX LIABILITIES AND ITC WALA OPTION KO DETAIL ME BATAYE SIR
Sure
Sir mere last 3-4 month ke kuch invoices Gstr1 or Gstr3b mein show nhi kiye tou usse next month me kar skte hai ??
Yes
@@becominganexpert sir old invoices ka tax gstr3b mein breakup tax liability ke throw show krege ya direct kr skte ??
@@URBNT 9404776008
Whatsapp
Taxable values bhi asa hi minus kni h
Yes seles ka credit note ka
And purchase ke debit ka.
How to download data this data from Tally
Display
Account book
Sales Register
Columner
Export in excel
👍❤🙏
all gst return e filling ka vedio ka link send kren
ruclips.net/video/sVx93guEHp4/видео.html
Thanks Sir
Please share our videos with your all contacts. I need your help.
Is se acha software lo
R1 ka kuch data delete kyu kiya?
No
9.20
@@amitghanekar7492 vo difference nikal raha tha isaliye.
Utane amount ka difference aa jayega jyo delete kiya hai.
@@becominganexpert smja sir, jo delete kiya utna differance aana chahiye pivot table mein.
Thank you sir for replying.
too long process
Sir mujhe ye format chahiye
Normal format hai
Poŕtal se download karake formatting karana padega.
Otherwise 9404776008 par aapaka mail id whatsapp kijiya
@@becominganexpert ok sir
Shall I get this class in English
Yes
7387600847
Whatsapp me
🏆🏆🏆🏆🏆🏆🎉🎉🎉🎉🎉🎉❤❤❤❤❤❤
Sir pls gst advance course
Sure
@@becominganexpert thanks for reply
@@becominganexpert when 🙁
Bhai vedio 11 minutes ka or sikha doge 5 mon m ye kya logic h
Bhai karane me 5 minutes lagata hai
Sikhane me time lagega na
Itana bat kiya usame aur ek company ka kar deta
Ms office konsa h apka
Isame 2019 use kiya hai
@@becominganexpert sir apka windows 10 nahi fir bhi ms office 2019 work kese kar raha h please batao
Bro thoda achhe se samjhjye. Kuchh v samanj nehin aa raha hee
Gst me kam karate ho kya?
Aapako basic malum hona chahiye
@@becominganexpert sir jii agar mujhe malum hota too video kiun dekhta 🤷
@@akblearnmore Right ✅
Pahale aap ye video dekhiye
ruclips.net/video/BN80DWEjRPE/видео.html
Jabatak aapaka basic strong nahi hoga tabatak reconciliation samaz me nahi aayega.
Sir sales ke figure kha se nikale
Aap jyo accounting software use karate hai usase
@@becominganexpert sir mujhe gstr1 or gstr3b Excel m comparison Krna h kaise kru please help
@@kiransingh5519 sir ye video usi ke bare me hai
Whatsapp 7387600847
Kuch samj nahi aaya
Kaise
@@becominganexpert itne sare deta ek saath samj nhi aa rha
Learn basic Gst , pivot table etc first and then watch .It is very simple. Igst,cgst and sgst comparison.
🤣🤣🤣🤣🤣