Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 to use using the CAMT formats for reconciliation. If these are not available , CSV or then the MT940 should be the second choice. These formats offer further options/settings. 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
colourGreen
titlesupported

Status
colourGreen
titlesupported

BGMAX

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

CAMT.053E

Status
colour

Green

Red
titleNot supported

Status
colourGreen
titlesupported

CAMT.053

Status
colour

Green

Red
titleNot supported

Status
colourGreen
titlesupported

CAMT.054

Status
colour

Green

Red
titleNot supported

Status
colourGreen
titlesupported

CODA

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

Finance Finland

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

MT940

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

N43

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

OFX, QFX

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

PAIN002

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

QIF

Status
colourGreen
titlesupported

Status
colourRed
titlenot supported

TL1

Status
colourGreen
titlesupported

Status
colourGreen
titlesupported

CSV

Status
colourGreen
titlesupported

Status
colourYellow
titlesupported *

*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

...