Affordable Course Fees + Best Education = CIT

Professional Tax Consultant
Course
in Kolkata

One of the Best Accounts & Taxation training in kolkata for all of you

Low Course Fees | Life Time Support | Real Life Case Studies | 100% Job & Income Opportunity

Book Your Seat Now for Professional Tax Consultant Course in Kolkata. To Book Call : 9614142256 or Apply Online

Professional Tax Consultant Career Course

We Provide Professional Tax Consultant Career Course Fees for all

Affordable Course Fees + Best Education = CIT

2 Years

Course Duration

10+2 (pass)

Course Eligibility

4 Modules

Course Module

Online Support

Book, Videos & Lifetime Support

Why Should You Choose Career Professional Tax Consultant ?

Professional Tax Consultant Course is a great things which can help you to achieve your career goal or a business goal.

Professional Tax Consultant course helps in office work. Professional Tax Consultant course also enables the Professionals to be more efficient. The advance features taught in this course is an office environment with maximum efficiency.

In this path you can build your own career in a good way (job or freelancing for both)

Tally Accounts Course
CIT

Why CIT is the Best Option for your Education ?

Being A Training Institute In Kolkata, We Offered Best Quality Education & Support, So That Everyone Can Grow And Achieve Their Goals Easily.

10+ Years of Experience

Updated, Experienced & Professional Teachers

7 Days Opened with Flexible Class Timing

Live Projects & Workshop Facilities

Lifetime Support & Hand holding

Affordable Course Fees + Best Education = CIT

100% Income Opportunity | 100% Job Guaranteed

!! Book Now !! Course Fees = Rs. 9,000/- (per module)

Course Module of Career Professional Tax Consultant Course:

Our Professional Tax Consultant Career Course Curriculum or Course Module is designed for all category of students, business man, Accountant and any other persons who wants to learn that.

Professional Tax Consultant Career Course Age Limit 18 - 30 years.

