Timesheets Reports: An In-Depth Guide

Timesheets reports let you review, filter, and export the time you've logged against projects for invoicing, time management, or recordkeeping.

This article covers the View & Export page, the Calendar view, and how rounding affects your totals.

View & Export

Before you run a report

Reports in Timesheets only include time you've assigned to a project on your timeline, either manually or by accepting an autocompletion suggestion. Raw activity from the timeline does not appear.

If your report looks empty or incomplete, the most likely cause is a lack of project time on your timeline. Go to Timesheets → My Timeline, and make sure you've logged time to projects before running the report again.

Go to Timesheets → Personal Reports → View & Export to generate a report.

Choose a date range

Use the date picker in the top right to set the time period for your report. You can choose from presets or set a custom range:

  • Day / Week / Month: Jumps to a standard period; use the arrows to move forward or back
  • Recent: Shows the most recent activity
  • Custom: Click the first day of your range, then the last day, to define any period you need

Days on the calendar with a green corner marker are finalized days.

Date picker showing Custom, Week, Month, and Recent tabs, a May 2026 calendar with May 20 selected as start date and June 1 as end date highlighted in blue, and a green Finalized legend at the bottom right

Filter by client, project, or task

Use the Filter by dropdowns to narrow your report to specific clients, projects, or tasks. All three filters support multi-select. You can include as many or as few as you need in a single report.

  • Use Select All or Deselect All at the top of each dropdown to quickly adjust the selection
  • Use the search bar inside each dropdown to find a specific name quickly
  • The badge on each filter button shows how many items are currently selected
Tasks filter dropdown open showing a search field, Select All and Deselect All options, and a scrollable list of tasks including Billing, Blog, Content Creation, Copywriting, CS Monthly Report, Design, Email Marketing, Helpdocs, Marketing, and Meeting with unchecked checkboxes

💡 Filters are additive. Selecting multiple projects shows time for all of them combined. If you need a report for a single client, filter by that client alone and leave projects and tasks set to all. The report will include only work associated with that client.

Interval and group

These two controls determine how the rows in your report are structured.

Interval

Sets the time period each row represents:

  • Total Time: Collapses everything into a single row per group, showing the overall total across your date range
  • Day: One row per day per group, useful for seeing how time was distributed across the week
  • Week: One row per week per group
  • Month: One row per month per group
  • Minute (all): Every individual time block as its own row, exactly as it was entered; the most detailed view and useful for auditing specific entries
Interval dropdown open showing options for Day, Week, Month, and Minute (all), with a tooltip explaining that Minute shows every block of time as entered and that combining Group by Project and Minute shows projects broken out by tasks

Group

Controls how rows are organized within each interval:

  • Project: One row per project; the most common setting for a summary view
  • Client: Rolls up all project time under each client; useful for invoicing
  • Task: Breaks time down by task type across all projects

💡 Combine Interval and Group for the view you need. For example: Interval = Day + Group = Project gives you a per-project breakdown for each day. Interval = Minute (all) + Group = Project gives you every individual entry, organized by project, ideal for auditing or sending detailed time logs to a client.

Billable, Reviewed, and Finalized options

The Only checkboxes on the right let you further restrict what's included in your report. These can be used individually or together.

Billable

Shows only time logged against projects marked as billable. Use this when preparing an invoice to exclude internal or non-billable work from the total.

Reviewed

Shows only time you've explicitly reviewed: accepted autocompletions and manually added blocks. When this is checked, any autocompletion suggestions that are still pending review are excluded from the report.

This is the recommended setting for any report you plan to share or invoice, since it ensures that only confirmed time is included. It's checked by default.

Finalized

Shows only time from days you've finalized (days where you clicked the lock icon on the timeline to mark them as complete). A finalized day means no further autocompletions will be added, and the timesheet is considered closed.

Use this filter when you want to report only on fully closed periods, rather than days that may still have time coming in.

💡 Reviewed vs. Finalized—what's the difference? Reviewed means you've confirmed individual time blocks. Finalized means you've locked the entire day. A day can have reviewed time without being finalized. For most reporting purposes, filtering by Reviewed is sufficient. Filter by Finalized when you need to be certain a day is fully closed out with no further changes possible.

The report table

With your filters and grouping set, the table updates to show your data. Each row includes:

  • Interval: The time period for that row (if using Day, Week, or Month interval)
  • Project: The project name with its color indicator
  • Client: The client the project belongs to, if one is set
  • Tasks: The task type(s) logged against that project in this period
  • Hours: Total logged hours for that row
  • Billable: How many of those hours are billable, shown as a number and percentage
  • Bill: The calculated amount based on your billing rate, if one is set

The Totals row at the bottom summarizes all rows currently shown.

View and Export report showing Filter by Clients, Projects, and Tasks dropdowns, Interval set to Total Time, Group set to Project, Rounding at 0.01 hrs, Only Reviewed checked, and a table with rows for Admin (1.58 hrs, $197.50), Blog (0.25 hrs, $0.00), and Customer Support (6.17 hrs, $0.00), with a Totals row showing 8 hours and $197.50

