The columns on the commitment funding sheet are used to manage and track the funding allocation, assignment and fund balances for the commit record.
Note: In these column definitions, the terms All Funds and Discrete Fund refer to the fund assignment options (from the Fund Assignment window, accessed from the SOV sheet or commitment funding sheet). These options determine how the SOV lines (and therefore, the commit lines) will be funded, either automatically or manually from the entire list of funds available to the commit, or by one specific fund.
The Funding Across All Funds column is used to enter (or calculate) the amount of each fund to allocate for this base commit record. The rows on the sheet are the funds that will be used to fund the commit. The value entered here will be the fund amount available for all commit lines that have "All Funds" as assignment. This can be a manual entry column, or a formula that uses another manual entry column as the basis of the formula.
Additional columns commonly track fund assignments (consumption) made against each fund. These can be in the form of business process transactions or manual funding assignments. System provided data sources that can be used for columns include the following:
- Funding By Discrete Fund: This column displays the sum total of all the line items of base and change commits that are funded by a specific (or "discrete") fund This value can be used to determine the fund balance during consumption.
- Records Funded Across All Funds: Reflects the total of funds consumed from records that are funded based on All Funds, whether funding is done manually or automatically.
- Records Funded By Discrete Fund: Displays the total of funds consumed from records that are funded based on a discrete fund, whether funding is done manually or automatically.
- Fund Balance Across All Funds: This column tracks the fund balance across all funds. The formula used is (Funding Across All Funds) - (Records Funded By All Funds).
- Fund Balance By Discrete Fund: This column tracks the fund balance by specific fund chosen in the Fund Assignment window. The formula used is (Funding By Discrete Fund) - (Records Funded By Discrete Fund).
- Funding Ratio Across All Funds: The value of this column is calculated automatically. It reflects the % ratio to use when performing fund assignment ratio during consumption. The formula is (Funding Across All Funds Per Fund) / Total of Fund Balance Across All Funds).