Course Details :

  • Journal
  • Advance Journal
  • Ledger
  • Trial Balance
  • Rectification Entry
  • Final Account
  • Trading Account
  • Profit & Loss
  • Account
  • Balance Sheet
  • Adjustment Entry in Advance
  • Bill wise Debtors and Creditors Ledger
  • Company Creation & Management
  • Payment Voucher
  • Receipt Voucher
  • Contra Voucher
  • Journal Voucher
  • Day Book in Tally
  • Pre-Allocation of Bills
  • Contra and Journal Voucher
  • Cash and Bank Reports
  • Inventory
  • Stock Item
  • Unit Creation
  • Stock Group
  • Stock Management
  • Physical Stock Management
  • Stock Analysis and Reports
  • Purchase Order Processing
  • Sales Order Processing
  • Billing Features in Tally
  • Debit and Credit Notes
  • Price List in Tally
  • Return Entry in Tally
  • Introduction to GST Structure
  • CGST, SGST, IGST, UGST
  • Purchase Voucher with GST
  • Sales Voucher with GST
  • Single Rate of GST
  • Multi Rate of GST
  • GST Product Types
  • Cess on GST
  • GST on Service Concern
  • NON GST Product Calculation
  • Capital Goods on GST
  • GST BILL Returns and Payment
  • Purchase and Sales Reporting
  • Types of GST Calculation
  • GST Adjustment
  • RCM on GST
  • Registration
  • GST Returns
  • Dealer
  • CGST, SGST, IGST, UGST
  • GST State Code
  • HSN/SAC Code
  • GST Rate Comparison
  • Claiming ITC
  • Creation of GST Bills
  • Payment of GST (Online)
  • How Handle mismatch with GST
  • Refund GST
  • Electronic Credit Ledger in GST
  • Creation of GST Bills
  • Payment of GST (Online)
  • Refund GST
  • Electronic Credit Ledger in GST
  • Amendment GST.
  • GSTR 1,2A, 2B, 3B,9
  • GST RETURN FOR COMPOSITE DEALER
  • Create Challan
  • Profile Setting
  • Change user ID Password
  • Adjustment GST
  • Word
  • Excel
  • Power Point
  • Access
  • COMPUTATION OF INCOME TAX
  • Introduction of Income Tax
  • Tax Structure in india
  • Nature of basic features of income tax
  • Brief history of income tax
  • Income tax is one tax
  • Objective of tax planning
  • Method of tax plan
  • Scope of tax planning
  • Assessee Person
  • Assessment Year
  • Previous Year
  • Heads of income
  • Heads of income and sources of income – distinction
  • Total income how to compute
  • Tax liability – how to determine
  • Basic considerations
  • Residential status of an individual /HUF
  • Income from salary/Pension
  • Employee Category
  • Allowance
  • Perquisite
  • Profit ilue Salary
  • Salary of partnership firm
  • Gratuity
  • Pension
  • Leave Salary
  • Bonus
  • Fees & commission
  • Computation and Filing of ITR-01
  • Assessment salary/pension person
  • Old Tax regime
  • New Tax Regime
  • Job Change in Financial Year
  • TDS Refund
  • Income From House Property
  • House Property Own
  • House Property Let Out
  • Unrealised Rent
  • Interest on Loan
  • Property income From leasing and Subleasing
  • Income From House Property outside India
  • House Property exempt from Tax
  • Negative adjusted annual value
  • Loss From House Property
  • Computation and Filing of ITR-01
  • Assessment salary/pension person
  • Old Tax regime
  • New Tax Regime
  • Job Change in Financial Year
  • Income From House Property
  • Income From Other Source
  • Deduction on Chapter VI
  • Capital Gain
  • Conversion of capital assets into stock -in -trade
  • Tax on long term capital gains calculation
  • Tax on short term capital gain calculation
  • Treatment of short term and long term capital loss
  • Repurchase of the unit of Mutual Fund
  • Computation and E Filing of ITR-02
  • Assessment salary/pension person
  • Old Tax regime
  • New Tax Regime
  • Job Change in Financial Year
  • Income From House Property
  • Income From Other Source
  • Deduction on Chapter VI
  • Capital gains
    Agriculture Income
  • Income Form Business Or Profession (Module I)
  • Trading Account
  • Profit & Loss Account
  • Balance Sheet
  • Adjustment Entry in Advance
  • Bill wise Debtors and Creditors Ledger
  • Assessment of businessman
  • Computation & E Filing of ITR-03 ,ITR -04
  • E Filing of Partnership Firm : ITR-05
  • E Filing of Companies Return : ITR-06
  • E Filling of NGO : ITR 07
  • Log in
  • Registration
  • TDS/ TCS
  • STATUS
  • E- PAYMENT
  • REFUND
  • ROC Basic
  • PAN VERIFICATION
  • PASSWORD PROBLEM AND SOLUTION
  • P.F. & E.S.I. Basic
  • BUSINESS CODE
  • SUBMISSION
  • Online Registration for PAN
  • M/S Office
  • Word
  • Excel
  • Power Point
  • Access
  • Final Account For Manufacturing Concern
  • Cost Sheet
  • Trading Account
  • Profit & Loss Account
  • Balance Sheet
  • Final Account for Partnership Firm
  • Trading Account
  • Profit & Loss Account
  • Profit & Loss Appropriation
  • Balance Sheet
  • Final Account For NGO
  • Receipt & payment Account
  • Income & Expenditure Account
  • Balance Sheet
  • Company Final Account
  • Multiple Ledger Creation
  • Cheque Printing in Tally ERP
  • Purchase Order
  • Sales Order
  • Bank Reconciliation in Tally
  • Price List in Tally
  • Wholesale
  • Retail
  • Dealer Distributor Commission
  • Trade Discount
  • Cash Discount
  • Special Discount
  • Credit Limit
  • Stock Transfers
  • Manufacturing Vouchers
  • Batch Wise Details
  • Reorder Level in Tally
  • Interest Calculations (Auto Mode)
  • Voucher Types and Class
  • Point of Sales (POS)
  • Scenarios and Optional Vouchers
  • Budgets and Controls in Tally
  • Cost Centres and Cost Categories
  • Party Ledger Analysis
  • Purchase and Sales Reporting
  • Stock Analysis and Reports
  • Cash and Bank Reports
  • Search, Filter and Sorting
  • Financial Reports
  • Multi Language
  • Backup and Restore
  • Finalisation Entries
  • Data Security
  • Data Synchronisation
  • Multi-Currency
  • Printing Reports
  • Basic of Banking
  • Zero Valued Entries
  • Free Sample Product
  • BOM
  • Tally.Net
  • Password Policy
  • Shortcut Keys
  • E WAY BILL
  • JOB COSTING RULES IN GST
  • How Handle mismatch with GSt
  • Refund GST
  • Change Regular to Composite Dealer in GST Portal
  • Amendment ON GST
  • GST other Country
  • GST on Non Resident Foregin Taxpayer
  • GST on Input Service Distributors
  • GST On Individual TDS Deductor
  • GST On E- commerce Operator
  • GST On SEZ Supplies
  • SEZ GST Refund
  • GST on FMCG
  • Reverse Charge Mechanism(RCM)
  • Goods Transport Agency (GTA)
  • Ineligible ITC
  • GSTR 5 – 11
  • Export File In GST
  • Import File in GST
  • Refund Claim In Export File
  • Concept OF TDS & TCS
  • TDS Accounting
  • TDS Entry in Tally
  • TDS on Salary
  • TDS on Other Than Salary
  • Advance Payment on TDS
  • TDS on Payer
  • TDS on Payee
  • TDS Tax Slab
  • Laws for Export Contracts
  • Types of legal issues in International Marketing
  • Export Agency Agreement
  • Laws relating to products
  • Letter of Understanding (LUT)/Bond
  • Laws relating to Letters of Credit
  • International Commercial terms (INCO)
  • Accounting of Multi Currency
  • International Tax Law in Export
  • GST Law In Export & Import
  • Payroll Accounting & Compliance
  • Employer PF & ESI Contribution
  • Payment of Provident Fund
  • TDS on Payroll
  • Payment of Professional Tax
  • Tracking of Salary Advance & Loan
  • Pay Revision & Arrears
  • Payroll for Contract Employees
  • Payroll Report
  • Function of RBI
    Banking Abbreviations
  • Banking Regulation Act 1949
  • Policy Rates
  • Types of Accounts
  • NEGOTIABLE INSTRUMENTS ACT 1881
  • BANKING OMBUDSMAN SCHEME 2006
  • FINANCIAL INCLUSION
  • PRIORITY SECTOR LENDING
  • MONEY MARKET INSTRUMENTS
  • Capital Market
  • Digital Mudra
  • E- Payment
  • BRS
  • Company audit
  • Verification of Assets and Liabilities
  • Appointment of auditor
  • Auditor’s report
  • Internal Check and Test Checking
  • Internal Control and Audit Procedure
  • working papers and evidence
  • Tally Audit Feature
  • M/S Office
  • Word
  • Excel
  • Power Point
  • Access
  • Intro Excel
  • Navigation and basic spreadsheet concepts
  • Auto Complete Option
  • Custom List & Fill Series
  • Different methods of selecting Range
  • Shortcuts Key
  • Special Formats – Numbers & Dates
  • Different File Format (XLS, XLSX, XLSM,PDF)
  • Sum, Average, Max,Min, Count, Counta
  • Absolute, Mixed and Relative Referencing
  • Change worksheet tab color
  • Rename a worksheet
  • Change worksheet order
  • Insert and delete columns or rows
  • Change workbook themes
  • Adjust row height and column width
  • Insert headers and footers
  • Hide or unhide worksheets
  • Hide or unhide columns and rows
  • Customize the Quick Access toolbar
  • Modify document properties
  • Display formulas
  • Formatting Cells with Number formats,
  • Font formats
  • Alignment
  • Borders etc
  • Setting Up Print Area
  • Customizing Headers & Footers
  • Designing the structure of a template
  • Print Titles –Repeat Rows / Columns
  • Customizing the Ribbon
  • Using and Customizing AutoCorrect
  • Changing Excel’s Default Options
  • Insert, Delete & Rename Sheets
  • Copy and Move Sheets
  • Worksheet Groups
  • Using the Clipboard Group
  • Using Paste Special
  • Basic IF statement
  • Nested IF statements
  • Combining IF with AND, OR, NOT
  • IFERROR
  • Count, Counta, Countblank
  • Countif, Sumif, Averageif
  • Countifs, Sumifs, Averageifs
  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len, Exact
  • Concatenate
  • Find, Substitute
  • Today, Now
  • Day, Month, Year
  • Date, Date if, DateAdd
  • EOMonth, Weekday
  • Filtering on Text, Numbers & Colors
  • Sorting Options
  • Advanced Filters on 15-20 different criteria(s)
  • Various Charts – Bar Charts / Pie Charts / Line Charts
  • Combo Chart – Columns & Line
  • Using SLICERS, Filter data with Slicers
  • Manage Primary and Secondary Axis
  • Create & modify charts
  • Different Chart Types
  • Adding data to existing chart
  • Secondary Axis Chart
  • Vlookup / HLookup
  • VLOOKUP – Approximate Match
  • VLOOKUP – Exact Match
  • VLOOKUP – Match
  • VLOOKUP – & Indirect
  • Index and Match
  • Creating Smooth User Interface Using Lookup
  • Nested VLookup
  • Reverse Lookup using Choose Function
  • Worksheet linking using Indirect
  • Vlookup with Helper Column
  • PivotTable layout
  • Rearranging data
  • Filtering a report
  • Adding fields
  • Field settings
  • Refreshing data
  • Formatting a PivotTable
  • Showing detail
  • Create a calculated field
  • Advanced data field settings
  • Creating a PivotChart
  • Creating PivotChart Reports from scratch
  • Adding fields to a PivotChart
  • What are the Array Formulas, Use of the Array Formulas?
  • Basic Examples of Arrays (Using ctrl+shift+enter).
  • Array with if, len and mid functions formulas.
  • Array with Lookup functions.
  • Advanced Use of formulas with Array
  • Custom & Multiple Sort
  • Subtotals
  • Advanced Filtering
  • Create automatic Subtotals
  • Text to Columns
  • Use the Group and Outline feature
  • Number, Date & Time Validation
  • Text and List Validation
  • Custom validations based on formula for a cell
  • Dynamic Dropdown List Creation using Data Validation – Dependency List
  • Limiting the range of values
  • Drop down lists
  • Error alerts
  • Goal Seek
  • Scenario Analysis
  • Data Tables (PMT Function)
  • Solver Tool
  • Data Table
  • Tracing precedent & dependants
  • Display/Hide formulas
  • Error Checking
  • Evaluate Formulas
  • Fixing Formulas Errors
  • Highlight & Remove Duplicate
  • Compare Reports
  • Converting Text to Number/Date
  • Find & Replace
  • Go To (Special) Options
  • Slicer
  • Spark Lines
  • Protecting cells/Range
  • Hide Formulas
  • Protecting Worksheet
  • Protecting Workbook