Export your report

When your filters and grouping are set the way you want, download your data using one of the three export buttons:

CSV

Exports your filtered, grouped data as a comma-separated values file. Works with Excel, Google Sheets, and most other spreadsheet or invoicing tools. This is the most flexible format.

Excel

Exports your filtered, grouped data directly as an .xlsx file, formatted and ready to open in Excel or Google Sheets.

Raw

Downloads all of your logged time for the selected date range with no filters or grouping applied. Every individual entry, exactly as recorded. Use this when you need a complete unmodified data dump, such as for a data audit or importing into an external system.

💡 Review before you export. Check the Totals row and spot-check a few rows before downloading. It's much easier to catch a missing project or incorrect date range now than after you've downloaded the file.


Calendar View

Using the calendar view

Go to Timesheets → Personal Reports → Calendars for a week-by-week visual of your logged project time. Where the View & Export report gives you numbers, the calendar gives you shape. You can see at a glance which days were busy, which projects dominated each day, and where gaps exist.

Each day column shows your logged time blocks in their project colors, positioned by time of day. The summary bar at the top shows your total logged hours for the week and a proportional breakdown by project. Hover over any block to see the project name, time range, and duration.

Calendar view showing Personal Reports Calendars for June 1 to June 7, with 15h 25m total at top, a project breakdown bar showing Customer Support, Admin, and Blog in their respective colors, and a week grid with project time blocks placed by time of day — Customer Support blocks visible on Monday through Wednesday mornings

Filtering the calendar

Use the Only checkboxes at the top to filter what's shown:

  • Reviewed: Show only confirmed autocompletions and manually added time
  • Finalized: Show only time from finalized days
  • Billable: Show only billable project time

Navigating weeks

Use the arrows in the top right to move forward and back through weeks. Use the + / − buttons in the top left of the grid to zoom the time axis in and out.

💡 Use the calendar to catch gaps before running a report. Days with no blocks are days with no logged project time. This might be correct (a day off) or might mean you forgot to review your timeline. Spotting these visually is faster than noticing a low total in a spreadsheet after the fact.


Understanding Rounding

How rounding works

If you notice small discrepancies between your time totals in different views, rounding is usually the cause. Rounding is applied at the row level and not to the overall total. Each row of your report is calculated in seconds, converted to decimal hours, and rounded according to your selected strategy. The total at the bottom is the sum of those rounded row values.

This means the same data can produce slightly different totals depending on your interval setting:

📅 Interval = Day

Rounding is applied to each daily row. Those rounded values are then added together, so small rounding differences can accumulate across many days.

🗓 Interval = Month

Rounding is applied once to the monthly total, which avoids accumulating those daily rounding extras. Totals will be slightly different than the sum of day interval rows.

💡 The default rounding is 0.01 hours (approximately 36 seconds per row). You can change this at any time under Timesheets → Preferences → Default rounding.

Available rounding options

There are two types of rounding strategy: precision-based (rounds to nearest) and time-based (always rounds up):

Precision-based: rounds to the nearest value

Option Precision Equivalent
0.1 hours Tenths of an hour 6 minutes
0.01 hours default Hundredths of an hour ~36 seconds
0.001 hours Thousandths of an hour ~3.6 seconds

Time-based: always rounds up to the next increment

Option Rounds up to Example
Hour Next whole hour 1.2 hrs → 2.0
15 minutes Next 0.25 increment 1.1 hrs → 1.25
6 minutes Next 0.1 increment 1.05 hrs → 1.1

Time-based rounding always rounds up, never down. If you have many short entries and use 15-minute rounding, each one rounds up to the next quarter-hour, which can add a meaningful amount of time to your total. Use precision-based rounding (0.01 or 0.1) if you want totals that more closely reflect actual logged time.

Rounding and billing

When a row contains time logged at multiple billing rates, the billed total is calculated as the sum of each rate's rounded time separately, not as a single rounded total. This means the Bill column can differ slightly from what you'd get if you rounded the raw total yourself.

For example, if a row has 45 minutes at $100/hr and 20 minutes at $75/hr, each portion is rounded independently before the bill amounts are added together. The difference is usually small, but it's worth being aware of if your invoices need to match to the cent.

Troubleshooting discrepancies

My daily totals don't match my monthly totals

This is expected behavior. When you use a day interval, rounding is applied to each daily row and those values are summed. When you switch to a month interval, rounding is applied once to the monthly total, which avoids accumulating the daily rounding extras and produces a slightly smaller number. Neither is wrong; they reflect different levels of rounding granularity.

My total time is higher than expected

This typically happens with time-based rounding (Hour, 15 minutes, or 6 minutes). Because these options always round up, many briefl time entries each get bumped to the next increment and the cumulative effect can be significant. Switch to a precision-based option like 0.01 hours to get totals that more closely reflect what was actually logged.

My billed total looks different from my raw time

This happens when a row includes time logged at multiple billing rates. Each rate's portion is rounded separately before the bill amounts are added. See Rounding and billing above for details.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us