User Guide

Time Balance & Overtime Report Parameters

Time Balance & Overtime report parameters include:

• Date range

  You can select a predefined date range or specify a custom one.

• Data grouping options

  Up to 2 data grouping levels are available in the report. You can choose between users, user groups, and time periods on each level.

• Selected staff

  Managers can select all staff, any departments or time zone groups, or only specific employees. Use predefined filtering options (select all, deselect all, show selected users only ) and search necessary users by name ().

  This setting is not available for regular users without management permissions.

  
• Report columns

  The report can be configured to display scheduled vs. reported time balance, overtime, or both. You can also configure it to show working and leave time in separate columns.

• Time format

  For HTML reports, you can choose either decimal format (##.##) or hours/minutes format (HH:MM). For CSV reports, decimal format is always applied.

Customers and projects to be included in the report

To see archived customers and projects in the customers and projects selector, select ‘Show archived customers and projects…‘ checkbox above the list of customers and projects.

Customers and projects from your management scope are marked with ‘Can manage’ note.

Leave Time & Balances Report

This report provides you with information on leave time reported for the selected leave types by actiTIME users. Managers will see information for users from their team, while regular users will see their personal data only.

Example of Leave Time Report

Leave time & balances information presented in the report includes:

• Total leave time reported for the selected leave types within the specified date range
• Time reported for each of the selected leave types within the specified date range
• PTO Balance as of the beginning and the end of the specified date range
• Sick Days Balance as of the beginning and the end of the specified date range

Example of Leave Time & Balances Report, with PTO & Sick Days Balances shown

For detailed information on PTO and Sick Days please see How to Manage Paid Time Off and Sick Days Settings section.

Report results can be grouped by users, by departments, by days, weeks, or calendar months, depending on what data you need to summarize.

The following filters are available for the Leave Time & Balances report:

• Date range
• Selected Staff – you can create a report for all staff or only for the selected system users and departments.
• Leave types – you can create a report for all leave types users reported time for or for the selected leave types.
• Leave Time and/or Balances.

Leave Time & Balances Report Parameters

Leave Time & Balances Report form

Parameters of Leave Time & Balances Report include:

• Date Range – you can use one of pre-defined date ranges or configure a custom one.
• Users to generate report for – all or selected actiTIME users, departments and time zone groups.

  This setting is available to managers only.

  • If you select option ‘All Staff‘, report will show information for all users who entered leave time for the selected leave types within the specified date range.
    Tip: Set ‘Include users without reported time’ checkbox in this filter, if you need to show users who did not reported leave time within the selected date range.
  • If you select specific departments or time zone groups, the report will show information for all users from these departments or time zone groups who entered leave time for the selected leave types within the specified date range.
  • If you select specific users, all selected users will be shown in the report even if some of them did not enter leave time within the selected date.

  To view only selected users in the user selector click on icon.

  
  View selected user only in the user selector

  To search users by name click on icon and start typing user name.

  
  Searching users by name in the user selector
  To show users with disabled access in the ‘Selected Staff‘ list set the ‘Show users with disabled access‘ checkbox under the list.
• Leave types to generate report for – all or selected leave types.
  
  Leave Type Selector
  Tip: To see archived leave types in the selector, set the ‘Show archived leave types…‘ checkbox under the list of leave types.
• Data grouping options
• Time format to be used in the HTML report – either decimal format (##.##) or hours/minutes format (HH:MM).
  Note: This option is not applicable to the reports in CSV format. Reports in the CSV format always use decimal format for time-track data.
• Columns to be shown in the report – when you have ‘Manage PTO & Sick Days Settings’ permission, you can choose which information should be shown in the report columns:
  • Leave Time & Balances
  • Leave Time only
  • Balances only

  Additional configuration options of the Leave Time & Balances Report allow you including following balance types in your report:

  • Show PTO & Sick Days Balances
  • Show PTO Balance
  • Show Sick Days Balance

The report to be generated is shown on the preview. You can change its parameters and set the appropriate configuration.

Time-Track Report

The Time-Track report lets you group, visualize, and analyze the data on how your team members allocate their time between various projects and tasks within the specified period.

Data available in the report depends on user permissions and assigned scope. Managers can run this report on their assigned team, while regular users see their own hours.

The Time-Track Report allows you to select the period to display the data from the menu in the upper-left corner of the screen.

You can also sort the data by tasks, projects, customers, date, etc., and filter it by users, customers, projects, and priority by selecting accordingly.

For a more straightforward analysis, you may group data in different rows and columns as needed.

The report also allows you to generate charts with the selected datasets for higher-level visualization and reporting. To create a chart, select the period and the data to be displayed and click on the Chart icon at the top-right corner of the screen.

Thus, you can prepare perfect reports for your seniors and customers. To export the report in CSV, XLS, or PDF format, click on the Export icon at the top-right corner of the screen.

Time-Track In Detail Report

Time-Track in Detail report provides the most detailed timesheet information including user comments on the reported time.

Data available in the report depends on user permissions and assigned scope. Managers can run this report on their assigned team, while regular users see their own hours. For more details, please see Permissions Required to Run a Report section.

Example of Time-Track In Detail report

Time-Track in Detail report allows you joining reported time and comments by tasks. If this option is selected, columns Date and User are hidden (if they are not selected as grouping options), and columns Spent Time and Comments contain aggregated values.

Example of Time-Track In Detail report(with two levels of data grouping and comments joined by tasks)

You can also use plain report format if you need raw data.

Example of Time-Track In Detail report, plain report format

Time-Track In Detail Report Parameters

To represent data in the most detailed way, the Time-Track in Detail Report offers many data grouping and filtering parameters.

1. Date range. You can select a preset date range or enter a custom one using calendar.
2. Data Grouping Level. Up to three data grouping levels are available in Time-Track in Detail Report.
   

   By changing data grouping order, you can summarize your data by different parameters.

   If you need data on what projects are the most time-consuming and what users are working on these projects, you can choose grouping by projects, then by users:

   

   If you need information on how users manage their time by spending it on specific tasks, group the data by users, then by tasks, etc.:

   

   Tip: If you have typical projects associated with different customers, you can group report data by project names. Your report will contain data related to each typical project.

   If you have typical tasks present in a number of projects, you can group data by task names. Your report will contain data related to each typical task.

   Use Join comments by tasks option to group comments by tasks: after applying this option, all comments for a specific task are shown in the row of this task.

   

   Time-Track in Detail Report without joining comments by tasks

   

   Time-Track in Detail Report with joining comments by tasks

3. Selected Staff filter.

   Managers can choose All Staff or only specific employees from their team. Staff filtering by departments or time zones is also available.

   Regular users without assigned teams will be able to access their own data only.

   
   Selected Staff Selector
4. Customer/Project filter.

   You can choose all customers and projects or filter data by specific customers and projects. Data for archived customers and projects are also available: to include it in the report, set the ‘Show archived customers and projects…‘ check box above the list of customers and projects.

   Note that users can see information only for customers, projects, and tasks assigned to them. Customers and projects from your management scope are marked with “Can manage” note.

   
   Customers and Projects Selector

   Note: If you select a customer when option ‘Show archived customers and projects…‘ is not selected, archived projects of this customer will not be shown in the report.

5. Time format to be used in the HTML report – either decimal format (##.##) or hours/minutes format (HH:MM).

   Note: This option is not applicable to the reports in CSV format. Reports in the CSV format always use decimal format for time-track data.

    

Estimated vs. Actual Time report is used to compare the task estimates to the actual time spent on these tasks. It also shows the variance between estimated and spent time.

Data available in the report depends on user permissions and assigned scope. Managers can run this report on their assigned team, while regular users see their own hours. For more details, please see Permissions Required to Run a Report.

This report is available in actiTIME interface only when ‘Task Estimates‘ feature is turned ON (see section Turn Features On / Off).

Spent time and variance between estimated and spent time are calculated as of the date specified in the report parameters.

Example of the Estimated vs. Actual Time Report, detailed form

Variance between estimated and spent time is calculated as

<Variance> = <Time Estimate> – <Spent Time>

When spent time is less than time estimate, variance is positive and means remaining time budget. When spent time is greater than time estimate, variance is negative and means extra time spent for the task, customer, or project.

Estimated vs. Actual Time report supports up to 3 levels of data grouping and an additional Detail level. The available grouping options include:

• Customers
• Projects
• Projects having the same names (by project names)
• Tasks
• Task having the same names (by task names)
• Types of Work

Grouping by project and task names allows to generate reports on “generic” projects and tasks, i.e. those ones that are usually presented in a number of customers (in case of grouping by project names) and projects (in case of grouping by task names).

actiTIME automatically calculates subtotals when grouping report records.

On the ‘lowest level’ report shows either per-user or per-task data. The report can be configured to hide this information and show only summary records, calculated according to the selected grouping options.

Example of the Estimated vs. Actual Time Report, summary form(per-user information is hidden)

To access Estimated vs. Actual Time report interfaces, use sub-menu ‘Estimated vs. Actual Time‘ of the top-level menu ‘Reports‘.

Estimated vs. Actual Time Report Parameters

Estimated vs. Actual Time Report form

Parameters of Estimated vs. Actual Time Report include:

• Customer(s) and project(s) to generate the report for:

  To see archived customers and projects in the customers and projects selector, set the ‘Show archived customers and projects…’ check box below the list of customers and projects.

  Note that users can see information only for customers, projects, and tasks assigned to them.

  
  Customers and Projects Selector

  If you select a customer when option ‘Show archived customers and projects…‘ is not selected, archived projects of this customer will not be shown in the report.

• Tasks to generate report for – one of the following options:
  • open tasks only
  • completed tasks only
  • all tasks (open and completed)

    By default report shows only started tasks that have time estimates. In addition you can configure how to process not started tasks and tasks without estimates:

  • If you want to get all time estimates specified for the selected projects – select option ‘Include estimates of not started tasks’
  • If you want to see all time spent on the selected project by the specified date (including time spent on the not estimated tasks) – select option ‘Include time spent on the tasks without estimates’
• Time format to be used in the HTML report – either decimal format (##.##) or hours/minutes format (HH:MM).

  This option is not applicable to the reports in CSV format. Reports in the CSV format always use decimal format for time-track data.

• Date to calculate spent time and variance between estimated and spent time on.

Task Performance Time Cards Report

The Time Cards Report contains the info submitted through the Calendar View of the Enter Time-Track interface. It captures time intervals for each task, i.e., the exact time users started and stopped to work on it during the day (e.g., from 9 AM to 4 PM, etc.).

Just like in the case of all other actiTIME reports, regular users can see only their personal data via the Task Performance Time Cards Reports, while managers can run it to review the data of their assigned users too.

Note: If the Calendar View feature is switched off in the Turn Features On / Off interface, the Task Performance Time Cards Report is not available.

Task Performance Time Cards Report Parameters

The report has a flexible configuration. You can customize it based on the following parameters:

• Preferable period – You can choose to show data for today, current week, previous week, previous months, custom date range, etc.
• Customers and projects – It’s possible to display data for all your projects and customers at once or only active / selected ones.
• Users – You can see time intervals submitted by all users or just some.

Besides, you can filter data in the report based on the duration of the logged time intervals, as well as the start and stop time of users’ work on tasks.

You may also choose how to group the data in the report, set a preferable time format for your time-track data and change the number and order of columns if necessary.

To do the latter, simply drag and drop the items from the Columns list to the required positions. After that, the actual report columns will be relocated in accordance with their list positions as well.

Lastly, the Task Performance Time Cards Report can be downloaded as a CSV file. Plus, if you want to save the set report configuration, you can save it as a shorcut and quickly access it at any time from the Reports Dashboard.

Custom Fields Report

The Custom Fields Report helps you analyze time tracking data linked to various custom task attributes you’ve created in your actiTIME account.

This report has a highly flexible configuration. You can:

• Choose a preferable date range for the analysis
• Filter your data by users, projects or customers
• Sort it by specific task attributes or exclude some custom fields from the view
• Change the order and quantity of columns
• Select one of the two available time formats for your data: HH:MM or ##.##
• Include tasks without time-track in the view
• Make the report as detailed as you want it to be via the data grouping settings

To run the report, follow this route: Reports Dashboard → + New Report → Custom Fields Report.

Once opened, you can change the report’s default data settings to your preferred ones. Plus, you can download the configured report as a CSV file or save it as a shortcut to the Reports Dashboard.

To run the Custom Fields Report, a user has to have one of the following permissions:

• Manage Accounts & Permissions
• Modify & Approve Users’ Time-Track
• Manage Scope of Work
• Manage Cost & Billing Data
• Enter Time-Track

Locations Report

The Locations Report depicts how much time you spend in different locations for any period of choice. It contains a beautiful bar chart that visualizes data and simplifies the comparison of results for different locations, users, departments, etc. Besides, the report includes a detailed table with a breakdown of hours by locations and individual employees.

You can access the Locations Report via the Reports Dashboard and configure it using the following parameters:

• Date range – It’s possible to set any preferable reporting period for your data. You can choose one of the predefined values from the drop-down menu (e.g., Current week, Previous month, Last 3 months, etc.) or define your own reporting period using the built-in date selector.
• Users – You have an option to run the report for only specific users / departments to keep it neat and avoid information overload.
• Locations – You can also exclude some locations from the report to make it as concise and focused as you wish.
• Data grouping – This setting lets you organize the reported data in a convenient way by dividing it into preferable grouping levels, e.g., Department → User, Months → Days, etc.

You can export the Locations Report as a CSV file – just click the export button at the top right corner of the interface once you’re finished with configuration.

Cost & Billing Reports

Cost & Billing Reports are all about showing you the full picture of the financial side of your enterprise. You can review a summary of your billable hours, see how they compare to your internal costs on a specific project or overall, and issue a quick PDF invoice to a customer. All reports offer a variety of customization options, making it very easy to build one that suits your needs best.

Please note that these reports cannot be accessed by regular users as they require the “Manage Cost & Billing Data” permission.

Billing Summary Report

Billing Summary report provides you with information about time reported for different types of work and billable amounts calculated on the basis of assigned billing rates.

This report is only available to managers with the “Manage Cost & Billing Data” permission. Data shown on the report depends on assigned team and scope. For more details, please see Permissions Required to Run a Report section.

This report is available in the actiTIME interface only when ‘Types of Work‘ feature is turned ON (see section Turn Features On / Off).

When ‘Types of Work‘ feature is turned ON, but ‘Hourly Billing Rates, Invoices & P/L Report‘ feature is turned OFF, the report does not include information on calculated billable amounts.

There are two forms of Billing Summary reports:

1. Count all time reported within a date range

   A Billing Summary report of this type is based on the number of hours spent on the tasks (including incomplete tasks) within the specified date range.

2. Count only time reported for tasks completed within a date range

   A Billing Summary report of this type is based on the overall number of hours (starting from task creation) spent on the tasks that were completed within the specified date range (according to their completion dates).

For both report types you can choose which information to show in the report:

• Approved/Non-Approved Time-Track
  • Show only approved time-track
  • Show both approved and not approved time-track
  • Show only not approved time-track
• Time and Billable Amount Information
  • Spent time only (for billable tasks, non-billable tasks, or both categories)
  • Billable amounts only (calculated for the billable tasks)
  • Both time spent on the billable tasks and billable amounts calculated for them

Billing Summary Report (spent time & billable amounts)

Billing Summary reports may be generated in the detailed or summary forms. This can be configured in the Data grouping section by selecting or deselecting the ‘Hide Details’ option.

In the detailed form, the report contains information about the tasks and/or time-track comments.

In the summary form, the information about the tasks and time-track comments is hidden and the report presents only summary records for the selected grouping options.

Billing Summary Report (spent time only, summary form)

The following filters are available for the Billing Summary report:

• Date range
• Customer and project – you can create a report for
  • all projects of all customers
  • all active projects of all active customers
  • one or several selected customers and/or projects

Billing Summary Report Parameters

Billing Summary Report Form when ‘Hourly Billing Rates, Invoices & P/L Report’ feature is turned ON

When ‘Hourly Billing Rates, Invoices & P/L Report‘ feature is turned OFF, the report does not include information on calculated billable amounts:

Fragment of Billing Summary Report Form when ‘Hourly Billing Rates, Invoices & P/L Report’ feature is turned OFF

Parameters of Billing Summary Report include:

• Customers and projects to generate the report for

  To see archived customers and projects in the customers and projects selector, set the ‘Show archived customers and projects…‘ checkbox above the list of customers and projects.

  Note that users can see information only for customers, projects, and tasks assigned to them.

  
  Customers and Projects Selector

  If you select a customer when option ‘Show archived customers and projects…‘ is not selected, archived projects of this customer will not be shown in the report.

• Report type:
  • Count all time reported within a date range
  • Count only time reported for tasks completed within a date range
• Data grouping options
• Information to show on the details level:
  • Tasks
  • Time-track comments
  • Tasks and time-track comments
• Information on time-track status:
  • Both approved and not approved time-track
  • Only approved time-track
  • Only not approved time-track
• Time and Billable Amount Information:
  • Show spent time (for billable tasks, for non-billable tasks, or for both billable and non-billable tasks)
  • Show billable amounts
  • Show spent time & billable amounts
• Time format to be used in the HTML report – either decimal format (##.##) or hours/minutes format (HH:MM).

  This option is not applicable to the reports in CSV format. Reports in the CSV format always use decimal format for time-track data.

• Date range – you can use one of pre-defined date ranges or configure a custom date range.

PDF Invoices

You can create invoices in PDF format on the base of time-track reported by users for billable tasks. The invoicing feature is only available to managers with the “Manage Cost & Billing Data” permission. Data shown on the invoice depends on assigned team and scope. For more details, please see Permissions Required to Run a Report section.

Invoice creation and invoice export are available in actiTIME interface only when ‘Hourly Billing Rates, Invoices & P/L Report‘ feature is turned ON (see section Turn Features On / Off).

There are two ways how actiTIME can count billable time in an invoice:

1. Count all time reported within a date range

   An invoice of this type is based on the working hours spent on the tasks (including incomplete tasks) within the specified date range.

2. Count only time reported for tasks completed within a date range

   An invoice of this type is based on the overall hours (starting from task creation) spent on the tasks that were completed within the specified date range (according to their completion dates).

For both invoice types you can define the information that will be shown in the invoice lines and how much detailed their description will be:

• The first configured grouping level defines what will be shown in the invoice lines.
• Additional grouping levels (2nd grouping level and level of details) define the information that will be shown as additional description of invoice lines.

You can turn off both the 1st and 2nd grouping levels. In this case ‘the first configured grouping level’ will be the details level, and invoice will contain a list of tasks.

Examples:

• If you configure data grouping options as Customers / Projects / Tasks, the invoice will contain one line for each pair ‘customer / type of work’ (with customer names accompanied with the related project and task names):
  
  Data shown in Billing Summary Report
  
  Data shown in the corresponding invoice
• If you configure data grouping options as Projects / Tasks, the invoice will contain one line for each pair ‘project / type of work’ (with project names accompanied with the related task names):
  
  Data shown in Billing Summary Report
  
  Data shown in the corresponding invoice
• If you configure data grouping options as Projects and turn off the 2nd grouping level and details, the invoice will contain one line for each pair ‘customer / type of work’ without additional details:
  
  Data shown in Billing Summary Report
  
  Data shown in the corresponding invoice

Please note that created invoices are not stored in actiTIME. If you need to get a copy of a previously created invoice, you will need to re-create it.

Invoice Parameters

All invoice parameters are divided into two parts:

• Invoice export parameters – parameters that define the information to be included into the invoice
• Invoice template parameters – parameters that define naming of specific invoice fields, taxes, and discounts

Invoice Export Parameters

Invoice Export Parameters Form

Invoice export parameters include:

• Customers and projects to generate the report for

  If you want to create an invoice for a specific customer or project, select it in the customers and projects selector. Note that users can see information only for customers, projects, and tasks assigned to them.

  
  Customers and Projects Selector

  If you select a customer when the option ‘Show archived customers and projects…‘ is not selected, the archived projects of this customer will not be shown in the invoice.

• Report type – one of
  • Count all time reported within a date range
  • Count only time reported for tasks completed within a date range
• Data grouping options

  If you select a customer when the option ‘Show archived customers and projects…‘ is not selected, the archived projects of this customer will not be shown in the invoice.

  • 1st grouping level: ‘Projects’
  • 2nd grouping level: Turned off
  • Details: ‘Tasks’ or Hidden

  If you are creating an invoice for a specific project, you may need to turn off the 1st and 2nd grouping levels, and keep only the details:

  • 1st grouping level: Turned off
  • 2nd grouping level: Turned off
  • Details: ‘Tasks’ or ‘Time-Track Comments’

• Date range – you can use one of pre-defined date ranges or configure a custom date range with specific “From” and “To” dates.

  Please note that actiTIME does not mark time included into the invoice as billed. Thus, be careful when selecting the date range for your invoice to avoid the same data being included into different invoices.

Invoice Template Parameters

Prepare Invoice form

Invoice template parameters include:

• Name of document (e.g. ‘INVOICE’)
• Name and address of your company
• ‘BILL TO’ field contents
• Names of optional invoice fields (e.g. ‘Reference Code’ and ‘PO#’)
• Invoice terms
• Discounts (names only)
• Taxes (names and values)
• Two optional footer messages

These parameters will be stored along with invoice export parameters when you save your invoice in the list of saved reports.

Please note that all information shown in the invoice is editable (except the auto-calculated amounts). You can add and delete the invoice lines as well as add and delete lines with taxes and discounts.

If there are non-taxable lines in the invoice, you can mark them as non-taxable in the ‘Amount’ column.

Notes on column names:

• ITEM = type of work
• QTY = spent time (man hours)
• RATE = billing rate for a task ($/mh)
• AMOUNT = total billing sum ($)

Notes on discounts and taxes:

• Discounts and taxes can be entered either as % of the invoice sub-total or as flat amounts.

  When discount is entered as a flat amount, it is evenly distributed between taxable and non-taxable invoice lines.

• Discounts are applied to the invoice sub-total amount before calculating taxes.

  When you specify several discounts, they are calculated independently of each other.

• Taxes are applied to the taxable part of the invoice sub-total amount after applying the discounts.

  When you specify several taxes, they are calculated independently of each other.

Invoice template parameters are saved automatically each time you create the invoice in PDF format by clicking on the ‘Create Invoice‘ button.

You can re-create the same invoice in PDF format as many times as you need. For example, you can preview your invoice in PDF format, then edit its parameters, and then create it again.

Cost of Work Report

Cost of Work report provides you with information on costs calculated for working and leave hours reported by the selected system users. Costs are calculated on the base of hourly user rates.

This report is only available to managers with the “Manage Cost & Billing Data” permission. Data shown on the report depends on assigned team and scope. For more details, please see Permissions Required to Run a Report section.

Example of Cost of Work Report, detailed form

Cost of Work Report is available in actiTIME interface only when ‘User Rates & Cost of Work Report‘ feature is turned ON (see section Turn Features On / Off).

Report Sections

The Cost of Work report consists of three sections:

• Costs calculated for the selected customers and projects on the base of regular user rates
  
  Cost of Work report, Costs calculated for the selected customers and projects

  This section shows costs calculated for the working time reported by the selected system users for the selected customers and projects within the specified date range.

  Note that costs shown in this report section are:

  1. Always calculated on the base of regular user rates
  2. Always calculated for all working time reported by the users for the selected customers and projects

  In particular, this means that costs shown in this report section include cost of overtime hours calculated on the base of regular user rates. See also description of the Overtime Addition costs listed below in the description of the General costs report section.

  You can configure how to group information shown in this section. Up to two grouping levels are available.

  Grouping by projects and tasks joined by name is a useful option, if you need to generate reports on ‘generic’ projects or tasks, i.e. projects with same names associated with different customers and tasks with same names performed in different projects.

  actiTIME automatically calculates subtotals when grouping report records.

• General costs
  
  Cost of Work report, ‘General costs’ section

  This section shows costs that do not depend on the selected customers and projects and depend only on the date range selected for the report.

  General costs include:

  • Leave Time costs – costs calculated on the base of leave time user rates.
  • Overtime Addition costs – additional costs calculated for users’ overtime hours reported within the specified date range. Overtime Addition costs are calculated as specified below: Overtime Addition Cost = (Overtime Hours) * (Overtime Rate – Regular Rate)

    Where parameter ‘Overtime Hours’ means one of the following:

    • Overtime hours reported by the users who are allowed to enter overtime manually
    • Auto-calculated overtime hours for the users with overtime calculation mode set to ‘Automatic calculation’

    Note that Overtime Addition does not depend on selected customers and projects. It shows additional overtime costs for the selected dates independently of the tasks users were working on at that time.

    This means that Overtime Addition does not change when you filter report records by customers and projects; thus in some cases report section with per-customer costs might not contain any spent time and costs (as they were filtered out), but the Overtime Addition Costs will be greater than zero.

• Grand Total
  
  Cost of Work report, ‘Grand Total’ section

  This section presents sum of costs shown in the other two report sections.

  Note that when you filter report records by customers and/or projects, section with general costs does not change, but the section with per-customer costs may depend on your filters.

  In this case summation of general costs and per-customer costs may provide you with results that are hard for interpreting, especially when selected users were working on the projects that were filtered out.

When displaying of leave time and overtime costs is turned off in report parameters, corresponding report section is hidden.

Example of Cost of Work report, displaying of leave time and overtime costs is turned off

Per-User Information Shown in the Report

Cost of Work report presents the following information for the selected users:

• Spent time – working or leave time reported by the user.

  You can turn off displaying of spent time in the report parameters.

• Rate – hourly user rate, one of the following:
  • Regular rate

    This rate is shown in the section presenting costs calculated for the selected customers and projects.

  • Leave Time rates

    These rates are shown in the General costs section, in the lines presenting leave time costs.

  • Overtime Addition rate

    This rate is shown in the General costs section, in the line presenting additional cost of overtime hours. Overtime addition rate is calculated as (Overtime Rate – Regular Rate).

  • Average rate

    Average rates are shown in the summary rows ‘Total for Leave Time‘ and ‘Grand Total‘. Average rates are calculated as (Cost / Spent Time).

  You can turn off displaying of user rates in the report parameters.

• Cost calculated on the base of hourly user rates

If hourly rates were changed for a user within the date range selected in the report parameters, the report will contain several sets of user-specific columns for each set of user rates.

Cost of Work report, columns for different user rates

For example, if rates for Billy Crown were changed on January 07, 2009, and report is generated for the date range from January 01, 2009 to January 08, 2009, the report will contain two column sets for Billy Crown:

• One for date range January 01, 2008 – January 06, 2009
• And another for date range January 07, 2009 – January 08, 2009

Compact and Detailed Report Formats

You can generate Cost of Work report in the compact or detailed form. Level of details to show in the report is configured in the report parameters.

You can choose which information to show in the report columns:

• Users in alphabetical order
• Departments only (without users)
• Users grouped by departments

In addition, you can show or hide the following information:

• Report columns:
  • Spent time
  • User rates
  • Average rates
  • Subtotals calculated for each department
• Report rows:
  • Per-task costs

In the most detailed form Cost of Work report shows all available information on the calculated costs:

Example of Cost of Work report, detailed form

In the most compact form Cost of Work report shows only costs without any additional details.

Example of Cost of Work report, compact form

You can also hide report rows displaying leave time and overtime addition costs.

Cost of Work Report Parameters

Cost of Work Report form

Parameters of Cost of Work Report include:

• Users to generate report for – all or selected actiTIME users, departments and time zone groups
  • If you select option ‘All Staff‘, the report will show information for all users who entered time within the specified date range.

    Note that users who did not enter time within the date range will not be shown in the report.

  • If you select specific departments or time zone groups, the report will show information for all users from these departments or time zone groups who entered time within the specified date range.

    Note that users who did not enter time within the date range will not be shown in the report.

  • If you select specific users, all selected users will be shown in the report even if some of them did not enter time within the selected date.

  To view only selected users in the user selector click on icon.

  
  View selected user only in the user selector

  To search users by name click on icon and start typing user name.

  
  <Searching users by name in the user selector

  To show users with disabled access in the ‘Selected Staff‘ list select ‘Show users with disabled access’ checkbox under the list.

• Data grouping options in the report section with customer- & project-specific costs.
• Time format to be used in the HTML report – either decimal format (##.##) or hours/minutes format (HH:MM).

  This option is not applicable to the reports in CSV format. Reports in the CSV format always use decimal format for time data.

• Information to show in the ‘General costs‘ report section:
  • Leave time costs
  • Overtime addition costs
• Information to show in the report columns:
  • Users in alphabetical order
  • User groups only
  • Users by user groups

  and options defining whether to show additional columns with supplementary information:

  • Spent time
  • Average rates
  • User rates
  • Subtotals by user groups
• Date range – you can use one of pre-defined date ranges or configure a custom date range.
• Customers and projects to generate the report for

  To see archived customers and projects in the customers and projects selector, select ‘Show archived customers and projects…‘ checkbox above the list of customers and projects.

  Note that users can see information only for customers, projects, and tasks assigned to them.

  
  Customers and Projects Selector

  If you select a customer when option ‘Show archived customers and projects…‘ is not selected, archived projects of this customer will not be shown in the report.

   

Profit/Loss Report

Profit/Loss report provides you with comparative information on billable amounts and costs.

This report is only available to managers with the “Manage Cost & Billing Data” permission. Data shown on the report depends on assigned team and scope. For more details, please see Permissions Required to Run a Report section.

Example of Profit/Loss Report

Profit/Loss Report is available in actiTIME interface only when both ‘User Rates & Cost of Work Report‘ and ‘Hourly Billing Rates, Invoices & P/L Report‘ features are turned ON (see section Turn Features On / Off).

Profit/Loss is calculated as

Profit/Loss = (Billable Amount – Cost)

Billable amounts are calculated on the base of hourly rates associated with types of work. Costs are calculated on the base of hourly user rates.

Profit/Loss report provides only summary information on costs and billable amounts. To get more detailed data generate Cost of Work Report or Billing Summary Report with the same parameters as you set for the Profit/Loss report.

To access Profit/Loss report interfaces, use sub-menu ‘Profit/Loss‘ of the top-level menu ‘Reports‘.

Report Sections

The Profit/Loss report consists of three sections:

• Profit/Loss calculated for the selected customers and projects
  
  Profit/Loss Report, P/L calculated for the selected customers and projects

  This section shows both costs and billable amounts calculated for the selected customers and projects.

  Costs shown in this section are calculated for the working time reported by the users for the selected customers and projects. These costs are always calculated on the base of regular user rates (for more details see also section How to Manage User Accounts) .

  Note that customer & project-specific costs are calculated on the base of all working time reported by the users, and thus include cost of overtime hours calculated on the base of regular user rates.

  There are also additional costs of overtime hours that depend on the difference between regular and overtime user rates. These costs are shown in the General Costs report section (see more details in this section description).

  Billable amounts are calculated on the base of hourly rates specified for types of work that are configured for the tasks actiTIME users reported time for (for more details see also section Types of Work).

  Information shown in this section is always grouped by customers, then by projects, and then by tasks. You can also choose to hide by-project and by-task information in the report parameters.

• General Costs
  
  Profit/Loss Report, ‘General Costs’ section

  This section shows general costs that do not relate to specific tasks and thus do not depend on the selected customers and projects. These costs depend only on the date range selected for the report.

  General costs include:

  • Leave Time costs – costs calculated on the base of leave time user rates.
  • Overtime Addition costs – additional costs calculated for users’ overtime hours reported within the specified date range. Overtime Addition costs are calculated as specified below:

    Overtime Addition Cost = (Overtime Hours) * (Overtime Rate – Regular Rate)

    Where parameter ‘Overtime Hours‘ means one of the following:

    • Overtime hours reported by the users who are allowed to enter overtime manually
    • Auto-calculated overtime hours for the users with overtime calculation mode set to ‘Automatic calculation’

      Note that Overtime Addition does not depend on selected customers and projects. It shows additional overtime costs for the selected dates independently of the tasks users were working on at that time.

      This means that Overtime Addition does not change when you filter report records by customers and projects; so in some cases it is possible that report section with per-customer costs will not contain any spent time and costs (because they were filtered out), but the Overtime Addition Costs will be greater than zero.

  This section does not show any billable amounts since general costs are not associated with specific tasks.

  You can turn off calculation of general costs in the report parameters.

• Overall Profit/Loss
  
  Profit/Loss Report, ‘Grand Total’ section

  This section presents sum of billable amounts, costs, and profit/loss shown in the other two report sections.

  Note that when you filter report records by customers and/or projects, the section with general costs does not change, but the section with Profit/Loss calculated for the selected customers and projects may depend on your filters.

  If this filtering is applied, the summarized data on general costs and per-customer profit/loss data may be hard to interpret, especially when working time was reported on the projects that were filtered out.

When leave time and overtime costs display is turned off in report parameters, Profit/Loss report contains only one section – Profit/Loss calculated for the selected customers and projects.

Example of a Profit/Loss Report, displaying of leave time and overtime costs is turned off

Compact and Detailed Report Forms

You can generate Profit/Loss report in the compact or detailed form. Level of details to show in the report is configured in the report parameters.

You can show or hide the following information:

• Report columns:
  • Spent time
  • Rates (billing rates and user rates)
• Report rows:
  • Profit/loss per task
  • Profit/loss per project

In the most detailed form the report shows all available information on profit and losses:

Example of a Profit/Loss report, detailed form

In the most compact form Profit/Loss report shows only billable amounts, costs, and profit/loss.

Example of a Profit/Loss report, compact form

You can also hide report rows displaying leave time and overtime addition costs.

Profit/Loss Report Parameters

Profit/Loss Report form

Parameters of Profit/Loss Report include:

• Customers and projects to generate the report for

  To see archived customers and projects in the customers and projects selector, select ‘Show archived customers and projects…‘ checkbox above the list of customers and projects.

  Note that users can see information only for customers, projects, and tasks assigned to them.

  
  Customers and Projects Selector

  If you select a customer when option ‘Show archived customers and projects…‘ is not selected, archived projects of this customer will not be shown in the report.

• Report format and level of details in the report section with customer- & project-specific data.

  You can choose to hide per-project and per-task data.

• Information to show in the ‘General costs‘ report section:
  • Leave time costs
  • Overtime addition costs
• Whether to show columns with additional information:
  • Spent time
  • Rates
• Date range – you can use one of pre-defined date ranges or configure a custom date range.

Time format to be used in the HTML report – either decimal format (##.##) or hours/minutes format (HH:MM).

This option is not applicable to the reports in CSV format. Reports in the CSV format always use decimal format for time data.

 

 

Charts

Timesheet charts display your time-track and cost & billing data in a bright and vivid form. They help organize information and provide a clear visual representation of your data.

Informative and fully customizable, the charts can be included in reports, presentations, statistical summaries etc. as an efficient tool to simplify the overview of large data amounts.

Access to charts is regulated by the set of user’s permissions. See the summary in the table below:

Permission

Manage Accounts
Permissions

Manage PTO
& Sick Days Settings

Manage Scope of Work

Modify &
Approve
Time-Track of Other Users

Generate Сost
& Billing
Reports

can see details for all users

can see details for assigned team and scope

Total working hours

Approved working hours

Leave time

Time-Track in Detail

PTO balance

Sick Days balance

Overtime hours

Cost of work

Billable amounts