dots bg

Advance Diploma in Financial Accounting & Taxation

Accounting, Finance & Taxation are the field in which there will never be recession, this is an ever-growing field to make career as professional. Every organization small or big irrespective of number of employees and individual business man need professionals of accounts, finance and taxation.

 

₹70000.00 ₹114900.00 39% OFF

To purchase this course, please contact the admin
Contact Admin
dots bg

What You’ll Learn

  • Fundamental Introduction
  • Entering and editing worksheet data
  • Essential worksheet Operations
  • Working with Cell and Ranges
  • Introduction of Table
  • Introduction of Formulas and Functions
  • Worksheet Formatting
  • Workbook Operations
  • Designing Excel
  • Templates
  • Printing Work
  • Basic Functions of excel
  • Working with data
  • Data Formatting

  • Customisation of software
  • Functions of excel
  • LEN, UPPER, LOWER, PROPER
  • List Sort & Filter
  • Multi- Level of Sorting
  • Creating Formulas that Manipulate Text
  • Creating formulas that lookup values
  • MIS with Pivots Tables
  • MIS with Xlookup Function
  • Types of Charts
  • Conditional Formatting
  • Special Paste content
  • Protect Workbook
  • MIS Structure
  • Use of Data Validation
  • Dashboard

  • Formulas for Financial Application
  • Performing spreadsheet what-if analysis
  • Count and sum Functions
  • Macro
  • Using Data Validation
  • Using Excel in a workgroup
  • Analysing data with pivot table
  • Making Worksheet error free
  • Dashboard in Excel
  • Share
  • Formulas and Functions
  • Logical Functions
  • Date & Time Functions
  • Text Functions
  • Statistical Functions
  • Round Function

  • About Tally Software
  • Basics of Tally
  • Accounting Masters creation
  • Accounting Entries
  • Inventory Management
  • Purchase process
  • Sales Process
  • Banking
  • Accounting with Services
  • Data Maintenance & Exchange
  • Reports Working
  • Tax Deducted at Source
  • Depreciation
  • Additional Concepts Under tally

  • Implementation GST for Company
  • GST Concepts under Tally
  • Types of Goods & services under GST
  • Types of Purchase under GST
  • Reverse charge mechanism (RCM)
  • Record of sales under GST
  • TDS With GST
  • GST Payment to Government
  • Record GST For Goods
  • Record GST For Services
  • GST Reports
  • Bad Debt
  • GST Challan Updating
  • Depreciation
  • Provision
  • Advance Depreciation
  • E-Way Bill

  • Godown Summery
  • GST Advance Receipt
  • GST For Composition Dealer
  • Import
  • Export
  • Transportation Services
  • GST Adjustment
  • GST For ineligible ITC goods & Services
  • HSN/ SAC Summery for GSTR1
  • TDS Report
  • Important Reports Work
  • Payroll Accounting
  • Tally Vault
  • Tally Audit

  • Individual GST Briefing
  • Goods and services Tax Network (GSTN)
  • Basic concept
  • GST Registration
  • Tax Invoice
  • Levies and Tax Applicability
  • Input Tax Credit
    • Avail ITC Block ITC
  • GST Portal Login
  • Eway Bill
  • HSN Code
  • GSTR – 1
  • GSTR - 2A
  • GSTR - 2B
  • GSTR - 3B
  • GSTR - 4
  • GSTR - 5
  • GSTR - 6
  • GSTR - 7
  • GSTR - 8
  • GSTR - 9
  • GSTR - 9C
  • GSTR - 10
  • GSTR - 11
  • Import and Export
  • Tax Management
  • GST Offline tools
  • Many More…

Income Tax Act Basic
  • Introduction of Income Tax
  • Basic Concepts and Definitions
  • Capital and Revenue Receipts
  • Basis of Charge and Scope of Total Income
  • Residential Status and Incidence of Tax
Income Tax E-filing
  • Online Registration of PAN
  • Computation and Filing of ITR01
  • Computation and Filing of ITR02 (Income from House Property)
  • Computation and Filing of ITR02 (Income from Capital Gain and Agriculture)
  • Computation and Filing of ITR03
  • Computation and Presumptive Income and Filing of ITR04
  • Computation and Partnership Firm and Filing of ITR05
  • Computation and Companies Return and Filing of ITR06
Tax Management, Administrative Procedure
  • Introduction of Taxation India
  • Payment of Other than Salary Return 26Q
  • TDS Return from 26Q
  • Salary Component with Payroll
  • TDS Return Form 24Q
  • Tax Collection at Source
  • Payment to Non-Resident 27Q
  • Interest & Penalty
  • TDS on Property and Rent
  • Tan (Tax Collection and Deduction Number)
  • Advance Payment of Tax, TDS/TCS and Interest and Penalties
    • Payroll & Income Tax
  • Payroll Accounting and Compliance
  • Processing and Accounting Employees and Employers PF Contribution
  • Accounting Employees and Employers ESI Contribution
  • Process of Employees and Employers ESI Contribution
  • Professional Tax
  • Employee Pay head Breakup
  • Retirement Benefit of Gratuity
  • Pension Scheme
  • Leave Salary Encashment
  • Retrenchment Compensation
  • Compensation Received At the Time of Voluntary Retirement
  • Insurance Premium Payable by Employer
  • Employee’s Contribution towards Staff Welfare Scheme