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.
CBSE Class 12 Accountancy Revised Syllabus
CBSE Class 12 Accountancy and their Unit wise marks distribution
CBSE Class 12 Accountancy Course Structure 2025-26 With Marking Scheme
Advertisements
Advertisements
Advertisements
Syllabus
CBSE Class 12 Accountancy Syllabus for Chapter 1: Accountancy I : Not-for-profit Organisation and Partnership Accounts
- 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
- Specific Donations
- 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
- 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
- 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
- Average Profits Method
- Super Profits Method
- Capitalisation Methods
- Treatment of Goodwill
- Premium Method
- Revaluation Method
- 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
- Average Profits Method
- Super Profits Method
- Capitalisation Method
- Multiplier Method
- Treatment of Goodwill
- Premium Method
- Revaluation Method
- Hidden Goodwill
- 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
- Average Profits Method
- Super Profits Method
- Capitalisation Methods
- Treatment of Goodwill
- Premium Method
- Revaluation Method
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Cash
- 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
- 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
- Average Profits Method
- Super Profits Method
- Capitalisation Methods
- Treatment of Goodwill
- Premium Method
- Revaluation Method
- 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
- Accounting for Companies - Introduction
- Theory on Shares
- Types of Shares - Preference Shares Equity Shares
- preference shares
- equity shares
- Accounting for Share Capital
- Public Issue of Shares
- Basic Accounting Entries for Issue of Shares
- Issue of Shares at Par, Premium and Discount
- Oversubcription and Undersubscription of shares
- Calls in Arrears and Calls in Advance
- Issue of Shares for Consideration other than cash
- Nature and Types of Share and Share Capital
- Share Capital - Issue and Allotment of Equity Shares
- Employee Stock Option Plan (ESOP)
- Private Placement of Shares
- Public Subscription of Shares
- Over Subscription of Shares
- Under Subscription of Shares
- Issue at Par and Premium and at Discount
- Calls in Advance and Arrears
- Issue of Shares for Consideration Other than Cash
- Accounting Treatment of Forfeiture and Re-issue of Share
- Pro-rata Allotment
- Disclosure of Share Capital in Company’s Balance Sheet (Horizontal Form)
- Concept of Private Placement
- Meaning and Concept of Debentures
- Issue of Debentures at Par at Premium and at Discount
- Issue of debentures at par, at premium and at discount under Companies Act 2013.
- Issue of Debentures for Consideration Other than Cash
- To promoters
- To underwriters
- To vendors
- Issue of Debentures with Terms of Redemption
- Issue of Debentures as Collateral Security for a Loan
- Interest on Debentures
- Interest on debentures (with TDS)
- Redemption of Debentures for Immediate Cancellation - Draw of Lots, Lump Sum and Purchase in the Open Market
- Creation of Debenture Redemption Reserve
- Accounting for Debentures - Conversion Method
- Meaning of Redemption of Debentures
CBSE Class 12 Accountancy Syllabus for Chapter 4: Financial Statement Analysis
- 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 ExpenseOperating 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`
CBSE Class 12 Accountancy Syllabus for Chapter 5: Accountancy : 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
- Simple and Integrated
- Transparency and Control
- Accuracy and Speed
- Scalability
- Reliability
- Grouping of Accounts
- Accounting Equation
- Equity and Liabilities
i. Shareholder’s Funds - Assets
i. Non-Current Assets
ii. Current Assets - Revenues
- Expenses
- Codification of Accounts
- Method of Codification
1. Sequential Codes
2. Block Codes
3. Mnemonic Codes
- Method of Codification
- 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
- Security features of CAS Software
- Advantages of Computerised Accounting System
- Limitations of Computerised Accounting System
- Accounting Information System (AIS)
- Cash and Bank Sub-System
- Sales and Accounts Receivable Sub-System
- Inventory Sub-System
- Purchase and Accounts Payable Sub-System
- Payroll Accounting Sub-System
- Fixed Assets Accounting Sub-System
- Expense Accounting Sub-System
- Tax Accounting Sub-System
- Final Accounts Sub-System
- Costing Sub-System
- Budget Sub-System
- 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
- 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
- Date and Time Function
- 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
- 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
- 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
- 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