在此文中
SumUp - Import movements .csv (Banana+ Advanced)
This extension allows to import transactions from the SumUp platform into Banana Accounting.
You can install the extension from the menu Extensions → Manage Extensions.
Requirements for Use
- Banana Accounting Plus with the Advanced Plan.
Export Procedure
Export your transactions from the SumUp platform in CSV format.
- Login on your SumUp profile.
- Then export the report containing all the Transactions.
- Select a timeframe using the date filter.
- Confirm the export by clicking on "Export" to download the CSV file.
The transaction report lists all your transactions, including card payments, cash payments, and refunds.
Import Procedure
- Via the Actions → Import to accounting → select Import transactions box.
- Choose the extension to be used, in this case 'SumUp - Import movements .csv (Banana+ Advanced)'.
- 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 SumUp movements in the accounts:
- Bank account: Account where the amount is credited.
- SumUp income account: Revenue account, this account records the gross amount paid by the customer
- Cash account: Account to book the amounts paid by cash.
- SumUp fee account: Cost account to record transaction-related expenses retained by SumUp.
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.
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 SumUp has assigned to the transaction, this way you have a reference to the original transaction id generated in SumUp .
Error Messages
If the import fails, an error message will be displayed. The most common errors are:
- 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.