Certification of Balances - File Layout and Data Mapping

The default file names for the Certification of Balances report are:

PDF: OH Certification of Balances Report_<MMDDYYYY_hhmmss>.pdf
Excel: OH Certification of Balances Report_<MMDDYYYY_hhmmss>.csv

The following table shows the columns, column names, descriptions, and data sources or valid values for the .csv format of the Certification of Balances report.

Column	Column Name	Description	Data Source or Valid Values
A	FUND CLASS	The fund type description.	Valid values: Governmental Proprietary Fiduciary Retrieved from the Fund Classification field on the Certification of Balances Record form of the OH Certification of Balances page.
B	FUND TYPE	The fund classification description.	Valid values: General Fund Special Revenue Debt Service Capital Projects Permanent Enterprise Internal Service Private Purpose Trust Agency Invalid Fund Type Retrieved from the Fund Type field on the Certification of Balances Record form of the OH Certification of Balances page.
C	FUND	The three-character fund code.	Retrieved from the Fund/SCC field on the Certification of Balances Record form of the OH Certification of Balances page. The first 3 characters represent the Fund code.
D	SCC	The four-character Sub-Cost Center code (blank if rolled up to fund level).	Retrieved from the Fund/SCC field on the Certification of Balances Record form of the OH Certification of Balances page. The last four characters (positions 4-7) represent the Special Cost Center.
E	TITLE	The 25-character fund title/description.	Retrieved from the Title field on the Certification of Balances Record form of the OH Certification of Balances page.
F	CASH BALANCE	The calculated cash balance.	Calculated during the report generation process. The calculated value is Beginning Balance - Principal + Total Revenue - Total Expenditure. The beginning balance is retrieved from the Transaction file (TRANSACT). The revenue is retrieved from the Revenue Ledger. The expenditure is retrieved from the Expenditure Ledger.
G	ENCUMBRANCES	The total encumbrances amount.	Calculated during the report generation process. The calculated value is the sum of encumbrances from the Expenditure Ledger and open purchase orders from the Purchase Order Approval (POAPRV) table.
H	ADVANCES NOT REPAID	The amount of interfund advances outstanding.	Retrieved from the Advance Not Repaid field on the Certification of Balances Record form of the OH Certification of Balances page.
I	CARRY OVER BALANCE	The calculated carryover balance.	Calculated during the report generation process. The calculated value is CASH BALANCE - ENCUMBRANCES + ADVANCES NOT REPAID.
J	BUDGETED EXPENDITURES	The budgeted expenditures amount.	Retrieved from the Budgeted Expenditures field on the Certification of Balances Record form of the OH Certification of Balances page.
K	AVAILABLE BALANCE	The final available balance.	Calculated during the report generation process. The calculated value is CARRY OVER BALANCE + BUDGETED EXPENDITURES.