Annual Spending Plan - Summary Report - File Layout and Data Mapping

The Annual Spending Plan - Summary report exports line-level summary data for the Annual Spending Plan, comparing estimated and actual amounts.

The following table shows the sequences, column names, descriptions, and data sources or valid values for the .xlsx format of the Annual Spending Plan - Summary report.

Sequence	Column Name	Description	Data Source or Valid Values
1	LINE	The predefined line number corresponding to a budget category in accordance with the Ohio Five-Year forecast.	Retrieved from the Line Number field on the OH Annual Spending Plan Information form of the OH Annual Spending Plan page.
2	DESCRIPTION	The line number’s description.	Retrieved from the Description field on the OH Annual Spending Plan Information form of the OH Annual Spending Plan page.
3	L_BUD_DIFF	The budget difference indicator.	Calculated during the report generation process. The system compares the sum of all monthly Plan amounts (Plan1-Plan13) against the sum of ledger budget amounts. Displays "" if the totals do not match, otherwise displays a space.
4	PERIOD ESTIMATE	The estimated amount for the selected period.	Calculated during the report generation process. The calculated value represents the sum of monthly Plan amounts from the OH Annual Spending Plan page for the selected period range (From Period to To Period).
5	PERIOD ACTUAL	The actual amount for the selected period.	Calculated during the report generation process. The calculated value represents the sum of actual expenditures and revenues from the Expenditure Ledger and Revenue Ledger for the selected period range (From Period to To Period).
6	PERIOD DIFFERENCE	The difference between the period estimate and the actual.	Calculated during the report generation process. The calculated value is PERIOD ACTUAL minus PERIOD ESTIMATE.
7	FISCAL YTD ESTIMATE	The fiscal Year-to-Date estimated amount.	Calculated during the report generation process. The calculated value represents the sum of monthly Plan amounts (Plan1 through the selected To Period) from the OH Annual Spending Plan page.
8	FISCAL YTD ACTUAL	The fiscal Year-to-Date actual amount.	Calculated during the report generation process. The calculated value represents the sum of actual expenditures and revenues from the Expenditure Ledger and Revenue Ledger from Period 1 through the selected To Period.
9	FISCAL YTD DIFFERENCE	The difference between the FYTD estimate and the actual.	Calculated during the report generation process. The calculated value is FISCAL YTD ACTUAL minus FISCAL YTD ESTIMATE.