Revision notes

Unit 14 Computerised Accounting: 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

Computers and the computerised accounting system

How a computer turns data into information

  1. Data Facts and figures fed in
  2. Input unit For example a keyboard
  3. CPU Arithmetic and logic unit, control unit, primary storage
  4. Output unit For example a monitor or printer
  5. Information Processed, useful result
Secondary storage works with the CPU to keep data for later use.
Reports a CAS generatesAreas where computers are commonly used in accounting
Day books or journalsRecording of business transactions
LedgerPayroll accounting
Trial balanceStores accounting
Trading account and profit and loss accountGeneration of accounting reports
Balance sheet and other reports

The fundamentals of accounting do not change when books are computerised: the same rules of debit and credit apply.

Features of a computerised accounting system as given in the textbook
FeatureWhat it means
Simple and integratedPurchase, sales, finance, inventory and manufacturing are linked in one system, and it may be combined with management information system (MIS) features
SpeedWork is done far faster than by hand
AccuracyWith correct hardware, software and input, the output is accurate
ReliabilityLarge volumes of data are processed dependably
VersatilityOne set of entries gives the trial balance, final accounts and many other reports
TransparencyDay-to-day operations and vital information are visible
ScalabilityAny volume of data can be handled as the business grows
On-line facilityData can be stored and reports viewed from anywhere
SecurityOnly authorised users can reach the accounting data

Key takeaways: a computer turns data into information through input, CPU and output units. A CAS processes transactions through accounting software to give day books, ledger, trial balance and final accounts, using the same rules of debit and credit. Its features are simplicity and integration, speed, accuracy, reliability, versatility, transparency, scalability, on-line facility and security.

Read the full lesson

Lesson 2

Components of a computerised accounting system

Components of CAS

  • Hardware
    • Input devices
    • Output devices
  • Software
    • System software
    • Application software
  • People
    • Analysts, programmers, operators
  • Procedure
    • Hardware, software and internal
  • Data
    • Raw facts that become information
  • Connectivity
    • Linking computers to share
Types of software
TypePurposeExamples given in the textbook
System software: operating systemManages the overall working of the computer; the interface between user and machineDOS, Windows, Ubuntu
System software: programming softwareAccepts instructions and turns them into a form the machine understandsC, Pascal, COBOL
System software: utility softwareManages the computer and its resourcesFile manager, anti-virus software
Application software: general purposeUsed for many kinds of tasksMS Office
Application software: specific purposeBuilt for one task, suited to the user's needsAccounting software, payroll software

Hardware, software, people, procedure, data and connectivity: six components, and the system is only as good as the weakest of them.

Key takeaways: hardware is the physical machine; software is system software (operating system, programming and utility software) or application software (general or specific purpose); people are analysts, programmers and operators; procedures are hardware oriented, software oriented or internal; data become information when processed; connectivity lets computers share.

Read the full lesson

Lesson 3

Advantages and limitations of CAS, and manual versus computerised accounting

Weighing up a computerised accounting system

  • Gains
    • Speed and accuracy
    • Up-to-date balances
    • Little storage space
    • Reports at a click
  • Costs and risks
    • Installation and training cost
    • System failure without backup
    • Security breaches
    • Staff fears and health
