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.
Responsible position(s):
Senior Accountant
Banner
Month-end cash balance report
Projections of cash receipts from tuition, appropriations, scheduled disbursements, payroll, bond obligations, etc.
Weekly – short term cash projections
Monthly – long-term projections for at least 1 fiscal year
Update monthly actuals with balance details for all cash accounts
Cash 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
Pull report for Bank 60 out of FGRGLTA. Other Bank account reports may be necessary in future steps.
Once 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)