About The Course
MS Excel is a highly used software for office work and it requires in the day to day professional life. It is highly necessary for an office worker to learn the Advance level excel for their personal as well as professional work. Advanced Diploma in Financial Accounting Program (ADFAP) delivers the combination complete depth knowledge of all features of Tally, E-Taxation (E-Filing) and MS Excel advance level knowledge about the tools required for the development of Excel worksheet.
This course gives you complete depth knowledge of all features of Tally. You can easily handle accounting and taxation of any types of business and also prepare MIS Reports. We took real life practical examples of all types of business transactions for better knowledge and understanding of practical real world.
Advanced Diploma in Financial accounting Program also help you to learn how to e-file income tax returns, New GST Registration, GST Return, e-TDS, PF, ESI & all Tax form Download, Fill up & Upload from, e-filing portal from the Government of India’s all Tax Department.
Course Highlights
Duration
12 Months or 124 Classes
Free Books
7 Books as Study Matireal
Examination
Online
Mode
Digital & Hard Copy
Prerequisites
Basic Computing
Detailed Syllabus
Books – 1
Chapter 01 – Basic of Accounting
Chapter 02 – Business Organizations
Chapter 03 – Accounting on Computers
Chapter 04 – Tally Fundamentals
Chapter 05 – Processing Transaction in Tally
Chapter 06 – Report Generation
Chapter 07 – GST - Fundamentals
Books – 3
Chapter 16 – GST on Service Tax
Chapter 17 – GST on Advance Receipt
Chapter 18 – GST on Service with TDS
Chapter 19 – GST on Capital Goods
Chapter 20 – GST Projects
Chapter 21 – Order Processing
Chapter 22 – Report Generation
Chapter 23 – Point of Sales (POS) on GST
Chapter 24 – List of Function Keys
Books – 5
Chapter 43 – Payroll Accounting & Compliance
Chapter 44 – Employer PF Contribution
Chapter 45 – Payment of Provident Fund
Chapter 46 – Employer ESI Contribution
Chapter 47 – Payment of Professional Tax
Chapter 48 – Tracking of Salary Advance & Loan
Chapter 49 – Pay Revision & Arrears
Chapter 50 – Point of Sales (POS) on GST
Chapter 51 – Payroll for Contract Employees
Chapter 52 – Payroll Report
Books – 2
Chapter 08 – GST with basics Rules
Chapter 09 – GST TAX rate chart
Chapter 10 – GST State Code
Chapter 11 – GST on Goods, Single Rate Tax
Chapter 12 – GST on Goods & Multi Rate Tax
Chapter 13 – GST with Transaction
Chapter 14 – GST - Fundamentals
Chapter 15 – POS on GST
Books – 4
Chapter 25 – Budget
Chapter 26 – Scenario Forecasts
Chapter 27 – Split Company Data
Chapter 28 – Import of Data
Chapter 29 – Job Work in Tally.ERP9
Chapter 30 – Composition Scheme
Chapter 31 – GST - Price Based Stock
Chapter 32 – Composite & Mixed Supply
Chapter 33 – Special Economic Zones(SEZ)
Chapter 34 – Input Service Distributor(ISD)
Chapter 35 – GST on old Stock
Chapter 36 – ITC Ineligible
Chapter 37 – E-Way Bill Rules
Chapter 38 – E-Way Bill in Tally.ERP9
Chapter 39 – Work Contract Under GST
Chapter 40 – Sale on Approval Under GST
Chapter 41 – FMCG Under GST
Chapter 42 – E-Commerce Operator in GST
Books – 6
Chapter 53 – Invoicing & Accounting
Chapter 54 – Inventory & Cost Control
Chapter 55 – Credit & Cash Flow
Chapter 56 – Taxation & Banking
Chapter 57 – Security Management & Provisions
Chapter 58 – Reports Generation
Chapter 59 – Payroll
Chapter 60 – Valuable Features
2nd Semester Syllabus :
Module-1 : Income Tax E-Filing
Introduction of Income Tax
Computation and Filing of ITR-01
Computation and E-Filing of ITR-02 (Income from House Property)
Computation and E-Filing of ITR-02 (Income from Capital Gain & Agriculture)
Computation and E-Filing of ITR-03
Computation of Presumptive
income & E Filing of ITR-04
E-Filing of Partnership Firm – ITR-05
E-Filing of Company Return – ITR-06
Online Registration for PAN
Module-2 : Tax Deducted at Source (TDS) / Tax Collected at Source (TCS)
Introduction of Taxation in India
Payment to other than Salary Return 26Q
TDS Return Form 26Q
Salary Components with Payroll
Continue next Para
TDS Return Form 24Q
Tax Collection at Sources
Payment to Non-Resident 27Q
About Traces Website
Interest & Penalty
TDS on Property & Rent
TAN ( Tax deduction & collection )
Module-3 : Goods & Services Tax (GST)
Introduction of Goods & Services Tax (GST)
Structure of GST
Invoicing in GST
Input Tax Credit & Payment in GST
GST Return Filing
Composition Scheme Under GST
Reverse Charge Mechanism (RCM)
E-Way Bill under GST
Registration under GST
Module-4
Professional Tax, ESI & PF
Tax Form Download, Fill up & Upload
2nd Semester Syllabus :
Books – 7
Chapter 01 – Introduction to Advanced Excel
Chapter 02 – Flash Fill, Data Validation & Advance Conditional Formatting
Chapter 03 – Data Table, Solver & Advanced Financial Analysis Set up
Chapter 04 – Conditional Logics, Lookups and Charts
Chapter 05 – Pivot Tables, Chart & Match Index
Chapter 06 – Functions & Formulas with Formatting
Chapter 07 – PowerPivot and Woking with other formulas
Chapter 08 – Quick Reference - Sheet & Misc. Questions with Answer
Career Opportunity
The knowledge of Tally along with E-taxation not only makes competent employees but make better professional Accountant, career options will increase a lot. In many job opportunities, knowing these two knowledge gives more benefits to the Job Seekers. This course will open the uncountable doors of career opportunity for students.
- GST Practitioner
- Accounts Manager
- Accountant
- Billing Executive
- Admin Executive
- Junior Accountant
- Tax Consultant
- Logistics Manager
- Income Tax Advisor
- Tally Operator
- Computer Operator
- Office Executive
- Accounts - Clerk
- Tax Analyst
- Inventory Manager
- Bookkeeper
- Tally Freelancers
- Accounts Executive
- Data Entry Operator
- Purchase Manager
- Accounts Assistant
- Accountant Trainee
- Support Office
- Stores In-Charge
See Our Books
