Тёмный

Full GST Work in Excel Sheet | GST का सारा काम Excel में करना सीखें | GSTR-1 Return | GSTR3B Return 

The Accounts
Подписаться 419 тыс.
Просмотров 151 тыс.
50% 1

Are you looking to improve your knowledge and skills in the taxation field? If so, then you need to join our Taxation Mastery Course! Click here:-
theaccounts.in...
Our course is the most comprehensive and up-to-date training program available on GST, ITR & TDS. It is suitable for anyone who wants to gain a deeper understanding of these important taxation concepts, regardless of their background or experience.
The course covers a wide range of topics, including:
The basics of GST, including registration, classification of goods and services, invoicing, and returns filing
1. The different types of ITRs and how to file them accurately
2. The different types of TDS and how to deduct and remit them correctly
3. The different types of TCS and how to collect and remit them correctly
4. Complete salary processing
5. The latest updates and changes to the tax laws
In addition to the theoretical knowledge, the course also provides hands-on training on GST return filing and TDS computation. This helps learners to gain the practical skills they need to comply with the tax laws.
Here are just some of the benefits of taking our course:
1. A deeper understanding of the taxation system in India
2. The ability to file GST, TDS, TCS returns and Income Tax correctly
3. Compliance with the latest tax laws
4. Increased confidence in handling tax-related matters
5. Improved career opportunities in the taxation field
No matter what your background or experience, our Taxation Mastery Course can help you to improve your knowledge and skills in the taxation field. So what are you waiting for?
Join our course today!
🤯Click here to join:- theaccounts.in...
For Any Query call us on:- 9708101770
WhatsApp us Click here:- wa.me/9708101770
Mail Us on:- info@theAccounts.in
👉Website:- theaccounts.in/
Follow us on…
👉Facebook:- / theaccount
👉Join Our Facebook Achievers Group:- ​​
/ theaccountsachievers
👉Instagram:- / theaccountss
#theaccounts
#mdshafiahmed
#gst
#itr
#tds
#accounting
#accounts
#tallyprime
#tally
#incometax
#incometaxreturn
#incometaxreturnfiling
#payroll
#salaryprocessing
#tcs
(Update website, Facebook, and Instagram link in youtube Banner)

Опубликовано:

 

