Professional Diploma in Finance & Accounts
Professional Training &
100% Projects Based Training

Be Professionals From Professionals               Only Professionals can Make u Professional

Part Time
Duration 15 Months
Class 1.5 Hrs. Daily
Days Mon-Fri
Half Time
Duration 7.5 Months
Class 3 Hrs. Daily
Days Mon-Fri
Full Time
Duration 5 Months
Class 4.5 Hrs. Daily
Days Mon-Fri

For Business Accountant OR Accounts Manager OR Accountant


Your career after a course in Accounting


Study in Accounting may include topics like Accounting Framework, Legal Framework, Management Information, Organizational Framework, Audit Framework, Tax Framework, Managerial Finance, Accounting Skills, Credit Transaction Skills, Payroll Transactions, Financial Accounting and Management Accounting. Accountancy is a subject that is favorable for managers in corporate houses and tax professionals as it helps them in determining the financial position of the firm and the various ways in which resource allocation can be done for the companies.

Accounting courses nowadays have improved a lot and have added various topics like business ethics, fraud prevention and investor relations other than classical topics like asset valuation and business mathematics. Some of the most sought after courses in this field include Professional Diploma in Finance & Accounts and Diploma in Accounting & Taxation/Payroll.

 Eligibility

For undergraduate programmers, one must be a 12th passed or one must have a Bachelor's degree.

  Career Prospects

This field offers a wide range of career options. You will learn how business works. Being a gradually evolving field, it offers indulging and challenging work. You will spend a lot of time looking under the hoods of businesses and learn the framework of business. Owing to this factor, many successful businessmen started their careers with accounting jobs. If you are determined and have the right potential, then you can grow up to the position of Chief Financial Officers in large corporations. In short, accountants are in demand in major corporations because whenever a company needs someone to do their books for them, an accountant will be the first person they call. One can look forward to careers like:




  1.   Accountant or Business Accountant or Accounts Manager
  2.   Revenue Agent
  3.   Marketing Manager
  4.   Financial Analyst
  5.   Tax Policy Analyst
  6.   Tax Attorney Specialist
  7.   Employment Tax Specialist
  8.   Personal Finance Consultant
  9.   MIS Analyst


MODULE 1 - M.I.S (Management Information System)

 Adv. MS WORD

Getting Started with Word

  • Navigate in Microsoft Word
  • Create and Save Word Documents
  • Manage Your Workspace
  • Edit Documents
  • Preview and Print Documents
  • Customize the Word Environment

Formatting Text and Paragraphs

  • Apply Character Formatting
  • Control Paragraph Layout
  • Align Text Using Tabs
  • Display Text in Bulleted or Numbered Lists
  •  Apply Borders and Shading

Working More Efficiently

  • Make Repetitive Edits
  • Apply Repetitive Formatting
  • Use Styles to Streamline Repetitive Formatting Tasks

Managing Lists

  • Sort a List
  • Format a List


Adding Tables

  • Insert a Table
  • Modify a Table
  • Format a Table
  • Convert Text to a Table

Inserting Graphic Objects

  • Insert Symbols and Special Characters
  • Add Images to a Document

Controlling Page Appearance

  • Apply a Page Border and Color
  • Add Headers and Footers
  • Control Page Layout
  • Add a Watermark
  • Learn to set the page orientation as portrait or landscape.
  • Learn to set the print size of the paper.
  • Learn to split your text into multiple columns.
  • Learn to add page breaks.
  • Learn to add section breaks.

Advanced Mail Merge

  • Beginning a Mail Merge
  • Using Excel for Mail Merge Data
  • Previewing Merge Letters
  • Selective Merge Records
  • Filtering
  • IF Then Else Fields
  • Include Text Fields
  • Mail Merge to Email

Preparing to Publish a Document

  • Check Spelling, Grammar, and Readability
  • Use Research Tools
  • Check Accessibility
  • Save a Document to Other Formats
  • The Macro Recorder
  • Recording Macros
  • Testing Macros
  • Running Macros

Microsoft Word Keyboard Shortcuts

 

 Prof. MS POWERPOINT

Creating Presentation                    

  • Blank & Sample Templates 
  • Adding Text
  • Bullet & Numbered Lists 

Adding Graphics

  • Capture Images & Insert Pictures 
  • Photo Album 
  • Drawing Shapes 
  • Advanced Shapes 
  • Merge Shapes 
  • WordArt 
  • SmartArt Graphics 

