Fund Activity Report - Summary - File Layout and Data Mapping

Use the OH Fund Activity - Summary Report to display a condensed view of fund activity, including beginning balances, revenue/receipts by account, and budget/expenditures by host budget code. This report provides a snapshot of cash flow activity for each fund for the fiscal year.

The default file name for the Fund Activity Summary Report is OH Fund Activity_Summary Report_<MMDDYYYY_hhmmss>.pdf.

The report is organized by Fund, with each fund containing:

Fund header with beginning balance.
Revenue/Receipts section with account-level detail.
Budget/Expenditures section grouped by Host Budget Code.
Fund footer with cash balance calculations.

The report contains the following sections:

Report Header

The following table shows the field names, descriptions, and data sources or valid values for the Report Header section of the Fund Activity Summary report.

Field Name	Description	Data Source or Valid Values
Application Name	The software vendor that supplied this package.	Retrieved from the Company field on the Fund Accounting Profile page.
Page Number	The report page number.	System-generated during report generation.
Date	The current date when the report is generated.	System-generated during report generation.
Employer Name	Your organization’s name.	Retrieved from the Client field on the Fund Accounting Profile page.
Time	The current time when the report is generated.	System-generated during report generation.
State Report Name	The report name.	The valid value is OH FUND ACTIVITY - SUMMARY REPORT.
Selection Criteria	The fund selection criteria, fiscal year, and period range entered by the user. Format: FUND: [value]; Year: [YYYY]; Period: [1/YYYY] - [PP/YYYY]	Retrieved from the Fund, Year, and Period fields on the OH Fund Activity Report page.

Fund Header

This section repeats for each fund.

The following table shows the field names, descriptions, and data sources or valid values for the Fund Header section of the Fund Activity Summary report.

Field Name	Description	Data Source or Valid Values
Fund/SPCC	Displays "FUND/SPCC:" followed by the three-digit fund code, a hyphen, and the four-digit SPCC (Special Purpose Cost Center) code.	Retrieved from the fund field in the GENLEDGR table.
Description	The key organization description.	Retrieved from the Title field on the Organization Chart page for the corresponding fund.
Beginning Balance as of July 1	The cash balance at the start of the fiscal year.	Retrieved from the trans_amt field in the TRANSACT table for the fund's beginning cash balance transaction.

Section 1: Revenue/Receipts Table (tblRevenueData)

The following table shows the column names, field names, descriptions, and data sources or valid values for the Revenue/Receipts Table section of the Fund Activity Summary report.

Column Name	Field Name	Description	Data Source or Valid Values
REVENUE/RECEIPTS	Fund/Account	The fund code and revenue account code combination, displayed in the format [Fund]-[Account]. This identifies the specific revenue account within each fund.	The Fund code is retrieved from the FUND/SCC field on the Organization Chart page. The Account code is retrieved from the Account field on the Revenue Budgets page.
DESCRIPTION	Description	The descriptive title for the revenue account.	Retrieved from the Title field on the Organization Chart page. If this field is blank, it is retrieved from the Title field on the Account List page.
BUDGET	Budget	The total budgeted revenue amount for the account. This represents the expected or estimated revenue for the fiscal year.	Calculated during report processing by summing the budget fields (bud1 through bud13) from the Revenue Ledger (revledgr) table for the selected accounting periods.
MTD	MTD	The Month-to-Date revenue amount. This is the actual revenue received for the current accounting period.	Retrieved from the period-specific revenue field (e.g., exp1 through exp13) in the Revenue Ledger (revledgr) table corresponding to the Period selected on the OH Fund Activity Report page.
YTD	YTD	The Year-to-Date revenue amount. This is the cumulative actual revenue received from the beginning of the fiscal year through the selected period.	Calculated during report processing by summing the period revenue fields (exp1 through the selected period) from the Revenue Ledger (revledgr) table.
ENC	ENC	The encumbered revenue amount (Year-to-Date). This is the total outstanding revenue encumbrances for the account. Revenue encumbrances represent anticipated revenue that has been committed but not yet received.	Retrieved from the encumbrance fields (enc1 through enc13) in the Revenue Ledger (revledgr) table.
BALANCE	Balance	The remaining available balance for the revenue account. This represents the difference between the budgeted revenue and the sum of actual receipts and encumbrances, indicating the amount of revenue still expected to be received.	Calculated during report processing as: Budget - YTD - ENC.

Revenue Section Footer

The Revenue Section Footer contains the Total Cash Receipts. This value is calculated during report processing by summing all YTD revenue amounts for the fund.

Section 2: Budget/Expenditures Table (tblExpenditureData)

The Budget/Expenditures Table section contains the following sub-sections:

Host Budget Code Subheader

The following table shows the field names, descriptions, and data sources or valid values for the Host Budget Code Subheader sub-section in the Budget/Expenditures Table section of the Fund Activity Summary report.

