The default file names for the Cash Position report are:
-
PDF: OH Cash Position Report_<MMDDYYYY_hhmmss>.pdf
-
Excel: OH Cash Position 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 Cash Position report.
|
Column |
Column Name |
Description |
Data Source or Valid Values |
|---|---|---|---|
|
A |
FUND |
The three-character fund code. |
Retrieved from the Fund field on the General Ledger. The first three characters of the Fund code are extracted from the General Ledger record. |
|
B |
SCC |
The Special Cost Center code (positions 4-7 of the organization key). |
Retrieved from the Fund field on the General Ledger. The Special Cost Center (SCC) is extracted from the General Ledger record as the last four characters of the Fund code. |
|
C |
DESCRIPTION |
The Fund/SCC description. |
Retrieved from the Title field on the Organization Chart page. The system looks up the title based on the Fund/Key Organization code. |
|
D |
BEGINNING BALANCE |
The beginning cash balance for the fund/SCC. |
Calculated during the report generation process. The calculated value represents the sum of transaction amounts from the Transaction file (TRANSACT) for the Fund, based on the selected accounting period. |
|
E |
MTD RECEIPTS |
The month-to-date (current period) receipts. |
Calculated during the report generation process. The calculated value represents the month-to-date receipts from the Revenue Ledger for the selected accounting period. Retrieved from the Exp (revenue) fields on the Revenue Ledger for the current period. |
|
F |
FYTD RECEIPTS |
The fiscal year-to-date receipts. |
Calculated during the report generation process. The calculated value represents the sum of receipts from the Revenue Ledger from Period 1 through the selected accounting period. Retrieved from the Exp (revenue) fields on the Revenue Ledger. |
|
G |
MTD EXPENDITURES |
The month-to-date (current period) expenditures. |
Calculated during the report generation process. The calculated value represents the month-to-date expenditures from the Expenditure Ledger for the selected accounting period. Retrieved from the Exp fields on the Expenditure Ledger for the current period. |
|
H |
FYTD EXPENDITURES |
The fiscal year-to-date expenditures. |
Calculated during the report generation process. The calculated value represents the sum of expenditures from the Expenditure Ledger from Period 1 through the selected accounting period. Retrieved from the Exp fields on the Expenditure Ledger. |
|
I |
CURRENT FUND BALANCE |
The current cash balance. |
Calculated during the report generation process. The calculated value is BEGINNING BALANCE + FYTD RECEIPTS - FYTD EXPENDITURES. |
|
J |
CURRENT ENCUMBRANCE |
The current outstanding encumbrances (open purchase orders). |
Calculated during the report generation process. The calculated value represents the sum of encumbrances from the Expenditure Ledger from Period 1 through the selected accounting period. Retrieved from the Enc fields on the Expenditure Ledger. |
|
K |
UNENCUMBERED FUND BALANCE |
The available cash after encumbrances. |
Calculated during the report generation process. The calculated value is CURRENT FUND BALANCE - CURRENT ENCUMBRANCE. |
Row Types
The .csv output includes multiple row types:
|
Row Type |
Description |
|---|---|
|
Header Row |
Column headers in the first row. |
|
Detail Row |
Individual fund/SCC data with all 11 columns populated. |
|
Fund Total Row |
Subtotal for each fund. Column 1 contains "TOTAL FOR Fund XXX:" where XXX is the fund code. Columns 4-11 contain the fund totals. |
|
Grand Total Row |
Grand total for all funds. Column 1 contains "GRAND TOTALS:". Columns 4-11 contain the overall totals. |