Skip to main content

Manual Account and CSV Import

Application icon: Manual importThis icon is used when transactions are imported from a file instead of a direct bank connection.mdi:file-upload-outline

A manual bank account is created directly in rAInty without connecting to the bank provider.

This option is useful when your bank is not available for direct connection, or when you prefer to import transactions yourself.

When creating the manual account, enter the initial account balance. After each successful CSV import, rAInty recalculates the displayed balance as the initial balance plus the sum of all imported transactions for that account.

When to use it​

Use manual creation and CSV import when:

  • your bank is not supported by the direct connection flow;
  • you already have transaction exports from your bank;
  • you want full control over which file is imported;
  • you are testing a bank account before connecting it automatically.

Main steps​

  1. Open Bank Account.
  2. Choose the option to add a new bank account.
  3. Select the manual option.
  4. Enter the account information.
  5. Open the created bank account.
  6. Choose Import CSV.
  7. Upload the CSV file exported from your bank.

CSV import builder​

The CSV import builder helps rAInty understand the bank file.

The file may use different formats depending on the bank. For this reason, the builder asks you to confirm how the file should be read.

You can normally choose:

  • the column separator, such as comma, semicolon, tab, or pipe;
  • whether the file has a header row;
  • how many initial rows should be skipped;
  • which CSV column matches each rAInty transaction field.

Mapping columns​

During mapping, you connect the bank file columns to rAInty fields.

Typical fields are:

  • booking date;
  • value date;
  • amount;
  • currency;
  • description;
  • counterparty;
  • reference;
  • external transaction id.

rAInty uses this mapping to convert the CSV rows into bank transactions.

Reusing a template​

After a mapping is configured, it can be saved as a template.

This means that the next time you import a CSV from the same bank, you can reuse the same structure instead of mapping all columns again.

Templates can start as private templates for your own use.

Import result​

Before creating transactions, rAInty validates the file.

It checks whether required fields are present, whether dates and amounts can be read, and whether some rows look duplicated.

After the import, rAInty shows a summary with:

  • imported transactions;
  • skipped duplicate rows;
  • rows with errors;
  • rows that need correction.

The imported transactions are then visible in the bank account transaction list.