Tracking CAPEX/OPEX Using Tempo for Server

This tutorial is created using Timesheets Version 9.

In this tutorial, you will track CAPEX and OPEX on worklogs. You will do this by creating accounts and linking them to Jira projects, issues, and worklogs. Then you will view all logged CAPEX and OPEX hours in a custom report. You need Tempo Timesheets for Server to complete these tasks.

In this tutorial:

Prerequisites:

  • A Jira project management project is needed for this tutorial. 
  • The project must have at least 2 project tasks with original and remaining estimates.
  • Make sure the Account field is available on the Issue page.
  • Make sure you know exactly which issues are Opex and Capex related. For example, Task - 1: Development = CAPEX, Task - 2: Training = OPEX.

Step 1: Creating Tempo Account categories


Before creating accounts, define the Account Categories by which to group your accounts. Create new categories for your customer accounts, such as Development, Sales and Marketing, Training, Service and Maintenance, etc. Specify a type for your categories: Billable, Internal, Capitalized, or Operational

Example:

Account CategoryAccount Category Type
DevelopmentCapitalized
TrainingOperational

 To create an account category...


Creating categories requires the Tempo Account Administrator permission.

Categories provide an efficient way to categorize logged time by type. You can create categories to group hours by cost center and work activities. For example, if you have several accounts containing sales and marketing data, you could create a new 'Sales and Marketing' category and assign those accounts to it. Each account category you create needs to have one of four predefined Types that classify the account category for different uses in Tempo.

To create an account category:

  1. Select Settings  in the Tempo sidebar.
  2. Under Accounts, select Account Categories
  3. In the Account Categories view, enter a Key and Name for the new category, and select a category Type:
    1. Billable - hours logged are billed to a customer or billed internally; for example, consultancy work for a customer or hours that an internal service department bills other departments.
    2. Capitalized - hours logged that add capital to the business and are not billed. For example, hours that are invested in product development.
    3. Internal - hours logged to ongoing activities within the organization that are not billed and do not directly add value to the business; for example, internal training, vacations, or sick leave. These are known as Internal issues in Tempo. Note that you still need to enter 0 in the Billable field when you're logging time to an Internal account - see Creating Non-billable Accounts for Internal Issues - Tempo Server for information.
    4. Operational - hours logged related to business operations. For example, time spent on marketing activities, internal systems or customer support (other than billable support).
  4. Click Add to create the new category.

Deleting Account Categories

You can delete account categories that are no longer needed.

  • In the Account Categories view, click Delete in the Action column for the category you want to delete.

Note

If an account is linked to one or more projects or issues, Tempo notifies you that the account is still in use and that you must remove any links before you can delete the account.

Step 2: Creating a CAPEX account and linking it to your Jira project


Now you can set up accounts and link them to your Jira projects and issues. Create a CAPEX account and name it App Development. Assign Taylor as the Account Lead and associate the Development category with the account. Because you already categorized Development as Capitalized, the account will automatically be specified as a Capitalized account.

 To create an account...


Creating and editing accounts requires the Tempo Account Administrator permission.

You can create accounts to organize the logged time data in your organization. There are different reasons you may want to do this, such as for the purpose of invoicing customers or tracking your capitalized expenses (Capex). You can associate a customer to an account, but it's not required.

A powerful feature with Tempo accounts is that you can connect the accounts to the Jira projects that you and your organization will be working on, which lets employees then log their time to a specific account. Doing this will help you organize your data easily later on in reports; for example, you can filter a Logged Time report by the accounts and get a clear view of how much time has been spent on each one.

Note

  • You can also import accounts from *.csv or *.xml files.
  • The Account Custom Field is installed automatically with Tempo Accounts, but may need to be configured further, depending on how you want to associate the account information to time records.