Field Name	Description	Data Source or Valid Values
Host Budget Code	The budget organization code that groups related expenditure accounts for budget tracking. This code represents a higher-level budget category that organizes multiple expenditure accounts. Expenditure accounts are linked to host budget codes to facilitate budget monitoring and the calculation of remaining balances at the budget code level.	Retrieved from the budget_orgn field in the Expenditure Ledger (expledgr) table.
Budget	The total budgeted expenditure amount for all accounts under the host budget code. This represents the total amount of the appropriated budget available for spending within this budget category.	Calculated by summing all budget period fields (bud1 through bud13) from the Expenditure Ledger (expledgr) table for all records matching the host budget code (budget_orgn) and fiscal year.

Field Name

Description

Data Source or Valid Values

Host Budget Code

The budget organization code that groups related expenditure accounts for budget tracking.

This code represents a higher-level budget category that organizes multiple expenditure accounts.

Expenditure accounts are linked to host budget codes to facilitate budget monitoring and the calculation of remaining balances at the budget code level.

Retrieved from the budget_orgn field in the Expenditure Ledger (expledgr) table.

Budget

The total budgeted expenditure amount for all accounts under the host budget code.

This represents the total amount of the appropriated budget available for spending within this budget category.

Calculated by summing all budget period fields (bud1 through bud13) from the Expenditure Ledger (expledgr) table for all records matching the host budget code (budget_orgn) and fiscal year.

Expenditure Detail Columns

The following table shows the field names, descriptions, and data sources or valid values for the Expenditure Detail sub-section in the Budget/Expenditures Table section of the Fund Activity Summary report.

Column Header	Field Name	Description	Data Source or Valid Values
BUDGET/EXPENDITURES	Fund/Account	The full organization key and expenditure account code combination, displayed in the format [Organization]-[Account]. This identifies the specific expenditure account within the organization structure.	The organization key is retrieved from the key_orgn field in the Expenditure Ledger (expledgr) table, which includes the fund and cost center components. The account code is retrieved from the Account field on the Expenditure Budgets page.
DESCRIPTION	Description	The descriptive title for the expenditure account.	Retrieved from the Title field on the Organization Chart page. If this field is blank, it is retrieved from the Title field on the Account List page.
BUDGET	Budget	The total budgeted expenditure amount for the account. This represents the appropriated budget available for spending in this account.	Calculated by summing the budget fields (bud1 through bud13) from the Expenditure Ledger (expledgr) table for the selected accounting periods.
MTD	MTD	The Month-to-Date expenditure amount. This is the actual expenditures posted for the current accounting period.	Retrieved from the period-specific expenditure field (e.g., exp1 through exp13) in the Expenditure Ledger (expledgr) table corresponding to the Period selected on the OH Fund Activity Report page.
YTD	YTD	The Year-to-Date expenditure amount. This is the cumulative actual expenditures from the beginning of the fiscal year through the selected period.	Calculated by summing the period expenditure fields (exp1 through the selected period) from the Expenditure Ledger (expledgr) table.
ENC	ENC	The encumbered amount (Year-to-Date). This is the total outstanding encumbrances for the account. Encumbrances represent committed funds for purchase orders and contracts that have not yet been paid.	Calculated by summing the encumbrance fields (enc1 through enc13) from the Expenditure Ledger (expledgr) table.
BALANCE	Balance	The remaining unencumbered balance for the expenditure account. This represents the budget remaining for new spending after accounting for actual expenditures and outstanding encumbrances.	Calculated as: Budget - YTD - ENC.

The Host Budget Code Footer contains the Remaining Balance for [HostBudgetCode]. This value is calculated during report processing by summing all Balance amounts for the host budget code.

Expenditure Section Footer

This section repeats for each fund.

The following table shows the field names, descriptions, and data sources or valid values for the Expenditure Section Footer section of the Fund Activity Summary report.

Field Name	Description	Data Source or Valid Values
Total Cash Expenditures	The total year-to-date cash expenditures for the fund. This represents all actual cash disbursements made from the fund during the fiscal year.	Retrieved from the sum of all expenditure amounts (fund_scc_ytd_exp) from the Expenditure Ledger (expledgr) table for the fund through the selected accounting period.
Total Cash Balance	The current cash balance for the fund after accounting for all receipts and expenditures. This represents the fund's actual cash position as of the selected period, excluding outstanding encumbrances.	Calculated as: Beginning Balance + Total Cash Receipts - Total Cash Expenditures.
Less: O/S Encumbrances	The total outstanding (O/S) encumbrances for the fund. This represents committed funds for purchase orders and contracts that have been approved but not yet paid. These amounts reduce the fund's available spending capacity.	Retrieved from the sum of all encumbrance amounts (fund_scc_ytd_enc) from the Expenditure Ledger (expledgr) table for the fund.
Unencumbered Balance	The remaining unencumbered cash balance available for new spending. This represents the true available balance in the fund after accounting for both actual expenditures and outstanding commitments. This is the amount available for new purchases or obligations.	Calculated as: Total Cash Balance - O/S Encumbrances.