Report Name: RPT-CM-008 CI Cash Balance Report
Report Description: CI Cash Balance Report provides information regarding the availability of CI funds by agency budget code. The data elements used to determine these balances (deposits/allotments, transfers, requisitions, and payments) by budget code for each agency include:
- Adjusted Appropriation Balance by budget code
- Allotment Balance by budget code
- Unallotted Appropriations Balance (calculated) by budget code
- Receipts PTD (Deposits and Transfers In) by Budget Code -(posted)
- Expenditures PTD (Requisitions and Transfers Out) 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’
- Allotment Balance(calculated) by budget code
- Available Balance (calculated) by budget code