KPI Tree

Ramp logoRamp Integration

Turn Ramp spend data into a causal model of where money goes, why costs move, and who is accountable.

Ramp captures every corporate card transaction, reimbursement, bill payment, and budget allocation. KPI Tree connects to Ramp through the data warehouse where your Ramp exports already land, whether you pipe them in through Fivetran, Airbyte, or the Ramp Developer API. If you do not yet run a warehouse, our professional services team will build one for you around Ramp as the canonical spend system. Once connected, KPI Tree builds what no expense platform offers: causal metric trees that decompose total spend into departments, categories, and vendors, assign ownership at every level, and alert the right person when costs deviate from plan. Burn rate, CAC, spend per employee, vendor concentration, budget utilisation, each becomes a node in a tree with an owner, statistical monitoring, and a direct line to action. Expense data stops being a compliance exercise and starts driving financial accountability.

From expense data to owned spend trees

KPI Tree connects to Ramp through your data warehouse or a professional services build-out, so you can start building spend trees regardless of your data infrastructure maturity.

1

Connect your Ramp data

Two ways to get started, depending on your stack.

SnowflakeBigQueryDatabricks
Warehouse

Connect your existing warehouse where Ramp data already lands.

Fivetrandbt
Professional Services

Our professional services team can build you turn-key AI foundations in a matter of weeks. Data warehouse on Snowflake/BigQuery, ELT with Fivetran, all modelled in dbt with a semantic layer.

2

Define spend and efficiency metrics

Create metrics from your Ramp data - total spend, departmental spend, vendor spend, budget utilisation rate, spend per employee, expense-to-revenue ratio, reimbursement cycle time, card utilisation rate, and more. Write SQL against your existing tables or sync definitions from your dbt semantic layer.

3

Build spend trees and assign ownership

Arrange metrics into parent-child trees that model how they drive each other. Total spend decomposes into departments. Departmental spend decomposes into categories and vendors. Each node gets a RACI owner, statistical monitoring, and alerts. When SaaS spend spikes, the department head and procurement lead know immediately - with context on which vendors drove the increase.

Spend intelligence that goes beyond expense management

Ramp automates expense management. KPI Tree adds the analytical layer that connects spend metrics to business efficiency with causal structure and cross-functional ownership.

Spend decomposition trees by department, category, and vendor

Break total company spend into departments, then categories within each department, then vendors within each category. Each level is an owned metric with statistical monitoring. When total spend exceeds plan, you trace the tree to the specific department, category, and vendor that drove the overrun - and the person accountable for it.

Efficiency ratios connected to revenue metrics

Expense-to-revenue ratio, CAC, spend per employee, and cost per transaction become first-class metrics linked causally to your revenue tree. When headcount grows, you see how spend per employee changes relative to revenue per employee - connecting cost efficiency to business outcomes, not just budget targets.

Budget deviation alerts with causal context

When departmental spend exceeds its statistical baseline or budget target, the metric owner receives an alert with context: which categories drove the deviation, which vendors increased, and how the spend change correlates with headcount or revenue metrics. Not a generic "over budget" email - actionable intelligence.

Spend decomposition that reveals where every pound goes.

Ramp shows you transactions. KPI Tree models how they aggregate into a spend structure you can manage. Total spend decomposes into departments. Departmental spend decomposes into SaaS, travel, marketing, infrastructure, and whatever categories matter to your business. Each category decomposes into vendors. Every level is a metric with an owner, a baseline, and alerts. When total spend overshoots, you do not search transaction logs - you follow the tree to the department, category, and vendor that drove it, and the person responsible.

  • Total spend decomposed into departments, categories, and vendors
  • Each level is an owned metric with statistical baseline and alerts
  • Period-over-period comparison isolates which components drove changes
  • RACI ownership connects spend metrics to department heads and procurement
0:00

Efficiency metrics that connect cost to revenue outcomes.

Expense management platforms track whether you are over or under budget. KPI Tree asks a more useful question: is your spend efficient relative to your revenue? Expense-to-revenue ratio, CAC, LTV-to-CAC ratio, revenue per employee, and cost per acquisition sit in the same tree as your spend metrics. When marketing spend increases, you see whether CAC improved or degraded. When headcount grows, you see the impact on revenue per employee. Cost decisions connect to business outcomes in a single model.

  • Expense-to-revenue ratio, CAC, and revenue per employee as owned metrics
  • Spend changes linked causally to revenue and efficiency outcomes
  • Correlation analysis surfaces which cost categories drive the best returns
  • Period comparisons show efficiency trends as the business scales
