Q Recon
Payout Reconciliation Engine
Help Center / Import Data
MODULE 6 · DATA

Import Data

QRecon supports importing transaction data using either automatic synchronisation through connected providers or manual CSV file imports - use either method based on your workflow.

Part 9 - Bring in Data

9.1 - Auto sync (PayPal / Stripe)

Pull payouts directly from a connected PayPal or Stripe account.

  1. Open the workspace Dashboard, then the PayPal or Stripe view.
  2. Confirm the provider is Connected under Settings → Connections.
  3. Click Sync PayPal or Sync Stripe.
  4. Wait for Syncing… to finish; check Last sync and the payout list.
QRecon dashboard - Sync Stripe or Sync PayPal for automated reconciliation
Dashboard sync controls and Last sync.
QRecon Stripe and PayPal sync result summary
After sync - confirm payouts appear in the list.
💡
Note: PayPal sync loads bank withdrawals (transfers to your bank) since the workspace Reconciliation start date.
⚠️
Important: If Sync is disabled, connect the provider under Settings → Connections first.

9.2 - Manual CSV import

Use CSV when you do not have API access, or prefer statement files.

  1. Go to Import.
  2. Choose data source: PayPal Statement CSV or Stripe Statement CSV.
  3. Choose file → Validate CSV.
  4. Review validation (payout and transaction counts).
  5. Preview, then click Import.
QRecon CSV import - choose Stripe or PayPal data source for reconciliation
Select PayPal or Stripe statement CSV.
QRecon import validation before payout reconciliation
Validate, preview counts, then Import.
File Requirements
  • Keep all column headers unchanged.
  • Use the sample templates available on the Import page whenever possible.
PayPal CSV columns
Date Time Type Gross Fee Net Currency Transaction ID Description
Stripe CSV columns
Date ID Type Amount Fee Net Currency Description
← Account Mapping Next: Review Payouts →