← ClaudeAtlas

saas-spend-auditlisted

Monthly SaaS spend audit for finance ops. Pulls the month's software card spend from Ramp, the vendor register from Google Sheets and per-app seat usage from Okta, works out which vendor every charge belongs to, runs the audit rules, gets the finance lead's keep / cancel / renegotiate call on every flagged vendor, and logs the actions in the Procurement Requests sheet. Use for "run the SaaS audit", "software spend review for <month>", or "who are we paying for tools we don't use".
trevhud/rote · ★ 8 · AI & Automation · score 71
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