saas-spend-auditlisted
Install: claude install-skill trevhud/rote
# Monthly SaaS spend audit
Run on the 3rd business day of the month, for the month that just closed.
Inputs: the first and last day of that month (`YYYY-MM-DD`).
## Data
Pull these three at the same time. None of them needs the others.
| Source | Tool | Details |
| --- | --- | --- |
| Card spend | `list_transactions` (Ramp MCP) | `from_date` / `to_date` = the month, `category` = `software` |
| Vendor register | `read_sheet_values` (Google Sheets MCP) | spreadsheet `1VendorRegisterExampleSheetId000000000000`, range `Register!A:J` |
| Seat usage | `get_app_usage` (Okta MCP) | once per Okta app id listed in the register, `days` = 30 |
The register has one row per approved vendor: vendor, card descriptor,
category, budget owner, contracted monthly price (USD), paid seats, Okta
app id (blank if the tool isn't behind Okta), renewal date, auto-renew
(Y/N), notes. Skip the header row and any row with a blank vendor.
Seat usage needs the register's Okta app ids, so read the register first,
then fan out over the ids.
## Match charges to vendors
Card merchant strings are messy (`SQ *FIGMA`, `ATLASSIAN* JIRA SOFTWARE`,
`PADDLE.NET* LINEAR`). Group the month's transactions by merchant
descriptor first, then work out the vendor for each descriptor:
1. If the descriptor matches a register row's card descriptor exactly
(ignoring case), that's the vendor. Done.
2. Otherwise, use judgment: payment processor prefixes (`SQ *`, `PADDLE.NET*`,
`FS *`, `PAYPAL *`) hide the real vendo