Focused Use Case
Convert Stripe Charges JSON to CSV for reconciliation
Turn Stripe Charges API responses into a clean CSV with gross, fees, and net totals.
The problem
Stripe Charges data is nested and not spreadsheet-friendly. Finance teams need a flat CSV to reconcile revenue, fees, refunds, and payouts.
The outcome
Reconciliation-ready CSV
Gross, fees, refunds, net.
Clean charge list
Charge id, status, customer, created date.
Step-by-step
- Copy the JSON from the Stripe Charges API.
- Paste it into the converter.
- Preview, reorder columns, and export to CSV.
Tip: Keep fields like amount, fee, and net for reconciliation.
Example JSON (trimmed)
Paste this JSON into the converter:
Sample response
[
{
"id": "ch_1P4nKc2eZvKYlo2C7Qd1vPZ0",
"created": "2026-03-12T10:05:00Z",
"currency": "usd",
"amount": 12000,
"amount_refunded": 0,
"status": "succeeded",
"payment_method_details": { "type": "card", "card": { "brand": "visa", "last4": "4242" } },
"balance_transaction": { "fee": 348, "net": 11652 },
"customer": { "email": "renee@example.com" }
},
{
"id": "ch_1P4nKd2eZvKYlo2C2q6jNqvM",
"created": "2026-03-13T14:22:00Z",
"currency": "usd",
"amount": 3900,
"amount_refunded": 500,
"status": "succeeded",
"payment_method_details": { "type": "card", "card": { "brand": "mastercard", "last4": "4444" } },
"balance_transaction": { "fee": 143, "net": 3257 },
"customer": { "email": "alex@example.com" }
}
]
After import, keep columns like id, created,
amount, amount_refunded, and balance_transaction.net.
Reconciliation checklist
- Group charges by day or payout period.
- Sum amount for gross revenue.
- Sum balance_transaction.fee for fees.
- Sum balance_transaction.net for net revenue.
FAQs
Does it handle nested fields?
Yes, nested objects are shown inline.
Can I export to Excel too?
Yes, you can export to CSV or Excel.
Do you store the data?
No, data is processed temporarily and removed automatically.
Convert Stripe charges now
Paste your Stripe Charges JSON and export a CSV in seconds.