CERTIFICATE IN FINANCE ACCOUNTING & TAXATION (CFAT)


CHAPTER-I
MANUAL ACCOUNTING WITH COMPUTERIZED

  •   Fundamentals of Accountancy
  •   Maintenance of Books of Accounts
  •   Salary Register
  •   Important Transitions
  •   Voucher Preparation
  •   Daybook writing Cash book
  •   Preparation Ledger writing
  •   Journal Register
  •   Stock Register update Purchase
  •   Register Preparation Sales
  •   Register Preparation Invoice
  •   Preparation
  •   Purchase order and Sales Order
  •   Preparation Quotation preparation
  •   Fixed Asset Register Preparation
  •   Trading and Profit & Loss
  •   Account Balance Sheet preparation
  •   Rectification Entries Depreciation
  •   Entries
  •   Bank reconciliation
  •   Cheque Preparation and Deposit
  •   Slips Balance Sheet Review

CHAPTER-II
COMPUTERIZED ACCOUNTING

  • Basic of Accounting
  • Business Organizations
  • Accounting on Computers
  • Tally ERP Fundamentals
  • Creating Accounting Masters in Tally ERP
  • Creating Inventory Masters in Tally ERP
  • Voucher Entry in Tally ERP

CHAPTER-III
ADVANCED ACCOUNTING WITH TALLY ERP

  • Advanced Accounting in Tally ERP
  • Advanced Inventory in Tally ERP
  • Value Added Tax (VAT)
  • Central Sales Tax (CST)

CHAPTER-IV
ADVANCED ACCOUNTING WITH COMPUTERIZED TAXATION

  • Service Tax
  • Tax Deducted Source
  • Tax Collected Source
  • Excise for Dealers
  • Excise & Central Value Added Tax for Manufacturers

CHAPTER-V
HR Payroll Management

Provident fund and labor laws Training HR payroll accounting Management

  •  How to file for Provident Fund registration and ESI Registration
  •  How to file Provident Fund Challan cum return, ESI Challan
  •  How to file various Provident fund related registers
  •  Provident Fund Returns and various labor law formalities
  •  How to file various forms of ESI for claims
  •  Provident Fund scrutiny cases

Income Tax

  •  Tax computation Course
  •  Company Registration process
  •  Training Students how to file Income Tax Return
  •  Training Students how to file E TDS return online
  •  Permanent Account No application and its procedure
  •  E TDS and TCS return filing Practical Training
  •  E TDS software like Taxmann Income Tax return filing techniques
  •  How to compute Income Tax on Salary Income.
  •  How to prepare Form 16 online and manual
  •  How to fill up Form 49A, 49 B
  •  Preparation of Chillan 281 and 280 manual and computerized both
  •  Income Tax Assessment procedure and handling
  •  Income Tax cases
  •  Income Tax appeals and Scrutiny Cases under section 143
  •  Tax Audit procedure and laws practical training
  •  How to register company for VAT? Detail procedure and formalities
  •  How to file VAT return manual and online both
  •  VAT Assessment procedure VAT appeal procedure

Features of Visual Payroll software:

  •  Slab wise calculation on the basis of working days of selective allowances & deductions
  •  Slab wise calculation on the basis of absent on selective allowance &
  •  Deductions Define grade wise pay scale of selective allowances.
  •  Define level wise pay scale increment
  •  Define deduction calculate on selective allowance head
  •  Define unlimited no of grades/ levels/ categories
  •  Define unlimited no of qualification type/ qualification course
  •  Define performance rating parameter muster
  •  Define unlimited no of departments / designation/units/ sub units
  •  Define restricted ordinary holidays
  •  Define ERP percentage & limit for employee & employer
  •  Define FPS percentage & limit of employee & employer
  •  Define A/c No/. 02 EPF Admin Charges percentage
  •  Round off value
  •  Define a/c no 21 EDLI
  •  Define Ac/ No. 22 EPF Admin Charges
  •  Define Employee and Employer LWF account
  •  Define salary calculation days in month
  •  Define professional tax calculation
  •  Define OT calculation days in month

Employee setup and functions

  •  Define employee wise weekly off/ second weekly off
  •  Define employee wise salary type (Daily / monthly)
  •  Define employee wise employee type Direct
  •  Employee/ contract employee
  •  Define Employee wise per our OT Rate
  •  Define Employee wise Bonus % &Limit
  •  Define employee wise PF ESI rate
  •  Define educational / Technical / professional qualification and experience of employee
  •  Define family members nominee & witness detail for employee
  •  Define local address permanent address telephone no.
  •  DOJ etc for employee
  •  Link employee signature ration card voter id card thumb impression
  •  Define special remarks for employee same ESE no. validation in employee setup
  •  Help on PF no. ESE No. in employee setup

