Accounting Information System
Accounting Information System
Accounting Information System
Chapter 5
Accounting Information Systems
Applications
By
Andualem Ufo(PhD)
MSc Accounting and Finance Program
Ethiopian Civil Service University
The Revenue Cycle:
Sales to Cash Collections
REVENUE CYCLE BUSINESS
ACTIVITIES
Ac
kn 1.2
ow DFD for
l ed Approve
gm
en Credit Sales Order Entry
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow DFD for
l ed Approve
gm
en Credit Sales Order Entry
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow DFD for
l ed Approve
gm
en Credit Sales Order Entry
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow DFD for
l ed Approve
gm
en Credit Sales Order Entry
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
SALES ORDER ENTRY
Ac
kn 1.2
ow
l ed Approve
gm Credit
en
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow
l ed Approve
gm Credit
en
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
SALES ORDER ENTRY
Credit sales should be approved before the
order is processed any further.
There are two types of credit authorization:
– General authorization
• For existing customers below their credit limit who
don’t have past-due balances.
• Credit limits vary by customer based on past history
and ability to pay.
• General authorization involves checking the customer
master file to verify the account and status.
SALES ORDER ENTRY
• For customers who are:
New
–
Ac
kn 1.2
ow
l ed Approve
gm Credit
en
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow
l ed Approve
gm Credit
en
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
SALES ORDER ENTRY
Sales order entry is performed by the sales
order department.
The sales order department typically reports to
the VP of Marketing.
Steps in the process include:
– Take the customer’s order
– Check the customer’s credit
– Check inventory availability
– Respond to customer inquiries (may be done by
customer service or sales order entry)
SALES ORDER ENTRY
When the order has been received and the
customer’s credit approved, the next step is to
ensure there is sufficient inventory to fill the
order and advise the customer of the delivery
date.
The sales order clerk can usually reference a
screen displaying:
– Quantity on hand
– Quantity already committed to others
– Quantity on order
SALES ORDER ENTRY
If there are enough units to fill the order:
– Complete the sales order
– Update the quantity available field in the inventory file
– Notify the following departments of the sale:
Shipping
Inventory
Billing
– Send an acknowledgment to the customer
SALES ORDER ENTRY
If there’s not enough to fill the order, initiate a
back order.
– For manufacturing companies, notify the production
department that more should be manufactured.
– For retail companies, notify purchasing that more
should be purchased.
SALES ORDER ENTRY
Accurate inventory records are needed so
customers can be accurately advised of their
order status.
– Requires careful data entry in the sales and shipping
processes.
– Can be problematic in retail establishments:
Clerks running a similar item over the scanner several times
instead of running each item
Mishandling of sales returns such that returned merchandise
isn’t re-entered in inventory records
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow
l ed Approve
gm Credit
en
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
Orders 1.1
Customer Take Customer
Order
Rej
ect
e dO Orders
rde
rs
Response
Inquiries
Ac
kn 1.2
ow
l ed Approve
gm Credit
en
t
Customer Approved
Orders
1.3
1.4 Check
Sales Order Inv. Inventory
Resp. to
Avail.
Cust. Inq. Bac
k Or
ders
Sales Sales Picking
Order Order List
Ware- Purchas-
Shipping Billing
house ing
SALES ORDER ENTRY
Sales order entry is performed by the sales
order department.
The sales order department typically reports to
the VP of Marketing.
Steps in the process include:
– Take the customer’s order
– Check the customer’s credit
– Check inventory availability
– Respond to customer inquiries (may be done by
customer service or sales order entry)
SALES ORDER ENTRY
Another step in the sales order entry process is
responding to customer inquiries:
– May occur before or after the order is placed
– The quality of this customer service can be critical to
company success
SALES ORDER ENTRY
Many companies use Customer Relationship
Management (CRM) systems to support this
process:
– Organizes customer data to facilitate efficient and
personalized service
– Provides data about customer needs and business
practices so they can be contacted proactively about
the need to reorder
SALES ORDER ENTRY
Goods &
Sales Packing
Order List
Sales Order
2.2
Bill of Ship Inventory
Lading & Goods
Packing Slip
Carrier
Shipping
Sales Picking List 2.1
Order Pick &
Entry Pack
Goods &
Sales Packing
Order List
Sales Order
2.2
Bill of Ship Inventory
Lading & Goods
Packing Slip
Carrier
SHIPPING
The second basic activity in the revenue cycle is
filling customer orders and shipping the desired
merchandise.
The process consists of two steps
– Picking and packing the order
– Shipping the order
The warehouse department typically picks the order
The shipping departments packs and ships the
order
Both functions include custody of inventory and
ultimately report to the VP of Manufacturing.
SHIPPING
A picking ticket is printed by sales order entry
and triggers the pick-and-pack process
The picking ticket identifies:
– Which products to pick
– What quantity
Warehouse workers record the quantities picked
on the picking ticket, which may be a paper or
electronic document.
The picked inventory is then transferred to the
shipping department.
SHIPPING
Technology can speed the movement of
inventory and improve the accuracy of perpetual
inventory records:
– Bar code scanners
– Conveyer belts
– Wireless technology so workers can receive
instructions without returning to dispatch
– Radio frequency identification (RFID) tags:
Eliminate the need to align goods with scanner
Allow inventory to be tracked as it moves through warehouse
Can store up to 128 bytes of data
Sales Picking List 2.1
Order Pick &
Entry Pack
Goods &
Sales Packing
Order List
Sales Order
2.2
Bill of Ship Inventory
Lading & Goods
Packing Slip
Carrier
Sales Picking List 2.1
Order Pick &
Entry Pack
Goods &
Sales Packing
Order List
Sales Order
2.2
Bill of Ship Inventory
Lading & Goods
Packing Slip
Carrier
SHIPPING
The second basic activity in the revenue cycle is
filling customer orders and shipping the desired
merchandise.
The process consists of two steps
– Picking and packing the order
– Shipping the order
The warehouse department typically picks the order
The shipping departments packs and ships the
order
Both functions include custody of inventory and
ultimately report to the VP of Manufacturing.
SHIPPING
The shipping department compares the following
quantities:
– Physical count of inventory
– Quantities indicated on picking ticket
– Quantities on sales order
Discrepancies can arise if:
– Items weren’t stored in the location indicated
– Perpetual inventory records were inaccurate
If there are discrepancies, a back order is
initiated.
SHIPPING
The clerk then records online:
– The sales order number
– The item numbers ordered
– The quantities shipped
This process:
– Updates the quantity-on-hand field in the inventory
master file
– Produces a packing slip
• The packing slip lists the quantity and description of
each item in the shipment.
SHIPPING
The clerk then records online:
– The sales• order number
The bill of lading is a legal contract that defines
– The item numbers ordered
responsibility for goods in transit
• It identifies:
– The quantities shipped
The carrier
–
This produces– The source
– Updates the –quantity-on-hand
The destination field in the inventory
master file – Special shipping instructions
– Produces a packing slipfor the shipping
– Who pays
Invoice
Sales
General
Ledger &
Rept. Sys. Customer Sales Customer
s
ment
ta te
S
nthly
Mo
3.2
Billing and Maintain Mailroom
Accounts Accts. Remittance
Rec. List
Receivable
p&
Packing Sli
Sales g
Sales Order 3.1 Bill of Ladin
Order Shipping
Entry Billing
Invoice
Sales
General
Ledger &
Rept. Sys. Customer Sales Customer
s
ment
ta te
S
nthly
Mo
3.2
Billing and Maintain Mailroom
Accounts Accts. Remittance
Rec. List
Receivable
BILLING
The third revenue cycle activity is billing
customers.
This activity involves two tasks:
– Invoicing
– Updating accounts receivable
BILLING
Accurate and timely billing is crucial.
Billing is an information processing activity
that repackages and summarizes information
from the sales order entry and shipping
activities
Requires information from:
– Shipping Department on items and quantities
shipped
– Sales on prices and other sales terms
BILLING
The basic document created is the sales
invoice. The invoice notifies the customer of:
– The amount to be paid
– Where to send payment
Invoices may be sent/received:
– In paper form
– By EDI
Common for larger companies
Faster and cheaper than snail mail
BILLING
When buyer and seller have accurate online
systems:
– Invoicing process may be skipped
Seller sends an email when goods are shipped
Buyer sends acknowledgment when goods are
received
Buyer automatically remits payments within a specified
number of days after receiving the goods
– Can produce substantial cost savings
BILLING
An integrated AIS may also merge the billing
process with sales and marketing by using
data about a customer’s past purchases to
send information about related products and
services with his monthly statement.
p&
Packing Sli
Sales g
Sales Order 3.1 Bill of Ladin
Order Shipping
Entry Billing
Invoice
Sales
General
Ledger &
Rept. Sys. Customer Sales Customer
s
ment
ta te
S
nthly
Mo
3.2
Maintain Mailroom
Accts. Remittance
Rec. List
p&
Packing Sli
Sales g
Sales Order 3.1 Bill of Ladin
Order Shipping
Entry Billing
Invoice
Sales
General
Ledger &
Rept. Sys. Customer Sales Customer
s
ment
ta te
S
nthly
Mo
3.2
Maintain Mailroom
Accts. Remittance
Rec. List
BILLING
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a reh o u se S h ip p in g C o n tr o lle r T re a s u re r
O rd e r S e rv ic e
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a reh o u se S h ip p in g C o n tr o lle r T re a s u re r
O rd er S e rv ic e
• Responds to B illin g A c c o u n ts C r e d it C a s h ie r
customer inquiries
D e p t. R e c e iv a b le M anager
PARTIAL ORGANIZATION CHART FOR
UNITS INVOLVED IN REVENUE CYCLE
CEO
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a reh o u se S h ip p in g C o n tr o lle r T re a s u re r
O rd e r S e rv ic e
CEO
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a re h o u se S h ip p in g C o n tr o lle r T re a s u rer
O rd e r S e rv ic e
CEO
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a reh o u s e S h ip p in g C o n tr o lle r T re a s u re r
O rd e r S e rv ic e
B illin g A c c o u n ts C r e d it C a s h ie r
• Invoices the D e p t. R e c e iv a b le M anager
customer
PARTIAL ORGANIZATION CHART FOR
UNITS INVOLVED IN REVENUE CYCLE
CEO
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a re h o u s e S h ip p in g C o n tr o lle r T re a s u re r
O rd e r S e rv ic e
CEO
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
S a le s C u s to m e r W a reh o u s e S h ip p in g C o n tr o lle r T re a s u re r
O rd e r S e rv ic e
• Approves credit for new
customers or existing
customers with issues B illin g A c c o u n ts C r e d it C a s h ie r
• Authorizes credits to customer D e p t. R e c e iv a b le M anager
accounts for returns,
allowances, and write-offs
PARTIAL ORGANIZATION CHART FOR
UNITS INVOLVED IN REVENUE CYCLE
CEO
V P o f M a r k e tin g V P o f M a n u fa c tu r in g CFO
B illin g A c c o u n ts C r e d it C a s h ie r
• Deposits cash D e p t. R e c e iv a b le M anager
received from
customers
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
In the revenue cycle (or any cycle), a well-designed AIS
should provide adequate controls to ensure that the
following objectives are met:
– All transactions are properly authorized
– All recorded transactions are valid
– All valid and authorized transactions are recorded
– All transactions are recorded accurately
– Assets are safeguarded from loss or theft
– Business activities are performed efficiently and effectively
– The company is in compliance with all applicable laws and
regulations
– All disclosures are full and fair
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
We’ll soon be discussing the threats that may
occur in the revenue cycle.
If you understand the preceding objectives, you
probably won’t have to worry about “memorizing”
threats.
Almost every threat represents a violation of one
of those control objectives.
Let’s look more closely.
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
In the revenue cycle (or any cycle), a well-designed AIS
should provide adequate controls to ensure that the
following objectives are met:
– All transactions are properly authorized
– A related threat
All recorded• transactions would be that a transaction
are valid
– would gotransactions
All valid and authorized through without proper authorization.
are recorded
• Such a transaction might result from either a
– All transactions are recorded accurately
mistake or a fraud.
– Assets are safeguarded from loss or theft
• EXAMPLE: An employee might process an
– Business activities are performed
unauthorized efficiently
write-off of his and
owneffectively
account, so
– The company is that he wouldn’twith
in compliance havealltoapplicable
pay. laws and
regulations
– All disclosures are full and fair
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
In the revenue cycle (or any cycle), a well-designed AIS
should provide adequate controls to ensure that the
following objectives are met:
– All transactions are properly authorized
– All recorded transactions are valid
•– The related
All valid andthreat is thattransactions
authorized a transaction
arewould be recorded that
recorded
– isn’t valid, i.e., itare
All transactions didn’t actually
recorded occur.
accurately
• EXAMPLE 1: An employee records a return of merchandise on
– Assets are safeguarded from loss or theft
his own account when the goods were never really returned.
– Business activities are performed efficiently and effectively
• EXAMPLE 2: Many financial statement frauds involve companie
– The company
recording is infictitious
totally compliance with allinapplicable
revenues laws the
order to make and
regulations financial position appear more favorable than it
company’s
– actually is.
All disclosures are full and fair
• The related threat would be that a transaction that actually did
CONTROL: OBJECTIVES,
occur didn’t get recorded.
CEO
V P o f M a n u fa c tu r in g CFO
P u r c h a s in g R e c e iv in g In v e n to r y C o n tr o lle r T re a s u re r
S to re s
CEO
V P o f M a n u fa c tu r in g CFO
P u r c h a s in g R e c e iv in g In v e n to r y C o n tr o lle r T re a s u rer
S to re s
CEO
V P o f M a n u fa c tu r in g CFO
P u r c h a s in g R e c e iv in g In v e n to r y C o n tr o lle r T re a s u rer
S to re s
CEO
V P o f M a n u fa c tu r in g CFO
P u r c h a s in g R e c e iv in g In v e n to r y C o n tr o lle r T re a s u rer
S to re s
• Approves invoices A c c o u n ts C a s h ie r
for payment
P a y a b le
PARTIAL ORGANIZATION CHART FOR UNITS
INVOLVED IN EXPENDITURE CYCLE
CEO
V P o f M a n u fa c tu r in g CFO
P u r c h a s in g R e c e iv in g In v e n to r y C o n tr o lle r T re a s u re r
S to r e s
A c c o u n ts C a s h ie r
P a y a b le
• Issues payment to
vendors
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
In the expenditure cycle (or any cycle), a well-designed
AIS should provide adequate controls to ensure that the
following objectives are met:
– All transactions are properly authorized
– All recorded transactions are valid
– All valid and authorized transactions are recorded
– All transactions are recorded accurately
– Assets are safeguarded from loss or theft
– Business activities are performed efficiently and effectively
– The company is in compliance with all applicable laws and
regulations
– All disclosures are full and fair
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
There are several actions a company can take
with respect to any cycle to reduce threats of
errors or irregularities. These include:
– Using simple, easy-to-complete documents with
clear instructions (enhances accuracy and
reliability).
– Using appropriate application controls, such as
validity checks and field checks (enhances
accuracy and reliability).
– Providing space on forms to record who completed
and who reviewed the form (encourages proper
authorizations and accountability).
CONTROL: OBJECTIVES,
THREATS, AND PROCEDURES
– Pre-numbering documents (encourages recording
of valid and only valid transactions).
– Restricting access to blank documents (reduces
risk of unauthorized transaction).