All recipes
Finance View

Spend by vendor trend

Vendor concentration dashboard — top vendors by spend, week-over-week movement, contract overlap detection.

Eluu — Spend by vendor trend
Shown in preview
Ramp QuickBooks Google Sheets
Runtime ~3 min
Tokens ~14K
Owner a finance ops colleague

Works with

Pick whichever tool your team already uses.

  • Spreadsheet
    Google Sheets Excel Airtable
  • Accounting
    QuickBooks Xero NetSuite
Ramp Card transactions
QuickBooks
QuickBooks Invoice payments
Google Sheets
Google Sheets Merge + analyze

What it does

Finance ops needs to see vendor concentration changes the moment they happen — not at the end of the quarter when a single vendor has already blown out the SaaS line. This recipe merges Ramp card spend with QuickBooks invoice payments, computes per-vendor week-over-week movement, and flags overlapping SaaS tools in the same capability so finance can consolidate before the next renewal.

How it works

  1. Pull card spend. Ramp transactions for the last 30 and prior 30 days, with merchant + spender context.
  2. Pull invoice spend. QuickBooks invoice payments in the same window, normalized to the same vendor names.
  3. Analyze. Merge sources, compute per-vendor totals + w/w deltas, flag any vendor with >30% movement, and detect overlapping tools in the same capability (e.g., two analytics SaaS subscriptions).

Setup

  • Connect a spend tool (Ramp or Brex).
  • Connect an accounting tool (QuickBooks, Xero, or NetSuite).
  • Connect a spreadsheet for the audit trail (Google Sheets, Excel, or Airtable).

Variations

  • Add a Slack alert when any vendor crosses a “monthly cap” you define.
  • Layer in cost-center attribution to show which team owns each spike.
  • Export a consolidation memo when 3+ overlaps are detected in the same capability.