Accounting Information System Jackson
Accounting Information System Jackson
Accounting Information System Jackson
1
Computer, Accounting &
Systems
What is a Computer?
• A computer is an information-processing
machine.
• We may also say that a computer is a device
that works under the control of stored
programs automatically accepting, storing and
processing data to produce information that is
the result of that processing.
2
Computer
The forms of information processed include:
• Data – e.g. invoices, sales ledger and
purchase ledger, payroll, stock controls etc.
• Text – widely available in many offices with
microcomputers
• Graphics – e.g. business graphs, symbols
• Images – e.g. pictures
• Voice – e.g. telephone
3
Computer Processing
Processing includes;
• creating,
• manipulating,
• storing,
• accessing and
• transmitting.
4
Why use computers?
Use of computers has become a necessity in
many fields.
9
Application of Information
Systems in Accounting
• These are systems that maintain records
concerning the flow of funds in the firm and
produce financial statements, such as balance
sheets and income statements. They are among
the earliest systems to be computerized
• Operational accounting information systems
produce the routine, repetitive information
outputs that every organization finds necessary,
including pay cheques, cheques to vendors,
customer invoices, purchase orders, stock
reports, and other regular forms and reports.
10
In Accounting
The heart of an organization’s operational-
level accounting information system is the
financial accounting system. A
computerized financial accounting system
is composed of a series of software
modules or subsystems used separately or
in an integrated fashion
11
System Applications
• General ledger.
• Fixed assets.
• Sales order processing.
• Accounts receivable.
• Accounts payable.
• Inventory control.
• Purchase order processing.
• Payroll.
When these computerized financial accounting
subsystems are integrated, each subsystem receives
data as input from other subsystems and provides
information as output to other subsystems.
12
Systems Concepts
A system is a set of interacting components
that work together to accomplish specific
goals. For example, a business is organized to
accomplish a set of specific functions. Any
situations, which involve the handling or
manipulation of materials or resources of any
kind whether human, financial or informative,
may be structured and represented in the
form of a system
13
Characteristics of System
• Purpose – Systems exist to fulfil some
objective or satisfy a need. A system may
accomplish more than one task. The purpose
of a system is closely tied to its rationale.
• Rationale – This is the justification for a
system’s existence.
• Efficiency – This is how well a system utilizes
its resources, that is, doing things right.
14
Characteristics of System
• Effectiveness – How well a system fulfils its
purpose, assuming that its purpose is the right
one. Involves a system doing the right things.
• Inputs – Entities that enter the system to
produce output or furnish information.
• Outputs – Entities that exit from the system
either as interfaces or for end-user activities.
They may be used to evaluate system’s
efficiency and effectiveness.
15
Characteristics of System
• Transformation rules – Specify how the input is
processed to produce output.
• Throughput – Measures the quantity of work a
system accomplishes. Does not consider the
quality of the output.
• Boundary – Artificially delimits a system for
study or discussion purposes. System designers
can only control those system components
within the boundary.
16
Characteristics of System
• Environment – That which impacts the system
but is outside the system’s boundary. The system
cannot control events in the environment.
• Interfaces – Points where two systems meet and
share inputs and outputs. Interfaces belong to the
environment although they may be inside the
system boundary.
• Feedback – Recycles outputs as subsequent
inputs, or measures outputs to assess
effectiveness. 17
Components of A System
Environment System Boundary
Environment
Environment
Input Output
Process
28
2. The Accuracy
29
3. The Financial Statements
Cost/ Quick
Quick
Number of Access
access to
Stationery
Information
used
Inputs – Accessibility
Time taken Outputs
Reliability
for a task relationship
of Cost of
Information employee considering
in handling time Internal
Network with
different Controls
other
departments jobs
35
Importance of IT in Accounting
• Time Frame
Computerized accounting activities help
an accountant perform month-end close
procedures. These activities also help a
company report profit information over a
period, such as a month or quarter.
38
Importance of IT in Accounting
• Recording Procedures
An accountant uses computerized
accounting software to make journal
entries in financial accounts, such as
assets, liabilities, revenues, expenses
and equity.
The accountant debits an asset or
expense account to increase its amount
and credits it to reduce the account
balance. The opposite is true for
revenue, liability and equity accounts.
39
40
41
42
43
44
CAS Development Lifecycle 1
• User and Uses Needs Identification - An
accounting information system is used to
input, process, store and distribute
information. The needs of each business for
an accounting system are slightly different.
• Analysis - Every business has unique
objectives and goals; and so, every
accounting system is set up with slight
variations. Companies must analyze their
needs when determining what type of
system to use.
45
CAS Development Lifecycle 2
• Design - After the analysis of the business is
complete, a company begins to design the system it
needs, ensuring it can fulfill all objectives within the
organization. The business can either do this
internally with accounting personnel or hire a firm
to design it for them. Small companies can purchase
software that can be customized to their needs.
Other companies hire a computer programmer to
write code specific to their needs
• Implementation - After the system is designed, the
company can begin to implement it. This is a
complicated process because it requires a
conversion from one system to another.
46
CAS Development Lifecycle 3
• Re-evaluation
Many times, once an accounting system is up
and running, a company finds it may be
lacking something. For instance, after using
the system, a firm may realize it needs a
database installed for customer mailings. A
re-evaluation is done for such reasons, and
adjustments are then made
47
CAS Development – Things to
Consider
• Workflow - When you switch to an
accounting information system, be prepared
for your workflow to change accordingly.
• Best Practices Research - Taking stock of
best accounting practices before you begin
the data migration
• Installation and Compatibility - prior to
installation it’s important to ensure your
workstations and server is compatible 48
CAS Development – Things to
Consider
• Auditing - make sure your consultant sets up
the software to enable audit trails
• Customization - match your company’s most
important business needs or offer the
flexibility to be implemented or customized
easily to your needs
• Data Migration - Best practices for migrating
data from your old system is to run a test
migration 49
CAS Development – Things to
Consider
• Security - It’s crucial to address security concerns
to protect your data.
• Ensure
– employees are backing up data in a secure location,
– that the files are password-protected if need be,
and
– have antivirus software running on any of the
computers that use the accounting software.
– This helps protect your data from data loss,
computer problems, and natural disasters 50
51
52
Features of a Computerized
Accounting System
• Consistency of operations
• Concentration of functions – only few people are
in processing financial information
• Potential of alteration as data is held together
and can be easily accessed
• Lack of visible outputs as only summarized data
is printed
• A single input automatically updates all the
records associated with the transaction
• Accuracy
• Use of passwords 53
Basic Functions of a CAS
1. Collect and Store Data
One function of a CAS is to efficiently and
effectively collect and store data about
business activities and transactions.
The system must capture transaction data on
source documents, record transaction data
in journals to present a chronological record
of transactions, and post data from journals
to ledgers that sort the data by account
type. 54
Basic Functions of a CAS
2. Provide Information
The second function of CAS is to provide
information useful for making decisions.
This information usually involves reports
in the form of financial statements and
managerial reports
55
Basic Functions of a CAS/ AIS
3 Provide Controls
The third function of a CAS is to
incorporate controls to ensure the
accurate recording and processing of
data.
The system must make certain that the
information that comes out of the
system is reliable, ensure that business
activities are efficient and in line with
management's objectives and keep
business assets safe 56
Accounting Information Concepts
Information: processed facts meant to
support decision making in an
organization
64
Objectives of SDLC
65
SDLC Phases
• The SDLC Phases include the following;
– Preliminary Study – determination of whether there is
need to change the existing system or business
procedures.
• It aims at understanding organizational characteristics and
objectives
– Feasibility study – a more detailed study carried out to
define the problem and decide whether or not the
new system to replace current is viable
• It aims at identifying main system characteristics, output
requirements and economic viability
• Types of Feasibility study include – technical, social, legal
and economic (Cost – Benefit – Analysis). 66
SDLC Phases 2
– Fact Finding/System Investigation – collection of
information about the existing system in order to
establish whether the current user’s needs are being
met
• Done through the use of questionnaire, interviewing,
observation, Sampling.
– Systems Analysis – evaluation of the current system
using gathered facts. It involves the detailed
assessment of the components of the existing system
and requirements of the new system
– Systems design – The translation of the statement of
requirements into a form that can be understood by
the user and other people apart from the designers
67
SDLC Phases 3
In this way, the audit hope to assess the risk to the company's valuable
asset (information) and establish methods of minimizing the risks70
E-Commerce & Application in
Accounting
• E-Commerce – Use of computer networks to
complete business transactions.
• Categories of E-Commerce include;
– B2B – transactions between businesses over the
internet or other networks
– B2C – internet based transactions between online
merchants / organizations and individual consumers
– C2C – Internet transactions between consumers
– Intra-Business/Intra Company – internal exchange of
goods, services and information within a company over
its intranet. 71
Benefits of E-Commerce to
Organizations & Customer
• Reduces cost of creating, processing, distributing of paper based
information
• Allows for reduced inventory costs
• Supports business changes
• Lowers telecommunication costs
• Helps small businesses to compete with large organizations
• Allows organizations to access customers globally
• Permits creation of efficient markets
• Provides a variety of choices
• Customers shop without time limitation
• Access to customized products and global interaction between
customers
72
Limitations of E-Commerce
• The use of internet reduces guarantee
on data security and reliability
• Difficult to interpret internet/web
information
• Need for specialized e-commerce and
web-servers thus increasing the cost of
set up
• Slow development tools compromises e-
commerce activities 73
Applications of Transaction
Processing Systems
• Accounting information are recorded in
form of transactions
• Business data, then goes through the
transaction cycle which includes;
– Data Collection
– Data editing
– Data manipulation
– Transaction process system is majorly applied
in the following accounting area
74
1. Order Processing System
These systems include;
1.Order entry – capturing of basic data
2.Sales configuration – ensuring the products and
services ordered meet customer needs
3.Inventory Control – Updates the computerized
inventory records
4.Invoicing – invoices generated based on records
available
5.Routing and scheduling – determines the best way
to get products from one location to the next
75
2. Purchasing Systems
Purchasing Transactions include;
1.Purchase order processing– completion of
purchasing transactions quickly
2.Receiving– Records all expected receipts
3.Accounts Payable– Increases organization’s
control over purchases, cash flow
management and improves profitability as
well as effective management of current
liabilities
76
3. Finance & Accounting Systems
These are information systems which
keep track of organization’s financial
resources. Examples include;
– Profit planning systems
– Budgeting Systems
– Portfolio Analysis Systems
– Accounts Receivables Systems
79
QuickBooks
• QuickBooks is an accounting software package for small- to
medium-sized businesses. Developed, sold and supported by Intuit
• QuickBooks is small business software that functions as a CRM
(customer relationship management) system, Inventory Control
and Accounting system all-in-one
• The typical uses of QuickBooks include:
– Storing customer and vendor information
– Tracking sales and expenses
– Creating customer invoices
– Receiving payments from customers
– Analyzing sales and expenses
– Organizing financial data for tax purposes
80
The Advantages of QuickBooks
– Calculations are done automatically so you don’t have to do the
math
– Reduces or eliminates math errors or mistakes
– Data entry is consistent (e.g. state abbreviations, phone
number formats, etc.) which makes finding or analyzing data
much easier
– Changes are easily propagated throughout the system (e.g.,
changing the sales tax rate in one place will change it for all
sales records)
– Searching for information is easy and quick with many options
to sort and display the information
– Multiple report formats are available to view or print
81
Key Components of QuickBooks
• Customer Information - This is information about the people
and businesses which have purchased the products or
services
• Vendor Information - This is information about the people
and businesses from which you purchase products or services
• Employee Information - This is where information about your
employees is maintained.
• Inventory Control - This area is where you manage all of your
products and services
• Reporting - The reporting area is extensive with various
standard report templates as well as ways to customize
reports for your business
82
Versions of QuickBooks
• QuickBooks has several versions of its software
available based on the needs of your company
• All of the QuickBooks versions contain the
following functionality:
– Manage Customer and vendor information
– Track your sales and expenses information
– Create customer invoices
– Receive and post payments from customers
– Analyze sales and expenses and create custom reports
– Organize the business financial data for tax purposes
83
Practical Approach to Quickbooks
Slides on Quickbooks
84
Practical Illustration- Recording an
Invoice
INVOICE
Account Inventory
Receivable Record
Dr Accounts Receivable
Control
Cr Sales
(Selling price on Invoice)
86
Manual Steps in CAS
operations)
87
Integration
Cash Receipts
Payroll
and Payments
General
Ledger
Accounts Accounts
Rec. Ledger Pay. Ledger
Inventory
Records
88
Computerized
Accounting
Systems
(continued)
Computerized
Accounting Systems
(continued)