Bank Statement – Import

Bank Statement – Import

In this view, you can import electronic bank statements. For each imported bank statement entry, booking suggestions can be created. Bank statement items that don't need to be booked can be excluded. Approved booking suggestions can be posted. As a result, bank statement items are created, which can be edited if needed. The following formats are supported:

  • camt.053
  • camt.054

The filters show all unposted bank statements when the view is opened.

New

  • A file selection dialog is displayed to select and import bank statement files

Delete

  • Imported bank statements can be deleted. Already created bookings will not be deleted.

Automatically Assign Bank Account

This function assigns a bank account and the defined financial account to all bank statements in the object list with the status "Read" or "In Progress".

Manually Assign Bank Account

With this function, you can manually assign or change a bank account for the selected bank statements from the object list. The currency of the financial account must match that of the bank statement.

Bank Statement Items

This button takes you to the "Bank Statement Items" view. There, the bank statement items of the selected bank statements are displayed in a list.

Post Bank Statements

With this button, approved bank statements can be posted. The result is displayed. After posting the bank statement, the status is set to Posted. You can use the context menu to display the created bank statement entries.

Bank Statement Items

You can access this sub-view via the "Bank Statement Items" button in the "Bank Statement – Import" view. In this view, the bank statement items of the bank statements are displayed in a list. The checkbox "Releasable" in each row indicates when a booking of the booking suggestions is possible.

Object List

Processing Status

  • In Progress = Pencil -> Not yet fully processed
  • Excluded = Cross -> Finished
  • Approved = Checkmark -> Finished

Match Quality

The match quality is determined when creating booking suggestions by pressing "Start Automatic Assignment (Link)".

  • Red
  • Yellow
  • Green

Excluded

Will not be posted. If excluded, it can be posted.

Releasable

Can be approved. If approved, it can be posted.

  • Unassigned amount = 0
  • Mandatory fields filled

Payer / Payee

Text for search in Payer / Payee. The text is composed of several fields of the bank statement item.

  • Booking Reference
  • Additional Information
  • Purpose

Start Automatic Assignment

With this function, you start the automatic creation of booking suggestions for all bank statement items in the object list. The booking suggestions are displayed in the Booking Suggestions area.

If a booking reference of the type QR reference or creditor reference, a file number, or invoice number is found in the purpose of the bank statement or matches from the configured search steps, an automatic booking suggestion is created.

If you have created manual booking suggestions and do not want them to be changed by the automation, please activate the Manual Assignment option.

Area Changeable Data in Detail

Unassigned Amount

Amount of the bank statement item that has not yet been assigned to a booking suggestion.

Area Booking Suggestions

In the Booking Suggestions area, manually and automatically created booking suggestions are displayed. Here, booking suggestions can be created, edited, or deleted.

As in the bank statement, booking suggestions of the following types can be created and edited:

  • Debtors Opos for payments on open items
  • Third-party funds
  • Payment
  • Direct Expense
  • Direct Advance
  • Direct Payment

The editing of individual booking suggestions is done in a separate dialog for each type.

For a bank statement item, multiple booking suggestions of different types can be created until the amount of the bank statement item is split.

Button to Clarify

A dialog for booking suggestion of type Payment is opened. The tax situation is pre-filled if a tax situation for General Bookings (Link) with the property 'to clarify...' is available.

Exclude

With this function, you exclude marked bank statement items from being posted. Existing booking suggestions are deleted.

Undo Exclusion

With this function, the exclusion of the marked bank statement items is undone.

Take into Processing

With this function, you can reset the status "Excluded" or "Approved" for the marked bank statement items back to "In Progress".

Import Bank Statement Search Steps

In this view, you can configure search steps for generating automatic booking suggestions. The search steps can be set active and inactive by you.
They are only considered in the Automatic Assignment if they are set active.

In the detail of the view, you can enter the values for the search steps in the condition fields. The input fields in the Conditions area are AND-linked. Purpose: Text field for search in the purpose with | as a separator
e.g. Third-party funds | FG., File No. The | means OR linking of the contents of the input field.

Additional Information: Text field for search in the additional information with | as a separator e.g. Additional info on the entry, not the detail

Amount with Deviation

Amount field with label “Amount” for entering an amount and a second amount field for entering the deviation with label “Deviation plus/minus”

Payer/Payee

Text field for search in Payer / Payee

You can create search steps for the following actions during the Automatic Assignment

Create Booking Suggestion

For matches based on the configured search steps, automatic booking suggestions are created for the following payment types

  • Third-party funds
  • Expense
  • Direct Advance
  • Payment

No configured search step is needed for open items because they are found using the reference number and invoice number provided in the account statement's purpose.

For recurring payments like rent, ongoing contracts, or installment payments, you can configure the search step more precisely by defining the amount, reference number, location, booking text, and employee in the search step.

Additionally, you can define in the search step that account statement entries with the defined values should be excluded from booking.
The configured search steps are executed during the Automatic Assignment, and based on the results, Automatic Booking Suggestions are created or account statement entries are excluded.

Match Quality

The match quality of the automatically generated booking suggestions is calculated when the booking suggestions are created.
The values are displayed in the second column of the account statement entries in the grid and cannot be changed by manually editing the result. The match values are as follows: 90 (green):

  • one or more invoices were found via the purpose where all open amounts are not equal to 0, the signs of the distributable amount and open amounts are the same, and the sum of the open amounts equals the distributable amount

or

  • matches were found for the defined search steps. If an amount was entered during the configuration of the search step, it must equal the distributable amount. If no amount was entered, the match is sufficient

10 (red)

  • no open items, invoices, or matches from the configured search steps were found.

50 (yellow)

  • matches were found for open items and invoices where the amounts are greater than the invoice amount or open item amount because the distribution is unclear > overpayment, and also for all other matches that do not correspond to the values 90 or 10

Related to