Stripe Balance Transactions Export Sample Dataset

Stripe's Balance Transactions export from the Dashboard Reports panel is delivered as a UTF-8 CSV with exact production columns: id, created, currency, amount, fee, net, type, description, source, and reporting_category. This dataset contains 7,500 synthetic balance transaction records spanning charges, refunds, disputes, payouts, and adjustments — mirroring a high-volume SaaS billing environment. The critical Stripe accounting quirk is that all created timestamps are forced to UTC regardless of your dashboard timezone setting, and the amount and fee columns store values in the smallest currency unit (cents for USD). More dangerously, the sign convention inverts depending on type: for charge rows, amount is positive and fee is negative, but for refund and dispute rows, amount becomes negative while fee becomes positive (the fee is returned). Naive SUM aggregation across all transaction types double-counts fee reversals as additional charges. The structural dirty data inventory includes: 1,840 description fields containing unescaped commas that break delimiter-based parsers, 420 rows with embedded CRLF line breaks in multiline dispute descriptions, and missing UTF-8 BOM causing € and £ symbols to render as mojibake. Expected Output: Yields exactly 7,500 valid transactions with accurate net revenue figures. Ideal for: ETL testing, DuckDB demos, Power BI, Excel Power Query, CI pipelines. Load this file into the stripe-formatter tool to correctly net the fee reversals before building your P&L.