Period-over-period comparison loading

Vendor spend analysis with ownership and trend detection.

SaaS sprawl, contract renewals, and vendor concentration risk hide in transaction data. In KPI Tree, vendor spend is a structured tree: top vendors by spend, growth rate per vendor, contract renewal timing, and vendor concentration index. When a vendor's monthly cost drifts upward, the owner of that vendor metric is alerted with statistical context. Procurement does not discover the problem at renewal time - they see the trend months earlier and act while leverage exists.

  • Top vendors tracked as individual metric nodes with ownership
  • Growth rate per vendor with statistical outlier detection
  • Vendor concentration index as a risk metric with alerts
  • Trend detection surfaces cost drift before contract renewal deadlines
Root cause analysis loading

Combine Ramp with revenue, headcount, and operational data.

Spend data is most valuable when it connects to everything else. Your warehouse also contains revenue from Stripe or Chargebee, headcount from your HRIS, pipeline data from Salesforce, and operational metrics from your product. KPI Tree builds trees across all of it. A single tree connects marketing spend to pipeline generated to revenue closed to CAC - with an owner at every stage. That cross-functional model turns expense data from a finance report into a company-wide efficiency tool.

  • Ramp spend metrics alongside revenue, headcount, and pipeline data
  • End-to-end efficiency modelling from spend to revenue outcome
  • Cross-tool correlation reveals which costs generate the best returns
  • Every metric carries ownership regardless of its data source

What KPI Tree adds that Ramp's analytics cannot

Ramp's analytics are built for expense management and policy compliance. KPI Tree is built for understanding how spend drives business outcomes and holding teams accountable.

causal · q < 0.05lag 3dq < 0.01Revenue-15%Conversion-23%Traffic+2%AOV-4%Checkout-31%PricingPaidOrganicBasket sizeDiscountsPayment errorsPage speed

Every source resolves onto one causal tree.

Causal spend trees, not expense reports

Ramp shows spend by category and department as flat reports. KPI Tree arranges them into parent-child trees that model how cost components drive total spend - so you trace root causes instead of reviewing transaction lists.

Cross-functional ownership of cost efficiency

Ramp's analytics live with finance. KPI Tree assigns RACI ownership across department heads, procurement, and leadership - because spend efficiency is an organisation-wide responsibility.

Spend connected to revenue outcomes

Ramp only sees expense data. KPI Tree correlates spend metrics with revenue, headcount, and pipeline data from every source in your warehouse to show whether costs are driving efficient growth or just growing.

Metrics you can track. Ready to add to your metric trees.

53 Ramp metrics, defined and ready to drop onto a tree.

Average Transaction Value

Expense Management

Average Transaction Value = Total Spend / Number of Transactions

Average transaction value measures the mean monetary amount per expense transaction processed through Ramp. It provides a baseline for identifying unusual spending patterns and understanding typical purchase behaviour.

View metric

Budget Adherence Rate

Expense Management

Budget Adherence Rate = (Categories Within Budget / Total Budget Categories) × 100

Budget adherence rate measures the percentage of budget categories where actual spending remains within the allocated amount. It quantifies organisational discipline in following financial plans.

View metric

Budget Utilisation Rate

Expense Management

Budget Utilisation Rate = (Actual Spend / Budget Allocation) × 100

Budget utilisation rate measures the percentage of allocated budget that has been spent within the current period. It shows spending velocity and helps predict whether budgets will be over or under-utilised.

View metric

Card Activation Rate

Expense Management

Card Activation Rate = (Cards with Transactions / Total Cards Issued) × 100

Card activation rate is the percentage of issued Ramp cards, both physical and virtual, that have been used for at least one transaction. It measures programme adoption and employee onboarding effectiveness.

View metric

Category Spend Analysis

Expense Management

Category spend analysis breaks down total expenditure by spend category such as software, travel, office supplies, and professional services. It reveals concentration, trends, and potential savings opportunities within each category.

View metric

Compliance Violation Rate

Expense Management

Compliance Violation Rate = (Violating Transactions / Total Transactions) × 100