Differences between manual and computerised accounting, as listed in the textbook
BasisManual accountingComputerised accounting
RecordingWritten by handEntered using computers
StorageIn volumes of booksIn well-designed databases
Ledger, trial balance and statementsPrepared by handPrepared automatically once entries are made
ReportsAnalysis and reports done by handAnalysis such as ratio analysis and cash flow statements done automatically
TimeA lot of time, from journal to reportsTime is needed only to enter data; the rest takes seconds
CostHigh, as several books are keptLower, as records are kept in soft copy (the textbook's comparison)
RetrievalSlow; many books to searchQuick; data found by giving instructions
AccuracyArithmetical and carrying-forward errors can happenCorrect input gives correct output, if the programming is correct
Communication of reportsSlow and done by handEasy and quick, anywhere, if online

A computer removes errors of copying and totalling, not errors of input or judgement: wrong data in gives wrong information out.

Key takeaways: CAS is fast, accurate, reliable and saves space, with reports at a click. Its limitations include installation and training costs, staff fears, system failure, security risks and health effects. An audit trail traces any figure back to its source document. Compared with manual books, a CAS stores data in databases and prepares ledgers and statements automatically.

Read the full lesson

Lesson 4

Accounting software, grouping and codification of accounts

Comparison of the three types of software, as given in the textbook
BasisReadymadeCustomisedTailormade
Nature of businessSmall, conventionalLarge, mediumLarge
Cost of installation and maintenanceLowRelatively highHigh
Expected level of secrecyLowRelatively highRelatively high
Number of users and interfaceLimitedAs per specificationsUnlimited
Linkage to other information systemsRestrictedNot restrictedNot restricted
AdaptabilityHighRelatively highSpecific
Training requirementsLowMediumHigh

Grouping of accounts

  • Liabilities and capital
    • Capital (capital, reserves and surplus)
    • Non-current liabilities (long-term borrowings)
    • Current liabilities (short-term borrowings, trade payables)
  • Assets
    • Fixed tangible assets (land and building, plant)
    • Intangible assets (goodwill, patents)
    • Current assets (inventories, trade receivables, cash)
  • Revenues
    • Sales
    • Other income
  • Expenses
    • Material consumed, wages
    • Depreciation, interest
    • Administrative, selling and distribution
Major heads and some of the sub-heads listed in the textbook
A made-up four-level code list
CodeAccount headGroup
13Current liabilitiesUnder 1 Liabilities and capital
131Trade payablesUnder 13
1311Murugan and Co. (a creditor)Under 131
1312Rani Suppliers (a creditor)Under 131
22Current assetsUnder 2 Assets
221InventoriesUnder 22
222Trade receivablesUnder 22
Three methods of codification
MethodHow it worksMade-up example
Sequential codesNumbers or letters given in consecutive order; used mainly for source documents such as cheques and invoices, and helpful in searching for themCustomers CU001, CU002, CU003 in the order they are opened
Block codesA range of numbers is split into sub-ranges, each kept for one group; inside a block numbers usually run in sequence100-199 bicycles, 200-299 spare parts, 300-399 accessories
Mnemonic codesLetters or abbreviations that remind the user of what they stand forPB for purchases book, BR for bills receivable

Group first, then code: a good code keeps the hierarchy, so sorting the codes sorts the accounts.

Key takeaways: readymade software suits small simple businesses, customised software suits medium and large ones with special needs, and tailormade software suits large enterprises. Accounts are grouped into major heads (liabilities and capital, assets, revenues, expenses) and sub-heads, and coded so the hierarchy is preserved. Codes may be sequential, block or mnemonic.

Read the full lesson

Lesson 5

MS Word and MS Excel practical for accounting

MS Word tasks given in the textbook
TaskSteps or shortcut (as in the textbook; versions differ)
Create a fileStart, All Programs, Microsoft Office, Microsoft Word; then File, Save As, give a file name, Save
Open a fileFile, Open, choose the file, Open
Save an existing fileFile, Save, or Ctrl+S
Close a fileFile, Close
Insert a tableInsert, Table, choose the number of rows and columns
Bold, italic, underlineCtrl+B, Ctrl+I, Ctrl+U
Align left, right, centre, justifyCtrl+L, Ctrl+R, Ctrl+E, Ctrl+J
Line spacing single, double, 1.5Ctrl+1, Ctrl+2, Ctrl+5
Page layoutMargins (normal, narrow, wide), orientation (portrait, landscape), size (A4, A5), columns
Page numbersInsert, Page Number, choose top or bottom of the page
Excel functions covered in the Tamil Nadu textbook
GroupFunctionWhat it returnsForm
StatisticalAVERAGEThe average=AVERAGE(range)
StatisticalMAX / MINThe largest / smallest value=MAX(range), =MIN(range)
StatisticalCOUNTNumber of cells containing numbers=COUNT(range)
StatisticalCOUNTANumber of cells that are not empty=COUNTA(range)
StatisticalCOUNTIFNumber of cells meeting a condition=COUNTIF(range,criteria)
TextCONCATENATESeveral texts joined into one=CONCATENATE(text1,text2)
TextUPPER / LOWERText in capitals / small letters=UPPER(text), =LOWER(text)
LogicalANDTRUE only if all conditions are true=AND(test1,test2)
LogicalORTRUE if any one condition is true=OR(test1,test2)
LogicalIFOne value if a test is true, another if false=IF(test,value_if_true,value_if_false)
FinancialSLNStraight line depreciation for one period=SLN(cost,salvage,life)
FinancialPMTPeriodic payment on a loan=PMT(rate,nper,pv,fv,type)
FinancialRATEInterest rate per period of a loan=RATE(nper,pmt,pv,fv,type)

Making a chart in Excel

  1. Enter data Labels and values
  2. Select range Include headings
  3. Insert chart Column, line or pie
  4. Add data labels Right-click the chart
  5. Name the axes From the chart tools

In PMT and RATE, match the rate to the payment period: monthly payments need the yearly rate ÷ 12.

Key takeaways: Word shortcuts save time (Ctrl+S save, Ctrl+B/I/U formatting, Ctrl+L/R/E/J alignment, Ctrl+1/2/5 spacing). Excel's statistical, text, logical and financial functions handle accounting data; SLN gives straight line depreciation, PMT a loan instalment and RATE a loan's interest rate. Menus differ between Office versions, but the commands keep their names.

Read the full lesson

Privacy · Terms · Refunds · Delivery