Converts CSV exports from Stripe to a CSV format that QuickBooks Online understands.
- In your Stripe account, browse to the 'Reports' → 'Balance change from activity' page.
- Click download and select all columns.
- Run
python stripe2qbo.py payments.csv
(note that if you have multiple CSV files from Stripe you can add/specify them all). The script will output a file namedStripeQuickBooksOutput[num].csv
. If the number of transactions are greater than 999 it will create multiple output files as QBO only allows CSV imports of up to 1000 lines (headers + 999 transactions).
- In your Quickbooks Online account, go to the account you want to import transactions into.
- Click the arrow next to the "Update" button in the upper right and select "File Upload".
- Click the Browse button and find the
StripeQuickBooksOutput[num].csv
file generated above.
Inspired by https://github.com/iandees/csv-to-qbo
Tested and working with UK Stripe/Quickbooks accounts.
See also a Paypal version https://github.com/deanbarrow/paypal-csv-to-qbo