Compliance violation rate is the percentage of transactions that breach company spending policies, including merchant restrictions, spending limits, or category prohibitions. It measures policy enforcement effectiveness.

View metric

Department Spend Analysis

Expense Management

Department spend analysis segments total expenditure by organisational department or team. It provides visibility into how each department uses its budget and enables comparison against plans and historical patterns.

View metric

Duplicate Payment Detection

Expense Management

Duplicate payment detection measures the number and value of potentially duplicated transactions identified across expense submissions and vendor payments. It quantifies recoverable waste in the payments process.

View metric

Employee Reimbursement Time

Expense Management

Reimbursement Time = Average (Payment Date - Submission Date)

Employee reimbursement time measures the average number of days between expense submission and reimbursement payment. It reflects the efficiency of the expense review, approval, and payment process.

View metric

Expense Approval Cycle Time

Expense Management

Approval Cycle Time = Average (Approval Date - Submission Date)

Expense approval cycle time measures the average duration from expense submission to final approval. It captures the speed and efficiency of the review and approval workflow.

View metric

Expense Per Employee

Expense Management

Expense Per Employee = Total Spend / Total Employees

Expense per employee divides total company spend by headcount to provide a normalised measure of spending intensity. It enables benchmarking across periods and against industry standards.

View metric

Maverick Spend Rate

Expense Management

Maverick Spend Rate = (Off-Contract Spend / Total Spend) × 100

Maverick spend rate is the percentage of total expenditure that occurs outside approved contracts, preferred vendors, or procurement channels. It represents spend that bypasses negotiated terms and volume discounts.

View metric

Merchant Concentration Analysis

Expense Management

Merchant concentration analysis measures the distribution of spend across vendors, identifying top merchants by volume and the degree of concentration. It reveals vendor dependency and negotiation opportunities.

View metric

Burn Rate

Expense Management

Monthly Burn Rate = Total Monthly Expenditure

Monthly burn rate is the total net cash expenditure per month, encompassing all operating expenses processed through Ramp. It is a critical metric for startups and growth-stage companies managing runway.

View metric

Out-of-Policy Spend Rate

Expense Management

Out-of-Policy Spend Rate = (Out-of-Policy Spend / Total Spend) × 100

Out-of-policy spend rate measures the percentage of total spend that falls outside company expense policies, including excessive amounts, unapproved categories, or non-compliant merchants.

View metric

Payment Cycle Time

Expense Management

Payment Cycle Time = Average (Payment Date - Invoice Date)

Payment cycle time measures the average duration from invoice receipt to vendor payment. It reflects accounts payable efficiency and impacts vendor relationships, early payment discounts, and working capital.

View metric

Receipt Compliance Rate

Expense Management

Receipt Compliance Rate = (Transactions with Receipts / Total Transactions) × 100

Receipt compliance rate is the percentage of transactions that have a matching receipt or supporting documentation attached. It measures adherence to documentation requirements essential for audit readiness and tax compliance.

View metric

Recurring Spend Analysis

Expense Management

Recurring spend analysis identifies and tracks expenses that repeat on a regular basis, including software subscriptions, service contracts, and regular vendor payments. It separates predictable from variable expenditure.

View metric

Savings Identification Rate

Expense Management

Savings Identification Rate = (Identified Savings / Total Spend) × 100

Savings identification rate measures the value of cost savings opportunities identified as a percentage of total spend. It captures how effectively the organisation discovers and acts on opportunities to reduce costs.

View metric

Spend by Vendor Analysis

Expense Management

Spend by vendor analysis ranks and examines expenditure at the individual vendor level. It shows total spend, transaction frequency, and trend for each vendor, enabling strategic vendor management.

View metric

Spend Forecast Accuracy

Expense Management

Forecast Accuracy = (1 - |Actual Spend - Forecasted Spend| / Forecasted Spend) × 100

Spend forecast accuracy measures the deviation between predicted and actual expenditure, expressed as a percentage. It evaluates the reliability of financial planning and budgeting processes.

View metric

Subscription Waste Detection

Expense Management

Subscription waste detection identifies recurring software and service subscriptions that are unused, underused, or duplicated across the organisation. It quantifies the recoverable value of optimising the subscription portfolio.

View metric

T&E Spend Ratio

Expense Management

T&E Spend Ratio = (Travel & Entertainment Spend / Total Spend) × 100

