हिंदी

Accountancy Commerce (English Medium) Class 12 CBSE Syllabus 2025-26

Advertisements

CBSE Class 12 Accountancy Syllabus - Free PDF Download

CBSE Syllabus 2025-26 Class 12: The CBSE Class 12 Accountancy Syllabus for the examination year 2025-26 has been released by the Central Board of Secondary Education, CBSE. The board will hold the final examination at the end of the year following the annual assessment scheme, which has led to the release of the syllabus. The 2025-26 CBSE Class 12 Accountancy Board Exam will entirely be based on the most recent syllabus. Therefore, students must thoroughly understand the new CBSE syllabus to prepare for their annual exam properly.

The detailed CBSE Class 12 Accountancy Syllabus for 2025-26 is below.

Academic year:
Advertisements
Advertisements
Advertisements

Syllabus

CBSE Class 12 Accountancy Syllabus for Chapter 1: Accountancy I : Not-for-profit Organisation and Partnership Accounts

1.1 Accounting for Not-for-Profit Organisation
  • Accounts of “Not for Profit” Concerns  
    • Introduction
    • Meaning of Not for Profit concern
    • Features of Not for Profit concern
    • Difference between Profit organisation and Not for Profit organisation
    • Need for maintaining books of accounts and preparing final accounts
  • Features of "Not for Profit" Concerns.  

    Meaning and Characteristics of Not-for-Profit Organisation

  • Accounting Records of "Not for Profit" Organisations  
  • Receipts and Payments Account  
    • Meaning
    • Features of Receipts and Payments Account
    • Types of Receipts
    • i) Capital Receipts
    • ii) Revenue Receipts
    • Types of Payments
    • i) Capital Expenditure
    • ii) Revenue Expenditure
    • iii) Deferred Revenue Expenditure
    • Specimen of Receipts and Payments Account
    • Steps in preparation of receipts and payments account
    • Meaning and Concept of fund-based and non-fund-based accounting
  • Preparation of Receipts and Payments Account  
  • Feature of Receipts and Payments Account  
  • Difference Between Income and Expenditure Account and Profit and Loss Account.  
  • Preparation of Income and Expenditure Account  
    • Preparation of Income and Expenditure Account from receipt and payment account with additional information
  • Feature of Income and Expenditure Account  
  • Preparation of Balance Sheet  
    • Preparation of Balance sheet from receipt and payment account with additional information
  • Some Peculiar Items  
    • Subscription
    • Donations
    1. Specific Donations
    2. General Donations
    • Legacies
    • Life Membership Fees
    • Entrance Fees
    • Sale of old asset
    • Sale of Periodicals
    • Sale of Sports Materials
    • Payments of Honorarium
    • Endowment Fund
    • Government Grant
    • Special Funds
  • Income and Expenditure Account Based on Trial Balance  
1.2 Accounting for Partnership : Basic Concepts
  • Nature of Partnership  
    • Two or More Persons
    • Agreement
    • Business
    • Mutual Agency
    • Sharing of Profit
    • Liability of Partnership
  • Partnership Deed  
    • Contents of the Partnership Deed
    • Importance of Partnership Deed
    • Provisions Relevant for Accounting
    • Format of Partnership Deed
  • Special Aspects of Partnership Accounts  
  • Maintenance of Capital Accounts of Partners  
    • Distinction between Fixed and Fluctuating Capital Accounts
  • Distribution of Profit Among Partners  
    • Profit and Loss Appropriation Account
    • Calculation of Interest on Capital
    • Interest on Drawings
  • Guarantee of Profits to a Partner  
  • Past adjustments  
    • relating to interest on capital, interest on drawing, salary and profit sharing ratio
  • Preparation of Final Accounts  
    • Rationale of making adjustments at the time of preparing final accounts
