Budget Worksheet General Tab

Use the General tab to select report options for the Budget Worksheet report and to save sets of options for reuse.

Contents

Field	Description
Report Name	You can change the default report name.
Create Activity	To create activities in the Activity Manager when you generate the report, select this check box. Deltek displays the Activity dialog box so that you can enter information about the activity, including its type (email, phone call, meeting, touchpoint, and so on), primary contact, and date/time. Deltek creates an activity for each record included on the report.

Base Rollup

Field	Description
Project Base Rollup	Use this option to summarize information for projects that use a standard numbering system. For example, if the first five characters of your project number represent a master contract, you can summarize (roll up) information for all projects that have a common master contract number. The Project Base Rollup slider box displays the number of characters in your project numbers. For example, if you use a 10-digit project number, the slider box displays 1234567890. A project number can also include up to two delimiters (for example, 12-345.67890). A phase total is the total of all occurrences of that phase across the base project. A task total is the total of all occurrences of that task across the base project. To roll up project numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.
Subtotal or Summarize on Base Number	If you set a project base rollup, use this field to select how you want Deltek to display the project data: Subtotal on Base Number: Select this option to display a group header at the beginning of each group of projects that matches the base rollup and then list each project in full detail. After the last project in the group, the report displays a group total. Summarize on Base Number: Select this option to display totals for each group but no project detail.
Phase Base Rollup	Use this option to summarize report information for phases that use a standard numbering system. The Phase Base Rollup slider box displays the number of characters in your firm’s phase numbers. For example, if you use a 7-digit phase number, the slider box displays 1234567. A phase number can also include one delimiter (for example, 12345.12). You can roll up the base phase and still display information by task. When you do, a task total is the total of all occurrences of that task across the base project. For example, the total for Task 00001 is the total of all Task 00001s in the base project. To display only phases and tasks, use the Project Base Rollup slider to cover the project number completely. To roll up phase numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.
Task Base Rollup	Use this option to summarize information at the task level for tasks that use a standard numbering system. This option is only available if you use tasks. The Task Base Rollup slider box displays the number of characters in your firm’s task numbers. For example, if you use a 3-digit task number, the slider box displays 123. This option works in the same way as the project and phase rollup options. For example, if the first two characters of your task number represent a department, you can roll up information for all tasks that have the same department number. To show only tasks, use the Project Base Rollup and Phase Base Rollup sliders to cover the project number and phase number completely. To roll up task numbers, drag a slider to cover the characters that you want rolled up. You can drag a slider from the left side of the slider box, the right side, or both sides.

Other Options

Field

Description

Report at

Select one of the following rate options: Billing: Select this option to display monetary amounts at billing rates. This option is only available if the Reporting at billing rates option is selected on the Reporting tab of the Accounting System Settings form (Settings > Advanced Accounting > System). Cost: Select this option to display monetary amounts at cost rates. This option is only available if the Reporting at burdened rates option is not selected on the Reporting tab of the Accounting System Settings form. Burden: Select this option to include overhead amounts in labor cost amounts. This option is only available if the Reporting at burdened rates option is selected on the Reporting tab of the Accounting System Settings form. If you use multiple currencies, your selection in the Report at field determines the type of currency used on the report. If Report at is set to Cost or Burden, Deltek displays amounts in the project currency. If Report at is set to Billing, the currency is based on the Use Billing Currency not Project Currency option on the Reporting tab of the Accounting System Settings form: When Use Billing Currency not Project Currency is selected, the amounts display in the project's billing currency. When Use Billing Currency not Project Currency is not selected, the amounts display in the project currency.