As you know, one of the most important requirements to correctly carry out your accounting is to have access to the bank statements of all the company’s accounts for bank reconciliation. This includes payment gateways like Stripe.
This statement must contain all the movements, not only the payments received but the withdrawal of funds after your bank account, possible refunds, etc.
In this article, we explain how to download the correct Stripe bank statement and submit it to Companio.
How to get the bank statements of Stripe for your invoice reconciliation, step by step
First, log into your Stripe account. In the menu on the left, choose the “Balances” option.
Then click on “Transactions”. You will see all the latest transactions, including all payments received, withdrawal of funds to bank accounts, refunds, etc.
Now click on the button at the top right that says “Export”.
In the pop-up window, click on “UTC” for the time zone, “Previous month” for the Data range, and “All columns” for the columns to display.
Then a CSV file will be downloaded.
Uploading the bank statement to Companio
This CSV file is the one you must upload to Companio. Just click on the “Bank statements” option on the left menu. Then use the “Upload” blue bottom at the top right.
Then choose “STRIPE” in the Choose Bank dropdown. You should have linked your Stripe account previously.
Now you should click on “CSV / Excel Upload” and choose the file downloaded previously. You don’t need to upload an extra PDF file. Just click on “Upload”. If the file is correct and contains valid transactions, they should be added now to the list bank movements. Otherwise, please check the instructions again, the file should contain a series of transactions with an identifier that starts with txn_.
In this article, we show how in a few simple steps, and in less than a minute, you can download the Stripe bank statement for bank reconciliation as part of your company’s accounting.