How to export transactions from Stripe for tracking transactions

How do I export transactions from Stripe for recording transactions?

You can export transactions from Stripe for recording transactions in your accounting system (e.g. Quickbooks or Xero) by following these steps:

  1. Login to your Stripe dashboard here: https://dashboard.stripe.com
  2. On the lefthand side click "Balance" and then "Transactions" underneath
  3. Click the "Export" button in the top right
  4. Underneath "Date Range" click the "Custom" radio button, and then enter your desired dates for the export
  5. In the "Columns" drop down select "All"
  6. Then click "Export"
  7. Once you have the spreadsheet open filter the top row with the column headers and sort the "Available On" column by "Ascending"
  8. Filter the "Type" column #2 by "payout" and then make all of those rows highlighted with the color fill tool
  9. Then re-filter the "Type" column #2 by "Select all" so that all of the rows are showing again
  10. That's it! Your sheet should look something like this below, where the highlighted rows are the "sum" of the white rows above.


How did we do?