Statements of transactions

Note
Statement of transactions functionality is only available in the French and Spanish versions of the system.

Statement of transactions are used to pass over bills to a bank in order to execute them. They contain uncompleted revenue transactions.

The list of statements of transactions is available from the level of menu Finances, under the [Transactions] button.

Statements of transactions

The list contains standard buttons which have been described in article <<Standard buttons>> and, additionally:

[File] − used for generating an ST file to the exchange file directory indicated in the system configuration

The list of statements is composed of the following columns:

  • Document − ST document system number in accordance with the numerator definition
  • Date of Issue
  • Number of Transactions − number of statement items
  • Value − total of values of all items
  • Status − ST document status The column can take on one of the following values: Initiated, Unconfirmed, Confirmed, Canceled, Sent
  • File − name and access path to the generated file
  • Description
  • Currency − system currency of a company in which the document has been issued

Detailed description of functioning of the filters can be found in category <<Searching and filtering data>>>

Adding statement

Statement of transactions is added in the same way as statement of remittance orders. Detailed description of the process can be found in article <<Statements of remittance orders>>.

Note
When saving an ST/whole ST document or confirming an ST it is not mandatory to complete fields From Bank Account and To Bank Account. This validation is performed while attempting to send the statement of transactions to a file.

Exporting statements to a file

Export of a statement of transactions to a file is performed the same way as in the case of the statement of remittance orders which is described in <<Statements of remittance orders>>.




Statement of payment orders

Payment order is a non-cash bank reconciliation form, in Europe known as direct-debit. This form of payment is basically used in recurring transactions. Payment order regarding a payment of Receivable type – a part initiating payment is creditor.

Configuration settings

From the level of System Configuration → Data Exchange → in section Transfers it is possible to select exchange file directory for the Statement of Payment Orders document. Then, the path is set as default on the SPO document form.

List of statements of payment orders

The list of statements of payment orders is available from the level of the menu Finances, under the [Statements] button.

List of statements of payment orders

The list contains standard buttons which have been described in article <<Standard buttons>> and, additionally:

[File] – used for generating an SPO file to the exchange file directory indicated in the system configuration

The list Statements of payment orders is composed of the following columns:

  • Document – system number of the SPO document, in accordance with the numerator definition
  • Date of Issue
  • Number of Transfer Orders – number of statement items
  • Value – total of values of all items
  • Status – SPO document status The column can take on one of the following values: Initiated, Unconfirmed, Confirmed, Canceled, Sent
  • File – name and access path to the generated file
  • Description
  • Currency – system currency of a company in which the document has been issued

 Detailed description of functioning of the filters can be found in category <<Searching and filtering data>>>

Adding statement of payment orders

Statement of payment orders is added in the same way as statement of remittance orders. Detailed description of the process can be found in article <<Statements of remittance orders>>.

Exporting statements to a file

Export of a statement of payment orders to a file is performed the same way as in the case of the statement of remittance orders which is described in <<Statements of remittance orders>>.

 

 




Statement of remittance orders

Remittance order is a basic and common form of non-cash settlement where a bank account owner orders bank to transfer a specific amount from their bank account to a bank account indicated by him/her in any bank. The remittance order is used to settle payables.

Configuration settings

From the level of System −> Configuration −> Data Exchange −> in section Transfers it is possible to select exchange file directory for the Statement of remittance orders document. Then, the path is set as default on the SRO document form.

Exchange file directory for SRO documents

List of statements of remittance orders

The list of statements of remittance orders is available from the level of the menu Finances, under the [Statements] button.

The list contains standard buttons which have been described in article <<Standard buttons>>.

[File] − used for generating an SRO file to the exchange file directory

Statement of Remittance Orders list

The of statements of remittance orders is composed of the following columns:

  • Document − SRO document system number in accordance with the numerator definition
  • Date of Issue
  • Number of Transfer Orders − number of statement items
  • Value − total of values of all items
  • Status − SRO document status The column takes on the following values: Initiated, Unconfirmed, Confirmed, Canceled, Sent
  • File − name and access path to the generated file
  • Description
  • Currency − system currency of a company in which the document has been issued

Detailed description of functioning of the filters can be found in category <<Searching and filtering data>>>

Adding statement of remittance orders

In order to add a statement of remittance orders, click on [Add] button from the List button group.

The form of an SRO document is composed of the following elements:

Tab General

