How to calculate the total payment for employees based on their logged hours and hourly rates with the Reports and Timesheets for Jira app

This article helps you display a report with total employee payments based on their logged hours and individual hourly rates in the list view.

Instructions

Create a Calculated field that computes employee payment based on their logged hours.

  1. Navigate to Apps and select Reports and Timesheets.

  2. Navigate to My Area and click the My Calculated Fields option. Click on Create New Field.

    image-20240325-110412.png

     

  3. Create a Calculated field to determine the payment based on logged time. This involves multiplying the user's payment by their logged time.

    image-20230920-115049-20230920-115339-20240325-114304.png

Create a Custom Report

  1. Navigate to Apps and select Reports and Timesheets.

  2. Navigate to New Report and select Custom Reports.

  3. Select view type as List.

  4. Add fields like Time entry: User Group by this field here, Rate, Time Entry: Logged Time, and also add the calculated field Rate*Logged Time (refer to the above steps to create a calculated field) to view the result.

  5. Incorporate a numeric custom field and assign distinct values for every Assignee in each issue. For example, add a custom field named "Rate" and assign values to individual assignees in each issue. Akhil's rate is configured at 100, whereas Priyal's is established at 50.

  6. Write a JQL as per the requirement.

  7. Run the report.

  8. It presents the overall payment outcome for employees according to their logged hours.

  • Make changes in the JQL or fields as per specific requirements.