T&E spend ratio measures travel and entertainment expenses as a percentage of total company spend. It provides a benchmark for controlling discretionary spending and comparing against industry norms.

View metric

Total Spend Under Management

Expense Management

Spend Under Management = (Spend Through Ramp / Total Company Spend) × 100

Total spend under management measures the percentage of company expenditure that flows through Ramp and is subject to its controls, visibility, and reporting. It indicates programme coverage and control maturity.

View metric

Virtual Card Adoption Rate

Expense Management

Virtual Card Adoption Rate = (Virtual Card Transactions / Total Transactions) × 100

Virtual card adoption rate measures the percentage of transactions or spend volume processed through virtual cards rather than physical cards or reimbursements. Virtual cards offer tighter controls with vendor and amount restrictions.

View metric

Accounting Integration Accuracy

Expense Management

Accounting Integration Accuracy = (Correctly Synced Transactions / Total Synced Transactions) × 100

Accounting integration accuracy is the percentage of Ramp transactions that sync correctly to the general ledger without requiring manual adjustment. It reflects the reliability of automated category mappings, GL codes, and entity assignments between Ramp and the accounting system.

View metric

Bill Payment Cycle Time

Expense Management

Bill Payment Cycle Time = Average (Payment Execution Date − Bill Receipt Date)

Bill payment cycle time measures the average number of days from bill receipt to payment execution within Ramp Bill Pay. It captures the end-to-end efficiency of the accounts payable workflow, including approval routing and scheduling.

View metric

Card Spend Distribution

Expense Management

Card spend distribution breaks down total card expenditure by card type, covering physical, virtual, and department-level cards, and by spending band. It reveals how concentration or fragmentation of spend across card instruments affects control and visibility.

View metric

Expense Fraud Detection Rate

Expense Management

Expense Fraud Detection Rate = (Confirmed Fraudulent Transactions / Total Flagged Transactions) × 100

Expense fraud detection rate is the percentage of flagged transactions confirmed as fraudulent or policy-abusive relative to total transactions reviewed. It measures the effectiveness of both automated controls and manual review processes in identifying genuine threats.

View metric

Reconciliation Time

Expense Management

Reconciliation Time = Period-End Reconciliation Completion Date − Period Close Start Date

Reconciliation time is the total number of hours or days required to match Ramp transactions against general-ledger entries and bank statements at period end. It reflects the efficiency of automated matching rules and the volume of exceptions requiring manual resolution.

View metric

Spend Anomaly Detection

Expense Management

Spend anomaly detection measures the volume and value of transactions flagged as statistical outliers against historical spending patterns. It captures deviations in amount, frequency, merchant, or timing that warrant investigation.

View metric

Vendor Consolidation Savings

Expense Management

Vendor Consolidation Savings = Pre-Consolidation Category Spend − Post-Consolidation Category Spend

Vendor consolidation savings tracks the monetary value saved by reducing the number of suppliers serving the same spend category and shifting volume to preferred vendors with negotiated pricing. It quantifies the financial benefit of strategic vendor rationalisation.

View metric

Budget Variance Analysis

Finance

Budget Variance = Actual Spend - Budgeted Amount; Budget Variance % = (Actual Spend - Budgeted Amount) / Budgeted Amount x 100

Budget Variance Analysis measures the difference between the budget you set in Ramp and the actual spend Ramp records against it across card transactions, reimbursements and bill payments. It is expressed both as an absolute amount and as a percentage of the budget, broken down by department, project or spend category. Because Ramp ties every transaction to a budget at the point of authorisation, the variance reflects committed spend rather than spend reconstructed after the fact.

View metric

Card Fraud Detection Rate

Finance

Card Fraud Detection Rate = Fraudulent Transactions Caught Before Settlement / Total Fraudulent Transactions x 100

Card Fraud Detection Rate measures the share of fraudulent or unauthorised Ramp card transactions that are caught and blocked or flagged before they settle, rather than discovered after the fact. It draws on Ramp transaction data, including declined charges, locked cards, and disputes raised against virtual and physical cards. A high rate means Ramp controls and your finance review process are intercepting bad charges early.

View metric

Card Utilisation Rate

Finance

Card Utilisation Rate = Total Card Spend in Period / Total Issued Card Limits in Period x 100

