Bank Statements

Bank statements have the document type code 75 IZV.

• basic
• ~ ITEMS ~
• ~ DMS ~
  Adding, viewing and updating documents attached to the statement. The tab is shown to companies subscribed to the Document Management System (DMS) module.

Statements can be imported directly into Brix as a draft statement. Brix then tries to “recognise” each transaction, assign an account and analytics to the item and link it to the matching open item.

Statements can be imported:

• manual
• auto

The original SEPA file of the statement is stored in the ~ DMS ~ tab of the statement form.

When a statement is imported, Brix fills the {Description} field of each item with data from the SEPA file. Each value is preceded by a label identifying the data:

• IBAN of the payer or payee,
• payment reference number,
• additional payment details.

By analysing the data in a statement item, Brix tries to recognise the account, the partner and, for accounts with open-item clearing, the item to be cleared.

• The partner is recognised by the IBAN in the statement item and entered into the partner analytics.
• The recognised partner is shown in the form even when account 99999999 is selected in the item.
• When an account is selected and the item is saved, if the selected account has no partner analytics, the previously entered partner analytics is removed from the item.

In addition to the IBAN, Brix analyses the data following the <Nm> tag and can identify the partner according to predefined rules. If you find a rule that always links a specific partner to the data following the <Nm> tag in the XML, partner “detection” can be improved further. Send us, via Support, the company, the bank, the statement date and the rule you have found, and we will build that rule in.

Example of such data in a SEPA XML file:

...
<RltdPties>
   <Cdtr>
      <Nm>Google GSUITE_pilana-vrat</Nm>  <<<< This is the <Nm> tag followed by the data that may define a rule.
...

When a statement is imported, Brix remembers the IBANs from items that are not yet in the IBAN codebook. When the statement is closed, such an IBAN is automatically entered into the ~ BANK ACCOUNTS ~ tab of the analytics entered in the item.

The IBAN is entered only if all of the following conditions are met:

• the IBAN begins with the country code HR,
• a partner, employee or member is entered in the item analytics,
• the bank of that IBAN has a {Bank leading number} entered.

When a statement is closed, a list of items with unlinked customer payments is displayed. Marking such items automatically creates draft advance payment invoices. If at least one such payment is marked, after confirming the selected payments the program opens the [ rapp ] form directly, with the data of the last marked payment.

The icon gives direct access to the general_ledger_sheet report.