What This Report Shows


  • This report uses the balance sheet account masters in conjunction with the bank masters from the Bank Reconciliation module.
  • It facilitates the use of pooled bank accounts and is predicated on the use of unique cash codes for each different bank account.


Best Practices


  • Unique Cash Code - For organizations with numerous investment accounts: LGIP (Local Government Investment Plans) and CD (Certificates of Deposit), a unique cash code may not be possible, or available, for each of these. In such cases, we recommend a unique code based on type.
    • For example: Cash code 111 may represent different LGIP accounts and 112 for a certain group of Certificates of Deposits. For that reason, you may wish to have the five bank identifications on the Select and Range Tab be ones that do not share a cash code.
    • The bank accounts with shared codes (LGIP & CD) would then be reflected in the Other Banks column of the report.


Requirements


  • Viewing Format - To view this report in its intended format, bank identifications that do not share a cash code must be created.
  • Sharing Cash Codes - Bank IDs that share a cash code are to be placed in the Other Banks column for separation from the IDs that do not share a cash code.


Cash Balance Summary Report by Bank and Fund (Annual/Monthly)


  1. Finance → Financial Management → Reports → Summary → G/L → Cash Balance Summary by Bank and Fund → Annual/Monthly OR Finance → Bank Reconciliation → Reports → Cash Balance Summary by Bank
  2. Fill in the appropriate fiscal year and month (if running monthly report).
  3. Choose the Bank IDs you wish to show in the five scroll bars shown (any Bank IDs not chosen will be shared in the last column – Other Banks).
  4. In the Range Tab, range on fund if necessary.
  5. Click Select (process wheel).


Select and Sort Tab

FIELDSOpt.Rec.Req.Description
Reset Group Defaults♦——Group defaults can be setup to populate certain fields based on what was saved previously
Fiscal Year——♦The fiscal year information from balance sheet account year masters is pulled from
Fiscal Month——♦If running monthly report only: the fiscal month information from balance sheet account year masters is pulled from
Sub-Title♦——An optional report title
Bank Identification 1-5——♦A Bank ID from each field will show in its own separate column in conjunction with a fund that the cash code has affected
Select Posted——♦Transactions that have been included in the posting process
Select Distributed♦——Transactions that have been included in the distribution process
Select Undistributed♦——Transactions that have only been source-user verified


Range Tab

FIELDSOpt.Rec.Req.Description
Range on Fund♦——Range on a fund if necessary
Opt. = Optional  Rec. = Recommended  Req. = Required