1.3 Reconstitution of a Partnership Firm – Admission of a Partner
  • Modes of Reconstitution of a Partnership Firm  
    • Change in the profit sharing ratio among the existing partners
    • Retirement of an existing partner
    • Death of a partner
  • Admission of a New Partner  
    • Effect of admission of a partner
  • Retirement and Death of a Partner - Calculation of New Profit Sharing Ratio  
  • Retirement and Death of a Partner - Sacrificing Ratio  
  • Concept of Goodwill  
    • Meaning of Goodwill
    • Nature and Features of Goodwill
    • Factors Affecting the Value of Goodwill
    • Need for Valuation of Goodwill
    • Methods of Valuation of Goodwill
    1. Average Profits Method
    2. Super Profits Method
    3. Capitalisation Methods
    • Treatment of Goodwill
    1. Premium Method
    2. Revaluation Method
    3. Hidden Goodwill
  • Adjustment for Accumulated Profits and Losses  
  • Accounting for Revaluation of Assets and Reassessment of Liabilities  
  • Admission of a Partner - Adjustment of Capitals  
  • Change in Profit Sharing Ratio Among the Existing Partners  
    • Sacrificing ratio and Gaining ratio
  • Admission of a Partner - Treatment of Goodwill  
  • Retirement Or Death of a Partner - Treatment of Goodwill  
  • Factors Affecting Goodwill  
  • Methods of Valuation of Goodwill  
    1. Average Profits Method
    2. Super Profits Method
    3. Capitalisation Method
    4. Multiplier Method
  • Treatment of Goodwill  
    1. Premium Method
    2. Revaluation Method
    3. Hidden Goodwill
1.4 Reconstitution of a Partnership Firm – Retirement/Death of a Partner
  • Ascertaining the Amount Due to Retiring/Deceased Partner  
  • Retirement and Death of a Partner - Calculation of New Profit Sharing Ratio  
  • Retirement and Death of a Partner - Gaining Ratio  
  • Concept of Goodwill  
    • Meaning of Goodwill
    • Nature and Features of Goodwill
    • Factors Affecting the Value of Goodwill
    • Need for Valuation of Goodwill
    • Methods of Valuation of Goodwill
    1. Average Profits Method
    2. Super Profits Method
    3. Capitalisation Methods
    • Treatment of Goodwill
    1. Premium Method
    2. Revaluation Method
    3. Hidden Goodwill
  • Retirement or Death of a Partner - Revaluation of Assets and Liabilities  
  • Retirement or Death of a Partner - Adjustment of Accumulated Profits and Losses  
  • Disposal of Amount Due to Retiring Partner  
  • Adjustment of Partners’ Capitals  
  • Meaning of Retirement or Death of a Partner  
1.5 Dissolution of Partnership Firm
  • Dissolution of Partnership Firm  
  • Dissolution of a Partnership Firm - Settlement of Accounts  
    • Settlement of accounts under Section 48 of The Indian Partnership Act 1932
  • Accounting Treatment of Bill - Journal Entries and Ledger  

CBSE Class 12 Accountancy Syllabus for Chapter 2: Accountancy II : Company Accounts and Analysis of Financial Statements

2.1 Accounting for Share Capital
  • Features of a Company  
  • Types of Companies  
    • Classification of Companies on the Basis of Incorporation
    • Classification of Companies on the basis of Membership
    • Classification of Companies on the basis of Liability
    • Classification of Companies on the Basis of Control
    • Classification of Companies on the Basis of Nationality
  • Share Capital of a Company  
    • Meaning of Share Capital
  • Types of Shares - Preference Shares Equity Shares  
    • preference shares
    • equity shares
  • Issue of Shares – Procedure  
    • Issue of Prospectus
    • Receipt of Applications
    • Allotment of Shares
  • Accounting Treatment for Share Capital  
    • Calls in Arrears
    • Calls in Advance
    • Over Subscription
    • Under Subscription
    • Issue at par
    • Issue of Shares at a Premium
    • Issue of Shares at a Discount
    • Issue of Shares for Consideration other than Cash
    • In the Books of Drawer/ Promissor
    • In the Books of Acceptor/ Promissor
  • Accounting Treatment of Forfeiture and Re-issue of Share  
