---
name: subscription-audit
description: Analyzes a 12-month software and SaaS expense export to identify redundant, overlapping, or narrow single-purpose tools that can be consolidated into one approved team AI workspace. Use before adding any new AI budget line item to save money first.
license: CC-BY-4.0
metadata:
  author: Paul Yerrick (paulyerrick.com / COKI Studio)
  version: "1.0"
  category: finance-and-operations
  source: https://www.paulyerrick.com/ai/
---

# The Subscription Audit

Audit your organization's last 12 months of recurring software charges to spot narrow, single-purpose tools and overlapping subscriptions so you can **save budget before spending a dollar on new AI software**.

## When to Use This Skill

- Before requesting budget for a new team AI workspace (Claude Team/Enterprise, ChatGPT Team/Enterprise, Gemini Workspace).
- During annual budgeting or a quarterly operations review by an Executive Pastor, COO, Finance Lead, or Operations Director.
- Whenever multiple departments have quietly expensed separate small SaaS tools on company cards.

## When Not to Use This Skill (Red Lines)

- **Remove all bank account numbers, credit card numbers, tax IDs, personal employee names, and donor/payroll records** before pasting or uploading your CSV/spreadsheet.
- Only run this audit inside an approved team AI workspace with model training disabled.
- Never cancel mission-critical security, accounting, ChMS, CRM, or compliance tools without department lead sign-off. Treat this output as a structured review sheet for human leaders.

## Inputs Needed

Ask the user to paste or upload:

1. **A 12-month software/SaaS charge list** (CSV, spreadsheet table, or copied lines showing vendor name, monthly or annual cost, and department if known).
2. **Primary core stack** (optional, e.g., Google Workspace or Microsoft 365, Planning Center / Rock RMS / Salesforce, Slack, etc.).
3. **Target approved AI workspace** (optional, e.g., Claude Team, ChatGPT Team, or undecided).

If cost periods are mixed (monthly vs. annual), normalize every line item to an estimated annual spend and clearly mark any estimates.

## Step-by-Step Instructions

1. **Normalize the list.** Group repeated monthly charges by vendor and calculate annualized spend per vendor. Flag duplicate subscriptions across departments (for example, three different teams paying for separate transcription or PDF tools).
2. **Classify every tool into one of four buckets:**
   - **Consolidate Now:** Narrow single-purpose tools whose main job is already handled well by a single approved AI workspace or existing core suite (basic transcription apps, simple summarization plugins, standalone grammar/rewriting utilities, lightweight copy generators, basic PDF chat tools, duplicate note-takers).
   - **Check for Overlap:** Categories where the organization is paying for two or more competing tools (multiple project trackers, form builders, survey tools, scheduling apps, or stock/design utilities).
   - **Keep (Core Infrastructure):** Mission-critical systems of record (ChMS, CRM, accounting, payroll, email/identity suite, specialized production/broadcast software).
   - **Needs Clarification:** Unrecognized vendor names or unclear usage where finance needs to ask the cardholder what it does.
3. **Calculate conservative savings.** Estimate low-end and high-end annual savings from the Consolidate Now and Check for Overlap buckets. Never inflate savings numbers.
4. **Build a 30-day action plan.** Give the leader a simple checklist of who to email, what to verify before canceling (data export, contract renewal date), and how the savings compare to funding one approved team AI workspace.

## Output Format

Use this exact markdown structure:

```markdown
## Software Subscription Audit Summary
**Total Vendors Reviewed:** [Count] | **Total Annualized Spend:** [$Amount]
**Estimated Recoverable Annual Savings:** [$Low to $High]

### 1. Consolidate Now (High-Confidence Candidates)
| Vendor | Annualized Cost | Category / Function | Consolidation Path | Risk Level |
| --- | --- | --- | --- | --- |
| [Vendor] | [$Amount] | [Function] | [Replace with approved AI workspace or existing suite] | Low / Medium |

### 2. Check for Overlap (Multiple Tools Doing the Same Job)
- **[Category, e.g., Meeting Transcription]:** Paying for [Tool A ($X/yr)] and [Tool B ($Y/yr)]. Recommend standardizing on one.

### 3. Keep (Core Infrastructure)
- [Brief comma-separated list of core systems left untouched]

### 4. Unknown / Needs Clarification
- **[Vendor ($Amount/yr)]:** Confirm owner, active seats, and renewal date.

### 5. Next-Step Checklist (Next 14 Days)
1. Confirm active usage and export any saved files/transcripts before canceling any tool in Section 1.
2. Check annual renewal dates on Section 2 overlaps and set calendar reminders 30 days ahead.
3. Reallocate recovered budget toward one approved, privacy-protected team AI workspace.
```

## Voice and Style Rules

- Be practical, conservative with savings estimates, and respectful of department needs.
- Never guess what an unfamiliar vendor does without labeling it clearly as `[Needs verification]`.
- Never use em-dashes or emojis.

## Quick-Start Example

**Example Input:**
> Vendor list (monthly unless noted): Otter.ai Pro ($16.99 x 4 seats), Fireflies.ai ($19 x 2 seats), Grammarly Business ($180/yr x 5 seats), Jasper AI ($49/mo), Planning Center ($299/mo), Canva Teams ($300/yr), Loom Business ($15 x 3 seats), Unknown SaaS "DocSum" ($29/mo).

**Expected Behavior:**
Normalize all items to annual spend, flag Otter + Fireflies + DocSum + Jasper (and review Grammarly) as Consolidate Now / Overlap candidates totaling over $2,800/yr in potential recoverable spend, leave Planning Center and Canva in Keep, flag DocSum under Unknown/Consolidate, and output the clean decision table plus 14-day cancellation/export checklist.
