/stripe-csv-to-qbo

Converts CSV exports from Stripe to a CSV format that QuickBooks Online understands.

Primary LanguagePythonMIT LicenseMIT

stripe-csv-to-qbo

Converts CSV exports from Stripe to a CSV format that QuickBooks Online understands.

Stripe Download

  1. In your Stripe account, browse to the 'Reports' → 'Balance change from activity' page.
  2. Click download and select all columns.

Convert

  1. 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 named StripeQuickBooksOutput[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).

QuickBooks Online Upload

  1. In your Quickbooks Online account, go to the account you want to import transactions into.
  2. Click the arrow next to the "Update" button in the upper right and select "File Upload".
  3. Click the Browse button and find the StripeQuickBooksOutput[num].csv file generated above.

Other

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