2.2 Issue and Redemption of Debentures
  • Meaning of Debentures  
  • Distinction Between Shares and Debentures  
    • Ownership
    • Return
    • Repayment
    • Voting Rights
    • Security
    • Convertibility
  • Types of Debentures  
    • From the Point of view of Security
    • From the Point of view of Tenure
    • From the Point of view of Convertibility
    • From Coupon Rate Point of view
    • From the view Point of Registration
  • Issue of Debentures  
    • Issue of Debentures for Cash
    • Issue of Debentures at a Discount
    • Debentures issued at Premium
  • Over Subscription of Shares  
  • Issue of Debentures for Consideration Other than Cash  
    • To promoters
    • To underwriters
    • To vendors
  • Issue of Debentures as Collateral Security for a Loan  
  • Issue of Debentures with Terms of Redemption  
  • Interest on Debentures  
    • Interest on debentures (with TDS)
  • Writing off Discount/Loss on Issue of Debentures  
  • Redemption of Debentures  
    • Payment in lump sum
    • Payment in instalments
    • Purchase in the open market
    • By conversion into shares or new debentures
2.3 Financial Statements of a Company
  • Financial Statements of a Company  
    • Meaning of financial statements
    • Features of financial statements
    • Significance of financial statements
    • Limitations of financial statements
  • Nature of Financial Statements  
    • Recorded Facts
    • Accounting Conventions
    • Postulates
    • Personal Judgements
  • Role and Objectives of Financial Management  
  • Types of Financial Statements  
  • Uses and Importance of Financial Statements  
  • Limitations of Financial Statements  
2.4 Analysis of Financial Statements
  • Meaning of Analysis of Financial Statements  
  • Significance of Analysis of Financial Statements  
    • Finance manager
    • Top management
    • Trade payables
    • Lenders
    • Investors
    • Labour unions
    • Others
  • Objectives of Analysis of Financial Statements  
  • Tools of Analysis of Financial Statements  
    • Comparative Statements
    • Common Size Statements
    • Trend Analysis
    • Ratio Analysis
    • Cash Flow Analysis
  • Comparative Statements  
  • Common Size Statements  
  • Limitations of Financial Analysis  
2.5 Accounting Ratios
  • Concept of Accounting Ratios  
    • Meaning of Accounting Ratios
    • Objectives of Accounting Ratios
    • Classification and Computation of Accounting Ratios
  • Objectives of Ratio Analysis  
  • Advantages of Ratio Analysis  
    • Helps to understand efficacy of decisions
    • Simplify complex figures and establish relationships
    • Helpful in comparative analysis
    • Identification of problem areas
    • Enables SWOT analysis
    • Various comparisons
  • Limitations of Ratio Analysis  
    • Limitations of Accounting Data
    • Ignores Price-level Changes
    • Ignore Qualitative or Non-monetary Aspects
    • Variations in Accounting Practices
    • Forecasting
    • Means and not the End
    • Lack of ability to resolve problems
    • Lack of standardised definitions
    • Lack of universally accepted standard levels
    • Ratios based on unrelated figures
  • Types of Ratios  
    • Statement of Profit and Loss Ratios
    • Balance Sheet Ratios
    • Composite Ratios

    Liquidity Ratios

    • Current Ratio
    • Quick Ratio (Liquidity ratio)

    Solvency Ratios

    • Debt-Equity Ratio
    • Debt to Capital Employed Ratio
    • Proprietary Ratio
    • Total Assets to Debt Ratio
    • Interest Coverage Ratio

    Activity (or Turnover) Ratio

    • Inventory Turnover Ratio
    • Trade Receivables Turnover Ratio
    • Trade Payable Turnover Ratio
    • Net Assets or Capital Employed Turnover Ratio
    • Debtors Turnover Ratio
    • Working Capital Turnover Ratio
    • Fixed Assets Turnover
    • Current Assets Turnover

    Profitability Ratios

    • Gross Profit Ratio
    • Operating Ratio
    • Operating Profit Ratio
    • Net Profit Ratio
    • Return on Capital Employed or Investment
    • Return on Shareholders’ Funds
    • Earnings per Share
    • Book Value per Share
    • Dividend Payout Ratio
    • Price / Earnings Ratio
    • Return on Investment
    • Dividend per Share
    • Profit Earning Ratio
