Ramp + Orcabase

See where the money goes.

Sync Ramp through Fivetran and ask what you spend, on what and with whom, in plain words, next to the revenue that pays for it.

Get started How to connect

Synced by Fivetran
Syncs every 6 hours
No Fivetran account needed

AgentRamp connected

What did we spend on software last quarter?

Reading your Ramp data…

Software came to $9.4k last quarter, up 18%, and three tools make up half of it.

Two tools are billed on two different cards.
Software is now 14% of all card spend.
The biggest jump came from seats added in June.

Software spend by month, $k

How I got this· 4 steps

Looked at your Ramp transactions
Kept those in the software category
Grouped them by vendor
Compared the quarter with the one before

Example answer. Numbers are illustrative.

In plain words

How do I analyze company spend from Ramp?

Ramp records every card purchase, bill and reimbursement. Fivetran copies them into a database Orcabase hosts for you, next to your revenue and your books.

Ask what software costs you, which vendors you pay most, or how spend compares with revenue, and get the answer with a chart.

Ask in plain words

What you can ask about your Ramp data

The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.

Meet the data agent

What did we spend on software last quarter, by tool?
Which vendors did we pay most this year?
How much did each team spend last month?
Which subscriptions renew this month?
How much is waiting in reimbursements?
Which bills are due this week?
What did we spend on travel, month by month?
Show me spend by category next to revenue.

What comes in

Your Ramp data, ready to ask about.

A copy in a database Orcabase hosts for you, with its own folder for each app.

Card transactions

Every card purchase, with merchant, category, amount and who made it.

Bills

Bills and their payments, by vendor.

Vendors

Who you pay, and how much.

Reimbursements

Out-of-pocket spend your team claimed.

Departments and users

Who spends, and which team they belong to.

Purchase orders

What was ordered before it was billed.

Numbers worth defining

Define them once. Every answer agrees.

Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Ramp data.

How metrics work

Monthly spend
Card spend, bills and reimbursements, each month.
Software spend
Spend in the software category, by tool.
Spend per person
Monthly spend divided by active cardholders.
Spend as a share of revenue
Total spend divided by revenue, each month.

Dashboards to start with

Your Ramp numbers at a glance.

Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.

Spend

4 charts

Spend by category
Top vendors
Spend by team
Reimbursements waiting

Spend and revenue

3 charts

Spend as a share of revenue
Software spend by tool
Monthly burn

About dashboards

Better together

Ask across Ramp and the rest of your business.

The best questions need more than one app. The agent can pull from several sources for one answer.

“Does card spend match what’s in the books?”

Ramp + QuickBooks

“What share of revenue goes to software and tools?”

Ramp + Stripe

“Does the ad spend on our cards match what Google Ads reports?”

Ramp + Google Ads

How to connect

Connect Ramp, step by step.

1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Ramp. Pick the database to sync into.
2
Connect Ramp on Fivetran’s page
Click Authorize on Fivetran’s page and sign in to Ramp.
3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Ramp data.

What you’ll need

A Ramp login that can authorize apps, like an admin’s.
The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.

At a glance

How it connects: Synced by Fivetran
How fresh: Every 6 hours, as standard.
Where your data lives: A copy in a database Orcabase hosts for you, with its own folder for each app.
Who can set it up: An admin in your organization.
Your login: You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
Cost: Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.

Sync apps with FivetranStep-by-step, in the docs.

Questions

About Ramp and Orcabase

More in the docs: Sync apps with Fivetran

Does it include bills and reimbursements, or just cards?

All three: card transactions, bills and reimbursements come in, so you can see total spend in one place.

Can Orcabase make payments or change cards?

No. Orcabase only reads the synced copy of your spend.

Do I need a Fivetran account?

No. Orcabase uses its own. You sign in to Ramp on Fivetran’s page, and the data lands in a database Orcabase hosts for you, so there’s nothing else to set up or pay Fivetran for.

How fresh is my Ramp data in Orcabase?

Fivetran syncs it every 6 hours as standard, and an admin can run a sync by hand at any time. The page for each source shows when it last synced and when it syncs next.

What does syncing cost?

Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard. Each distinct row that’s added or changed in a month counts once, however often it changes, and the first full copy is free. You choose which tables sync, so you only spend the allowance on what you need.

Keep exploring

More data sources

All data sources

Your Ramp data already has the answers.

Connect it, ask your first question, and pin the answers you want to see every week.

Get started All data sources