To create an account:

  1. Select Accounts  in the Tempo sidebar.
  2. Click the +Create Account button at the top-right.
  3. Fill in the Create Account form:
    1. Name - A descriptive name for the account. The combination of the account name and key is used to display the account in Jira issues or in the Log Time form in Tempo Timesheets, depending on configuration.
    2. Key - The account key needs to be unique for the account. A suggested key based on the account name is auto-generated, but you can enter any value you like. The key can use letters (a-z, A-Z), digits (0-9), underscore ("_"), dash ("-") or a dot ("."). You cannot change the key after the account is created.
    3. Lead - The account lead is responsible for the account. You can either select an existing Jira user's name or simply enter a name.
    4. Category - Optional. Select a category to associate with the account from the dropdown. The account category is a way to group different cost centers and work activities, such as Development or Marketing. There are four types of categories you can use: Billable, Capitalized, Operational, and Internal. 
      To create or edit categories, click the settings icon  at the top-right, and select Categories
    5. Customer - Optional. Select a customer to associate with the account from the drop-down menu. The customer does not need to be an outside customer, it may simply be a way to group together a common entity (Jira projects or cost centers) of your definition for the projects linked to the account. 

    6. Contact - Optional. Depending on the purpose of the account, for internal or external use, the contact may or may not be a Jira user.

    7. Projects - Select the projects that include issues you will be logging time on for this account. You can link more than one project to an account.
  4. If you want to create another account, check the Create another box.
  5. When you are finished, click Create

Note

It is not mandatory to add a customer, a contact, or category when creating accounts. You edit the account later - see below.

Global Accounts

You can create a global account that is linked to all projects. To do so, first create an account as described above, then:

  1. Click the Account name in the list to access the Account Overview.
  2. Under Links to Projects, select the Make this account global checkbox.

Editing Account Information

You can edit the following information about an account: account name, customer, category, status, monthly budget, lead, and contact. 

  1. In the Accounts view, click the name of the account you want to edit.
  2. You can edit the account Name, Customer, Category, Monthly Budget, Lead, and Contact. The account Key cannot be changed after the account is created.

Adding a Monthly Budget

Monthly Budget is used to display a status of hours worked vs the budget for the selected month. This is displayed in the Account Monthly Budget Burn-up Chart gadget available in Tempo Timesheets. In the Accounts view, enter the hours that can be spent on the account during the period in the Monthly Budget field.

Tempo Account Monthly Budget Burn-up Chart

When you have created the account, you need to link it to your Jira project.

 To link a project to an account...


Linking accounts to Jira projects requires the Tempo Account Administrator permission.

Tempo accounts can be linked to one or more Jira projects so that an account can be selected from the ​Account​dropdown when you log your time. The Account Custom field must be added first so that there is the Accountdropdown available in Jira issues or in the Log Time form. Only accounts that have been linked to Jira projects will be available from this Accountdropdown.


There are several ways in which you can link an account to one or more Jira projects:
  • When you create an account​, you can select the projects to which you want that account to be linked. The projects can also be included in the imported file if the accounts are created with any of the Accounts Import features.

  • In a Jira project's Account settings. From here, you can also set the default account to be used for all issues in a Jira project.

  • From an account's Overview - see below.

Linking to Projects from the Account's Overview

You can link existing accounts to one or more projects in the Accounts overview. 

  1. Select Accounts  in the Tempo sidebar.
  2. In the Accounts view, select the account to which you want to link Jira projects.
  3. On the account's Overview, click ​+ Add Project Link​ at the right and search for the project to which you want to link the account. You can link one account to multiple projects.
  4. You can also select the ​Make this account global​ checkbox if you want to link the account to all Jira projects. Clearing the checkbox will unlink a global account from all Jira projects.

Keep the number of global accounts to a minimum because linking accounts to many Jira projects can have a negative impact on Tempo's performance.

Step 3: Creating an OPEX account and linking it to your Jira project


Similarly, create an OPEX account and name it Support Training. Again, Taylor is the Team Lead and the category is Training. This account will be specified as an Operational account type.

Again you need to link the the account to the same project as in Step 2. 

Step 4: Linking a CAPEX account to issues


Now you need to link the project issues to the correct accounts; for example, issues that relate to capitalized work, such as development, should be linked with a CAPEX account. Open a development issue and associate your App Development account to it. 

When you have updated the issue, log some time to it. Then browse to the App Development account. The issue count under your linked project should now show 1 issue.

Step 5: Linking an OPEX account to issues and logging time


Similarly, the project issues relating to operational work, such as training, need to be linked to an OPEX account. Open a training issue and link the Support Training account created in Step 2 to it.

When you have updated the issue, log some time to it. Then browse to the Support Training account. The issue count under your linked project should now show 1 issue.

Step 6: Viewing all CAPEX versus OPEX hours