2.6 Cash Flow Statement
  • Concept of Cash Flow Statement  
    • Meaning of Cash Flow Statement
    • Objectives of Cash Flow Statement
    • Importance of Cash Flow Statement
    • Preparation of Cash Flow Statement
    • (as per AS3 (Revised) (Indirect Method only)
  • Benefits of Cash Flow Statement  
  • Cash and Cash Equivalents  
    • Cash
    • Bank
    • Short term investments
    • Marketable securities
  • Classification of Activities for the Preparation of Cash Flow Statement  
    • Cash from Operating Activities
    • Cash from Investing Activities
    • Cash from Financing Activities
    • Treatment of Some Peculiar Items
  • Ascertaining Cash Flow from Operating Activities  
    • Direct Method
    • Indirect Method
  • Ascertainment of Cash Flow from Investing and Financing Activities  
  • Preparation of Cash Flow Statement  
    • Adjustments related to depreciation,
    • Dividend and tax,
    • Sale and purchase of non-current assets (as per revised standard issued by ICAI)

CBSE Class 12 Accountancy Syllabus for Chapter 3: Accounting for Partnership Firms and Companies

3.1 Accounting for Partnership Firms
  • Meaning and Definitions of Partnership and Partnership Deed  
  • The Indian Partnership Act 1932  
  • Methods of Capital Accounts - Fixed and Fluctuating Capital Method  
  • Preparation of Profit and Loss Appropriation Account  
  • Division of Profit Among Partners  
  • Guarantee of Profits to a Partner  
  • Concept of Goodwill  
    • Meaning of Goodwill
    • Nature and Features of Goodwill
    • Factors Affecting the Value of Goodwill
    • Need for Valuation of Goodwill
    • Methods of Valuation of Goodwill
    1. Average Profits Method
    2. Super Profits Method
    3. Capitalisation Methods
    • Treatment of Goodwill
    1. Premium Method
    2. Revaluation Method
    3. Hidden Goodwill
  • Factors Affecting Goodwill  
  • Accounting for Partnership Firms - Reconstitution and Dissolution  
  • Change in the Profit Sharing Ratio Among the Existing Partners  
  • Admission of a Partner - Sacrifice Ratio and New Ratio  
  • Change in the Profit Sharing Ratio Among the Existing Partners - Treatment of Reserves and Accumulated Profits  
  • Accounting for Revaluation of Assets and Reassessment of Liabilities  
  • Preparation of Revaluation Account and Balance Sheet  
  • Effect of Admission of a Partner on Change in the Profit Sharing Ratio  
  • Admission of a Partner - Treatment of Goodwill  
  • Change in the Profit Sharing Ratio Among the Existing Partners - Gaining Ratio  
  • Admission of a Partner - Revaluation of Assets and Liabilities  
    • Meaning
    • Adjustment of accumulated Profits and Losses
    • Adjustment of Capitals
  • Admission of a Partner - Treatment of Reserves and Accumulated Profits  
  • Admission of a Partner - Adjustment of Capitals  
  • Admission of a Partner - Preparation of Balance Sheet  
  • Retirement and Death of a Partner - Effect of Retirement I Death of a Partner on Change in Profit Sharing Ratio  
  • Retirement Or Death of a Partner - Treatment of Goodwill  
  • Retirement or Death of a Partner - Revaluation of Assets and Liabilities  
  • Retirement Or Death of a Partner - Adjustment of Accumulated Profits and Reserves  
  • Retirement Or Death of a Partner - Adjustment of Capitals  
  • Retirement and Death of a Partner - Preparation of Balance Sheet  
  • Retirement Or Death of a Partner - Preparation of Loan Account of the Retiring Partner  
  • Calculation of Deceased Partner's Share of Profit Till the Date of Death  
  • Preparation of Deceased Partner's Capital Account, Executor's Account  
  • Dissolution of Partnership Firm  
  • Types of Dissolution of a Firm  
  • Dissolution of a Partnership Firm - Settlement of Accounts  
    • Settlement of accounts under Section 48 of The Indian Partnership Act 1932
  • Dissolution of a Partnership Firm - Preparation of Realization Account, and Other Related Accounts  
    • Capital accounts of partners
    • Cash and bank a/c (excluding piecemeal distribution, sale to a company and insolvency of partner(s)).
  • Past adjustments  
    • relating to interest on capital, interest on drawing, salary and profit sharing ratio
3.2 Accounting for Companies

CBSE Class 12 Accountancy Syllabus for Chapter 4: Financial Statement Analysis

4.1 Analysis of Financial Statements
  • Financial Statements of a Company  
    • Meaning of financial statements
    • Features of financial statements
    • Significance of financial statements
    • Limitations of financial statements
  • Statement of Profit and Loss and Balance Sheet in the Prescribed Form with Major Headings and Sub Headings  
  • Concept of Financial Statement Analysis  
    • Meaning of Financial Statement Analysis
    • Objectives of Financial Statement Analysis
    • Importance and Limitations of Financial Statement Analysis
    • Tools for Financial Statement Analysis
  • Comparative Statements  
  • Common Size Statements  
  • Cash Flow Analysis  
  • Ratio Analysis and its Types  
  • Concept of Accounting Ratios  
    • Meaning of Accounting Ratios
    • Objectives of Accounting Ratios
    • Classification and Computation of Accounting Ratios
  • Liquidity Ratios  

    Current Ratio: `"Current Assets"/"Current Liabilities"`

    Current Assets = Current Investments + Inventories (excluding Loose Tools and Spare Parts) + Trade Receivables + Cash and Bank Balance + Short-term Loans and Advances + Other Current Assets

    Current Liabilities = Short term borrowings + Trade payables + Other Current Liabilities + Short term Provisions.

    Quick Ratio / Liquid Ratio : `"Quick Assets"/"Current Liabilities"`

    Or

    `"All Current Assets- Inventories(excluding Loose Tools and Spare Parts)- Prepaid Expenses"/"Current Liabilities"`

    Or

    `"Liquid Assets"/"Current Liabilities"`

  • Solvency Ratios - Debt to Equity Ratio  

    Debt to Equity Ratio: `"Debt / Long Term Debt"/"Equity / Shareholders' Funds"`

    Debt = Long Term Borrowings + Long Term Provisions

    Equity / Shareholders’ Funds = Share Capital + Reserves and Surplus

    Or

    Non Current Assets + (Current Assets – Current Liabilities) - Non Current Liabilities

    = Non Current Assets + Working Capital- Non Current Liabilities

    = (Tangible Assets + Intangible Assets + Non Current Investments + Long Term Loans and Advances) +  Working Capital – (Long Term Borrowings + Long Term Provisions)

  • Solvency Ratios - Debt to Total Assets Ratio  

    Debt to Total Assets Ratio: Debt/Total Assets

  • Solvency Ratios - Proprietary Ratio  

    Proprietary Ratio: `"Shareholders Funds/ Equity"/"Total Assets"`

    Total Assets = Non Current Assets + Current Assets = Tangible Assets + Intangible Assets + Non Current Investments + Long Term Loans and Advances

    +

    Current Investments + Inventories (including Loose Tools and Spare Parts) + Trade Receivables + Cash
    and Bank Balance + Short-term Loans and Advances + Other Current Assets

  • Solvency Ratios - Interest Coverage Ratio  

    Interest coverage ratio = Net profit before interest and taxes/Interest

    Interest includes interest on only long term borrowings.

  • Activity Ratios - Inventory Turnover Ratio  

    Inventory Turnover Ratio = (Cost of Goods Sold /Cost of Revenue from Operation)/Average Inventory

    Cost of goods sold= Opening Stock + Net Purchases + Direct Expenses – Closing Stock

    Cost of Revenue from Operations = Revenue from Operations – Gross Profit

    Or

    Cost of Material Consumed (including direct expenses) + Change in inventories of WIP and Finished Goods

    Or

    Opening Inventory + Net Purchases+ Direct Expenses – Closing inventory

    Average Inventory = (Opening Inventory + Closing Inventory)/2

  • Activity Ratios - Trade Receivables Turnover Ratio  

    Trade Receivable Turnover Ratio: = Credit Revenue from Operation/Average Trade Receivable

    Credit Revenue from Operation = Revenue from Operation – Cash Revenue from Operation

    Average Trade Receivables = Opening Trade Receivable + Closing Trade Receivable/2

  • Activity Ratios - Trade Payables Turnover Ratio  

    Trade Payable Turnover Ratio: = Net Credit Purchases/Average Trade Payable

    Average Trade Payables = Opening Trade Payable + Closing Trade Payable  / 2

  • Activity Ratios - Working Capital Turnover Ratio  

    Working Capital Turnover Ratio = Revenue from Operations/Working Capital

  • Profltabtltty Ratios - Gross Profit Ratio  

    Gross Profit Ratio: `"Gross Profit"/"Revenue from Operations"xx100`

    Gross Profit = Revenue from Operations – Cost of Revenue from Operations/ Cost of Goods Sold
    Cost of Revenue from Operations = Cost of Material Consumed (including direct expenses) + Change in inventories of WIP and Finished Goods.

    Or

    Opening Inventory + Net Purchases + Direct Expenses – Closing inventory

  • Profitability Ratios - Net Profit Ratio  

    Net Profit Ratio = `"Net Profit"/"Revenue from Operations"xx100`

    Net Profit = Gross profit + Other Income – Indirect Expenses – Tax

     

     

  • Profitability Ratios - Operating Ratio  

    Operating Ratio =``

    Operating Expenses = Employee Benefit Expenses + Depreciation and Amortisation Expenses + Selling
    and Distribution Expenses+ Office and Administrative Expense

    Operating Income = Sale of scrap, trading commission received, cash discount received, revenue from services.

     

  • Profitability Ratios - Operating Profit Ratio  

    Operating Profit Ratio : ``

    Net operating profit = Net Profit after Tax+ Non-Operating Expenses – Non Operating Incomes

    Or

    Gross Profit – Operating Expenses + Operating Incomes

    Non Operating Expenses = Finance Cost (Interest on Borrowings) + Loss on sale of Non Current Assets

    Non Operating Incomes = Interest and Dividend Received on Investment + Profit on sale of Non Current Assets

  • Profitability Ratios - Earning per Share  

    `"Earning per share" = "Net Profit after Tax and Preference Dividend"/"No. of Equity Shares"`

     

  • Profitability Ratios - Price Earning Ratio  

    `"Price Earning Ratio" = "Market Value of an Equity share"/"Earning per share"`



  • Profitability Ratios - Return on Investment  

    Return on Investment = `"Net Pr ofit before Interest and Tax"/"Capital Employed"xx100`

4.2 Cash Flow Statement

CBSE Class 12 Accountancy Syllabus for Chapter 5: Accountancy : Computerised Accounting System

1 Overview of Computerised Accounting System
  • Introduction to Computerised Accounting System  
  • Computerised Accounting System  
    • Basic flow of Accounting Transaction
    • Data and Information
  • Components of Computerised Accounting System  
  • Features of Computerised Accounting System  
    1. Simple and Integrated
    2. Transparency and Control
    3. Accuracy and Speed
    4. Scalability
    5. Reliability
  • Grouping of Accounts  
    • Accounting Equation
    1. Equity and Liabilities
      i. Shareholder’s Funds
    2. Assets
      i. Non-Current Assets
      ii. Current Assets
    3. Revenues
    4. Expenses
    • Codification of Accounts  
      • Method of Codification
        1. Sequential Codes 
        2. Block Codes 
        3. Mnemonic Codes 
    • Methodology to Develop Coding Structure and Coding  
  • Using Software of Computerised Accounting System  
    • Security features of CAS Software
      i. Password Security
      ii.  Data Audit
      iii. Data Vault
  • Advantages of Computerised Accounting System  
  • Limitations of Computerised Accounting System  
  • Accounting Information System (AIS)  
    1.  Cash and Bank Sub-System
    2. Sales and Accounts Receivable Sub-System
    3.  Inventory Sub-System
    4.  Purchase and Accounts Payable Sub-System
    5. Payroll Accounting Sub-System
    6. Fixed Assets Accounting Sub-System
    7.  Expense Accounting Sub-System
    8. Tax Accounting Sub-System
    9. Final Accounts Sub-System
    10. Costing Sub-System
    11. Budget Sub-System
    12. Management Information System 
  • Structure of Computerised Accounting System  
  • Computerised Accounting System (CAS) - Software Packages  
    • Generic
    • Specific
    • Tailored.
    • Features of computerised accounting system
    • Components of Computerised Accounting System
  • Steps in Installation of CAS (Computerised Accounting System)  
  • Codification and Hierarchy of Account Heads  
  • Using Computerized Accounting System - Creation of Accounts  
  • Using Computerized Accounting System  
    • Adjusting entries, Preparation of financial statements, preparation of balance sheet, profit and loss account with closing entries and opening entries.
  • Need and Security Features of the Computerized Accounting System  
    • Security of CAS and Security features are generally available in CAS
2 Spreadsheet
  • Introduction to Spreadsheet  
  • Basic Concepts of Spreadsheet  
    • Labels  
    • Formulas  
      • cell reference
      • nested conditional (what-if scenario) if scenario)
      • order of mathematical (expression) operations rules
      • spreadsheet
    • Functions  
      • = FunctionName(Data), range of cells, SUM or AutoSum (Σ), Naming Ranges – IF Functions – Nested IF Functions, Naming Cells and Ranges, Numbers Numbers,  = SUMIF (Numbers,”<6), IF (logical_test, value_if_ture, value_if_false), logical_test,  value_if_true, value_if_false, = IF (AVERAGE (A2:A6) > 10, SUM (B2:B6), 0), = IF (logical_test, value_if_true, value_if_false)
    • Other Useful Functions  
  • Other Useful Functions  
    • Date and Time Function  
      • TODAY () , NOW () , DAY (serial_number), DATEVALUE (date_text)
    • Mathematical Function  
      • SUMIF (range, criteria, sum_range), ROUND (number, num_digits) and COUNT
    • Text Manipulation Function  
      • Text, Concatenate
    • Logical Function  
      • AND, OR
    • Lookup and References Function  
      • LOOKUP (Vector Form), LOOKUP (Array Form), VLOOKUP, HLOOKUP
    • Financial Functions  
      • ACCRINT, CUMIPMT, PV, FV, PMT, RATE and NPV 
  • Data Entry, Text Management and Cell Formatting  
  • Data Entry  
    • The data fill options
    • Import/Copy Data from other sources
  • Data Validation  
  • Data Validation Form  
  • Data Formatting  
    • Formatting Tools 
  • Output Reports  
    • Defining the Print Area 
  • Preparation of Reports Using Pivot Table  
    • One-Variable Data Table
    • Two-Variable Data Table 
    • Pivot Tables 
  • Advantages of Pivot Table (Report)  
  • Common Errors (Messages) in Spreadsheet  
    • Mark Common Formula Errors
  • Data Representation - Graphs, Charts and Diagrams  
  • Concept of Electronic Spreadsheet (ES)  
  • Features Offered by Electronic Spreadsheet  
  • Using Computerised Accounting System - Data  
    • Data entry, Data validation, and Data verification
