14.3 Budget Execution, Variance Analysis & Financial Auditing

Budget Execution, Variance Analysis & Financial Auditing

The formal adoption of an annual appropriation ordinance by a city council or park district board marks the transition from budget planning to budget execution. For a Certified Park and Recreation Professional (CPRP), budget execution is an active, daily management responsibility. Operating divisions must deliver promised recreational services and maintain high infrastructure standards while strictly adhering to statutory expenditure ceilings and internal control safeguards.

Effective financial administration demands mastery of encumbrance accounting, ongoing budget variance analysis, legally compliant mid-year budget adjustments, and robust internal and external auditing controls. This section details the operational tools and regulatory frameworks necessary to maintain financial integrity and public trust throughout the fiscal year.

---

+-----------------------------------------------------------------------------------+
|                     BUDGET EXECUTION & FISCAL CONTROL SYSTEM                      |
+-----------------------------------------------------------------------------------+
|  1. ENCUMBRANCE CONTROLS     |  2. VARIANCE ANALYSIS       |  3. AUDIT & COMPLIANCE|
|  * Purchase Requisitions     |  * Favorable vs Unfavorable |  * Internal POS Spot  |
|  * Purchase Orders (POs)     |  * Revenue / Expense Gaps   |    Cash Audits        |
|  * Available Balance Formula |  * Root-Cause Investigation |  * External CPA Audit |
|  * Year-End Encumbrance Roll |  * Corrective Action Plans  |  * ACFR / GASB Stds   |
+-----------------------------------------------------------------------------------+

---

1. Budget Execution Controls & Encumbrance Accounting

In governmental accounting, an appropriation is a legal authorization granted by the legislative body to make expenditures and incur obligations for specific purposes up to a specified dollar limit. To prevent departments from overspending their legal appropriations, local governments utilize encumbrance accounting.

+-----------------------------------------------------------------------------------+
|                       THE ENCUMBRANCE ACCOUNTING LIFECYCLE                        |
+-----------------------------------------------------------------------------------+
| [ 1. PURCHASE REQUISITION ]                                                        |
| Recreation supervisor identifies need (e.g., $15,000 playground mulch order)       |
|                                     │                                             |
|                                     ▼                                             |
| [ 2. ENCUMBRANCE ESTABLISHED (PURCHASE ORDER ISSUED) ]                             |
| Finance issues formal PO to vendor; $15,000 is legally ENCUMBERED (set aside)      |
| Available budget balance drops immediately by $15,000                              |
|                                     │                                             |
|                                     ▼                                             |
| [ 3. GOODS DELIVERED & INVOICE RECEIVED ]                                         |
| Mulch delivered to park; vendor submits official invoice for $15,000               |
|                                     │                                             |
|                                     ▼                                             |
| [ 4. LIQUIDATION OF ENCUMBRANCE & ACTUAL EXPENDITURE ]                             |
| $15,000 encumbrance is LIQUIDATED; $15,000 recorded as ACTUAL EXPENDITURE          |
| Accounts payable issues check/ACH payment to vendor                                |
+-----------------------------------------------------------------------------------+

A. The Available Budget Balance Formula

A critical exam concept for the CPRP is understanding that the money remaining in a budget is not simply total budget minus paid checks. Outstanding purchase commitments must be accounted for to prevent double-spending:

$\text{Available Balance} = \text{Appropriated Budget} - \left( \text{Actual Year-to-Date Expenditures} + \text{Outstanding Encumbrances} \right)$

Component Definitions:

• Appropriated Budget: The legal expenditure limit enacted by the governing board for that specific line-item or program account (e.g., $100,000 for Park Maintenance Supplies).
• Actual Expenditures: Cash disbursements already paid or formal accounts payable vouchers processed for goods and services received (e.g., $45,000).
• Outstanding Encumbrances: Total purchase orders (POs), executed contracts, or formal obligations issued to vendors for goods/services that have been ordered but not yet invoiced or paid (e.g., $25,000).
• Available (Unencumbered) Balance: The remaining legal spending authority available for new purchasing commitments: $\text{Available Balance} = \$100,000 - (\$45,000 + \$25,000) = \$100,000 - \$70,000 = \mathbf{\$30,000}$

If a supervisor attempts to submit a new purchase requisition for $35,000 against this account, the automated financial management system will place an immediate "budget exception hold," as the requisition exceeds the available unencumbered balance of $30,000, even though actual cash paid to date is only $45,000.

B. Year-End Treatment of Encumbrances

At the conclusion of the fiscal year (e.g., June 30 or December 31), agencies must reconcile outstanding encumbrances:

• Lapsing Appropriations: Operating funds that remain unspent and unencumbered officially lapse (expire) and revert to the municipality's unassigned fund balance.
• Encumbrance Rollover / Carryforward: Valid, contractual purchase orders issued before year-end for capital equipment or contracted services that were delayed in delivery are formally rolled forward into the new fiscal year, preserving the previous year's appropriation authority.

