You only need to do this once for each bank account. It opens automatically after you add a bank account; you can also open it from the Bank Accounts tab with the CSV Mapping button.
- Under 1. Upload a sample statement, click Choose File, pick a CSV statement from your bank and click Analyze.

- Under 2. Map columns, check the type chosen above each column. Garage Invoice suggests a mapping for you.
- Required: Date, Amount (or Credit Amount / Paid in and Debit Amount / Paid out if your bank uses two columns) and Description.
- Optional: Counterpart Name, Counterpart Account No. / IBAN and Transaction Type.
- Set every other column, such as the running balance, to Ignore.
Click CSV settings if the delimiter, date format or decimal separator need changing.

- Click Save. Choose Map & Import to save the mapping and import this statement now, or Map Columns to only save the mapping.

Note: check the suggested mapping before you save. In our test, a Balance column was suggested as Amount and had to be set to Ignore.
Feature Payments and online payments: see what it does and how it fits your workshop.