In a Custom Report, you can view all hours logged to issues that are linked to the CAPEX and OPEX accounts. Generate a Custom Report, filter it by App Development (CAPEX) and Support Training (OPEX). You can then export the data for invoicing.

Step 7: Viewing all CAPEX versus OPEX hours across accounts


If you have multiple CAPEX and OPEX accounts, you can view all Capitalized and Operational hours logged on issues across your accounts. Generate a Custom Report, filter it by Account Category Type (Capitalized or Operational). 

 To filter information in a custom report...


  • Viewing worklogs for other team members requires the View All Worklogs and Browse Projects permissions for each project. 
  • You can view the worklog data from inactive or deleted Jira users in a report - see Inactive and Deleted Jira Users and Tempo Timesheets for more information.
  • Viewing plans requires the View Team Plans permission.
  • To report on planned time, you need to have Tempo Planner version 7.8 or later and Tempo Timesheets 10.8 or later installed. 
  • To report on planned vs actual time, you need to have Tempo Timesheets version 10.15 or later and Tempo Planner version 7.15 or later installed

You can customize your reports so that they show what you need in a meaningful manner. By default, report results are displayed in a grid format but you can also view the data as a detailed list. You can apply filters, organize the information into groups, sort the data by columns, set report preferences, and add columns to show Jira fields and work attributes as needed. When viewing reports as a grid, you can also define whether the grids represent days, weeks, months, or quarters.

Tempo remembers all your view settings and preferences between sessions. 

To access reports:

  • Select Reports  in the Tempo sidebar.

Switching between the Grid and List Views

Click the View button at the top-right, and then select either Grid view or List view.

Grid View

By default reports are displayed in a grid view. The grid view displays the report information in a timesheet-format. Each column in the grid represents a day, week, month, or quarter, depending on the Grid Periods option you select on the Grid view drop-down menu. You can also specify the what data to display using the Columns options.

  • For worklog reports, you can click the cells and log hours on issues.
  • By default, the grids represent days. You can select a different grid period and use the date picker to select a period to see what you need. Click Grid view at the top-right to select a grid period.

List View

You can select to display the report as a detailed list. The list view shows you the report information in table-format. You can choose which which attributes or work attributes to show using the Columns and List View Columns options on the List view drop-down menu.

Filtering Data 

Select filters for the reports to show only the information you need. You can, for example, select to view time logged on a specific project or all planned work for your team. The Filter by box at the top of the report shows which filters are applied.

To filter data in a report:

  1. Click the Filter by box to display a list of filter options. 
  2. Select the data you want to include in the report.
    • Use the search box to search for projects, teams, accounts, etc. To add a filter, select its check-box. To remove a filter, clear the check-box or click the beside its name in the Filter by box. 
    • If you select to filter by issues, you can also choose to include sub-tasks.
    • Click Back to return to the list of filters. 
  3. The Filter by box shows what filters are being applied in the report. You can remove a filter by clicking the x to the right of its name.

Below is an overview of the various fields you can use to filter your reports:

FilterWhat it does
TeamsFilters by Tempo team(s)
RolesFilters by staff role
UsersFilters by Jira user
LocationsFilters by office location
CustomersFilters by Tempo customers
AccountsFilters by Tempo account(s)
Account CategoriesFilters by Tempo account categories
Category Types
Filters by account category types, including billable, capitalized, internal and operational
ProjectsFilters by Jira projects
EpicsFilters by Jira epic(s)
IssuesFilters by Jira issues
Jira Filters (JQL)
Filters by predefined JQL filter

Grouping Data

Group data in your reports to help you structure your information in a meaningful way. The groups are displayed in the report according to Jira hierarchy. 

To simplify the report view, reports containing multiple levels of grouping do not display "empty" hierarchy levels. The following example shows a report that has been grouped by Epic/Issue/Sub-task/Worklog. No Epic hierarchy level is shown for Issue PRO-11 since it is not linked to an epic. Also, there is no hierarchy level for Sub-tasks because the issues do not have any. This makes the report look tidier and more easy to read.

To group data in a report:

  1. Click the Group by box to to display a list of possible choices. Select the groups you want to add. 
  2. To remove a level of grouping, click Group by, and then click x to the right of the specified group level.

Tip

In Plan Time reports plans submitted for approval are labelled with a colored dot  to indicate their approval status. A green dot means that they have been approved, yellow that they are in review, and red indicates a rejected plan. You can hover the mouse pointer over the dot to get approval details.

