nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Michał Kowalewski_SolDevelo

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.

Worklogs Date Range.png

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

1) Worklogs 3.png

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

All comments

Robert DaSilva_a432as

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 P 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

Worklogs & Timesheets.png

Michał Kowalewski_SolDevelo

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.

Worklogs Date Range.png

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

1) Worklogs 3.png

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

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

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

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

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.

Sahil Aggarwal_dqrd2k

Hi — that’s a really common need, and you’re thinking about it the right way.

What you want is a worklog-date report (hours actually logged in January), not a sprint/epic/issue-created report. In native Jira it’s hard to get a clean “all issues × time spent in this month” export you can drop into Excel. That’s exactly the gap timesheet apps fill.

With Timesheets by Rymo: Time tracker and Timesheet tracking you can do this in a few clicks:

Open Apps → Worklog Timesheets for Jira
Go to Reports
Set the date range to January (or use Last Month / This Month)
Set Group By → Issue (optionally also by Worklog Author if you want Tom’s hours broken out)
Optionally filter by Worklog Author if you only want one person
Click Export XLSX or Export CSV

You’ll get every issue that had time logged in that month, with only the hours logged in that period — so in your example, Tom’s 7 hours in January show up for that work item, and the December 4 hours stay in the December report.

From there you can open the file in Excel and sum however you like. You can also save the report so next month it’s one click away.

If helpful, docs are here: [Links removed]

Happy to answer any follow-ups on filters / grouping!

Evie Z.

@Sahil Aggarwal

This topic is now closed as the discussion has become outdated. If you have more questions or want to continue the conversation, feel free to start a new topic. For more details on why we close older threads, check out our Rules of engagement - Atlassian Community. We’ve also removed the external links from your post, per our Community Rules of Engagement.

Additionally we noticed that this account represents a company app/solution, and we wanted to check in with you to ensure that you’re aware of our Atlassian Partners - Rules of Engagement and that you’ve read through our Partner Processes and Best Practices page.

Following the requirements on that page, we require you to organize the Atlassian Partner lozenge to display in your profile. This lozenge makes it clear what app/solution you represent and allows identified accounts to author articles in the community.

Please review the process to apply for the partner lozenge here.

Thank you for your understanding!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

worklog

timesheet