Accountancy · Class 12 · Computerised Accounting System · 4.º Período
Accounting Application of Electronic Spreadsheet
Using spreadsheets for accounting applications like loan repayment schedules and payroll accounting. Focus on basic formulas and financial functions.
CBSE Learning OutcomesCBSE Class 12 Accountancy, Part C: Computerised Accounting, Unit 4: Accounting Applications of Electronic Spreadsheet - Concept of electronic spreadsheet, Features offered by electronic spreadsheetCBSE Class 12 Accountancy, Part C: Computerised Accounting, Unit 4: Accounting Applications of Electronic Spreadsheet - Application in generating accounting information: bank reconciliation statement, asset accounting, loan repayment of loan schedule
About This Topic
Using spreadsheets for accounting applications like loan repayment schedules and payroll accounting. Focus on basic formulas and financial functions.
Key Questions
- How can spreadsheets be used to calculate depreciation?
- What functions are used for payroll preparation?
- How do we create a loan repayment schedule in Excel?
More in Computerised Accounting System
Overview of Computerised Accounting System
Concept, features, and structure of a Computerised Accounting System (CAS). Comparison between manual and computerised accounting processes.
2 methodologies
Using Computerized Accounting Software
Practical application of accounting software for recording transactions and generating reports. Steps for creating a company, ledgers, and voucher entries.
2 methodologies