Get a weekly Mangomint sales and cancellations report

1. Open the Mangomint Reports app, choose Sales Summary, set last week's dates and locations, and read # Sales, Service Sales, Product Sales, Tips and Gross Total for each day.
2. Run Service & Product Sales By Staff for the same dates to see each staff member's service and product totals.
3. Open Appointment Cancellations for the same week, read the Type and Next Appointment columns, and download the Excel file to see who canceled each appointment.
4. Copy the totals into a spreadsheet or a message, then repeat the date setting for the week before to compare.
5. The same date picking repeats every Monday, and an open sale from Saturday that nobody closed is missing from the totals until someone closes it.

Every Monday, send me last week's Sales Summary next to the week before, sales by staff, and the late cancellations and no-shows with no next appointment.

1. 01

   Pin the week to the salon clock

   The agent reads list_locations for each location's time zone and sets Monday to Sunday in that zone, so a late Sunday checkout is not pushed into the wrong week.

2. 02

   Pull this week and last

   It calls get_report for sales_summary and sales_by_staff for last week and the week before, and works out the change in gross and net totals and in product share.

3. 03

   Sort the cancellations

   From canceled_appointments it separates normal cancellations from late cancellations and no-shows, and lists only clients with no next appointment, the ones worth a call.

4. 04

   Flag numbers that look wrong

   A day with zero sales during opening hours, or a sharp drop on one day, gets a note that open sales may not be closed yet. The agent reports it and does not guess the missing amount.

Week 5 to 11 Oct, Downtown: net $24,628 (week before: $23,410)
Services 227, products 48, product sales $1,633
Top staff: Alex $7,820, Sam $6,145, Rae $5,390
Cancellations: 14 (9 normal, 3 late, 2 no-show); 6 with no next appointment
Check: Sunday 11 Oct is low at $1,244; 2 sales may still be open

• Mangomint Sales reports count closed sales by sale date, and an open sale stays out of the Sales reports and the Payroll report until someone closes it.
• Mangomint treats gift card, package and membership sales as deferred revenue, so they appear in Sales Summary only when redeemed.
• The Mangomint Appointment Cancellations report also lists deleted appointments and expired Express Bookings, and client email, service price and who canceled appear only in its Excel download.
• Sales of archived Mangomint staff members stay in Sales and Payment reports, but archived staff drop out of the Payroll report.
• Mangomint Reports need an Admin user or the Can access company reports permission.

Every tool here only reads, so it can run weekly from n8n, Make, Zapier or cron without waiting for your OK.

Sources: Mangomint: List of Available Reports · Mangomint: Sales Reports · Mangomint: Business Reports · Mangomint: FAQ, Reports

curl https://cotlet.dev/api/v1/mangomint/get_report \
  -H "Authorization: Bearer $COTLET_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"report":"sales_summary","from":"2026-10-05","to":"2026-10-11"}'

{
  "report": "sales_summary",
  "from": "2026-10-05",
  "to": "2026-10-11",
  "currency": "USD",
  "rows": [
    {
      "date": "2026-10-05",
      "services_qty": 31,
      "services_total": 3120,
      "products_qty": 6,
      "products_total": 214,
      "total": 3334
    },
    {
      "date": "2026-10-06",
      "services_qty": 28,
      "services_total": 2870,
      "products_qty": 4,
      "products_total": 148,
      "total": 3018
    },
    {
      "date": "2026-10-07",
      "services_qty": 35,
      "services_total": 3540,
      "products_qty": 9,
      "products_total": 302,
      "total": 3842
    },
    {
      "date": "2026-10-08",
      "services_qty": 33,
      "services_total": 3315,
      "products_qty": 5,
      "products_total": 176,
      "total": 3491
    },
    {
      "date": "2026-10-09",
      "services_qty": 41,
      "services_total": 4210,
      "products_qty": 12,
      "products_total": 388,
      "total": 4598
    },
    {
      "date": "2026-10-10",
      "services_qty": 47,
      "services_total": 4760,
      "products_qty": 10,
      "products_total": 341,
      "total": 5101
    },
    {
      "date": "2026-10-11",
      "services_qty": 12,
      "services_total": 1180,
      "products_qty": 2,
      "products_total": 64,
      "total": 1244
    }
  ],
  "totals": {
    "services_qty": 227,
    "services_total": 22995,
    "products_qty": 48,
    "products_total": 1633,
    "total": 24628
  }
}

MCP: add https://cotlet.dev/mcp/v1 with the same key; the tool is mangomint_get_report. Example data.

• Reschedule Mangomint appointments when staff is out
• Book clients from the Mangomint Intelligent Waitlist
• Book Mangomint appointments from client texts with an AI agent
• Mangomint API and MCP server: every tool
• All use cases