Cash Requirements Report Fields
  • 29 Nov 2023
  • Contributors
  • Dark
    Light
  • PDF

Cash Requirements Report Fields

  • Dark
    Light
  • PDF

Article summary

 


Cash Requirements Report Fields


The Cash Requirements report lists the Cash Requirement value, the Administrative Fee (if recorded via the Edit and Post Administrative Fees utility in the Fund Management module), and the difference (Net Amount) for each Fund.

The report lists the Cash Requirement value for each Fund in the first column. This figure is accurate regardless of how the value is calculated (for example, G/L method, FACTS method, imported, or created via the Edit and Post Administrative Fees utility in the Fund Management module). Most users will find that only this first column is relevant to their usage of the Spending Policy system.

The second column lists the Administrative Fee (if recorded via the Edit and Post Administrative Fees utility in the Fund Management module).

The third column (Amount) is the difference between the first two columns (the Available to Grant amount for organizations that “back into” this value by subtracting the admin fees from a “grants plus admin” spending calculation). The Create Recurring, G/L, or Budget Entries utility allows you to duplicate this derivation for the actual General Ledger entries (select the Spend Pol minus Admin Fee radio button).

The last two columns – Historic Gift Value and Market Value, are derived from FACTS. The Historic Gift Value sums transactions from General Ledger with a GifP Type, so will not be accurate if Gifts are initially deposited outside the pool and swept into FACTS via a utility that creates Journal Key codes that are not set up to translate into that Tran Type (this method of tracking historic gift value is seldom used – most organizations use a fund balance).

If all Gifts create GifP Types in FACTS, the difference of these two columns is the spendable amount under UMIFA, and compared to the Amount column will tell you whether historic Gifts will be invaded by Grants. These same amounts are also listed on the Manually Adjust Spending Policy Amounts utility.

The report offers full sort, selection, and subtotals based on the Fund fields and prompts for the fiscal year whose cash requirements you want to view. 

Example:  Cash Requirements Report

Field

Description

Fund ID

The Fund ID for the Fund whose cash requirements are listed in the adjacent columns.

Fund Year

The fiscal year that the report is based on.

Cash Requirement

The cash requirement value for the Fund, as of the last calculation.

Admin Fee

Any administrative fees for the Fund, if recorded v via the Edit and Post Administrative Fees utility in the Fund Management module.

This process saves the Admin Fee in the FundSummaryHistory record.

Net Amount

The difference between Cash Requirement and Admin Fee amounts.

Total FACTS Hist Gift Value

The total historic Gift value for the Fund, summed from GifP transactions in FACTS.

Total FACTS Market value

The total FACTS Market Value for the Fund.

 


Was this article helpful?