3 Use of Spreadsheet in Business Applications
  • Introduction to Use of Spreadsheet in Business Application  
  • Payroll Accounting  
  • Payroll Components  
    • Current payroll period (Month and Year)
    • Earnings 
      Basic Pay (BP), Grade Pay (GP), Dearness Pay (DP), Dearness Allowance (DA), House Rent Allowance (HRA), Transport Allowance (TRA), Any Other Earning
    • Deductions 
      Professional Tax (Applicable in some states) (PT), Provident Fund (PF), Tax Deduction at Source (TDS), Recovery of Loan Instalment (LOAN), Any Other Deduction
  • Elements Used in Payroll Calculation  
    • Basic Pay Earned (BPE), Dearness Allowance (DA), Transport Allowance (TRA), Total Earnings (TE), Provident Fund (PF), Tax Deduction at Source (TDS), Recovery of Loan Instalments (LOAN), Total Deductions (TD), Net Salary (NS) = Total Earnings (TE) – Total Deductions (TD) Net Salary (NS) = Total Earnings (TE) – Total Deductions (TD)
    • Template Design  
  • Asset Accounting  
  • Introduction to Asset Accounting  
  • Computerised Asset Accounting  
    • Straight Line Method  
    • Written Down Value (WDV) Method  
    • Schedule Forming Part of the Balance Sheet  
  • Loan Repayment Schedule  
    • Loan 
    • Calculating Interest and Repayments of Loan
  • Application in Generating Accounting Information - Bank Reconciliation Statement  
  • Application in Generating Accounting Information - Asset Accounting  
  • Application in Generating Accounting Information - Loan Repayment of Loan Schedule  
  • Application in Generating Accounting Information - Ratio Analysis  
