AI Spend & ROI Tracker (Excel + Google Sheets)

You pay for a chat assistant, a coding copilot, an image tool, a transcription app, and a couple of API keys. Some of them earn their keep and some renewed while you weren't looking. The AI Spend & ROI Tracker puts every subscription and pay-as-you-go API bill in one workbook, turns it into a true monthly and annual number, and shows how much of it comes back as time saved, valued at your own hourly rate.

Add your tools, log the tasks they speed up (minutes saved and how often), and the Dashboard does the rest: spend by category, hours and money saved per month, ROI for each tool and overall, renewals coming up, and a cut-candidates list showing what you'd save per year by cancelling. API costs come from your own token counts and price-per-1M inputs, so the numbers stay right when providers change their pricing. It works in Excel and Google Sheets, comes with sample data you can clear in seconds, and takes about 5 minutes to set up.

What's included

• AI-Spend-ROI-Tracker.xlsx with 6 tabs:
  • Start Here: setup steps, colour key, how every number is calculated, FAQ
  • Dashboard: 9 KPI cards (monthly and annual spend, hours saved, value of time saved, overall ROI, net value, cost per hour saved, upcoming renewals, cut candidates), a spend-by-category chart, a top-10 cost vs value chart, a cut-candidates list, a category table, and ROI for every tool
  • Subscriptions: tool, plan, category, monthly/annual billing, price per seat, seats, owner, a Keep/Review/Cut dropdown, and automatic monthly and annual cost, next renewal date, days until renewal, ROI and status (100 rows)
  • API Usage: provider, model, project, input/output tokens, editable price per 1M tokens, other usage costs, and automatic monthly cost and ROI (50 rows)
  • Time Saved: task, tool dropdown, minutes saved, times per week, and automatic hours and value per month, plus a link check (200 rows)
  • Settings: hourly rate, currency symbol, ROI target, renewal alert window, editable categories
• Quick-Start-Guide.pdf: a one-page setup guide
• Realistic sample data, clearly labelled, that you can clear in a few seconds

Works in Microsoft Excel 2010 or newer and Google Sheets (File → Import). No macros, no add-ins, no sign-up.

Note: the API price fields are inputs you fill in from each provider's pricing page. The sample values are placeholders, not current price quotes.