Fund Activity Report - Excel File Layout and Data Mapping

The default file name for the Fund Activity Detail Report’s Excel file layout is OH Fund Activity Report_<Start Year_Start Period_End Year_End Period>.xlsx.

The Excel workbook contains five tabs:

FUND SUMMARY

The following table shows the columns, column names, descriptions, and data sources or valid values for the Fund Summary tab of the Fund Activity Detail Report’s Excel file layout.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year for the reporting period.	Populated during the file creation process. Retrieved from the Start Year and End Year fields on the OH Fund Activity Report page.
B	PERIOD	The fiscal period within the year for which activity is reported.	Populated during the file creation process. Retrieved from the Start Period and End Period fields on the OH Fund Activity Report page.
C	FUND / SPCC	The fund and special cost center code combination.	Calculated during the file creation process. The calculated value represents the fund and special cost center combination, formatted as the first three characters of the fund code followed by a hyphen and the remaining characters, derived from the Fund field on the Organization Record page.
D	FUND / SPCC DESCRIPTION	The title of the organization associated with the fund.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
E	CASH AS OF JULY 1	The opening cash balance for the fund at the start of the fiscal year (July 1), based on the beginning balance and year-end close transactions posted to the specified cash accounts.	Calculated during the file creation process. The calculated value represents the fund's opening cash balance as of July 1 (the beginning of the fiscal year), derived from the beginning balance and year-end close transactions recorded in the cash accounts specified in the Cash Account 1 through Cash Account 5 fields on the OH Fund Activity Report page.
F	PERIOD STARTING BALANCE	The cash balance at the start of the reporting period, calculated as the Cash as of July 1 plus cumulative receipts minus cumulative expenditures through the end of the prior period.	Calculated during the file creation process. The calculated value represents the cash balance at the start of the reporting period, equal to Cash as of July 1 plus cumulative cash receipts minus cumulative cash expenditures posted through the end of the prior period.
G	TOTAL CASH RECEIPTS	The total revenue posted to the fund across all revenue accounts during the reporting period.	Calculated during the file creation process. The calculated value represents the sum of all revenue amounts posted to the fund across all revenue accounts during the reporting period, accumulated from the revenue ledger.
H	TOTAL CASH EXPENDITURES	The total expenditures posted to the fund across all expenditure accounts during the reporting period.	Calculated during the file creation process. The calculated value represents the sum of all expenditure amounts posted to the fund across all expenditure accounts during the reporting period, accumulated from the expenditure ledger.
I	CASH NET CHANGE (PERIOD)	The net change in cash for the period, calculated as Total Cash Receipts minus Total Cash Expenditures.	Calculated during the file creation process. The calculated value represents the net change in the cash balance for the period, equal to the Total Cash Receipts minus the Total Cash Expenditures.
J	TOTAL CASH BALANCE / PERIOD ENDING BALANCE	The cash balance at the end of the reporting period, calculated as the Period Starting Balance plus the Cash Net Change (Period).	Calculated during the file creation process. The calculated value represents the cash balance at the end of the reporting period, equal to the Period Starting Balance plus the Cash Net Change (Period).
K	OUTSTANDING ENCUMBRANCES	The total encumbrances posted to the fund across all expenditure accounts during the reporting period.	Calculated during the file creation process. The calculated value represents the sum of all encumbrance amounts posted to the fund across all expenditure accounts during the reporting period, accumulated from the expenditure ledger.
L	UNENCUMBERED BALANCE	The available cash balance after encumbrances, calculated as the Total Cash Balance / Period Ending Balance minus Outstanding Encumbrances.	Calculated during the file creation process. The calculated value represents the cash balance available after accounting for outstanding encumbrances, equal to the Total Cash Balance / Period Ending Balance minus the Outstanding Encumbrances.

REV DETAIL

