Revision notes

Unit 10 Computerised Accounting system-Tally: Foundation

The key points, rules to remember, tables and diagrams from all 5 lessons, on one page for quick revision. To keep a copy, use your browser's Print and choose "Save as PDF".

Lesson 1

Computerised accounting system: applications, reports and data exchange

How a computerised accounting system works

  1. Input Accounting transactions entered once, through vouchers
  2. Processing Software posts them to every related record
  3. Storage Records kept on the computer, easy to retrieve
  4. Output Day books, ledgers, trial balance, final accounts and other reports
Six applications of CAS listed in the Tamil Nadu textbook
ApplicationWhat CAS does
Maintaining accounting recordsKeeps records easily and efficiently for a long time, needs little physical space, and retrieves data quickly and accurately
Inventory managementIdentifies fast moving, slow moving and obsolete stock and gives up-to-date stock levels instantly
Payroll preparationRecords attendance, works out pay by time worked or units produced, and makes deductions such as provident fund and income tax
Report generationProduces routine and special purpose reports
Data import and exportBrings data in from, and sends data out to, users inside and outside the organisation
TaxationComputes taxes, deducts them and helps deposit them to the Government account

Two kinds of accounting report

  • Routine reports
    • Day books or journal
    • Ledger
    • Trial balance
    • Income statement
    • Balance sheet
    • Cash flow statement
  • Special purpose reports
    • Any report other than the routine ones
    • Prepared to suit the needs of a particular user
    • Example: dues from customers in one district, for the sales manager

Management Information System and its parts

  • Manufacturing information system Supplies, for example, hours worked and units produced
  • Marketing information system Supplies sales orders and customer data
  • Human resource information system Supplies staff details, attendance and pay rates
  • Accounting information system Uses all of these to record, value and report; sends cost and budget data back

Key takeaways: CAS turns transactions (input) into records and reports (output) through software. Its applications include records, inventory, payroll, reports, data import and export, and taxation. Automated accounting enters a transaction once and updates every related record. Reports are routine or special purpose, and the AIS constantly exchanges data with the other parts of the MIS.

Read the full lesson

Lesson 2

Getting started with Tally.ERP 9: company, Gateway of Tally and features

Parts of the Gateway of Tally screen in Tally.ERP 9
Part of the screenWhat it shows
Left paneThe List of Selected Companies, with the current period and date
Right pane (Gateway of Tally)The menu: Masters (Accounts Info, Inventory Info), Transactions (Accounting Vouchers, Inventory Vouchers), Utilities, Reports, Display and Quit. Each option has a shortcut letter highlighted in red
Vertical button bar (extreme right)Buttons such as F1 and F2 for quick actions; for example F1: Select Cmp and F11: Features
Bottom information panelProduct, version, licence, configuration and a calculator

