Skip navigation

Denver Office of the Auditor - Keefe Commissary Network Audit, 2009

Download original document:
Brief thumbnail
This text is machine-read, and may contain errors. Check the original document to verify accuracy.
OFFICE OF THE AUDITOR

DENVER SHERIFF DEPARTMENT
KEEFE COMMISSARY NETWORK, LLC
REVENUE AND CONTRACT COMPLIANCE AUDIT
JANUARY 2009

Dennis J. Gallagher
Auditor

City and County of Denver
201 West Colfax Ave., Dept. 705 • Denver, Colorado 80202 • 720-913-5000, FAX 720-913-5247
www.denvergov.org/auditor

Dennis J. Gallagher
Auditor

January 28, 2009
Mr. William R. Lovingier
Director of Corrections and Undersheriff
Denver Sheriff Department
City and County of Denver
Dear Mr. Lovingier:
Attached is the Auditor’s Office Audit Services Division’s revenue and contract compliance
audit report of the Keefe Commissary Network, LLC contract dated October 1, 2006. The audit
was for the period October 1, 2006 through December 31, 2007. The purpose of the audit was to
determine if Keefe Commissary Network, LLC and the Denver Sheriff Department complied
with the terms of the contract and whether internal controls in place were adequate.
The audit revealed reportable weaknesses related to contract administration, internal controls,
and contract compliance. These weaknesses are disclosed in detail within the accompanying
report.
If you have any questions, please contact Kip Memmott, Director of Audit Services, at
720-913-5029.
Sincerely,

Dennis J. Gallagher
Auditor
DJG/ect
cc:

Honorable John Hickenlooper, Mayor
Honorable Members of City Council
Members of Audit Committee
Ms. Kelly Brough, Chief of Staff
Mr. Claude Pumilia, Chief Financial Officer
Mr. Chris Henderson, Chief Operating Officer
Mr. David Fine, City Attorney

To promote open, accountable, efficient and effective government by performing impartial reviews and other audit
services that provide objective and useful information to improve decision making by management and the people.
We will monitor and report on recommendations and progress towards their implementation.
1

Mr. Lovingier and Mr. Archer
January 28, 2009
Page Two
Ms. Lauri Dannemiller, City Council Executive Staff Director
Ms. Beth Machann, Controller
Mr. Alvin LaCabe, Manager of Safety
Mr. Michael Henry, Interim Director
Mr. Mike Archer, Regional Vice President, Keefe Commissary Network, LLC

2

TABLE OF CONTENTS

Transmittal Letter

1

Table of Contents

3

Auditor’s Report

4

Executive Summary

5

Background, Scope, Objective, and Methodology

6

Findings, Recommendations, and Responses

8

Schedule of Amount Due and Paid and Related Notes

11

Exhibit A – Denver Sheriff Department Response

13

3

City and County of Denver
201 West Colfax Ave., Dept. 705 • Denver, Colorado 80202 • 720-913-5000, FAX 720-913-5247
www.denvergov.org/auditor

Dennis J. Gallagher
Auditor

AUDITOR’S REPORT
We have completed a revenue and contract compliance audit of the agreement dated October 1,
2006 between Keefe Commissary Network, LLC (Keefe) and the Denver Sheriff Department
(DSD). The purpose of the audit was to determine whether Keefe and DSD complied with
various terms and conditions of the contract as well as City and County of Denver rules and
regulations. This audit was included in the Auditor’s Office Audit Services Division’s Annual
Audit Plan and is authorized pursuant to the City and County of Denver Charter, Article V, Part
2, Section 1, General Powers and Duties of Auditor. We conducted our audit in accordance with
generally accepted government auditing standards.
The audit revealed Keefe and DSD did not comply with important provisions of the contract
related to payment terms, amounts due, insurance, and reporting requirements.
We extend our appreciation to the personnel who assisted and cooperated with us during the
audit.
Audit Services Division

Kip R. Memmott, MA, CGAP, CICA
Director of Audit Services

Date: January 28, 2009
Staff: Ken Kemple, CISA, CICA, Deputy Director
Mike Widner, CICA, Audit Supervisor
Manijeh Taherynia, CPA, CFE, Senior Internal Auditor
Rebecca Corral, CFE, Senior Internal Auditor

To promote open, accountable, efficient and effective government by performing impartial reviews and other audit
services that provide objective and useful information to improve decision making by management and the people.
We will monitor and report on recommendations and progress towards their implementation.
4

KEEFE COMMISSARY NETWORK LLC
EXECUTIVE SUMMARY
FOR THE PERIOD OCTOBER 1, 2006 THROUGH DECEMBER 31, 2007

