Skip to main content
Chapter 36 of 38
Revision Notes

Use Of Spreadsheet In Business Applications — Revision Notes

NIOS · Class 12 · Accountancy

Use Of Spreadsheet In Business Applications revision notes for NIOS Class 12 Accountancy: 4 topics in quick points.

87 questions38 flashcards7 formulas & key relations5 concepts

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 revision notes and more.

Free trial, no card needed.

Key Topics to Revise

1

Payroll Accounting

  • Payroll accounting means using computers to maintain employee salary records.
  • Payroll is an accounting statement that shows salary payable to each employee, gross salary, deductions, and net amount payable.
  • Salary is usually specified on a monthly basis.
2

Payroll Components

  • Earnings include Basic Pay, Grade Pay, Dearness Pay, Dearness Allowance, House Rent Allowance, Transport Allowance, and any other earning.
  • Deductions include Professional Tax, Provident Fund, TDS, Loan recovery, and any other deduction.
  • Basic Pay is the pay in the pay scale plus Grade Pay, but it does not include Special Pay.
3

Payroll Calculation Elements

  • Basic Pay Earned is Basic Pay calculated with reference to Number of Effective Days Present during the month.
  • NOEDP equals number of days in a month minus leave without pay minus unauthorised absence.
  • DA and HRA are calculated on Basic Pay Earned using applicable monthly rates.
4

Depreciation

  • Depreciation is an allocation of the depreciable cost of a non-current asset over its useful life.
  • Depreciation is a process of cost allocation based on useful life, scrap value, and cost of asset put to use.
  • Only items that lose useful value over time can be depreciated except freehold land whose value generally does not decrease.

Get complete notes with diagrams and examples

Full Notes

Key Concepts

Use of computers for maintainingEarnings include Basic PayBasic Pay Earned is the BasicGross salary consists of Basic PayDA = BPE × Rate

Frequently Asked Questions

What are the important topics in Use Of Spreadsheet In Business Applications for NIOS Class 12 Accountancy?
Key topics in Use Of Spreadsheet In Business Applications include Payroll Accounting, Payroll Components, Payroll Calculation Elements, Depreciation. Study these first, then practise questions on each for the NIOS Class 12 board exam.
How should I revise Use Of Spreadsheet In Business Applications for the NIOS Class 12 board exam?
Learn the core ideas first, then work through the 87 practice questions on Use Of Spreadsheet In Business Applications. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

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.