Export a monthly Timetastic leave report for payroll

1. An account that can open SETTINGS > REPORTING & BACKUP picks the Monthly summary and chooses the month.
2. Timetastic downloads an Excel file with two worksheets: Month, with totals per active user by leave type, and Leave, with all the month's requests and bookings.
3. The Leave sheet also holds declined and cancelled requests, so whoever prepares payroll has to read past them.
4. For one person, the admin goes to USERS, clicks the three dots beside the name and chooses Download data.
5. The same steps repeat every month, and sick leave for a year or a month comes from the same page.

Give me September leave per person from Timetastic, holiday and sick days apart, without declined or cancelled requests.

1. 01

   Read the month

   get_monthly_summary takes the month in YYYY-MM and reads both worksheets of the download, so the totals per person and the booking rows come back as data and not as a file. The account must be able to open the page; any other account gets APP_PERMISSION_DENIED and the agent says so.

2. 02

   Drop what does not count

   The Leave rows include declined and cancelled requests. The agent removes them before it adds anything up and reports how many it removed, so the numbers match what was approved.

3. 03

   Check the totals against the rows

   The Month totals are compared with the approved rows of the Leave sheet. A person whose two numbers differ is listed for you with both values, and the agent does not pick one.

4. 04

   Shape it for payroll

   The agent returns the layout you asked for, for example one line per person with holiday days and sick days apart. Nothing is written back to Timetastic, so a wrong layout costs only a second run.

5. 05

   Add balances when asked

   For a year-end or leave-year check, get_annual_summary adds allowance, carried forward, time in lieu and remaining per person to the same answer.

September 2026, 3 active users
Ana Torres: holiday 2, sick 1
Ben Okafor: sick 2
Priya Nair: no leave
Totals: holiday 2, sick 3
Left out: 1 declined request (Ben Okafor, Sep 28 to 30)

curl "https://cotlet.dev/api/v1/timetastic/monthly-summary?month=2026-09" \
  -H "Authorization: Bearer $COTLET_API_KEY"

{
  "month": "2026-09",
  "totals": [
    {
      "employee": "Ana Torres",
      "leave": {
        "Holiday": 2,
        "Sick leave": 1
      }
    },
    {
      "employee": "Ben Okafor",
      "leave": {
        "Sick leave": 2
      }
    },
    {
      "employee": "Priya Nair",
      "leave": {}
    }
  ],
  "rows": [
    {
      "employee": "Ana Torres",
      "leave_type": "Holiday",
      "from": "2026-09-07",
      "to": "2026-09-08",
      "status": "Approved"
    },
    {
      "employee": "Ana Torres",
      "leave_type": "Sick leave",
      "from": "2026-09-15",
      "to": "2026-09-15",
      "status": "Approved"
    },
    {
      "employee": "Ben Okafor",
      "leave_type": "Sick leave",
      "from": "2026-09-02",
      "to": "2026-09-03",
      "status": "Approved"
    },
    {
      "employee": "Ben Okafor",
      "leave_type": "Holiday",
      "from": "2026-09-28",
      "to": "2026-09-30",
      "status": "Declined"
    }
  ]
}

MCP: add https://cotlet.dev/mcp/v1 with the same key; the call is timetastic_read → get_monthly_summary. Example data.

• Approve Timetastic time off requests with AI
• Book Timetastic time off from your AI agent
• Timetastic API and MCP server: every tool
• All use cases