---

2. Monthly Budget Variance Analysis & Root Cause Reporting

Park and recreation managers receive monthly general ledger financial statements comparing actual financial performance against linear, time-phased budget benchmarks. Variance analysis is the systematic review of differences between budgeted projections and actual performance.

$\text{Dollar Variance} = \text{Actual Amount} - \text{Budgeted Amount}$ $\text{Percentage Variance} = \left( \frac{\text{Actual Amount} - \text{Budgeted Amount}}{\text{Budgeted Amount}} \right) \times 100$

+-----------------------------------------------------------------------------------+
|                     FAVORABLE VS. UNFAVORABLE VARIANCE RULES                      |
+-----------------------------------------------------------------------------------+
| FINANCIAL STREAM       | FAVORABLE (F) VARIANCE        | UNFAVORABLE (U) VARIANCE  |
|------------------------+-------------------------------+---------------------------|
| REVENUE STREAMS        | Actual Revenue > Budget       | Actual Revenue < Budget   |
| (User fees, rentals)   | (More cash collected)         | (Revenue shortfall / gap) |
|------------------------+-------------------------------+---------------------------|
| EXPENDITURE STREAMS    | Actual Expense < Budget       | Actual Expense > Budget   |
| (Wages, utilities)     | (Cost savings / unspent funds)| (Cost overrun / overspend)|
+-----------------------------------------------------------------------------------+

A. Investigating Variance Root Causes

Variances exceeding standard agency tolerance thresholds (typically $\pm 5%$ to $10%$) require immediate written narrative explanations and management intervention:

1. Weather & Environmental Anomalies:
   • Scenario: Municipal aquatic center admissions display a 30% unfavorable revenue variance in June.
   • Root Cause: Unprecedented precipitation (18 days of rain) forced outdoor pool closures.
   • Corrective Action: Adjust July/August seasonal lifeguard labor schedules to reduce operating expenditures and launch promotional late-season evening swim events.
2. Program Enrollment Fluctuations:
   • Scenario: Adult co-ed softball league experiences a 25% favorable revenue variance.
   • Root Cause: Surging interest in adult recreational sports led to 16 additional teams registering.
   • Operational Alignment: Anticipate a corresponding unfavorable variance in contractual umpire fees and field lighting utility expenses.
3. Inflation & Macroeconomic Price Surges:
   • Scenario: Park Maintenance fuel line item exhibits a 20% unfavorable expenditure variance at mid-year.
   • Root Cause: Regional wholesale diesel fuel prices increased by $1.20 per gallon.
   • Corrective Action: Implement route-optimization software for maintenance mowers, reduce mowing frequencies in passive conservation zones, and request an intra-departmental budget transfer from unspent seasonal salary savings.

---

3. Mid-Year Budget Adjustments: Administrative vs. Legislative Authority

When operational realities diverge from adopted budget plans, managers must execute formal budget adjustments. Municipal financial regulations strictly differentiate between administrative transfers and legislative appropriations.

+-----------------------------------------------------------------------------------+
|                 SPECTRUM OF MID-YEAR BUDGET ADJUSTMENT AUTHORITY                  |
+-----------------------------------------------------------------------------------+
| ADJUSTMENT TYPE       | OPERATIONAL DEFINITION            | REQUIRED APPROVAL     |
|-----------------------+-----------------------------------+-----------------------|
| Intra-Departmental    | Transferring funds between object | Park Director /       |
| Line-Item Transfer    | codes within the same division    | City Manager (Admin)  |
|-----------------------+-----------------------------------+-----------------------|
| Inter-Departmental    | Moving funds between different    | City Manager / Mayor  |
| Administrative Shift  | departments (e.g. Parks to Police)| or City Council Action|
|-----------------------+-----------------------------------+-----------------------|
| Supplemental          | Increasing the TOTAL legal        | City Council / Board  |
| Appropriation         | expenditure ceiling of the agency | (Public Ordinance)    |
|-----------------------+-----------------------------------+-----------------------|
| Budget Rescission /   | Formally reducing spending        | City Council / Board  |
| De-appropriation      | authority due to revenue deficits | (Public Resolution)   |
+-----------------------------------------------------------------------------------+

A. Intra-Departmental Line-Item Transfers

• Mechanism: Reallocating unspent budget from one object-of-expenditure line item to another within the same operating division or department (e.g., transferring $5,000 from unspent Office Supplies [Object 210] to Turf Repair Chemicals [Object 240]).
• Authority: Handled entirely administratively by the Park and Recreation Director, often requiring signature concurrence from the municipal Finance Director or City Manager. It does not alter the total bottom-line appropriation approved by the city council.

B. Supplemental Appropriations

