NCERT Class 12 Accountancy Computerised Accounting System: Chapter 3 — USE OF SPREADSHEET IN BUSINESS APPLICATIONS
This chapter, "Use of Spreadsheet in Business Applications," from NCERT Class 12 Accountancy's Computerised Accounting System book, focuses on applying spreadsheet software like Excel for various business functions. It builds upon previous knowledge of spreadsheet features, detailing their use in Payroll Accounting, Asset Management, and Loan Repayment. The chapter elaborates on computing employee salaries, including gross salary calculation, deductions, and preparing payroll statements. It breaks down payroll components like Basic Pay, Grade Pay, Dearness Allowance, HRA, and TRA, alongside deductions such as Professional Tax, Provident Fund, and TDS. This chapter equips students with practical skills in using spreadsheets for efficient financial record-keeping and analysis, crucial for CBSE curriculum.
Quick info
| Board | CBSE / NCERT |
|---|---|
| Class | Class 12 |
| Subject | Accountancy |
| Book | Computerised Accounting System |
| Chapter | Chapter 3 — USE OF SPREADSHEET IN BUSINESS APPLICATIONS |
| Language | English |
| PDF type | NCERT Textbook |
| Session | CBSE 2026 |
| Reading time | 3 minutes |
| Word count | 565 |
Learning outcomes
- Understand the application of spreadsheets in business, specifically for payroll accounting.
- Identify and compute various components of employee earnings (Basic Pay, DA, HRA, etc.).
- Recognize and calculate statutory and other deductions (PT, PF, TDS).
- Learn how spreadsheets facilitate payroll computations and statement preparation.
- Gain insights into using spreadsheets for asset management and loan repayment calculations.
Vocabulary
| Word | Meaning |
|---|---|
| Payroll Accounting | The process of managing and recording all aspects of employee salary payments. |
| Basic Pay (BP) | The pay in the pay scale plus Grade Pay, excluding Special Pay. |
| Grade Pay (GP) | Pay added to Basic Pay based on employee designation and pay band/scale. |
| Dearness Pay (DP) | A portion of Dearness Allowance merged with Basic Pay. |
| Dearness Allowance (DA) | Compensation for price rise, calculated as a percentage of Basic Pay + Dearness Pay. |
| House Rent Allowance (HRA) | An allowance paid to employees to help with accommodation costs. |
| Transport Allowance (TRA) | An allowance to cover commuting expenses to the workplace. |
| Professional Tax (PT) | A statutory deduction levied by state governments. |
| Provident Fund (PF) | A statutory deduction for social security, computed as a percentage of Basic Pay + Dearness Pay. |
| Tax Deduction at Source (TDS) | A statutory deduction made monthly towards an employee's Income Tax liability. |
The complete chapter text is read in the official NCERT PDF viewer below (streamed from ncert.nic.in). This page provides NCERT Help study material — summary, vocabulary, practice questions, and FAQs — not a full reproduction of the textbook.
Read chapter online
This PDF is loaded from the official NCERT website (ncert.nic.in). Use the page buttons below to read — download is disabled on NCERT Help.
Read page by page below. PDF is streamed from the official NCERT website — no download button on this page.
Practice questions
- What is the primary purpose of Payroll Accounting? Answer: To manage and record all aspects of employee salary payments accurately and efficiently.
- Define Basic Pay (BP) and Grade Pay (GP). Answer: Basic Pay is the core salary plus Grade Pay. Grade Pay is added based on the employee's designation and pay scale.
- What is Dearness Allowance (DA) intended to compensate for? Answer: DA is intended to compensate for the erosion in the purchasing power of wages due to price rises.
- List three types of deductions mentioned in the chapter. Answer: Professional Tax (PT), Provident Fund (PF), and Tax Deduction at Source (TDS).
- How is Provident Fund (PF) typically computed? Answer: PF is computed as a percentage of (Basic Pay + Dearness Pay, if applicable).
Practice MCQs
Q1. Which of the following is NOT considered an earning component for an employee?
Explanation: Professional Tax is a statutory deduction, not an earning component for the employee.
Q2. What does TDS stand for in the context of payroll deductions?
Explanation: TDS refers to Tax Deduction at Source, a statutory deduction made monthly towards Income Tax liability.
Q3. Dearness Allowance (DA) is usually calculated as a percentage of:
Explanation: DA is granted as a percentage of Basic Pay plus Dearness Pay, if applicable.
Q4. Which allowance helps an employee with accommodation costs?
Explanation: House Rent Allowance (HRA) is paid to facilitate employees in acquiring residential accommodation.
Q5. Provident Fund (PF) is primarily a deduction for:
Explanation: Provident Fund (PF) is a statutory deduction considered part of social security.
Frequently asked questions
What is the main objective of studying the 'Use of Spreadsheet in Business Applications' chapter?
The chapter aims to teach students how to use spreadsheet software like Excel for practical business applications such as payroll accounting, asset management, and loan repayment.
What are the key components of an employee's salary computation discussed in the chapter?
The chapter discusses earnings like Basic Pay, Grade Pay, Dearness Pay, Dearness Allowance, HRA, TRA, and deductions like Professional Tax, PF, and TDS.
How does a spreadsheet help in payroll accounting?
Spreadsheets automate calculations for earnings and deductions, help prepare salary statements and slips, and generate bank advice for salary transfers.
What is the difference between Dearness Pay (DP) and Dearness Allowance (DA)?
Dearness Pay is a portion of DA that has been merged with the Basic Pay, while Dearness Allowance is a separate compensation for price rise granted periodically.
What is Tax Deduction at Source (TDS) in payroll?
TDS is a statutory deduction made monthly from an employee's salary, which is an advance payment towards their annual Income Tax liability.
Besides payroll, what other business applications of spreadsheets are covered?
The chapter also briefly mentions the application of spreadsheets for Asset Management and Loan Repayment calculations.
Related resources
Important topics
Topics covered
NCERT Class 12 Accountancy — Computerised Accounting System — Chapter 3 — USE OF SPREADSHEET IN BUSINESS APPLICATIONS. Verified by NCERT Help Editorial Team. Reviewed on 29 Jul 2026. Last updated 10 Aug 2026.