Finance and payments
Connect Paypal Transaction to DataxLand
The PayPal connector reads transaction history, balances, payments and disputes from a PayPal business account. Each transaction carries the gross amount, the PayPal fee and the net amount received, so DataxLand separates the real payment fee from revenue. For stores that take payments from overseas customers through PayPal on a WooCommerce or Shopify website, Si joins PayPal transactions to orders so the payment fee lands in the contribution margin of the right order, instead of sitting on its own in a statement.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Paypal Transaction
- See how much of each month's revenue goes to PayPal fees.
- Reconcile the net amount received from PayPal with the net revenue of website orders.
- Track disputes and refunds by month.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| transactions | Transactions - gross amount, fee, net amount received, transaction type, invoice or order ID. |
| balances | Balances by currency at each point in time. |
| list_payments | Payments created through the PayPal API. |
| list_disputes | Disputes and their resolution status. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Client ID, Client secret, Sandbox, Start Date |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Payment fees | Marketplace transaction fees and payment gateway fees, allocated to lines by line revenue. | Currency |
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Receivables collected | Total value of receivable invoices collected, by collection date. | Currency |
Connect Paypal Transaction in 3 steps
- 1
Create a REST API app
In the PayPal Developer Dashboard, create an app in Live mode, copy the Client ID and Client secret, and enable Transaction Search read access for the app.
- 2
Add the source
In the workspace choose Add source, find Paypal Transaction in the connector library, enter the Client ID, Client secret and start date, turn off Sandbox, then click Test connection.
- 3
Choose streams and review
Pick transactions and balances (transactions load incrementally); Si proposes how transactions join orders, and you approve before the build.
Limits and caveats
- PayPal only returns transaction history within the time range its API allows, and new transactions can appear a few hours late.
- Fees go into per-order margin when there is an order ID to join on; transactions without one still count toward total payment fees.
- This is an Airbyte connector (ELv2 license) run inside DataxLand; a paid plan is required.
Frequently asked questions
Does DataxLand send money or issue refunds on PayPal?
No. DataxLand only reads transactions.
Can I use a personal account?
You need a business account to create a REST API app.
Is payer information stored?
Payer personal-data columns (email, name) are hashed on load and never returned through dashboards, the API or MCP.
Dashboard templates that use this source
Connect Paypal Transaction and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes