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 Vision 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 Project Info Center (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
Vision 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. Vision 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 firm uses leading zeros in voucher numbers but you do not want to display the zeros, you can clear the Display voucher number leading zeros option on the Accounts Payable tab of the System AP Configuration form (Configuration > Accounting > System AP).
Expanding and Collapsing Report Groups
If you are using Microsoft SQL Server 2008 and if, on the Options tab of the Options dialog box for this report, you select Print Financial Analysis and you also enable the option to collapse and expand a report group, Vision disables the expand/collapse option for report groups 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.
Related Topics
- Display the Project Detail
The Project Detail report is a project report. - Project Detail General Tab
Use the General tab to select report options for the Project Detail report and to save sets of options for reuse. - Project Detail Options Tab
Use the Options tab to indicate if you want to display the project information and financial analysis sections and to specify options for displaying that data. - Activity Tab of the Options Dialog Box
Use the Activity tab to specify a period for the report and to filter the report to only include projects, phases, or tasks with activity in that period. You can set up a report to be generated on a recurring basis. If you set up a recurring report to show current activity, Vision bases the report on the accounting period that is current at the time it generates the report. - Project Detail Labor and Expense Tab
Use the Labor and Expense tab to indicate if you want the report to display labor detail, expense detail, or both. The tab also provides a number of options for how the labor and expense information is displayed. - Project Detail Columns Tab
Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats. The columns you select on the Columns tab are for the labor and expense detail rows.