Components and Architecture of Computerized Accounting Systems

3.1 Five Components

A computerized accounting system has five core components:

1. Hardware: Computers, servers, network devices, printers, scanners, and UPS backup support data entry, processing, and reporting.
2. Software: Accounting applications such as Tally, SAP, and QuickBooks operate with the operating system and database management system.
3. Data: The system stores the chart of accounts, customer and supplier master records, transaction entries, and historical financial data.
4. People: Data entry operators, accountants, system administrators, and internal auditors use and supervise the system.
5. Procedures: Data entry protocols, authorization rules, backup routines, and audit trail maintenance ensure accuracy and control.

3.2 Database Architecture

Modern accounting software uses Relational Database Management Systems (RDBMS):

Database Component	Role in Accounting
Tables	Store data in rows and columns (e.g., Ledger table, Voucher table)
Primary Key	Unique identifier for each record (e.g., Invoice Number)
Foreign Key	Links related tables (e.g., Customer ID in Invoice table links to Customer master)
Queries	SQL commands to extract specific reports (e.g., all transactions for a specific ledger)
Indexes	Speed up search operations
Views	Pre-defined query outputs (e.g., Outstanding Debtors view)

Common databases used: MySQL (open-source), Microsoft SQL Server (Tally backend), Oracle Database (SAP, Oracle ERP), PostgreSQL.

---