Hours Distribution by Project report

Use this report to review which employees are charging hours on your projects, how they are spending their time, and what hours are available to be billed.

This drilldown report starts at the project-total level, drills down to the phase totals, and then to the staff and specific dates hours were charged. This report displays hours entered on timesheets for specific projects. It does not include beginning balance hours entered in the Project Command Center.

You can summarize information by project manager or principal in charge, and drill down to project, phase, and employee timesheet detail information.

Audience

Principal

Project manager

Accounting

General staff

Producing the report

From the > Reports menu, click Project > Hours Distribution by Project.

Report options

Option	Description
Company	Multi-company only. The report contains information for all companies in your organization, unless you select a specific company in this field.
Project	The report contains information for all projects, unless you select a specific employee in this field.
Period	The report contains information for the current week, unless you select a different time period in this field.

Customize options

Option	Description
Report title	You can change the title of the report.
Sort order	Sorts the report by project, project manager, billing manager, principal-in-charge, project type, client, or department. If you use multi-company, you can also sort by company.
Summarize detail entries by	Organizes detail information by employee and then activity, or by activity and then employee
Limit by	Only prints projects associated with the department, project manager, or principal-in-charge who is producing the report. You can print all projects by selecting No limit. If you use multi-company, you can also limit by company.
Print graph	If selected, a graph of the information appears on the report.
Use drilldown	If selected, you can drill down to further detail on the report. If cleared, all information, including the lowest level of detail, prints on the report.
Print notes	If selected, it prints any notes entered for the project.
Print customize options on report	If selected, it prints a list of the options that you select.

Report contents

Column	Description
Project	The project ID
Description	The project name
Status	The current status of the project, as follows: A - Active P - Preliminary W - Work hold H - Hold B - Billing hold C - Closed
Total	Total hours worked on the project for the period selected
Billed	Total hours billed to the project during the period selected
Work-in-progress:
Total WIP	Total billable hours that are not yet included on a final invoice at the end of the period selected
Billable	WIP hours that have a status of billable. These hours are normally included on the current draft invoice for the project.
Deferred	WIP hours that have a status of deferred. These hours are included on your next draft invoice.
Hold	WIP hours that have a status of Hold

Nonbillable	Nonbillable hours worked on the project for the period selected
Write-off	Number of hours written off for the period selected

No Project row

When employees enter time to an item in the Overhead section of the timesheet, and that item is set up as an Overhead Group item with no project assigned to it, Ajera totals that time and identifies it as No Project.