This summary highlights the findings of the revenue and contract compliance audit of the Keefe
Commissary Network, LLC (Keefe) contract. The Findings and Recommendations section of
the report beginning on page 8 further describes these issues in detail. The responses from the
Denver Sheriff Department (DSD) to these findings are contained in Exhibit A.
Finding I - Non-Compliance with Contract Terms Caused Underpayment and Increased
Risk to the City
Audit work revealed DSD made verbal agreements with Keefe regarding payment terms and
commissions in violation of Executive Order No. 8. Furthermore, we noted DSD failed to
properly monitor and enforce Keefe’s compliance with contract provisions regarding insurance,
financial, and other reporting requirements.
Unauthorized Payment Process - The contract provisions require DSD to remit gross
commissary receipts to Keefe on a weekly basis. Keefe is then required to calculate and pay
monthly commissions of 44% on commissary sales after deducting appropriate taxes. However,
DSD and Keefe enacted a verbal agreement which changed the payment process. Based on the
existing verbal agreement, DSD does not make weekly payments. Instead, DSD retains
commissions calculated by Keefe’s system and pays the contractor monthly for the remaining
balance.
Improper Calculation of Commissions - The contract defines commissions due as 44% of gross
receipts, net of applicable taxes. However, audit work revealed DSD instructed Keefe to reduce
the prices charged to inmates for certain clothing items and, in return, make sales of these items
subject to a 20% commission rate. Additionally, audit work noted the combined sales tax rate
was incorrectly programmed in Keefe’s software which resulted in understated sales tax
deductions for the entire audit period. As a result of these two issues, DSD collected $5,940 less
than the commission amount prescribed by the contract. In addition, since Keefe does not
actually make payments to DSD, we were unable to assess late payment interest penalties on
amounts due.
Non-Enforcement of Contract Provisions - We noted DSD failed to enforce Keefe’s
compliance with contract requirements related to insurance coverage, submission of monthly and
annual financial reports, and evidence of compliance with Payment Card Industry Data Security
Standards (PCI DSS) during the audit period.
Recommendations
We recommend DSD assess and collect the $5,940 due from Keefe. We recommend DSD and
Keefe immediately discontinue their verbal agreements and follow the contract provisions until
proper contract amendments are enacted. We also recommend DSD monitor and enforce
insurance, financial, and other reporting requirements to mitigate risks to the City.

5

KEEFE COMMISSARY NETWORK, LLC
BACKGROUND, SCOPE, OBJECTIVE, AND METHODOLOGY
FOR THE PERIOD OCTOBER 1, 2006 THROUGH DECEMBER 31, 2007

Background
Keefe Commissary Network, LLC (Keefe) entered into an agreement with the Denver Sheriff
Department (DSD) effective October 1, 2006 to exclusively provide canteen and commissary
services for the inmate population at the Denver County Jail and the Pre-Arraignment Detention
Facility. The contract extends through December 31, 2008 and may be renewed for up to four
additional years subject to the parties’ agreement and execution of such agreement.
The “Undersheriff Prisoner Purchase, Welfare, and Recreation Trust,” established by D.R.M.C.
Article XV, holds inmate funds in a City trust administered by the Denver Sheriff Department.
Keefe has provided a proprietary software program to DSD which records individual inmate
account balances, facilitates commissary sales, generates sales reports, and is the accounting
system for the Trust Fund. Friends and family can place funds on inmate accounts by credit
card, wire transfer, money order, and cash. Inmates can then use the available funds to purchase
food, drink, and personal hygiene items from the commissary. All commissary sales proceeds
are deposited into the Trust Fund. Under the terms of the contract, DSD is required to remit
commissary sales to Keefe on a weekly basis. Keefe is required to pay DSD a commission fee
equal to 44% of revenue, net of appropriate taxes, on a monthly basis.
Scope
The audit of the Keefe Commissary Network, LLC contract (PeopleSoft fund/org.
56951/3532000) was for the period October 1, 2006 through December 31, 2007. The audit
focused on evaluation of internal controls over processing inmate orders, accounting entries for
commissary transactions, and proper reporting of commissary sales and sales commissions. The
audit also examined the contractor’s compliance with insurance and reporting requirements.
Objective
The objective of our audit was to determine whether Keefe was in compliance with the terms of
the contract, commissary sales were properly reported, and sales commissions were accurately
calculated and paid. We also assessed DSD’s performance in monitoring the contract and their
compliance with City rules and regulations.
Methodology
The evidence gathering and analysis techniques used in order to meet the audit objectives
included, but were not limited to:
•

Evaluating internal controls over recording and reporting inmate commissary sales and
refunds;

•

Testing and documenting reliability of computer processed data;

6

BACKGROUND, SCOPE, OBJECTIVE, AND METHODOLOGY

KEEFE COMMISSARY NETWORK, LLC