The following table shows the columns, column names, descriptions, and data sources or valid values for the Rev Detail tab of the Fund Activity Detail Report’s Excel file layout.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year for the reporting period.	Populated during the file creation process. Retrieved from the Year field on the General tab of the Post Receipts - Batch Entry page.
B	PERIOD	The fiscal period within the year for which activity is reported.	Populated during the file creation process. Retrieved from the Period field on the General tab of the Post Receipts - Batch Entry page.
C	FUND / SPCC	The fund and special cost center code combination.	Calculated during the file creation process. The calculated value represents the fund and special cost center combination formatted as [Fund Code] - [SCC Code], derived from the Fund field on the Organization Record page.
D	FUND / SPCC DESCRIPTION	The title of the organization associated with the fund.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
E	BUDGET UNIT	The key organization code that identifies the budget unit for the revenue account.	Populated during the file creation process. Retrieved from the Fund field on the Organization Record page.
F	REVENUE	The revenue account code associated with the transaction.	Populated during the file creation process. Retrieved from the Account field on the Revenue Budgets Adjustment page.
G	BUDGET UNIT / REVENUE DESCRIPTION	The title of the revenue account associated with the budget unit.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
H	DATE	The date the revenue transaction was posted.	Populated during the file creation process. Retrieved from the Date field on the Post Receipts page.
I	DESCRIPTION	The description entered for the revenue transaction at the time of posting.	Populated during the file creation process. Retrieved from the Description field on the Post Receipts page.
J	PAYER #	The payer or vendor number associated with the revenue transaction.	Populated during the file creation process. Retrieved from the Payer Number field on the Post Receipts page.
K	PAYER	The name of the payer or vendor associated with the revenue transaction.	Populated during the file creation process. Retrieved from the payer name that auto-populates based on the Payer Number field on the Post Receipts page.
L	TRANSACTION CODE	The system-assigned code identifying the type of revenue transaction (for example, cash receipt or journal entry).	Calculated during the file creation process. The calculated value represents the system-assigned code that identifies the type of revenue transaction, such as 24 for cash receipts and 19 for journal entries.
M	RCPT/JE #	The receipt number for cash receipt transactions, or the journal entry number for journal entry transactions.	Populated during the file creation process. Retrieved from the Receipt Number field on the Post Receipts page. For journal entry transactions (transaction code 19), the value is retrieved from the journal entry number stored in the transaction record.
N	BUDGET BEGINNING BALANCE	The revenue budget balance for the account immediately before the transaction is applied.	Calculated during the file creation process. The calculated value represents the revenue budget balance for the account immediately before the transaction is applied.
O	AMOUNT	The revenue transaction amount, adjusted for the transaction direction based on the transaction code.	Calculated during the file creation process. The calculated value represents the transaction amount, adjusted for the transaction direction based on the transaction code.
P	BUDGET ENDING BALANCE	The revenue budget balance for the account immediately after the transaction is applied.	Calculated during the file creation process. The calculated value represents the account's revenue budget balance immediately after the transaction is applied.

REV SUMMARY

The following table shows the columns, column names, descriptions, and data sources or valid values for the Rev Summary tab of the Fund Activity Detail Report’s Excel file layout.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year for the reporting period.	Populated during the file creation process. Retrieved from the Start Year and End Year fields on the OH Fund Activity Report page.
B	PERIOD	The fiscal period within the year for which activity is reported.	Populated during the file creation process. Retrieved from the Start Period and End Period fields on the OH Fund Activity Report page.
C	FUND / SPCC	The fund and special cost center code combination.	Calculated during the file creation process. The calculated value represents the fund and special cost center combination, formatted as the first three characters of the fund code followed by a hyphen and the remaining characters, derived from the Fund field on the Organization Record page.
D	FUND / SPCC DESCRIPTION	The title of the organization associated with the fund.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
E	BUDGET UNIT	The key organization code that identifies the budget unit for the revenue account.	Populated during the file creation process. Retrieved from the Fund field on the Organization Record page.
F	REVENUE	The revenue account code associated with the budget unit.	Populated during the file creation process. Retrieved from the Account field on the Revenue Budgets Adjustment page.
G	BUDGET UNIT / REVENUE DESCRIPTION	The title of the revenue account associated with the budget unit.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
H	BUDGET BEGINNING BALANCE	The revenue budget balance for the account at the start of the period, calculated as the cumulative budget appropriations minus receipts posted through the end of the prior period.	Calculated during the file creation process. The calculated value represents the revenue budget balance at the start of the period, equal to the sum of all prior-period budget appropriations minus all prior-period receipts, plus the current period's budget appropriation, as recorded in the revenue ledger.
I	PERIOD RECEIPTS	The total revenue received and posted to the account during the reporting period.	Calculated during the file creation process. The calculated value represents the total cash receipts posted to the revenue account during the period, as accumulated in the revenue ledger.
J	BUDGET ENDING BALANCE	The revenue budget balance remaining at the end of the period, calculated as the Budget Beginning Balance minus the Period Receipts.	Calculated during the file creation process. The calculated value represents the remaining revenue budget balance at the end of the period, equal to the Budget Beginning Balance minus Period Receipts.

