In this article
Stripe - Import movements .csv (Banana+ Advanced) [BETA]
This import extension allows you to import the transactions from Stripe platform into Banana. Stripe allows multiple export options, you can use two different export types to import data into Banana:
You can install the extension from the menu Extensions → Manage Extensions.
Requirements for use
- Banana accounting Plus with the Advanced Plan.
- Use a double entry or income and expenses accounting
Export the transactions report
It allows you to obtain all customer payments, including fees and collected transfers, and their corresponding status. To obtain this report you need to:
- Log in to your Stripe account
- In the main dashboard, select Transactions.
- Click All activity.
- Click Export.
In the export dialog select:
- Columns: All columns.
- Then click on Export.
We recommend saving the file in a place where you can easily find it later and not opening it before importing it.
Export of the balance summary report
This report is similar to a bank statement, helping you to reconcile your Stripe balance at the end of the month.
It provides an itemized CSV export of your complete transaction history and any custom metadata associated
with those transactions. All transactions are shown in your settlement currency (after any foreign currency conversion).
To obtain this report you need to:
- Log in to your Stripe account
- In the main dashboard, select Reports.
- Click Summary balance.
- Choose Balance change from activity.
- Click Download.
In the export dialog select:
- Report format: Itemized.
- Columns: All columns.
- Then click on Download.
We recommend saving the file in a place where you can easily find it later and not opening it before importing it.
Import procedure
The import procedure works the same for both reports:
- Via the Actions → Import to accounting → select Import transactions box
- Choose the extension to be used, in this case 'Stripe- Import movements .csv (Banana+ Advanced) [BETA]'.
- With the Browse button, choose the file from which to import the transactions.
- Press OK Button.
In the settings dialogue you must enter the date format and the accounts to be used to record stripe movements in the accounts:
- Stripe Account: Account where the amount is credited.
- Stripe In: Revenue account, this account records the gross amount paid by the customer
- *Stripe Reserved Funds: Cost account, used to record the amount reserved by stripe and then returned.
- *Stripe Fee: Cost account to record transaction-related expenses retained by stripe.
*These elements are only to be entered if you import the data using the "All transactions" method, if you import the balance change from activity you can leave them empty.
The accounts inserted must exists in your chart of accounts, if you do not yet have any suitable accounts, you can create new ones in your chart of accounts.
Currently only data in Stripe's Standard columns are imported, data in columns added by other platforms you are connected to are not imported.
For more details see import transactions page.
Visualize the imported data
In the Transactions table:
- Enable the ExternalReference (External Reference) and the Notes columns to see the id that Stripe has assigned to the transaction, this way you have a reference to the original transaction id generated in Stripe.
- When imported, transactions are sorted by date, it is possible that transactions belonging to the same operation are split by date and therefore do not occur in succession. We recommended to keep the .csv file as a reference as movements are exported grouped by operation, for control activities you can trace back the original movements using the external reference and notes columns.
Error Messages
- Unrecognised *.csv file format: The format of the *.csv file you are trying to import does not match any of the formats associated with this filter:
- Check that you have chosen the correct file.
- If the file you have chosen is correct, it may be that our filter requires updating.
- This extension requires Banana Accounting+ Advanced: You are trying to use the extension with a licence other than the one requested, please upgrade to the Advanced Plan. to be able to use the functionality of this filter.
Send us a feedback
This extension is a BETA version, we welcome suggestions for improvement.
It may happen that the format of the csv file is updated and as a result the filter no longer functions correctly. Send us feedback and attach an example file (.csv) with the new format and we will proceed to update the filter.