A statement is a document used to save a bank statement and generate subsequent documents from it (receipts, payments, financial transactions etc.). An XML file in ISO 20022 format can be imported into the statement (SEPA statement). It is possible to display attachment preview in fine-tuning.
A warning appears in front of the row on the bank statement, if the document date related to the row differs from the date on the statement row.
Receipts automatically generated from the bank statement track the invoice reference number - if the customer accidentally pays several invoices with the same reference number, it must be corrected manually.
Payments track the payment number created in Directo - if the payment order created in the bank happens to have the same number, the connection may occur with the wrong payment and must be corrected manually.
If automatic transactions from the bank statement are in use, then the transactions are created and confirmed automatically. Helps to find rows that need correction. If there are created transactions in the meantime, the changes can be seen by pressing F5 on the bank statement.
If the bank statement is not in the base currency, e.g. in SEK and in the general ledger the transactions are always reflected in the correct currency, so Directo's start balance and final balance are calculated in SEK just as the beginning balance and closing balance of the account in the nominal ledger are in SEK.
The following data is added to the follow-up document created from the bank statement as a result of manual filling or application of the rule:
The identifiable documents are:
Bank statement import identifies receipts previously created in Directo based on the reference number
.Bank statement import identifies payments initiated from Directo
.To import a bank file, must first create a new bank statement document and save it with the payment method associated with the required bank account selected in the header. The payment method setting EXPORT TYPE must be 18 (SEPA EST). IMPORT SEPA EST button appears on the statement document saved with this payment method. After pressing the button, can select a bank statement file from computer and upload it.
To each bank file row corresponds one row in the statement document. All records, both sums received and paid, are imported. According to the bank file entry type, Directo assigns the type to the row Receipt, Payment, etc. The type can be changed if desired.
If documents have been created from the statement and the import is performed again, all rows from which a document has not yet been created were deleted.
The rows with the document link remain (and if they are in the file being imported, they will not be imported again, provided that there is a unique row identifier in the data).
In the bank, each transaction has a unique identifier, which is also imported into Directo. Statement import adds only those rows which unique identifier has not yet been imported into Directo. This eliminates the situation where the same entries are accidentally imported multiple times. If, for example, the same statement is imported immediately into a new bank statement document, the result is a document without a single row.
Imporditavateks formaatideks on
Arve lisaväli, kus hoitaks arve viitenumbrit
By setting the rules of the statement, the information of the statement lines can be automatically filled. This option is most often used to describe bank transactions that are recorded as a financial transaction, such as service fees, interest, loan payments, etc.
It is easiest to start creating a new rule from the statement document. The corresponding rule code can be seen on all lines to which a rule has been applied, and the rule can be opened by clicking on it. All lines in the statement that have not been applied to any known rule have an ADD link. Example: one row already has a rule applied (EU2_TT) and other rows that do not match any known rule have the link ADD.
Clicking on this link opens a window for creating a new rule, the conditions of which are pre-filled with information from the line of the corresponding statement.
A code and a name must be assigned to the rule to be created. When filling in the conditions block must be remember that the rule applies if ALL the conditions are met. In the example above, the rule applies to transactions where
In order for the rule to apply more universally, the conditions can be reduced or a text fragment search can be used instead of an exact text match. For example, in such conditions
the rule applies in all cases when money is debited from the account with a transaction of type TT_1 and whose description includes the text service fee
After fulfilling the conditions, the desired result of the application of the rule must be determined. Example:
The statement line to which the given rule applies is assigned
The register of the configured bank statement rules can be found in the Finance settings option Bank statement rules. Rules can be changed and deleted here.
In order to generate the necessary accounting document from the statement, the corresponding document type tab must be selected above the lines. Example: Receipt is selected:
As a result of selecting the type, the button Generate: Receipt has appeared. By pressing this button, Directo creates a new receipt document from the lines visible on the screen. During the creation of the receipt, the received amounts are matched with the sales ledger data. Generation takes place in two stages - first customer identification and then document identification.
The customer is identified according to the suitability of the parameters based on the order given here:
Datafield defining customer reference number for receipt import
is specified Invoice data field, where invoice reference number is stored
Invoice datafield for external invoice number
, the compatibility of the number in the datafield with the number in the explanation Bank statement receipt generator's invoice detection prefers project code occurence in payment description
is specified Order number lookup when creating receipt from bank statement
is specified The document is identified according to the previously identified customer, in the order here, based on the following fields:
Invoice data field, where invoice reference number is stored
is specified Invoice datafield for external invoice number
, the compatibility of the number in the datafield with the number in the explanation Bank statement receipt generator's invoice detection prefers project code occurence in payment description
is specified If the statement is very large, Directo will generate multiple receipts so that no receipt is more than 500 lines long.
A common receipt or payment is created from lines with the same object, user and reference. St. the aforementioned object, user, and reference go into the receipt or payment header.
By pressing the button Generate: Transaction, is created a transaction from all the statement document rows which type is transaction and rows converge to the same transaction which date and reference are the same (or rule in the absence of a reference). (or rule in the absence of a reference). When creating a transaction Directo checks the compliance of the financial transaction with the rules and enriches the information according to the settings (for example, adds hierarchies to objects).
If a recipe is assigned to a statement row, the sum of this row is divided according to the rules defined in the recipe. Rules should be defined based on the following:
If an automatic data exchange interface with the bank is used, statement documents are created in Directo when the bank issues the previous day's account statement i.e. PeriodicStatement (camt.053.001.0) report (usually between 03:00 and 05:00). The Debit Credit Notification or Alert report is also supported (camt.054.001.02), which occurs as soon as the receipt takes place (from an amount that can be set in the bank). The peculiarity is that this type of report is not always created new, but adds rows to that day alert type report.
The imported bank statement can be saved as a PDF and XML file in its unaltered form, to be printed if necessary or used for internal control. To do this, you need to activate the system setting Finance settings > Bank statement import stores statement also as an attachment
, by selecting the appropriate language in which the PDF file will be saved from the drop-down menu.
Transport > Default range
, if you want the report document to be created in a specific range.Transport > LHV bank account/IBAN list
bank accounts, whose statements you want automatically sent to Directo Transport > SEB Gateway bank account/IBAN list
bank accounts, whose statements you want automatically sent to Directo.