How to Download the Bank Statements of Stripe for Your Accounting and Your Annual Report?
As you know, one of the essential requirements for accurately managing your accounting is to obtain access to complete bank statements of all the company's accounts, including 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 will guide you through the steps you must follow.
First, log into your Stripe account. In the menu on the left, choose “Payments” and then “All transactions”. Now click on the “Export” button on the top right.
You will see a dialogue box. This step varies depending on whether you need it for monthly accounting or to prepare your annual report:
If it is for monthly accounting, in the appearing dialogue box, choose "UTC" as the time zone, "Last month," and "All columns." Click on the "Export" button. A CSV file will be downloaded.
If it is for the annual report, in the appearing dialogue box, choose "UTC" as the time zone, "Custom," and "All columns." Click on the "Export" button. A CSV file will be downloaded. Select January 1st of the financial year of the report as the start date, and then choose December 31st of the same year as the end date.
Now, navigate to the "Reports" section, followed by "Overview."
Finally, select "Balance."
Please ensure that the latest month with its corresponding dates and UTC is selected at the top.Then, click on the "Download" button.
You need to upload that file, alongside the previous CSV file you got from the “All transactions” section to Companio. When uploading this last balance, Companio will probably indicate that there were no transactions in the file. That’s normal, it is a balance, so it does not contain any transactions. The transactions are in the first file downloaded from the “All transactions” section, so you can safely ignore this message.
Learn how to effortlessly upload bank statements manually to Companio with our step-by-step article.
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 will guide you through the steps you must follow.
First, log into your Stripe account. In the menu on the left, choose “Payments” and then “All transactions”. Now click on the “Export” button on the top right.
You will see a dialogue box. This step varies depending on whether you need it for monthly accounting or to prepare your annual report:
If it is for monthly accounting, in the appearing dialogue box, choose "UTC" as the time zone, "Last month," and "All columns." Click on the "Export" button. A CSV file will be downloaded.
If it is for the annual report, in the appearing dialogue box, choose "UTC" as the time zone, "Custom," and "All columns." Click on the "Export" button. A CSV file will be downloaded. Select January 1st of the financial year of the report as the start date, and then choose December 31st of the same year as the end date.
Now, navigate to the "Reports" section, followed by "Overview."
Finally, select "Balance."
Please ensure that the latest month with its corresponding dates and UTC is selected at the top.Then, click on the "Download" button.
You need to upload that file, alongside the previous CSV file you got from the “All transactions” section to Companio. When uploading this last balance, Companio will probably indicate that there were no transactions in the file. That’s normal, it is a balance, so it does not contain any transactions. The transactions are in the first file downloaded from the “All transactions” section, so you can safely ignore this message.
Learn how to effortlessly upload bank statements manually to Companio with our step-by-step article.
Updated on: 21/11/2023
Thank you!