Kentucky State University
Business Policies and Procedures Manual
- Compare earnings credits and fees with industry data and other banking providers
- Meet with bank and investment representatives for account reviews annually.
- Recommend new banking contracts as appropriate.
Cash Forecasting
Responsible position(s):
Required documents and access:
- Banner
- Month-end cash balance report
- Projections of cash receipts from tuition, appropriations, scheduled disbursements, payroll, bond obligations, etc.
Frequency and timing:
- Weekly – short term cash projections
- Monthly – long-term projections for at least 1 fiscal year
Steps:
- Update monthly actuals with balance details for all cash accounts
- oCash balance report that goes to CPE for month-end – use this report to update the ending balances for the month
| Balances - 8/31/2023 | | |
|---|
| | |
| Bank Accounts | | |
|---|
| Bank 60 Fifth Third General Depository | 3,709,813.98 | Fifth Third Sweep Acct |
|---|
| Outstanding Checks | (601,068.88) | Bank 56 -ARP Report |
|---|
| (15,181.46) | Bank 55 ARP Report |
|---|
| Bank 09 State Account | 4,736,482.51 | State Account 2550-ALL |
|---|
| Bank 20 State Appropriations | - | State Allotment Acct 2540S |
|---|
| Total Funds Available | 7,830,046.15 | |
|---|
| | State Capital Project 2550-CP-APD* |
|---|
| Bank 29 State Capital Project Account | 4,010,168.21 | |
|---|
| Bank 52 Perkins Account | 81,281.56 | Perkins Account |
|---|
| Total Bank Accounts | 11,921,495.92 | |
|---|
- Review General account activity in Banner and categorize transactions based on source, i.e. transactions from the Cashier account (Bank 58) are inflows from student payments
- oPull report for Bank 60 out of FGRGLTA. Other Bank account reports may be necessary in future steps.
- oOnce in the FGRGLTA screen, the report can be accessed by completing the following:
Printer = DATABASE
Parameter Values = (see below for example, Bank 60 is account code 110060)