Report Name: RPT-CM-030 Reserve Account Balances Report
Report Description: Reserve Cash Balance Report provides information regarding the availability of posted cash balances by agency budget code. The data elements used to determine cash balances (deposits, requisitions and transfers) by budget code for each agency include:
- Prior Year Ending Balance– Previous year ending balance
- Pending Adjustment to Prior Year
- Display Prior Year Ending Balance for the following Budget Codes
- 19900 – 19929
- 19949 – 19999
- Display -0- for the following Budget Codes
- 19800 – 19899
- 19930 – 19948
- Current Year Beginning Balance - Prior Year Ending Balance -Pending Adjustment to Prior Year
- Fund Balance Reclassification: Display YTD Activity for budget codes 19800 – 19899 and 19930 – 19948 using the following
Journal Categories:- OSC UNRESERVE FB RECLASS
- OSC INTER-RESV TRANSFER
- “Receipts YTD” (Deposits and Transfers In) of the Agency Cash Account by Budget Code- (Posted)
- “Expenditures YTD” (Requisitions and Transfers Out) of the Agency Cash Account by Budget Code - (posted)
- Report will include AP transactions in the calculation of expenditures by considering transactions that have:
- Source: Payables
- Category: Payments
- Calculate expenditure by sum of the ‘Cash Clearing’ lines within the payment batch [Total Credit -Debit] by budget fund
- Exclude payments where the supplier site starts with ‘IGO’
- Calculated Ending Cash Balance of the Agency Cash Account by Budget Code