PayPal + Orcabase
See what PayPal really brings in.
PayPal’s reports are hard to line up with the rest of your sales. Sync your PayPal transactions through Fivetran and ask what came in, what went back and what the fees cost, right next to your store and your other payment tools.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
How much came in through PayPal last month, after fees?
PayPal brought in $6.9k in August, 14% of revenue, and kept $312 in fees.
- That’s 4.5% of PayPal sales, against 3.1% on Stripe.
- Small one-time orders pay the most in fees, proportionally.
- PayPal sales dipped with one-time orders after free shipping ended.
PayPal sales by month, $k
How I got this· 4 steps
- Looked at your PayPal transactions
- Separated sales, refunds and fees
- Compared the fee rate with Stripe’s
- Split PayPal sales by order size
Example answer. Numbers are illustrative.
In plain words
How can I report on PayPal transactions?
Fivetran copies your PayPal transactions into a database Orcabase hosts for you: every payment, refund and fee, with its currency and status. Then you ask in plain words, like “how much did PayPal bring in last month, after fees?”
Because it sits next to your store and your other payment tools, you can finally see total revenue across all of them in one chart.
Ask in plain words
What you can ask about your PayPal data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
How much did PayPal bring in each month this year?
What share of our revenue comes through PayPal?
How much did PayPal fees cost us last quarter?
Which customers pay with PayPal most often?
How much did we refund through PayPal last month?
Do PayPal buyers spend more or less per order?
How much came in from each country?
Show me PayPal and Stripe revenue side by side.
What comes in
Your PayPal data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Sales
Refunds
Fees
Buyers
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 PayPal data.
PayPal revenue
PayPal payments minus refunds, by the day they were paid.
Fee rate
PayPal fees as a share of PayPal sales.
Share of revenue
PayPal revenue as a share of revenue across all your payment tools.
Refund rate
Refunded PayPal amount as a share of PayPal sales.
Dashboards to start with
Your PayPal numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
PayPal
4 charts- Sales by month
- Fees and fee rate
- Refunds
- Top countries
All payments
3 charts- Revenue by payment tool
- Fee rate by tool
- Share of revenue
Better together
Ask across PayPal and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect PayPal, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for PayPal. Pick the database to sync into.
- 2
Connect PayPal on Fivetran’s page
Fivetran’s page asks for the client ID and secret of a PayPal app, which you create in PayPal’s developer dashboard. Fivetran’s guide shows which permissions it needs.
- 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 PayPal data.
What you’ll need
- A PayPal business account, and access to PayPal’s developer dashboard to create an app.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- 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.
Why do I need to create a PayPal app?
Can Orcabase move money in my PayPal account?
Do I need a Fivetran account?
How fresh is my PayPal data in Orcabase?
What does syncing cost?
Your PayPal data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.