Stripe-Style Exports

Many PSP exports, including Stripe's transaction and payout CSVs, store amounts as minor units (for example, 1500 for 15.00 USD). The key difference from a typical bank export is that multiplier should be 1, not 100.

sources:
  stripe:
    file_pattern: "data/stripe/*.csv"
    parser:
      type: csv
      date_col: "created"
      date_layout: "2006-01-02"
      amount_col: "amount"
      multiplier: 1
      currency_col: "currency"
      ref_col: "id"
      name_col: "description"

Common adjustments

Three situations require adjusting the defaults above.

If the export date includes a timestamp, set date_layout to match the exact source shape (for example, "2006-01-02T15:04:05Z" for ISO 8601).

If the file contains multiple amount fields, choose the field that represents the value the bank or ledger reconciles against, typically the net settlement amount rather than the gross charge.

If fees are separate from the gross amount, reconcile against the settlement amount when comparing to a bank statement.