Computerised Accounting System - Tally - Study Notes
10.1 Computerised accounting system
A computerised accounting system (CAS) maintains accounts using computers. Accounting transactions are taken as inputs, processed through accounting software and used to produce accounting records and reports.
10.2 Applications of CAS
- Maintaining accounting records: easily and efficiently for a long period, without a large amount of physical space; fast and accurate retrieval of data.
- Inventory management: fast moving, slow moving and obsolete inventory can be identified; availability and level of inventory are known instantly.
- Pay roll preparation: records attendance, computes salary on hours/days worked or units produced, and makes deductions such as provident fund and income tax.
- Report generation: routine and special purpose reports.
- Data import/export: to and from users inside and outside the organisation.
- Taxation: computes taxes, deducts them and deposits them to the Government account.
10.3 Automated accounting system
An approach to maintain up-to-date records with accounting software. Manual accounting makes entries in different books; software accepts one entry in one field or place and automatically relates it to all other relevant records.
10.4 Designing accounting reports
| Routine reports | Special purpose report |
|---|---|
| Day books/Journal, Ledger, Trial balance, Income statement, Balance sheet, Cash flow statement | Any report other than routine reports, prepared according to the requirements of the user |
Steps: (1) define the objective of the report, (2) specify its structure, (3) create database queries to retrieve, modify, add or delete data.
10.5 Data exchange
A Management Information System (MIS) gives information for decisions at all levels. It includes manufacturing, marketing, human resource and accounting information systems. The Accounting Information System (AIS) collects financial data, processes it and gives information to users. To compute wages, AIS needs data from the manufacturing and human resource information systems.
10.6 Tally with GST
- Widely used business accounting and inventory management software with multi-lingual operations, online functions and legally supported reports.
- Tally.ERP 9 was introduced in 2009 and updated for GST in 2017. It follows the double entry system.
10.7 Working in Tally.ERP 9
- Starting: Start > All Programs > Tally.ERP 9, or the desktop icon. Without a licence choose 'Work in Education Mode' (only dates 1, 2 and 31 can be used).
- Create company: Company Info > Create Company.
- Gateway of Tally: selected company on the left pane; menus such as Transactions and Reports on the right pane; shortcut letter in red; vertical button bar on the extreme right; bottom horizontal information panel shows product, version, licence, configuration and calculator.
- Close: Esc > Enter/Y/Yes, or Ctrl + Q. Select company: F1 (Select Cmp).
- F11: Features opens Company Features. General Accounting Features: Maintain accounts only (set Yes), Integrate accounts and inventory, Income and Expenses A/c instead of Profit and Loss A/c. Statutory and Taxation: GST, VAT, TDS.
Groups, ledgers and vouchers
- A group is a collection of ledgers of the same nature; 34 predefined groups. Primary: Capital Account, Current Liabilities, Fixed Assets, Current Assets. Sub-groups: Reserves & Surplus, Sundry Creditors, Sundry Debtors.
- Predefined ledgers: Cash and Profit & Loss A/c. Create others with Masters > Accounts Info > Ledgers > Single Ledger > Create, giving name and group.
- User-defined groups/ledgers can be fully altered or deleted (Alt D); predefined ones only renamed, never deleted.
| Voucher | Key | Used for |
|---|---|---|
| Contra | F4 | Cash deposited into or withdrawn from bank |
| Payment | F5 | Payments by cash or bank; cash/bank credited |
| Receipt | F6 | Receipts by cash or bank; cash/bank debited |
| Journal | F7 | Depreciation, provision for bad debts, rectification, credit purchase of assets |
| Sales | F8 | Cash and credit sales of goods |
| Purchase | F9 | Cash and credit purchases of goods |
Practical points
- Wages under Direct Expenses; Salaries, Rent, Stationery and Depreciation under Indirect Expenses.
- Cash is predefined: enter its opening balance by altering the ledger.
- Closing stock: alter the Stock ledger and enter the closing balance with the opening date.
- Trial Balance: Gateway of Tally > Reports > Display > Trial Balance. Profit & Loss and Balance Sheet: F10: A/c Reports or Gateway of Tally > Reports, Alt F1 for detail. Delete or alter a voucher through Display > Day Book.