Cash Position Report - File Layout and Data Mapping
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. |