Data Reference

payments

• One row per completed charge.
• Key fields: status, amount (minor units), currency, payment_method_type, customer_id, created_at.
• Notes: Filter by status = 'succeeded' for revenue analysis.

refunds

• One row per refund.
• Key fields: payment_id, amount, status, created_at.
• Notes: Join to payments for refund rates and net revenue views.

payouts

• Disbursements to your bank account.
• Key fields: amount, status, arrival_date.
• Notes: Combine with balance_transactions to reconcile net totals and fees.

balance_transactions

• Ledger of balance-affecting events.
• Key fields: amount, fee, net, type, available_on, created_at, source_id.
• Notes: The most reliable source for net/fee rollups and reconciliation.

customers

• Customer profile records.
• Key fields: email, name, phone, created_at.
• Notes: Join to payments for lifetime value and cohort analysis.

disputes (if available)

• Chargeback and dispute events.
• Key fields: payment_id, status, amount, created_at.
• Notes: Often reconciled later than real-time payments data.

Tips

• Use table-level freshness indicators in the editor to confirm update times.
• Column names and availability can vary by integration and plan.

Last updated: 2025-10-20