CIS Flashcards
Gather and analyze facts about problems with current system and formulate solution
Systems Professionals
Primary users needs are solicited
End Users (Managers, Operations Personnel, Accountants, Internal Auditors)
Individuals who have an interest in the system but are not end users
Stakeholders (Accountants, Internal and external Auditors)
Readily available
and readily use of software system.
Turnkey Systems (Commercial Systems)
You need to further edit but it has it’s own accounting system.
General Accounting systems (Commercial Systems)
You can acquire what you need, there is only certain item in general accounting system.
Special purpose systems (Commercial Systems)
Moving from one system to another without human intervention.
Office Automation systems (Commercial Systems)
Doesn’t have items, only has modules.
Backbone systems (Commercial Systems)
there is a supporting vendor when making the system.
Vendor Supported systems (Commercial Systems)
Advantages of Commercial Software
Implementation Time
Cost
Reliability
Disadvantages of Commercial Software
Independence
The need for customized systems (becomes dependent on vendor)
Maintenance
Links individual projects or applications to the strategic objectives of the firm.
Systems Planning
allocation, processing, budgeting, informed decisions by systems specialists
Strategic Systems Planning
- Authorizing development of new systems
- Addressing and documenting user needs
- Technical design phases
- Participation of internal auditors
- Testing program modules before
implementing
o Testing individual modules by a team of
users, internal audit staff, and systems
professionals
Systems Development Activities
develop in existing technology
Technical Feasibility
availability of
funds
Economic Feasibility
conflicts between conceptual concept & discharge liabilities
Legal Feasibility
Compatibility
Operational Feasibility
ability to implement within acceptable time
Schedule Feasibility
Data Source
Data Flows
Error Rates
Data Stores
Controls
Resource Costs
Data Processes
Transaction Volumes
Bottlenecks and Redundant Operations
Gathering Facts and Facts Gathering Techniques
PHASE 1 (Phases and Associated Documentation)
Systems Planning
PHASE 2 (Phases and Associated Documentation)
Systems Analysis
PHASE 3 (Phases and Associated Documentation)
Conceptual System Design
ITERATIVE APPROACH
reduced time for cost development, maintenance, testing and improved user support & flexibility
PHASE 4 (Phases and Associated Documentation)
System and Evaluation and Selection
PHASE 5 (Phases and Associated Documentation)
Detailed Design
PHASE 6 (Phases and Associated Documentation)
Application Programming and Testing
PHASE 7 (Phases and Associated Documentation)
System Implementation (Go Live)
PHASE 8 (Phases and Associated Documentation)
Systems Maintenance
where application program source code are stored
Source Program Library Controls
An economic event that affects the assets and equities of the firm, is reflected in its accounts, and is measured in monetary terms.
TYPES:
o the expenditure cycle
o the conversion cycle
o the revenue cycle
Financial Transaction
time lag between the two due to credit relations with suppliers
Expenditure Cycle
the production system (planning, scheduling, and control of the physical product through the manufacturing process)
Conversion Cycle
monitors the flow of cost information related to production
Cost Accounting System
time lag between the two due to credit relations with customers
Revenue Cycle
used to capture and formalize transaction data needed for transaction processing
Source Documents (Manual System Accounting Records)
the result of transaction processing
Product Documents (Manual System Accounting Records)
a product document of one system that becomes a source document for another system
Turnaround Documents (Manual System Accounting Records)
a record of chronological entry
Journals (Manual System Accounting Records)
specific classes of transactions that occur in high frequency
Special Journals
nonrecurring, infrequent, and dissimilar transactions
General Journal
a book of financial accounts
Ledger
shows activity for each account listed on the chart of accounts
General Ledger
shows activity by detail for each account type
Subsidiary Ledger
generally contains account data (e.g., general ledger and subsidiary file)
Master File
a temporary file containing transactions since the last update
Transaction File
contains relatively constant information used in processing (e.g., tax tables, customer addresses)
Reference File
contains past transactions for reference purposes
Archive File
Five common documentation techniques:
o Entity Relationship Diagram
o Data Flow Diagrams
o Document Flowcharts
o System Flowcharts
o Program Flowcharts
is a documentation technique to represent the relationship between entities in a system.
Entity Relationship Diagram (ERD)
Widely
used in AIS. REA uses 3 types of entities:
o resources (cash, raw materials)
o events (release of raw materials into
the production process)
o agents (inventory control clerk,
vendor, production worker)
The REA model version of ERD
- use symbols to represent the processes, data sources, data flows, and entities in a system
- represent the logical elements of the system
- do not represent the physical system
Data Flow Diagrams (DFD)
- illustrate the relationship among processes and the documents that flow between them
- contain more details than data flow diagrams
- clearly depict the separation of functions in a system
Documents Flowcharts
- are used to represent the relationship between the key elements–input sources, programs, and output products–of
computer systems - depict the type of media being used (paper, magnetic tape, magnetic disks, and terminals)
- in practice, not much difference between document and system flowcharts
System Flowcharts
illustrate the logic used in problems
Program Flowcharts
- client-server based and process
transactions in real time - use relational database tables
- have high degree of process
integration and data sharing - some are mainframe based and use
batch processing
Some firms employ legacy systems for
certain aspects of their data processing. - Accountants need to understand
legacy systems.
Legacy systems charac
Modern systems
- mainframe-based applications
- batch oriented
- early legacy systems use flat files for
data storage - later legacy systems use hierarchical
and network databases - data storage systems promote a
single-user environment that
discourages information integration
Legacy systems
assemble transactions
into groups for processing. Under this
approach, there is always a time lag
between the point at which an economic
event occurs and the point at which it is
reflected in the firm’s accounts.
Batch Systems
process
transactions individually at the moment
the event occurs. Because records are
not grouped into batches, there are no
time lags between occurrence.
Real-time Systems
A batch is a group of similar transactions
that are accumulated over time and then
processed together.
* The transactions must be independent of
one another during the time period over
which the transactions are accumulated
in order for batch processing to be
appropriate.
* A time lag exists between the event and
the processing
Batch Processing
source documents are
transcribed by clerks to magnetic tape for
processing later
Keystroke (1)
- identifies clerical errors in the
batch and places them into an error file
Edit Run (2)
places the transaction file in
the same order as the master file using a
primary key
Sort Run (3)
changes the value of
appropriate fields in the master file to
reflect the transaction
Update Run (4)
the original master
continues to exist and a new master file is
created
Backup Procedure (5)
- process transactions individually at the
moment the economic event occurs - have no time lag between the economic
event and the processing - generally require greater resources than
batch processing since they require
dedicated processing capacity; however,
these cost differentials are decreasing - oftentimes have longer systems
development time
Real-Time Systems
DATA CODING SCHEMES
- SEQUENTIAL CODES
- BLOCK CODES
- GROUP CODES
- ALPHABETIC CODES
- MNEMONIC CODES
FINANCIAL REPORTING PROCESS
- Capture Transactions.
- Record the Special Journal.
- Post to Subsidiary Ledger.
- Post to General Ledger.
- Prepare the unadjusted trial balance.
- Make Adjusting Entries.
- Journalize & post adjusting entries.
- Prepare the trial balance.
- Prepare the FS.
- Journalize & post closing entries.
- Prepare the post-closing trial balance.
listing of transactions
o allocation of expenses to cost
centers
o comparison of account balances
from prior periods
o trial balances
General ledger analysis:
o balance sheet
o income statement
o statement of cash flows
Financial statements:
o analysis of sales
o analysis of cash
o analysis of receivables
Managerial Reports
coded listing of
accounts
Chart of accounts
is an XML-based language for
standardizing methods for preparing,
publishing, and exchanging financial
information, e.g., financial statements.
XBRL