4 Graphs and Charts for Business Data
  • Introduction to Graphs and Charts for Business Data  
  • Graphs and Charts  
  • Basics Steps for Graphs/Charts/Diagrams Using Excel  
  • Elements of a Chart/Graph  
    • The chart area, The plot area, The data points, The horizontal (category) and vertical (value) axis, The legend, A chart and axes titles, A data label
  • Formatting of Chart  
    • Formatting the Chart (using design option)
    • Changing the format of a selected chart element
    • Changing the layout of the chart element
  • Change the Chart Type  
  • Resizing of Chart/Graph  
  • 2D - 3D Charts/Graphs  
  • Advantages in Using Graph/Chart  
    • Help to Explore, Help to Present, Help to Convince
5 Data Base Management System for Accounting
  • Introduction Data Base Management System for Accounting  
  • Database Management System Software (DBMS)  
  • Features of Database Management System (DBMS)  
    • A conceptual understanding of the basic features of the Data Base Management System (DBMS), i.e. data update and retrieval using basic functions and commands of SQL.
    • Basic Commands: Select, Where, And, Or, Update, Delete and
    • Basic Functions: Avg, Count, Max, Min, Sum.
  • Understanding and Defining the Database Requirement  
  • Identification of Data to Be Stored in Tables  
  • Logical Structuring of Data in Tables  
  • Creating Database Tables in Microsoft Access  
  • Creation of Query in Microsoft Access  
  • Creation of Forms in Microsoft Access  
  • Creation of Reports in Microsoft Access  
Advertisements
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×