Finance Executive

14 Months Course

Module 1

Perfect MS- Office

Introduction to Computers, Operating System(Windows-XP,Vista,7 ),Difference between O.S. and Application Software.

MS-Word

Create simple Documents,Opening Files and Saving Text,Inserting Graphics and Pictures, Use of Tab,Use of Header & Footer,Linking and Embedding, Mail Merge(Converting Data of Records from Excel into Word for the purpose of Address Labels or directly on Envelopes),Inserting Formulae,Sorting, Explaining Various Printing Optionsin detail.

MS-Excel

Entering Data, Editing, Formatting Cells,Using various Financial Functions,Logical Functions(If,and,or etc.), Goal Seek Scenario ,Filters and Advance Filters, V-Look up ,H-Look up, Linking spreadsheets ,Split use of Multiwork Sheet, Pivot Table and Charts, MIS Reports. etc.
Power Point :Creating a Presentation,Entering and Editing Text , Using different view for Presentation, Using Clip Art and Animations.

MS Outlook

Create POP Account ,Identities for Multiple Users, Offline Support and Message Synchronisation ,Contact Pane etc.
Internet : Concept of Internet,How to create e-mail account,send mail with attachment and downloading,create account on social networking sites e.g. Facebook ,Twitteretc, online chatting, e-ticketing(how to book Railway tickets online), e-banking, Internet telephony etc) with Project Work.

Module 2

Advanced Practical Accounts & Labour Law

Accounting Fundamentals,History of Accounts, Accounting terminology, Accounting Principals ,Double Entry System  ,Schedule VI, Trial Balance, Rectification of Errors,  Depreciation, Bank Reconciliation Statement ,Stock Valuation, Ratio Analysis, Cash Flow Statement ,Accounting of Duties & Taxes, Presentation of Annual Reports ,Financial Engineering(Profit Screening),Accounting Instruments  & Documents,Preparation & Maintenance of Vouchers,Challans , Invoices,Receipts,Cash Memo,Quotations ,Purchase/Sales Order,Debit/Credit Note,Labour Laws- Employee State Insurance(ESI), Employee Provident Fund(EPF), Public Provident Fund(PPF), Bonus & Gratuity, Employment Exchange.

[Real Life Project based on actual transactions of a Company using Real Accounting Instruments & Documents.]
[to see the contents of Module 2 in detail download Brochure]

Module 3

Computerized AccountingPackage :Tally.ERP 9

Tally.ERP 9- As an Authorized Tally Partner we teach the latest version of Tally with original curriculum of Tally ( Which includes a set of 2 Books published Tally Solutions Pvt. Ltd. , Bangalore(TallyPRO Vol-1 and Vol-2)  along with the CD of Tally Software).

MODULE 3 :BASIC  TALLY.ERP 9 : How to install Tally Software , Concept of Data Path in Tally Software , Reactivating Tally If it turns to educational Mode.
Creation of Company ,Altering and Deleting the Company, Security Control and Tally Vault Password. Backup and Restore of Data. Concept of Group Companies, Splitting of Company data. Understanding Accounting, Inventory and Statutory Features(F11) ,Creating Accounting Masters(Ledgers, Groups and Voucher Types) and Inventory Masters( Stock Group, Stock Item, Unit of Measure ,Godowns ).     ACCOUNTING VOUCHER ENTRIES - Sale , Purchase, Receipt Payment, Journal, Contra),Bill Wise Details, INVENTORY VOUCHERS ENTRIES - Sale Order , Purchase Order, Indent, Stock Journal, Delivery Note, Receipt Note).Interest Calculation( Simple and Compound),Basic and Advance Printing Features ,Banking Features(Cheque Printing, Cheque Register, Bank Reconciliation ,Payment Advice, Post-Dated Summary).Export of data in Excel. PDF , JPEG, HTML or XML).

ADVANCE ; TALLY.ERP

