Quantive Insight Quantive Insight
Free public demo

Stripe2Books sample

Free public demo with anonymized sample data. Not for QuickBooks import.

Back to Stripe2Books offer

Sample Stripe export (CSV)

id,Created (UTC),Amount,Amount Refunded,Currency,Captured,Converted Amount,Converted Currency,Conversion Rate,Decline Reason,Description,Fee,Net,Refunded Application Fee,Is Link,Mode,PaymentIntent ID,Payment Source Type,Statement Descriptor,Status,Seller Message,Taxes On Fee,Card ID,Customer ID,Customer Description,Customer Email,Invoice ID,Transfer
ch_1QanonPay0001AAAA,2025-11-03 14:22:11,149.00,0.00,usd,true,149.00,usd,1.0,,Subscription — Acme Starter,4.62,144.38,0.00,false,live,pi_3QanonPay0001AAAA,card,ACME*STARTER,Paid,Payment complete.,0.00,card_1QanonAAAA,cus_anon0001,Acme Retail LLC,buyer1@example-anon.test,in_1QanonInv0001,
ch_1QanonPay0002BBBB,2025-11-04 09:01:44,49.00,0.00,usd,true,49.00,usd,1.0,,One-time setup fee,1.72,47.28,0.00,false,live,pi_3QanonPay0002BBBB,card,ACME*SETUP,Paid,Payment complete.,0.00,card_1QanonBBBB,cus_anon0002,Beta Foods Inc,buyer2@example-anon.test,,
ch_1QanonPay0003CCCC,2025-11-05 18:40:02,320.50,0.00,usd,true,320.50,usd,1.0,,Invoice INV-8841,9.59,310.91,0.00,false,live,pi_3QanonPay0003CCCC,card,ACME*INV8841,Paid,Payment complete.,0.00,card_1QanonCCCC,cus_anon0003,Gamma Labs,buyer3@example-anon.test,in_1QanonInv0003,
ch_1QanonPay0004DDDD,2025-11-06 12:15:33,75.00,75.00,usd,true,75.00,usd,1.0,,Workshop seat (later refunded),2.48,72.52,0.00,false,live,pi_3QanonPay0004DDDD,card,ACME*WORKSHOP,Paid,Payment complete.,0.00,card_1QanonDDDD,cus_anon0004,Delta Studio,buyer4@example-anon.test,,
ch_1QanonPay0005EEEE,2025-11-07 08:05:19,12.00,0.00,usd,true,12.00,usd,1.0,,Metered overage Nov,0.65,11.35,0.00,false,live,pi_3QanonPay0005EEEE,card,ACME*OVERAGE,Paid,Payment complete.,0.00,card_1QanonEEEE,cus_anon0005,Epsilon Co,buyer5@example-anon.test,,

Sample cleaned CSV (Amount / Fee / Net)

Date,Description,Amount,Fee,Net,Currency,Stripe ID,Customer,Status
2025-11-03,Subscription — Acme Starter,149.00,4.62,144.38,usd,ch_1QanonPay0001AAAA,buyer1@example-anon.test,Paid
2025-11-04,One-time setup fee,49.00,1.72,47.28,usd,ch_1QanonPay0002BBBB,buyer2@example-anon.test,Paid
2025-11-05,Invoice INV-8841,320.50,9.59,310.91,usd,ch_1QanonPay0003CCCC,buyer3@example-anon.test,Paid
2025-11-06,Workshop seat (later refunded),75.00,2.48,72.52,usd,ch_1QanonPay0004DDDD,buyer4@example-anon.test,Paid
2025-11-07,Metered overage Nov,12.00,0.65,11.35,usd,ch_1QanonPay0005EEEE,buyer5@example-anon.test,Paid