Project Detail
The Project Detail report displays labor and expense transaction detail for projects.
This report provides the following information:
- Labor Distribution: The report shows which employees have charged time to each project in the current accounting period or for the life of the project.
- Billing Assistance: The report provides a complete record of hours spent by each employee on each project and the resulting monetary amount charged to the project. it also gives a complete record of all project expenses, by account number. You can use this report to provide supporting billing information for an invoice if a client requests additional detail.
- Project Cost Record: The report displays detailed project labor and expense cost information. You can also generate the report at billing rates if you are using the Billing application. When you generate the report at billing rates, it displays the billing potential of labor and expenses at the time of posting.
Labor and Expense Sections
The report displays transactions in sections based on type: labor and each type of expense (direct, direct consultant, and so on). At the lowest level of the work breakdown structure (WBS), you can sort labor transactions by employee or by labor code. You can generate the report for the current period, the year to date, the job to date, a range of periods, or a range of dates.
Below each labor section, the report displays the total overhead allocated.
Additional Contents
In addition to the labor and expense detail, you can include the following:
- Selected information from the Projects hub (principal, project manager, client, and so on) for each WBS level.
- User-defined fields.
- A Financial Analysis section for each WBS level. Those sections display amounts in the following columns for the current period, the year to date, and the job to date:
- Fees billed, consultants billed, reimbursable billed, other billed, total billed, revenue, and spent amounts.
- The difference between spent and revenue. This is labeled Profit if you use cost rates and Variance if you use billing rates.
- Profit percentage, if you use cost rates, or the variance percentage, if you use billing rates. This percentage is the profit or variance divided by revenue.
- Expected gross compensation.
- Current cash received for the job to date.
- Total accounts receivable and unbilled amounts for the job to date. These amounts include retainage amounts, if applied.
- Effective multiplier, if you use cost rates, or realization ratio, if you use billing rates.
- Revenue method.
Symbols Used on the Report
An asterisk (*) to the left of a detail line indicates the transaction was transferred from another project.
A small u indicates unposted time.
Effective Dates
Billing includes the option to specify effective dates for billing rates. You can establish a schedule of rates at which employee labor is billed throughout the course of a project.
If a project's billing rate is determined by a billing labor rate table, the date of the transaction affects the billing rate. This applies to transactions entered through Transaction Entry, using a Billing Labor Insert, or using a Billing Labor Transfer. DPS compares the transaction date with the effective dates in the billing labor rate table to determine which billing rate to use to calculate the billing amount.
Leading Zeros in Voucher Numbers
If your enterprise uses leading zeros in voucher numbers but you do not want to display the zeros on the report, clear the Display Voucher Number Leading Zeros option on the Accounts Payable tab of the System AP Configuration form ().
Expanding and Collapsing Report Groups
If you are using Microsoft SQL Server 2008 and if, select Print Financial Analysis on the Options tab, and enable the option to collapse and expand a report group, disables the expand/collapse option for report groups is disabled when you generate the report with this set of options. This is necessary because a defect in Microsoft software would cause the report to fail otherwise.
Options Dialog Box
Use the Options dialog box to specify reporting options for a report. Depending on the report, the dialog box contains one or more of the following tabs: General, Sorting/Grouping, Columns, Budget, Metrics, User Defined Sections, Activity, Drill Down, Layout, and Graph.