Free Sample Videos
We allow the students to watch this section/videos without purchasing the course, so that student can understand course content, quality standards.
S1. Basics of Commerce, Accounting
S1.1 What is Commerce01:32
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:20
S1.5 Rules of Accounts with Journals10:54
S1.6 Fundamentals of Accounting12:08
S2. Download Materials
Download Materials Here00:00
S2.2 Tally Certification awareness06:02
S3. TallyPrime Basics
S3.1 Tally Overview – History, Advantages04:58
S3.2 TallyPrime – Licence Modules and Pricing04:13
S3.3 Tally Rental License Request02:18
S3.4 Download and Installation, Update TallyPrime05:53
S3.5 Launching Tally Prime – Education Mode & Activating License02:53
S3.6 Creating New Company, Alteration, Deletion and Change default data saving path10:46
S3.7 TallyPrime Pre-defined Vouchers-Introduction02:27
S3.8 Recording Purchases and sales17:07
S3.9 Recording Contra, Receipt and Payment Vouchers14:37
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 Tally Prime09:25
S3.13 Tally Data Recording Methods08:55
S4. Billing in TallyPrime with GST
S4.1 What is GST-a short Introduction to GST04:03
S4.2 GST Classifications and Place of Supply02:42
S4.4 Recording GST with Auto Billing , Exclusive GST Ledgers for Input and Output06:36
S4.5 Billing Configuration – Company Logo03:15
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:01
S4.11 Recording GST Services I Sales and Purchases of Services in TallyPrime09:03
S4.12 Recording GST Expenses Claimable and Non-claimable10:13
S4.13 Recording GST Assets – claimable and non-claimable08:36
S5: GST Filing, E-Invoice & E-waybill generations
S5.1 Understanding GST Returns & Types10:03
S5.2 GST Tax Computation and Adjustments06:20
S5.3 Learn GSTR-1 Tables10:54
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.09 E-Way Bill-Registration03:30
S5.10 E-WAYBILL Generation, Cancellation, Update and more06:56
S5.11 E Invoice Introduction02:13
S5.12 E-Invoice – GSTIN Registration of E Invoice Portal01:02
S5.13 E-Invoice Enablement for GSTIN on E Invoice Portal02:31
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, Eligibility09:00
S6. Inventory Management
S6.1 Inventory Management – Introduction, Importance, Advantages04:21
S6.2 Creation of Unit of Measurement02:32
S6.3 Stock Group – Creation and Alteration’02:51
S6.4 Stock Category – Creation and Alteration01:58
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:07
S6.9 Returning of Expired Batch Stock Item03:44
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:58
S6.15 Activation of Delivery & Receipt Notes04:36
S6.16 Activation of Debit & Credit Note01:44
S6.19 Creation of Godown01:35
S6.20 How to Create and Manage Multiple Godowns in TallyPrime05:33
S7. Bill Wise Accounts – Bills Receivable and Bills Payable 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:06
S7.6 How to view and analyze bills outstanding reports in tallyprime04:34
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:50
S8.4 An introduction to post dated cheques management06:06
S8.5 Post dated cheques management in tallyprime16:19
S8.6 Applying for TallyPrime License01:44
S8.7 Introduction to bank reconciliation process in tallyprime05:41
S8.8 Bank reconciliation in tallyprime22:03
S8.9 How To Do Auto-Bank Reconciliation04:38
S9. Miscellaneous Topics from Tally
S9.1 Calculator Usage in TallyPrime04:07
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:40
S9.6 Group Company – Creation, Alteration09:25
S.10.TallyPrime Closing
S10.1 Golden Rules of Accounts, Treatment Statements03:47
S10.2 Capital and Drawings Related Adjustments20:17
S10.3 Party Related Adjustments – Settlement Discounts, Bad debts, Reserve for Bad debts21:08
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
S.11.Tally-Case Studies & Assignment
S11.1 Tally Comprehensive-Test Paper-102:26:06
S12. Payroll Management
S10.1 What is Payroll I An Introduction02:21
S10.2 What is Basic Salary, methods of calculating basic salary08:24
S10.3 What is DA, methods of Calculating DA13:35
S10.4 What is HRA, how to Calculate HRA, Taxability and Exemption Calculation06:54
S10.5 Pay heads CA, TA, LTA I Conveyance Allowance I Travel Allowance I Leave TA06:24
S10.6 EPF I Employee Provident Fund I Calculation I Employee and Employer Contributions I Taxability20:53
S10.7 ESI I Employee State Insurance I Rules I Percentages I Contribution Period I11:22
S10.8 What is Gratuity I Calculation of Gratuity I Taxability I Ceiling Limit07:12
S10.9 Bonus Act 1965 I What is Bonus, How to Calculate, Taxability21:40
S10.10 Income Tax on Salary I TDS Computation, Cess, Surcharges, Salary Increment Cases33:43
S10.11 Professional Tax – Stat-wise I Applicability I Slabs06:12
S12.12 CTC vs Gross Salary vs Net Salary05:14
S12.13 Attendance Sheer Preparation I Present, Paid Leaves, Absents, Holidays using Countif, Countif, Sum Formulas16:31
S12.14 Complete Payroll Processing I Basic, DA, HRA, CA, TA, LTA, Bonus, PF, ESI, PT,TDS, cess, Surcharge, Gross-Net Salary01:12:39
S12.15 PaySlip Generation from Paysheet in MS Excel21:53
S12.16 TDS Deposit on Income Tax Portal14:46
S12.17 Employer Contributions PF ESI15:20
S12.18 EPF,ESI Establishment Registration30:03
S12.19 Add – Exit of Employee Records on EPFO website09:44
S12.20 EPF Returns Preparation, Filing24:46
S12.21 EPF Nil Return Filing02:36
S12.22 How to Add Employee in ESI website I generate IP Number06:10
S12.23 ESI Returns Preparation and Filing07:30
S12.24 Comprehensive Case Study – TDS ON SALARY P1- Payroll and TDS Deposits01:42:27
S12.25 Comprehensive Case Study – TDS ON SALARY P2 – TDS Returns Filing 24Q01:02:08
S.13.GST Portal Concepts
S13.1 What is GST-a short Introduction to GST04:03
S13.2 GST Classifications and Place of Supply02:42
S13.3 Understand GST Number04:28
S13.4 GST Registration Threshold Limits and Documents Required for GST Registration05:50
S13.5 GST Registration-Proprietorship and Partnership37:44
S13.6 Track Submitted Application Status02:19
S13.7 GST Registration – Filing Clarifications04:00
S13.8 GST Practitioner Registration12:17
S13.9 How to Download GST Certificate02:11
S13.10 GST Amendments- Core Fields and Non Core Fields08:23
S13.11 GST – Opting Regular or Composition06:39
S13.12 GST Cancellation and Revocation06:25
S13.13 What is GST Returns, Types of GST Returns10:03
S13.14 Learn GSTR-1 Tables10:54
S13.15 GSTR-1 Filing using TallyPrime12:33
S13.16 Filing Nil-GSTR-1 I when ther is no Sales01:37
S13.17 GSTR-1 Amendments I Modify Previous Months Invoices03:16
S13.18 Purchases Reconciliation I GSTR2A Reconciliation I 2 Methods21:54
S13.19 GSTR-3B Tax Payment I Filing GSTR-3B I Tax Summary – Adjustments07:43
S13.20 GST Composition scheme introduction, Slabs, Eligibility09:00
S13.21 GST CMP-08 Filing – Composition GST Return Filing07:17
S13.22 GST Refund- Compete Process13:48
S13.23 How to Generate E-way bill, Registration, Print, Cancellation, Masters Creation, User Creation, 3 methods25:13
S13.24 E Invoice Introduction02:13
S13.25 E-Invoice – GSTIN Registration of E Invoice Portal01:02
S13.26 E-Invoice Enablement for GSTIN on E Invoice Portal02:31
S13.27 E-Invoice – API User Creation for Your Accounting Software03:38
S13.28 Generate E-Invoice using Tally – Generate and E-Invoice ,Print within Tally using API Logins05:06
S13.29 E – Invoice Cancellation in Tally as well as E-invoice Portal02:36
S13.30 E-Invoice Generation – Tally to JSON , JSON Manual Upload on E Invoice Portal _ if API logins are not created04:09
S13.31 E-Invoice Generation Using Official Excel kit – Excel to JSON, JSON upload on E-Invoice Portal02:40
Taxation
1. What is Tax, when Taxes Introduced in India00:52
2. Direct Taxes Vs Indirect Taxes01:18
3. Income Tax Basics, Ways of collecting Income Tax09:38
4. When to File ITRs03:47
5. What is ITR, Applicability of ITRs09:17
6. What is Tax Audit, When to Tax Audit, Objectives, Forms, Due Dates, Penalties10:23
7. Income Tax Computation Format – All Type of Tax Payers27:36
8. Income Tax Computation – Individual – English10:54
9. HOW TO register PAN in Income Tax Portal05:27
10. What is Form 26AS and How to View IT04:23
Quiz-1
11. ITR-1 Filing28:10
12. ITR-4 Filing-Business and Profession25:28
13. Filing ITR-4 for Partnership Firm31:18
14. What is TDS, TDS Basics07:06
15. TDS Process Overview12:56
16. Who can deduct TDS04:18
17. How to Apply for TAN08:13
18 TDS Payment07:37
19. TDS Returns06:01
20. Recording TDS Transactions in TallyPrime26:13
Quiz-2
21. TDS on Salary09:13
22. TDS Payments12:05
23. Maintaining TDS Challan Information06:55
24. Download and Install TDS RPU-Java-Win RaR06:05
25. Download CSI File – Challan Status Inquiry Files to Import in TDS Returns Preparation Utility04:24
26. TDS Return Preparation Form 26Q29:12
27. TDS Return Preparation Form 24Q16:28
28. PAN and TAN Registration09:42
29. Submitting TDS Files-NEW03:26
30. How to View Submitted TDS and Collect Token RRR Number01:36
Quiz-3
31. What is TDS Certificate and Types02:18
32. Registration TAN on TDS Traces Portal07:56
33. TDS Return Status01:29
34. How to Download TDS Certificates Form 16Part A or B04:30
35. Download TDS Certificates-Complete Process21:56
Quiz-4
Tally.ERP9 – Full Course
1. Tally.ERP9 with GST and Excel Combo Pack Intro Video04:50
2. Tally.ERP9 Download – New Portal00:51
3 Tally – Introduction, History, Advantages03:53
4. Costing of Tally00:39
5. Tally.ERP9 Downloading, Installation & Activation03:57
6. Golden Rules of Accounts10:54
7. Tally.ERP9 with GST – Course Material00:03
8. Company – Creation, Alteration, Deletion & Securing16:08
9. Understanding Tally Pre- defined Vouchers08:43
10. Tally Data Processing Structure11:08
11. Understanding Tally with Basic Illustrations17:54
12. Recording & Maintaining Installments in Tally.ERP9 I Bill-wise accounts24:26
13. Recording & Maintaining Supply against Advances- Advances Management15:23
14. Tracking OverDue Supply – Credit Sales05:45
15. Multi – Currency Accounting in Tally.ERP9 & Adjustment Entries of Forex Gain & Loss17:20
16. Cheque Book Configuration in Tally.ERP913:40
17. Banking – Transaction Types ATM, Credit & Debit Cards, Online Banking & more05:39
18. Post Dated Cheques Management in Tally.ERP9 I PDC’s29:32
19. Bank-Reconciliation-Introduction-Theory06:32
20. Bank-Reconciliation-in-Tally.ERP9-I-Practical-CaseStudy140:39
24. Enabling GST Features in Tally.ERP909:11
25. Recording GST Transactions in Tally.ERP9 I SMART method25:57
26.Recording-GST-Transaction Traditional-Method14:26
27. Recording GST Transactions – CaseStudy217:54
28. GST Tax Invoice Configuration – Voucher Numbering04:58
29. Recording GST Transaction with Auto Billing07:52
30. GST Tax Invoice, Bank Details, Customer Seal Signature, Jurisdiction – Printing Configuration16:49
31. Rate Inclusive of Tax Item Description in Tally.ERP905:26
32. Recording GST Transactions – Services06:16
33. Recording GST Transactions – Assets I with Input Tax Credit I without ITC06:51
34. Recording GST Transactions – Expenses with & without Input Tax Credit06:07
35. Recording GST Transactions – Sales with Additional Expenditure05:02
37. GST- Recording RCM in Tally.ERP931:20
56. Purchase Returns & Sales Returns in Tally.ERP911:46
57. Delivery Notes & Receipt Notes in Tally.ERP914:08
58. Sales Orders Quotations in Tally.ERP906:39
59. Tally.ERP9 Discounts I Trade Discounts & Cash Discounts14:16
60. PriceList’s in Tally.ERP9 I Party Level & Product Level08:39
61. Auto-Interest Calculation on Overdue Installments40:02
62. Basic of Manufacturing07:59
63. Standard Manufacturing Practicals in Tally.ERP941:55
64. Cost Centres in Tally.ERP9 (Departments Handling)14:55
65. Branch-Wise Accounts-Using Cost Centers & Godowns in Tally.ERP937:46
70. Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split23:21
71. Payroll – in Tally.ERP9 Introduction to Steps04:34
72. Payroll-Complete Setup Monthly Process & Stop Computation – Overall Coverage35:34
73. Budgets in Tally.ERP910:15
74. Calculator Usage in Tally.ERP903:11
75. Tally Data Backup & Restore19:17
76. Alternate Units of Measurement in Tally.ERP904:02
77. Batches Management (with Date of Manufacturing & Expiry )07:37
78. Data Searching in Tally.ERP906:22
79. Day Book Features in Tally.ERP913:35
80. POS in Tally.ERP905:49
81. Splitting in Tally.ERP906:58
82. Part Numbers in Tally.ERP903:59
83. Standard Rate Setup in Tally.ERP903:59
84. Zero Valued Transaction02:13
85. Exports I Tally to JPEG, PDF, HTML, XML05:43
86. Data Export & Import in Tally.ERP911:40
87. Live Mailing from Tally.ERP917:24
MS Excel Full Course- Basics to Advanced
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 Background07:16
10. Fill Series – Basics – Fill Data only, Fill Format, Fill Weekdays and more02:54
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:54
14. Freeze_Panes-Top Row Columns & Multiple Rows & Columns06:10
15. MS Excel-Filters-Learn How to Use Filter to analysis a Big Data07:32
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:54
19. MSExcel-View Sheets Side by Side from One Excel File04:13
20. MS Excel- Workbook Protection- Learn how to setup a Password to open Excel File03:52
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:14
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 time05:00
33. MS Excel – HyperLinks – Links to Sheet-File-WebPages and more08:51
34. MS Excel Logical Functions Test Functions03:29
35. MS Excel IF formulas – IF – IFand – IFor – nestedIF – IFerror19:50
36. MS Excel – Student Marksheet Calculation using Sum, Nested IF, Rank, Status avg and more17:00
37. V Lookup – Exact Match and Approximate Match12:11
38. MS Excel – H Lookup03:54
39. MS Excel – X Lookup – Download and Add to your Excel03:25
40. X Look up – Basics01:06
41. MS Excel – Xlookup Formula06:22
42. MS Excel – EMI and Loan Statement Preparation – PMT PPMT IPMT14:39
43. MS Excel – DropDownList Creation – Dependent List – Independent List – Data Validation11:51
44. Data Validation – Date-List-Whole Number – Text Lentgh-Nested If-Ifs and more24:23
45. Macro part- Designing a form05:11
46. Macro Part2 – Recording and Running a Macro14:25
47._VBA_&_Macro_Introduction01:06
48. 3D SUM – Calculate Multiple Sheet and analyze04:15
49. CONSOLIDATE – 3D SUM EXTENSION04:05
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:41
54. Auditing Tools – Trace Precedents-Dependent-Show Formula and more05:48
55. Statistical Formulas – Sum-Sumif-sumifs-avg-avgif-avgifs-count-countif-countifs15:34
56. INDEX03:40
57. MATCH01:45
58. PIVOT tABLES bASICS00:48
59. Create_a_PivotChart_from_Table_&_Pivot_Table01:02
60. Pivot_Table_-_Use_slicers_to_filter_data01:08
61. Sales Register Maintenance24:11
62mission calculation06:29
63. Attendance Sheet Preparation09:37
64. Salary Calculation06:02
65. Creating_Professional_Invoice_in_Excel13:21
TallyPrime-Downloading & Installation
