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

Required:

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
advantage and disadvantage of joint auditor?

Problem: (a) Your client has sought your advise on the procedures to be adopted for carrying out the stocktaking which is based on a year-end count. You are required to prepa

#Fortex Limited, the meat processing firm, was formed in 1985 from three smaller companies. In 1993, however, after a few years of spectacular growth, the company collapsed. a) S

Ask quesThe following situations involve a possible violation of the MIA ByLaws (on professional ethics, conduct and practice). For each situation, (1) decide whether or not the Co

General Verification Procedures - Audit Process 1. Get or prepare a schedule for each and every class of liability. Usually this would indicate the makeup of the liability a

Question: Part A (i) List and define five audit procedures for obtaining audit evidence. (ii) Why is it necessary to obtain corroborating evidence for inquiry and obser

Your firm has recently been appointed auditors of the Social Transport Corporation and you are commencing the audit of the wages system. The Corporation has about 2500 employee

Managements interest in the accounting system Management needs complete and accurate books of accounts because: There is no other way the business can be controlled; Rec

Seek Out Transactions with Related Parties  Within the course of the audit, the auditor carries out process that may identify the existence of transactions along with related

Historic Costs Methods - Long Term Contracts You will notice such this exercise is completely dependent on the company estimating its further costs.  This is wherever the audi