EXP DETAIL

The following table shows the columns, column names, descriptions, and data sources or valid values for the Exp Detail tab of the Fund Activity Detail Report’s Excel file layout.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year for the reporting period.	Populated during the file creation process. Retrieved from the Start Year and End Year fields on the OH Fund Activity Report page.
B	PERIOD	The fiscal period within the year for which activity is reported.	Populated during the file creation process. Retrieved from the Start Period and End Period fields on the OH Fund Activity Report page.
C	FUND / SPCC	The fund and special cost center code combination.	Calculated during the file creation process. The calculated value represents the fund and special cost center combination, formatted as the first three characters of the fund code followed by a hyphen and the remaining characters, derived from the Fund field on the Organization Record page.
D	FUND / SPCC DESCRIPTION	The title of the organization associated with the fund.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
E	BUDGET UNIT	The key organization code that identifies the budget unit for the expenditure account.	Populated during the file creation process. Retrieved from the Key Organization field on the Organization Record page.
F	EXPENDITURES	The expenditure account code associated with the budget unit.	Populated during the file creation process. Retrieved from the Account field on the Budget Adjustments - Batch Entry page.
G	BUDGET UNIT / EXP DESCRIPTION	The title of the expenditure account associated with the budget unit.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
H	DATE	The date the expenditure transaction was posted.	Populated during the file creation process. Retrieved from the Date field on the Change Accounts Payable page.
I	DESCRIPTION	The description entered for the expenditure transaction at the time of posting.	Populated during the file creation process. Retrieved from the Description field on the Change Accounts Payable page.
J	VENDOR #	The vendor number associated with the expenditure transaction.	Populated during the file creation process. Retrieved from the Vendor field on the Change Accounts Payable page.
K	VENDOR	The name of the vendor associated with the expenditure transaction.	Populated during the file creation process. Retrieved from the vendor name that auto-populates based on the Vendor field on the Change Accounts Payable page.
L	TRANSACTION CODE	The system-assigned code identifying the type of expenditure transaction (for example, budget appropriation, budget transfer, encumbrance, or accounts payable payment).	Calculated during the file creation process. The calculated value represents the system-assigned code that identifies the type of expenditure transaction, such as 11 for budget appropriations, 13 for budget transfers, 17 and 18 for encumbrances, and 24 for accounts payable payments.
M	RCPT/JE #	The encumbrance or purchase order number associated with the transaction, or the journal entry number for journal entry transactions.	Populated during the file creation process. Retrieved from the encumbrance number stored in the transaction record, which originates from the encumbrance entry associated with the purchase order or journal entry.
N	CHECK #	The check number assigned to the disbursement during the check printing or manual check process.	Calculated during the file creation process. The calculated value is the check number assigned during disbursement, either during check printing or during the manual check process.
O	BUDGET BEGINNING BALANCE	The expenditure budget balance for the account immediately before the transaction is applied.	Calculated during the file creation process. The calculated value represents the account's expenditure budget balance immediately before the transaction is applied, equal to the sum of all prior-period budget appropriations minus all prior-period expenditures and encumbrances, plus the current period's budget appropriation.
P	AMOUNT	The expenditure transaction amount, adjusted for the transaction direction based on the transaction code.	Calculated during the file creation process. The calculated value represents the transaction amount, adjusted for the transaction direction based on the transaction code. For accounts payable (transaction code 24) and budget transfer credits (transaction code 13), the value is negated.
Q	ENCUMBRANCE	The encumbrance amount associated with the transaction. For encumbrance-type transactions (transaction codes 17 and 18), this equals the transaction amount. For all other transaction codes, this equals the liquidated encumbrance amount.	Calculated during the file creation process. The calculated value represents the encumbrance amount associated with the transaction. For encumbrance-type transactions (transaction codes 17 and 18), the value equals the transaction amount. For all other transaction codes, the value equals the negative of the liquidated encumbrance amount stored in the transaction record.
R	BUDGET ENDING BALANCE	The expenditure budget balance for the account immediately after the transaction is applied, equal to the Budget Beginning Balance minus the sum of the Amount and the Encumbrance.	Calculated during the file creation process. The calculated value represents the account's expenditure budget balance immediately after the transaction is applied, equal to the Budget Beginning Balance minus the sum of the Amount and the Encumbrance.