Card Utilisation Rate measures the share of the total spending limit issued across your Ramp cards that is actually spent within a period. Using Ramp transaction and card limit data, it shows whether the limits you have assigned to people, teams and vendors match real spending behaviour. A low rate points to limits set far above need, while a rate near the cap signals teams that may be constrained.

View metric

Cash Flow Impact Analysis

Finance

Cash Flow Impact = (Settled Card Transactions + Bill Payments Made) - (Refunds + Statement Credits + Cashback Earned)

Cash Flow Impact Analysis measures the net cash that leaves the business through Ramp in a given period, combining settled card transactions and bill payments against any statement credits, refunds, and cashback returned. In Ramp, this draws on transaction settlement dates rather than authorisation dates, so the figure reflects when money actually moves rather than when a purchase was made. It separates committed spend from realised outflows so finance can see the true timing of cash leaving the business.

View metric

Cost Centre Efficiency Analysis

Finance

Cost Centre Efficiency = Output or Value Delivered by Cost Centre / Total Ramp Spend Allocated to that Cost Centre

Cost Centre Efficiency Analysis measures how much value each cost centre returns for the spend it consumes, using the department, team, and category labels Ramp applies to every card transaction and bill payment. In Ramp, every transaction carries a cost centre and an accounting category, so you can compare actual spend per cost centre against the output, revenue, or budget tied to that same group. A higher ratio means a cost centre converts its spend into more useful output, while a falling ratio signals waste or misallocation.

View metric

Department Spending Trends

Finance

Department Spending Trend = (Department Spend in Current Period - Department Spend in Prior Period) / Department Spend in Prior Period x 100

Department Spending Trends measures how total spend tagged to each department in Ramp changes across consecutive periods. It draws on Ramp card transactions, reimbursements, and bill payments that carry a department or cost-centre attribute, then compares period-over-period totals to surface the direction and pace of change. The metric tells you not just what each team spent, but whether that spend is rising, falling, or holding steady.

View metric

Duplicate Transaction Detection Rate

Finance

Duplicate Transaction Detection Rate = Duplicate Transactions Flagged Before Approval / Total Duplicate Transactions x 100

Duplicate Transaction Detection Rate measures the share of duplicate transactions in your Ramp data that are flagged before they are approved or reimbursed. Using Ramp card swipe records, bill payments, and reimbursement claims, a duplicate is a second transaction that matches an earlier one on vendor, amount, and date window. The rate captures how much of that duplication the team catches versus lets through to settlement.

View metric

Employee Spending Behaviour Analysis

Finance

Out-of-Policy Spend Rate per Employee = Out-of-Policy Transaction Value / Total Card Spend per Employee x 100

Employee Spending Behaviour Analysis examines how individual employees and teams spend across their Ramp cards, breaking transactions down by merchant category, frequency, average value and policy compliance. In the context of Ramp data, it draws on every card transaction, receipt and policy flag to show patterns such as repeat merchants, out-of-policy purchases and concentration of spend among a small group of cardholders. It turns raw transaction logs into a behavioural view that finance teams can act on.

View metric

Expense Categorisation Accuracy

Finance

Expense Categorisation Accuracy = Correctly Categorised Transactions / Total Categorised Transactions x 100

Expense Categorisation Accuracy measures the share of Ramp transactions assigned to the correct accounting category, general ledger code or department without later correction. In Ramp, each card swipe and bill is auto-coded by rules or suggestions, so this metric tracks how often that coding survives review unchanged. A high value means finance teams spend less time recoding spend and can trust category-level reporting straight from the data.

View metric

Location Based Spend Analysis

Finance

Location Based Spend Analysis = Sum of Ramp Transaction Amounts grouped by Location / Total Ramp Spend x 100

Location Based Spend Analysis breaks down Ramp transactions by the geographic location attached to each charge, whether that is the merchant city or country, the spending entity, or the cardholder office. In Ramp, every card swipe and bill payment carries merchant and entity metadata, so you can aggregate total spend per location and compare regions side by side. It turns a flat transaction feed into a map of where company money is actually being committed.

View metric

Monthly Spend Velocity

Finance

Monthly Spend Velocity = (Current Month Spend - Prior Month Spend) / Prior Month Spend x 100

