Combo 1 – TDS & TCS Course + Automation of BS and P&L
About Bundle
Excel is most powerful tool and if you use it in Accounting it work like wonders and help you to save lots of your time. This course provides you learning of Automation of balance sheet and Profit & loss on the basis of Trial Balance by using excel. Make sure your Trial Balance should be in excel format.
This course will also help you to match opening and closing balances in 5 minutes. Also you can prepare MIS reports, comparative reports etc. with the help of this course. you will gain so much knowledge that you can prepare balance sheet on daily basis just in 5 minutes.
It is very easy to understand.
Content of Course :
- Powerful Excel Formulas (Most powerful Excel formula sikhaye jayenge jo aapko sirf B.Sheet banane mein hi nhi balki har jagah kaam aayenge)
- Checking of Trial Balance to correct mistake if any within 2 minutes
- Trial Balance arrangements using Excel for Automation
- Creation of Masters and Groups
- Preparation of Balance Sheet and Profit & Loss automatically with Trial Balance
- Full automation of B.Sheet ( iska matlab ek baar automation ke baad aap chahen toh daily balance sheet bana sakte hain woh bhi bus 5 minute mein, yaani agar Trial mein koi change ho jaaye toh bhi aapko koi pareshani nhi hogi,Ghanto ka kaam minuto mein hone lagega)
- Checking of Opening Trial Balance with Closing Trail Balance before finalization of Balance sheet is must and we will let you know how you can do this in minutes
TDS & TCS concept is wider in income tax, one can start his or her own consultancy in this field alone and can earn a good amount with consultancy of TDS and TCS only
TDS & TCS compliance are most important for Businessman’s, professionals and consultants. This Practical course contains everything about TDS and TCS i.e. Section wise Concepts clarity, New TAN apply, Register and activate new TAN, All TDS and TCS returns filing (Including Salary) through free software of NSDL (RPU utility), Form 16/16A/16B/16C Download, Lower Deduction certificates apply, Late Fee, TDS return correction/Revision (challan & Deductee), TDS on Non Resident, TDS on Property and many more.
Join this most beneficial course to start your own consultancy in TDS and TCS.
one must aware of TDS and TCS compliance because if you miss these compliance’s than consequences are heavy, and you will be more than happy if you can do these compliance yourself without the help of anyone else. Join course and get benefited.
By CA Pooja Gupta.
What is this Course?
This course is divided in following parts :
1 TDS Conceptual Clarity
2 How to Apply for New TAN
3 New TAN Registration Process on Income tax Portal
4 How to Register and Active New TAN on Traces
5 Know PAN for TDS
6 Sec 192 TDS on Salary
7 Sec 192A Pre mature withdrawal of Provident Fund
8 Form 24Q Filing (Through Free Software RPU by NSDL)
9 Sec 194C TDS on Contractor
10 Sec 194D, 194H & 194G TDS on Commission
11 Sec 193 Interest on Securities
12 Sec.194A TDS on Interest other than securities
13 Sec.194 TDS on Dividend
14 Sec.194B & BB TDS on Winnings
15 Sec.194DA Payment of Maturity amount of life insurance premium
16 Sec.194E Payment to non-resident sportsmen or Sports association or Entertainer
17 Sec.194EE National Saving Scheme
18 Sec.194F Payment on repurchase of Units by Mutual fund/UTI
19 Sec 194I TDS on Rent
20. Sec 194IA TDS on property (New PAN based Challan cum return Detailed coverage)
21 Sec 194IB TDS on Rent by certain individuals (PAN based Challan cum return Detailed coverage) with Filing of 26QC
22 Sec 194IC Payment under Joint Development Agreement
23 Sec 194J TDS on Professional services
24 Sec 194LA Compensation on Compulsory acquisition of immovable property
25 Sec 194K TDS on contract, commission or brokerage or Fee for Professional service
26 Sec. 194M TDS on certain payments (PAN based Challan cum return Detailed coverage)
27 Sec 194N TDS on Cash withdrawal
28 Sec 194O TDS on E Commerce
29 Sec 194P Pension (along with interest on bank account)
30 Sec 194Q TDS on Purchase of Goods
31 Sec 194R TDS on Perquisites
32 Sec 194S TDS on Virtual Digital Asset
33 TCS (Complete Concept clarity – TCS on Certain Goods, TCS on Sale of Goods, TCS on Motor Vehicle, TCS on Lease of Parking, Toll plaza, TCS on Foreign Remittance)
34 TDS Return Form 26Q Filing (using Free RPU utility of NSDL)
35 TCS return Form 27EQ Filing (using Free RPU utility of NSDL)
36 Correction of TDS returns (online for Challan and deductee details or employee details)
37 Form 16, 16A, 16B, 16C Download
38 Section 195 TDS of Non Resident
39 Form 27Q Filing
40 How to Pay TDS/TCS online (new payment option explained)
41 FAQ coverage for important sections and many more
Is this Live or Recorded?
This course is containing Pre-Recorded Lectures, so user can watch anytime, anywhere and from any device.
What is course validity?
You can watch unlimited times for lifetime as you per your convenience. It can be watch on Mobile/Tab/Desktop/Laptop.
