Skip to main content
Version: 4.11.0

FMUTA component

The FMUTA component enriches messages containing financial mutations in CSV format as exported by Abacus. This component produces messages in a format that can be imported by accounting software. It adds a header line for each group of lines present in the input.

Input requirements

The first line of CSV files used as input for this component should be a header containing the following column names:

  1. Regelnr
  2. Bedrag
  3. Incl_Excl
  4. BTWBedrag
  5. HeaderOmschrijving
  6. RegelOmschrijving

The column named Regelnr should be first, and the other columns can be present in any order. The columns named Bedrag and BTWBedrag should contain numerical values using a comma as decimal separator.

Additionally, the fields should be separated by semicolons.

Output

The following table summarizes the functionality of this component.

Column nameHeaderLine
Regelnr(1)Copied
DagboektypeCopiedCopied
DagboeknrCopiedCopied
PeriodeCopiedCopied
BoekjaarCopiedCopied
BoekstukNrCopiedBlank
HeaderOmschrijvingDroppedDropped
RegelOmschrijvingDroppedDropped
Omschrijving(2)(3)
DatumCopiedCopied
TegenrekeningBlankCopied
DebnrCopiedCopied
CrednrCopiedCopied
FactuurnrBlankCopied
Bedrag(4)Copied
Incl_ExclDroppedDropped
JournaliserenCopiedCopied
ValutacodeCopiedCopied
KoersBlankCopied
Krediet_bepCopiedCopied
Bedrag_krediet_bepCopiedCopied
Vervaldatum_FactuurCopiedBlank
Vervaldatum_Bedrag_Krediet_bepCopiedBlank
BTWCodeBlankCopied
BTWBedragBlankCopied
WeeknrCopiedCopied
ReferentieCopiedBlank
BetalingswijzeCopiedBlank
BedragrekeningCopiedCopied
KostenplaatsCopiedCopied
KostendragerCopiedCopied
AantalKostendragerCopiedCopied
VerschilcodeCopiedCopied
kolom30CopiedCopied
StornoboekingCopiedCopied

The values in the table represent the following:

  • Copied indicates that the value of these fields are copied from the input.
  • Dropped indicates that these columns are dropped from the output.
  • Blank indicates that the values of these fields is blank.
  • (1) indicates that the value of these fields is equal to 0.
  • (2) indicates that the value of these fields is copied from the column HeaderOmschrijving.
  • (3) indicates that the value of these fields is copied from the column RegelOmschrijving.
  • (4) indicates that the value of these fields is computed from the values in the columns Bedrag, Incl_Excl, and BTWBedrag. The value in the header is equal to the sum of the values in the column Bedrag of the corresponding lines and the sum of the values of the column BTWCode for the lines in which the value for the column Incl_Excl equals Excl.

Configuration

  • The decimal separator, field delimiter, and quoting behavior used for the output are configurable.
  • You can use any character as decimal separator or delimiter.
  • You can choose whether you want each field to be quoted or only those fields that require quotation marks according to the specification of the CSV format. For example, fields containing line breaks, double quotes, or commas should be quoted.