Lesson

Computerised Accounting System and Accounting Database & Reports

Learn how accounting software records transactions, stores data, and creates reports like Ledger, Trial Balance, Profit and Loss, and Balance Sheet.

Understand computerised accounting, vouchers, accounting databases, tables, records, fields, reports, benefits, and risks in a simple way.

Beginner12-15 min

Concept explanation

Understand the idea first

What is a Computerised Accounting System?

A computerised accounting system is a system where accounting transactions are recorded, stored, processed, and reported using accounting software.

In manual accounting, we write entries in books.

In computerised accounting, we enter transactions into software, and the software prepares ledgers and reports.

Example: Riya Stationery Shop sells notebooks for Rs.5,000 cash.

In a manual system, Riya writes the journal entry, posts it to ledger, prepares trial balance, and then prepares final accounts.

In a computerised system, Riya enters one sales transaction, and the software updates sales, cash, ledger, trial balance, and reports automatically.

Simple line: Computerised accounting means using software to record and process accounting transactions.

Simple story

Riya runs a stationery shop.

Earlier, she used notebooks to record cash sales, credit sales, purchases, payments, receipts, and expenses.

At month-end, she spent many hours preparing ledger accounts, trial balance, profit and loss, and balance sheet.

Later, she started using accounting software.

Now when she enters one transaction, the software saves the transaction, updates related accounts, prepares ledger reports, updates trial balance, and helps prepare profit and loss and balance sheet.

This saves time, but Riya still needs to know which accounts are affected.

Simple line: Computerised accounting saves time, but it still needs correct accounting knowledge.

How a transaction flows in accounting software

Transaction: Riya sells goods for Rs.10,000 cash.

Step 1: user enters voucher in software.

Step 2: software records Cash A/c Dr. and To Sales A/c.

Step 3: software updates Cash Ledger.

Step 4: software updates Sales Ledger.

Step 5: Trial Balance updates.

Step 6: Profit and Loss and Balance Sheet data updates.

Simple line: One correct transaction can update many reports automatically.

What is a voucher in computerised accounting?

A voucher is the data entry screen or record used to enter a transaction into accounting software.

Common examples are Sales voucher, Purchase voucher, Receipt voucher, Payment voucher, Contra voucher, and Journal voucher.

For a cash sale, a Sales voucher or Receipt/Sales entry may be used depending on the software design.

For cash paid for rent, a Payment voucher may be used.

For cash deposited into bank, a Contra voucher may be used.

For depreciation entry, a Journal voucher may be used.

Simple line: Voucher is how a transaction enters the computerised accounting system.

What is an Accounting Database?

An accounting database is the place where accounting data is stored digitally.

Think of it like a digital cupboard.

Inside the cupboard, data is arranged properly.

It may store customer details, supplier details, item details, transaction details, ledger details, and payment details.

When we need a report, the software takes data from this database.

The database keeps the accounting information organised.

Simple line: Accounting database stores accounting information in an organised digital form.

Tables, records, and fields

A database table is like a digital register.

Example: a Customer table stores customer details.

A record is one full row in a table.

Example: Raju Traders can be one customer record.

A field is one specific detail inside a record.

Example fields are customer name, phone number, balance, and address.

Simple example: Customer Name, Phone, and Balance are fields. Raju Traders | 98765xxxxx | Rs.10,000 is one record.

Simple line: Table = register. Record = row. Field = detail.

What are Accounting Reports?

Accounting reports are summaries prepared from accounting data.

A Journal Report shows all journal entries.

A Ledger Report shows account-wise transactions.

A Cash/Bank Book shows cash and bank movement.

A Trial Balance shows debit and credit balances.

Profit and Loss shows profit or loss.

Balance Sheet shows assets, liabilities, and capital.

Receivables Report shows who owes money to the business.

Payables Report shows whom the business has to pay.

GST/tax reports show tax-related summaries at a basic level.

Simple line: Reports convert stored data into useful information.

Benefits of computerised accounting

Computerised accounting saves time.

It reduces calculation errors when data is entered correctly.

Reports can be generated quickly.

Old records can be searched easily.

Data can be stored safely with backup.

Ledger and trial balance update automatically.

It helps in GST or tax reporting at a basic level.

It helps owners make better decisions.

It reduces repeated work and can handle many transactions.

Simple line: Computerised accounting makes accounting faster and more organised.

Limitations and risks

Computerised accounting is useful, but it has risks.

Wrong data entry gives wrong reports.

The user must understand accounting basics.

Software can fail or crash.

Data may be lost without backup.

Password and security are important.

Viruses or cyber risks can affect data.

Wrong setup of ledgers can create wrong results.

Example: if rent is entered as furniture, the report will be wrong.

Simple line: Computerised accounting is powerful, but wrong input gives wrong output.

Simple report examples

Ledger Report: Cash Account may show cash sales Rs.5,000, rent paid Rs.2,000, and closing balance Rs.3,000.

Receivables Report: Raju Traders owes Rs.10,000 and Neha Stores owes Rs.7,000.

Payables Report: Amit Suppliers payable Rs.8,000 and Paper Mart payable Rs.12,000.