Modify Objects

  • Crop, Resize & Style Objects 
  • Formatting Objects 
  • Grouping Objects 
  • Object Ordering & Layering 
  • Gridlines & Guides

Tables

  • Insert & Formatting Tables 
  • Insert Table from Word 
  • Manipulating PowerPoint Tables
  • Inserting a Word Table
  • Inserting an Excel Spreadsheet
  • Adjusting Rows, Columns, Cells
  • Table Styles and Borders

Create & Modify Charts 

  • Inserting a Chart
  • Working with Datasheets
  • Applying a Chart Type, Style and Layout
  • Displaying Chart Analysis
  • Picture Charts
  • Formatting Chart Background

Templates, Themes & Layouts

  • Creating a Custom Layout
  • Applying a Theme
  • Applying a Background Style
  • Saving a Custom Theme
  • Arranging and Printing Section

Custom Design Templates

  • Slide Master 
  • Background Graphics 
  • Custom Slide Layouts 
  • Advanced Custom Themes 
  • Add Headers & Footers 
  • Modify Notes Master 
  • Edit Handout Master 
  • Create Custom Template 

Editing Slide Masters

  • Slide Master, Title Master
  • Formatting the Masters
  • Adding Header and Footer Information
  • Notes and Handout Masters

Animations and Transitions

  • Animation Schemes
  • Animating Text and Objects
  • Custom Animations and timing
  • Inserting Sounds and Video
  • Editing Media Clips

Setting Up the Slide Show

  • Setting Automatic Slide Timings
  • Setting Up a Continuous Loop
  • Hiding a Slide
  • Rehearsing Slide Transition Timings

Custom Shows & Interlinked Shows

  • Creating a Custom Show
  • Setting Up a Custom Show as the Default
  • Creating a Hyperlink
  • Using a Hyperlink
  • Using an Action Buttons
  • Jumping to Another Presentation

Packaging Presentations

  • Embedding the Fonts in a Presentation
  • Using the PowerPoint Viewer
  • Formatting a Presentation for the Web
  • Inspecting the Document
  • Annotating a Presentation
  • Sending in PDF Format

Using SmartArt

  • Inserting a SmartArt Object
  • Formatting a SmartArt Object Color
  • Resizing/Repositioning a SmartArt Object
  • Inserting Text into a SmartArt Object
  • Formatting Text Within a SmartArt Object
  • Adding Shapes to a SmartArt Object
  • Grouping SmartArt Objects

Inserting a Photo Album

  • Inserting Pictures from a File
  • Adding Captions
  • Applying a Theme to your Album
  • Customizing the Album Layout

Special Effects

  • Insert, Trim, Fade & Bookmark Audio 
  • Insert, Trim, Fade & Bookmark Videos 
  • Advanced Animation 
  • Motion Paths 

Customizing Presentation

  • Custom Slide Shows 
  • Setup Slide Show & Presenter View 
  • Secure PowerPoint Show 
  • Hyperlinks 
  • Action Buttons & Link Actions 
  • Annotate 
  • Record Narration 
  • Rehearse Timings 

Collaborating

  • Merge & Compare 
  • Insert Comments 
  • Slide Library 
  • OneDrive & Coauthoring 

Secure & Distribute

  • Present Online 
  • Create Video Files 
  • Package Presentation 
  • Publish to PDF or XPS 
  • Document Properties 
  • Document Inspector 
  • Password Protect 
  • Digital Signature 
  • Mark as Final 
  • Screen Recording 
  • Closed Caption 
  • Equations & Ink

  Prof. MS Access (RDBMS)

Understanding Databases 

  • Starting and Opening an Existing Database
  • Moving Around in Access
  • Understanding Datasheet View & Design View
  • Using the Mouse Pointer to Navigate
  • Using the Keyboard to Navigate
  •  

Creating Tables

  • Creating a Database
  • Creating a Table Using the Wizard
  • Creating and Modifying a Table
  • Adding Fields to Tables
  • Adding and Editing Records
  • Printing Tables
  • Moving and Deleting Fields
  • Deleting Records
  •  

Working with Tables

  • Formatting a Table
  • Modifying Field Properties
  • Sorting Records in a Table
  • Finding Records in a Table
  • Using Filters with a Table
  • Establishing Relationships Between Tables
  • Creating Subdatasheets
  • Importing Records From an External Source
  •  

