Billing Projections tab
The Billing Projections tab summarizes the billing forecasts entered on the Billing tab by project across the firm for the next 12 months.
The Billing Projections tab uses the Billing End Cut-Off date, configured on the System Configuration General Settings tab, to determine which months to display. For example, if the Billing End Cut-Off date is set to the 5th of the month, the May billing period would appear from 5/5 through 6/4.
To access this tab
On the Projections and Analysis window, click the Billing Projections tab .
Data grid
The following fields are displayed in the data grid. All the fields are read-only.
Note: The fields shown to you by default may vary based upon your individual user settings.
Data can be grouped, filtered and sorted using the column headers. This allows project managers to quickly view the available information from different perspectives.
| Field | Description |
|---|---|
| Active / Opportunity |
Indicates whether the effort is an active project (regular, promotional or overhead) or an opportunity. |
| Scenario | The scenario value set for the opportunity phase. This value is set
by the project manager using the Scenario
option in the Financial
Projections toolbar. The Scenario value only applies to opportunities. |
| Office | The office associated with the project phase. |
| Client | The client associated with the project. Values are imported from the accounting system. |
| Client Type | The client type. Values are imported from the accounting system. |
| Project Number | The project number. Values are assigned in the accounting system. |
| WBS2 | This value is obtained directly from your accounting system. |
| Project Name | The project name. |
| Project Type | The project type. Values are imported from the accounting system. |
| Phase Name | The phase name. |
| Budget (dollars) | The budget (in dollars) assigned to the phase. This value comes from the Fee column on the Billing tab. |
| Billed | The total amount of billing posted for an identified fee or labor (hourly) billing in the accounting system. This value is equal to the Prior Billed column on the Billing tab. |
| Unbilled | The remaining unbilled amount for the phase. This value comes from the Future Projections column on the Billing tab. Note: When the budget amount is greater than the billed amount the amount to be billed will be zero (0). |
| Probability |
The probability that the project or related fee will occur. Regular, Promotional and Overhead projects are generally 100% probable while Opportunities will generally have a probability of less than 100%. |
| Monthly Columns | Monthly columns display projected billing going forward two years. The current month and next month are calculated based on the values entered in the Billing Tab. The remaining periods are calculated proportionally. For example a $100,000 fee with 10 months remaining will display $10,000 each month. |
| Reviewed | This column identifies which phases have been reviewed in the current billing cycle as entered in the Reviewed column on the Billing tab. |
| Status | The current billing process status as entered in the Status column on the Billing tab |
| By | Name of the user who selected the Reviewed check box as it appears on the Billing tab. |
Additional Fields
The field chooser contains additional columns which may be added to the grid. This may vary in your implementation due to your individual user settings. For the Billing Projections tab these columns are:
- %. The percent of the fee as part of the overall contract amount as it appears on the Billing tab.
- Billing Ends. The last day of work that will be billed as part of this phase as entered in the Invoice End field on the Billing tab.
- Billing Starts. The first day of work that will be billed as part of this phase as entered in the Invoice Start field on the Billing tab.
- Charge Type. The charge type for the effort. Options include Regular, Promotional and Overhead projects and Opportunities.
- Client Project Number. The client project number. This value can be entered by the project manager for opportunities on the Business Development tab. Values for other effort types are imported from the accounting system.
- Company. The company assigned to the project.
- Complete. Displays as a percentage the amount of the total fee for the phase that is expected to be billed by the end of the current billing cycle. It is a cumulative value that includes prior billing for the phase. This value comes from the Complete column on the Billing tab.
- Flag. May contain additional information about the billing for this phase (such as Incomplete Billing or Credit Applied). This information comes from the Flag column on the Billing tab.
- Group. The group assigned to the phase. Values are imported from the accounting system.
- Next Estimate. The next month's estimated billing amount, shown as a percentage of the total fee for the phase that is expected to be billed by the end of the next billing cycle. This value comes from the Projected column on the Billing tab.
- Period. The fiscal period for the budget detail item.
- Principal in Charge. The principal in charge assigned to the project.
- Project Manager. The project manager assigned to the project.
- Projection for: <current month>. The amount projected to be billed for the current billing cycle as set on the Billing tab.
- Seq. The billing sequence, which is defined in the accounting system.
- WBS3. This value is obtained directly from WBS fields in your accounting system.