MCP Total Time and Mileage Report
Learn how to use the MCP Server to get a Total Time and Mileage report. Set it to run automatically as often as you need.
What Can I do with the Total Time and Mileage Report through the MCP?
- See every employee’s totals in one table, side by side.
- Get one row per employee, or one row per group.
- See total miles, regular hours, regular pay, overtime hours, and overtime cost.
- Get a totals row across everyone, with the highest overtime 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.
- Ensure your employees have pay rates set. A blank pay rate shows as $0 regular pay.
- Ensure your overtime settings are correct. Overtime hours and cost follow your company’s overtime rules.
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 and paste it in your AI chat. Provide the date range at the end of the prompt.
- Skill: Download the Timeero Time & Mileage Report zip file and upload it in your AI agent’s skills section. Then ask for a Total Time and Mileage 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 start the download.
Step 2: Check the first run
The report has one row per employee, and the bottom row is everyone. Example data:
Time_Mileage_by_User_2026-11-02_to_2026-11-08.xlsx · 5 employees · highest overtime cost: Dana Ruiz
| User | Total miles | Regular hours | Regular pay | Overtime hours | Overtime cost |
|---|---|---|---|---|---|
| Dana Ruiz | 212.40 | 40.00 | $1,000.00 | 6.50 | $243.75 |
| Marcus Lee | 98.15 | 40.00 | $880.00 | 2.00 | $66.00 |
| Priya Shah | 0.00 | 38.25 | $765.00 | 0.00 | $0.00 |
| Tom Becker | 145.80 | 32.00 | $608.00 | 0.00 | $0.00 |
| Ellen Fox | 12.30 | 20.00 | $360.00 | 0.00 | $0.00 |
| Total | 468.65 | 170.25 | $3,613.00 | 8.50 | $309.75 |
Below the table, a Notes section shows:
- Mileage cost for the period.
- Any double overtime, PTO, or premium pay hours.
- Anyone still clocked in who was left out.
Three things to confirm:
- Every employee with time shows up. Compare against your users’ timesheets in Timeero.
- Spot-check one employee. Their hours and miles should match the Total Time and Mileage report in Timeero for the same dates.
- No one shows $0 regular pay with hours on it. That would signify a missing pay 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.”
- By group. “Show one row per group instead of per employee.”
- One group only. “Only include the Field Crew group.”
- Hourly employees only. “Only include hourly employees.”
- Add mileage cost. “Add a Mileage cost column.”
- Compare to last period. “Add last period’s hours and overtime next to each employee.”
What Else do I Need to Know?
- Open timesheets aren’t counted. If someone is still clocked in, their time is left out, and the AI agent lists them so you can follow up.
- Hourly and salaried employees are both included. Ask for hourly only if you don’t want salaried employees.
- Overtime follows your company settings. Double overtime, PTO, and premium pay aren’t in the six columns. They’re listed in the Notes when they apply.
- Employees without a group show as “No group” when the report is by group.
- “Last week” means Monday to Sunday. If your week starts on a different day, say so in your request.
- Up to 366 days per report. For longer periods, run one report per year.