Designing a Form

  • Creating a Form Using Auto Form
  • Creating a Form Using the Form Wizard
  • Adding Controls to a Form
  • Modifying Control Properties
  • Resizing and Moving Controls
  • Entering Records into a Form
  • Creating Calculated Controls
  •  

Designing a Report

  • Creating a Report Using Auto Report
  • Creating a Report Using Report Wizard
  • Adding a Control to a Report
  • Formatting a Report
  • Resizing and Moving Controls
  • Creating Calculated Controls
  •  

Creating and Using Queries

  • Creating and Running a Query
  • Specifying Criteria in a Query
  • Using Comparison Operators
  • Creating a Calculated Field
  • Creating a Multiple-Table Query
  • Printing a Query

Automating Tasks

  • Creating an Auto Keys Macro
  • Using Controls to Run a Macro
  • Assigning a Macro to an Event
  • Assigning a Macro to a Condition
  • Testing and Debugging a Macro

 Prof. MS EXCEL

Mathematical & Statical Function’s

  • Sum
  • Product
  • Average
  • Ceiling
  • Floor
  • Round
  • Round Up
  • Round Down
  • Power
  • Count
  • Counta
  • Maximum
  • Minimum
  • Mode
  • Median
  • Log
  • Dollar
  • Average A
  • Mina
  • Maxa
  • Large
  • Sqrt
  • Mod
  • Roman
  • Rank
  • Rank Average
  • Rand
  • Rand Between

Logical Function

  • If
  • Nested if
  • SumIf
  • Sumifs
  • Averageif
  • Averageifs
  • Countif
  • Countifs
  • Or
  • Not
  • And
  • If error
  • If Function & Nested If Statements And & Or Functions
  • Maxifs
  • Minifs
  •  

Text Function’s

  • Upper
  • Lower
  • Left
  • Right
  • Exact
  • Len
  • Mid
  • Concatenate
  • Proper
  • Trim
  • Substitute
  • Search
  • Find

Date & Time Function’s

  • Days360
  • Date
  • Network days
  • Now
  • Today
  • Weekday
  • Effect
  • Eomonth
  • Edate
  • Workdays
  • Datedif

Lookup &Reference Function’s

  • Index
  • Match
  • Lookup
  • Choose
  • Offset
  • Offset with Match
  • Xlookup
  • Transpose
  • Hlookup For Single Worksheet
  • Vlookup For Single Worksheet
  • Hlookup & Vlookup For Multiple Sheet
  • Match and Find Record by Vlookup And Hlookup
  • Approximate Match with Vlookup
  • Exact Match with Vlookup
  • Nesting Lookup Function
  • Show Formula
  • Choose Function with Vlookup
  • Indirect

Financial Function’s

  • Pmt
  • Rate
  • Ppmt
  • Ipmt
  • Fv
  • Pv
  • Coupdays
  • Coupnum
  • Ispmt
  • Sln
  • Cumprinc
  • Cumipmt
  • Ddb
  • Db
  • Received

Database Function’s

  • Daverage
  • Dproduct
  • Dmin
  • Dmax
  • Dcount
  • Dsum
  • Dget

Working with Charts

  • Moving a Chart One to another Sheet
  • Resizing a Chart, Changing a Chart Type
  • Editing Chart Text, Modifying Chart Options
  • Formatting Category & Value Axis Data
  • Formatting a Data Series
  • Changing a Chart’s Source Data
  •  

Format Cells

  • Cell Format.
  • Data Bars, Color Scales & Icon Sets.
  • Sorting basic.
  • Sorting based on Customized List.
  • Customized Sorting (Advanced).
  •  

Conditional Formatting with Rules & Color Scale 

  • Using Conditional Formatting
  • Removing Conditional Formatting
  • Format As table
  • Create our Styles
  • Conditional formatting with formulas
  • Conditional formatting with Form Controls.
  •  

Data Management with Data Validation

  • Data Validation and dealing with Invalid Data.
  • Group and Outline Data
  • Data Consolidation.
  • Data text to column.
  • Custom Views
  •  

Data Analysis

  • Tracing Formula Precedents
  • Tracing Cell Dependents
  • Error Checking
  •  

Summarizing Data by Subtotal With grouping

  • Adding Subtotals to a List
  • Nesting Subtotals
  • Adding Group & Outline Criteria to Ranges
  • Using Data Validation
  • Text to Column
  •  

What –If Data Analysis

  • Using Goal Seek
  • Using Data Table
  • Creating & Displaying Scenarios
  •  

