You are here: Ajera Help (A-Z) > year-end > evaluate year > Hours Distribution by Project report

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.

 

 

© 2023 Deltek Inc. All rights reserved.