S1 : Basics of Commerce, Accounting
S1.1 What is Commerce01:31
S1.2 What is Accounting, Why do we need it02:49
S1.3 Double Entry Accounting System Steps, Structure08:15
S1.4 Golden Rules of Accounts03:19
S1.5 Rules of Accounts with Journals10:54
S1.6 Fundamentals of Accounting12:07
S2. Course Tips, Download Materials and Practice Notes
Download Materials
S2.2 Tally Certification awareness video06:02
S3. TallyPrime Basics
S3.1 Tally Overview – History, vantages04:58
S3.2 TallyPrime – Licence Modules and Pricing04:13
S3.3 Tally Rental License Request02:17
S3.4 Download and Installation, Update TallyPrime05:52
S3.5 Launching TallyPrime – Education Mode & Activating License02:52
S3.6 Creating New Company, Alteration, Deletion and Change default data saving path10:45
S3.7 TallyPrime Pre-defined Vouchers-Introduction02:27
S3.8 Recording Purchases and sales17:06
S3.9 Recording Contra, Receipt and Payment Vouchers14:36
S3.10 Recording Journals in TallyPrime07:17
S3.11 How to update Opening balance for Ledgers, Opening Stock for Items07:21
S3.12 Group Company Creation in TallyPrime09:24
S3.13 Tally Data Recording Methods08:55
S4. Billing in TallyPrime with GST
S4.1 What is GST-a short Introduction to GST04:02
S4.2 GST Classifications and Place of Supply02:42
S4.3 Recording GST Purchases & Sales – Traditional Method36:02
S4.4 Recording GST with Auto Billing , Exclusive GST Ledgers for Input and Output06:35
S4.5 Billing Configuration – Company Logo03:14
S4.6 Billing Configuration – Additional Description for Stock items & Ledgers02:58
S4.7 Billing Configuration – Enable Rate Inclusive of Taxes column02:49
S4.8 Billing Configuration – Update Sales Voucher Numbering02:47
S4.9 Printing Preferences-Cust Seal and Signature, Jurisdiction, Bank Details, Invoice Status04:51
S4.10 Optimize Printing Paper Size04:00
S4.11 Recording GST Services I Sales and Purchases of Services in TallyPrime09:02
S4.12 Recording GST Expenses Claimable and Non-claimable10:12
S4.13 Recording GST Assets – claimable and non-claimable08:36
S5: GST Filing, E-Invoice & E-waybill generations
S5.1 Understanding GST Returns & Types10:02
S5.2 GST Tax Computation and Adjustments06:20
S5.3 Learn GSTR-1 Tables10:54
S5.4 GSTR-1 Filing using TallyPrime12:32
S5.5 Filing Nil-GSTR-1 I when there is no Sales01:37
S5.6 GSTR-1 Amendments I Modify Previous Months Invoices03:16
S5.7 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods21:53
S5.8 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary – Adjustments07:42
S5.9 E-Way Bill-Registration03:30
S5.10 E-WAYBILL Generation, Cancellation, Update and more06:55
S5.11 E Invoice Introduction02:13
S5.12 E-Invoice – GSTIN Registration of E Invoice Portal01:01
S5.13 E-Invoice Enablement for GSTIN on E Invoice Portal02:30
S5.14 E-Invoice – API User Creation for Your Accounting Software03:38
S5.15 Generate E-Invoice using Tally – Generate and E-Invoice ,Print within Tally using API Logins05:06
S5.16 E – Invoice Cancellation in Tally as well as E-invoice Portal02:36
S5.17 E-Invoice Generation – Tally to JSON , JSON Manual Upload on E Invoice Portal _ if API logins are not created04:09
S5.18 E-Invoice Generation Using Official Excel kit – Excel to JSON, JSON upload on E-Invoice Portal02:40
S5.19 GST Composition scheme introduction, Slabs, Eligibility08:59
S5.20 GST CMP-08 Filing – Composition GST Return Filing07:17
S6. Inventory Management
S6.1 Inventory Management – Introduction, Importance, Advantages04:21
S6.2 Creation of Unit of Measurement02:31
S6.3 Stock Group – Creation and Alteration’02:51
S6.4 Stock Category – Creation and Alteration01:57
S6.5 Stock Items – Creation and Alteration03:35
S6.6 Activation of Batches for Stock Item02:36
S6.7 allocation of batch details in purchase invoice06:43
S6.8 selling of stock items from batch and identifying of expired batch in sales invoice, printing batch info07:06
S6.9 Returning of Expired Batch Stock Item03:43
S6.10 Activating Price Levels01:47
S6.11 defining price levels, creating price list, usage of price list in sale voucher07:17
S6.12 Revise Price List01:49
S6.13 Different Types of Inventory Valuations02:57
S6.14 Activation of Purchase Order and Sales Order02:57
S6.15 Activation of Delivery & Receipt Notes04:35
S6.16 Activation of Debit & Credit Note01:43
S6.17 purchases management – purchase order, receipt note, purchase, purchase returns17:07
S6.18 Sales Management – Sales Order, Delivery Note, Sales, Sales Return08:45
S6.19 Creation of Godown01:34
S6.20 How to Create and Manage Multiple Godowns in TallyPrime05:32
S7. Bill-wise Accounts I Bills Receivables and Payables Management
S7.1 Bill-wise Accounts – An Introduction05:23
S7.2 Bill-wise Accounts – Purchases12:29
S7.3 Bill-wise Accounts – Sales06:00
S7.4 Bill-wise Accounts – Tracking Overdue Supplies04:39
S7.5 Bill-wise Accounts – Advances Management06:05
S7.6 How to view and analyze bills outstanding reports in tallyprime04:33
S8. TallyPrime with Banking
S8.1 Cheque book configuration in tallyprime10:46
S8.2 Cheque Printing in TallyPrime05:13
S8.3 Enabling All Banking Transaction Types02:49
S8.4 An introduction to post dated cheques management06:05
S8.5 Post dated cheques management in tallyprime16:18
S8.6 Applying for TallyPrime License01:43
S8.7 Introduction to bank reconciliation process in tallyprime05:41
S8.8 Bank reconciliation in tallyprime22:02
S8.9 How To Do Auto-Bank Reconciliation04:37
S9. Miscellaneous Topics in TallyPrime
S9.1 Calculator Usage in TallyPrime04:04
S9.2 Alternative unit of Measurement04:09
S9.3 Part Numbers in TallyPrime02:34
S9.4 Standard Rate Setups in Tallyprime03:42
S9.5 Export Reports from Tally I Excel, PDF, JPEG04:39
S9.6 Group Company – Creation, Alteration09:24
S10. TallyPrime Closing
S10.1 Golden Rules of Accounts, Treatment Statements03:46
S10.2 Capital and Drawings Related Adjustments20:17
S10.3 Party Related Adjustments – Settlement Discounts, Bad debts, Reserve for Bad debts21:07
S10.4 Appreciation and Depreciation related adjustments09:18
S10.5 Prepaid and Outstanding related adjustments08:50
S10.6 TallyPrime Closing – Backup, Split Company, Setup New FY12:48
S11. Case Studies & Assignments
S11.1 Tally Comprehensive-Test Paper-102:26:06
S12. GST Portal + E Invoice Portal + E Way Bill Portal Concepts
S12.1 What is GST-a short Introduction to GST04:02
S12.2 GST Classifications and Place of Supply02:42
S12.3 Understand GST Number04:27
S12.4 GST Registration Threshold Limits and Documents Required for GST Registration05:49
S12.5 GST Registration-Proprietorship and Partnership37:44
S12.6 Track Submitted Application Status02:19
S12.7 GST Registration – Filing Clarifications04:00
S12.8 GST Practitioner Registration12:17
S12.9 How to Download GST Certificate02:11
S12.10 GST Amendments- Core Fields and Non Core Fields08:23
S12.11 GST – Opting Regular or Composition06:39
S12.12 GST Cancellation and Revocation06:24
S12.13 What is GST Returns, Types of GST Returns10:02
S12.14 Learn GSTR-1 Tables10:54
S12.15 GSTR-1 Filing using TallyPrime12:32
S12.16 Filing Nil-GSTR-1 I when there is no Sales01:37
S12.17 GSTR-1 Amendments I Modify Previous Months Invoices03:16
S12.18 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods21:53
S12.19 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary – Adjustments07:42
S12.20 GST Composition scheme introduction, Slabs, Eligibility08:59
S12.21 GST CMP-08 Filing – Composition GST Return Filing07:17
S12.22 GST Refund- Compete Process13:48
S12.23 How to Generate E-way bill, Registration, Print, Cancellation, Masters Creation, User Creation, 3 methods25:13
S12.24 E Invoice Introduction02:13
S12.25 E-Invoice – GSTIN Registration of E Invoice Portal01:01
S12.26 E-Invoice Enablement for GSTIN on E Invoice Portal02:30
S12.27 E-Invoice – API User Creation for Your Accounting Software03:38
S12.28 Generate E-Invoice using Tally – Generate and E-Invoice ,Print within Tally using API Logins05:06
S12.29 E – Invoice Cancellation in Tally as well as E-invoice Portal02:36
S12.30 E-Invoice Generation – Tally to JSON , JSON Manual Upload on E Invoice Portal _ if API logins are not created04:09
S12.31 E-Invoice Generation Using Official Excel kit – Excel to JSON, JSON upload on E-Invoice Portal02:40
S13: Payroll Management
S13.1 What is Payroll I An Introduction02:21
S13.2 What is Basic Salary, methods of calculating basic salary08:23
S13.3 What is DA, methods of Calculating DA13:35
S13.4 What is HRA, how to Calculate HRA, Taxability and Exemption Calculation06:54
S13.5 Pay heads CA, TA, LTA I Conveyance Allowance I Travel Allowance I Leave TA06:24
S13.6 EPF I Employee Provident Fund I Calculation I Employee and Employer Contributions I Taxability20:52
S13.7 ESI I Employee State Insurance I Rules I Percentages I Contribution Period I11:21
S13.8 What is Gratuity I Calculation of Gratuity I Taxability I Ceiling Limit07:12
S13.9 Bonus Act 1965 I What is Bonus, How to Calculate, Taxability21:40
S13.10 Income Tax on Salary I TDS Computation, Cess, Surcharges, Salary Increment Cases33:43
S13.11 Professional Tax – Stat-wise I Applicability I Slabs06:12
S13.12 CTC vs Gross Salary vs Net Salary05:13
S13.13 Attendance Sheer Preparation I Present, Paid Leaves, Absents, Holidays using Countif, Countif, Sum Formulas16:31
S13.14 Complete Payroll Processing I Basic, DA, HRA, CA, TA, LTA, Bonus, PF, ESI, PT,TDS, cess, Surcharge, Gross-Net Salary01:12:39
S13.15 PaySlip Generation from Paysheet in MS Excel21:53
S13.16 TDS Deposit on Income Tax Portal14:46
S13.17 Employer Contributions PF ESI15:19
S13.18 EPF,ESI Establishment Registration30:03
S13.19 Add – Exit of Employee Records on EPFO website09:44
S13.20 EPF Returns Preparation, Filing24:46
S13.21 EPF Nil Return Filing02:35
S13.22 How to Add Employee in ESI website I generate IP Number06:09
S13.23 ESI Returns Preparation and Filing07:29
S13.24 Tally Prime-Step-1 Creation of a Company Enable Payroll05:50
S13.25 Tally Prime Step-2 Creation of Employee Groups and Employees08:09
S13.26 Tally PrimeStep-3 Creation of Attendances Types05:20
S13.27 Tally Prime Step-4 Part-1 Creation of Pay Heads Basic, DA, HRA, CA, Variables, PF, ESI44:50
S13.28 Tally Prime Step-4 Part-2 Creation of Pay Heads Income Tax, Cess, Sur-charge, Salary Payable37:02
S13.29 Tally Prime Step-5 Define Salary Details05:52
S13.30 Tally Prime Step-6 Payroll Monthly Routine – Attendance, Calculate Salary, payment advise, Payments18:34
S14. Complete TDS & TCS Management
S14.1 Ways of Collecting Income Tax- Self Assessment Tax- Advance Tax, TDS, TCS C126:50
S14.2 Know Basic Terms used in TDS and TCS06:20
S14.3 TDS Process Overview I Cycle of TDS11:32
S14.4 TDS Deposits – Payment Due Dates , Penalties02:23
S14.5 TDS Returns Forms Dues Dates, Penalties09:42
S14.6 TDS Certificates Form 16-16a03:15
S14.7 How to Apply for TAN – Form 49B08:12
S14.8 VV Imp PAN and TAN Registration ON INCOME TAX PORTAL – first time users09:41
S14.9 VV Imp TAN Registration on TDS Traces Portal07:56
S14.10 TDS Case Study-April48:45
S14.11 TDS Case Study-May23:58
S14.12 TDS Case Study-June24:08
S14.13 TDS Returns – Download Required Softwares, CSI File10:06
S14.14 TDS Returns – Preparation and Filing 26Q23:25
S14.15 How to View Submitted TDS Returns and Collect Token RRR Number on Income Tax Portal01:35
S14.16 How to View TDS Return Status on TDS Traces Portal01:28
S14.17 How to Download TDS Certificates Form 16A04:29
S14.18 TDS on Salary – Computation37:01
S14.19 TDS Deposits – Single and Multiple Employees – Challan Maintenance20:59
S14.20 TDS Returns 24Q – Download Required Softwares and CSI File05:35
S14.21 TDS Returns – 24Q preparation and Filing22:42
S14.22 Download Form 16 on TDS Traces Portal04:55
S14.23 How to Register PAN on TDS Traces Portal – Using Aaddhar Info, Deductos Info, Challan Info – C115:00
S14.24 How to Download Provisional Form 16-16A from TDS Traces Portal – C105:49
S14.25 Introduction to TCS I Cycle06:27
S14.26 TCS Case Study-1 I Collection and Deposit22:26
S14.27 TCS Case Study-2 I Collection and Deposit06:26
S14.28 TCS Case Study-3 I Collection and Deposit05:22
S14.29 TCS Returns Preparation and Filing 27EQ15:16
S15. Income Tax
S15.1 What is Tax, History of Taxes in India03:45
S15.2 Direct Taxes vs Indirect Taxes02:45
S15.3 What is ITR, When to File ITR Forms04:44
S15.4 Types of ITR Forms and Applicability21:39
S15.5 Ways of Collecting Income Tax- Self Assessment Tax- Advance Tax, TDS, TCS26:50
S15.6 Taxation Overview on Individuals, Firms, Companies, Political Parties22:13
S15.7 Old vs New Slabs comparison13:23
S15.8 PAN Registration on Income Tax Portal05:17
S15.9 How to Check 26AS and AIS07:02
S15.11 How to Register PAN on TDS Traces Portal – Using Aadhaar Info, Deductos Info, Challan Info15:00
S15.12 How to Download Provisional Form 16-16A from TDS Traces Portal05:49
S15.13 ITR-1 Draft Preparation and Computation of tax50:52
S15.14 ITR-1 Filing – Case-1 – Taxable Income but No Tax Liability15:48
S15.15 ITR-1 Filing – Case-2 NO Taxable Income but TDS Deducted – Apply for Refund11:08
S15.16 ITR-1 Filing – Case-3 Applying for Refund by reducing Taxable Income10:49
S15.17 ITR-1 Detailed Filing with the Help of Computation01:05:01
S15.18 Income Tax Computation – as per 44AD, 44ADA non Audit – for Individuals and Firms Income from Business or Profession08:40
S15.19 Filing Form 10IEA I Opting Old Regime for Individuals having income from Business or Profession04:43
S15.20 ITR-4 Filing for Individuals I Income from Business – Presumptive Taxation10:04
S15.22 ITR-2 Filing – Capital Gains from Property Transfer20:50
S15.24 Important Notes on ITR-3 and ITR-4 Selection12:02
S15.25 ITR-3 Filing with as per Book of Accounts45:43
S15.26 ITR-3 Filing Comprehensive Case Study39:19
S15.27 ITR-4 Filing for Individuals and Firms – Presumptive Taxation Scheme10:33
S15.28 ITR-5 Filing Over view Firms, LLPs, AOI, BOI, Co-operative society, Govt Authorities42:53
S16. MS Excel
1. MS Excel – Launching – Basics of Excel Main Dashboard, Interface06:47
2 MS Excel – Cells, Rows, Columns and Sheets Basics05:51
3 MS EXCEL – Home Tab Basics – Editing and Formatting19:36
4 Copy Paste Functions – All Types05:53
5 Home Tab- Customization of Tabs04:52
6 MS Excel – Speak Cells03:44
7 Text to Columns – MS Excel Split Tool04:20
8 Characteristics of a Cell and Cell References08:35
9. Comments in MS Excel – Insert, Edit, Paste and Customize Comment Background.mp407:16
10. Fill Series – Basics – Fill Data only, Fill Format, Fill Weekdays and more02:53
11. Fill Series-Advanced – Fill Interval, Custom Lists and Fill side04:59
12. Fill Series – Flash Fill05:56
13. MS Excel-How to Hide and Unhide Rows Columns Sheets05:53
14. Freeze_Panes-Top Row Columns & Multiple Rows & Columns06:09
15. MS Excel-Filters-Learn How to Use Filter to analysis a Big Data07:31
16. MS Excel- Split Sheet Window03:12
17. MS Excel-How to Insert & Delete Cells Rows and Columns07:25
18. MS Excel-Working with Sheets06:53
19. MS Excel-View Sheets Side by Side from One Excel File04:12
20. MS Excel- Workbook Protection- Learn how to setup a Password to open Excel File03:51
21. MS Excel- sheet & cells protection05:14
22. MS Excel – Concatenate-Join Multiple Text Strings into ONE01:12
23. MS Excel-Trim_Functions- Remove unnecessary Elements from strings01:23
24. MS Excel- Print Formulas – Left Right Middle03:32
25. MS Excel – Date Related Formulas03:13
26. MS Excel-Print Page Setup Margins Size Excel to PDF08:41
27. MS Excel-Page Header & Footer Add Page Numbers Logo Report Name Date Time & more06:39
28. MS Excel – Conditional Formatting05:18
29. MS excel -import data from web05:13
30. MS Excel-import data from text document with auto refresh03:14
31. MS Excel-import-text word ppt jpeg video- pdf & more objects09:14
32. MS Excel-format multiple sheets at a time04:59
33. MS Excel – HyperLinks – Links to Sheet-File-WebPages and more.mp408:51
34. MS Excel Logical Functions Test Functions03:28
35. MS Excel IF formulas – IF – IFand – IFor – nestedIF – IFerror19:49
36. MS Excel – Student Marksheet Calculation using Sum, Nested IF, Rank, Status avg and more17:00
37. V Lookup – Exact Match and Approximate Match12:10
38. MS Excel – H Lookup03:53
39. MS Excel – X Lookup – Download and Add to your Excel03:24
40. X Look up – Basics01:06
41. MS Excel – Xlookup Formula06:22
42. MS Excel – EMI and Loan Statement Preparation – PMT PPMT IPMT14:38
43. MS Excel – DropDownList Creation – Dependent List – Independent List – Data Validation11:51
44. Data Validation – Date-List-Whole Number – Text Length-Nested If-Ifs and more24:23
45. Macro part- Designing a form05:10
46. Macro Part2 – Recording and Running a Macro14:25
47._VBA_&_Macro_Introduction01:05
48. 3D SUM – Calculate Multiple Sheet and analyze04:14
49. CONSOLIDATE – 3D SUM EXTENSION04:04
50. Age Calculator – Exclusive and Inclusive04:07
51. BAR CODE GENERATOR in MS Excel04:10
52. Charts – Pie Charts07:07
53. Charts – Bar Charts and Column Charts08:40
54. Auditing Tools – Trace Precedents-Dependent-Show Formula and more05:47
55. Statistical Formulas – Sum-Sumif-sumifs-avg-avgif-avgifs-count-countif-countifs15:33
56. INDEX03:40
57. MATCH01:44
58. PIVOT tables basics00:47
59. Create_a_PivotChart_from_Table_&_Pivot_Table01:01
60. Pivot_Table_-_Use_slicers_to_filter_data01:07
61. Sales Register Maintenance24:11
62. commission calculation06:29
63. Attendance Sheet Preparation09:36
64. Salary Calculation06:02
65. Creating Professional Invoice in Excel13:21
66. 2D Geographic Charts – Map Chart Basics03:05
67. 2D MAPS – ADVANCED08:03
68. 3D Maps – Make scenes – Export Video – Time Lapse15:25
69. 3D MAPS – State wise Product Sale03:30
S15.10 Advance Tax – Calculation and Deposit on Income Tax Portal