•

Reconciling, on a test basis, commissary sales and refunds per system generated reports
to source documents;

•

Tracing, on a test basis, reported commissary sales to accounting records;

•

Reviewing sales commission calculations for accuracy;

•

Conducting discussions with management; and

•

Obtaining and reviewing evidence of insurance, performance bonds, the required
monthly and annual financial reports, and proof of compliance with Payment Card
Industry Data Security Standards (PCI DSS).

7

KEEFE COMMISSARY NETWORK, LLC
FINDINGS AND RECOMMENDATIONS
FOR THE PERIOD OCTOBER 1, 2006 THROUGH DECEMBER 31, 2007

Finding I - Non-Compliance with Contract Terms Caused Underpayment and Increased
Risk to the City
Audit work determined the Denver Sheriff Department (DSD) implemented verbal agreements
with Keefe Commissary Network, LLC (Keefe) with respect to payment terms and commissions
due in direct violation of Executive Order No. 8, Contracts and Other Written Instruments,
which states, “…an amendment is required whenever a provision of the contract needs to be
changed. Verbal instructions or written correspondence may not be considered as amendments
to a contract.” Additionally, we noted DSD failed to properly monitor and enforce contract
provisions regarding certain insurance, financial, and other reporting requirements. These issues
are described in further detail below:
Unauthorized Payment Process – As shown in Figure 1, the contract requires Keefe to submit
an invoice on a weekly basis for gross commissary sales. DSD is then required to pay the entire
amount of gross receipts to Keefe. Keefe is then responsible for calculating commissions due to
DSD and remitting commission payments on a monthly basis.

Figure 1 - Payment Process per Contract

However, DSD entered into a verbal agreement with Keefe which altered the payment process.
Based upon the current verbal agreement as illustrated in Figure 2, DSD receives weekly
invoices from Keefe, but DSD does not remit the gross sales to Keefe. Instead, DSD retains
commissions based on the invoice and pays Keefe the remaining balance.

Figure 2 - Payment Process per Verbal Agreement
8

FINDINGS AND RECOMMENDATIONS

KEEFE COMMISSARY NETWORK, LLC

Improper Calculation of Commissions - The contract defines commissions due as 44% of gross
receipts, net of applicable taxes. However, audit work revealed that shortly after entering the
contract, DSD and Keefe made an improper verbal agreement which altered the percentage of
commission due. Specifically, DSD requested Keefe reduce the prices charged to inmates for
certain clothing items and, in return, DSD agreed to receive sales commissions of 20% on these
items.
In addition, we noted the combined sales tax rate was incorrectly programmed in Keefe’s
software at the rate of 7.2% when it should have been applied at 7.6% from October through
December 31, 2006 and 7.72% beginning January 1, 2007. Furthermore, DSD failed to identify
the erroneous sales tax rate which could have been detected through recalculation and
reconciliation of commission amounts due. As a result, Keefe’s allowable sales tax deduction
from gross sales was understated for the entire audit period.
Ultimately, DSD collected $5,940 less than the commission amount prescribed by the contract.
In addition, since Keefe does not actually make payments to DSD on a monthly basis as
highlighted above, we were unable to determine and assess late payment interest penalties on
amounts due in accordance with the contract.
Non-Enforcement of Contract Provisions - Executive Order No. 8 outlines DSD’s
responsibility for monitoring and ensuring compliance with contract terms throughout the life of
the contract. However, audit work noted DSD failed to monitor and enforce Keefe’s compliance
with several contract provisions as highlighted below:
•

Based upon our examination of insurance policies, we noted Keefe did not obtain
insurance containing professional liability and employee dishonesty coverage as required
by the contract. Additionally, DSD did not review the insurance certificates maintained
by the contractor to ensure all required types of coverage were included in the policy.
Inadequate insurance coverage increases risk of third party liability for both Keefe and
DSD.

•

Audit work revealed Keefe failed to submit monthly sales summaries certified by an
officer of the company, as well as annual CPA certified statements detailing gross
receipts, deductions, net receipts, and the resulting sales commissions due as required by
the contract. Although DSD can independently generate monthly and annual sales
reports from the Keefe system, the financial reporting requirements are intended to
provide additional assurance that amounts due and paid are accurately recorded and
reported. Moreover, CPA certified annual statements could have detected the erroneous
tax rate and mitigated incorrect calculations of commissions due.

•

The contract requires Keefe to provide verification of compliance with Payment Card
Industry Data Security Standards (PCI DSS) since credit and debit cards are used to fund
inmate accounts. However, Keefe failed to submit evidence of quarterly data
vulnerability scans or annual audits certifying PCI DSS compliance and DSD did not
require these reports throughout the audit period. Despite multiple audit requests, Keefe
did not provide these reports. As a result, the City is left with no level of assurance that
Keefe has complied with PCI DSS.
9

