- \n
- In Compact Mode, each time entry is automatically rounded to the nearest full minute for display purposes only<\/li>\n\n\n\n
- This does not affect the actual tracked time; the system always stores time in the full format<\/li>\n<\/ul>\n\n\n\n
- \n
- To view the exact time format:<\/li>\n<\/ul>\n\n\n\n
- \n
- Navigate to the workspace settings by clicking on the three dots next to your workspace name<\/li>\n\n\n\n
- Under the \u201cDuration Format\u201d drop-down, select \u201cFull\u201d<\/li>\n<\/ol>\n\n\n\n
<\/figure>\n\n\n\n
Once you switch to the full format, your reports will show you the most accurate data without rounding. <\/p>\n\n\n\n
Rate hierarchy affects calculations<\/h2>\n\n\n\n
Billing amounts may differ depending on how rates are applied. In Clockify, a more specific rate overrides a less specific one in this order:<\/p>\n\n\n\n
Project\u2019s member rate > Task rate > Project rate > Member rate > Workspace rate<\/strong><\/p>\n\n\n\n
- \n
- How to check which rates are applied <\/li>\n<\/ul>\n\n\n\n
To identify where a rate is coming from, you can check each level in the rate hierarchy:<\/p>\n\n\n\n
Project Member Rate<\/strong><\/p>\n\n\n\n
- \n
- <\/li>\n<\/ol>\n\n\n\n
- \n
- Go to the Projects page and open the relevant project<\/li>\n\n\n\n
- Navigate to the Team tab inside the project<\/li>\n\n\n\n
- Check the rate column for each team member<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-1024x533.png\")
<\/figure>\n\n\n\nTask Rate<\/strong><\/p>\n\n\n\n
- \n
- <\/li>\n<\/ol>\n\n\n\n
- \n
- While still inside the project, navigate to the Tasks tab<\/li>\n\n\n\n
- Check the rate column for each task<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-1024x535.png\")
<\/figure>\n\n\n\nProject Rate<\/strong><\/p>\n\n\n\n
- \n
- <\/li>\n<\/ol>\n\n\n\n
- \n
- Navigate to the Settings tab inside a project <\/li>\n\n\n\n
- Scroll a bit down and check the rate<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-1024x543.png\")
<\/figure>\n\n\n\nTeam Member Rate<\/strong><\/p>\n\n\n\n
- \n
- <\/li>\n<\/ol>\n\n\n\n
- \n
- Navigate to the Team tab located on the sidebar<\/li>\n\n\n\n
- Check the rate for each team member under the rate column <\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-1024x536.png\")
<\/figure>\n\n\n\nWorkspace Rate<\/strong><\/p>\n\n\n\n
- \n
- <\/li>\n<\/ol>\n\n\n\n
- \n
- Click on the three dots next to the workspace name<\/li>\n\n\n\n
- Click on the \u2018Workspace Settings\u2019 option<\/li>\n\n\n\n
- Scroll down and check the workspace rate<\/li>\n<\/ul>\n\n\n\n
![\"\"](\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-1024x929.png\")
<\/figure>\n\n\n\nYou can edit the rates by selecting the \u2018Change\u2019 button located next to each hourly rate. If you are on a paid plan, you\u2019ll have an option to apply the rate retroactively by selecting the \u2018Apply to all future and past time entries\u2019 option. <\/p>\n\n\n\n
Discrepancy in Excel report<\/h2>\n\n\n\n
If you\u2019re seeing small differences in totals when exporting reports to Excel, this is due to how decimals are handled:<\/p>\n\n\n\n
- \n
- The web app and PDF exports calculate the amounts using 4 decimal places, which ensures precise totals, especially when time is multiplied by hourly rates. <\/li>\n\n\n\n
- When exporting to Excel, the data is sent with only 2 decimal places for display and compatibility reasons<\/li>\n\n\n\n
- If you use Excel\u2019s SUM formula, the totals may be slightly off due to rounding at the line-item level<\/li>\n<\/ul>\n\n\n\n
Example: <\/strong><\/p>\n\n\n\n
A time entry amount of $33.3368 might appear as $33.34 in Excel. When summed across multiple entries, those small differences can add up. <\/p>\n\n\n\n
For the most accurate values:<\/strong><\/p>\n\n\n\n
- \n
- Rely on the web report or PDF export, which reflects the true calculation using full decimal precision. <\/li>\n\n\n\n
- Use Excel exports primarily for raw data or basic overviews<\/li>\n<\/ul>\n\n\n\n
Still having issues? The Clockify Support Team will be happy to look into it and assist you further. Please contact us at support@clockify.me and include the following details:<\/p>\n\n\n\n
- \n
- A screenshot of the discrepancy in question<\/li>\n\n\n\n
- A CSV copy of the report for the relevant date range<\/li>\n\n\n\n
- Billable rate information<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"If you\u2019re noticing a mismatch in your reports, here are a few common reasons w…","protected":false},"author":41,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_helpful_status":1,"_searchwp_excluded":"","footnotes":""},"categories":[46],"tags":[],"class_list":["post-23507","post","type-post","status-publish","format-standard","hentry","category-permissions"],"acf":[],"featured_image_src":null,"author_info":{"display_name":"Milena Dimic Vlajic","author_link":"https:\/\/clockify.me\/help\/author\/millenaclockify-me"},"_links":{"self":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/users\/41"}],"replies":[{"embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/comments?post=23507"}],"version-history":[{"count":5,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23507\/revisions"}],"predecessor-version":[{"id":28532,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23507\/revisions\/28532"}],"wp:attachment":[{"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/media?parent=23507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/categories?post=23507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/tags?post=23507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- <\/li>\n<\/ol>\n\n\n\n
- <\/li>\n<\/ol>\n\n\n\n
- <\/li>\n<\/ol>\n\n\n\n
- <\/li>\n<\/ol>\n\n\n\n
- <\/li>\n<\/ol>\n\n\n\n
- How to check which rates are applied <\/li>\n<\/ul>\n\n\n\n
- To view the exact time format:<\/li>\n<\/ul>\n\n\n\n