Analyzes bank CSV exports to audit subscriptions and optimize credit card reward placement. Built for Claude Code, it flags missed credits, detects price increases, and tracks renewal dates.
git clone https://github.com/cathrynlavery/spend-optimizer.gitSpend Optimizer is a Claude Code skill that parses bank and credit card transaction CSV exports to surface recurring charges, identify unused subscriptions, and recommend the best card for each spending category. It includes reward structures for 30+ credit cards and flags missed statement credits—such as Disney+ or Uber—that cardholders are entitled to but haven't claimed. The skill detects price increases on existing subscriptions, tracks annual renewal dates, and monitors category spending caps like the $150K annual limits on Amex and Chase rewards programs. It also ships with cancellation URLs for 50+ services, making it straightforward to act on audit findings. Anyone looking to reduce subscription waste or get more value from premium travel and rewards cards will benefit from this skill.
[{"step":1,"action":"Export your bank transaction data as a CSV file (ensure it includes merchant names, categories, and transaction amounts).","tip":"Most banks allow CSV exports from their online portal. Filter for the last 12 months to capture annual spending patterns."},{"step":2,"action":"Run the spend-optimizer skill in Claude Code by pasting the prompt template and replacing [BANK_CSV_EXPORT] with your file path (e.g., 'transactions_2023.csv').","tip":"Use `cd /path/to/your/files` in Claude Code to navigate to the directory containing your CSV file before running the command."},{"step":3,"action":"Review the AI-generated report and prioritize the recommendations based on your spending patterns and renewal timelines.","tip":"Focus on high-spend categories first (e.g., office supplies, travel) where small changes in reward rates yield big gains."},{"step":4,"action":"Upload the report to Sortd’s kanban board under a \"Finance\" pipeline. Create tasks for each action item (e.g., 'Apply for Citi Custom Cash Card') and assign them to the appropriate team member.","tip":"Use Sortd’s 'Task' view to track progress and set deadlines for each task. Add labels like 'Renewal' or 'Card Application' for easy filtering."},{"step":5,"action":"Set calendar reminders in Sortd for renewal dates and follow up on negotiations. Update the kanban board weekly to reflect progress.","tip":"Use Sortd’s 'Calendar View' to visualize deadlines and ensure nothing falls through the cracks."}]
Find all recurring charges hidden in months of bank transaction exports
Identify which credit card to use for each merchant to maximize rewards
Flag unclaimed statement credits for services like Disney+ or Uber
Detect subscription price increases since the original sign-up
No install command available. Check the GitHub repository for manual installation instructions.
git clone https://github.com/cathrynlavery/spend-optimizerCopy the install command above and run it in your terminal.
Launch Claude Code, Cursor, or your preferred AI coding agent.
Use the prompt template or examples below to test the skill.
Adapt the skill to your specific use case and workflow.
Analyze the [BANK_CSV_EXPORT] file to optimize credit card reward placement and subscription spending. Identify [NUMBER] missed cashback opportunities, flag any price increases on subscriptions, and calculate potential annual savings if rewards are optimized. Prioritize recommendations based on [CRITERIA: e.g., highest spend categories, annual renewal dates]. Provide a summary table with current vs. optimized reward earnings for each card.
### Spend Optimization Report for Acme Corp (October 2023) **Executive Summary:** Acme Corp currently earns **$2,450/year** in credit card rewards but is missing **$890/year** in potential cashback by not optimizing reward placement. The analysis identified 3 missed opportunities, 1 price increase, and 2 subscription renewals due within 30 days. **Key Findings:** 1. **Missed Cashback Opportunities:** - **Amazon Business (Spend: $12,450/year):** Currently earning 1% cashback on a Chase Ink Business Preferred card. Should be moved to an Amex Business Gold card for 4% cashback in the first $150k spend category (Office Supplies). *Potential annual gain: $373.50* - **Office Depot (Spend: $8,200/year):** Currently on a flat 2% cashback card. Should be moved to a Citi Custom Cash card for 5% cashback in office supply stores. *Potential annual gain: $246.00* - **Delta Airlines (Spend: $6,800/year):** Currently earning 2x points on a personal card. Should be moved to a Delta SkyMiles Reserve Business card for 3x points on Delta purchases. *Potential annual gain: $204.00* 2. **Price Increases Detected:** - **Slack Pro Plan:** Increased from $12.50/user/month to $15/user/month on October 1st. *Annual impact: +$240* - **Recommendation:** Downgrade to Slack Free plan or negotiate with sales rep for legacy pricing. 3. **Renewals Due in 30 Days:** - **QuickBooks Online Plus:** Renews November 15th. Current spend: $499/year. *Recommendation:* Downgrade to Essentials plan ($299/year) if features are not fully utilized. - **Mailchimp Premium:** Renews November 5th. Current spend: $1,200/year. *Recommendation:* Switch to Standard plan ($720/year) if email volume has decreased. **Optimized Reward Summary:** | Card | Current Annual Rewards | Optimized Annual Rewards | Potential Gain | |--------------------------|------------------------|--------------------------|-----------------| | Chase Ink Business Preferred | $1,245 | $1,618.50 | +$373.50 | | Amex Business Gold | $0 | $498 | +$498 | | Citi Custom Cash | $164 | $410 | +$246 | | Delta SkyMiles Reserve | $136 | $204 | +$68 | | **Total** | **$1,545** | **$2,730.50** | **+$1,185.50** | **Action Items:** 1. Contact Chase to request a product change to Amex Business Gold for Amazon Business spend. 2. Apply for Citi Custom Cash card and update Office Depot autopay. 3. Schedule calls with Slack and QuickBooks sales reps to negotiate pricing before renewal dates. 4. Set a calendar reminder for November 1st to review Mailchimp plan usage and downgrade if needed. **Next Steps:** - Upload the [BANK_CSV_EXPORT] file to Sortd’s kanban board under the "Finance" pipeline. - Assign the "Slack Price Increase" task to the Finance team lead. - Create follow-up tasks in Sortd for each card application and renewal negotiation.
AI assistant built for thoughtful, nuanced conversation
Get more done every day with Microsoft Teams – powered by AI
Automate security compliance and monitor real-time security posture seamlessly.
Automate your spreadsheet tasks with AI power
Agentic AI Workflow platform
Connected workspace for docs, wikis, and projects
Take a free 3-minute scan and get personalized AI skill recommendations.
Take free scan