EXP SUMMARY

The following table shows the columns, column names, descriptions, and data sources or valid values for the Exp Summary tab of the Fund Activity Detail Report’s Excel file layout.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year for the reporting period.	Populated during the file creation process. Retrieved from the Start Year and End Year fields on the OH Fund Activity Report page.
B	PERIOD	The fiscal period within the year for which activity is reported.	Populated during the file creation process. Retrieved from the Start Period and End Period fields on the OH Fund Activity Report page.
C	FUND / SPCC	The fund and special cost center code combination.	Calculated during the file creation process. The calculated value represents the fund and special cost center combination, formatted as the first three characters of the fund code followed by a hyphen and the remaining characters, derived from the Fund field on the Organization Record page.
D	FUND / SPCC DESCRIPTION	The title of the organization associated with the fund.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
E	BUDGET UNIT	The key organization code that identifies the budget unit for the expenditure account.	Populated during the file creation process. Retrieved from the Key Organization field on the Organization Record page.
F	EXPENDITURES	The expenditure account code associated with the budget unit.	Populated during the file creation process. Retrieved from the Account field on the Budget Adjustments - Batch Entry page.
G	BUDGET UNIT / EXPENDITURE DESCRIPTION	The title of the expenditure account associated with the budget unit.	Populated during the file creation process. Retrieved from the Title field on the Organization Record page.
H	BUDGET BEGINNING BALANCE	The expenditure budget balance for the account at the start of the period, calculated as the cumulative budget appropriations minus expenditures and encumbrances posted through the end of the prior period, plus the current period's budget appropriation.	Calculated during the file creation process. The calculated value represents the account's expenditure budget balance at the start of the period, equal to the sum of all budget appropriations posted through the current period minus all expenditures and encumbrances posted in prior periods, plus the current period's budget appropriation.
I	PERIOD EXPENDITURES	The total expenditure amount posted to the account during the reporting period.	Calculated during the file creation process. The calculated value represents the total expenditure amount posted to the account during the period, accumulated from all individual expenditure transactions recorded for that period.
J	PERIOD ENCUMBRANCES	The total encumbrance amount posted to the account during the reporting period.	Calculated during the file creation process. The calculated value represents the total encumbrance amount posted to the account during the period, accumulated from all individual encumbrance transactions recorded for that period.
K	BUDGET ENDING BALANCE	The expenditure budget balance remaining at the end of the period, calculated as the Budget Beginning Balance minus the sum of the Period Expenditures and Period Encumbrances.	Calculated during the file creation process. The calculated value represents the remaining expenditure budget balance at the end of the period, equal to the Budget Beginning Balance minus the sum of Period Expenditures and Period Encumbrances.