File settings

Now scroll down to the file settings. Here you can specify which column of your csv file should be mapped to which field in accrio. You can do that

either by selecting a header map template (e.g. Revolut, Wise, Cornercard, Viseca DE, Paypal DE)
or by creating a header map from scratch.

With an existing template

If you're using Revolut, Wise, Cornercard, UBS MasterCard/Visa, Viseca DE, Paypal DE, our Journalbooking Template (other templates on request), click on the dropdown (e.g. Cornercard (public)) and click on Load (Refresh button).

Headermap with template

Without an existing template

If you don't use one of the above mentioned banks, you have to

create a header map from scratch
or make a request for the free setup service
or ask us for additional help

Create a header map from scratch

Create a new header map

To create a header map from scratch click on the plus sign to create a new header map.

Headermap without template

warning

Make sure that the dropdown menu has no template selected otherwise the plus sign will duplicate the template for customization. If a template was selected, click on the dropdown and select the first entry (empty) and click on load (refresh button).

Map the columns

Now you have to define which column of you csv file should be mapped to which field in accrio. You can do that by clicking on the dropdown menu of the field and select the column name of your csv file.

Section 1: is only required if your csv file doesn't start on line 1.
Section 2: is required for all csv files.
Sections A and B: are optional and only required if you want to use the automapping feature or other additional features.

tip

Check out our examples how to map your csv file:

tip

To check the columns & formatting of your csv file:

duplicate your csv file and open the duplicate file with Excel, Google Sheets or Numbers.
Never open the original csv file with Excel. This will most likely mess up the formatting of the file and makes it unusable for the import.

Custom headermap

Fields explained

Section 1 `optional`

ignore top rows `optional`

You will need this feature, if your headers are not in the first row of the csv file. E.g. in the following example, you would input 5 and click on reload. Now the first 5 rows will be ignored and the header names will be taken from the 6th row.

Ignore top rows

Section 2 `required`

booking date `required`

Choose the column which contains the booking date. The transaction will be booked in bexio at this date.

➡️ The date format will be detected automatically. If the date format is not detected correctly, you can specify it manually in the field custom date format.

custom date format optional

In most cases our tool is able to detect the date format in your csv file automatically (e.g. dd.mm.yyyy, dd/mm/yyyy, yyyy-mm-dd etc.).
Only set this field if the date format is not detected correctly. Examples:

12/31/22 -> mm/dd/yy

12/31/2022 -> mm/dd/yyyy

description `required`

The description is usually the most important text, since it describes what the transaction was for. This will be used to match the transaction to the correct booking rule and will be sent as the booking text to bexio.

2nd field

If you have two fields that are useful for the description in bexio, you can select a 2nd field. The 2nd field will be added to the description in bexio. E.g. if you select description in the 1st and reference as the 2nd field, the description in bexio will be description reference.

maximum length `optional`

You can define the max length of the description that will be sent to bexio. This allows to cut off unnecessary information if your description text is very long.

card currency `required`

If your csv file contains a column with the card currency (e.g. CHF or EUR).

warning

Make sure that this is the currency of the card and not the original currency of the transaction. If you paid in USD, but your card accumulates the transaction in CHF, the card currency is CHF.

static currency

If your file doesn't contain a column with the card currency, you can set a static value here (e.g. CHF or EUR) which will be applied to all transactions.

card amount `required`

This will be the amount booked to bexio. If your csv file contains a single column with positive and negative amounts (e.g. 100.00 or -50.00). This is the amount that will be

negative amounts will be interpreted as debit transactions (you pay something with credit card)
positive amounts will be interpreted as credit transactions (someone transfers money to your card account)

debit / credit in 2 columns

If your csv file uses two separate columns for debit and credit transactions. Check this checkbox. Now you can select two separate columns.

reverse amount (*-1) optional

If the amounts in your csv file are reversed (negative amounts become credit transactions and positive amounts become debit transactions), you can check this checkbox to tell accrio it should interpret the amounts in reverse.

info

Make sure that the amount of the transactions have the correct colour in accrio:

Debit transactions (you pay something with credit card) should be red be
Credits transactions (someone transfers money to your card account) should be green

Section A `optional`

Automapping feature

If your csv file already contains one or multiple columns with correct bexio account numbers (e.g. 6000) or bexio tax codes (e.g. VM77) you can use this feature to automatically map these columns to the correct bexio account number or tax code instead of creating rules for each transaction. Check out this tutorial to learn more about this feature.

Credit account (transaction rule)

Coming soon. Check out this tutorial or contact us if you have any questions.

Debit account (bank rule)

Coming soon. Check out this tutorial or contact us if you have any questions.

Tax code

Coming soon. Check out this tutorial or contact us if you have any questions.

Section B `optional`

Fields on the left hand side can be used in rules, fields on the right have special functionalities (like generating a separate booking for fees)