Concept of GST (IGST, CGST, SGST and Cess), History of GST and its benefits, HSN Code(Harmonised System Nomenclature),Different Tax rates in GST, How to create different Stock items with different  GST tax rates and assign HSN codes to Stock items, Concept of Exempt, Nil rate and CESS in GST, Understanding GST Implication for COMPOSITION Dealers, Concept of Input tax Credit ,Reverse Charge, Voucher Entries with IGST , CGST and SGST implications ,Voucher Entries of Sales Return , Purchases Returns along with Credit Note and Debit Note ,How to Rectify Mismatches in Sales and Purchase Invoices,

Concept of Cost Centre/Profit Centre. Concept of JOB Order process . Voucher Types e.g. POS etc.
Order Processing, Reorder Level, Batch-wise Details, Multi Currency with Entries of Forex Gain or Loss, Creating Budget and applying Credit Limits , BOM ( Bills of Material),Backup and ,Price Level and Price Lists,TDS and TCS in Tally.ERP 9, How to pass TDS entries Payroll : Configuring Payroll in Tally.ERP 9,Creating Payroll Masters(Employee Setup,PayrollMasters,Attendance Types, Pay Heads, Gratuity, Salary Details Setup,Processing Payroll in Tally.ERP 9,Payment of Salaries(Disbursement of Salary,Accounting for Employer ESI/PF Contribution,Payment of Professional Tax,Generating Payroll Reports.

Exploring Various Reports in Tally.ERP 9 : Horizontal balance Sheet, Vertical balance Sheet ,Trial balance, Profit & Loss Account, Ratio Analysis, Day Book , Cash Book, Various Ledger Reports –Sales, Purchase, Journal, Sundry Debtors, Sundry Creditors , Stock Summary, Godown wise summary, Cash Flow and Fund Flow statement , Accounts Receivables and Payables etc.
GST Returns – How to File GSTR 1, GSTR 2A(Auto Populated at Present) , GSTR 3 B, GSTR 4 ( For Composition Dealers) , GSTR 9, 9 A , 9 B and 9 C ( Annual Returns) through Tally.ERP 9 Software( Online Filing) and Offline Filing ( Manually entering Vouchers). How to create Challan and pay taxes online on www.gst.gov.in Portal.(STUDENTS will be doing LIVE projects for filing GST returns on  www.gst.gov.in  portal and creating Tax Payment Challans .).

E-WAY BILL

What is E-Way Bill, How to Generate E-way Bill from fromwww.ewaybill.nic.in . How Fill Part A and Part B of E-way Bill ,How to generate E-way through Tally without opening E-way Bill site with Webtel Software. Penalties for non-compliance of E-Way Bill .

[to see the contents of Module 3 in detail download Brochure]

Module 4

BUSY , MARG and BOOK KEEPER Accounting Software

BUSY Accounting Software :Company Creation, Groups, Ledgers Inventory management,Accounting Vouchers, Inventory Vouchers ,Banking Features, BRS, GST Invoicing, GST Return Filing ,Generating MIS Reports ,Live Project .
MARG Accounting Package :Creation of Company, Groups, Ledgers , Inventory Management , Understanding Sales and Purchase Cycle Understanding MARG for Medicine Business . LIVE Project.

BOOK KEEPER

Understanding Book Keeper Software,Company Creation, Groups, Ledgers Inventory management, Accounting Vouchers, Inventory Vouchers ,Banking Features,To understand concept of BAR Coding, how to generate Bar codes from Book Keeper, BRS, GST Invoicing, GST Return Filing ,Generating MIS Reports ,Live Project .
Module 5, 6 & 7 comprise of e-Taxation course on WEBTEL Software

Module 5

Direct Tax(Income Tax)

ICFe teaches online Filing of various ITR  returns along with the theoretical concepts with help of WEBTEL Software .
Student will get a Login Id and Password and they will be access to Knowledge resources from our Portal.
I)INCOME TAX: Basic Concepts of Income Tax, Income from House Property , Income from Salaries, Income from Capital Gains and other Sources.Computation of Income and Tax thereon taking care of Statutory Deductions, Set off of losses, Agriculture Income ,TDS, Advance Tax, Calculation of Interest u/s 234A,234B,& 234C.
Preparation of Income Tax Returns viz. ITR 1-ITR 8,Preparation of Wealth Tax Returns in Form BA.
*e-filing of ITR 1 – ITR 8 through WEBTEL Software
TDS:
* Basic Concepts of TDS, TDS Rates, Payment of TDS,
* Preparation and Validation of e-TDS return File.
*Generation of Quarterly Return, Form 24Q, 26Q, 27EQ
* Generation of TDS/TCS, Certificate Form 16, 16A & 27D.TDS/TCS Challan
Preparation.
* Import, Export of DATA from Excel File, Text File, FVU File
***Live Project

MODULE 6

Indirect Tax (GST-Goods & Service Tax)

Introduction to GST , Indirect Taxation prior to GST,Why GST was Introduced in India,Understanding GST taxation System , Dual GST, Structure of GST.
GSTIN Structure, Business Liable to Register under GST, Mandatory Registration,Existing Registration, Mandatory Registration, Registartion under Regular Dealer and under Composition Scheme.
Supply of Goods and Services: Scope of Supply, Place of Supply,Time of Supply, Value of Supply,Interstate and Intrastate supply of Goods and Services, Mixed Supply and Composite Supply.Exempt Supply of Goods and Services,
Transition to GST : Availed Input Tax Credit, Unavailed CENVAT credit and input VAT on capital Goods.Availing the Input credit held in Closing Stock.
Invoicing :Tax Invoice, Bill of Supply ,Credit Note, Debit Note and Supplementary Invoice, Transportation of Goods without issue of invoice.
Input Credit Mechanism: Entitlement of Input Tax Credit ,Non-Entitlement of Input Tax Credit,Input Tax Credit Set Off, Input Tax Credit Claim .
GST Returns : Regular Dealer GSTR 1A, GSTR 2, GSTR3B, Composition Tax payer GSTR 4,Yearly returns 9, 9A, 9B, 9C.Input Tax Credit Set Off , Challanreconcilliation,
LIVE Project to understand GST practically.

Module 7

ROC(Registrar of Companies):

Basics of Company Law –What is Company, Types of Company-Private Limited and Public Limited,LLPetc, Memorandum of Association/ Articles of Association.
* Introduction to MCA site,Application for Name and its Approval ,Registration of Company on MCA ,Preparation of e-form 1A , 1 , 18 ,32 ,44 (Relating to Company Formation)
*Preparation of Statutory Register & Reports viz. Register of Member, Register of Directors, Allotments, Share holders , Share Transfer ,Register of Charge, Quorums, Minute Books etc.
Registration-Introduction to MCA site, Application for Name and its Approval ,Registration of Company on MCA.
Statutory Registers ,NCLT, Process of Liquidation of Company
Annual E-Filing –MGT-9,AOC-2,Directors Report,Notice for Meeting.

FORM MANAGER :

*About 100 blank forms covering Affidavits ,Bonds ,Agreements ,Gift, Income Tax, Partnership, Indemnity ,Notices & Circulars etc…
*Facility to accommodate user defined forms.
*Facilitate to automatic picking of MASTER DATA into the Forms(Like mail merge facility in MS-Word).
AIR :
*Facilitate preparation of Annual Information Return & e-filing thereof.
*Import of DATA from Text File, FVU File.

MODULE 8

BANKING

Basic functioning of Banking in India, Types of Accounts, Different types of  Loans( Loans against Property, OD facility, Loans against Salary) Payment Mechanism ,Practical knowledge about different types of Banking Instruments, Introduction to Auditing,  How to prepare Bank Audit Report ,Negotiable Instruments Act , PROJECT REPORT/CMA TOOL :
*Preparation  Project Report for Working Capital Requirement .
*Auto interest Calculation, EMI Calculation, Present Value Maturity Value Calculation
*Preparation of Cash Flow and Fund Flow Statements.

Module 9

Spoken English &PersonaityDevelopment

Basic Grammar, Sentence formation, Various kinds of Sentences, Vocabulary, Pronunciation , Idioms & Phrases ,Extempore Sessions,Communication and Conversation through Role Plays and Story Sessions, Presentation Skills, Group Discussions, Interview handling Skills, Audio & Video Sessions .
Personality Development: Leadership skills, Body Language, Attitude, Stress Management, Time Management ,Table Manners , Interview handling skills etc.

DOWNLOAD FINANCE EXECUTIVE BROCHURE (PDF)