CSV import: when the columns are not recognised

If the module does not recognise the CSV columns of your bank, you tell it once. It remembers the layout.

When this happens

The module recognises the separator (; , tab |), the character set (UTF-8, Windows-1250, ISO-8859-2) and the header by words in Slovenian, Croatian, English and German (for example Booking date, Credit amount, Reference, Partner, Remittance). If it does not understand the header, the screen Which column is which? opens.

What to do

Pick a field for each column: Booking date and Amount (credit) are required. If the statement has no separate credit and debit columns, choose Amount (credit; negative = debit).
Optionally pick the payer, reference, remittance, currency, bank reference and payer IBAN. Leave columns you do not need (balance) at Do not import.
Keep the box Save this layout for next time ticked and press Show preview.

A saved layout also applies to the automatic import from the mailbox and folder: the next statement with the same header needs no mapping.

Amounts and dates

The module understands 1.234,56 and 1,234.56, amounts with a trailing minus and dates as 12.10.2026, 2026-10-12 and 12/10/26. Debits (amount out) are skipped.

Was this article helpful?

Badges and labels on productsExtensions Product questions and answersExtensions Product enquiry formExtensions Product attachments (data sheets, manuals)Extensions Back in stock notificationExtensions

Cookie name	Cookie purpose
PHPSESSID	Preserves the visitor's session state across page requests.
magelan_geo	Remembers that the visitor closed the suggestion of the other language version of the store, so it is not shown again.
form_key	Protects visitor's data from Cross-Site Request Forgery Attacks.
guest-view	Stores the Order ID that guest shoppers use to retrieve their order status. Used in “Orders and Returns” widgets.
login_redirect	Preserves the destination page the customer was loading before being directed to log in.
mage-banners-cache-storage	Stores banner content locally to improve performance.
mage-cache-sessid	The value of this cookie triggers the cleanup of local cache storage.
mage-cache-storage	Local storage of visitor-specific content that enables ecommerce functions.
mage-cache-storage-section-invalidation	Forces local storage of specific content sections that should be invalidated.
mage-messages	Tracks error messages and other notifications that are shown to the user, such as the cookie consent message, and various error messages. The message is deleted from the cookie after it is shown to the shopper.
private_content_version	Appends a random, unique number and time to pages with customer content to prevent them from being cached on the server.
section_data_ids	Stores customer-specific information related to shopper-initiated actions such as display wish list, checkout information, etc.
user_allowed_save_cookie, cookie_consent	Stores the user's cookie consent state for the current domain.
X-Magento-Vary	Configuration setting that improves performance when using Varnish static content caching.

Cookie name	Cookie purpose
product_data_storage	Stores configuration for product data related to Recently Viewed / Compared Products.
recently_compared_product	Stores product IDs of recently compared products.
recently_compared_product_previous	Stores product IDs of previously compared products for easy navigation.
recently_viewed_product	Stores product IDs of recently viewed products for easy navigation.
recently_viewed_product_previous	Stores product IDs of recently previously viewed products for easy navigation.
_fbp	This cookie is installed by Facebook to store and track visits across websites.

Cookie name	Cookie purpose
dc_gtm_*	Throttles request rate when Google Analytics is deployed with Google Tag Manager.
_ga, _gat, _gid, _ga_, _gat_	This cookie is installed by Google Analytics. They are used to collect information about how visitors use our website. We use the information to compile reports and to help us improve the website. The cookies collect information in a way that does not directly identify anyone.

CSV import: when the columns are not recognised

When this happens

What to do

Amounts and dates

Related

Cookie preferences