computerclasses

E-Accounting

E-Accounting Professional Course

BASICS OF COMPUTER

  • Computer Fundamentals- Introduction to Computer, Hardware, Software, Operating system, Interaction with windows creating files and folders, Printing and scanning document
  • MS word- Create, Edit and Format Document, Inserting header & Footer, Graphics and Images, Table, Spelling and Grammar check, Mail Merge & Protecting document
  • MS Excel- Creating Spreadsheets, working with database, calculation using Formula, creating Graphs and Reports, Sheet Protections
  • MS PowerPoint- Creating Presentation using Slides, Inserting Graphics, Animations, Sound, Video, add Masters Slides etc.
  • Internet- Surfing Web, Creating Email ID, sending and receiving mail & attachments, uploading and downloading files, ticket booking etc.
  • Typing skills

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, 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

BASIC OF ACCOUNTING

Accounting is a procedure to document, categorize, summarize, interpret and communicate the financial information about a business. No matter what company, field, industry or sector one belongs, the process of accounting is a mainstay to manage a business productively.The course in basic accounting will introduce you to the cardinal terms like debit, credit, balance sheets, taxes and financial reports, giving you an overview of managing accounts electronically with “e-accounting”

ACCOUNTING PRINCIPLES

  • Introduction to Accounting, uses and application
  • Accounting Terms – Expense, Income, Assets and Liabilities
  • Accounting Principles and Conventions
  • Concept of Debit & Credit
  • Golden & Modern Rule of Debit and credit

ACCOUNTING ENTRIES

  • Recording transaction in Journal
  • Entry for outstanding expense and accrued income
  • Depreciation
  • Bad debts
  • Accounting for Income Tax
  • Adjustment entries
  • Reserve and provision
  • Posting of transactions in Ledger book

REPORTING

  • Ledger posting
  • Casting and balancing
  • Different accounting books
  • Making Trial Balance
  • Making financial Reports – Profit & Loss, Balance Sheet
  • Ratio analysis

BASICS OF MATHEMATICS

Basic Mathematics is manifest in everything around us. Whether you are preparing a recipe at home, or planning a budget, calculating incentives earned over a month or assessing the feasibility in making an investment, Mathematics helps us reach logical conclusions.

Reappraising the basic skills like addition, subtraction, multiplication, division, our course in basic Mathematics will help you gain insight in applying Mathematics in daily use, helping you make approximations and estimations and compute fractions and whole numbers.

  • Addition, Subtraction, Multiply and Divide
  • Profit and loss
  • Percentage
  • Ratio
  • Simple Interest and Compound Interest

TALLY WITH GST

COMPANY MANAGEMENT

  • Basics of Tally
  • Introduction to Tally ERP 9
  • Installation of tally ERP 9 software
  • Default Data path and changing it
  • Creating company
  • Alteration and Deletion of Company
  • Introduction to Gateway of Tally ERP 9

TALLY MASTERS:- ACCOUNTS

  • Introduction to masters and Account Masters
  • Creation of Ledgers
  • Alteration and deletion of Ledgers
  • Creation of Groups
  • Alteration and deletion of Groups
  • Creation of ledgers with opening balance
  • Creation of Suppliers & Customers ledger with bill wise details

ACCOUNTING VOUCHERS IN TALLY

  • Understanding default accounting voucher types
  • Receipt voucher
  • Payment voucher
  • Contra voucher
  • Purchase voucher- invoice and voucher mode
  • Sales voucher- invoice and voucher mode
  • Journal voucher
  • Inventory vouchers

INVENTORY MASTERS IN TALLY

  • Inventory Masters- Stock Group, Stock category ,Stock Item, Unit and Godown
  • Creation of inventory masters
  • Alteration and deletion of inventory masters

ORDER PROCESSING IN TALLY

  • Quotations, Purchase and Sales Order
  • Purchase and Sales Challan
  • Rejection inward and outward
  • Purchase and Sales Return

ADVANCE INVENTORY FEATURES

  • Job-Order Processing
  • Stock transfer after creating voucher class
  • User Maintenance & Tally Audit
  • Bill of Material – Production, Assemble, Unassembled
  • Alternate and combined UOM
  • Stander price
  • Part number and other features

ORDER PROCESSING IN TALLY

  • Quotations, Purchase and Sales Order
  • Purchase and Sales Challan
  • Rejection inward and outward
  • Purchase and Sales Return

OTHER IMPORTANT FEATURES IN TALLY

  • Bank Reconciliation
  • Export and Import of data
  • Data Security and Backup
  • Zero Valued Transactions
  • Configurable Invoicing
  • Stock Transfer
  • Cheque Printing
  • Company Logo
  • Reporting

ADVANCE ACCOUNTING FEATURES IN TALLY

  • Multiple Price List for different group of customers
  • Interest calculation with or without advance parameter
  • Generating Point of Sale Invoice (POS)
  • Voucher Class with separate configuration
  • Non Accounting Voucher-Reversing Journal & Optional vouchers
  • Creating Scenario
  • Cost Centre and cost category
  • Credit Limit and Budget Control

REPORTING AND USER MANAGEMENT IN TALLY

  • MIS Reporting
  • Exceptional Reports
  • Email Reports
  • Confirmation of Accounts
  • Generate Reminder Letters
  • Split of Data, Group and Merge Company
  • Back-up and restore

PAYROLL MASTERS AND FEATURES

Payroll is used to manage complete details of salary, employees, HR compliances and other related requirements.

  • Creating Employees Masters
  • Define Salary Components
  • Defining Salary structure and copying thereof
  • Leave categories
  • Attendance types
  • Bonus
  • Gratuity
  • Loan and advances management
  • Overtime Management

