Once the project/shell funding sheet has been set up, the funds must be "funded" -- enter the funding amounts that will be used to fund your projects and shells. The following procedures discuss manually allocating funds and entering amounts to the funds that will be used in the project or shell. (Fund allocation using business processes is discussed in a later section.)
Commonly, the Manual Funding By Project data source is used as a manual entry column to enter the starting amount of each fund, or add additional funds to it. This column can be direct entry or line item entry, and is used for project level fund allocation. The Manual Project by CBS data source can be added to the project/fund cost sheet, and values added there. The same column data source can be added to the project/shell funding sheet to display the values added to the cost sheet column. This is used for CBS level fund allocation.
The following procedures assume that the appropriate funds (rows) and columns have already been added to the funding sheet. You can click a column heading to verify the data source used. For details about adding funds (rows) or columns to the company funding sheet.
To enter project level fund allocation values (on the funding sheet)
- Open the project or shell funding sheet.
- Locate the column that is used for adding value to funds on the sheet, commonly, the Manual Funding by Project column.
- Do one of the following:
- If the column is direct entry, click inside the cell and enter the amount. If the cell already has a value, you can modify it.
- If the column is line item entry, click the link in the cell. The Cell Detail window opens. You can:
- Click Add Line Item to add a new line item.
- Select a line item and click Copy Line Item to add a line item by copying another.
- Double-click an existing line item to modify it.
- Select a line item and click Remove Line Item to remove it.
Enter the line item information in the Line Item window and click OK.
This amount can be used as the starting project level amount of a fund. Other columns on the funding sheet can be used to track transactions, and formula columns can be added to keep track of the fund balance.
To enter CBS level fund allocation values (on the cost sheet)
- Open the project or shell cost sheet.
- Locate the column that is used for adding value to funds by CBS code, commonly, the Manual Funding by CBS column.
- Click the link in the cell. The Cell Detail window opens. You can:
- Click Add Line Item to add a new line item.
- Select a line item and click Copy Line Item to add a line item by copying another.
- Double-click an existing line item to modify it.
- Select a line item and click Remove Line Item to remove it.
- Complete the Line Item window.
- Select a fund from the fund picker by clicking the Select button for the Funding Source. The fund picker lists the funds that are active at the company level. To search for a specific fund, click Find.
- Click OK. The new line item will be added to the Cell Detail window. If the Manual Funding by CBS column has also been added to the project/shell funding sheet, the value will display there.
To add funding sheet data through a formula
Formula columns calculate results based on data entered in other columns. You cannot enter data directly into a formula column. You may click the funding sheet column header to view the data source for the cells in the column. If the column is a formula column, it will be displayed, and you can view which other columns are used in the calculation.