Subscription Creep Detector

What data it expects

Connect QuickBooks Online or drop a CSV / Excel export with a similar layout — the AI adapts the workflow if your columns differ.

How it works — every step, readable

1. 01Load GL detail (last 3 months)

   SELECT * FROM read_csv_auto('QBO_GeneralLedger.csv', header=true)

2. 02Monthly spend per vendor

   aggregates rows into summary totals · filters to the relevant rows

   SELECT name AS vendor, account, STRFTIME(TRY_CAST(date AS DATE), '%Y-%m') AS month, SUM(amount) AS spend
   FROM input_1 WHERE amount > 0 AND TRY_CAST(date AS DATE) IS NOT NULL GROUP BY 1, 2, 3

3. 03Recurring vendors only (every month)

   aggregates rows into summary totals · filters to the relevant rows

   WITH months AS (SELECT COUNT(DISTINCT month) AS n FROM input_1)
   SELECT vendor, account, month, spend FROM input_1
   WHERE vendor IN (
     SELECT vendor FROM input_1 GROUP BY vendor
     HAVING COUNT(DISTINCT month) = (SELECT n FROM months))

4. 04Recurring spend trend + growth

   combines data from multiple inputs · aggregates rows into summary totals · buckets values by condition

   WITH w AS (PIVOT (SELECT * FROM input_1) ON month USING SUM(spend) GROUP BY vendor, account),
   g AS (SELECT vendor,
     ROUND(100.0 * (MAX(CASE WHEN month = (SELECT MAX(month) FROM input_1) THEN spend END)
      / NULLIF(MAX(CASE WHEN month = (SELECT MIN(month) FROM input_1) THEN spend END), 0) - 1), 1) AS growth_pct
     FROM input_1 GROUP BY vendor)
   SELECT w.*, g.growth_pct FROM w JOIN g USING (vendor) ORDER BY g.growth_pct DESC