Question 1

Why do Shopify and Stripe CSVs break when exported in bulk?

Accepted Answer

Bulk exports frequently contain malformed rows from partial refunds, chargebacks, or cross-currency settlements. Shopify's CSV adds commas inside product-variant names. Stripe includes nested JSON in metadata columns. Both break naive comma-split parsers.

Question 2

What is a healthy fee ratio for ecommerce transactions?

Accepted Answer

The 2026 ecommerce benchmark is 3–5% of gross revenue for payment processing fees. Shopify Payments charges 2.9% + $0.30. Stripe charges 2.9% + $0.30. PayPal charges 3.49% + $0.49. A fee ratio above 5.5% signals a leak — often from currency conversion, chargebacks, or redundant gateway fees.

Question 3

How do hidden operational fees erode profit margins?

Accepted Answer

Beyond payment processing, merchants absorb: refund processing fees (Stripe charges $0.05 per refund), chargeback fees ($15–$25 each), currency conversion spreads (1–2%), subscription app fees ($10–$50/month), and return shipping subsidies. These compound silently to 8–12% of gross revenue.

Question 4

Can I use this tool for bank statement CSVs?

Accepted Answer

Yes, but financial advisory depends on column headers. If your CSV uses 'amount', 'debit', 'credit', or 'fee', the sanitizer will detect and categorize. For best results, ensure one column per transaction type and consistent currency symbols.

Question 5

What does the pie chart tell me about my business health?

Accepted Answer

The pie chart splits revenue from hidden operational fees. If the fee wedge exceeds 8%, your business is bleeding margin. Healthy ecommerce operators maintain fees below 5% of gross. The sanitizer flags where your leakage is coming from.

Question 6

How often should I run a CSV audit?

Accepted Answer

Monthly is the minimum defensible cadence for active merchants. Weekly for high-volume stores (1000+ transactions/month). A quarterly audit is insufficient — most fee leaks compound invisibly and only surface after 60–90 days of accumulation.

Question 7

Is my financial data secure when using this sanitizer?

Accepted Answer

100% browser-side. The CSV is parsed with JavaScript FileReader API. No upload occurs. No server sees your revenue numbers. The sanitized CSV is generated entirely in your browser and downloaded directly to your device.

Financial CSV Sanitizer & Leakage Detector

Revenue vs Fee Breakdown

CSV Sanitization & Profit Leakage Questions

Command Palette