skills.rest
ramp-public
ramp-publicOFFICIAL
Explore all skills by this author →
WebsiteGitHub

spend-analysis

Merge card transactions and bill payments into vendor spend totals.

45|6|Updated Mar 24, 2026
Search Tags:#transactions#pagination#refunds#cost-reporting#bills#spend-analysis#vendor-spend
One-click install
npx skills add https://github.com/ramp-public/ramp-cli --skill spend-analysis-ramp-public
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: spend-analysis
Source: https://github.com/ramp-public/ramp-cli/tree/main/src/ramp_cli/skills/spend-analysis
Command: npx skills add https://github.com/ramp-public/ramp-cli --skill spend-analysis-ramp-public

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It eliminates the manual effort of reconciling card charges and bill payments into a single, dated vendor spend view so you can quickly answer “how much did we spend” with clear totals and breakdowns.

Core Features & Use Cases

  • Card + bill spend aggregation: Pulls card transactions and bill payments (two separate APIs/resources) and merges them into vendor totals for a chosen time range.
  • Refund-aware totals: Includes negative transaction amounts as refunds and calls them out so your spend numbers are accurate.
  • Pagination and vendor-variant handling: Continues through pages using next_page_cursor and flags likely duplicates from non-normalized vendor names (e.g., “Delta Air Lines” vs “Delta Airlines”).
  • Use cases: SaaS review, spend reports by vendor/category/team (via vendor name filtering), and inference cost-style spend monitoring across card activity and paid bills.

Quick Start

Ask the agent to analyze spend for Figma between 2026-01-01 and 2026-04-01 and return a vendor breakdown that includes both card transactions and paid bill payments in machine-readable JSON by using the ramp spend-analysis skill with the date window you specify.

Frequently Asked Questions about spend-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I aggregate vendor spend across card transactions and bill payments for a specific date range?▼

Vendor spend aggregation combines card transactions and bill payments into merged totals for a chosen time range. The analysis queries both resources, paginates through all results, and produces a clear card-versus-bills breakdown.

How are refunds handled when calculating total vendor spend?▼

Refund handling incorporates negative transaction amounts as refunds and explicitly calls them out in the summary. This ensures your calculated vendor spend totals remain accurate and net of any returned funds.

What is the best way to reconcile card charges and bill payments into a single vendor spend view?▼

Reconciling card charges and bill payments merges data from two separate APIs into unified vendor totals. This eliminates manual reconciliation by producing dated summary tables with a comprehensive breakdown of all spend activity.

How does vendor spend analysis handle duplicate entries from non-normalized vendor names?▼

Vendor-name variant detection flags likely duplicates caused by non-normalized vendor names, such as "Delta Air Lines" versus "Delta Airlines." This identifies potential duplicate entries so you can review and consolidate vendor totals accurately.

Can I generate SaaS review or inference cost reports by filtering specific vendor names?▼

SaaS review and inference cost monitoring are supported by filtering vendor names during the spend analysis. The process paginates through all available transactions and bills, returning machine-readable vendor breakdowns for the specified date window.

Why does my vendor spend report show different totals for card transactions versus paid bills?▼

Vendor spend reports separate card transactions and bills because the source APIs provide amounts in different formats: currency strings for transactions and numeric dollars for bills. The skill parses both formats and merges them into accurate combined totals.

Related Skills

Explore More Finance & Accounting Skills→
AradotsoAradotso
4

stripe-link-cli

Retrieve one-time Stripe Link payment credentials for agent-driven checkouts.

Official
Advanced
EdytaKucharskaEdytaKucharska
3

infra-cost-assessment

Analyze cloud infrastructure costs and vendor lock-in risks from pricing pages or bills.

Community
Advanced
coreymaypraycoreymaypray
1

accounts-payable

Automate accounts payable workflows with Stripe invoicing and Supabase audit logs.

Community
Advanced
duhu2000duhu2000
4

spend-analysis

Analyze procurement spend data to identify cost-saving opportunities.

Community
Advanced