In this article

    SumUp - Import movements .csv (Banana+ Advanced)

    Import
    Universal
    View on Github

    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

    Export Procedure

    Export your transactions from the SumUp platform in CSV format.

    • Login on your SumUp profile.
    • Click on Home
    • Click on Download Center
    • Go to the Accounting section
    • Download Transactions and select the CSV (current format) option.

    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 dialog 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.

    Import SumUp dialog

    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.

    Imported data

    The program imports the following entries in the Transactions table:

    1. Sales with a successful bank payout
      Typically related to products/services paid by the customer via card. These transactions are recorded in accounting with three entries:
      1. Recognition of the sales revenue in the account defined as "SumUp income account" (gross amount).
      2. Recognition of the actual amount received, net of SumUp fees, in the "Bank account".
      3. Recognition of the fees retained by SumUp in the "SumUp fee account".
    2. Cash sales
      These transactions are recorded with a single entry:
      • "Cash account" as the receiving account
      • "SumUp income account" as the counter-account
    3. Refunds (when recorded as a bank payout)
      Refunds are recorded like standard payouts (see point 1), with an additional reversal entry:
      • Decrease of the "Bank account"
      • Decrease of the "SumUp income account"

    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 currently in beta, and we welcome suggestions for improvement.

    SumUp provides multiple types of reports, which can also be generated in different languages. Make sure to select the correct report, as described in the export procedure above on this page. If SumUp updates its export process and the instructions provided here are no longer valid, please let us know.

    If the Transaction Report is generated in a language that is not yet supported by the program, resulting in an unrecognized format, please send us the file so we can update and improve the extension.

    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.

    Useful Links

    How can we help you better?

    Let us know what topic we should expand or add to make this page more useful.

    Send us your feedback

    Share this article: Twitter | Facebook | LinkedIn | Email