Sorting & Filtering

  • Sorting Records in a List
  • Using AutoFilter in a List
  • Filter & Advance Filter
  • Applying Advance Filters

Protecting Excel Workbook & Sheet

  • Locking/Unlocking Cells in a worksheet
  • Protecting a Worksheet
  • Protecting a Workbook
  • Creating a Shared Workbook
  • Tracking Changes to a Workbook
  • Accepting & Rejecting Changes to a Workbook
  • Password Protecting a Workbook
  • Merging Workbooks
  •  

Workgroup Collaboration

  • Web Page Preview
  • Converting Worksheets into Web Pages
  • Inserting Hyperlinks
  • Viewing & Editing Comments
  •  

Customizing Macro by Action Button

  • Creating a Macro with Condition
  • Running a Macro, Editing a Macro
  • Adding a menu to the Menu Bar
  • Adding a Commands to a Menu
  • Adding Buttons to a Toolbar
  •  

Working with Pivot Table & Pivot Chart

  • Creating a Pivot Table
  • Rearranging a Pivot Table
  • Filtering Pivot Table Data
  • Creating a Pivot Chart
  •  

Reporting with Payroll Statement

  • MIS Report
  • Profit & Loss a/c statement
  • Balance sheet
  • Worker contribution statement
  • Cash flow statement
  • Debtor’s & Creditors statement
  • Inventory statement
  • BRS Statement
  • Fixed Assets & fund statement
  • Payroll Report
  • P.F & E.S.I Report
  •  

Advance Paste Special Techniques

  • Paste Formula’s, Paste Formats
  • Paste Validations
  • Transpose Tables
  • Paste data
  •  

Special Operation

  • Find record by drop down list according To condition
  • Dash Board
  • Working with the Web and External Data
  • Inserting a Hyperlink
  • Importing Data from an Access Database or Text File
  • Importing Data from the Web and Other Sources
  • Working with Existing Data Connections
  • Speed o Meter
  •  

Print Settings

  • Page Break
  • Print Area
  • Print Titles
  • Background

 SQL

SQL ─ Overview

  • What is SQL?
  • SQL Process
  • SQL Commands
  •  

SQL – Operators

  • What is an Operator in SQL?
  • SQL Arithmetic Operators
  • Arithmetic Operators – Examples
  • SQL Comparison Operators
  • Operators – Examples
  • SQL Logical Operators
  • Logical Operators – Examples

SQL – Expressions

Boolean Expressions

Numeric Expressions

Date Expressions

SQL – CREATE Database

  • SQL ─ DROP or DELETE Database
  • SQL ─ SELECT Database, USE Statement
  • SQL ─ CREATE Table
  • SQL - Creating a Table from an Existing Table
  • SQL ─ DROP or DELETE Table
  • SQL ─ INSERT Query
  • SQL ─ SELECT Query
  • SQL ─ WHERE Clause
  • SQL ─ AND & OR Conjunctive Operators
  • The AND Operator
  • The OR Operator
  • SQL ─ UPDATE Query
  • SQL ─ DELETE Query.
  • SQL ─ LIKE Clause.
  • SQL ─ TOP, LIMIT or ROWNUM Clause
  • SQL ─ ORDER BY Clause
  • SQL ─ Group By
  • SQL ─ Distinct Keyword
  • SQL ─ SORTING Results
  •  

SQL ─ Constraints

  • SQL ─ Constraints
  • SQL - NOT NULL Constraint
  • SQL - DEFAULT Constraint
  • SQL - UNIQUE Constraint
  • SQL ─ Primary Key
  • SQL ─ Foreign Key
  • SQL ─ CHECK Constraint
  • SQL ─ INDEX Constraint
  • Dropping Constraints
  • Integrity Constraints
  •  

SQL ─ Using Joins

  • JOIN
  • SQL ─ LEFT JOIN
  • SQL - RIGHT JOIN
  • SQL ─ FULL JOIN
  • SQL ─ SELF JOIN
  • SQL ─ CARTESIAN or CROSS JOIN
  •  

SQL ─ UNIONS CLAUSE

  • The UNION ALL Clause
  • SQL ─ INTERSECT Clause
  • SQL ─ EXCEPT Clause
  •  

SQL ─ NULL Values

SQL ─ Alias Syntax

SQL – Indexes

  • The CREATE INDEX Command
  • The DROP INDEX Command
  • SQL - INDEX Constraint
  •  

SQL ─ ALTER TABLE Command

SQL - TRUNCATE TABLE Command

