Labor Billing Tab of the Project Budget Worksheet

Your project job-to-date labor budget lets you keep track of all labor to be charged to a project. Use this tab to establish your labor billing amounts.

Contents

Field	Description
Start Date	Specify the start date for work on this labor code.
End Date	Specify the end date for work on this labor code.
Overall Pct Comp	In this field, you can enter an overall percent complete for the entire project. If you do so, the percentage that you specify here overrides the overall percent complete that DPS calculates.
Lab Pct Comp	For any project, you can define an overall labor percent complete, an overall expense percent complete, or both, for your project: Define the overall labor percent complete here in the Lab Pct Comp field. Define the overall expense percent complete in the Exp Pct Comp field on the Expense Billing tab or Expense Costs tab.
Project Currency/Billing Currency	If you use multiple currencies, the currency is based on the setting for the Use Billing Currency not Project Currency option in Settings > Accounting > Labor Options: If this option is selected in Settings, the field displays the currency code for the project's billing currency. If this option is cleared in Settings, this field displays the currency code for the project currency.

Labor Billing Grid

Field	Description
Expense Costs Drop-down	Click the drop-down arrow on a grid header to complete any of the following actions: To print grid data, click Print. On the Print Preview form, click File > Print to send the grid data to your default printer. To export grid data to an Excel spreadsheet, click Export to Excel. When Microsoft Excel opens, use its features to modify, print, or email the grid data, or to save the spreadsheet file locally. To turn on grouping for a grid, click Enable Grouping. When a field displays with the instruction: "Drag a column header here to group by that column," drag and drop column headers into the field, in the sequence that you want them to display. Not all options are available on all grids.
Insert	Click this option to insert a row beneath the current row.
Delete	Click a row and then click this option to delete it.
Labor Code	Your labor budgets are based on labor codes. You can insert a new row to add a new budget line for any labor code that is valid for the current project. If you are inserting a row, you can enter a labor code in this field or select a labor code on the Labor Code lookup, which lists valid labor codes for the project.
Description	This field shows the description for the labor code that you specify in the Labor Code field.
% Complete	Enter your estimate of how far work has progressed on the project for this labor code. You should update the percent complete on a regular basis.
Hours	Enter the job-to-date budgeted number of hours for work to be performed under the labor code for the project.
Rate	Enter the job-to-date budgeted rate for work to be performed under the labor code for the project. This rate is stored as the billing rate.
Amount	This is the budgeted monetary amount for the labor to be charged to the labor code for the project. DPS automatically calculates this amount based on the hours and rate. To override the calculated amount, enter a different amount in this field.
EAC Hrs	Estimate at Completion Hours Enter your estimate of the total number of hours that will have been worked at the completion of the project, as reported for this labor code.
EAC Amt	Estimate at Completion Amount Enter your estimate of the total billing amount that will have been incurred at the completion of the project, as reported for this labor code.
ETC Hrs	Estimate to Complete Hours Enter your estimate of the total additional hours, beyond those worked to date, that are required to complete the work for this labor code.
ETC Amt	Estimate to Complete Amount Enter your estimate of the total additional billing amount required to complete the work for this labor code.
Start Date	Specify the start date for work on this labor code.
End Date	Specify the end date for work on this labor code.
JTD Hours	This field shows the actual hours reported, job-to-date, for this labor code, as calculated at the most recent posting.
JTD Spent	This field shows the actual billing amount spent, job-to-date, for this labor code, as calculated at the most recent posting. DPS calculates billing amounts based on the billing terms in effect at the time of the posting. When you post a transaction, DPS looks at the applicable billing terms to determine billing rates for project reporting purposes. If you later update the billing terms, your updates are not reflected on the project reports unless you refresh billing extensions. You should refresh billing extensions when you create or change the billing terms for any project, or after posting transactions for that project during the current period If you use multiple currencies, the currency is based on the setting for the Use Billing Currency not Project Currency option in Settings > Accounting > Labor Options: If this option is selected in Settings, the amount in this field is based on the project's billing currency. If this option is cleared in Settings, the amount in this field is based on the project currency.