Trust Fund Cash Balance and Activity Report (KKR059)
  • 11 Jul 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Trust Fund Cash Balance and Activity Report (KKR059)

  • Dark
    Light
  • PDF

Article summary

Report Description

This report provides the Trust Fund spendable cash balance and is updated from Accounts Receivable (AR), Accounts Payable (AP), and Inter/IntraUnit IU, GL journal entries captured in Florida PALM Financials along with pending activity that may impact the overall cash balance.

Report Navigation: Main Menu > Florida PALM > Reports > KK > TF Cash Balance & Activity Rpt 

Click below to view the sample report layout.

Business Roles

The following business roles have access to this report:

Business Process Models

This report can be found in the following business processes:

Selection Criteria

The report data can be filtered by the following selection criteria:

Data Field

Data Field Details

Business Unit

Required

Fund From

Optional

Fund To

Optional

Report Layout

The layout of the report is listed below. 

Data Field

Florida PALM RECORD.FIELD Mapping

Business Unit

LEDGER_KK.BUSINESS_UNIT

Transactional Fund

LEDGER_KK.FUND_CODE

Spendable Cash Balance

LEDGER_KK.POSTED_TOTAL_AMOUNT

Pending AP Transactions

PYMNT_VCHR_XREF.(PYMNT_GROSS_AMT-PAID_AMT)

AR Unverified Deposits

For Regular Customer Payments -

ITEM_DST.MONETARY_AMOUNT

For Direct Journal Payments -
PAY_MISC_DST.MONETARY_AMOUNT

Pending IU Transactions

FLP_IU_TRANS_DTL.MONETARY_AMOUNT

Pending GL Journals

JRNL_LN.MONETARY_AMOUNT

Anticipated Cash Balance

N/A

Version History

Date

Revision Description

07/02/2024

Original Version




Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.