SQL ─ Using Views

  • Creating Views
  • The WITH CHECK OPTIONSQL ─ Having Clause
  •  

SQL – Transactions

  • Properties of Transactions
  • Transactional Control Commands
  •  

SQL ─ Wildcard Operators

SQL ─ Date Functions

SQL ─ Temporary Tables

  • What are Temporary Tables?
  • Dropping Temporary Tables
  •  

SQL – Clone Tables

SQL – Sub Queries

  • Subqueries with the SELECT Statement
  • Subqueries with the INSERT Statement
  • Subqueries with the UPDATE Statement
  • Subqueries with the DELETE Statement
  •  

SQL – Using Sequences

  • Using AUTO_INCREMENT column
  • Obtain AUTO_INCREMENT Values

 VBA MACROS

What Is Vba & How Vba Works With Excel

  • Quick Review of Macros
  • Introducing the Visual Basic Editor
  • Uses of record Macros
  • Understanding and creating modules
  •  

Programming Concepts

  • VBA Sub and Function Procedures
  • How to create a message box
  • Write a Program to update and retrieve information using Input Box
  • Understanding and using Select Case statement
  • How do I define a variables and Rules for defining a Variables Name and Type
  • Creating And using Variables
  • Working with range Objects
  • How to save and Protect Modules
  •  

Decision Makers

  • If……Then……Else
  • If……Then……Else If……If
  •  

Other Kinds of Loops

  • Working with Do While u. Loop Procedure
  • Do…… Until Loop and Do…… Loop Until
  • Do……While loop and Do…… Loop While
  • For each…… Next
  • For……Next
  •  

Workbook Objects Create or Add Single and Multiple Workbooks

  • Workbook Save and Save AS
  • Open Single and Multiple Workbooks
  • Close Specify and Multiple Workbooks
  • Activate From one workbook to another Workbook
  • Open Workbook from Specific Path
  • Get Workbook Name and Paths
  • Hide and Unhide for Single and Multiple Workbooks
  • Protect and Unprotect Worksheets
  •  

Worksheet Objects insert a single and Multiple Worksheets

  • Delete Specific and multiple worksheets
  • Get Count of Worksheets
  • Select a Specific and all Worksheets
  • Get All Worksheets Name
  • Hide and Unhide For Single and Multiple Worksheets
  • Rename for Single and Multiple Worksheets
  • Protect and unprotect worksheets
  • Sort and Move worksheets
  • Calculate entire worksheet
  • Using VBA and worksheet Function

Cell objects insert Single and multiple Row, Column and Cells

  • Delete Single and Multiple rows, Column and Cells
  • Get Range or Address of Cell and Selection
  • Navigate from one Cell to another Cell
  • Select specific Range, Cell, Rows and Column
  • Types of Selection and Offset method
  • Insert Function In cell
  •  

Reading and Writing Arrays

  • Defining Arrays
  • Arrays as Outputs
  • Arrays as inputs
  • The Arrays as a Collection
  • The Array as an Array
  •  

Form Controls and User Forms (Create and Design an user Form)

  • Working with User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
  • How to Create Dynamic Dashboard on User Form with Different Controls
  • How to Link Various User Form With Each Other To Create A Complete Interface Between User and System
  •  

VBA Programming Functions

  • Create a Sum Functions
  • Create Multiply Function
  • Create Count Function
  • Extract Text & Number
  • Proper Function
  • Vlookup Function
  • Square root Function
  • Public or Private function
  •  

Excel VBA Power Programming for VBA Macros

  • Working with Dynamic Ranges. Protecting worksheets, Cells and Ranges. Working with Multiple Files. Opening &saving Files
  • How to Analyze Data On multi Worksheets and Build Summary sheets
  • how to Access the Windows File and Folder System to Open and Close Workbooks
  • How to protect your code Against Errors
  • How to use Excel And VBA to Create Basic Dash Boards
  • How to create Your own custom Business Worksheet Function in VBA
  • How to create Basic Report Generation Tools Using Excel Vba, Microsoft Word and PowerPoint
  • How to use the Excel Visual Basic Macro record Excel Tasks in VBA and then Interpret the code
  •  

Connection between Excel VBA & other platforms

  • How to Establish Connection Between VBA And Power Presentation to Create Power Point Through VBA
  • How to Establish Connection Between Excel Vba And Outlooks Through Vba
  • How to Establish Connection Between Excel Vba And MS Word Through Vba

