Use Of Spreadsheet In Business Applications — Chapter Summary
NIOS · Class 12 · Accountancy
Summary of Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy. Part of the NIOS Class 12 Accountancy syllabus.
Interactive on Super Tutor
Studying Use Of Spreadsheet In Business Applications? Get the full interactive chapter.
Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for chapter summary and more.
Free trial, no card needed.
Overview
Notice how a spreadsheet helps organize two major business tasks in accounting: payroll accounting and depreciation accounting. It brings formulas, calculations, and records into one system, so salary details and asset values can be handled more quickly and more accurately. Count the main ideas care
Key Concepts
Use of computers for maintaining
Use of computers for maintaining the records salary of employees is known as payroll accounting. Payroll is an accounting statement that shows the sal
Earnings include Basic Pay
Earnings include Basic Pay, Grade Pay, Dearness Pay, Dearness Allowance, House Rent Allowance, Transport Allowance, and any other earning. Deductions
Basic Pay Earned is the Basic
Basic Pay Earned is the Basic Pay calculated with reference to Number of Effective Days Present during the month. The formula is BPE = BP × NOEDP/NODM
Gross salary consists of Basic Pay
Gross salary consists of Basic Pay and various allowances. Net salary is the difference between gross salary and deductions.
DA = BPE × Rate
DA = BPE × Rate of DA, HRA = BPE × Rate of HRA, TRA may be fixed or percentage based, TE = BPE + DA + HRA + TRA, PF = BPE × PF Rate, TD = PF + TDS + L
Learning Objectives
- State the meaning of payroll accounting
- Explain the components of payroll
- State the meaning of depreciation
- Explain the methods of depreciation
- Compute annual depreciation with the help of a computer
Frequently Asked Questions
What are the important topics in Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy?
How should I revise Use Of Spreadsheet In Business Applications for the NIOS Class 12 board exam?
Sources & Official References
Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.
More resources for Use Of Spreadsheet In Business Applications
Practice Quiz
Test yourself with a quick quiz
Important Questions
Exam-style questions with answers
Revision Notes
Key points for last-minute revision
Formula Sheet
The chapter's formulas in one place
Concept Maps
See how topics connect
Study Plan
Step-by-step plan for this chapter
Flashcards
Quick-fire cards for active recall
Syllabus
What topics to cover
For serious students
Get the full Use Of Spreadsheet In Business Applications chapter — start free.
Quizzes, flashcards, an AI doubt solver and a study plan for NIOS Class 12 Accountancy. Free to start, no card needed.