Certificate in Financial Accounting

Training Mode
Regular
Fastrack
Crash
Classroom | Online
15 Months
7.5 Months
5 Months

A Certificate in Financial Accounting provides a comprehensive understanding of financial accounting principles and practices. The course covers topics such as bookkeeping, preparation of financial statements, balance sheets, income statements, and cash flow analysis. Students learn how to manage financial records, ensure compliance with accounting standards, and analyze financial performance. This certification is ideal for aspiring accountants, business owners, and finance professionals looking to enhance their accounting skills and career prospects.

M.I.S (Management Information System)

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

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

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

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

  • Creating a Chart with the 2D or 3D
  • Create Column Chart, Pie Chart
  • Create Pateros Charts
  • Create Speed- O-Meter Chart
  • 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

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

ADVANCED ACCOUNTING

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

 

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

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

TALLY and E-Filing

  • 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
  • GSTR-1
  • GSTR-2
  • GSTR-3
  • GSTR-4
  • GSTR-5
  • GSTR-6
  • GSTR-7
  • GSTR-8
  • ITR-1
  • ITR-2
  • ITR-3
  • ITR-4
  • ITR-5

DS/TCS Forms

  • TDS/TCS Challan
  • TDS 24Q
  • TDS 26Q
  • TCS 27EQ
  • 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
  • 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

 

Key Features of Courses

Enjoy a free demo session in both classroom and online with a live instructor. This helps you understand our instructors and the atmosphere of our institute. To attend a demo session, call us or fill out the inquiry form or email us at info@lakshayainstitute.com.
We offer an easy and hassle-free installment process for course fees. No extra charges or interest fees—discuss your installments during registration and pursue your dreams.
We focus on quality training with limited batch sizes to ensure personal attention, better results, enhanced learning, and greater focus on concepts.
Our instructors are passionate and highly experienced, providing a high-quality learning experience with a focus on student achievement and outcomes.
We offer the opportunity to retake classes at no cost for up to a year, giving you the flexibility to enhance your understanding and knowledge.
In addition to regular classes, we provide special classes to further reinforce concepts and provide a deeper understanding of the software, languages, and tools.
×

    Unlock Your Learning Journey
    Book a Demo