Title: OACR audit focus
Full Citation
Permanent Link: http://ufdc.ufl.edu/UF00087344/00026
 Material Information
Title: OACR audit focus
Physical Description: Serial
Language: English
Creator: Office of Audit & Compliance Review, University of Florida
Publisher: Office of Audit & Compliance Review
Place of Publication: Gainesville, Fla.
Publication Date: February 2009
 Record Information
Bibliographic ID: UF00087344
Volume ID: VID00026
Source Institution: University of Florida
Holding Location: University of Florida
Rights Management: All rights reserved by the source institution and holding location.


This item has the following downloads:

February%202009 ( PDF )

Full Text


SuR Audit Focus

Brian Mikell, Chief Audit Executive

Inside this issue:

Ve're on the Web at:

A quarterly newsletter from the Office of
Audit & Compliance Review

Spedhe ControlS s

Spreadsheets are used widely across
campus for managing and reporting
data. Many applications are large
and complex. Some are built and
used by one user, while others have
many users who modify or add data
and change formulas and reporting
formats. Recent studies show that
up to 90 percent of large spread-
sheets contain non-trivial errors.
The University of Michigan devel-
oped a self-assessment question-
naire to assist units in examining
controls over spreadsheets.

The self-assessment questionnaire
(link) addresses the following areas
of spreadsheet controls:
* User Access-User access ad-
dresses the question of who can
access a spreadsheet and what
they can do with it once they
have access.
* Data Transmission-Microsoft
Excel has the ability to transfer
information between individual
worksheets within a workbook
and between different spread-
* Documentation-Knowing what
spreadsheets exist and how they
are used is the first step in de-
termining how to secure them.

* Development-Good processes
should be in place for the devel-
opment of new spreadsheets be-
fore bringing them into the pro-
duction environment to ensure
that they are error free and prop-
erly documented.
* Segregation of Duties-One per-
son may enter data, perform the
steps to process the data, and
deliver the output. Concentrat-
ing these duties with a single in-
dividual creates a segregation of
duties issue.
* Version Controls-Because
spreadsheets are heavily used
for tracking, multiple versions
are frequently kept. In order to
ensure that all users are working
with the most current version,
older versions should be well-
* Storage, Backup and Recovery-
Spreadsheets often contain data
that is integral to the way an of-
fice functions and is critical to
business processes. The impor-
tance of these spreadsheets
makes good backup and recov-
ery procedures essential.
We encourage the use of this tool to
better secure spreadsheets to ensure
data integrity.


Off*e of Aui.
903 WesitirUn~iv~ersityTi'

*ansvle FL


Tel: (352) 392139S 1
Fax (329234


The University
of Florida's
2007-2008 an-
nual financial
report was is-
sued this quar-

The Auditor
General's report

for the year ended June 30, 2008, was
included. The Auditor General re-
ported that the financial statements
represented fairly, in all material re-
spects, the financial position of the
University of Florida. The report is
available for viewing at the Finance &
Accounting website http://fa.ufl.edu/
ga / a f r / f v 2 0 0 7-
08 annual financial renort.ndf.

TAM Exmp Tim -

We would like to remind campus
units that TEAMS exempt employees,
along with Academic Personnel, do
not need to enter time worked in
myUFL. Hours are automatically
populated for time worked and em-
ployees need only report exceptions
such as leave taken.

Many TEAMS employees are exempt
from the Fair Labor Standards Act
(FLSA) and therefore are NOT com-

pensated for more than 40 hours in a
week. For example:
* An exempt employee works 10
hours in a day. Do not adjust
hours in myUFL.
* An exempt employee works 5
hours in a day. Enter 3 hours
leave in myUFL.

If you are not sure if you are exempt
or non-exempt, contact your unit ad-
ministrator or Human Resources.

The OACR is pleased to announce
that effective February 1, 2009,
Brian Mikell, CPA, was appointed
Chief Audit Executive replacing Nur
Erenguc. Brian has served as
OACR's Director of Audit & Manage-
ment Advisory Services since April
30, 2004. Prior to joining OACR, he
served 22 years as an external audi-
tor with the Florida Auditor Gen-
eral's Office, mostly involved with
audits at the University of Florida.
Brian is a University of Florida alum-
nus. He can be reached at 392-1391
or by e-mail at bmikell@ufl.edu.
Please visit us on the web at http://


University of Florida Home Page
© 2004 - 2010 University of Florida George A. Smathers Libraries.
All rights reserved.

Acceptable Use, Copyright, and Disclaimer Statement
Last updated October 10, 2010 - - mvs