CHAPTER - IX
FINANCE

Loans & Advance

  •  Define unlimited loans for each employee
  •  Loan installment can be adjust with salary / bonus/ others
  •  Automatic deduction of loan installment against salary
  •  On line loan balance show at the tie of monthly
  •  Attendance entry
  •  Define monthly advance
  •  Define receive entry
  •  Advance/ deduction against bonus.

Arrears

  •  Define arrears for each allowance
  •  Define arrears for unlimited period for each arrears paid month
  •  Define ESI applicable for selective arrears allowance
  •  Define arrears % for EPF/ FPF/ ESI arrears wages
  •  Pay slip / Pay register can be printed with or without arrears

Attendance Entry

  •  Muster roll entry option having both daily & monthly entry provision
  •  Automatically conversion of Muster roll into monthly attendance entry
  •  Monthly attendance entry provision
  • vAt the time of attendance entry visual payroll will automatically check whether employee covered ESI or not
  •  At the time of attendance entry if employee exceeds
  •  The ESI limit still but still covered under ESI

Over Time

  •  Define over time as allowance field
  •  It can be calculated separately
  •  Define option to link over time with pay slip
  •  Define option to link over time with pay slip
  •  Define OT rates for employee working hours in company & OT hours

Leave

  •  Year wise opening can be defined for CL/ SL/ EL
  •  On line leave balance show of CL/SL/EL
  •  Automatic calculation of monthly earned leave for EL
  •  Automatic carried forward option for EL
  •  Only last year earned EL can consumed in current year option available
  •  Option of stop on Negative balance of leave & option of grace days for minus balance
  •  Holiday can be defined unit wise
  •  Option for change the salary even after automatic salary calculation

Provident fund and labor laws Training HR payroll accounting Management

  • Financial Instruments (non-fund based)
  • Cash Flow Statement
  • Fund Flow statement
  • Ratio Analysis
  • Budgeting
  • Various Analysis
  • Scenario Management
  • Export Finance (Bill Discounting)
  • Working Capital Management

CHAPTER - X
BASIC COURSE OF SHARE MARKET

Chapter-VI
TAXATION BY CAS & SOFTWARES

  •  M.P. VAT & Allied Sales Tax Act (7 SESSIONS)
  •  INCOME TAX (5 SESSIONS)
  •  Service Tax (4 sessions)
  •  Excise & Import Duty (5 sessions)
  •  Labor law (2 sessions)
  •  Company Law (6 sessions)
  •  Miscellaneous Tax & Finance (3 sessions)

