INVOICE PROCESSING

Monthly recurring-vendor cost drift report

On the first of each month, aggregates every recurring vendor's spend trend from BigQuery, ranks the biggest month-over-month movers.

CategoryInvoice Processing
Enginesim
Difficultyintermediate
Triggerschedule
Steps5
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonthly report schedule
  • ActionAggregate per-vendor recurring spendGoogle BigQueryBigQuery
  • LogicRank top month-over-month movers
  • ActionWrite drift report to NotionNotionNotion
  • OutputPost top-movers summary to FinOpsSlack

What it does

Gives finance a single monthly view of how recurring-vendor spend is drifting. It rolls up each vendor's charges, computes month-over-month and trailing-quarter changes, and ranks the vendors whose costs are creeping up the fastest so budget conversations are driven by data.

When to use it

Use this for the monthly AP or FinOps review when you want one report that answers "which subscriptions are quietly growing" rather than reacting to one invoice at a time. Good for spotting slow creep that per-invoice alerts miss.

How it works

  1. 1A monthly schedule fires on the first business day.
  2. 2The flow queries BigQuery for per-vendor recurring spend across the trailing periods.
  3. 3It computes month-over-month and quarter-over-quarter deltas and ranks the top movers.
  4. 4The ranked drift table is written to a Notion page for the finance workspace.
  5. 5A summary with the top five increasing vendors is posted to the FinOps Slack channel linking the full report.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect BigQueryDatasets, queries, schemas.
  2. 2
    Connect NotionPages, databases, comments.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.