Monthly Spend Velocity measures the rate of change in total company spend recorded in Ramp from one month to the next, expressed as a percentage. It draws on all card transactions, reimbursements, and bill payments captured in Ramp so finance can see whether outgoings are accelerating or slowing. A positive velocity means spend is growing month over month, while a negative figure means it is contracting.

View metric

Policy Violation Rate

Finance

Policy Violation Rate = Flagged Transactions in Period / Total Transactions in Period x 100

Policy Violation Rate measures the proportion of Ramp card and reimbursement transactions that breach a configured spend policy, such as exceeding a category limit, missing a required receipt, or falling outside an approved merchant. Ramp flags each violation against the policy rules attached to a card programme, so the metric reflects real enforcement gaps rather than estimates. It is usually tracked over a month and segmented by team, category, or individual cardholder.

View metric

Reimbursement Processing Time

Finance

Reimbursement Processing Time = Average of (Reimbursement Paid Date - Reimbursement Submitted Date) across all paid claims in the period

Reimbursement Processing Time measures the elapsed time between an employee submitting a reimbursement claim in Ramp and that claim being paid out. It captures the full lifecycle through Ramp, including manager approval, finance review and the payment run. A shorter time means employees are repaid faster and the finance team is clearing claims without bottlenecks.

View metric

Seasonal Spending Patterns

Finance

Seasonal Index for Period = Average Spend in Period across Years / Average Spend across All Periods x 100

Seasonal Spending Patterns measure how total spend captured in Ramp, across corporate cards and bill payments, varies in a repeating way across periods of the year. By aggregating Ramp transactions by month, quarter or season and comparing the same period across multiple years, you can isolate the recurring component of spend from one-off changes. It turns Ramp transaction history into a view of when your business reliably spends more or less.

View metric

Spend Category Analysis

Finance

Category Spend Share = Spend in Category / Total Spend x 100

Spend Category Analysis measures how total Ramp spend is distributed across expense categories such as software, travel, meals, advertising and office supplies. Ramp automatically categorises every card transaction and bill payment, so this metric reads directly from that categorised transaction data over a chosen period. It surfaces both the absolute spend per category and each category share of the total.

View metric

Spend Programme Effectiveness

Finance

Spend Programme Effectiveness = In-Policy Spend / Total Spend x 100

Spend Programme Effectiveness measures how well your Ramp spend programme keeps actual spending inside the budgets, card limits, and policies you have set. Using Ramp transaction, budget, and approval data, it captures the share of spend that lands within policy against the total spend flowing through your cards and bill payments. A high score means the controls you configured in Ramp are doing their job without constant manual intervention.

View metric

Transaction Volume Growth Rate

Finance

Transaction Volume Growth Rate = (Transactions This Period - Transactions Last Period) / Transactions Last Period x 100

Transaction Volume Growth Rate measures the period over period change in the number of transactions flowing through Ramp, including card swipes and bill payments. It is calculated from the count of settled transactions in each period rather than their value, so it reflects activity and frequency rather than spend size. Tracking it against Ramp data tells you whether your finance operations are scaling smoothly or whether transaction throughput is rising faster than the team can process and reconcile.

View metric

Vendor Concentration Risk

Finance

Vendor Concentration Risk = Spend on Top N Vendors / Total Spend x 100

Vendor Concentration Risk measures how much of your total spend in Ramp flows through a small number of vendors. Using Ramp transaction and bill payment records, it expresses the share of spend captured by your largest suppliers, so you can see whether your outflows depend on a narrow set of relationships. A high reading means a single vendor going down, raising prices, or changing terms would have an outsized effect on the business.

View metric

Vendor Diversification Index

Finance

Vendor Diversification Index = 1 - Sum of (Vendor Spend / Total Spend)^2

Vendor Diversification Index measures how evenly your spend is distributed across the vendors you pay through Ramp, rather than concentrated in a handful of suppliers. Using Ramp transaction and bill payment data tagged by merchant or vendor, it scores spend concentration so a high index reflects a broad, balanced supplier base and a low index flags dependency on a few vendors. It turns raw vendor-level spend into a single signal of supplier risk.

View metric

Vendor Payment Terms Analysis

Finance

Weighted Average Payment Terms = Sum of (Bill Amount x Net Terms in Days) / Total Bill Amount; Early Discount Capture Rate = Discounts Captured / Discounts Available x 100

