Develop an audit program to identify fraud using acl, Auditing

You are auditing Pell grant provided to students at six state universities. The Pell grant program is a federal financial aid program for college students. The maximum grant a student can receive during a school year is $3,125 with a maximum of $1,041.67 per semester and summer session. The amount of a grant depends on financial need and the number of credits taken (status). Students cannot receive a grant at two different schools during the same school term.

SSN: Social security number

Last: Students last name

First: Students first name

Middle: Students middle name or initial

School: School- Coded 1 to 6

Term: Coded 1 to 3

1- Fall semester

2- Spring semester

3- Summer semester

*Need: Financial need - coded 1 to 5

1- 100% of allowable grant

2- 75%

3- 50%

4- 25%

5- 0%

*Status: Credit taken - Coded 1 to 4

1-12 or more credits: 100%

2-9 to 11 credits 75%

3-6 to 8 credits 50%

4-3 to 5 credits 25%

Amount: Amount of grant for the term

Computation of grant $3,125/3 * Need * Status

For a full time student with maximum need:

$3,125 / 3 * 100% * 100% = $1,041.67

For a student with a code 3 need taking 9 credits

$3,125 / 3 * 50% * 75% = $390.63


1. Develop an audit program to identify potential fraud using ACL

2. Use ACL to perform the steps in your audit program. Turn in the following:

a. Your audit program referenced to the ACL printouts supporting each audit step.

b. A report on your finding including additional steps you would take to determine if fraud actually occurred

c. Appropriate ACL printouts properly indexed with comments written on the printout to explain the printout and its implications. Do not print out the entire grant file. Extract only the items of significance.

Posted Date: 2/28/2013 12:54:46 AM | Location : United States

Related Discussions:- Develop an audit program to identify fraud using acl, Assignment Help, Ask Question on Develop an audit program to identify fraud using acl, Get Answer, Expert's Help, Develop an audit program to identify fraud using acl Discussions

Write discussion on Develop an audit program to identify fraud using acl
Your posts are moderated
Related Questions
Issues in Audit of Intangible Assets The two key issues in such audit of intangible assets are: (a) Recognition of intangible assets The audit problem here is to mak

Goodwill and Fair Value The main points the auditor needs to verify for any goodwill arising in the accounting period are as follows: (i) Examine the procedure used to find


Analyse the ratios in conjunction with the additional information and identify from your analysis, implications for the audit and any particular audit steps that need to be underta

The Accounting System ISA 400 Risk Assessment and Internal Control accounting system are the sequence of tasks and records of an entity by which transactions are procedure as a

Counter - Indications That the auditor has found indications of going related to non-applicability does not of itself justify instantly conclusion that the entity is not a goi

I have a auditing case study i need to complete in chapter 8 of Auditing & Assurance service (fifteenth edition) by Alvin A. Arens, Randal J. Elder and Mark S. Beasley. I don''t kn

Motor Vehicles - Audit Process Similar considerations govern the audit of motor vehicles as to those relating to machinery and plant.  The simply matter of consideration now i

Part A: What are the five inter-related components of internal control? Briefly discuss them. Part B: A file maintained by the Accounts Department for one of Sharp's s

Audit Function The audit functions as follows as: 1. To verify the estimation of timing differences; 2. To ensure such permanent differences have not been got into accou