Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.
Payroll needs one thing: hours per person for a fixed period, in a file.Build that report once, save it, and schedule it. After the first time it takes about two minutes a month.
The example: Northwind Studio exports March. Daniel Okafor (Finance) builds and sends the file.
Before you start
Plan requirement. Exporting a report is Pro. Reports themselves are available on every plan – what Pro adds is depth: custom reports, scheduling and taking the file out of the product. See Free vs Pro.
You need report.view to read a report, report.create to build one, and report.export to download it. Finance, Project Manager, Admin and Owner have export. Contractors cannot build or export reports at all.→ Report permissions · Roles and permissions matrix
Get the hours right before you export
An export is only as good as the hours underneath it. Do these two first.
Closing locks the month so the numbers cannot move after payroll has been run against them. This is the whole reason the feature exists.→ Close a period
Build the report
1
Start a new report on the time entry source
The source decides what the report is about. For payroll you want time entries – one row per recorded hour, which you then group.→ Build a report · Report sources
There is also a timesheets source, which reports on whole submitted weeks rather than individual entries. Use it if your payroll works off approved weeks rather than daily hours.
2
Set the date range to the payroll period
March 1 to March 31. Use a relative range like “last month” if you plan to schedule the report, so it moves with the calendar instead of staying stuck on March.→ Date ranges and periods
This is the shape payroll wants – one row per person, with their total hours.If your provider needs a daily or weekly breakdown, group by person and then by date. The report engine builds the tree; you choose the levels.→ Grouping and pivots
5
Add the columns payroll asks for
Keep it to what they need. A payroll file with thirty columns gets rejected.
Column
Include when
Person
Always
Total hours
Always
Billable hours
You pay differently for billable work
Non-billable hours
Same
Project or client
Your provider splits cost by client
Billable value
Almost never – this is revenue, not pay
Cost
Only if payroll works from your internal cost rate
Cost is sensitive. Seeing it needs time.viewCost or rate.viewCost, which Members and Contractors do not have. Only include it if the person receiving the file is meant to see what people cost.
6
Check the totals against something you already know
Before you send it anywhere, sanity-check the number.March at Northwind:
Person
Hours
Sarah Lin
152
Jonas Bergman
160
Ana Ferreira
44
Total
356
Jonas is on a 40 hour week. The period covered 20 working days, so 160 hours is exactly right. Sarah is 8 hours short of that, which matches one day of leave. Ana is part time, and 44 hours fits her pattern.If a number looks wrong here, it is wrong. Fix it before it becomes someone’s pay.
7
Save the report
Save it as Payroll – monthly hours. Now it is one click every month, and it always has the same shape.→ Saved reports
8
Export it
Three formats:
Format
Use it for
CSV
Uploading into a payroll system. The most common choice.
Excel
A person will open it and work in it.
PDF
A record to file, or something to sign off.
A small report downloads immediately. A large one is built in the background and you are told when it is ready.→ Export a report · Export formats
9
Schedule it so you stop remembering
Have the saved report emailed to Daniel on the first working day of every month, covering last month.→ Schedule a report · Share a report
Contractors are paid differently
Ana is a contractor, and she invoices you rather than being on payroll.Run a separate report filtered to contractors, and work from their cost rate, which is what you actually pay them.
Person
Hours
Cost rate
You pay
Ana Ferreira
44
$55
$2,420
That is a payables number, not a payroll number, and it usually goes to a different person.→ Manage contractors · Cost rates
No. Exports are Pro. You can build and read reports on screen for free, but taking the file out of the product needs a paid workspace. See Free vs Pro.
Should I export tracked time or clock in and out records?
It depends what you pay for. Tracked time is hours against work. Time Clock records presence at work. If you pay for attendance, use timecards. If you pay for project hours, use time entries. See Timecards.
The totals do not match the invoices. Why?
Payroll counts every hour. An invoice counts only billable hours. The difference is your non-billable time, and it should be. See Billable vs non-billable.
Someone's hours are missing from the export.
Almost always the filter. Check whether the report is filtered to approved time and the person’s week was never approved. See Report problems.
Can I stop payroll seeing what people cost?
Yes – leave the cost column out of the report. Cost visibility is also controlled by capability, so a person without time.viewCost cannot see it whatever the report contains. See Rate permissions.
The export is taking a long time.
Large reports build in the background and you are notified when the file is ready. Narrow the date range or the filters if you need it faster. See Export a report.
Related guides
Month-end close
Do this before you export anything.
Weekly timesheet routine
Clean weekly hours make a clean export.
Manage contractors
Paying freelancers is a separate run.
Offboard an employee
Their final hours for the last run.
Monitor project profitability
The other report worth scheduling.
{"docsConfig":{"theme":"mint","$schema":"https://mintlify.com/docs.json","name":"TimeTracker","description":"Documentation for TimeTracker — time tracking, project management, timesheets, budgets and invoicing for service businesses.","colors":{"primary":"#14a800","light":"#6fda44","dark":"#108a00"},"logo":{"light":"https://mintcdn.com/lemaistrelabtechnologiesllp/H9Sna8wVBfkk0gAi/images/logo-light.svg?fit=max\u0026auto=format\u0026n=H9Sna8wVBfkk0gAi\u0026q=85\u0026s=8a120388c75952f2e86544c917e8bd82","dark":"https://mintcdn.com/lemaistrelabtechnologiesllp/H9Sna8wVBfkk0gAi/images/logo-dark.svg?fit=max\u0026auto=format\u0026n=H9Sna8wVBfkk0gAi\u0026q=85\u0026s=d37d44fd2f4e5d924de5a35f6730d893","href":"https://timetracker.in"},"favicon":"https://mintcdn.com/lemaistrelabtechnologiesllp/H9Sna8wVBfkk0gAi/favicon.png?fit=max\u0026auto=format\u0026n=H9Sna8wVBfkk0gAi\u0026q=85\u0026s=89d91a23b2c84faee6cc1e3dcc90cb9a","appearance":{"default":"system"},"background":{"color":{"light":"#ffffff","dark":"#0c0e12"}},"navbar":{"links":[{"href":"https://timetracker.in/pricing","label":"Pricing"},{"href":"mailto:[email protected]","label":"Support"}],"primary":{"type":"button","label":"Open TimeTracker","href":"https://app.timetracker.in"}},"footer":{"socials":{"website":"https://timetracker.in","x":"https://x.com/timetracker_in"},"links":[{"header":"Product","items":[{"label":"Time tracking","href":"/time-tracking/overview"},{"label":"Timesheets","href":"/timesheets/overview"},{"label":"Invoicing","href":"/invoicing/overview"},{"label":"Reports","href":"/reports/overview"}]},{"header":"Resources","items":[{"label":"Quickstart","href":"/getting-started/quickstart"},{"label":"Guides","href":"/guides/overview"},{"label":"Glossary","href":"/concepts/glossary"},{"label":"FAQ","href":"/reference/faq"}]}]},"search":{"prompt":"Search the TimeTracker docs"},"seo":{"indexing":"all"},"fonts":{"heading":{"family":"Instrument Sans"},"body":{"family":"Inter"}},"styling":{"latex":true},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"lemaistrelabtechnologiesllp","hasAudioNarration":false,"actualSubdomain":"lemaistrelabtechnologiesllp","customDomains":["docs.timetracker.in"],"gitSource":{"type":"github","owner":"timetracker-developer","repo":"timetracker-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6ae93ea603a81e5375b3f1f7:success","clientVersion":"0.0.4248","searchFilterCounts":[{"language":"default","tag":"Documentation","count":264},{"language":"default","tag":"Reference","count":32},{"language":"default","tag":"Workspace settings","count":20},{"language":"default","tag":"Tasks","count":19},{"language":"default","tag":"Guides","count":17},{"language":"default","tag":"Projects","count":15},{"language":"default","tag":"Invoicing","count":14},{"language":"default","tag":"Reports","count":14},{"language":"default","tag":"Core concepts","count":13},{"language":"default","tag":"Time tracking","count":13}]},"assistantConfig":{},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"site-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"starter-pricing","enabled":true,"variant":{"name":"control","enabled":true,"payload":{"type":"string","value":"control"},"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"wildcard-email-auth","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":true},"customCss":[]}
{"page":{"pagePath":"guides/export-hours-for-payroll","slug":"/guides/export-hours-for-payroll","pageMetadata":{"title":"Export hours for payroll","description":"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.","href":"/guides/export-hours-for-payroll"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,p:`p`,strong:`strong`,tbody:`tbody`,td:`td`,th:`th`,thead:`thead`,tr:`tr`,..._provideComponents(),...props.components},{Accordion,AccordionGroup,Card,CardGroup,Heading,Info,Step,Steps,Table,Tip,Warning}=_components;if(!Accordion)_missingMdxReference(`Accordion`,true);if(!AccordionGroup)_missingMdxReference(`AccordionGroup`,true);if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Info)_missingMdxReference(`Info`,true);if(!Step)_missingMdxReference(`Step`,true);if(!Steps)_missingMdxReference(`Steps`,true);if(!Table)_missingMdxReference(`Table`,true);if(!Tip)_missingMdxReference(`Tip`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(_components.p,{children:`Payroll needs one thing: hours per person for a fixed period, in a file.`}),`\n`,_jsx(_components.p,{children:`Build that report once, save it, and schedule it. After the first time it takes about two minutes a month.`}),`\n`,_jsx(Info,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`The example:`}),` Northwind Studio exports March. Daniel Okafor (Finance) builds and sends the file.`]})}),`\n`,_jsx(Heading,{level:`2`,id:`before-you-start`,children:`Before you start`}),`\n`,_jsx(Warning,{children:_jsxs(_components.p,{children:[_jsx(_components.strong,{children:`Plan requirement.`}),` Exporting a report is `,_jsx(_components.strong,{children:`Pro`}),`. Reports themselves are available on every plan – what Pro adds is depth: custom reports, scheduling and taking the file out of the product. See `,_jsx(_components.a,{href:`/billing/free-vs-pro`,children:`Free vs Pro`}),`.`]})}),`\n`,_jsxs(_components.p,{children:[`You need `,_jsx(_components.code,{children:`report.view`}),` to read a report, `,_jsx(_components.code,{children:`report.create`}),` to build one, and `,_jsx(_components.code,{children:`report.export`}),` to download it. Finance, Project Manager, Admin and Owner have export. `,_jsx(_components.strong,{children:`Contractors cannot build or export reports at all.`})]}),`\n`,_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/report-permissions`,children:`Report permissions`}),` · `,_jsx(_components.a,{href:`/reference/roles-and-permissions-matrix`,children:`Roles and permissions matrix`})]}),`\n`,_jsx(Heading,{level:`2`,id:`get-the-hours-right-before-you-export`,children:`Get the hours right before you export`}),`\n`,_jsx(_components.p,{children:`An export is only as good as the hours underneath it. Do these two first.`}),`\n`,_jsxs(Steps,{children:[_jsxs(Step,{title:`Every week is submitted and approved`,children:[_jsx(_components.p,{children:`Unapproved time is unreviewed time. Do not pay against it.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/guides/weekly-timesheet-routine`,children:`Weekly timesheet routine`}),` · `,_jsx(_components.a,{href:`/approvals/approve-a-timesheet`,children:`Approve a timesheet`})]})]}),_jsxs(Step,{title:`The period is closed`,children:[_jsx(_components.p,{children:`Closing locks the month so the numbers cannot move after payroll has been run against them. This is the whole reason the feature exists.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/approvals/close-a-period`,children:`Close a period`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`build-the-report`,children:`Build the report`}),`\n`,_jsxs(Steps,{children:[_jsxs(Step,{title:`Start a new report on the time entry source`,children:[_jsx(_components.p,{children:`The source decides what the report is about. For payroll you want time entries – one row per recorded hour, which you then group.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/build-a-report`,children:`Build a report`}),` · `,_jsx(_components.a,{href:`/reports/report-sources`,children:`Report sources`})]}),_jsx(Tip,{children:_jsx(_components.p,{children:`There is also a timesheets source, which reports on whole submitted weeks rather than individual entries. Use it if your payroll works off approved weeks rather than daily hours.`})})]}),_jsxs(Step,{title:`Set the date range to the payroll period`,children:[_jsx(_components.p,{children:`March 1 to March 31. Use a relative range like “last month” if you plan to schedule the report, so it moves with the calendar instead of staying stuck on March.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/date-ranges-and-periods`,children:`Date ranges and periods`})]})]}),_jsxs(Step,{title:`Filter to what payroll should see`,children:[_jsx(_components.p,{children:`Common filters:`}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Filter`}),_jsx(_components.th,{children:`Why`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Status is approved`}),_jsx(_components.td,{children:`Do not pay against unreviewed hours`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Group is Engineering, Design…`}),_jsx(_components.td,{children:`If different groups go to different payroll runs`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Person`}),_jsx(_components.td,{children:`If contractors are paid on a separate run`})]})]})]}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/report-filters`,children:`Report filters`})]})]}),_jsxs(Step,{title:`Group by person`,children:[_jsx(_components.p,{children:`This is the shape payroll wants – one row per person, with their total hours.`}),_jsx(_components.p,{children:`If your provider needs a daily or weekly breakdown, group by person and then by date. The report engine builds the tree; you choose the levels.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/grouping-and-pivots`,children:`Grouping and pivots`})]})]}),_jsxs(Step,{title:`Add the columns payroll asks for`,children:[_jsx(_components.p,{children:`Keep it to what they need. A payroll file with thirty columns gets rejected.`}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Column`}),_jsx(_components.th,{children:`Include when`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Person`}),_jsx(_components.td,{children:`Always`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Total hours`}),_jsx(_components.td,{children:`Always`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Billable hours`}),_jsx(_components.td,{children:`You pay differently for billable work`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Non-billable hours`}),_jsx(_components.td,{children:`Same`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Project or client`}),_jsx(_components.td,{children:`Your provider splits cost by client`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Billable value`}),_jsx(_components.td,{children:`Almost never – this is revenue, not pay`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Cost`}),_jsx(_components.td,{children:`Only if payroll works from your internal cost rate`})]})]})]}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/metrics-reference`,children:`Metrics reference`}),` · `,_jsx(_components.a,{href:`/reference/report-metrics`,children:`Report metrics`})]}),_jsx(Warning,{children:_jsxs(_components.p,{children:[`Cost is sensitive. Seeing it needs `,_jsx(_components.code,{children:`time.viewCost`}),` or `,_jsx(_components.code,{children:`rate.viewCost`}),`, which Members and Contractors do not have. Only include it if the person receiving the file is meant to see what people cost.`]})})]}),_jsxs(Step,{title:`Check the totals against something you already know`,children:[_jsx(_components.p,{children:`Before you send it anywhere, sanity-check the number.`}),_jsx(_components.p,{children:`March at Northwind:`}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Person`}),_jsx(_components.th,{children:`Hours`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Sarah Lin`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`152`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Jonas Bergman`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`160`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ana Ferreira`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`44`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Total`})}),_jsx(_components.td,{\"data-numeric\":`true`,children:_jsx(_components.strong,{children:`356`})})]})]})]}),_jsx(_components.p,{children:`Jonas is on a 40 hour week. The period covered 20 working days, so 160 hours is exactly right. Sarah is 8 hours short of that, which matches one day of leave. Ana is part time, and 44 hours fits her pattern.`}),_jsx(_components.p,{children:`If a number looks wrong here, it is wrong. Fix it before it becomes someone’s pay.`})]}),_jsxs(Step,{title:`Save the report`,children:[_jsxs(_components.p,{children:[`Save it as `,_jsx(_components.strong,{children:`Payroll – monthly hours`}),`. Now it is one click every month, and it always has the same shape.`]}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/saved-reports`,children:`Saved reports`})]})]}),_jsxs(Step,{title:`Export it`,children:[_jsx(_components.p,{children:`Three formats:`}),_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Format`}),_jsx(_components.th,{children:`Use it for`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`CSV`})}),_jsx(_components.td,{children:`Uploading into a payroll system. The most common choice.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`Excel`})}),_jsx(_components.td,{children:`A person will open it and work in it.`})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:_jsx(_components.strong,{children:`PDF`})}),_jsx(_components.td,{children:`A record to file, or something to sign off.`})]})]})]}),_jsx(_components.p,{children:`A small report downloads immediately. A large one is built in the background and you are told when it is ready.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/export-a-report`,children:`Export a report`}),` · `,_jsx(_components.a,{href:`/reference/export-formats`,children:`Export formats`})]})]}),_jsxs(Step,{title:`Schedule it so you stop remembering`,children:[_jsx(_components.p,{children:`Have the saved report emailed to Daniel on the first working day of every month, covering last month.`}),_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/reports/schedule-a-report`,children:`Schedule a report`}),` · `,_jsx(_components.a,{href:`/reports/share-a-report`,children:`Share a report`})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`contractors-are-paid-differently`,children:`Contractors are paid differently`}),`\n`,_jsx(_components.p,{children:`Ana is a contractor, and she invoices you rather than being on payroll.`}),`\n`,_jsxs(_components.p,{children:[`Run a separate report filtered to contractors, and work from their `,_jsx(_components.strong,{children:`cost`}),` rate, which is what you actually pay them.`]}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`Person`}),_jsx(_components.th,{children:`Hours`}),_jsx(_components.th,{children:`Cost rate`}),_jsx(_components.th,{children:`You pay`})]})}),_jsx(_components.tbody,{children:_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Ana Ferreira`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`44`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`$55`}),_jsx(_components.td,{\"data-numeric\":`true`,children:`$2,420`})]})})]}),`\n`,_jsx(_components.p,{children:`That is a payables number, not a payroll number, and it usually goes to a different person.`}),`\n`,_jsxs(_components.p,{children:[`→ `,_jsx(_components.a,{href:`/guides/manage-contractors`,children:`Manage contractors`}),` · `,_jsx(_components.a,{href:`/rates/cost-rates`,children:`Cost rates`})]}),`\n`,_jsx(Heading,{level:`2`,id:`other-exports-you-may-need`,children:`Other exports you may need`}),`\n`,_jsxs(Table,{children:[_jsx(_components.thead,{children:_jsxs(_components.tr,{children:[_jsx(_components.th,{children:`You need`}),_jsx(_components.th,{children:`Use`})]})}),_jsxs(_components.tbody,{children:[_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`One person’s week as a file`}),_jsx(_components.td,{children:_jsx(_components.a,{href:`/timesheets/export-a-timesheet`,children:`Export a timesheet`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Leave taken and balances`}),_jsx(_components.td,{children:_jsx(_components.a,{href:`/time-off/export-leave`,children:`Export leave`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Clock in and out records`}),_jsx(_components.td,{children:_jsx(_components.a,{href:`/time-clock/timecards`,children:`Timecards`})})]}),_jsxs(_components.tr,{children:[_jsx(_components.td,{children:`Everything in the workspace`}),_jsx(_components.td,{children:_jsx(_components.a,{href:`/data/export-your-data`,children:`Export your data`})})]})]})]}),`\n`,_jsx(Heading,{level:`2`,id:`common-questions`,children:`Common questions`}),`\n`,_jsxs(AccordionGroup,{children:[_jsx(Accordion,{title:`Can I export on the Free plan?`,id:`can-i-export-on-the-free-plan`,children:_jsxs(_components.p,{children:[`No. Exports are Pro. You can build and read reports on screen for free, but taking the file out of the product needs a paid workspace. See `,_jsx(_components.a,{href:`/billing/free-vs-pro`,children:`Free vs Pro`}),`.`]})}),_jsx(Accordion,{title:`Should I export tracked time or clock in and out records?`,id:`should-i-export-tracked-time-or-clock-in-and-out-records`,children:_jsxs(_components.p,{children:[`It depends what you pay for. Tracked time is hours against work. Time Clock records presence at work. If you pay for attendance, use timecards. If you pay for project hours, use time entries. See `,_jsx(_components.a,{href:`/time-clock/timecards`,children:`Timecards`}),`.`]})}),_jsx(Accordion,{title:`The totals do not match the invoices. Why?`,id:`the-totals-do-not-match-the-invoices-why`,children:_jsxs(_components.p,{children:[`Payroll counts every hour. An invoice counts only billable hours. The difference is your non-billable time, and it should be. See `,_jsx(_components.a,{href:`/concepts/billable-vs-non-billable`,children:`Billable vs non-billable`}),`.`]})}),_jsx(Accordion,{title:`Someone's hours are missing from the export.`,id:`someones-hours-are-missing-from-the-export`,children:_jsxs(_components.p,{children:[`Almost always the filter. Check whether the report is filtered to approved time and the person’s week was never approved. See `,_jsx(_components.a,{href:`/troubleshooting/report-problems`,children:`Report problems`}),`.`]})}),_jsx(Accordion,{title:`Can I stop payroll seeing what people cost?`,id:`can-i-stop-payroll-seeing-what-people-cost`,children:_jsxs(_components.p,{children:[`Yes – leave the cost column out of the report. Cost visibility is also controlled by capability, so a person without `,_jsx(_components.code,{children:`time.viewCost`}),` cannot see it whatever the report contains. See `,_jsx(_components.a,{href:`/rates/rate-permissions`,children:`Rate permissions`}),`.`]})}),_jsx(Accordion,{title:`The export is taking a long time.`,id:`the-export-is-taking-a-long-time`,children:_jsxs(_components.p,{children:[`Large reports build in the background and you are notified when the file is ready. Narrow the date range or the filters if you need it faster. See `,_jsx(_components.a,{href:`/reports/export-a-report`,children:`Export a report`}),`.`]})})]}),`\n`,_jsx(Heading,{level:`2`,id:`related-guides`,children:`Related guides`}),`\n`,_jsxs(CardGroup,{cols:2,children:[_jsx(Card,{title:`Month-end close`,icon:`calendar-days`,href:`/guides/month-end-close`,children:_jsx(_components.p,{children:`Do this before you export anything.`})}),_jsx(Card,{title:`Weekly timesheet routine`,icon:`calendar-check`,href:`/guides/weekly-timesheet-routine`,children:_jsx(_components.p,{children:`Clean weekly hours make a clean export.`})}),_jsx(Card,{title:`Manage contractors`,icon:`handshake`,href:`/guides/manage-contractors`,children:_jsx(_components.p,{children:`Paying freelancers is a separate run.`})}),_jsx(Card,{title:`Offboard an employee`,icon:`user-minus`,href:`/guides/offboard-an-employee`,children:_jsx(_components.p,{children:`Their final hours for the last run.`})}),_jsx(Card,{title:`Monitor project profitability`,icon:`chart-line`,href:`/guides/monitor-project-profitability`,children:_jsx(_components.p,{children:`The other report worth scheduling.`})})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Export hours for payroll","description":"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.","href":"/guides/export-hours-for-payroll"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Before you start","slug":"before-you-start","depth":2,"children":[]},{"title":"Get the hours right before you export","slug":"get-the-hours-right-before-you-export","depth":2,"children":[]},{"title":"Build the report","slug":"build-the-report","depth":2,"children":[]},{"title":"Contractors are paid differently","slug":"contractors-are-paid-differently","depth":2,"children":[]},{"title":"Other exports you may need","slug":"other-exports-you-may-need","depth":2,"children":[]},{"title":"Common questions","slug":"common-questions","depth":2,"children":[]},{"title":"Related guides","slug":"related-guides","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":[],"subdomain":"lemaistrelabtechnologiesllp","siteName":"TimeTracker","title":"Export hours for payroll - TimeTracker","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-08-01T02:12:42.421Z","originalFileLocation":"guides/export-hours-for-payroll.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.\">\u003cmeta data-mint-head name=\"application-name\" content=\"TimeTracker\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Export hours for payroll - TimeTracker\">\u003cmeta data-mint-head property=\"og:description\" content=\"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"TimeTracker\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.timetracker.in/guides/export-hours-for-payroll\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://lemaistrelabtechnologiesllp.mintlify.site/_mintlify/api/og/v2?division=People+operations\u0026amp;title=Export+hours+for+payroll\u0026amp;description=Build+the+monthly+hours+report+your+payroll+provider+needs%2C+export+it+as+CSV%2C+Excel+or+PDF%2C+and+have+it+delivered+automatically+every+month.\u0026amp;theme=936eb6d152e21e21fa62a106\u0026amp;signature=5f56a9c342aba47ad084bc7200be106b3844295444b30614286e9185b10d4a23\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Export hours for payroll - TimeTracker\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://lemaistrelabtechnologiesllp.mintlify.site/_mintlify/api/og/v2?division=People+operations\u0026amp;title=Export+hours+for+payroll\u0026amp;description=Build+the+monthly+hours+report+your+payroll+provider+needs%2C+export+it+as+CSV%2C+Excel+or+PDF%2C+and+have+it+delivered+automatically+every+month.\u0026amp;theme=936eb6d152e21e21fa62a106\u0026amp;signature=5f56a9c342aba47ad084bc7200be106b3844295444b30614286e9185b10d4a23\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/lemaistrelabtechnologiesllp/XndmdcLSWS3JX6tg/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"TimeTracker\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#14a800\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.timetracker.in/guides/export-hours-for-payroll\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/guides/export-hours-for-payroll.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.timetracker.in/#organization\",\"name\":\"TimeTracker\",\"url\":\"https://docs.timetracker.in\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/lemaistrelabtechnologiesllp/H9Sna8wVBfkk0gAi/images/logo-light.svg?fit=max\u0026auto=format\u0026n=H9Sna8wVBfkk0gAi\u0026q=85\u0026s=8a120388c75952f2e86544c917e8bd82\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.timetracker.in#website\",\"name\":\"TimeTracker\",\"url\":\"https://docs.timetracker.in\",\"publisher\":{\"@id\":\"https://docs.timetracker.in/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.timetracker.in/guides/export-hours-for-payroll#webpage\",\"url\":\"https://docs.timetracker.in/guides/export-hours-for-payroll\",\"name\":\"Export hours for payroll\",\"description\":\"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.\",\"dateModified\":\"2026-08-01T02:12:42.421Z\",\"isPartOf\":{\"@id\":\"https://docs.timetracker.in#website\"},\"breadcrumb\":{\"@id\":\"https://docs.timetracker.in/guides/export-hours-for-payroll#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.timetracker.in/guides/export-hours-for-payroll#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"People operations\",\"item\":\"https://docs.timetracker.in/guides/onboard-a-new-employee\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Export hours for payroll\",\"item\":\"https://docs.timetracker.in/guides/export-hours-for-payroll\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.timetracker.in/guides/export-hours-for-payroll#article\",\"headline\":\"Export hours for payroll\",\"name\":\"Export hours for payroll\",\"description\":\"Build the monthly hours report your payroll provider needs, export it as CSV, Excel or PDF, and have it delivered automatically every month.\",\"url\":\"https://docs.timetracker.in/guides/export-hours-for-payroll\",\"mainEntityOfPage\":{\"@id\":\"https://docs.timetracker.in/guides/export-hours-for-payroll#webpage\"},\"dateModified\":\"2026-08-01T02:12:42.421Z\",\"publisher\":{\"@id\":\"https://docs.timetracker.in/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.timetracker.in#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"TimeTracker\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"TimeTracker\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/guides/export-hours-for-payroll.md","siteName":"TimeTracker","nav":{"global":null,"tabs":[{"tab":"Documentation","pages":[{"title":"Documentation","href":""}]},{"tab":"Guides","groups":[{"group":"End-to-end workflows","pages":[{"title":"Guides","href":"/guides/overview"},{"title":"Track work for a client","href":"/guides/track-work-for-a-client"},{"title":"Set up a new workspace","href":"/guides/set-up-a-new-workspace"},{"title":"Weekly timesheet routine","href":"/guides/weekly-timesheet-routine"},{"title":"Month-end close","href":"/guides/month-end-close"},{"title":"Quote to invoice","href":"/guides/quote-to-invoice"},{"title":"Monitor project profitability","href":"/guides/monitor-project-profitability"},{"title":"Run a monthly retainer","href":"/guides/run-a-monthly-retainer"}]},{"group":"By business type","pages":[{"title":"Setup for an agency","href":"/guides/setup-for-an-agency"},{"title":"Setup for a consultant","href":"/guides/setup-for-a-consultant"},{"title":"Setup for a remote team","href":"/guides/setup-for-a-remote-team"}]},{"group":"People operations","pages":[{"title":"Onboard a new employee","href":"/guides/onboard-a-new-employee"},{"title":"Offboard an employee","description":"A complete checklist for someone leaving: close their open time, reassign their tasks, revoke every route back in, transfer ownership and free the seat.","href":"/guides/offboard-an-employee"},{"title":"Export hours for payroll","href":"/guides/export-hours-for-payroll"},{"title":"Manage contractors","description":"When to use the Contractor role instead of Member, how contractor rates change your margin, and how to run and end a freelance engagement cleanly.","href":"/guides/manage-contractors"}]},{"group":"Moving to TimeTracker","pages":[{"title":"Switch from another tool","href":"/guides/switch-from-another-tool"},{"title":"Import clients and projects","href":"/guides/import-clients-and-projects"}]}]},{"tab":"Reference","pages":[{"title":"Reference","href":"/reference/overview"}]}]},"basePath":"","title":"Export hours for payroll - TimeTracker","deploymentId":"dpl_2pTxFtyBudBMYZiCw1MyvoA1wxpd","buildId":"dpl_2pTxFtyBudBMYZiCw1MyvoA1wxpd","dynamics":[],"chunks":[]}