AIS Chapter 4 - PAYROLL & FIXED ASSETS
AIS Chapter 4 - PAYROLL & FIXED ASSETS
AIS Chapter 4 - PAYROLL & FIXED ASSETS
INFORMATION
SYSTEM
1
CHAPTER 4
2
A. PAYROLL
1. The Conceptual Payroll System
2. The Physical Payroll System
3. Reengineering the Payroll System
B. FIXED ASSETS
1. The Conceptual Fixed Asset System
2. The Physical Fixed Asset System
3. Controlling The Fixed Asset System
3
A. PAYROLL
4
1. The Conceptual Payroll System
1. Personnel Department
5
1. The Conceptual Payroll System
2. Production Department
Production employees prepare two types of time
records:
1. Job tickets (Figure 4-3) capture the time that
individual workers spend on each production job.
Cost accounting uses these documents to allocate
direct labor charges to work-in-process (WIP)
accounts.
2. Time cards (Figure 4-4) capture the time the
employee is at work. These are sent to the prepare
payroll function for calculating the amount of the
employee’s paycheck. 6
1. The Conceptual Payroll System
7
1. The Conceptual Payroll System
4. Payroll Department
1. Prepare the payroll register (Figure 4-5) showing gross
pay, deductions, overtime pay, and net pay.
2. Enter this information into the employee payroll
records (Figure 4-6).
3. Prepare employee paychecks (Figure 4-7).
4. Send the paychecks to the distribute paycheck
function.
5. File the time cards, personnel action form, and copy
of the payroll register.
8
1. The Conceptual Payroll System
5. Distribute Paycheck
A form of payroll fraud involves submitting time cards for
nonexistent employees. To prevent this, many
companies use a paymaster to distribute the paychecks
to employees. This individual is independent of the
payroll process—not involved in payroll authorization or
preparation tasks. If a valid employee does not claim a
paycheck, the paymaster returns the check to payroll.
The reason the check went unclaimed can then be
investigated.
9
1. The Conceptual Payroll System
10
1. The Conceptual Payroll System
PAYROLL CONTROLS
1. Transaction Authorization
A form of payroll fraud involves submitting time cards
for employees who no longer work for the firm. To
prevent this, the personnel action form helps payroll
keep the employee records current.
PAYROLL CONTROLS
2. Segregation of Duties
The time-keeping function and the personnel function
should be separated. The personnel function provides
payroll with pay rate information for authorized hourly
employees.
Typically, an organization will offer a range of valid pay
rates based on experience, job classification, seniority,
and merit. If the production (time-keeping)
department provided this information, an employee
might submit a higher rate and perpetrate a fraud.
14
1. The Conceptual Payroll System
PAYROLL CONTROLS
2. Segregation of Duties (cont.)
For purposes of operational efficiency, the payroll function
performs several tasks. Some of these are in contradiction with
basic internal control objectives. For example, the payroll function
has both asset custody (employee paychecks) and
record-keeping responsibility (employee payroll records). This is
the equivalent in the general purchases system of assigning AP
and cash disbursement responsibility to the same person.
PAYROLL CONTROLS
3. Supervision
Sometimes employees will clock in for another worker
who is late or absent. Supervisors should observe the
time-keeping process and reconcile the time cards
with actual attendance.
16
1. The Conceptual Payroll System
PAYROLL CONTROLS
4. Accounting Records
The audit trail for payroll includes the following
documents:
1. Time cards, job tickets, and disbursement vouchers.
2. Journal information, which comes from the labor
distribution summary and the payroll register.
3. Subsidiary ledger accounts, which contain the
employee records and various expense accounts.
4. The general ledger accounts: payroll control,
cash, and the payroll clearing (imprest) account. 17
1. The Conceptual Payroll System
PAYROLL CONTROLS
5. Access Controls
The assets associated with the payroll system are labor
and cash. Both can be misappropriated through
improper access to accounting records.
A dishonest individual can misrepresent the number of
hours worked on the time cards and thus embezzle
cash.
Similarly, control over access to all journals, ledgers,
and source documents in the payroll system is
important, as it is in all expenditure cycle systems. 18
1. The Conceptual Payroll System
PAYROLL CONTROLS
6. Independent Verification
The following are examples of independent verification controls in
the payroll system:
1. Verification of time. Before sending time cards to payroll, the
supervisor must verify their accuracy and sign them.
2. Paymaster. The use of an independent paymaster to distribute
checks (rather than the normal supervisor) helps verify the
existence of the employees. The supervisor may be party to a
payroll fraud by pretending to distribute paychecks to nonexistent
employees.
3. Accounts payable. The AP clerk verifies the accuracy of the
payroll register before creating a disbursement voucher that
transfers funds to the imprest account.
4. General ledger. The general ledger department provides
verification of the overall process by reconciling the labor 19
20
2. The Physical Payroll System
MANUAL PAYROLL SYSTEM (Figure 4-8).
1. Payroll authorization and hours worked enter the payroll
department from two different sources: personnel and
production.
2. The payroll department reconciles this information, calculates
the payroll, and distributes paychecks to the employees.
3. Cost accounting receives information regarding the time
spent on each job from production. This is used for posting to
WIP account.
4. AP receives payroll summary information from the payroll
department and authorizes the cash disbursements
department to deposit a single check, in the amount of the
total payroll, in a bank imprest account on which the payroll is
drawn.
5. The general ledger department reconciles summary
information from cost accounting and AP. Control accounts 21
are updated to reflect these transactions.
2. The Physical Payroll System
COMPUTER-BASED PAYROLL SYSTEM
AUTOMATING THE PAYROLL SYSTEM USING BATCH PROCESSING
(Figure 4-9)
Because payroll systems run periodically (weekly or monthly), they
are well suited to batch processing. The data processing
department receives hard copy of the personnel action forms, job
tickets, and time cards, which it converts to digital files. Batch
computer programs perform the check writing, detailed record
keeping, and general ledger functions.
23
3. Reengineering the Payroll System
For moderate-sized and large organizations, payroll processing is
often integrated within the human resource management (HRM)
system. The HRM system captures and processes a wide range of
personnel-related data, including employee benefits, labor
resource planning, employee relations, employee skills, and
personnel actions (pay rates, deductions, and so on), as well as
payroll.
This system differs from the simple automated system in three ways:
(1) the various departments transmit transactions to data
processing via terminals,
(2) direct access files are used for data storage, and
(3) many processes are now performed in real time. 24
3. Reengineering the Payroll System
1. Personnel Department
The personnel department makes changes to the
employee file in real time via terminals. These
changes include additions of new employees,
deletions of terminated employees, changes in
dependents, changes in withholding, and changes
in job status (pay rate).
25
3. Reengineering the Payroll System
2. Cost Accounting
The cost accounting department enters job cost
data (real time or daily) to create the labor usage
file.
26
3. Reengineering the Payroll System
3. Time-Keeping
Upon receipt of the approved time cards from the
supervisor at the end of the week, the time-keeping
department creates the current attendance file.
27
3. Reengineering the Payroll System
4. Data Processing
At the end of the work period, the following tasks
are performed in a batch process:
31
1. The Conceptual Fixed Asset System
35
1. The Conceptual Fixed Asset System
1. Asset Acquisition
37
1. The Conceptual Fixed Asset System
2. Asset Maintenance
• Asset maintenance involves adjusting the fixed asset
subsidiary account balances as the assets (excluding
land) depreciate over time or with usage.
• Common depreciation methods in use are straight
line, sum-of- the-years’ digits, double-declining
balance, and units of production. The method of
depreciation and the period used should reflect, as
closely as possible, the asset’s actual decline in utility
to the firm.
• Accounting conventions and BIR rules sometimes
specify the depreciation method to be used.
38
1. The Conceptual Fixed Asset System
2. Asset Maintenance (cont.)
• Depreciation calculations are transactions that the
fixed asset system must be designed to anticipate
internally when no external event (source document)
triggers the action.
• An important record used to initiate this task is the
depreciation schedule. A separate depreciation
schedule, such as the one illustrated in Figure 4-12, will
be prepared by the system for each fixed asset in the
fixed asset subsidiary ledger.
• A depreciation schedule shows when and how much
depreciation to record. It also shows when to stop
taking depreciation on fully depreciated assets. This
information in a management report is also useful 39
41
1. The Conceptual Fixed Asset System
3. Asset Disposal
43
1. The Physical Fixed Asset System
COMPUTER-BASED FIXED ASSET SYSTEM
• Because many of the tasks in the fixed asset system
are similar in concept to the purchases system in
Chapter 3, we will dispense with a review of manual
procedures.
• Figure 4-13 illustrates a computer-based fixed asset
system, which demonstrates real-time processing.
• The top portion of the flowchart presents the fixed
asset acquisition procedures, the center portion
presents fixed asset maintenance procedures, and
the bottom portion presents the asset disposal
procedures.
• Note: To simplify the flowchart and focus on the key features of the system, 44
we have omitted the processing steps for AP and cash disbursements.
1. The Physical Fixed Asset System
1. Acquisition Procedures
• The process begins when the fixed asset accounting clerk
receives a receiving report and a cash disbursement
voucher. These documents provide evidence that the
firm has physically received the asset and show its cost.
From the computer terminal, a clerk creates a record of
the asset in the fixed asset subsidiary ledger. Figure 4-14
presents a possible record structure for this file.
• When the clerk deletes the record from the fixed asset
subsidiary ledger, the system automatically
(1) posts an adjusting entry to the fixed asset control
account in the general ledger,
(2) records any loss or gain associated with the disposal,
and
(3) prepares a journal voucher. A fixed asset status report
containing details of the deletion is sent to the fixed asset
department for review.
48
A. FIXED ASSET
49
3. Controlling the Fixed Asset System
50
3. Controlling the Fixed Asset System
1. Authorization Controls
• Fixed asset acquisitions should be formal and
explicitly authorized.
• Each transaction should be initiated by a written
request from the user or department.
• In the case of high-value items, there should be an
independent approval process that evaluates the
merits of the request on a cost-benefit basis.
51
3. Controlling the Fixed Asset System
2. Supervision Controls
• Because capital assets are widely distributed throughout
the organization, they are more susceptible to theft and
misappropriation than inventories that are secured in a
warehouse.
• Therefore, management supervision is an important
element in the physical security of fixed assets.
Supervisors must ensure that fixed assets are being used
in accordance with the organization’s policies and
business practices.
• For example, laptops purchased for individual employees
should be secured in their proper location and should not be
removed from the premises without explicit approval.
Company vehicles should be secured in the organization’s
motor pool at the end of the shift and should not be taken 52
home for personal use unless authorized by the appropriate
supervisor.
3. Controlling the Fixed Asset System
3. Independent Verification Controls
• Periodically, the internal auditor should review the asset
acquisition and approval procedures to determine the
reasonableness of factors used in the analysis. These
include the useful life of the asset, the original financial cost,
the proposed cost savings as a result of acquiring the asset,
the discount rate used, and the capital budgeting method
used in the analysis.
• The internal auditor should verify the location, condition,
and fair value of the organization’s fixed assets against the
fixed asset records in the subsidiary ledger. In addition, the
automatic depreciation charges calculated by the fixed
asset system should be reviewed and verified for accuracy
and completeness. System errors that miscalculate
depreciation can result in the material misstatement of 53
operating expenses, reported earnings, and asset values.
End of
Chapter 4
54