Spent way too long manually trying to understand where our stripe money was going
a few months ago i exported our balance csv during tax season because the numbers in my head just weren’t matching what was actually landing in the bank account.
thought i messed up the spreadsheet at first.
after digging through transactions one by one i realized our real effective fee rate was way higher than the advertised 2.9% once you include stuff like:
- international cards
- cross-border fees
- currency conversion
- refunds
- random outlier transactions
the weirdest part was stripe technically shows all the data, but there’s no simple “here’s your actual blended fee rate” view anywhere. i ended up wasting hours in spreadsheets trying to piece it together manually.
so i built a small tool for myself that reads the stripe balance export and shows:
- real effective fee %
- biggest fee drivers
- suspiciously expensive transactions
- fee anomalies over time
right now mostly trying to figure out:
- what reports people actually care about
- whether founders care more about fees or failed payments
- if this is mainly useful for saas or also agencies/ecom/etc
would genuinely love feedback from other people using stripe heavily because i feel like most of us are kinda flying blind on the actual costs until finance/tax season hits 😅