£
<
33
\
r'
«L PRC**-
o
z.
LU
CD
-------
Report Contributors: Paul Curtis
Robert L. Smith
Javier Negron
Guillermo Mejia
Abbreviations
EPA U.S. Environmental Protection Agency
FY Fiscal year
GL General ledger
OCFO Office of the Chief Financial Officer
OIG Office of Inspector General
OMB Office of Management and Budget
RGLTS Report of General Ledger Balance by Treasury Symbol
SFFAS Statement of Federal Financial Accounting Standards
Hotline
To report fraud, waste, or abuse, contact us through one of the following methods:
e-mail: OIG Hotline@epa.gov write: EPA Inspector General Hotline
phone: 1-888-546-8740 1200 Pennsylvania Avenue NW
fax: 703-347-8330 Mailcode 8431P (Room N-4330)
online: http://www.epa.qov/oiq/hotline.htm Washington, DC 20460
-------
* ' U.S. Environmental Protection Agency 11-2-0300
£ JSJL \ Office of Inspector General June 29 2011
SEZ I
s v\|/v S
At a Glance
Why We Performed These
Agreed-Upon Procedures
We performed agreed-upon
procedures on the U.S.
Environmental Protection
Agency (EPA) Fiscal Year
(FY) 2011 Second Quarter
Financial Statements. We did
so to assist EPA in evaluating
whether its quarterly financial
statements were compiled
consistently with the Treasury
United States Standard General
Ledger Crosswalk, and to
identify significant fluctuations
in financial line item balances
from the previous year.
Background
Agencies submit unaudited
interim financial statements to
the Office of Management and
Budget 21 days after the end of
each of the first three quarters
of the fiscal year. Comparative
interim financial statements are
limited to a Balance Sheet,
Statement of Net Costs, and
Statement of Budgetary
Resources.
For further information,
contact our Office of
Congressional, Public Affairs
and Management at
(202) 566-2391.
The full report is at:
www.epa.aov/oia/reports/2011/
110629-11 -2-0300. pdf
Catalyst for Improving the Environment
Agreed-Upon Procedures on EPA's Fiscal Year 2011
Second Quarter Financial Statements
What We Found
We performed certain agreed-upon procedures on the Agency's FY 2011 Second
Quarter Financial Statements. We compared the statements with EPA's
crosswalk, recomputed them for mathematical accuracy, and compared them with
balances separately generated by us.
Below are the results of our performing the agreed-upon procedures:
The financial statements generated by the Office of Inspector General
agreed with EPA's FY 2011 Second Quarter Financial Statements for
the Consolidated Balance Sheet, Consolidated Statement of Net Cost,
Consolidated Statement of Net Cost by Goal, Consolidating Statement
of Changes in Net Position (including Earmarked Funds), Combined
Statement of Budgetary Resources, and Statement of Custodial Activity.
EPA's Treasury Symbols were in compliance with Statement of Federal
Financial Accounting Standards 27.
The on-top entry to record child agency balances agreed with the
support.
The Agency properly reversed the FY 2010 on-top adjustments in
FY 2011.
The elimination and consolidation entries appear reasonable and
complete.
No differences were found in the comparison of FY 2011 beginning
balances to FY 2010 ending balances.
The Agency identified 13 fluctuations in its analysis of significant
variances and submitted them to the Office of Management and Budget.
Our analysis identified 11 additional significant variances.
The agreed-upon procedures do not constitute an audit of the quarterly financial
statements or any part thereof, the objective of which would be the expression of
an opinion on the quarterly financial statements or any part thereof.
-------
UNITED STATES ENVIRONMENTAL PROTECTION AGENCY
WASHINGTON, D.C. 20460
THE INSPECTOR GENERAL
June 29, 2011
MEMORANDUM
SUBJECT: Agreed-Upon Procedures on EPA's Fiscal Year 2011
Second Quarter Financial Statements
Report No. 11-2-0300
FROM: Arthur A. Elkins Jr.
Inspector General
TO:
Barbara Bennett
Chief Financial Officer
The U.S. Environmental Protection Agency (EPA), Office of Inspector General, conducted these
agreed-upon procedures on EPA's Fiscal Year 2011 Second Quarter Financial Statements. This
report is provided solely to assist you in evaluating whether the Fiscal Year 2011 Second Quarter
Financial Statements were compiled in a manner consistent with the Treasury United States
Standard General Ledger Crosswalk, and to identify significant fluctuations in financial line
balances from the previous year.
Our report is intended solely for your information and use, and should not be used by those who
have not agreed to the procedures or taken responsibility for the sufficiency of the procedures for
their purposes. No written response to this report is required.
If you have any questions, please do not hesitate to contact Paul Curtis at (202) 566-2523 or
curtis.paul@epa.gov. or Bob Smith at (202) 566-2531 or smith.robertl@epa.gov.
-------
Agreed-Upon Procedures on EPA's Fiscal Year 2011
Second Quarter Financial Statements
11-2-0300
Table of C
Purpose 1
Background 1
Scope and Methodology 1
Results of Agreed-Upon Procedures 2
Status of Recommendations and Potential Monetary Benefits 6
Appendices
A OIG-ldentified Significant Fluctuations Between 03/31/11 and 03/31/10 7
B Distribution List 10
-------
Purpose
We performed these agreed-upon procedures at the request of the Office of the Chief Financial
Officer (OCFO). We did so to assist the U.S. Environmental Protection Agency (EPA) in
evaluating whether its Fiscal Year (FY) 2011 Second Quarter Financial Statements were
compiled consistently with the Treasury's United States Standard General Ledger Crosswalk,
and to identify significant fluctuations in financial line item balances from the previous year.
Background
According to Office of Management and Budget (OMB) Circular A-13 6, Financial Reporting
Requirements, interim unaudited financial statements, without notes, are required on a quarterly
basis. Agencies submit unaudited interim financial statements to OMB 21 days after the end of
each of the first three quarters of the fiscal year. Comparative interim financial statements are
limited to a Balance Sheet, Statement of Net Cost, and Statement of Budgetary Resources.
Agencies should include management's explanation of significant variances in types or amounts
of assets, liabilities, costs, revenues, obligations, and outlays, along with the submitted
statements. The analysis should be only on the significant variances between the current quarter
and the same quarter from the prior year. Management has discretion on what constitutes a
significant variance.
EPA prepares consolidated comparative interim financial statements for submission to OMB. In
addition to the three required interim statements, EPA prepares and submits a comparative
Consolidated Statement of Net Cost by Goal, Consolidating Statement of Changes in Net
Position, and Statement of Custodial Activity.
Scope and Methodology
We performed certain agreed-upon procedures, enumerated below, on EPA's unaudited
consolidated FY 2011 Second Quarter Financial Statements. The adequacy of these procedures is
the OCFO's responsibility. Consequently, we make no representation regarding the sufficiency
of the procedures. The agreed-upon procedures do not constitute an audit of the quarterly
financial statements or any part thereof, the objective of which would be the expression of an
opinion on the quarterly financial statements or any part thereof. Accordingly, we do not express
such an opinion. Were we to perform additional procedures, other matters might come to our
attention that we would report to assist the OCFO.
This agreed-upon procedures engagement was conducted using applicable generally accepted
government auditing standards, which incorporate attestation standards issued by the American
Institute of Certified Public Accountants. These standards provide guidance for performing and
reporting the results of agreed-upon procedures.
We performed the agreed-upon procedures from April 26 to June 22, 2011. We based our
procedures on EPA's FY 2011 Second Quarter Financial Statements and supporting schedules,
general ledger (GL) balances, and manual on-top adjustments.
11-2-0300
1
-------
Results of Agreed-Upon Procedures
Procedure 1:
Obtain EPA's second quarter financial statements, adjusted trial balance, on-top entries, and
support for the statements (including Earmarked Funds). Import the Report of General Ledger
Balance by Treasury Symbol (RGLTS); enter the Agency's on-top adjustments into ProSystem;
and generate an adjusted trial balance, Consolidated Balance Sheet, Consolidated Statement of
Net Cost, and Consolidating Statement of Changes in Net Position.
Results of Procedure 1
We obtained the Agency's second quarter financial statements, adjusted trial balance, on-
top entries, and support for the statements (including Earmarked Funds and Child Agency
Trial Balances). We imported the RGLTS and entered the Agency's on-top adjustments
to beginning balances into Prosystem to generate an adjusted trial balance, Consolidated
Balance Sheet, Consolidated Statement of Net Cost, and Consolidating Statement of
Changes in Net Position.
Procedure 1.a
Compare the ProSystem-generated adjusted trial balance to the Agency's adjusted trial balance
and note any differences.
Results of Procedure 1.a
We compared the Prosystem-generated adjusted trial balance based upon the Agency's
support to the Agency's adjusted trial balance. The Agency's adjusted trial balance for
the FY 2011 second quarter agreed with our Prosy stem-adjusted trial balance amounts,
except for immaterial rounding differences. We verified that the statements complied
with and are in accordance with EPA's crosswalk.
Procedure 1.b
Compare the ProSystem-generated financial statements to EPA's financial statements and note
any differences.
Results of Procedure 1.b
We compared the Prosystem-generated financial statements to EPA's financial
statements (Consolidated Balance Sheet, Consolidated Statement of Net Cost, and
Consolidating Statement of Changes in Net Position). We did not note any differences.
11-2-0300
2
-------
Procedure 1.c
Enter the FY 2011 and 2010 GL balances and on-top adjustments into Excel spreadsheets.
Prepare the Combined Statement of Budgetary Resources and Statement of Custodial Activity,
compare to the Agency's statements, and note any differences.
Results of Procedure 1.c
We entered the FY 2011 GL balances and on-top adjustments into an Excel spreadsheet.
We prepared and compared the Office of Inspector General (OIG) Combined Statement
of Budgetary Resources and Statement of Custodial Activity to the Agency's statements.
Combined Statement of Budgetary Resources:
The Agency's balances for the FY 2011 second quarter agreed with our amounts for this
statement except for immaterial rounding differences.
Statement of Custodial Activity:
The Agency's balances for the FY 2011 second quarter agreed with our amounts for this
statement except for immaterial rounding differences.
Procedure 1.d
Extract GL ending balances for Earmarked Funds from the RGLTS using Interactive Data
Extraction Analysis and enter into ProSystem. Enter on-top adjustments, generate a Consolidated
Statement of Changes in Net Position for Earmarked Funds, and compare to EPA's Consolidated
Statement of Changes in Net Position for Earmarked Funds.
Results of Procedure 1.d
We extracted the GL ending balances from the RGLTS for Earmarked Funds, generated a
Consolidated Statement of Changes in Net Position for Earmarked Funds, and compared
it to EPA's Consolidated Statement of Changes in Net Position for Earmarked Funds. We
did not note any differences.
Procedure 1.e
Compare the Agency's second quarter Consolidated Statement of Net Cost by Goal to the
consolidated totals from the Consolidated Statement of Net Cost and note any differences.
11-2-0300
3
-------
Results of Procedure 1.e
We compared the Agency's second quarter Consolidated Statement of Net Cost by Goal
to the consolidated totals (total costs, total earned revenue, and net cost of operations)
from the Consolidated Statement of Net Cost. The amounts agreed.
Procedure 1.1
Mathematically verify accuracy of the Consolidated All Other column on the Consolidating
Statement of Changes in Net Position in the Agency's financial statements.
Results of Procedure 1.1
We mathematically verified the accuracy of the Consolidated All Other column in the
Agency's financial statements on the Consolidating Statement of Changes in Net Position
in the Agency's financial statements.
Procedure 1.g
Identify significant fluctuations in balances by comparing current year balances to prior year
balances. (Criteria: Percentage change of 10 percent or more and dollar change exceeding
$50 million).
Results of Procedure 1.g
The Agency identified 13 significant fluctuations in the Consolidated Balance Sheet,
Consolidated Statement of Net Cost, and Combined Statement of Budgetary Resources.
Our analysis identified seven additional significant fluctuations in these statements. We
also identified four significant fluctuations in the Consolidating Statement of Changes in
Net Position (a nonrequired statement). OIG- and Agency-identified fluctuations are
detailed in appendix A.
Procedure 2
Obtain and compare EPA's identified Earmarked Treasury Symbols to Federal Accounting
Standards Advisory Board Statement of Federal Financial Accounting Standards (SFFAS) 27,
Identifying and Reporting Earmarked Funds, for compliance.
Results of Procedure 2
We obtained and compared EPA's identified Earmarked Treasury Symbols to SFFAS 27.
We found that EPA's Treasury Symbols are in compliance with SFFAS 27. Earmarked
Treasury Symbols consist of the following trust funds: Hazardous Substance Superfund;
Federal Insecticide, Fungicide, and Rodenticide Act Fund; Revolving Fund for
11-2-0300
4
-------
Certification and Other Services; Licenses and Other Services; Environmental Services;
Exxon Valdez Settlement Fund; Pesticide Registration Improvement Act Fund; Oil Spill
Response Fund; Contributed Funds; and Leaking Underground Storage Tank Trust Fund.
Procedure 3
Obtain and compare FY 2011 and 2010 Child Trial Balances to the child on-top entry.
Results of Procedure 3
We obtained and compared EPA's FY 2011 and 2010 Child Trial Balances to the child
on-top entry. We found that the on-top entry to record child agency balances agreed with
the support.
Procedure 4
Compare the FY 2011 reversals to the FY 2010 on-top adjustments and EPA's Closing
Instructions to assess whether EPA followed the guidance in the instructions.
Results of Procedure 4
We compared the FY 2011 reversals to the FY 2010 on-top adjustments and to EPA's
Closing Instructions to assess whether EPA followed the guidance in the instructions. We
found that the Agency properly reversed the FY 2010 on-tops in FY 2011.
Procedure 5
Compare the RGLTS FY 2011 beginning balances to the FY 2010 ending balances and note any
differences.
Results of Procedure 5
We compared the RGLTS FY 2011 beginning balances to FY 2010 ending balances and
found no differences.
Procedure 6
Review elimination and consolidation entries prepared by the Reporting and Analysis Staff for
reasonableness and completeness.
Results of Procedure 6
We reviewed elimination and consolidation entries prepared by the Reporting and
Analysis Staff for reasonableness and completeness. The elimination and consolidation
entries appeared reasonable and complete.
11-2-0300
5
-------
Status of Recommendations and
Potential Monetary Benefits
RECOMMENDATIONS
POTENTIAL MONETARY
BENEFITS (In $000s)
Rec.
No.
Page
No.
Subject
Status
Planned
Completion
Action Official Date
No recommendations
Claimed
Amount
Ag reed-To
Amount
11-2-0300
6
-------
Appendix A
OIG-ldentified Significant Fluctuations
Between 03/31/11 and 03/31/10
(Dollars in Thousands)
Notes for each table are as follows:
1 EPA-identified significant fluctuation also identified by OIG in the second quarter analysis reported to OMB.
2 OIG-identified significant fluctuation not identified by EPA in the second quarter analysis reported to OMB.
Consolidated Balance Sheet
ASSETS
FY 2011
FY 2010
Difference
%
Fund Balance With Treasury1
$14,098,280
$20,213,981
($6,115,701)
-30.25%
Accounts Receivable, Net1
$445,131
$333,263
$111,868
33.57%
LIABILITIES
Accounts Payable & Accrued Liabilities1
$1,122,633
$881,373
$241,260
27.37%
Cashout Advances, Superfund2
$701,587
$555,558
$146,029
26.29%
NET POSITION
Unexpended Appropriations - Other Funds1
$12,771,237
$19,072,072
($6,300,835)
-33.04%
Source: FY 2011 Financial Statements provided by EPA.
Consolidated Statement of Net Cost
COSTS
FY 2011
FY 2010
Difference
%
Gross Costs1
$6,381,673
$5,451,429
$930,244
17.06%
Source: FY 2011 Financial Statements provided by EPA.
11-2-0300
7
-------
Consolidated Statement of Changes in Net Position
FY 2011
Consolidated
Total
FY 2010
Consolidated
Total
Difference
%
CUMULATIVE RESULTS OF OPERATIONS:
BUDGETARY FINANCING SOURCES:
Appropriations Received2
$5,295,092
$10,180,413
($4,885,321)
-47.99%
Source: FY 2011 Financial Statements provided by EPA.
Consolidated Statement of Changes in Net Position - All Other Funds
FY 2011
Consolidated
All Other
Funds
FY 2010
Consolidated
All Other
Funds
Difference
%
CUMULATIVE RESULTS OF OPERATIONS:
Budgetary Financing Sources:
Trust Fund Appropriations2
($680,055)
($1,280,570)
$600,515
-46.89%
BUDGETARY FINANCING SOURCES:
Appropriations Received2
$5,295,092
$10,180,413
($4,885,321)
-47.99%
Source: FY 2011 Financial Statements provided by EPA.
Consolidated Statement of Changes in Net Position—Earmarked Funds
FY 2011
Consolidated
Earmarked
Funds
FY 2010
Consolidated
Earmarked
Funds
Difference
%
CUMULATIVE RESULTS OF OPERATIONS:
Budgetary Financing Sources:
Trust Fund Appropriations2
$680,055
$1,280,570
($600,515)
-46.89%
Source: FY 2011 Financial Statements provided by EPA.
11-2-0300
8
-------
Combined Statement of Budgetary Resources
BUDGETARY RESOURCES:
FY 2011
FY 2010
Difference
%
Appropriation1
$5,343,817
$10,255,076
($4,911,259)
-47.89%
Collected1
$297,191
$603,148
($305,957)
-50.73%
Advance Received1
$52,046
$299,800
($247,754)
-82.64%
Anticipated for Rest of Year, Without Advances1
$349,822
$395,022
($45,200)
-11.44%
Nonexpenditure Transfers, Net, Anticipated and Actual2
$729,177
$1,375,789
($646,612)
-47.00%
STATUS OF BUDGETARY RESOURCES:
Obligations Incurred:
Direct1
$3,820,185
$4,384,081
($563,896)
-12.86%
Apportioned1
$7,227,340
$10,595,870
($3,368,530)
-31.79%
Unobligated Balances Not Available2
$178,549
$1,538,552
$(1,360,003)
-88.39%
CHANGE IN OBLIGATED BALANCE:
Unpaid Obligations, Brought Forward, October 12
$13,872,909
$15,788,389
($1,915,480)
-12.13%
Less: Uncollected Customer Payments from Federal
Sources, Brought Forward, October 12
($439,956)
($573,824)
$133,868
-23.33%
Obligations Incurred, Net2
$4,095,398
$4,627,961
($532,563)
-11.51%
Unpaid Obligations2
$10,900,017
$13,413,108
($2,513,091)
-18.74%
NET OUTLAYS:
Net Outlays:
Less: Offsetting Collections1
($363,242)
($921,420)
$558,178
-60.58%
Less: Distributed Offsetting Receipts1
($703,823)
($1,290,155)
$586,332
-45.45%
Source: FY 2011 Financial Statements provided by EPA.
11-2-0300
9
-------
Appendix B
Distribution
Chief Financial Officer
Deputy Chief Financial Officer
Director, Office of Financial Management, Office of the Chief Financial Officer
Director, Reporting and Analysis Staff, Office of the Chief Financial Officer
Director, Office of Financial Services, Office of the Chief Financial Officer
11-2-0300
10
------- |