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.

[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.
  • that comes from a confirmed document (exception is an opening balance document whose payment can be added also when the OB is still unconfirmed)

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.

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
  • Date of Receipt − date of receipt from the source document and in case it is missing

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
When adding a payment to the statement of remittance orders the compliance between the bank account indicated in the payment and the customer’s bank account indicated on the white list of taxpayers, is checked. Such verification is performed on the same terms as the verification performed when adding payment to an item of a statement remittance order.
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 article 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 here.

Tab Attachments

Detailed description of the tab Attachments can be found in here.

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.

Note
When adding a payment to the statement of remittance orders, the compliance between the bank account indicated in the payment and the customer’s bank account indicated on the, so-called, white list of taxpayers, is checked. Such verification is performed only if on the payment, as entity, a domestic customer of Business entity type, is selected and the document value is higher or equal to the control limit set in the company configuration. If the account number selected in the payment is different than the number on the white list, the following message is displayed: The selected bank account number of this customer/vendor is not listed in the VAT-registered taxpayer register. Are you sure you want to send the bank transfer with such a bank account number? Yes/No. If the user selects the option Yes, the payment will be added to the statement. In case  of selecting the option No, the payment will be not added to the statement.
Note
If in the statement, transfer format of Web Service type is indicated, after selecting [File] button, window Transfer Order Signing is opened, where it is possible to sign the order with the use of a selected certificate and to export it to the bank or to export it without any sign. If the order is sent without a sign, it will be necessary to confirm its execution from the level of the bank system.

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

Czy ten artykuł był pomocny?