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

The Annual Spending Plan - Detail report exports account-level data for the Annual Spending Plan.

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

Sequence	Column Name	Description	Data Source or Valid Values
1	LINE NUMBER	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	FULL ACCOUNT NUMBER	The Full Account Number. This field is displayed when Full Account Structure is enabled.	Calculated during the report generation process. The system automatically combines the Key Organization and Account Code from the Expenditure Ledger or Revenue Ledger into the district's full account format.
3	KEY ORG	The key organization code. This field is displayed when Full Account Structure is not enabled.	Retrieved from the Key Orgn field on the Expenditure Ledger or Revenue Ledger.
4	ACCOUNT CODE	The Account code. This field is displayed when Full Account Structure is not enabled.	Retrieved from the Account field on the Expenditure Ledger or Revenue Ledger.
5	FYTD ESTIMATED	The fiscal Year-to-Date estimated amount.	Calculated during the report generation process. The calculated value is the sum of the monthly Plan amounts (July through the selected To Period) on the OH Annual Spending Plan page for the matching line number.
6	PERIOD ACTUAL	The period’s actual amount.	Calculated during the report generation process. The calculated value represents the sum of actual expenditures or revenues from the Expenditure Ledger or Revenue Ledger for the selected period range (From Period to To Period).
7	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 or revenues from the Expenditure Ledger or Revenue Ledger from Period 1 through the selected To Period.
8	FYTD PCT	The fiscal Year-to-Date percentage.	Calculated during the report generation process. The calculated value is (FISCAL YTD ACTUAL ÷ FYTD ESTIMATED) × 100. Displays 0 if FYTD ESTIMATED is zero.

FULL ACCOUNT NUMBER

The file layout depends on the district's account structure configuration:

If Full Account Structure is enabled, the FULL ACCOUNT NUMBER column is displayed.
If Full Account Structure is not enabled, the KEY ORG and ACCOUNT CODE columns are displayed.

Row Types

The .xlsx output includes two types of data rows:

Row Type	Description
Detail Row	Individual ledger entry with all eight columns populated.
Total Row	The line total summary. Column 1 contains "TOTAL LINE: X.XXX" where X.XXX is the line number. Columns 5-8 contain the totals for that line.

Row Type

Description

Detail Row

Individual ledger entry with all eight columns populated.

Total Row

The line total summary.

Column 1 contains "TOTAL LINE: X.XXX" where X.XXX is the line number.

Columns 5-8 contain the totals for that line.