Below is an overview of the various fields that you can use to group data and organize your report results:
Group byWhat it doesAvailable report

Project

Groups data by Jira project(s)
  • Logged Time
  • Planned Time
  • Capacity
  • Planned vs Actual
User
Groups data by Jira user
  • Logged Time
  • Planned Time
  • Capacity
  • Planned vs Actual
LocationGroups data by office location
  • Logged Time
  • Planned Time
  • Capacity
Account
Groups data by Tempo account(s)
  • Logged Time
  • Planned Time
  • Capacity
  • Planned vs Actual
Epic
Groups data by Jira epic(s)
  • Logged Time
  • Planned Time
  • Capacity
  • Planned vs Actual
Issue
Groups data by Jira issue(s)
  • Logged Time
  • Planned Time
Sub-task
Groups data by Jira sub-task(s)
  • Logged Time
  • Planned Time
Component
Groups data by Jira component
  • Logged Time
Fix version
Groups data by Jira fix version
  • Logged Time
Worklog
Groups data by worklog(s)
  • Logged Time


Sorting Data

One way of organizing your report is to sort the data in alphabetical or numerical order. Sort a report by the data in a particular column by clicking that column’s heading. Clicking a column header sorts data according to that column’s ascending or descending order: the text is sorted from A to Z, numerical data is sorted from highest to lowest, and time/date data is sorted from earliest to latest.

  • Up and down arrows next to a column name indicate that data is being sorted by that column.
  • To reverse the sort order, click the column heading a second time.
  • In a report with multiple grouping levels, data is grouped by the top-level group. For example, the report above shows the most number of planned hours at the top sorted by user.

Adding and Removing Columns and Work Attributes

Adding and removing columns lets you select what information is displayed in your report. For example, if you want to view how many billable vs how many non-billable hours were spent on issues linked to an account, filter the report by Customer and group the information by Account. Then add the Billable column to compare billable and logged hours.

Column options are not the same for Worklog and Plan reports, and column availability depends on how report results are grouped, for example, worklog columns are only available when grouping by worklogs, issue columns when grouping by issue, etc. Work attributes can only be displayed when the report is in List view and when the report is grouped by Worklog. When trying to add a column that is not available, a pop-up message will show you what is required for the column to become available. 

To add columns and work attributes:

  1. Click the Grid view or List view button at the far-right. The button's label depends on which view is displayed.
  2. Select the columns and work attributes you want to show in your report. 
  3. To remove a column or a work attribute from the view, clear the check-box next to its name on the Grid/List view menu.


Below is a list of the various columns you can use to bring additional data into your reports:
Logged Time reportColumnWhat it does
ColumnsLogged
Displays time logged

Logged/Required
Displays logged time vs. required time

RequiredDisplays estimates of how much time the user is required to log, based on the workload and holiday scheme of the user

Billable 
Displays billable time logged

Planned
Displays time planned
List view columnsRemaining
Displays estimated hours that are remaining

Estimated
Displays estimated hours

Account
Displays account associated with time records

User
Displays user associated with time records

Log delayDisplays the time difference between when you created the time record and the date and time that the time record was logged to

Created
Shows when the time record was created
Planned Time reportColumnWhat it does
ColumnsPlanned
Displays time planned

Planned/Required (R%)Shows what percentage of time has been planned

Required (R)Displays estimates of how much time is required
List view columnsUser
Displays user associated with plan

Planned by
Displays who created the plan

Status
Shows the status of the planned issue(s)

Reviewed by
Displays who reviewed the plan(s)

Requested reviewer
Displays who has been requested to review the plan(s)

Status updatedShows if the status of the plan has been updated

Setting Date and Time Formats

You can select how dates, time, and duration are shown in your reports. Your preferences are applied immediately and are saved on a per-user basis. This affects how the date is displayed in the Date and Created columns in the List view when grouping by worklog, and in the Report Title field when saving.

The Duration options are not available in Tempo Timesheets versions 9.x.


To change the date, time, and duration format:

  1. Click the Settings button  at the top-right of the report.
  2. Select options as desired.

Viewing Issue Hours

If you have the View issue hours permission for the project but not the required permissions to view other users' worklogs, you can see the total number of hours per issue in the project, but not individual worklogs from other users.


On this Page