Statement of Remittance Orders form

  • Number − document number assigned automatically by the system in accordance with the numerator definition
  • Document Status − determined automatically by the system, cannot be edited
  • Reference Number − allows for entering an additional document number by the user
  • Date of Issue − the current date is set by default, can be changed by the user
  • Date of Transfer − until adding an item to a statement, it is possible to select one of the three options from a drop−down list:
  • Current Date − system date
  • Due Date − it is not possible to specify the date in a document header. For particular SRO items, due date from the first payment added to the document is retrieved.
  • Specified Date − after selecting this option, a field allowing user for entering any transfer date becomes active
  • Value − total of item values converted to the system currency
  • File format − drop−down list allowing for selecting a format for exporting from
    formats defined in the configuration. It is possible to change format only until the file is generated.
  • File − name and access path to the generated file. Document number and path specified in System −> Configuration −> Data Exchange −> section Transfer are set by default, with the possibility of change. In case of providing only a file name, without indicating its location, the file will be saved in Comarch ERP Standard setup folder
  • Owner − center of the company structure which is the issuer of a document
  • Group transfer orders by entity accounts – this parameter is checked by default and is editable as long as the document has no items. If checked, it is possible to add to an SRO document both payments and items and the payables against the same entity (bank account number) are grouped into one transfer order when generating the file. If the parameter is unchecked, only payments can be added to a document. For payments of the split payment type, it is not possible to group transfers − each payment is a separate order exported to a bank.
  • For − title of transfer
  • Account − dop−down list allowing for selecting a bank account. Selected account is automatically set on subsequent items and it cannot be changed. If an account is not selected, it will be filled in automatically on the basis of the first SRO item added. Changing of a register in an SRO document which contains items will automatically update the account on all items.

Tab General → Items

Tab Items of an SRO documents

The list of SRO items is composed of the following columns:

  • Date of Transfer
  • Entity Code
  • Entity Name
  • Amount
  • Currency
  • From Bank Account − number of a bank account for the account indicated on a given SRO item
  • To Bank Account − number of a bank account of a customer/vendor indicated on a given SRO item

and columns hidden by default:

  • Split Payment − information whether a given payment is subject to the split payment mechanism
  • VAT Amount − VAT amount for a payment of the split payment type

In order to add new item, it is necessary to click on button [Add].

SRO document item form

The form is composed of the following tabs:

Tab General

Tab General is composed of the following sections:

  • Transfer:
    • Date of Transfer – date of transfer indicated in a header
    • Amount − total of amounts of a transfer for payments of a given item in the currency of those payments
    • Account − account indicated in a header, cannot be changed. If no account has been indicated in a header, it is possible to select it from a drop−down list.
    • From Bank Account − number of a bank account assigned to the selected account. The field cannot by edited.
    • Bank − name of a bank assigned to the selected account. The field cannot by edited.
  • Payer:
    • Vendor − allows for selecting entity type (Vendor, Employee, Institution) and indicating a specific entity of a given type.
    • Bank Account − allows for selecting from a drop−down list a bank account from all active bank accounts of selected entity.
    • Bank − field filled in automatically with the code and the name of a bank appropriate for selected bank account.
  • Payments:
    • Document − system document number
    • Date − payment due date
    • To Send − amount remaining to be sent
    • Transfer Amount − the amount from the column To Send is set by default, with the possibility of changing it
    • Currency – currency in which document was entered
    • Source − reference number from a source document
    • Split Payment − information whether a given payment is subject to the split payment mechanism
    • VAT Amount − VAT amount for a payment of the split payment type

Adding a payment to an SRO item is possible only if:

  • an SRO document is confirmed
  • the parameter Group Transfer Orders by Entity Accounts is checked
  • an entity is indicated on an item

To add a payment to an SRO item, it is necessary to click on the [Add] button.

It opens a list of payables with checked parameter To Send and filtered by entity and register selected on the item. In the upper right corner of the list, parameter Terms Date is available, where the following information is displayed:

  • transfer date from SRO header ─ for Date of Transfer options indicated in the SRO header: Current or Date of Transfer Specified Date
  • value Due Date ─ for Date of Transfer option indicated in the SRO header: Due Date

Terms date is presented for information purposes and it cannot be edited. Additionally, among columns hidden by default, column Terms Value is available, which contains the value of terms for a given payment. Terms date and terms value have effect on calculation of the amount presented in column To Send. Terms on a statement of remittance orders is calculated on the basis of the full payment amount only.

