worklog per month time tracking

[Laura Fallon]

I am trying to pull a report where it shows all the time that was logged for a specific month. without having to be tied to an epic, or a sprint, or anything. 

Basically, Tom logged 4 hours to a work item in December and then logged 7 more hours in January. I want to be able to pull a report for January and see the 7 hours that Tom logged to that work item. I want a report that shows all the issues with the time for the month spent that I can then on my own in excel add up.

[Michał Kowalewski_SolDevelo · Accepted solution]

Hi @Laura Fallon Welcome to the community!

If you're open to martketplace apps, then you may consider Worklogs - Time Tracking, Time Reports, Timesheets, the app that was developed by my team.

The app allows you to easily display time logs of your teammates for a particular date range, for example, for a specific month.

After viewing your desired work logs, you can export them to the XLSX file.

There are of course more features, and if you want to see the app in the action I encourgae you to book a demo session with us.

Feel free to contact us if you have any questions.

Kind regards,
Michał from SolDevelo

[Robert DaSilva]

Hey @Laura Fallon , you should be able to accomplish this via Jira Filters and a custom JQL query.

Based on your note, you're looking for an excel export that shows all time entries by a specific person, in a specific period of time. Jira offers two fields you can filter against: worklogdate, and worklogauthor.

Here's how I would recommend building your query:

worklogdate > 2025-12-01 AND worklogdate < 2026-02-01 AND worklogauthor = Tom

The worklog author is going to require an Atlassian Account, so you'll need to type that in manually and select the right person from the pop-up that shows.

This will give you a list of Jira work items where Tom has logged time, between the dates of Dec 1st and Feb 1st. When you export this data to Excel, make sure you select the "All Fields" option so that all the relevant work log entries export. You can then do some excel magic to convert the time in seconds into minutes or hours.

Hope this helps!

Robert

[Trudy Claspill]

Hello @Laura Fallon 

Adding to this..

In your first sentence you asked for a report of all time logged during a specific month.

Jira does not natively provide a report of the time logged in a given time period 

As described by @Robert DaSilva  you can get a report of all the issues against which time was logged in a given time period. And you can export all data for those issues to get all the time logged against those issues regardless of when that time was logged. You would need to use another tool to reduce that to only the work logs that fall within your specified time period.

There are third party apps that would enable you to get the report you asked for. Are you open to using a third party app?

[Rahul_RVS]

Hi @Laura Fallon 

Welcome to the community !! 

As suggested by everyone, a mktplace app can help here. If you are open to try out one for detailed time tracking reports, pls take a look at 

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Time sheet screen. With Calendar view and Board view

Disclaimer : I am part of the dev team

[Gökçe Karaduman-The Starware]

Hi @Laura Fallon ,

If you’re open to using a third-party app, this is exactly the type of use case where WorklogPRO – Timesheets and Cost Tracker for Jira can help.

With WorklogPRO’s Timesheet report, reporting is based directly on worklog dates, not on issue structure. So in your example, if Tom logged 4 hours in December and 7 hours in January on the same issue, a Timesheet filtered for January will only show the 7 hours logged in January.

To achieve this, you simply need to set the date range to the specific month (e.g., January) and group the data by User → Issue (or any structure that fits your needs).

Additionally, you can view all worklogs and their authors within the selected period, giving you full visibility into who logged time and when. Using WorklogPRO’s filtering capabilities, you can also select a specific user—Tom in your case—and see only the worklogs that person logged during that month.

One convenient feature is the variety of export options available directly from the Timesheet report interface. You can export your data as:

• A PDF grid for easy sharing and printing
• An Excel grid (XLS) that preserves the report layout for further analysis
• A Worklog export (XLS) focused on detailed worklog entries
• A Worklog export (CSV) for compatibility with various data tools

This makes it easy to pull the data you need and perform additional calculations or summaries in Excel or other spreadsheet software.

Disclaimer: I work for the vendor who developed this application.

[Anton from JetHeads_io]

Hey @Laura Fallon!

Native Jira doesn't let you filter worklogs by the date they were logged — it only shows total time per issue, not broken down by month.

JetTime (a third-party Jira app) can do exactly this — generate a timesheet report filtered by date range (e.g., January 2026) showing all worklogs and/or work items from that period. You'll see Tom's 7 hours logged in January as a separate entry, and you can export the full report to Excel to continue working with the data there (add up totals, pivot, etc.).

JetTime features:

• Time tracking & timesheets with improved Log Work UI and timers
• Reports filtered by date range, user, or project
• Excel & PDF export for further analysis
• Cost tracking with custom financial fields
• Custom metrics (mileage, materials, activity types, etc.)
• Runs fully on Atlassian infrastructure, so data stays inside Atlassian Cloud

👉 JetTime on the Atlassian Marketplace
— Anton, JetTime founder

[Zhenya Elfimova _Actonic_]

Dear @Laura Fallon ,

Unfortunately, it is not possible to build monthly timesheet out of the box, and usually teams look for some 3rd party tools to build this kind of time report.

As a product owner of Timesheet Builder app I would recommend to check out Worklog analysis view available in this add-on. On this view you can build a timesheet grouping by any standard and custom field you have in Jira. All worklogs will be displayed according to this selection.

In your case I imagine that following grouping options may work:

- Issue and Worklog author

- Worklog author and Issue

- Worklog author

As a result, you will receive a time table showing all bookings made in the selected month.

If you would like to see how it works, please check out this YouTube video.

Also, this timesheet can be built for any time period. All you need is to select start and end date :)

Kind regards,

Zhenya

Actonic Products

[Bartek Szajkowski _ Orbiscend OU]

Hello @Laura Fallon

Welcome in Community and sorry for my late answer :)
I'm Bartek from Orbiscend OU

If you are open for a third-party app, I would like to recommend ARGON, which is powerful JQL Search tool - ARGON Powerful JQL Search 

ARGON worklog function allows you to search for issues that have worklogs matching specific criteria, such as author, time period, or time spent.

In your case, ex.

issue in worklog("project = YOUR_PROJECT", "Tom", "2025/01/01", "2025/01/31")

This will return all issues where Tom logged time specifically during January — so that work item would show up with his January hours only, not the December ones.  

I hope you find my suggestions helpful

Greetings

Bartek from Orbiscend OU