Navigate Here: Reports > CIP Planning Reports > Funding Reports >
Fund Source And Use Report is a report on fund source and use in a specific filtering phase.
You can configure the below settings before viewing the report. These settings will affect the content and layout of the report.
Filtering Phase: Select a filtering phase that determines the funded projects in the report. Please note each filtering phase has its own funded and unfunded project list and carries its own set of funding allocation numbers. The default is the current working filtering phase using your working cycle and working scenario. If you do not have the right to set the working cycle and working scenario, then your working cycle and working scenario will be the same as the system default. For further information on working scenario, system default scenario, working cycle, and system default cycle, please visit the Cycle and Scenario section under the Utilities module.
Fund Group: Select whether to contain funds in all fund groups or only in a specific fund group. This will filter the Fund list.
Fund: Select whether to contain all funds or only a specific fund.
Group the years after the first 5 years: If you select "Yes", the financial data for the first five years will be presented in detail, while the remaining years in the cycle will be grouped together. If you select "No", no years will be grouped, but you must specify how many years will be shown in Number of years. You can choose between 5, 6, 7, and 10 years.
You can set the Page Number Format and the Starting Page Number in the report. The Page Number Format allows you to enter text, symbols, or numbers to help display the page numbers on the report. For example, if you wanted to include the word “Page” before each number you would enter this in the first format text box. The page numbers would appear as “Page 1”, “Page 2”, etc. The Starting Page Number allows you to modify the starting page on your report. This is used for display purposes only, and will not affect the output of the report. The default starting page number is 1. You can also set the Print orientation of the report to either landscape or portrait.
Once you have finished, click the View Report button to open the report in a new window. Once the report is opened there are a number of features on the top navigation bar. You can export the report to PDF, Excel, Word, or RTF format by selecting the Export button. You can also navigate to another page using the page arrows, refresh the report by clicking the Refresh button, and adjust the zoom percentage of the report by selecting a different percentage in the dropdown box.
Projects in this report are classified as Ongoing/Annual or One-time, depending on the value of the Annual Project on the Project General Management form.
Below are the descriptions of the content contained in this report:
Fund Name: This is the Fund Name field on the Fund General Information form.
Fund Number: This is the Fund ID field on the Fund General Information form.
Description: This is the Fund Description field on the Fund General Information form.
FY 20NN - NN: These columns list the fund's beginning balance, revenues, interest and operating budget by fiscal year in the current working cycle. The information comes from the Revenue Forecast table on the Fund General Information form.
N Year Total: The sum of the fund's beginning balance, revenues, interest and operating budget during FY 20NN - NN. But the N Year Total of beginning balance is not a summary value. It is the first fiscal year's beginning balance.
Total Sources of Funds: Calculated by Beginning Balance + Revenues + Interest - Operating Budget.
Project ID and Name: The report lists all projects that are funded by a specific fund. Each project row shows the funding allocated from the fund by fiscal year. You can view the funding data on the Fund Allocation by Fund page.
Total Uses of Funds: The total funding allocated to projects from the fund by fiscal year.
Ending Fund Balance: It is the available funding of the fund, calculated by Total Sources of Funds - Total Uses of Funds.