Trial Balance Report: Cash A/c Debit, Sales A/c Credit, Rent A/c Debit, and Capital A/c Credit.

Profit and Loss Report: Sales, less expenses, then profit or loss.

These reports come from stored transaction data.

Simple line: Reports help the owner know what is happening in the business.

Easy memory table

Principle, meaning, and example

Principle / Concept	Simple Meaning	Easy Example
Computerised Accounting	Accounting using software	Entering sales in software
Voucher	Transaction entry record	Sales voucher
Database	Digital storage of data	Customer and ledger data
Table	Digital register	Customer table
Record	One row of data	Raju Traders row
Field	One detail	Phone number or balance
Report	Summary from data	Trial Balance
Backup	Copy of data for safety	Saved data copy

Simple comparison

Manual Accounting vs Computerised Accounting

Manual Accounting	Computerised Accounting
Entries are written by hand	Entries are entered into software
Ledger posting is manual	Ledger updates automatically
Reports take time	Reports are generated quickly
More chance of calculation error	Less chance of calculation error if data is correct
Physical books/files are used	Digital database is used
Searching old records is slower	Searching records is faster

Memory line: Manual accounting depends on writing. Computerised accounting depends on correct data entry.

Report guide

Common reports in accounting software

Report	What it shows	Simple use
Journal Report	All journal entries	Check transactions entered
Ledger Report	Account-wise transactions	Check one account in detail
Cash/Bank Book	Cash and bank movement	Track money coming in and going out
Trial Balance	Debit and credit balances	Check balance agreement
Profit and Loss	Income, expenses, profit or loss	Know business result
Balance Sheet	Assets, liabilities, and capital	Know financial position
Receivables / Payables	Who owes money and whom to pay	Manage collections and payments
GST/Tax Report	Tax summaries at a basic level	Support tax checking

Reports are useful only when the entered data is correct.

Visual flow

Mental model

Business transaction happens

Source document is received

Voucher is entered in software

Data is saved in accounting database

Ledger accounts update

Trial Balance updates

Reports are generated

Owner uses reports for decisions

Solved examples

See the rule in action

Example 1

Goods sold for cash Rs.5,000.

In software: Sales voucher is entered
Entry idea: Cash A/c Dr. Rs.5,000
To Sales A/c Rs.5,000
Report effect: Cash Book increases, Sales Ledger increases, and Profit and Loss sales increases.

Cash increases because money is received.

Sales increases because goods are sold.

Example 2

Goods sold to Raju Traders for Rs.10,000 on credit.

Entry idea: Raju Traders A/c Dr. Rs.10,000
To Sales A/c Rs.10,000
Report effect: Receivables report shows Raju owes Rs.10,000.

Raju Traders becomes debtor.

Sales increases even though cash is not received immediately.

Example 3

Paid Amit Suppliers Rs.8,000 by bank.

Entry idea: Amit Suppliers A/c Dr. Rs.8,000
To Bank A/c Rs.8,000
Report effect: Bank Book updates and Payables report updates.

Supplier balance decreases because payment is made.

Bank decreases because money is paid through bank.

Example 4

Rent paid Rs.12,000.

Entry idea: Rent A/c Dr. Rs.12,000
To Cash/Bank A/c Rs.12,000
Report effect: Profit and Loss expense increases.

Rent is an expense.

Cash or bank decreases when payment is made.

Example 5

Machine purchased Rs.50,000.

Entry idea: Machinery A/c Dr. Rs.50,000
To Bank A/c Rs.50,000
Report effect: Balance Sheet asset increases.

Machine is an asset.

It should not be treated as a normal expense.

Avoid these

Common Mistakes

Thinking software removes the need to understand accounting

Entering wrong account names

Selecting wrong voucher type

Recording capital expense as revenue expense

Not checking reports after entry

Not taking data backup

Sharing passwords carelessly

Creating duplicate ledgers

Thinking reports are correct even when input is wrong

Ignoring source documents

Practice prompts

Try It Yourself

Goods sold for cash Rs.6,000. Which account increases? Expected: Cash and Sales.

Goods sold to Raju Traders on credit Rs.10,000. Which report will show Raju owes money? Expected: Receivables report / debtor report.

Rent paid by bank Rs.5,000. Which voucher type may be used? Expected: Payment voucher.

Cash deposited into bank Rs.20,000. Which voucher type may be used? Expected: Contra voucher.

Machine purchased Rs.50,000. Is it shown in Profit and Loss or Balance Sheet? Expected: Balance Sheet as asset.

A customer table has Customer Name, Phone, and Balance. Are these fields or records? Expected: Fields.

One row for Raju Traders in customer table is called? Expected: Record.

Wrong data entered into software gives correct reports. True or false? Expected: False.

Trial Balance report is generated from stored transaction data. True or false? Expected: True.

Backup is needed for data safety. True or false? Expected: True.

Connect with Accywise Tools

Practice the same concept

Review Journal Entry Basics Review Ledger Posting Basics Open Tools

Finished this lesson?

Mark your progress

Save this lesson as complete on this browser.

Ready for the next step?

Computerised accounting becomes easy when you understand the accounting logic behind each transaction. First learn the entry, then understand how software stores it and turns it into reports.

Review Journal Entry Basics