Introduction to MySQL. Installation of MySQL server.
Writing Basic SQL

Topics:

  • Basic SELECT Statement
  • Selecting All Columns
  • Selecting Specific Columns
  • Writing SQL Statements
  • Column Heading Defaults
  • Arithmetic Expressions
  • Using Arithmetic Operators
  • Defning a Null
  • Defning a Column Alias
  • Duplicate Rows
  • Eliminating Duplicate Rows
  • Delete database
  • Manage Database
  • What is VBA or Macros?
  • What it can be used for
  • Activate the Developer Tab
  • Macro Security Settings
  • Naming & Recording a simple Macro
  • Recording using Relative & Absolute References
  • Editing a Recorded Macro in the VBA Editor
  • Saving the File as Macro Enabled Workbook
  • Running a Macro using a Toolbar
  • Assigning a Macro to a Button or Drawn Object on a Sheet
  • Assigning a Macro to a Quick Access Toolbar
  • Creating a Short-Cut Key to Run a Macro
  • Opening and Closing the VBA Editor
  • Using the Project Explorer
  • Inserting a Module
  • Working with the Properties and Code Windows
  • Module, Procedures, Functions
  • Object, Property, Methods
  • Application, Workbook, Worksheet, Range
  • Creating a Sub Routine
  • Understanding the code structure
  • Commenting Statements
  • Calling procedures
  • Creating an Interactive Message Box
  • Creating a Custom Input Box
  • Advantage of Application.Inputbox
  • Simple IF (IF…THEN)
  • IF Else (IF…THEN…ELSE)
  • IF & Logical Operators (IF AND/OR…THEN)
  • Nested IF (IF…THEN…ELSEIF)
  • SELECT CASE
  • CASE ELSE
  • Declaring a Variable’s Data Type
  • Working with Object Variables
  • Option Explicit
  • Constants
  • For Loop (FOR…NEXT)
  • For Each Loop (FOR EACH…NEXT)
  • Do Until Loop (DO UNTIL…LOOP)
  • Do While Loop (DO WHILE…LOOP)
  • Referring to a Range
  • Entering Values and Formulas
  • Formatting Cells and Values
  • With…Statement
    Using
  • CurrentRegion Property
  • Accessing a range using UsedRange Property
  • The End Property
  • Offset
  • Select Special Cells
  • Sort & Filter
  • Rows and Columns (Insert/Delete/Autofit/Hide)
  • Activate Worksheet
  • Add/Delete/Rename a Worksheet
  • Copy/Move a Worksheet
  • Working with Group Worksheets
  • Hide/ Protect Worksheets
  • Open/Close Workbook
  • Save/Protect Workbook
  • This Workbook
  • Screen updating/ Display Alerts
  • Cut copy Mode/ Username/ Speech
  • Using Excel Worksheet Functions in VBA
  • VBA Function
  • Creating User-Define Functions
  • Using Range and declaring variables in User defined functions
  • Creating a custom form
  • Adding text boxes to forms
  • Moving controls
  • Adding label controls to forms
  • Changing text box and label properties
  • Combo box, option, command
  • Sequences of Events
  • Events Associated with Worksheets
  • Events Associated with a Workbook
  • Understanding different Error Types
  • Debugging: Stepping through Code and Breakpoint
  • On Error Goto Statement
  • Resume Next Syntax
  • ApplyIng TAN
  • TDS on other than Salary
  • TDS Return Form 26Q
  • TDS on Salary Person
  • TDS Return Form 24Q
  • Tax Collection at Sources
  • Payment to Non-Resident 27Q
  • About Traces Website
  • Interest & Penalty
  • TDS Certificate
  • Form 16
  • Form 16A
  • Capital Markets
  • Fundamental Analysis
  • Derivatives
  • Technical Analysis
  • Financial Planning
  • Market
  • Consumer
  • GDP
  • Global Policy
  • Unemployment
  • Inflation
  • Global Trade
  • Live Project on GST
  • Live Project on Income Tax
  • Live Project on TDS
  • Live Project on Stock Market
  • Live Project on Company Final Account

Extra Course Features by CIT:

Course Materials:  Students Will Get Course Documents, Books, E-boks & Online Support.

Course Rating :

Ratings : 5 star
5/5

Student Progress:

Skill Developed 85%
Jobs 65%
Freelancing 78%
StartUp 92%

Course Enrollment :

In-Class Timing

Flexibilities :

  • Extra classes in case you miss few classes
  • Doubt Clarence classes
  • Practicals & assessments
  • Job and interview scheduling

Book Your Seat Now !!