--- title: MCP Server Job Costing Report description: Build a job costing report with Claude and the Timeero MCP. See hours, labor cost at the job rate, and mileage for every job, by employee, in Excel. --- [Skip to content](https://help.timeero.com/mcp-server-job-costing-report#main-content) English Show submenu for translations [![logo - 512.png\]](https://help.timeero.com/hs-fs/hubfs/logo%20-%20512.png?width=75&height=75&name=logo%20-%20512.png)](https://timeero.com) Open main navigation Close main navigation - English Show submenu for translations - [Go to timeero.com](https://timeero.com/) [Go to timeero.com](https://timeero.com/) Help Center - There are no suggestions because the search field is empty. 1. [Help Center](https://help.timeero.com/?hsLang=en) 2. [Integrations](https://help.timeero.com/integrations?hsLang=en) 3. [MCP](https://help.timeero.com/integrations?hsLang=en#mcp) # MCP Server Job Costing Report ## Learn how to use the MCP Server to get a job costing report. Set it to run automatically as often as you need. ### ![Premium Plan](https://help.timeero.com/hs-fs/hubfs/Premium%20Plan.png?width=72&height=44&name=Premium%20Plan.png) ### What Can I do with the Job Costing Report through the MCP? - See every job in one table side by side. - Get an employee tab that subtotals each person on each job. - Included hourly and daily rate employees, calculated at the job rate. - See a totals row across all jobs, with the top three jobs by cost called out. - Run it on a schedule: weekly, monthly, or per pay period.   ### What do I Need to do Before I Start? - Ensure you have connected the Timeero MCP to your AI Agent.  - [*Connect Claude to Timeero.*](https://help.timeero.com/how-to-set-up-the-mcp-for-claude?hsLang=en) - [*Connect ChatGPT to Timeero.*](https://help.timeero.com/how-to-set-up-the-mcp-for-chatgpt?hsLang=en) - [*Connect Cursor or other MCP compatible clients to Timeero.*](https://help.timeero.com/how-to-set-up-the-mcp-for-cursor-and-other-ides?hsLang=en) - Ensure your jobs each have a set rate in your account. A blank rate shows up as $0, and Claude will ask what to do with it. - Ensure Mileage rates are set. Mileage cost uses each employee's mileage rate.   ### Step 1: Give your AI Agent the Instructions There are two ways to give the AI agent instructions. You can use the prompt linked below, or create a skill in your AI agent.  - **Prompt:** Copy [the prompt in this link](https://help.timeero.com/hubfs/MCP%20Use%20Case%20Guides/Timeero_Job_Costing_Prompt.txt?hsLang=en)and paste it in your AI chat. Provide the date range at the end of the prompt. - **Skill:** [download timeero-job-costing.zip](https://help.timeero.com/hubfs/MCP%20Use%20Case%20Guides/timeero-job-costing.zip?hsLang=en)and upload it in your AI agent's skills section. Then ask for a job costing report and give your dates. \*Once you click the download link for the skill, you may need to press enter in the url search bar to initiate the download.  ### Step 2: Check the first run One row per job on the Job Summary tab. The bottom row is all jobs. Example data: *Job\_Costing\_2026-10-01\_to\_2026-10-31.xlsx · 4 jobs · highest cost: Warner Rd remodel* | Job | Job rate | Hours | Labor cost | Miles | Mileage cost | Total cost | | --- | --- | --- | --- | --- | --- | --- | | Warner Rd remodel | $45 | 312.0 | $14,040 | 480 | $336 | $14,376 | | Oak St roof | $40 | 186.5 | $7,460 | 210 | $147 | $7,607 | | Mesa clinic build | $38 | 140.0 | $5,320 | 100 | $70 | $5,390 | | Painting | No rate set | 42.0 | $0 | 30 | $21 | $21 | | **All jobs** | | **680.5** | **$26,820** | **820** | **$574** | **$27,394** | The other tabs: - **By Employee:** each job split by employee, with subtotals per job and a total per employee across all jobs. - **Timesheet Detail:** every timesheet with date, clock in and out, hours, rate used, and cost. - **Notes:** how costs were calculated, and any jobs that were flagged or used a fallback rate. Three things to confirm: 1. **Every job with time shows up.** Compare against your users' timesheets in Timeero. 2. **Spot-check one job.** Its hours should match the total shown in the **Report by Job** in Timeero. 3. **No job shows $0 labor cost with hours on it,** unless you chose that. That would signify a missing job rate. ### How can I Customize the Report? - **Set it to run on a schedule.** Use the following prompt:  - "Turn this into a scheduled task. Run it \[every Monday at 7am for last week\] and send me the file. If a job has no job rate, \[use each employee's pay rate / leave it at $0 and flag it\]." - **One job only.** "Only include the Warner Rd remodel job." - **Compare to budget.** "Add a Budget column with these amounts per job, and a Variance column." - **Add a markup.** "Add a Billable column at job cost plus 20%." - **Compare to last period.** "Add last period's hours and cost next to each job." - **Send it to finance.** "Email the file to finance@ each run." ### What Else do I Need to Know? - **Jobs come from clock-in.** Time counts toward the job an employee selects when they clock in. Time tracked by location or geofence isn't included. For that, use the Segmented Tracking report. - **Overtime is costed at the job rate.** All hours use the same flat job rate. The regular, overtime, and double-time split is shown for reference. - **Hourly and salaried employees are both included.** - **PTO is left out of job cost.** The Notes tab shows how many PTO hours were excluded. - **Reports use today's job rates.** If you changed a rate partway through the period, earlier hours are costed at the new rate. - **Up to 366 days per report.** For longer periods, run one report per year.     - [Getting Started](https://help.timeero.com/getting-started?hsLang=en#main-content) - [First Steps](https://help.timeero.com/getting-started?hsLang=en#first-steps) - [Users](https://help.timeero.com/getting-started?hsLang=en#users) - [Jobs & Tasks](https://help.timeero.com/getting-started?hsLang=en#jobs-tasks) - [Scheduling](https://help.timeero.com/getting-started?hsLang=en#scheduling) - [Company Settings](https://help.timeero.com/company-settings?hsLang=en#main-content) - [Main Settings](https://help.timeero.com/company-settings?hsLang=en#main-settings) - [Break Settings](https://help.timeero.com/company-settings?hsLang=en#break-settings) - [Premium Settings](https://help.timeero.com/company-settings?hsLang=en#premium-settings) - [SMS Management](https://help.timeero.com/company-settings?hsLang=en#sms-management) - [Billing](https://help.timeero.com/billing?hsLang=en) - [Advanced Tracking Options](https://help.timeero.com/advanced-tracking-options?hsLang=en#main-content) - [Auto Clock In/ Out](https://help.timeero.com/advanced-tracking-options?hsLang=en#auto-clock-in-out) - [Timesheets, Mileage & Location Tracking](https://help.timeero.com/timesheets-mileage-location-tracking?hsLang=en#main-content) - [Time & Mileage page on the Web Portal](https://help.timeero.com/timesheets-mileage-location-tracking?hsLang=en#time-mileage-page-on-the-web-portal) - [Entries Tab on the Mobile App](https://help.timeero.com/timesheets-mileage-location-tracking?hsLang=en#entries-tab-on-the-mobile-app) - [Kiosk App](https://help.timeero.com/timesheets-mileage-location-tracking?hsLang=en#kiosk-app) - [Multi-Level Approvals](https://help.timeero.com/timesheets-mileage-location-tracking?hsLang=en#multi-level-approvals) - [Integrations](https://help.timeero.com/integrations?hsLang=en#main-content) - [MCP](https://help.timeero.com/integrations?hsLang=en#mcp) - [Gusto](https://help.timeero.com/integrations?hsLang=en#gusto) - [ADP Workforce Now](https://help.timeero.com/integrations?hsLang=en#adp-workforce-now) - [ADP RUN](https://help.timeero.com/integrations?hsLang=en#adp-run) - [QuickBooks Online](https://help.timeero.com/integrations?hsLang=en#quickbooks-online) - [Zapier](https://help.timeero.com/integrations?hsLang=en#zapier) - [Paychex](https://help.timeero.com/integrations?hsLang=en#paychex) - [Sandata EVV](https://help.timeero.com/integrations?hsLang=en#sandata-evv) - [Paylocity](https://help.timeero.com/integrations?hsLang=en#paylocity) - [Rippling](https://help.timeero.com/integrations?hsLang=en#rippling) - [QuickBooks Desktop](https://help.timeero.com/integrations?hsLang=en#quickbooks-desktop) - [Xero](https://help.timeero.com/integrations?hsLang=en#xero) - [PIMSY](https://help.timeero.com/integrations?hsLang=en#pimsy) - [Paycor](https://help.timeero.com/integrations?hsLang=en#paycor) - [Sage Intacct](https://help.timeero.com/integrations?hsLang=en#sage-intacct) - [Viventium](https://help.timeero.com/integrations?hsLang=en#viventium) - [BambooHR](https://help.timeero.com/integrations?hsLang=en#bamboohr) - [Reports](https://help.timeero.com/reports?hsLang=en) - [Employee Resources](https://help.timeero.com/employee-resources?hsLang=en#main-content) - [Getting Started](https://help.timeero.com/employee-resources?hsLang=en#getting-started) - [Configure Settings](https://help.timeero.com/employee-resources?hsLang=en#configure-settings) - [Managing Time & Mileage](https://help.timeero.com/employee-resources?hsLang=en#managing-time-mileage) - [Time Off Management](https://help.timeero.com/time-off-management?hsLang=en) - [In-App Messaging](https://help.timeero.com/in-app-messaging?hsLang=en#main-content) - [Message Blasts](https://help.timeero.com/in-app-messaging?hsLang=en#message-blasts) - [Product Updates](https://help.timeero.com/product-updates?hsLang=en) - [Frequently Asked Questions](https://help.timeero.com/frequently-asked-questions?hsLang=en) # Timeero For further assistance, contact our support team: +1 (888) 998-0852 or email us: hello@timeero.com © 2026 by Timeero LLC.