16 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 139   
@abhisheksrivastav5322
@abhisheksrivastav5322 2 года назад
Very Nice Sir Your Teaching Style Very Impressive And Very Clear 👌👌 Thank You So Much 🙏🙏
@Hridayesh1992
@Hridayesh1992 19 дней назад
Complete free practical course mil jye yahi ummeed hai aapse❤❤❤🎉
@shilpaupadhyay3548
@shilpaupadhyay3548 3 года назад
Valuable information. Thnk you. God bless you
@pankajkatale2585
@pankajkatale2585 2 года назад
I dont have any word to express my felling after watching Your Tutorial....Thats Amazing teaching Sir.hats of you
@omshiv3179
@omshiv3179 3 года назад
Awesome and Excellent sir !! आपका बहुत बहुत धन्यवाद 😘 | आपका यह video मेरे लिए बहुत ही उपयोगी है | अपनी अभूतपूर्व knowledge को share करने के लिए आपका बहुत बहुत शुक्रिया |
@saritajsingh1774
@saritajsingh1774 3 года назад
Kasm se bhoot knowledge h aap ko man to kr raha h mere hath me hota to me 1million de deti aap ko
@TheAccounts
@TheAccounts 3 года назад
It's your goodness Sarita Thank you so much
@ramvashistha9956
@ramvashistha9956 3 года назад
Very useful information..is it enough as you have missed items wise detail in GSTR1, pls suggest
@ramvashistha9956
@ramvashistha9956 3 года назад
I hv a question that why have you missed item wise details in GSTR1.. it's not mandatory or what..
@ramvashistha9956
@ramvashistha9956 3 года назад
You have not answered my question
@TheAccounts
@TheAccounts 3 года назад
If ur turnover above 1.5 crore then u need to give hsn wise details of ur stock item
@vlogwithyatishkandhari6293
@vlogwithyatishkandhari6293 8 месяцев назад
Aap bahut bariki se aur dhire dhire achha se samjhate hai
@vikaspatil-kx8rk
@vikaspatil-kx8rk 3 года назад
Sir your teaching style is very nice 👌. It is very useful in practical life.👌
@papaimaginglife8136
@papaimaginglife8136 2 года назад
Thanks for your valuable lessons, i purchased the excel sheet
@punamsharma8292
@punamsharma8292 3 года назад
You are best teacher for accounts
@ShreeRadha483
@ShreeRadha483 3 года назад
MOST AWAITED VIDEO SIR THANKS 4 THAT THANKYOU SO SO SO MUCH ................
@manjit.sarania
@manjit.sarania Год назад
Very important analysis on GST calculation sir..
@biswajitnag910
@biswajitnag910 3 года назад
As per % formula, tax amount should come corresponding to IGST, CST & SGST column simultaneously. Please explain how the formula itself choose IGST or CGST & SGSTcolumn.
@ravigupta1086
@ravigupta1086 Год назад
If you input 9% it will give CGST/SGST, if you enter 18% it will consider it as IGST
@bijaykumarmishra7689
@bijaykumarmishra7689 3 года назад
Sir i t is not only simpl but also mind blowing solution
@aabedkadri7351
@aabedkadri7351 3 года назад
Mashallah bahut achchi information di hai aapne sir
@vlogwithyatishkandhari6293
@vlogwithyatishkandhari6293 8 месяцев назад
Bahut badhiya samjhaya aapane sor
@shubhrantgupta7052
@shubhrantgupta7052 2 года назад
Tds on rent pe complete knowledge k sath video provide kro sir
@SANJAYGUPTA-wh6kw
@SANJAYGUPTA-wh6kw 3 года назад
Thanks for information.vary nice explain
@baburaopolisetty496
@baburaopolisetty496 3 года назад
Sir in this caluclation table, instead of keeping Roundoff Column, we can round off the total sales in the last column by this formula: =ROUND(SUM(F4:K4)-G4,0), please checkup and modify the calculator sheet sir!!!!
@rajnishupadhyay4623
@rajnishupadhyay4623 3 года назад
Very useful video. Thank you so much sir
@asifansarii600
@asifansarii600 2 года назад
Sir gst new set off rule ka bhi ek.video.bannaiye plz kaise gst adjust karne hai excel.mei aur system.par
@Ravan1992
@Ravan1992 3 года назад
Great video sir.👍👍
@anoopr4892
@anoopr4892 3 года назад
Thank you very much
@amritagupta1243
@amritagupta1243 3 года назад
Sir please ledger scrutiny sikhayein. Internal audit ke aspects bhi sikhayein pls.
@chandankumaraasish7209
@chandankumaraasish7209 3 года назад
Sir Good morning Aapki gst ki class Ka new batch kb se start hoga I want to study for gst
@VINAYSingh-gx1zl
@VINAYSingh-gx1zl 3 года назад
Sir plywood furniture ya kisi bhi furniture ki accounting kaise ki jaati hain ya jab ham kisi job main jate hain aur job main ham furniture ki job mil jaati hain tab alag alag furniture hote hain tab kaise furniture jaise suppose plywood ka business hain to jaise accounting karenge from the start step to step...plese sir ek ek step main batayein aur practical batayein ki furniture ki accounting kaise karein specially sir ho sakein to plywood ka example bhi de kyunki air ji plywood ka hi kam mujhe mila hain so sir plese plese sir ek video starting se step to step plywood showroom main KyA kya accounting ki jaa sakti hain par video banaye soon...sir ji job ka sawaal hain....plese sir
@shuvopurkait7576
@shuvopurkait7576 3 года назад
This video is very useful thanks sir Plz sir round off ka formula
@RahulKumar-ly6ly
@RahulKumar-ly6ly 3 года назад
Thanks sir very helpful video sir
@VINAYSingh-gx1zl
@VINAYSingh-gx1zl 3 года назад
Showroom jo furniture ka showroom ho plywood ka ho bedsheets ka ho kaisa bhi furniture ho so plese sir ek practical video showroom accounting par banaye aur sabhi details and kya kya ek showroom main job lag jaati hain to hamein karna hoga is p Topic par video banaye soon very soon video banaye plese plese plese plese I will wait...and will wait
@parvezansari7604
@parvezansari7604 3 года назад
Sir optotax se gst bharna kese bhare
@radheymohan7465
@radheymohan7465 7 месяцев назад
Sir, I want a program for gstr3b with itc of the month from gstr2b & other addition/minus of entries of purchases i.e. banks, transport, or other entries of itc can be maintain monthwise with annual summary generation. Thank
@bikashhalder516
@bikashhalder516 3 года назад
Very informative.. thanks for such video 🙏
@shafeequeahamedmpm
@shafeequeahamedmpm 3 года назад
How can i make formula for making monthly salary list for the employees basic, food,over timr and bonus.we have to calculate deduction for eg, 2 hr leave/ 2 days 51/2hrs leave.per day daily duty time is 10 1/2 hours duty.morning 7 to 12 and afternoon 2 to 5.30 then 5.30 to 7.30 over time.
@sachinmalvadkar9323
@sachinmalvadkar9323 3 года назад
सर मुझे furniture showroom ka accounting video चाहिए प्लीज़
@sachinmalvadkar9323
@sachinmalvadkar9323 3 года назад
Job मिलने वाली है
@kansingh5968
@kansingh5968 2 года назад
Nice
@arshadansari3341
@arshadansari3341 3 года назад
dear sir mai lucknow se hu apse accunting ki trening lena chahta hai plz help thanx.
@RajendraSingh-jq8ew
@RajendraSingh-jq8ew 2 года назад
Sir namskar, agar kisi party ka pichle saal ke opening me diffrence ho or party bill provide nahi kar sakta ho to uski entry kaise hogi plz 🙏
@SUNNYKUMAR-kx3qu
@SUNNYKUMAR-kx3qu 3 года назад
Thanks sir
@mdaarfialam8660
@mdaarfialam8660 3 года назад
Very useful knowledge sir.. Sir Bike/car ke showroom me kis trah se work hoti hai sir. Eske bare me bhi ek video provide kijye sir please.
@reviewstar_deepakmishra5226
@reviewstar_deepakmishra5226 2 года назад
Well Explained.
@karankushwaha9888
@karankushwaha9888 3 года назад
Bhut achchha lga apka lesson. Aap is bani hui exel sheet ko sale krte hai kya. Krte hai to kitne price lenge.
@jaynandangiri4401
@jaynandangiri4401 3 года назад
Supppppp Video Hai Sir .....,.
@ravichaudhry5430
@ravichaudhry5430 3 года назад
Very useful video
@laderajeshwarrao1719
@laderajeshwarrao1719 20 дней назад
SIR IF IN LOCAL PURCHASE BILL HAVE 5% 12% 18% GST ITEMS SO HOW WE HAVE TO CALCULATE WITH THIS FORMULA AS YOU SHOWING IN EXCEL ,PL MENTION SO CAN GET EASY TO DO WORKING
@cogwheelLearning
@cogwheelLearning 3 года назад
Appreciate the effort 🔥🔥
@pawansaraswat4725
@pawansaraswat4725 3 года назад
sir agar ek hi invoice me alag alag tax rate ho to ye excel format kaise kaam karega.....
@chandrahasyadav2541
@chandrahasyadav2541 3 года назад
Sir aapki jankari achhi hai but aap SK video ye banao ki jisase ye clear ho Jaye ki 3 b me kya tax payable krna hai ye aap excel me banao sir
@neerajsingh9063
@neerajsingh9063 3 года назад
Ye toh simple work h , I'm already doing this. This is all manual. Sir aisa btao Jisse Tally 7.2 ka Excel pe export ho aur multi tax rate wale invoices pe ye PIVOT use ho. including HSN summary.
@asifansarii600
@asifansarii600 2 года назад
Sir get set off ki ek.video baniye please and excel.me calculation kaise kare
@DkRaj54
@DkRaj54 Год назад
Sir total sale me konsa formula konsa h jise round off apne aap nikal rha h
@archiearyal4561
@archiearyal4561 3 года назад
hmmm
@louispaul118
@louispaul118 3 года назад
Please give composition account /return process for small traders
@papurout5798
@papurout5798 3 года назад
Thanks a lot
@user-wr6vo2fz8n
@user-wr6vo2fz8n 9 месяцев назад
Kya hum Google sheets main bhi use kar sakte hai
@subhankarpaul8947
@subhankarpaul8947 3 года назад
Sir tds k ek yearly excel sheet k opor video bana dijiega
@user_5412-sp
@user_5412-sp 3 года назад
samaj Gaye sir ji
@sachinmalvadkar9323
@sachinmalvadkar9323 3 года назад
सर furniture showroom ki accounting का विडियो चाहिए प्लीज़ Job मिलने वाली है
@umeshrathod3293
@umeshrathod3293 3 года назад
Thank you 😊
@docdoc9855
@docdoc9855 3 года назад
Sir aapki video bahut achhi hoti h but use aapne Kaafi complicated kar dia aapne and multiple rated invoice main it doesn't work rather than using pivot table offline tool would be better and and computation sheet was not impressive as well
@ashishpandey4543
@ashishpandey4543 3 года назад
Appreciable
@kismatagencyind
@kismatagencyind 3 года назад
In TABLE (4) eligible ITC, which data I have to put in all other ITC?please explain .
@bantikhan8380
@bantikhan8380 3 года назад
Shukriya
@bhargavvaghela1807
@bhargavvaghela1807 3 года назад
Sir ji tally k invoice me digital signature kaise add kr skte h plz answer digiyega
@parwindersingh4471
@parwindersingh4471 3 года назад
sir my tally me duties and tax and gst payable 2 head ne dona vich mera tax show ho rha sir single head kive bnu plz rply
@kanmanideka60
@kanmanideka60 3 года назад
Sir you are great. You create excellent video for us. I want to join with you and learn step by step from you. If you give me the chance to join with you. I will be very happy and pay the fees to you for your valuable couching.
@shyamprasad3549
@shyamprasad3549 3 года назад
Please tell how to file gst 3b and gstr 1 quarterly for transportor.
@monojitknarar9920
@monojitknarar9920 3 года назад
Sir ap ekbar bank entry Bahut Hoga to kaise usko kam time main reconciliation karein?bank statement ke sath
@ManjayKumar-lc3ml
@ManjayKumar-lc3ml 2 года назад
Sir.gst R1 return ki date jo excel sheet ki formula wrong h
@SHUBHAMKUMAR-pw6fu
@SHUBHAMKUMAR-pw6fu 3 года назад
Rent receipt with NOC kya hi
@viky502
@viky502 Год назад
Sir intrastate ke liye kaise karenge 😊
@meremaheboobkayamathogi8326
@meremaheboobkayamathogi8326 2 года назад
Hsn code wise summary karna batao
@gunavathipichaimuthu9893
@gunavathipichaimuthu9893 2 года назад
grouping opsition is not enable pls tell me the another opsition sir
@arindamroy2353
@arindamroy2353 3 года назад
Sir, total sales column mein rate wala column bhi add ho rakkha hain ek baar check kijiye. total sales should be taxable amount+cgst+sgst/igst. ussme sayad galti se rate ka column bhi add ho rakhha hain. kindly confirm.
@unnie786
@unnie786 Год назад
Kya ye gstr 1 ki or 3b dono ka preparation hai
@teckhindi8291
@teckhindi8291 3 года назад
Sir ji mujhe ek baat poochni h, GST 1 july 2017 ko Applicable hua...Ab tally me jab GST applicable waali screen aati h tab, kon C date daalte hai...Maan lo company 2019 me create kar rhe hai...To ab kon c date daalenge
@jaynandangiri4401
@jaynandangiri4401 3 года назад
Dear Sir. Agar hum Purchase karte hai to uss time pe item ka name kuch or hota hai and jab sale karte hai tab kuch or to uske kaise adjust karenge......... please give me answer
@sgd9064
@sgd9064 3 года назад
इस एक्सेलशीट मे टॅक्स कॉलममे IGST, SGST CGST इसमेसे कौनसा टॅक्स लगेगा यह कैसे समझमे आयेगा
@kittupoojavlogs
@kittupoojavlogs 3 года назад
Dear , The Accounts, mera clothes ka kaam hain aur maine ek gst register person se goods bedsheet kharidi hai 22 quantity hain aur usne mujhe pehle cash memo diya lekin jab maine bataya ki pakka bill chahiye to usne kaha ki kapde par 5% gst lagega to maine kaha koi baat nahi to usne cash memo par hi 5% gst laga kar mujhse le liya aur mujhe nahi pata tha ki cash memo invoice nahi maana jaata hain ye purchase 23 oct 2020 ki hai ,ab maine usse 29 oct 2020 ko fir purchase ki to usne ab pakka bill diya aur pichle bill ko wo pakka nahi kar rha hai mere pass proof bhi hai gst jo maine diya hai ,lekin ab main usse pakka bill mang raha hoon to wo nahi de raha hain , mere pass cash memo hain jis par usne mujhe bill diya aur us par 5% gst bhi laga hain to main kya karu apne gstr1 ke monthly return me usko show karu ya nahi , kyonki maine to poora payment diya hain with 5% GST ke saath , mujhe kya karna chahiye , agr main inward supply me is purchase ko show karta hoon to kise dikkat hogi mujhe ya us registered person ko jis se maine maal kharida hain , please help me sir , aap ka bahut ahsaan hoga
@archiearyal4561
@archiearyal4561 3 года назад
hmmmmmmmm
@nirmavaland7710
@nirmavaland7710 3 года назад
Sir gstr 1 export karte he to excel sheet me to kya check karna chahiye ?
@SHUBHAMKUMAR-pw6fu
@SHUBHAMKUMAR-pw6fu 3 года назад
Rent receipt with NOC kaa GST Registation kaise kre
@apexcareereducation2294
@apexcareereducation2294 2 года назад
Sir ek galti hai aapne table formet me galti kar di jis wajh se total sales me rate of gst bhi Jud ja rahi hai apko pahle rate ka column ana tha fir taxeble amount
@comedybadshah2167
@comedybadshah2167 3 года назад
But isme cgst, sgst aur igst dono le lega aisa kaise krenge ki sirf ek le
@gauravhr2979
@gauravhr2979 3 года назад
Sir jo tally ap use kartey hai uska link bhej do
@sanjibchowh3578
@sanjibchowh3578 3 года назад
Sir apne shayad 2.5 rate ko bhi jor dia hai total sales mein correct me if iam wrong kindly sahi kar dijia, i think value hoga 1048.00 after rounding
@MM-ew3uj
@MM-ew3uj 3 года назад
Sir tally me kya kya sikhe jisse ek ache accountant bn paye ,.. please sir reply kijiye mujhe bs purchase sale receipt payment sale order purchase order aur delivery challan sab aata hai but aur Mai kya sikhu Kaha se. Start Karu Kuch samjh nhi aa raah wo taxation brs ye sab Ka video bna diziye
@bankukumar7305
@bankukumar7305 3 года назад
Other countries me GST ka work kese kare
@vikaspal5316
@vikaspal5316 3 года назад
Sir g, agar ak hi Bill mein 5%,12,18 means alag alag tax rate Hain to is Excel sheet ko kaise maintain krein. Pls help
@vikaspal5316
@vikaspal5316 3 года назад
Pls help sir G
@vikaspal5316
@vikaspal5316 3 года назад
Pls reply
@SaddamHussain-mt6cx
@SaddamHussain-mt6cx 3 года назад
Sir isme ek mistake he agar taxable value 100 he to 100 + 5% = 105 , hona chahiye Bt esa nhi ho rha he 100 + 5%= 110 arha he
@shy0330
@shy0330 3 года назад
Very nice knowledge thanks sir
@santoshthakur5290
@santoshthakur5290 2 года назад
Data me change kerne per Pviot table me change nahi hota h
@shyamprasad3549
@shyamprasad3549 3 года назад
How to see your previous vedeo.
@aasthapuri7654
@aasthapuri7654 2 года назад
Amount was cut but file is not download. Why sir? Where is the file
@TheAccounts
@TheAccounts 2 года назад
Send me payment details at bindas33727@gmail.com
@mdfirojansari5267
@mdfirojansari5267 3 года назад
Sir tally prime ka bare me bataiye
@anishgupta2880
@anishgupta2880 3 года назад
Hi sir, maine aapki file purchasw kri h but isme tcs nhi h... mujhe tcs vali file do please vrna mere money waste h
@baljeetsharma9874
@baljeetsharma9874 3 года назад
sir farmula is wrong.total amount me 3 times + ho jata h,sir corecet this.
@shuvopurkait7576
@shuvopurkait7576 3 года назад
Sir plz Round off kaisa करू plz formula plz 😢
@Sayyadfatma
@Sayyadfatma Год назад
Sir aap Bihar se hain?
@TheAccounts
@TheAccounts Год назад
Yes
@RihanKhan-bl9pd
@RihanKhan-bl9pd Год назад
Credit note or debit note add kiye hi nhi
Далее
Excel Computation for GSTR 1 Return
33:53
Просмотров 50 тыс.
How would you react?!😳
00:44
Просмотров 2,9 млн
Complete Knowledge of GSTR-3B
1:07:41
Просмотров 311 тыс.
GSTR 1 Filing Online and Offline Method in 2023
28:36