Module 2

 ADVANCED ACCOUNTING

  • Accounting terminology
  • Activities and user of Accounting Information
  • Assumption of Accounting
  • Principal of Accounting
  • Accounting cycle and source/Accounting document
  • Accounting equation Classification of Account
  • Types of Expenditure
  • Compound Entry
  • Subsidiary book and types of book
  • Trial balance & Objectives
  • Rectification of Error
  • Provision & Reserve
  • Inventory & cost for Inventory Valuation
  • Suspense Account
  • Share capital of company
  • Kind of Share, forfeiture of share
  • Over Subscription & Pro-rata allotment
  •  Accounting voucher
  • Journal, cash book, ledger and trial balance
  • Bills of exchange
  • Depreciation
  • Bank Reconciliation Statement
  • Financial Statements
  • Ratio Analysis
  • Cash Flow Statement
  • MIS Report
  • Budget & Types of Budget
  • Accounting Standard

 

Module 3

 TAXATION

  • Residential Status & Slab rate of Taxes
  • Certain Incomes Exempt from Tax
  • Income under Head Salary
  • Income under the Head House Property
  • Profit & Gains from Business & Profession
  • Income under the Head Capital Gains
  • Income under the head Other Sources
  • Clubbing of Income, set off & Carry Forward of losses, Deduction from Gross Total Income.
  • Agricultural Income, Illustration on Computation of Total Income & Liability
  • Assessment of Firms, Return of Income & Assessment of individual
  • TDS/TCS-Types of Forms, return filing
  • Tax Deduction of Source, Advance Tax,
    • Interest, Refund, Penalty,
    • Income Tax-Preparation of Income Tax Return Filing (Manually and E-filling) allotment of PAN, TAN, Advance tax, penalties, complete documentation
  • Legal Documentation
  • GST (GOODS AND SERVICE TAX)
  • Legal Documentation For GST

 

Module 4

 BUSY

General Features

  • Completely Codeless
  • Multi-Company Accounting
  • Context-Sensitive On-Line Help
  • Flexible Voucher Numbering
  • Multiple Voucher Series for each Voucher Type
  • Voucher entry while viewing reports and Vice-versa
  • User-definable Optional Fields in Masters and Vouchers
  • Unlimited level of Grouping of Accounts, Items, Material Centers and Cost Centers
  • Option for adding Images & Notes in Account & Item Masters
  • Draft Mode Printing for every Report and Document
  • Voucher Cancellation
  • Powerful Query System
  • SQL Query Executor
  • Print Preview
  • Landscape Mode Printing
  • Bird's Eye View of Account
  • ENTERPRISE FEATURES
  • Voucher / Master Approval
  • Message centre
  •  

Financial Accounting

  • All books of Accounts & Final Results
  • Balance Sheet with various Schedules
  • Columnar Account Registers (Configurable)
  • Daily / Monthly Summaries of Accounts, Account Groups and Cost Centers
  • Bill-wise Outstanding with Ageing Analysis
  • Payment Reminder Letters (Configurable)
  • Statement of Account (Configurable)
  • Handling of Post-dated Cheques
  • Broker-wise Reporting
  • Royalty Calculation
  • Interest Calculation (Multiple Slabs based on Amt. & Days)
  • Bank Interest Calculation
  • Bank Re-conciliation
  • Depreciation Chart (As per Companies Act / IT Act)
  • Multi-Currency Accounting
  • Cost Centre-wise Reporting
  •  

Multi-Location Inventory

  • All books of Inventory
  • Stock Status (Multi-location)
  • Sales / Purchase Challans
  • Columnar Inventory Registers (Configurable)
  • Stock Valuation on Multiple Methods
  • Separate Stock Valuation Method for each Item
  • Item Serial No. Tracking
  • Stock Ageing Analysis
  • Allocation of Expenses to Items
  • Daily / Monthly Summaries of Items and Item Groups
  • Automatic Round-off in Vouchers
  • Primary and Alternate Unit for each Item
  • Batch-wise Inventory with Expiry Date
  • Provision for Free Qty in Inventory Vouchers
  • Provision for entering Sales / Purchase Return in Sales / Purchase Vouchers
  • Production / Un-assemble
  • BOM / Production Planning
  • Critical Level Reporting
  • Multiple Price-list for Items
  • Multiple Price Structures (Party / Qty / Category-wise)
  • Provision to update Item Prices on various Criterion
  •  

