Application of Information and Communication Technology (ICT) in Book-Keeping
This concluding 21st-century module bridges traditional bookkeeping with modern digital financial management. Students explore computerized accounting systems, comparing manual ledgers with computerized software packages. Learners investigate common accounting software used in Tanzania and East Africa (such as TallyPrime, QuickBooks, Sage, and electronic spreadsheets like Microsoft Excel). Students learn how to configure a digital Chart of Accounts, input transactions via digital templates, execute automated ledger posting, generate instant trial balances and financial statements, and maintain data security through encryption and cloud backups.
🎯 Syllabus Competencies & Learning Objectives
Key Competencies
- Main Competence: 2.0 Demonstrate mastery of the use of ICT in Book-keeping
- Specific Competence: 2.1 Use basic accounting packages
Specific Learning Objectives
- Explain the concepts, advantages, and limitations of Computerised Accounting Systems (CAS).
- Compare manual accounting systems with computerized accounting packages.
- Identify common accounting packages (Tally, QuickBooks, Sage, Excel) and their core operational modules.
- Demonstrate setting up a company profile, chart of accounts, and entering transactions in software templates.
- Generate, analyze, and interpret electronic financial reports (Trial Balance, Income Statement, Balance Sheet) and implement digital data backup procedures.
📖 Comprehensive Study Notes Summary
**Allocated Periods: 10**
#### 1. Manual vs. Computerised Accounting Systems (CAS)
| Feature | Manual Accounting | Computerised Accounting (CAS) |
| :--- | :--- | :--- |
| **Speed & Efficiency** | Slow; manual calculations and posting | Instantaneous processing and automatic posting |
| **Accuracy** | High risk of arithmetic and transposition errors | Arithmetic errors eliminated; automatic debit=credit balance |
| **Data Storage & Volume**| Bulky paper ledgers requiring large storage space| Vast data stored securely in hard drives or cloud servers |
| **Financial Reporting**| Takes days/weeks at year-end to compile statements| Financial statements generated instantaneously at the click of a button |
| **Cost of Setup** | Low initial cost (paper books and pens) | Higher initial cost (computers, software licenses, staff training) |
| **Vulnerability** | Physical damage (fire, water, insects, theft)| Cyber threats, power failure, system crashes (mitigated by backups) |
#### 2. Architecture of Accounting Software
- **Core Modules**:
1. *General Ledger*: The master database holding the Chart of Accounts and journal entries.
2. *Accounts Receivable (Sales Ledger)*: Invoicing customers, tracking credit sales, monitoring overdue debts.
3. *Accounts Payable (Purchases Ledger)*: Managing supplier invoices, purchase orders, and payment scheduling.
4. *Inventory Control*: Tracking stock levels, cost of goods, reorder levels, and automated stock valuations.
5. *Cash & Bank Management*: Bank reconciliation modules, automated electronic payment matching.
6. *Payroll Module*: Calculating employee gross pay, statutory deductions (PAYE, NSSF, NHIF), and net pay.
#### 3. Operating Procedure in an Accounting Package
1. **Company Configuration**: Entering company name, legal status, financial year-end date, base currency (TZS), and tax settings (TRA TIN and VRN).
2. **Setting up the Chart of Accounts (CoA)**: Creating coded account heads (e.g., `1000 - Assets`, `2000 - Liabilities`, `3000 - Equity`, `4000 - Revenue`, `5000 - Expenses`).
3. **Transaction Entry via Digital Vouchers**:
- *Payment Voucher*: For bank/cash payments.
- *Receipt Voucher*: For customer payments received.
- *Sales Invoice*: For billing credit clients.
- *Journal Voucher*: For adjustments, opening entries, and corrections.
4. **Automated Report Generation**: Generating General Ledger reports, Aged Debtors Analysis, Trial Balance, Income Statement, and Balance Sheet with zero manual computation.
#### 4. Data Security and Internal Controls in CAS
- **User Authorization & Access Levels**: Restricting access through role-based permissions (e.g., cashiers can only enter sales; only the Chief Accountant can approve adjusting journals).
- **Audit Logs / Audit Trails**: Automatic, tamper-proof system logs recording the exact date, time, user identity, and terminal for every single entry, modification, or deletion.
- **Data Backup Strategies**: Maintaining regular automated backups on external drives, off-site servers, and encrypted cloud storage to protect against ransomware and hardware failure.
💡 Key Concepts & FAQs (Exam Questions)
Q: What does GIGO stand for in computerized accounting?
Answer: Garbage In, Garbage Out—meaning if incorrect data is entered into software, the resulting reports will also be incorrect.
Q: What is a Chart of Accounts (CoA)?
Answer: A structured, coded list of all account headings used by an organization to categorize financial transactions in its ledger.
Q: What is an Audit Trail in accounting software?
Answer: An automated, tamper-proof log recording who entered, edited, or deleted any transaction, with timestamps and user details.
Q: Name three common accounting software packages used in business.
Answer: TallyPrime, QuickBooks, Sage, and Microsoft Excel spreadsheets.