FINDINGS AND RECOMMENDATIONS

KEEFE COMMISSARY NETWORK, LLC

Recommendations
1. We recommend DSD assess and collect $5,940 in sales commissions due from Keefe in
accordance with the contract. We recommend DSD fully comply with City contracting rules
that prohibit entering into verbal agreements with third parties. Since the contract expires
December 31, 2008, the parties will have the opportunity to renegotiate the contract terms,
incorporate any desirable changes, and pursue these changes through a proper contract
amendment as required by Executive Order No. 8.
2. We recommend DSD work with Keefe to immediately correct the tax rate programmed in the
system. Specifically, we recommend DSD monitor combined tax rate changes and ensure
tax tables are programmed correctly in Keefe’s system. Additionally, we recommend DSD
require Keefe to submit the financial reports outlined in the contract to mitigate the risk of
improper recording and reporting of sales and subsequent commissions due. DSD’s finance
personnel should perform monthly and yearly recalculations of commissions in accordance
with the contract, reconcile amounts due with Keefe’s financial reports, and resolve any
discrepancies with Keefe.
3. In order to protect both DSD and Keefe from potential claims by third parties, we
recommend Keefe obtain insurance policies which satisfy all the current coverage
requirements. Additionally, we recommend DSD review these new policies and, if
necessary, consult with Risk Management and the City Attorney’s Office to ensure adequacy
of the coverage and compliance with the terms of the contract.
4. We recommend Keefe submit evidence of quarterly data vulnerability scans or annual audits
verifying compliance with PCI DSS. Further, we recommend DSD require, obtain, and keep
on file the proof of compliance with this requirement on a regular basis.

10

KEEFE COMMISSARY NETWORK, LLC
SCHEDULE OF AMOUNTS DUE AND PAID
FOR THE PERIOD OCTOBER 1, 2006 THROUGH DECEMBER 31, 2007

Amount Due
(Note 1)

Amount Paid
(Note 2)

Balance Due
DSD/(Keefe)

$136,437
$136,437

$135,687
$135,687

$750
$750

Sales Commissions
Total:

$577,970
$577,970

$572,780
$572,780

$5,190
$5,190

Grand Total

$714,407

$708,467

$5,940

Periods
10/1/06 - 12/31/06
Sales Commissions
Total:
1/1/07 - 12/31/07

The accompanying notes are an integral part of this schedule.

11

NOTES TO SCHEDULE OF AMOUNTS DUE AND PAID

1.

KEEFE COMMISSARY NETWORK, LLC

Amounts Due (Note 1)

Sales commissions, as shown in the accompanying schedule, is 44% of net receipts which is
defined as all receipts from sales of products under the contract agreement, less applicable sales
tax. Counterfeit money or loss from theft shall not be deducted in the calculation of gross
receipts.
2.

Amounts Paid (Note 2)

All amounts paid in the schedule of amounts due and paid were compiled from the Denver
Sheriff Department’s cash disbursement records. Amounts paid include those due during the
audit period and paid in the ordinary course of business whether or not within the audit period.

12

EXHIBIT A – DENVER SHERIFF DEPARTMENT RESPONSE KEEFE COMMISSARY NETWORK, LLC

13

EXHIBIT A – DENVER SHERIFF DEPARTMENT RESPONSE KEEFE COMMISSARY NETWORK, LLC

14

EXHIBIT A – DENVER SHERIFF DEPARTMENT RESPONSE KEEFE COMMISSARY NETWORK, LLC

JAN- 13-2009

11 : 27

Agree with
Recommendation

P. 003

PANA 8060

Within 60 days

Mohammad Da hleh
720-865-4107

RECOMMENDAT ION 4: We recommend Keefe submit evidence of quarterly data vulnerability
scans or annual audits verifying compliance with PCI DSS. Further, we recommend DSD require,
obtoin, and keep on file the proof of compliance with this requirement on a regular basis.
> RESPONSE/ACTION PLAN: We wilJ work with Keefe to suhmit evidence of quarterly date
vulnerability scans or annual audits verifying compliance with PCI DSS.

State your agreem ent or
reason for disagreement
with Recommendation
Agree with
Recommendation

Target date to complete
implementation activities
(Generally expected
within 60 to 90 davs)
Will state in 2009 contract
Within 60 days

Name and phone number
of primary individual
responsible for
Implementation
Mohammad Dahleh
720-865-4107

Please contact Mar k Valentine at (720) 865-4108 with any questions.
Sincerely,

NI#
Mark Vale11Line
Director of Fitlance
cc: Director Bill Lovingier
Chief Ronald Foos

TOTAL P.003

15