Skip to content
English
  • There are no suggestions because the search field is empty.

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.

Premium Plan

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?

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.

*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:

  1. Every employee with time shows up. Compare against your users’ timesheets in Timeero.
  2. Spot-check one employee. Their hours and miles should match the Total Time and Mileage report in Timeero for the same dates.
  3. 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.