Chapter-VII
OTHER USEFUL TAXATION & ACCOUNTING SOFTWARES

  •  CompuTax.( For Income Tax)
  •  CompuTds.( For Tax Deducted at Source)
  •  CompuServ( For Service Tax)
  •  CompuVat.( For State Value Added Tax)
  •  CompuBal ( For Balance Sheet )
  •  CompuRoc ( For Return Of Company's)
  •  Excise Manufacturing ( For Excise Manufacturing)
  •  Excise Trading ( For Excise Dealers)
  •  Niryat - Export Documentation (For Export Document.)
  •  Genius

CHAPTER - VIII
BANKING

  • Basics of Banking
  • Advance Banking
  • Practical working with bank

Basic of Banking

  • Banking Terminology
  • Various Banking Instruments
  • Various functions of Banks
  • Different types of Deposit & Loans
  • Mechanism for learning of banking Instruments

Advance Banking/Practical Working with Bank

  • E-banking, NEFT, RTGS, IMPS, OD & NPA
  • Mobile Banking
  • Plastic Money
  • Preparation of Stock Statements for cc Limit & Renewal of Limit
  • Security Features
  • Project Loan
  • Internet Banking
  • E commerce website and its functions
  • Online Payment of Taxes
  • Online Payment Procedures Concept of? Payment Gateways?
  • How to obtain? Payment Gateways? from Banks How to take permission from
  • CC Avenue
  • Concept of E Cheque and its implications How to receive Money
  • Online Introduction to Indian Banking
  • System Functions of Reserve Bank of India Different Types of Accounts
  • How to open and operate Savings Accounts
  • Current Account over Draft Account
  • Cash Credit Accounts
  • Procedure for Long Term Loans CMA Data
  • How to avail long Term loans
  • Procedure for evaluating Working Capital Loans Application and formality of working capital loans
  • Procedure for housing loans Educational Loans
  • Application to loan approval for SME (Small and medium Enterprises)
  • Day to day operations of Indian Banks
  • Difference between Private and Public Sector Banks

  • Investment Scenario
  • Basic of Finance & Returns
  • Basic of Capital Market,
  • Basic of Financial Market
  • Significance of Secondary Market
  • Stock Market
  • Derivates Market
  • Basic Trading
  • Live Trading on Terminal

Capital Market & Equity share trading.

  • Concept of Share Trading, Demat Account
  • Portfolio Management Service and Share
  • Investment Techniques
  • Online Portfolio Management through Bombay Stock Exchange software
  • www.bseindia.com Share market back end operations and software

CHAPTER - XI
Office Management and (MIS)

  • Meaning of MIS
  • Concept of Management System
  • Centralized Management System
  • Distributed Management System
  • Separate System Concept
  • Parallel System Concept (with finance & cost)
  • Training on Computerized Typing software
  • Letter writing skills and office correspondence course cum Training
  • Communication skills training through business English Course
  • Business English Speaking and presentation skills Course
  • Day to day business correspondence and office administration skills

CHAPTER - XII
Advance MS Excel

  • Introduction and Basic Overview
  • Working with Workbook and Worksheets Formatting Cells
  • Customized formatting of Cells
  • Cell References (Absolute, Relative & Mixed) Shortcut Keys
  • Other Features (Paste Special and finding and replacing data etc)
  • Text Formulas (CONCATENATE, UPPER, LOWER, PROPER, DATE, MOD, MODE, TODAY, NOW) Inserting Comments
  • Use of Go to Feature
  • Use of? &? To Join data in different cells Logical formula (IF function and its use) Conditional Formatting and its Use in different scenarios
  • Logical Complex Formulas (IF, OR, AND & IFERROR) Use of Nested IF formula with examples
  • Other Text Formulas (TEXT, CLEAN, TRIM, Len, T, COUNT, COUNTA, COUNTBLANK, COUNTIF, SUBTOTAL)
  • Defining Cell Range & Name Manager
  • Applying Auto filter Use of Advanced Filter
  • Displaying Unique Record by using Advanced Filter Freezing and Unfreezing Panes
  • Linking of Worksheets & Workbooks
  • Open websites, existing files etc by Inserting Hyperlink More useful formulas (RIGHT, LEFT, LEN, FIND, and SUMIF & SUMPRODUCT)
  • Formatting Financial Formulas (PMT, PV, DISC, DB, IRR, NPV etc) Text to Column to fetch data Lookup &
  • Reference cell Formulas (CELL, ADDRESS, ROW, COLUMN, LOOKUP, VLOOKUP, HLOOKUP, MATCH, OFFSET, SUMPRODUCT,

CHAPTER - XIII
Scope and Review of GST (Goods and Service Tax)

What is GST :- Goods and Service Tax indirect Tax for the whole India Overview of Goods & Service Tax, Registration under GST (Regular and Composition),Meaning & Scope ofSupply, Time of Supply, Value of Supply, Tax Rate structure, invoicing under GST regime, Input Credit Mechanism Return under GST (GSTR1,GSTR2,GSTR3 and so on), Payment of Taxes, Consequences of non –compliance and Compliance Rating, Transition to GST, Ecommerce and ISD, Audit and Appeals in GST,GSTN and GSP.

Benefits:-

  • Easy Compliance
  • Uniformity of Tax Rates
  • Improved Competitiveness
  • Gain to Manufacturers and Exporters
  • Simple & Easy Administration
  • Better Control over System
  • Higher Revenue for Government
  • Relief in overall Tax Burden
  • State level Taxes like:- Central Excise, Service Tax, VAT, octroi, Entry Tax, Purchase Tax, Luxury Tax will come to an end after GST

GST Administration:-

Both Central and State will control GST, Center will collect (CGST) and State will collect (SGST) for interstate goods movement Center will collect (IGST)

GST Registration Process:-

VAT/ Central Excise/ Service Tax payers will register with ID - GSTIN registration number based on PAN number

GST Payment:-

Electronic payment process, through net banking, RTGS/ NEFT/ Debit Card/Credit Card.

GST Returns:-

GSTR-1, GSTR-2, GSTR-3, GSTR-4, GSTR-5, GSTR-6, GSTR-7, GSTR-8, GSTR-9, GSTR-10

 

 

CERTIFICATE PROGRAMME IN COMPUTER APPLICATIONS (CPCA) - CORPORATE MICROSOFT OFFICE TRAINING (COMPLIMENTARY)


Key Information

TRUECOMMERCE has been providing basic computer course since long time and is one of the oldest computer training institute in INDORE, TRUECOMMERCE offers facility of Computer training at INDORE. This Certification Computer course is for one month (duration25 hours). This basic computer training is useful for beginners, executives, housewives and even kids who want to learn basic computers, however those who wish to become computer operator can also join this course, this is a short term job oriented practical course, every student is provided individual computer and unlimited practice hours to each student after the computer classes. TRUECOMMERCE basic computer courses have been designed with following objectives:- To make students /learners/undergraduates/graduates/housewife/ kids/anyone computer-literate to equip students/ learner with data processing and office automation skills which have become part of life in today's computerized world, anyone not knowing these basic skills can be considered as computer illiterate.


Course Highlights:

Basic Level

TRUECOMMERCE computer institute offers basic level course where student learn how to use word processing features, perform calculations, & develop powerful presentations using MS Office 2007/ 2010/2013/2016 by Certified and experienced trainers

Advanced Level

TRUECOMMERCE computer institute offers advance level course where student can learn how to do advanced data analysis & solving analytical problems using Goal seeker, Solver, macros etc Learn to design databases for small-medium business organizations, write queries & get reports using MS Access , TRUECOMMERCE offers computer courses in INDORE, this is certified course which helps you to get better job

Content:-

  •  Computers and its basic operation
  •  MS Office MSWord, MS Power Point, MS Excel , Outlook Express
  •  Email, Chat and Internet

Key Features & Benefits:-

  •  Learner becomes computer literate
  •  Structured learning Process
  •  Additional Practice sessions
  •  Learning day to day operations.
  •  Focus on practical operational knowledge of computers.
  •  Basic features of MS Windows, Word, Excel, PowerPoint and Outlook.
  •  How to using internet, email and chat

Important Features:-

  •  Lowest Fee
  •  Full Course covering every advanced topics
  •  Experienced Corporate Trainer
  •  Fully Air-condition class rooms
  •  1:1 computer training
  •  Individual attention
  •  Standard study material

Who Can Join?

  •  12th Pass student
  •  Under Graduate
  •  Graduate
  •  House wife
  •  Kids
  •  Working people
  •  Elderly people
  •  MBA ( HR)
  •  Working professionals
  •  MIS Executives
  •  MIS Personals
  •  Freelancers

Course Detail
(MS Word)

Home Menu

  •  New , open, save, save as, print settings
  •  Cut, copy, & paste
  •  Format painter
  •  theme fonts
  •  bold, italic, underline
  •  font size, strikethrough
  •  subscript, superscript
  •  clear formatting, change-case
  •  font color, text color
  •  bullets & numbering
  •  sort alphabets & numbers
  •  bullets & numbering
  •  sort alphabets & numbers
  •  paragraph alignment
  •  line spacing, shading
  •  customize border
  •  gallery of styles, change styles
  •  find, replace & select

Insert Menu

  •  Page break, blank page
  •  Table, picture, clip art
  •  Shapes, insert smart-art graphic
  •  Insert chart, hyperlink
  •  Bookmark, header, footer
  •  Page number, text box
  •  Word art, drop cap
  •  Date& time, object
  •  Symbol, autocorrect

Page layout menu

  •  theme fonts, margins
  •  page orientation, page size
  •  columns
  •  breaks, line numbers
  •  watermark, page colour, page borders
  •  indent settings, paragraph spacing
  •  object position, text wrapping
  •  endnote, footnote

Mailings

  •  mail merge, letters, labels
  •  step by step mail merge wizard
  •  select & edit recipients lists
  •  insert merge field
  •  update labels, preview results
  •  finish & merge

Review

  •  spelling & grammar, research
  •  thesaurus, word count
  •  new, edit, & delete comment
  •  track changes, accept & reject changes
  •  protect document, restrict formatting & editing
  •  View
  •  print layout, full screen
  •  web layout, outline, draft
  •  view rulers, gridlines, thumbnails
  •  zoom, one page, two pages, page width
  •  new window, arrange all, split, view side by side, synchronous scrolling
  •  6. switch windows, run macros

(MS Excel)

  •  new, open, save, save as, print settings
  •  cut, copy,& paste
  •  format painter
  •  fill color, change font face
  •  bold, italic, underline
  •  font size, strikethrough
  •  subscript, superscript, font color
  •  customize border
  •  find, replace & select
  •  cell alignment, orientation, wrap text
  •  align text, merge & center, indents
  •  number format, percent, comma style
  •  increase & decrease decimal
  •  conditional formatting, format as table
  •  cell styles, insert, delete& format cells

Insert Menu

  •  Pivot table, pivot chart, table
  •  picture, clip art, shapes, smart art
  •  column chart, hyperlink, text box
  •  header & footer, word art, object, symbol
  •  Page layout menu
  •  theme fonts, colors, fonts
  •  page margins, orientation, page size
  •  print area, page break, background
  •  page width, height & scale
  •  gridlines, headings, object selection
  •  bring to front, send to back, rotate

Formulas

  •  auto sum, average, max, min, count
  •  if, sum if, today, now, upper, lower
  •  left, right, trim, true, false
  •  ceiling, mround, round down, roundup
  •  trace precedents, trace dependents
  •  show formula, evaluate formula, watch window

Data

  •  sort, filter, text to column
  •  remove duplicates, data validation
  •  consolidate, what if analysis
  •  goal seek, scenario manager
  •  subtotal, group, ungroup

Review

  •  spelling & grammar, research
  •  thesaurus, protect workbook
  •  new, edit, & delete comment
  •  track changes, accept & reject changes
  •  protect sheet, restrict formatting & editing

View

  •  page layout, normal, full screen
  •  page break preview, custom views
  •  view rulers, gridlines, formula bars
  •  headings, zoom, new window, arrange all, freeze panes, hide, unhide, split
  •  switch windows, macros

(MS Power Point)

Home Menu

  •  new, open, save, save as, print settings
  •  2 cut, copy,& paste, format painter
  •  new slide, layout, delete
  •  bold, italic, underline
  •  font size, strikethrough, text shadow
  •  subscript, superscript
  •  clear formatting, change-case
  •  Character spacing, font color
  •  bullets & numbering, text direction
  •  paragraph alignment, align text
  •  line spacing, columns
  •  shapes, arrange, quick styles
  •  shape fill, shape outline, shape effects
  •  find, replace & select

Insert Menu

  •  table, picture, clip art, photo album
  •  shapes, smart art, chart, hyperlink
  •  action, text box, header & footer
  •  word art, date & time, slide number
  •  symbol, object, movie, sound

Design

  •  page setup, slide orientation
  •  slide design, colors, fonts, effects
  •  background styles, hide background graphics

Animation

  •  preview, animate, custom animation
  •  special effect, transition sound, transition speed

Slide Show

  •  from beginning, from current slide
  •  custom slide show, setup slide show
  •  hide slide, rehearse timings, resolution

Review

  •  spelling, research, thesaurus, translate
  •  new, edit & delete comment
  •  protect presentation

View

  •  normal, slide sorter, notes page
  •  view rulers, gridlines, slide show
  •  zoom, fit to window, color ,grayscale
  •  new window, arrange all,
  •  switch windows, formatting tools

MICROSOFT OUTLOOK

  •  Touring the Outlook Interface
  •  Using E-mail
  •  Creating Signatures & New Folders
  •  Using a Calendar & Adding Events
  •  Working with Multiple Calendars
  •  Sharing Calendars
  •  Adding & Viewing Contacts
  •  Creating, Viewing & Flagging Tasks

TYPING SKILLS

  •  Hindi Typing (20-30 Word Per Min)
  •  English Typing (20-30 Word Per Min)
  •  Typing Practice with Typing Tutor

SOCIAL, PROFESSIONAL & OFFICIAL USE OF INTERNET   

  •  Email Account and Attach Files, surfing, downloading and Uploading, Online Working Internet
  •  Online Banking
  •  Online Billing , Mobile, Electric, Travelling, Hotel, Marketing, E-Buying etc
  •  Booking, Online Payments, Online Forms Filling, Result valuation, Online
  •  Shopping, Surfing & Downloading of System Software &Tools)
  •  Voice chatting, video conferencing Face book, Twitter, Linked in, Orkut,
  •  Google+, YouTube, Rediff BOL, yahoo Messenger, Google chrome, Google Talk’s installation / Uses
  •  Online Reservation, Booking, Online Payments,
  •  Surfing & Downloading of System Software & Tools)

  CAREER PROSPECTS

  •  Computer Operator
  •  Front Office Executive
  •  Customer Support Executive
  •  Back Office Executive
  •  Back Office Operator
  •  Office Executive
  •  Office Assistant
  •  Data Entry Operator
  •  Data Support Executive
  •  Cash Counter Executive
  •  Bill Desk Executive
  •  Operation Executive
  •  Trainee in a Computer Institute
  •  Computer Trainer
  •  Application Support Executive
  •  Computer Typist
  •  Documentation Assistant
  •  Team Leader
  •  Customer Support Officer
  • AND MANY MORE……….