Generate Timesheet Reports

Every organization has different timesheet reporting needs, so you can generate timesheets reports from the custom
report
designer to leverage the power and flexibility in
filtering
and grouping on custom fields. By using
user
story and
defect
custom fields to track the accounting codes provided by your finance department, timesheet reports can display information about development time spent by accounting code.

Software companies can use story and defect custom fields to track accounting categories (using drop-down custom fields) or to track which stories are capitalizable (using a Boolean custom field). Development managers and scrum masters may then generate capitalization reports for the accounting department by filtering on these custom fields.

IT groups can use story and defect custom fields to assign charge-back codes to development work and report development time to respective cost centers.

Services organizations can use story and defect custom fields to track clients and billing codes.

If you include any
task
custom fields in your custom report, then only time entries that are associated with a task will be included in the report. In other words, time entries against a
project
only or a project with a story only will not be included.

Generate a Timesheet Report

Follow these steps:

Select Reports, Reports.

From the Reportspage
, select +Add New.

From the Custom Report Designer, select Timesheet as the type of report to generate.

In the Broken Down By section, select values for Date, User, Project, Work Item,
Package
, or any (story or task) custom field you use to organize your CA Agile Central work by accounting, cost center, or client codes.
Use the Add+ button to add any necessary fields.

In the Filters section, select two date filters to define the timesheet period to report on, and optionally the Package, Tags, or the custom fields you use to organize your CA Agile Central work by accounting, cost center, or client codes.

Select Run.
If the Timesheet report completes, the preview displays with the
result
for your criteria. From the preview, you can save the report in the Reportstab
, email it to others, or save it in CSV or PDF formats. To see these options, select the Page Tools menu.

Timesheet reports can often take a long time to run, especially if it includes a long time period. If you attempt to run a timesheet report and the report times out, you can use the following steps to get the report emailed when it completes.

Define your report criteria and select Run.

Select Page Tools, Email.

Enter your email (or the email where you want the report sent), select or modify the remaining fields as necessary, and select Send.

A green status flare displays in your timesheet report window, informing you that the report will be mailed when it completes. You may now close the report window.

Save a Timesheet Report

Follow these steps:

Run the report and select Save from the Page Tools options in the upper-right corner.

Name the report and add a brief description.

Select one of the following options for the report visibility:

Just me: The report will only be visible to you.

Anyone can view: The report will be visible (read-only) to everyone.

Anyone can view, edit, or delete: The report will be visible to everyone and anyone can edit or delete the report.

The Timesheet report is added to your list of custom reports on the Reports tab.

Generate a Capitalization Report

Use CA Agile Central custom fields to document your organization's accounting rules (typically drop-down options or a Boolean type). Set the custom field value for each CA Agile Central artifact either at the work item level or at the task level, but not both. Once custom field values have been set, the report designer can generate capitalization reports by filtering and grouping on the specific custom fields you set.

Examples

A capitalization report when using a task-level custom field named Accounting Code:

Report type = Timesheet

Broken by Task Accounting Code (custom) then by Project

Filtered by Date >= Oct 1 and Date <= Oct 31

This report displays Time Spent (hours) by Accounting Code and by Project for the month of October.

A capitalization report when using story-level Accounting Project and Accounting Task custom fields:

Report type = Timesheet

Broken by Story Accounting Project (custom) then Story Accounting Task (custom)

Filtered by Date >= Oct 1 and Date <= Oct 31

This report displays Time Spent (hours) by Accounting Project and Accounting Task for the month of October.

A capitalization report when using a story-level capitalizable Boolean custom field:

This report displays Time Spent (hours) only for capitalizable work for the month of October.

Generate a Billing Report

For professional services groups or organizations using consultants, timesheet reports can be as detailed as billing and invoice statements need to be.

Example

Report type = Timesheet

Broken by Date then by User then by Work Item then by Task Name

Filtered by Date >= Oct 1 and Date <= Oct 31

This report displays Time Spent (hours) by Date by User including the work description for the month of October.

Report Time Spent on Top-Level Stories

Features or
initiatives
are often broken down into a
hierarchy
of user stories. Each
user story
in the hierarchy represents a portion of work that is needed for the feature. Timesheet reports give you the ability to aggregate the time spent for the entire feature by focusing on its top-level
parent story
(top-level work item).

Follow these steps:

Select the Reports tab.

From the Reports page, select +Add New in the upper-right corner.

From the Custom Report Designer, select Timesheet as the type of report to generate.

Select Top-level Work Item in the Broken down by section.

To filter out standalone defects and stories, add a filter where the top-level work item contains the story name or a special label.

Select Run.

Use a naming convention to focus your report on feature-level stories, removing all others. For instance, use a label such as FEATURE in the name of your top-level parent story, then create a filter on that label to report list of features or initiatives and their costs.

When reporting time on top-level stories, consider the following:

Hours for
work items
outside of the current project scoping are not included in the cost aggregation.

The Top-level Work Item filter is case-sensitive.

Timesheet hours logged for defects or defect tasks associated with stories are not included in this report.

The report displays only the top level and lowest level of stories in the hierarchy.

Broken down by options are only applied to the lowest level of stories in the hierarchy.

-- No Entry -- values in the Top-level Work Item column indicate hours entered at the project level on a timesheet.

Generate Weekly Time Cards

At the end of each week, team members can generate a weekly time
card
to report on time they spent that week on development work. This report includes everything in the current timesheet sorted by day. The report also includes a Project Summary table at the bottom of the page.

Follow these steps:

From My Home, Timesheet, select the week for which to generate the time card.

From Page Tools, select Export as PDF.

Export Timesheet Reports to CSV

Team members can export their weekly time cards and managers can export aggregate timesheet reports to CSV.

Follow these steps:

From the Reports tab, select the Timesheet report from the right column that lists saved custom reports.

Select Export to CSV.

Feedback

Need more help? The CA Agile Central Community is your one-stop shop for self-service and support. To submit feedback or cases to CA Agile Central Support, find answers, and collaborate with others, please join us in the CA Agile Central Community.