Bank Statement File Import — Bank Transactions

Preparing your CSV file

This guide will lead you through the process of importing your bank transactions, or any other relevant transactions, from a CSV file directly into your company account within the Enlivy app.

By utilizing this convenient feature, you can save time and ensure accuracy.

We’ll provide comprehensive instructions, covering everything from selecting the appropriate file format to mapping data points and completing the import.

Throughout this guide, we’ll use a sample bank statement to illustrate the steps. However, the process is applicable to most actual bank statements you download from your financial institution, typically in formats like XLS (.xls) or XLSX (.xlsx).

Sample March 2022 bank statement in XLS format with debit and credit transactions

We will use a bank statement from March 2022, containing both debit and credit transactions. You can access it in the provided XLS format above.

The initial step is to convert the XLS file to CSV format. Once converted, the file will display in Excel as a CSV or like this in a text editor.

The converted bank statement shown as a CSV file opened in Excel

And in the text editor:

The same bank statement CSV file opened in a plain text editor

Now that you’ve prepared your CSV file for import, we can begin the import process.

Importing Bank Transactions to the Enlivy App from a CSV file

First, navigate to the Bank Transactions tab in the Enlivy App.

On the right side of the screen, click the Add Bank Transaction button, followed by the Import button.

The Add Bank Transaction menu with the Import option in Enlivy

After clicking the Import button, you will be prompted to choose a CSV file and select a bank account where the imported transactions will be stored.

The import dialog prompting for a CSV file and a destination bank account

Choose your CSV file; I will use the one mentioned at the beginning of this document. Next, select a bank account; I will opt for one of my existing accounts in the Enlivy Application, named Banca Test.

A CSV file selected with a bank account chosen and the file preview shown on the right

After selecting a CSV file, the preview of that file appears on the right side of the screen, as shown in the screenshot above.

Our next step is to identify the Header Row of the table in the bank statement.

Let’s revisit the bank statement to determine its Header Row:

The bank statement with its header row identified

We can observe that the statement’s row is represented by Row 18, as depicted in the CSV file preview on the right side:

The CSV file preview in Enlivy showing Row 18 as the header row

We will select Row 18 as the Header Row, after which additional fields will appear, as shown in the following screenshot:

Additional mapping fields that appear after selecting the header row

Here’s an explanation of all the fields in the Bank Transactions - Import section

Header Row: Specifies the row that will serve as the header in your CSV during the import process.
Start from Row: Indicates the row from which the data should be collected.
End at Row: Specifies the row at which the data collection should conclude (i.e., the last transaction line).
Field Position – Title: Choose the column or field position from the table to designate the transaction title.
Field Position – Created At: Select the column or field position from the table to indicate the transaction date or registration date.
Field Position – Amount Inbound: Select the column or field position that shows money coming into the bank account (incoming amounts).
Field Position – Amount Outbound: Select the column or field position that shows money going out of the bank account (outgoing amounts).
Field Position – Note: Designate a column or field position to act as a note.
Date Format: Input the date format; the standard format is 'd/m/Y'.

Update Bank Account Balance: If checked, it will update the balance of the selected bank account with the imported transactions.

Display Advanced Options: When checked, it will reveal additional advanced options:

Field Position – Sender User ID
Field Position – Sender Label
Field Position – Receiver User ID
Field Position – Receiver Label

These fields allow you to map more information from the CSV (additional fields/columns) as needed.

The advanced import options for mapping sender and receiver fields

Here’s the recommended mapping setup for the CSV, based on the example we’ve provided

The recommended field mapping setup for the sample CSV import

Header Row: The header row of the bank statement table.; 18
Start from Row: Row 19 is blank, so the import starts at row 20.; 20
End at Row: The last transaction row; later rows aren't transactions.; 33
Field Position – Title: The ‘Transaction Description’ column becomes each transaction's title.; Transaction Description
Field Position – Created At: The ‘Register Date’ becomes the transaction date after import.; Register Date
Field Position – Amount Inbound: In this sample the incoming amounts are in the Debit Sum column, so it maps to Amount Inbound.; Debit Sum
Field Position – Amount Outbound: The outgoing amounts are in the Credit Sum column, so it maps to Amount Outbound.; Credit Sum
Field Position – Note: The ‘Transaction Description’ column also acts as the note.; Transaction Description
Date Format: Left unchanged.; d/m/Y

After entering the desired information in the fields above, a new preview will be generated at the bottom of the page by the App. This preview will display how the lines from the CSV will be mapped in the Enlivy App and how they will appear. The preview is automatically generated based on the inputs we provided in the fields above. In our case, it looks like this:

Preview of how the CSV rows will be imported as bank transactions in Enlivy

If we have entered the correct fields, the table should appear as intended. If everything is correct, we can proceed by clicking the Import button.

Congratulations 👏, you’ve imported your first transactions file to Enlivy.