Interest Allocation Report - Unexpected Average Daily Balance and Interest amounts

Interest Allocation receives unexpected Average Daily Balance and an Interest amount when using the option Calculate outstanding activity via Pooled Cash setup

• Interest Allocation Report Define screen
• Summary or Detail Report
• Create Journal option (GEN)

• Interest Allocation (IA)
• Cash Flow (CF)
• Average Daily Balance

Interest Allocation option:

Calculate outstanding activity via Pooled Cash setup - might be selected when a site uses Fund & Secondary Balancing

• Review Interest Allocation options selected
• If the option Calculate outstanding activity via Pooled Cash setup is selected try removing it to see if the amount changes
  • There could be outstanding AP checks contributing Average Daily Balance amount experienced for the Fund or subfund

• How to identify if Secondary Balancing is in use 
• Calculate outstanding activity via Pooled Cash setup
  • Instructs the program to apply each outstanding AP check to the cash account in the fund or subfund for the invoice expense rather than applying all outstanding checks to the pooled cash account, when selected
    
    • How To Clear or Unclear AP Checks
• AP settings > Check settings > Default cash account = Pooled Cash Balance Sheet: 
  • Defaults pooled cash account to AP batch
  • Pooled cash account Inherited by AP Invoice
    • Post API hits expense account Fund/Sub-Division and Accounts Payable control
    • Cash disbursement APP would hit pooled default cash fund account, then hit Accounts Payable control for Fund/Sub-Division and then DTDF would trigger to balance out all funds involved for debit/credit.
• Reconciliation could be difficult as unpaid or outstanding AP checks could be on Fund/Sub-Division and Accounts Payable control while outstanding AP checks tied are cleared off the pooled cash account