Vendor Payment Terms Analysis examines the payment terms recorded against each vendor and bill in Ramp, comparing the terms you have negotiated (such as net 30, net 60, or early payment discounts) with how those bills are actually paid. It reveals whether the finance team is using the full credit period, capturing early payment discounts, or paying ahead of schedule without benefit. In Ramp, the source data sits in the Bill Pay records, vendor profiles, and invoice due dates.

View metric

Vendor Performance Scoring

Finance

Vendor Performance Score = (Cost Efficiency Weight x Cost Score) + (Reliability Weight x Reliability Score) + (Payment Behaviour Weight x Payment Score)

Vendor Performance Scoring is a composite rating that grades each supplier in Ramp using the transaction, bill, and payment records tied to that vendor. It blends signals such as total spend, payment cycle time, dispute and decline frequency, and budget adherence into a single comparable score. In the context of Ramp, the score is built entirely from the vendor records Ramp already captures across card spend and bill pay, so it reflects how a supplier actually behaves on your account rather than a self-reported rating.

View metric

Common questions

How does Ramp data reach KPI Tree?
Through the warehouse. Most finance teams already replicate Ramp to Snowflake, BigQuery, or another warehouse via Fivetran, Airbyte, or a lightweight custom job against the Ramp Developer API, and KPI Tree reads those tables in place so budgets, card transactions, vendors, and reimbursements flow into metric trees without any duplication. If you do not yet have that pipeline, our professional services team can build the warehouse, configure the ELT, and ship a dbt semantic layer for Ramp as a fixed-scope engagement. We are tracking the experimental Ramp MCP reference server in the ramp-public GitHub organisation but do not currently treat it as a production connection path, so if you need a live MCP integration today, warehouse-first is the route we recommend.
What Ramp metrics can I track?
Any metric computable from Ramp data in your warehouse: total spend, departmental spend, category spend, vendor spend, budget utilisation rate, spend per employee, expense-to-revenue ratio, reimbursement cycle time, card utilisation rate, vendor concentration index, and more. If it can be expressed as SQL against your Ramp tables, it can be a KPI Tree metric.
Can I track budget versus actual spend?
Yes. Define budget targets as metrics and track actuals against them. KPI Tree's period comparison and statistical monitoring will alert the metric owner when actual spend deviates from budget by more than the expected variance - at the department, category, or vendor level.
How long does setup take?
If your Ramp data is already in a warehouse, connecting KPI Tree takes under an hour, and teams with a dbt semantic layer can sync Ramp-derived metrics in one click. If you do not yet have a warehouse or an ELT pipeline, our professional services engagement typically takes a few weeks end-to-end and delivers a production data foundation plus the dbt models for spend, budgets, vendors, and card transactions.
Does KPI Tree replace Ramp?
No. Ramp handles corporate card management, expense policies, bill payments, and accounting integrations. KPI Tree serves a different purpose: modelling how spend metrics causally relate to each other and to business outcomes, assigning ownership, and creating accountability. Most teams use both.
Can I connect spend data to revenue metrics?
Yes. That is one of the core advantages. A single metric tree can include Ramp spend data alongside Stripe revenue, Chargebee subscription metrics, and Salesforce pipeline data. KPI Tree's correlation engine analyses relationships across all sources - showing whether increased spend in specific categories correlates with revenue growth.
Is my financial data secure?
KPI Tree connects to your warehouse, not directly to Ramp. Your warehouse security model - RSA key-pair authentication, service accounts, network policies - remains fully enforced. KPI Tree queries aggregated metric data, not individual transaction details or card numbers.
Do I need a dbt semantic layer?
No. You can define metrics directly with SQL against your Ramp warehouse tables. If you use dbt to model your financial data, KPI Tree can sync those metric definitions automatically via the dbt Cloud or dbt Core integration.

Your expense data should drive efficiency, not just track it.

Connect your warehouse to KPI Tree and turn Ramp spend data into causal metric trees with ownership, statistical analysis, and accountability that connects cost management to business outcomes.

Experience That Matters

Built by a team that's been in your shoes

Our team brings deep experience from leading Data, Growth and People teams at some of the fastest growing scaleups in Europe through to IPO and beyond. We've faced the same challenges you're facing now.

Checkout.com
Planet
UK Government
Travelex
BT
Sainsbury's
Goldman Sachs
Dojo
Redpin
Farfetch
Just Eat for Business