• Mechanism: Formally increasing the total authorized spending ceiling of a fund during the active fiscal year (e.g., adding $250,000 to the Parks General Fund operating budget to repair emergency flood damage to community center gymnasiums).
• Authority: Because it legally expands total governmental spending authority, a supplemental appropriation must be formally approved by the legislative governing body (City Council or Park Board) through a public ordinance or resolution with identified funding sources (e.g., unassigned emergency reserves or unanticipated grant revenue).

---

4. Internal Controls, Cash Handling & Fraud Prevention

Recreation agencies operate numerous decentralized cash-collection and point-of-sale (POS) touchpoints—including pool admission gates, golf pro shops, marina fuel docks, summer camp registration desks, and concession stands. Robust internal controls safeguard public assets against loss, theft, and fraud.

+-----------------------------------------------------------------------------------+
|                    THE FOUR PILLARS OF INTERNAL CASH CONTROLS                     |
+-----------------------------------------------------------------------------------+
| 1. SEGREGATION OF DUTIES    | Separation of Custody, Authorization, Recording, &  |
|                             | Reconciliation (no single employee handles all steps)|
| 2. POINT-OF-SALE INTEGRITY  | Mandatory pre-numbered electronic receipts; barcode |
|                             | scanners; secure cash drawers with personal logins  |
| 3. DUAL-CUSTODY PROCEDURES  | Two employees present for safe drops, register cash |
|                             | counts, and armored carrier handoffs                |
| 4. INDEPENDENT SPOT AUDITS  | Unannounced surprise cash drawer counts and inventory|
|                             | reconciliations by internal audit personnel         |
+-----------------------------------------------------------------------------------+

Core Internal Control Rules in Recreation Facilities:

1. Segregation of Duties: The employee who collects cash at the registration desk (Custody) must not be the same employee who enters accounting general ledger adjustments (Recording) or reconciles the monthly bank statements (Reconciliation).
2. Daily Cash Reconciliation & Drawer Balancing: At the end of every operating shift, cash registers must be balanced by the cashier and a lead supervisor using printed POS "Z-Reports." Overages and shortages must be documented with written supervisor sign-off.
3. Dual-Custody Safe Drops: Bank deposit bags must be verified, signed, and dropped into dual-lock depository drop-safes by two staff members simultaneously.
4. Petty Cash Governance: Petty cash funds must operate on an imprest system, capped at nominal thresholds ($100–$250), restricted to minor emergency purchases with mandatory original receipts, and subjected to regular unannounced spot audits.

---

5. Financial Auditing & The Annual Comprehensive Financial Report (ACFR)

Public accountability culminates in the annual financial audit process, verifying that the agency's financial statements represent a true and fair view of its financial position in compliance with Generally Accepted Accounting Principles (GAAP) as established by the Governmental Accounting Standards Board (GASB).

+-----------------------------------------------------------------------------------+
|               STRUCTURE OF THE ANNUAL COMPREHENSIVE FINANCIAL REPORT (ACFR)       |
+-----------------------------------------------------------------------------------+
| 1. INTRODUCTORY SECTION     | * Letter of Transmittal                             |
| (Unaudited Overview)        | * Organizational Chart & List of Principal Officials|
|                             | * GFOA Certificate of Achievement (if awarded)      |
|-----------------------------+-----------------------------------------------------|
| 2. FINANCIAL SECTION        | * Independent Auditor's Report (Audit Opinion)      |
| (Core Audited Material)     | * Management's Discussion & Analysis (MD&A)         |
|                             | * Basic Financial Statements (Gov-Wide & Fund Level)|
|                             | * Notes to Financial Statements                     |
|                             | * Required Supplementary Information (RSI)          |
|-----------------------------+-----------------------------------------------------|
| 3. STATISTICAL SECTION      | * 10-Year Financial Trend Data                      |
| (Multi-Year Context)        | * Revenue Capacity & Assessed Valuation Tables      |
|                             | * Demographic, Economic & Operational Statistics    |
+-----------------------------------------------------------------------------------+

A. Independent Auditor's Opinions

Upon concluding their comprehensive examination of municipal financial records, the independent CPA firm issues an official Auditor's Opinion:

• Unmodified (Clean) Opinion: The highest and most desirable outcome. Certifies that the financial statements are presented fairly, in all material respects, in accordance with GAAP.
• Modified (Qualified) Opinion: Issued when there is a specific material misstatement or limitation in audit scope, but not pervasive enough to invalidate the financial statements as a whole.
• Adverse Opinion: Issued when the financial statements are materially misstated and do not fairly present the agency's financial position under GAAP.
• Disclaimer of Opinion: Issued when the auditor was unable to obtain sufficient audit evidence to form an opinion due to severe missing records or restricted access.

B. Comprehensive Financial Controls & Auditing Matrix

The following matrix summarizes the vital controls, adjustment mechanisms, and reporting standards tested on the CPRP examination: