# Importing a bank statement from a file and the universal template

URL: https://bimpsoft.com/en/help/finance/bank-statement-import/
Updated: 2026-11-06

> You can upload a bank statement to Bimp as a file: open "Finance → Transactions", click "Client-Bank", select the "From file" source, upload the statement, choose the bank and click "Import". A single upload can cover no more than 30 days. For banks without a dedicated format, use the universal template.

## When you need to import a statement from a file

Import from a file is needed when you have to bring bank transactions into Bimp without entering each payment manually, and there is no automatic exchange with the bank. After the import, all transactions appear in the "Transactions" list and wait to be allocated. Automatic statement upload is set up separately: see [Automatic exchange with banks](https://bimpsoft.com/en/help/integrations/bank-integration/). All articles in this section are listed on the “[Finance](https://bimpsoft.com/en/help/finance/)” page.

## How to upload a statement from a file

You upload a statement from **Finance → Transactions** with the **Client-Bank** button.

1. Save the statement from online banking as an Excel file (**.xls**). The period in the file must be no more than 30 days.
2. Open **Finance → Transactions** and click **Client-Bank** in the upper right corner.

   ![The "Transactions" tab of the "Finance" section with a list of transactions; the "Client-Bank" button in the upper right corner and the "Finance" menu item on the left are highlighted](https://bimpsoft.com/help/_img/48d32c9b-6379-42cc-89fd-4bc7b847eb4b.webp)

3. In the right panel, in the "Data source" field, select **From file** and click **Upload**.
4. Select the statement file in the file explorer. The "File import" window opens with the name of the selected file.
5. In the "Bank" field, select the bank whose statement you are uploading.

   ![List of banks in the "Bank" field of the import window: PrivatBank, PrivatBank Business, Ukrsibbank, PUMB, Aval, OTP, Bank Pivdennyi, Monobank, Universal Bank, ProCredit Bank, TASCOMBANK, Ukrgasbank](https://bimpsoft.com/help/_img/75b80607-1634-4b22-a39a-5ad2aa573c4d.webp)

6. Click **Import**. After a few seconds, the transactions appear on the "Transactions" tab.

> [!NOTE] PrivatBank statements come in an old and a new format. If the system shows an error or does not recognize the data, switch the toggle in the import window to the other statement type.

## What happens after the import

After the import, new transactions have an empty circle in the "Alloc." column: they are not allocated. The next step is to link them to items, contracts and orders: [Allocating bank statement transactions](https://bimpsoft.com/en/help/finance/bank-statement-processing/).

![List of transactions after import: four transactions with empty circles in the "Alloc." column, receipts of +15,000 and +17,000 UAH and expenses of -16,500 and -1 UAH, the "Document" column is empty](https://bimpsoft.com/help/_img/c46168c7-7bc2-428c-96da-de0c7f833c79.webp)

## How to upload a statement with the universal template

The universal template lets you upload a statement from any bank, even if there is no dedicated format for it: you need to bring the data into the template structure.

1. Prepare an Excel file according to the template. The **second row** must contain a heading like "Statement for account No. UA…" with the account number (IBAN) after the "No." symbol: Bimp uses it to identify the account.
2. Fill in the required columns: reference (a unique transaction identifier), amount and currency. If there is no reference, fill in the first column "No.": Bimp will use the row number as the identifier.
3. If possible, specify the [counterparty](https://bimpsoft.com/en/help/counterparties/counterparty-card/) and their account. The minimum set of data is enough for the statement to appear in the system, but a missing counterparty will have to be entered manually during allocation.
4. Upload the file the same way as in the previous section and select the universal (general) template.

## How Bimp filters out duplicates

Bimp does not upload a transaction a second time if its identification code matches one that already exists. The code is formed as `[BankCode]_[AccountNumber]_[Reference]`, where the bank code depends on the statement format:

| Format | Bank prefix |
|---|---|
| PrivatBank | 1 |
| PrivatBusiness | 2 |
| Universal template | 0 |

> [!WARNING] If you upload statements from two different banks through the universal template and the account numbers and references (or row numbers) match, Bimp treats the second record as a duplicate and skips it. Use unique references.

## Common problems

**A file for a long period is not uploaded.** Cause: the limit of 30 days per import. Save the statement as several files and upload them one by one.

**PrivatBank is not recognized.** Cause: a different statement format. Switch the statement type toggle in the import window.

**A transaction from the universal template was not uploaded.** Cause: the account number and reference match an existing transaction. Fill in unique references.

## FAQ

**What period can I upload a statement for?**

No more than 30 days at a time. For a longer period, save several files in the bank (for example, one per month) and upload them one by one.

**What file format should the statement be in?**

Excel (.xls) is supported. If a PrivatBank statement is not recognized, switch the toggle for the old or new statement format in the import window.

**What should I do if my bank is not in the list?**

Use the universal template: enter the transactions in a file according to its requirements and upload it, selecting the universal (general) template.

**Why were some transactions from the universal template not uploaded?**

The system treats a record with the same account number and reference (or row number) as a duplicate and does not upload it a second time. This can happen if statements from different banks are uploaded through one template.