Example

PI/2020/00001 amounting to 1230 USD gross was issued on 02/09/2020

  • Invoice due date: 03/09/2020
  • Terms: 10%, 10 days
  • Amount remaining to be cleared, terms included: 1 107 USD

On 02/12, the user added SRO/1 and included PI/10/2019 in it. The amount to be sent, terms included, equals 1107 USD. The user changed transfer amount for the payment to 1000 USD.

Then, the user added SRO/2 and included PI/10/2019 in it. The amount to be sent for that payment equals 107 USD (amount remaining to be cleared, terms included – total of amounts without transfers for that payment =1107-1000=107)

List Account Payables opened from the level of payment of an SRO item

Note
On a payment associated with a given item, it is not necessary to indicate the same account as in the item header.

It is possible to add a payment:

  • that is subject to completion
  • that is not entirely completed
  • whose amount To Send is different than zero
  • that is compatible with an item as to entity, currency, and bank account number – if such number is specified on item form
  • that is compatible with an item as to date of transfer, if the date of transfer selected in document header is: Due Date. This condition does not apply when adding the first payment to item.

If no entity’s bank account is specified for the SRO item, but it is specified for the added payment, it is assigned to the item. In case of payments added to a SRO document, it is possible to edit the amount of transfer in this column until the document is confirmed. The amount can be modified from range 0 to the amount of To Send value.

In the details of a SRO item, apart from standard buttons, there is also Customer/Vendor button group containing the following buttons:

  • [Form] − displays the form of a customer/vendor indicated in the SRO document. Modifications to the customer/vendor data made from this level and saving the changes updates that data also in the edited SRO item.
  • [History] − displays all the transactions registered for the customer selected in an SRO document.
  • <<[Payment Estimate]>> − redirects to the payment estimate window, where it is possible to complete/compensate a payment.

Tab General Payments

In this tab, there is a list of all payments attached to the given SRO.

Tab Payments in SRO document

The list contains standard buttons which have been described in article <<Standard buttons>>.

The list of payments is composed of the following columns:

  • Document − system document number
  • Entity Code
  • Entity Name
  • Date − payment due date
  • To Send − amount remaining to be sent
  • Transfer Amountthe amount from the column To Send is set by default, with the possibility of changing it
  • Currency – currency of the document payments
  • Source − reference number from a source document
  • Split Payment − information whether a given payment is subject to the split payment mechanism
  • VAT Amount − VAT amount for a payment of the <<split payment>> type

To add new payment, click on the button [Add] which opens the list of payables with checked parameter To Send and filtered by the account indicated in the document header. The payment is taken into account if it has a non−zero amount, is subject to completion and is not entirely completed.

Note
In the case where a given payable is to be paid partially (e.g. a purchase invoice paid by several bank transfers – included in several SRO documents), all previously added SRO documents must be paid; only then will the system be able to calculate a correct amount to be transferred in the next SRO document.

It is only possible to confirm SRO documents in which:

  • a bank account with account number is assigned to each customer/vendor
  • a bank account with account number is assigned to each bank account
  • payments value is other than zero

Note
It is only possible to confirm SRO documents containing payments of the split payment type if those payments have VAT amount, customer’s/vendor’s TIN and document number filled in.
Detailed information on split payment handling upon SRO export may be found in chapter <<Split payment mechanism in the export of statements of remittance orders and import of bank statements.>>

Tab Description

This tab is used for providing additional information regarding a Statement of Remittance Orders.

Tab Attributes

Detailed description of the tab Attributes can be found in <<Article>>.

Tab Attachments

Detailed description of the tab Attachments can be found in <<Article>>.

Exporting of transfer orders to a file

Generating a transfer file from an SRO document is possible only if the document is confirmed and has a specified file format and the directory it must be saved in. The file can be generated from the level of the list of SRO documents and from the level of a SRO document form, after selecting the button [File] available in the Generation button group. Upon generating the file from SRO document, the document status changes to Sent.

In particular cases (e.g., when a payment which should not be included in the statement was added or the file format was not inserted), it is possible to change its status back to the previous one. From the level of the context menu of a SRO document, there are two options available, which allow for changing its status:

  • [Undo Sending] – the option is active only for a document with Sent status and changes its status back to
  • [Undo Confirmation] – the option is active only for a document with Confirmed status and changes its status back to

Upon providing appropriate data, the file can be generated again.

Option of restoring SRO document status