{"id":23507,"date":"2025-06-25T11:48:32","date_gmt":"2025-06-25T11:48:32","guid":{"rendered":"https:\/\/clockify.me\/help\/?p=23507"},"modified":"2026-04-24T06:29:38","modified_gmt":"2026-04-24T06:29:38","slug":"time-mismatch","status":"publish","type":"post","link":"https:\/\/clockify.me\/help\/troubleshooting\/permissions\/time-mismatch","title":{"rendered":"Time and amounts mismatch in reports"},"content":{"rendered":"\n<p>If you\u2019re noticing a mismatch in your reports, here are a few common reasons why that happens:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Compact mode is enabled<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>In Compact Mode, each time entry is automatically rounded to the nearest full minute for display purposes only<\/li>\n\n\n\n<li>This does not affect the actual tracked time; the system always stores time in the full format<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">How to display the exact time format<\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click the three dots next to your workspace name<\/li>\n\n\n\n<li class=\"translation-block\">Click <strong>Workspace settings<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Under the <strong>Duration Format <\/strong>drop-down, select <strong>Full<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh7-rt.googleusercontent.com\/docsz\/AD_4nXcQlnfhpNHlSkVZDMr8EN8QFAbFtUTxcMX6pZZubZJac8wvhX-nMm95PYHTg9cN_5JJgIapYPh4VQVodXhA3LSQIL-ZSVBHElX6EZIunrrUn1TKvWWMR8-EO8uDO-8rKbRJkkig1Q?key=XZmssafXgdhlV2XB9mRUkEGN\" alt=\"\"\/><\/figure>\n\n\n\n<p>Once you switch to the full format, your reports will show the most accurate data without rounding.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Rate hierarchy affects calculations<\/h2>\n\n\n\n<p>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<p class=\"translation-block\"><strong>Project\u2019s member rate &gt; Task rate &gt; Project rate &gt; Member rate &gt; Workspace rate<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How to check which rates are applied&nbsp;<\/h3>\n\n\n\n<p>To identify where a rate is coming from, you can check each level in the rate hierarchy:<\/p>\n\n\n\n<p><strong>Project Member Rate<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Go to the <strong>Projects<\/strong> page and open the relevant project<\/li>\n\n\n\n<li class=\"translation-block\">Navigate to the <strong>Access<\/strong> tab inside the project<\/li>\n\n\n\n<li class=\"translation-block\">Check the <strong>Billable rate<\/strong> column for each team member<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-1024x533.png\" alt=\"\" class=\"wp-image-23509\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-1024x533.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-300x156.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-768x400.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-1536x800.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-2048x1066.png 2048w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-member-rate-18x9.png 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Task Rate<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">While still inside the project, navigate to the <strong>Tasks<\/strong> tab<\/li>\n\n\n\n<li class=\"translation-block\">Check the <strong>Hourly rate <\/strong>column for each task<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"535\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-1024x535.png\" alt=\"\" class=\"wp-image-23510\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-1024x535.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-300x157.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-768x401.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-1536x802.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-2048x1070.png 2048w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/task-rate-18x9.png 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Project Rate<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">While still inside the project, navigate to the <strong>Settings<\/strong> tab<\/li>\n\n\n\n<li class=\"translation-block\">Scroll down and check the <strong>Project billable rate<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"543\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-1024x543.png\" alt=\"\" class=\"wp-image-23511\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-1024x543.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-300x159.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-768x407.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-1536x814.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-2048x1086.png 2048w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/project-rate-18x10.png 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Team Member Rate<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"translation-block\">Go to the <strong>Team<\/strong> page located on the sidebar<\/li>\n\n\n\n<li class=\"translation-block\">Check the <strong>Billable rate<\/strong> column for each team member<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"536\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-1024x536.png\" alt=\"\" class=\"wp-image-23512\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-1024x536.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-300x157.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-768x402.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-1536x805.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-2048x1073.png 2048w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/team-rate-18x9.png 18w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><strong>Workspace Rate<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on the three dots next to the workspace name<\/li>\n\n\n\n<li class=\"translation-block\">Click <strong>Workspace Settings<\/strong><\/li>\n\n\n\n<li class=\"translation-block\">Scroll down and check the <strong>Workspace billable rate<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"929\" src=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-1024x929.png\" alt=\"\" class=\"wp-image-23513\" srcset=\"https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-1024x929.png 1024w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-300x272.png 300w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-768x697.png 768w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-1536x1394.png 1536w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate-13x12.png 13w, https:\/\/clockify.me\/help\/wp-content\/uploads\/2025\/06\/ws-rate.png 1706w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div class=\"wp-block-custom-highlight-box custom-box color-green\"><div class=\"box-header\"><svg width=\"20\" height=\"20\" viewBox=\"0 0 24 24\" fill=\"none\"><mask id=\"mask-green\" style=\"mask-type:alpha\" maskUnits=\"userSpaceOnUse\" x=\"0\" y=\"0\" width=\"24\" height=\"24\"><rect width=\"24\" height=\"24\" fill=\"#D9D9D9\"><\/rect><\/mask><g mask=\"url(#mask-green)\"><path d=\"M5 21.0001C4.45 21.0001 3.97917 20.8043 3.5875 20.4126C3.19583 20.0209 3 19.5501 3 19.0001V5.0001C3 4.4501 3.19583 3.97926 3.5875 3.5876C3.97917 3.19593 4.45 3.0001 5 3.0001H13.925L11.925 5.0001H5V19.0001H19V12.0501L21 10.0501V19.0001C21 19.5501 20.8042 20.0209 20.4125 20.4126C20.0208 20.8043 19.55 21.0001 19 21.0001H5ZM9 15.0001V10.7501L18.175 1.5751C18.375 1.3751 18.6 1.2251 18.85 1.1251C19.1 1.0251 19.35 0.975098 19.6 0.975098C19.8667 0.975098 20.1208 1.0251 20.3625 1.1251C20.6042 1.2251 20.825 1.3751 21.025 1.5751L22.425 3.0001C22.6083 3.2001 22.75 3.42093 22.85 3.6626C22.95 3.90426 23 4.1501 23 4.4001C23 4.6501 22.9542 4.89593 22.8625 5.1376C22.7708 5.37926 22.625 5.6001 22.425 5.8001L13.25 15.0001H9ZM11 13.0001H12.4L18.2 7.2001L17.5 6.5001L16.775 5.8001L11 11.5751V13.0001Z\" fill=\"#4CAF50\"><\/path><\/g><\/svg><span class=\"box-label\">Note<\/span><\/div><div class=\"box-content\">\n<p class=\"translation-block\">You can edit the rates by clicking the <strong>Change<\/strong> button next to each hourly rate. On a paid plan, you have an option to apply the rate retroactively by selecting the <strong>Apply to all future and past time entries<\/strong>.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Discrepancy in Excel report<\/h2>\n\n\n\n<p>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<ul class=\"wp-block-list\">\n<li>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.&nbsp;<\/li>\n\n\n\n<li>When exporting to Excel, the data is sent with only 2 decimal places for display and compatibility reasons<\/li>\n\n\n\n<li>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<p><strong>Example:&nbsp;<\/strong><\/p>\n\n\n\n<p>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.&nbsp;<\/p>\n\n\n\n<p><strong>For the most accurate values:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Rely on the web report or PDF export, which reflects the true calculation using full decimal precision.&nbsp;<\/li>\n\n\n\n<li>Use Excel exports primarily for raw data or basic overviews<\/li>\n<\/ul>\n\n\n\n<p>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<ol class=\"wp-block-list\">\n<li>A screenshot of the discrepancy in question<\/li>\n\n\n\n<li>A CSV copy of the report for the relevant date range<\/li>\n\n\n\n<li>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&#8230;","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":23,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23507\/revisions"}],"predecessor-version":[{"id":31153,"href":"https:\/\/clockify.me\/help\/wp-json\/wp\/v2\/posts\/23507\/revisions\/31153"}],"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}]}}