NCERT Book Class 12 Accountancy Computerised Accounting Use Of Spreadsheet In Business Applications

Accountancy
Download PDF

Official NCERT Book for Class 12 Accountancy: Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications

Explore the complete NCERT textbook for Class 12 Accountancy. Tailored for the 2026-27 curriculum, this resource breaks down complex topics to help students prepare effectively for school examinations.

Chapter-wise Study Material: Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications

View or download the dedicated Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications resource below. This chapter-by-chapter structuring ensures easy navigation for daily study routines. For comprehensive exam preparation, pair this reading with our verified NCERT Solutions.

INTRODUCTION
 
In the previous chapter, we have learned about the spreadsheet and its several features that can be used in business applications. In this chapter, we shall discuss the applications of spreadsheet (using Excel) to Payroll Accounting and some other select applications (Asset Management, and Loan Repayment).
 
3.1 PAYROLL ACCOUNTING

Every employee is paid salary on a pre-determined date within the framework of employee contract and related personnel policy in force from time to time in an organisation.
The computation of salary payment is based on the number of days an employee has worked, rate per grade of pay, rate of applied allowances and deductions to be made therefrom.
The preparation of salary bill should provide for the following :
• Maintaining payroll related data such as Employee No., Name, Attendance, Basic Pay, applicable Dearness and other Allowances, deductions to be made.
• Periodic payroll computations: the payroll computation includes the calculation of various earning and deduction heads, which are to be derived from basic values (such as basic salary, number of days under leave without pay (LWP) and unauthorised absence, etc) as per the formulae.
• Preparation of salary statement and employees salary slips
• Generation of advice to bank: It contains the net salary to be transferred to individual bank account of employees and other salary related statutory payments such as provident fund, tax, etc.
 
3.1.1 PAYROLL COMPONENTS
Every employee is under contractual relationship of service with an organisation, and is paid salary accordingly. The following elements are important for salary computation and its payment:
• CURRENT PAYROLL PERIOD (MONTH AND YEAR)
• EARNINGS
• Basic Pay (BP) : It is the pay in the pay scale plus Grade Pay, but does not include Special Pay.
• Grade Pay (GP) : It is the pay to be added to the Basic Pay according to the Designation of the employee and applicable pay band or scale of pay.
• Dearness Pay (DP) : It is that portion of Dearness Allowance, which has been declared and deemed to have been merged with the Basic Pay.
• Dearness Allowance (DA) : It is a compensation for erosion in the purchasing power of wage earner due to price rise. It is granted by the Government periodically as a percentage of (Basic Pay +Dearness Pay, if applicable).



Click on the below link to download NCERT Class 12 Accountancy Computerised Accounting Use Of Spreadsheet In Business Applications

Free study material for Accountancy

NCERT Book for Class 12 Accountancy Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications

NCERT Book Class 12 Accountancy Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications

Access the official NCERT Textbook for Class 12 Accountancy Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications, updated for the current academic session. Recognized as the core reading material across schools nationwide, board evaluations rely entirely on this syllabus.

Access NCERT English Medium Textbooks

Explore our exhaustive library of NCERT books in English Medium spanning all subjects in Class 12. Every chapter features comprehensive explanations followed by extensive end-of-chapter exercises.

Enhance Learning with Official Textbooks

The Class 12 Accountancy Computerised Accounting System Chapter 03 Use Of Spreadsheet In Business Applications text is carefully engineered to build rock-solid foundational concepts. For an enriched academic journey, learners should pair this with our online NCERT Solutions and revision notes.

FAQs

Where can I download the latest NCERT Book Class 12 Accountancy Computerised Accounting Use Of Spreadsheet In Business Applications in PDF for 2026-27?

You can download the latest, teacher-verified PDF for NCERT Book Class 12 Accountancy Computerised Accounting Use Of Spreadsheet In Business Applications for free on StudiesToday.com. These digital editions are updated as per 2026-27 session and are optimized for mobile reading.

Does this Accountancy book follow the latest NCERT rationalized syllabus?

Yes, our collection of Class 12 Accountancy NCERT books follow the 2026 rationalization guidelines. All deleted chapters have been removed and has latest content for you to study.

Why is it better to download NCERT Book Class 12 Accountancy Computerised Accounting Use Of Spreadsheet In Business Applications chapter-wise?

Downloading chapter-wise PDFs for Class 12 Accountancy allows for faster access, saves storage space, and makes it easier to focus in 2026 on specific topics during revision.

Are these NCERT books for Class 12 Accountancy sufficient for scoring 100%?

NCERT books are the main source for NCERT exams. By reading NCERT Book Class 12 Accountancy Computerised Accounting Use Of Spreadsheet In Business Applications line-by-line and practicing its questions, students build strong understanding to get full marks in Accountancy.