Sales / Purchase Order Processing

  • Pending Sales Orders (Party / Item-wise)
  • Pending Purchase Orders (Party / Item-wise)
  • Order Cancellation
  • Invoice / Challan Generation from Orders
  • USER-CONFIGURABLE INVOICING
  •  

Fully User-Configurable

  • Use Plain / Pre-printed Stationery
  • Option for Fonts, Colors& Logos
  • Option to Print Outer Box, Horizontal & Vertical Lines
  • Multiple-taxes in Single Invoice
  • Tax Inclusive / MRP Billing
  • Point-of-Sale (POS) Billing
  • Mfg. Excise Invoicing
  • Trading Excise Invoicing
  •  

User-Configurable Documents

  • Accounting Vouchers
  • Purchase Invoice
  • Sales Return / Purchase Return Invoice
  • Receipt / Payment Advice
  • Debit / Credit Note
  • Sales / Purchase Order
  • Delivery Note / Goods Receipt Note
  • Stock Transfer Memo
  •  

Sales Tax Reports

  • Sales Tax Forms Receivables / Issuable
  • Sales Tax Forms Reminder Letters
  • Forms Received / Issued Register
  • Sales Tax / Purchase Tax Summary
  • Sales Tax Surcharge
  • Sales Tax Registers
  •  

GST Reports

  • GST Computation / Summary
  • GST Invoicing (Tax / Retail)
  • GST Returns (State-wise)
  • GST Registers (State-wise)
  • Columnar GST Registers (Configurable)
  • Party-wise / Item-wise GST Summary
  • Party-wise / Item-wise GST Summary
  • Sales Re-conciliation as per Accounts and GST
  • GST R1
  • GST R2
  • GST 3B
  •  

Service Tax

  • Input Service Tax Register
  • Output Service Tax Register
  • Service Tax Summary
  • ST-3 (Service Tax Return)
  •  

TDS Reports

  • TDS Calculation
  • TDS Warning Alarms
  • TDS Challans
  • TDS Certificate (Form 16-A)
  • TDS Return (Form 26-Q)
  • Annexures to Form 26-Q
  • e-TDS with TDS 27-A
  • TDS Audit Report
  • TDS Deduction Details Report
  •  

Fringe Benefit Tax

  • Mark Expenses as FBT
  • Expense-wise Taxable Value
  • Option to charge FBT on Account Groups
  • Fringe Benefit Tax Report
  •  

MIS Reports

  • Cash Flow / Funds Flow
  • Budgets / Targets / Credit Limits
  • Ratio Analysis
  • Sales / Purchase Analysis on various combinations
  • Issue / Receipt Analysis
  • Consumption Analysis
  • Data Check List
  • Profitability Reports (Item / Bill / Party / Batch / MC wise)
  • Multi-Company Final Results / Reports
  •  

Utilities

  • Data Freezing
  • Pop-up Calculator
  • Notes / Task Manager
  • User-definable Access Rights

Module 5

 TALLY

Introduction of Tally

  • Company information
  • Create a new company
  • Current period, current date
  • Company creation (accounts maintain, financial year, security control, tally vault)
  • Accounts info
  • Group ledger
  • Ledger

Book Keeping

  • Entries with dr. And cr.
  • Using cash account in journal
  • Debit & Credit note
  • Voucher types
  • Select company
  • Shut company
  • Alter company
  • Delete company
  • Group company
  • Change tally vault

Financial Reports & Consolidate Ledger Accounts

  • Balance sheet
  • Profit & loss a/c
  • Ratio analysis

Fund management with list of account

  • Trial balance
  • Accounts book
  • Statement of account
  • Cash/fund flow
  • Day book
  • List of account
  •  

Mode of Invoice Punching/billing

  • Bill wise detail with (new reference, against ref, advance, on account)
  • Display (statement of a/c
  • Bills payable, Receivables
  • outstanding ledger, group)

Inventory Management

  • Stock group
  • Stock item
  • Unit of measure
  • Voucher entries –goods in, goods out
  • Alternate unit and standard rate
  • Opening balance, stock summary

Purchase & Sales Order Processing

  • Purchase and sale order
  • Create purchase order
  • Alter purchase order
  • Delete purchase order
  • Create sale order
  • Alter sale order
  • Delete sale order
  • How can we do reject in reject our entry & use option
  • Delivery note & Receipt note
  • Give challan number in item
  • How can we do reject in reject our entry & use option
  • Delivery note & Receipt note
  • Give challan number in item
  •  

