...
The Fast Four Bank Reconciliation supports by default all major file formats and provides full support to import a CSV file with a custom field mapping. During import, the Bank Reconciliation Suite App provides support for single account imports and multi-account imports. A single-account file is simply one file that contains only one bank account. A multi-account file can hold information for one or multiple bank accounts. With an additional configuration, the solution can automatically split the data into separate statements. How to set up a multi-account import can be found on the documentation page “Setup multi-account statement import” page. The multi-account import setup is the recommended import type because the solution decides automatically for which account the imported data is and this reduces the potential mistake that data is imported on an incorrect account.
Tip |
---|
Fast Four recommends using the CAMT formats for reconciliation. If these are not available then the MT940 should be the second choice. CSV files can always be used as a fallback option which is fully configurable. |
Info |
---|
Please note that in the following list of file types only UTF-8 characters are supported. |
...
Supported file formats
File type | Single-account import support | Multi-account import support |
---|
BAI2 | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
BGMAX | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
CAMT.053E | |
Green | Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
CAMT.053 | |
Green | Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
CAMT.054 | |
Green | Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
CODA | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
Finance Finland | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
MT940 | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
N43 | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
OFX, QFX | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
PAIN002 | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
QIF | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Red |
---|
title | not supported |
---|
|
|
TL1 | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Green |
---|
title | supported |
---|
|
|
CSV | Status |
---|
colour | Green |
---|
title | supported |
---|
|
| Status |
---|
colour | Yellow |
---|
title | supported * |
---|
|
|
*CSV files can only support a multi-account statement import if the file contains a column with a value that is unique to a particular bank account, for example, the IBAN-number or bank account number
...