Disclaimer: recent changes to Stripe's export process have broken this project. Anyone wishing to use this code will have to fix it. Look at the WIP-updates branch for initial work that has been done, and check out the issue tracker for the correct formulas to compute the right sums of the fees, charges/etc.
A small command line utility that converts the Stripe transfer exports (CSV) to the OFX file format often used by accounting software for bank statement imports.
For each charge transaction:
- It creates a credit transaction for the charged amount
- It creates a debit transaction for the fees
For each refund transaction:
- It creates a debit transaction for the refunded amount
- It creates a credit transaction for the refunded fees
At the end it creates a transfer of the whole net value to your bank account.
It lets you treat your Stripe account as if it was a real bank account in your accounting software and reconcile the individual transactions against invoices, credit notes, and bank fees.
When the money gets deposited into your bank account as a lump sum you can explain the transaction as a transfer from your "Stripe account".