PAYROLL STATUTORY IN TALLY

  • Enabling and filling statutory details
  • PF and ESI Rules and rates
  • PF and ESI calculation and Accounting
  • TDS Deduction on salary

PAYROLL VOUCHERS IN TALLY

  • Monthly Attendance
  • Auto calculation and entry of Monthly Salary
  • Entry for PF,ESI and DLI
  • Entry of User defined salary components

PAYROLL REPORT IN TALLY

  • Generate payroll reports- Pay-slip, Attendance Register, Salary register
  • Payment Advice
  • Leave Reports
  • Auto mailing of pay slips to employees
  • Payroll statutory report

TDS IN TALLY

TDS stands for Tax Deducted at source. The concept of TDS was introduced in the Income Tax Act, 1961. At present, Income from several sources is subject to TDS.

  • TDS Transactions in Tally
  • TDS Computation
  • TDS on advance payment
  • TDS without PAN
  • Payment of TDS
  • TDS Reports

TCS IN TALLY

TCS is applicable on some selected transactions and TCS compliance is almost similar to TDS but applicable Rule is different.

  • TCS Transactions in TALLY
  • TCS Computation
  • Payment of TCS
  • TCS Reports

GST ACCOUNTING IN TALLY

Goods and Services Tax is a comprehensive tax levied on supply of goods and services across India.

  • GST on Goods (Local & Interstate)
  • GST on Services (Local & Interstate
  • Item rate wise and value wise GST
  • HSN and SAC
  • ITC under GST and Adjustment thereof
  • Analysis of GSTR-1,GSTR-2 and GSTR-3/3B
  • Treatment of Reverse charge in GST

ONLINE RETURN FILING

INCOME TAX- INTRO, RETURN FILING (WEBTEL, COMPUTAX & EXCEL)

Income tax reporting is mandatory for all business entity and individual/HUF if income exceeds basic exemption limit.

  • Obtaining PAN
  • Registration under Income Tax
  • Computation of Income Tax
  • Residential Status
  • online payment of taxes
  • Return filling through WEBTEL, COMPTAX and EXCEL
  • ITR Forms – ITR-1, ITR-2, ITR-3, ITR 4 Sugam, ITR-5, ITR-6
  • Process of Refund claim
  • Advance tax
  • Self-Assessment Tax
  • Tax on regular Assessment
  • Revise return
  • Penalty, Interest etc…

TDS & TCS-INTRO, RETURN FILING (WEBTEL, COMPUTAX & EXCEL)

  • Obtaining TAN
  • Computation of TDS
  • TDS on Salary
  • TDS on other than Salary
  • TDS on Non-Residents
  • Online payment of TDS and TCS
  • Return filling- 24 Q , 26 Q , 27 Q , 27 EQ
  • Generate TDS Certificates- Form 16 & Form 16 A
  • Form 26 AS (Tax credit)
  • Generate FVU file
  • Generate Consolidated Report
  • Process of Refund claim
  • Advance tax
  • Revise return
  • Penalty & Interest etc…

GST –INTRO & RETURN FILING (WEBTEL, COMPUTAX & EXCEL)

GST return preparation and filing is the key challenge under GST Law for the Accountants. This module will enable the learners to prepare and file error free returns on time with multiple options.

  • GST Registration
  • Obtaining GSTIN
  • GST accounting
  • Invoicing rule
  • Place of supply
  • Computation of GST
  • GST on Local & Interstate transactions
  • Online payment of GST
  • GST on Stock Transfer
  • Reverse charge mechanism
  • GST on Work Contractor
  • GST Return
  • Generate Mismatch Report
  • Process of Refund claim
  • Revise return
  • Penalty& Interest etc.

BASICS OF STOCK MARKET & FOREX

Stock Markets are a crucial part of an economy, rendering a pivotal role in industrial and commercial growth of a country. As far as Forex is concern, it is the most important factor for exporter, importer, money changer, RBI, Government and overall economy.

Our course will elucidate the basic concepts of Stock market, trade and Foreign Exchange, making students aware of the basic operations of these businesses.

  • Primary market, Secondary market
  • Demat Account , Trading Account
  • Types of investors:- Speculators, Hedgers, Arbitragers
  • BSE Sensitive Index or SENSEX , NSE Index Nifty
  • Bull Market or Bear Market
  • Delivery , Intraday and BTST
  • Long Buy , Short Selling , Stop Loss and trigger price
  • Portfolio, Averaging, Booking Profit or Loss
  • Currencies of different countries, conversion rates
  • Comparison of INR with other currencies
  • Forex Trading In India, Forex transaction in spot and Future Market
  • Forex loss management Tools.
  • Penalty& Interest etc.

ONLINE BANKING, DIGITAL PAYMENTS AND PLASTIC MONEY

Online financial transactions are the base of Digital India. Online payment is mandatory in certain cases. So we must have complete knowledge of online banking and Digital Payment.

  • Introduction of banking
  • Online bank payment
  • Amount transfer from one bank of another: – NEFT, RTGS and IMPS
  • Bill payments
  • Stop payments
  • online bank statement
  • Debit / Credit /Travel / Others
  • Aadhaar Enabled Payment System
  • Unified Payments Interface
  • Mobile Wallets
  • Internet banking
  • Mobile banking

INTRODUCTION TO ROC AND MARG ACCOUNTING SOFTWARE

  • How to Register New Company online
  • Form filing for New Company form 1A,Form 1,Form32, Form 18
  • Procedure For getting DIN &CIN
  • How to Register Digital Signature on MCA websites for filing return.
  • Introduction of Marg Accounting Software