Internal Report of Finance

  • Display (inventory books, day book, list of account)
  • Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)

Controlling (Cost Center & Cost Categories)

  • Cost centre
  • Creation of cost centre
  • Alteration of cost centre
  • Cost categories
  • Create cost categories
  • Alter cost categories

 

Multi godown creation

  • Godown/location
  • Create godown
  • Alter godown
  • Removing companies
  • Copy company
  •  

Tax Deducted at Source (TDS)

  • Tds
  • Transaction of tds
  • Ledger for tds
  • Payment voucher
  • Preparing tds challan
  • Deposit of tds to govt
  •  

Tax Collected at Source (TCS)

  • Understanding TCS
  • Creating TCS Masters & Practical Examples
  • TCS Payment, Reports, & Forms
  •  

Goods and Services Tax (GST)

  • GST
  • Ledger for GST
  • Transaction of GST
  • Adjustment of GST
  • Payment of GST

Budgets and Controls in Tally

  • Budget
  • Types of budget
  •  

Scenarios and Optional Vouchers

  • Creation of scenario
  • Alter or display scenario information
  •  

Export, Backup and Splitting company data

  • Splitting company data
  • Steps of splitting
  • From tally to excel
  • Importing into MS-excel
  • Removing companies
  • Copy companies

Printing Reports

  • Printout of balance sheet, p&l a/c, ledger
  • Printing Different Reports
  • Sales Invoice
  •  

Multi-Currency

  • Currency creation (How to create
  • New currency & how to set the price Lists.

Point of Sales

  • POS (Point of Sale)

Payroll Accounting Functions

  • Payroll (payroll info)
  • Employees and salary detail
  • Maintain attendance register of employees
  • Employees group
  • Create attendance type
  • Unit of leave (payroll)

Manufacturing Vouchers

  • BOM (bill of material)
  • Create Item of BOM
  • How to create voucher after
  • Ledger of BOM
  • Transaction of BOM
  • Alter of BOM
  • After ledger for excise duty

Batch wise Details

  • Batchwise Inventory
  •  

Interest Calculations

  • Interest Calculations

Credit Limit Price List

  • Creation of Price level
  • Create of Price group
  • Maintain Price list on items
  •  

Voucher Types and Class

  • Voucher Type
  • Voucher Class-Sales
  • Inclusive Tax Class
  • Customer pay their payment
  • How to create voucher with discount & freight charg

Module 6 - E-Filing

 GST Forms

  • GSTR-1
  • GSTR-2
  • GSTR-3
  • GSTR-4
  • GSTR-5
  • GSTR-6
  • GSTR-7
  • GSTR-8

 

 Income Tax Return Forms

  • ITR-1
  • ITR-2
  • ITR-3
  • ITR-4
  • ITR-5

 

 TDS/TCS Forms

  • TDS/TCS Challan
  • TDS 24Q
  • TDS 26Q
  • TCS 27EQ

 

Module 7 - Banking

 BANKING

  • Banking system in India
  • Banker’s & Customer Relation
  • Customer Account with the Banker
  • Modern Account opening procedures
  • Banking Operation
  • Summarized of cheque, Types of Cheques
  • Types of Crossing
  • Loan & Advances
  • Types of Commercial credit Letters
  • Housing Loans Schemes
  • Calculation of Interest
  • Different Interest rate on Different Deposit
  • Concepts of Banking
  • Credit, Debit Card, E-banking, Banking documentation
  • Final Accounts of Banks
  • Asset Classification and Provisioning on Advance.
  • Foreign Exchange

 

Module 8

 CORPORATE & INDUSTRIAL LAW

  • Company Act 1956 Concept
  • Types of Companies, Conversion of Company
  • Memorandum and Articles of Association
  • Incorporation of a company
  • Issues of Shares
  • Share Capital & Debentures, Share Certificate, share Warrant
  • Membership of a company
  • Director & types of Director
  • Appointment of Director and Auditor
  • Audit of Accounts
  • Register of Member and Debenture Holder
  • Winding Up (Kinds of Voluntary Winding Up)
  • Payment of Bonus Act,1965
  • Dividend (declaration, distribution of dividend)
  • Provident Fund, 1952(Labor Law- EPF, ESI Act)
  • Calculation of Provident Fund
  • Pension Scheme
  • Gratuity Act,1972
  • Employees State Insurance Act,1

 


Financial Accounting Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.




Message Us

Max Chars Allowed = 100

Copyright © Computec Professionals Group