First session in Tally.ERP 9 (book's steps)

  1. Start Tally Choose Work in Education Mode
  2. Create company Company Info > Create Company; enter the name; accept Yes
  3. Gateway of Tally Check the company appears in the left pane
  4. F11: Features Accounting Features: Maintain accounts only = Yes
  5. Close Esc and Yes, or Ctrl + Q

Key takeaways: Tally.ERP 9 (2009, updated for GST in 2017, according to the textbook) follows double entry and records through vouchers. Start in education mode for practice, create a company, use the Gateway of Tally as the home screen, F1 to select a company, F11 for features ('Maintain accounts only' = Yes for the book's practicals), and Ctrl + Q to quit.

Read the full lesson

Lesson 3

Accounting groups and ledgers in Tally

Some primary groups and the sub-groups under them

  • Capital Account
    • Reserves & Surplus
  • Current Liabilities
    • Sundry Creditors
    • Duties & Taxes
    • Provisions
  • Current Assets
    • Sundry Debtors
    • Cash-in-Hand
    • Bank Accounts
    • Stock-in-Hand
  • Fixed Assets Machinery, furniture, buildings, computers
Other primary groups include Purchase Accounts, Sales Accounts, Direct and Indirect Expenses, and Direct and Indirect Incomes.

Every ledger needs a name and the group it goes 'Under'. The group decides where its balance appears in the final accounts.

— Remember
What can be changed, according to the book
ActionUser-defined group or ledgerPredefined group or ledger
AlterAll details can be alteredOnly the name can be altered
DeleteCan be deletedCannot be deleted
Working: ask whether the account is an asset, liability, income or expense, then whether it is direct (trading) or indirect (profit and loss)
Ledger (made-up business)Group it goes underReasoning
Sangeetha's Capital A/cCapital AccountOwner's capital
Indian Overseas Bank A/cBank AccountsA bank account of the business
Machinery A/cFixed AssetsLong-lived asset used in the business
Kumar A/c (a customer who owes us)Sundry DebtorsA debtor is a current asset
Lakshmi A/c (a supplier we owe)Sundry CreditorsA creditor is a current liability
Purchases A/cPurchase AccountsGoods bought for resale
Sales A/cSales AccountsGoods sold
Wages A/cDirect ExpensesExpense of making or bringing goods: goes to the trading account
Salaries A/cIndirect ExpensesOffice expense: goes to the profit and loss account
Commission received A/cIndirect IncomesIncome other than sales: goes to the profit and loss account
Opening stockStock-in-HandInventory held

Key takeaways: a group collects ledgers of the same nature; primary groups (such as Current Assets) contain sub-groups (such as Sundry Debtors). Only Cash and Profit & Loss A/c are predefined ledgers. Create each ledger with its name and group; predefined items can only be renamed, never deleted, while user-defined ones can be fully altered or deleted.

Read the full lesson

Lesson 4

Vouchers in Tally: receipt, payment, contra, purchase, sales and journal

The six major accounting vouchers in the book
VoucherKey (Tally.ERP 9)Used forEffect
ContraF4Transactions involving both cash and bank: depositing cash into bank, withdrawing cash from bankCash and bank accounts only
PaymentF5All payments in cash or through bankCash or bank credited; the other account debited
ReceiptF6All receipts in cash or through bankCash or bank debited; the other account credited
JournalF7Transactions not involving cash, bank, purchases or sales of goods, such as depreciation, provision for bad debts, credit purchase of assetsAny ledgers debited and credited
SalesF8Cash and credit sales of goodsSales account credited
PurchaseF9Cash and credit purchases of goodsPurchases account debited

Deciding the voucher type

  1. Is it goods bought or sold? Yes: Purchase (F9) or Sales (F8), for cash or on credit
  2. Only cash and bank involved? Yes: Contra (F4)
  3. Money going out? Yes: Payment (F5)
  4. Money coming in? Yes: Receipt (F6)
  5. None of these? Journal (F7): depreciation, credit purchase of an asset, adjustments
Check the questions in this order.

Goods: Purchase or Sales. Cash and bank only: Contra. Money out: Payment. Money in: Receipt. Everything else: Journal.

— Rule of thumb
Transaction analysis for Kavitha's business
No.Transaction (made up)Journal entryVoucherGroups (Dr / Cr)
1Started business with cash ₹2,00,000Cash A/c Dr; To Kavitha's Capital A/cReceipt (F6)Cash-in-Hand / Capital Account
2Opened a bank account, deposited ₹50,000Bank A/c Dr; To Cash A/cContra (F4)Bank Accounts / Cash-in-Hand
3Goods bought on credit from Prakash ₹30,000Purchases A/c Dr; To Prakash A/cPurchase (F9)Purchase Accounts / Sundry Creditors
4Goods sold on credit to Uma ₹40,000Uma A/c Dr; To Sales A/cSales (F8)Sundry Debtors / Sales Accounts
5Rent paid by cheque ₹5,000Rent A/c Dr; To Bank A/cPayment (F5)Indirect Expenses / Bank Accounts
6Cash received from Uma ₹15,000Cash A/c Dr; To Uma A/cReceipt (F6)Cash-in-Hand / Sundry Debtors
7Computer bought on credit from Sakthi Systems ₹35,000Computer A/c Dr; To Sakthi Systems A/cJournal (F7)Fixed Assets / Sundry Creditors
8Cash withdrawn from bank for office use ₹8,000Cash A/c Dr; To Bank A/cContra (F4)Cash-in-Hand / Bank Accounts
9Carriage inwards paid in cash ₹1,000Carriage inwards A/c Dr; To Cash A/cPayment (F5)Direct Expenses / Cash-in-Hand

Key takeaways: every transaction enters Tally through a voucher. Contra F4, Payment F5, Receipt F6, Journal F7, Sales F8, Purchase F9 in Tally.ERP 9. Analyse each transaction first (journal entry, voucher, groups); use purchase and sales vouchers only for goods, contra only for cash-bank movements, and journal for non-cash adjustments and credit purchase of assets.

Read the full lesson

Lesson 5

Tally practical: opening balances, closing stock and reports

Viewing reports
ReportPath in Tally.ERP 9 (as in the book)
Trial BalanceGateway of Tally > Reports > Display > Trial Balance > Alt + F1 (detailed)
Profit & Loss A/cGateway of Tally > Reports > Profit & Loss A/c > Alt + F1, or F10: A/c Reports > Profit & Loss A/c
Balance SheetGateway of Tally > Reports > Balance Sheet > Alt + F1, or F10: A/c Reports > Balance Sheet
Ratio AnalysisGateway of Tally > Reports > Ratio Analysis, or F10: A/c Reports > Ratio Analysis
Day BookGateway of Tally > Reports > Display > Day Book > Alt + F1, or F10: A/c Reports > Day Book

From opening balance sheet to final accounts in Tally

  1. Company and features Maintain accounts only = Yes
  2. Ledgers with opening balances Alter Cash for its opening balance
  3. Vouchers for the year Receipt, payment, contra, purchase, sales, journal
  4. Closing stock Alter the stock ledger
  5. Reports Trial balance, P&L, balance sheet, ratios, day book
Step 2: ledgers with opening balances
LedgerUnderOpening balance ₹
Malar's Capital A/cCapital Account1,50,000 (Cr)
Kannan A/cSundry Creditors20,000 (Cr)
Machinery A/cFixed Assets60,000 (Dr)
Furniture A/cFixed Assets15,000 (Dr)
StockStock-in-Hand25,000 (Dr)
Selvi A/cSundry Debtors30,000 (Dr)
Cash (predefined: alter it)Cash-in-Hand10,000 (Dr)
Bank A/cBank Accounts30,000 (Dr)

Key takeaways: enter opening balances while creating ledgers (alter Cash, which already exists); record closing stock by altering the stock ledger when accounts are not integrated with inventory; correct vouchers through the Day Book; and read the trial balance, profit and loss account, balance sheet, ratio analysis and day book from Reports or F10. Always check key totals by hand.

Read the full lesson

Privacy · Terms · Refunds · Delivery