Skip to content

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
transactionsTransactions - gross amount, fee, net amount received, transaction type, invoice or order ID.
balancesBalances by currency at each point in time.
list_paymentsPayments created through the PayPal API.
list_disputesDisputes and their resolution status.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inClient ID, Client secret, Sandbox, Start Date
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2

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.

MetricDefinitionUnit
Payment feesMarketplace transaction fees and payment gateway fees, allocated to lines by line revenue.Currency
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Receivables collectedTotal value of receivable invoices collected, by collection date.Currency

Connect Paypal Transaction in 3 steps

  1. 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. 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. 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

Ask Si about your Paypal Transaction data →Paypal Transaction + WooCommerce →All data sources →

Connect Paypal Transaction and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes