Search Plus UI Blocks

Find a block, a category or a site

Grouped table with group totalsdata-grid-grouped

Use in Plus UI
npx shadcn@latest add https://blocks.plusui.com/r/data-grid-grouped.json

Data-grid · 3 variants

← → to step through · + on a thumbnail to compare side by side (up to 3)

/preview/data-grid-grouped
Open ↗

Default content

{
  "eyebrow": "Brassfinch · Card spend",
  "title": "October spend by category",
  "description": "Every card payment this month across the team, with VAT reclaimable and receipts still to match. Group it the way your accountant asks.",
  "actions": [
    {
      "label": "Send to accountant",
      "href": "#send",
      "variant": "primary"
    }
  ],
  "currency": "GBP",
  "columns": [
    {
      "key": "date",
      "label": "Date",
      "kind": "date"
    },
    {
      "key": "merchant",
      "label": "Merchant",
      "kind": "strong"
    },
    {
      "key": "cardholder",
      "label": "Cardholder",
      "kind": "person"
    },
    {
      "key": "category",
      "label": "Category",
      "kind": "text"
    },
    {
      "key": "receipt",
      "label": "Receipt",
      "kind": "status"
    },
    {
      "key": "vat",
      "label": "VAT",
      "kind": "money"
    },
    {
      "key": "amount",
      "label": "Amount",
      "kind": "money"
    }
  ],
  "statuses": [
    {
      "value": "matched",
      "label": "Matched",
      "tone": "success"
    },
    {
      "value": "missing",
      "label": "Missing",
      "tone": "danger"
    },
    {
      "value": "review",
      "label": "To review",
      "tone": "warning"
    }
  ],
  "rows": [
    {
      "id": "t01",
      "cells": {
        "date": "2026-10-01",
        "merchant": "Fieldnote Software",
        "cardholder": "Ada Okafor",
        "category": "Software",
        "receipt": "matched",
        "amount": 288,
        "vat": 48
      }
    },
    {
      "id": "t02",
      "cells": {
        "date": "2026-10-02",
        "merchant": "Linden Print Co.",
        "cardholder": "Sam Reyes",
        "category": "Production",
        "receipt": "matched",
        "amount": 642,
        "vat": 107
      }
    },
    {
      "id": "t03",
      "cells": {
        "date": "2026-10-03",
        "merchant": "Railway tickets, Leeds",
        "cardholder": "Ada Okafor",
        "category": "Travel",
        "receipt": "missing",
        "amount": 118.4,
        "vat": 0
      }
    },
    {
      "id": "t04",
      "cells": {
        "date": "2026-10-03",
        "merchant": "Copperleaf Café",
        "cardholder": "Jun Park",
        "category": "Meals",
        "receipt": "matched",
        "amount": 46.8,
        "vat": 7.8
      }
    },
    {
      "id": "t05",
      "cells": {
        "date": "2026-10-06",
        "merchant": "Canvas & Frame",
        "cardholder": "Sam Reyes",
        "category": "Production",
        "receipt": "review",
        "amount": 1260,
        "vat": 210
      }
    },
    {
      "id": "t06",
      "cells": {
        "date": "2026-10-07",
        "merchant": "Northpoint Hosting",
        "cardholder": "Jun Park",
        "category": "Software",
        "receipt": "matched",
        "amount": 96,
        "vat": 16
      }
    },
    {
      "id": "t07",
      "cells": {
        "date": "2026-10-08",
        "merchant": "Harbour Hotel, Bristol",
        "cardholder": "Ada Okafor",
        "category": "Travel",
        "receipt": "matched",
        "amount": 214,
        "vat": 35.67
      }
    },
    {
      "id": "t08",
      "cells": {
        "date": "2026-10-09",
        "merchant": "Figment Fonts",
        "cardholder": "Jun Park",
        "category": "Software",
        "receipt": "missing",
        "amount": 180,
        "vat": 30
      }
    },
    {
      "id": "t09",
      "cells": {
        "date": "2026-10-10",
        "merchant": "Saltbox Kitchen",
        "cardholder": "Sam Reyes",
        "category": "Meals",
        "receipt": "missing",
        "amount": 132.5,
        "vat": 22.08
      }
    },
    {
      "id": "t10",
      "cells": {
        "date": "2026-10-13",
        "merchant": "Kiln Studio Hire",
        "cardholder": "Ada Okafor",
        "category": "Production",
        "receipt": "matched",
        "amount": 450,
        "vat": 75
      }
    },
    {
      "id": "t11",
      "cells": {
        "date": "2026-10-14",
        "merchant": "Taxi, Temple Meads",
        "cardholder": "Sam Reyes",
        "category": "Travel",
        "receipt": "review",
        "amount": 24.6,
        "vat": 0
      }
    },
    {
      "id": "t12",
      "cells": {
        "date": "2026-10-15",
        "merchant": "Ledgerline Accounting",
        "cardholder": "Jun Park",
        "category": "Software",
        "receipt": "matched",
        "amount": 39,
        "vat": 6.5
      }
    }
  ],
  "labels": {
    "search": "Search spend",
    "searchPlaceholder": "Search merchant or cardholder",
    "count": "{count} payments",
    "total": "October total",
    "empty": "No payments match that search.",
    "groupBy": "Group by",
    "groupCount": "{count} payments",
    "toggleGroup": "Show or hide {group}"
  },
  "groupBy": [
    "category",
    "cardholder",
    "receipt"
  ]
}