Creating Third-Party Invoices
Third-party invoices are the invoices that track the incomes and expenses resulted from contracts based on the bank or financial institution's agreements with third-party entities (agents, brokers, etc.) . You can allow Core Banking to create the invoices automatically, or you can create invoices manually.
Core Banking automatically creates invoices for approved third-party agreements, using a dedicated scheduled job, both for PaymentOut
and for PaymentIn
. The automatic invoices contain the same information as the manually added ones, with the difference that Start Period = End Period = current system date
. The job runs once each night and creates third-party invoices, for the combination of third-party entity/ agreements currency, during the validity of the agreement, on the Payment Day of each agreement, as defined in the third-party agreement's Payment Periodicity
(daily, monthly, or weekly). The job also creates invoice detail records.
To prevent losing profits, there may be situations when the financial institution claims back all or some of the commission already paid out to third-party entities, due to the fact that the affected contracts were closed before their due date. Core Banking automatically identifies the contract events that determine the clawback (for example, Early Repayment events). To make use of the clawback settings, make sure that you mark the desired transaction types with Is Clawback Transaction = True
, and those transaction types are selected at the banking product type level or at the banking product level, depending on your agreement pricing definition. Core Banking calculates the clawback commission for each contract and inserts a corresponding invoice detail for the invoice generated for the third-party entity. If no invoice was yet generated for the third-party entity, a new invoice is created, and the invoice details are included there.
If a contract is marked as blocked for further agreements after performing a clawback payment (
Block After Clawback
= True
), when a clawback commission is paid for this contract, no other third-party commission found on the contract can be invoiced by the system, hence, for the same agreement pricing, no future invoice details are generated.For any type of transaction performed on the contracts subject to agreements that have Has Clawback = True
, if the Clawback Period covers the date of the transaction and the contracts are closed, then the system automatically generates an invoice so that the broker is charged.
Let's say you have a transaction that has Has Clawback = True
, it is included in the product that is captured in the Agreement Pricing Object section of the agreement, and it is also captured in the Clawback Settings' Clawback transaction types
field. When a contract is created for one of these products including the specified transaction, Core Banking commissions the third-party entity as defined within the agreement. If the transaction targeted for clawback happens within the time frame resulting from clawback period type and period, Core Banking automatically generates an invoice for the clawback commission.
For a setup like the above, if all the conditions are met and a contract for a Buy Now Pay Later product type is included in the invoice for the agreement and if an Early Repayment transaction is performed within the first 3 months from creating the contract/ generating the initial commission, then Core Banking triggers the clawback automatically.
Using Core Banking's user interface, you can create third-party invoices from a dedicated menu item, or directly from an approved agreement's page, with a few differences for each method, as follows:
Follow these steps to create new third-party invoice records for any approved agreement:
-
In the FintechOS Portal, click the Insert button on the top right side of the Invoices page. The Add Invoice page is displayed.
-
In the General Data section of the newly displayed page, fill in, view or modify the following fields:
-
Name - Automatically filled in with the name of the invoice record, after saving the record. You can't modify this field.
-
External Identifier - Enter an external identifier for the invoice, if needed.
-
Invoice Date - Automatically filled in with the current date of the system. You can modify this date.
-
-
In the Period section, fill in the following fields:
-
Start Period and End Period - Select the starting and the ending date of the interval during which Core Banking filters the contracts that are subject to invoicing. The
Start Period
must be<= End Period
.
-
-
In the Payment Data section, fill in or view the following fields:
-
Currency - Select the currency in which the invoice is to be paid.
-
Total Amount To Pay and Total Amount To Recover - The total amounts to pay to and to recover from the third-party, expressed in the selected currency. You can't modify these fields. T hey are automatically calculated by Core Banking based on the invoice details entered later, after saving the invoice record.
-
-
In the Account Data section, fill in the following fields:
-
Agent/ Broker/ Insurer/ Merchant - Select the third-party entity for whom you are creating the invoice.
-
Bank Account - Select the third-party entity's settlement account. You can only choose from the list of the entity's accounts opened in the selected currency.
-
Reconciliation Account - Select the financial institution's reconciliation account. You can only choose from the list of the accounts opened in the selected currency.
-
-
Click the Save and Reload button.
After saving the invoice record, the Invoice page also displays the Invoice Details section, containing a list with all the invoice details attached to the invoice, and the Payments section, containing information about the payments performed by Core Banking.
-
Continue with adding an invoice detail to the invoice in Draft status. Click Insert within the Invoice Details section on the Invoice page.
The Invoice Detail page is displayed. -
On the Invoice Detail page's General Data section, fill in or view the following fields:
-
Name - Automatically filled in with the name of the invoice detail record, after saving the record. You can't modify this field. This is the contract number.
-
Invoice - Automatically filled in with the name of the invoice record. You can't modify this field.
-
Agreement - Select the agreement for which you are inserting the invoice detail. You can only choose from the list of agreements with Approved status created for the third-party mentioned in the invoice record.
-
Detail Type - Select the type of payment to be performed for the invoice detail:
Payment In
- for payments from the third-party's settlement account into the financial institution's reconciliation account;Payment Out
- for payments from the financial institution's reconciliation account into the third-party's settlement account.
-
-
In the Settings section, fill in the following fields:
-
Commission - Select the commission to be applied for this invoice detail. You can only choose from the list of commissions mentioned in the selected agreement, that have a valid value during the invoice's period.
NOTE
If the selected commission is ofThird-Party Clawback
commission type, thenDetail Type = Payment In
. -
Contract - Select the contract that is the object of the invoice detail. You can only choose from the list of contracts with the third-party having the role specified in the selected agreement, and having the activation date during the period of the invoice, for commissions with
Once
periodicity type.
For clawback commissions, the list is also filtered to display only the contracts having an event selected asClawback Transaction Types
selected earlier in the Agreement Pricing Detail section, within the clawback period.
If the commission is applied to contract installments, than the due date of the installment must be within the period of the invoice.NOTE
For commissions withOnce
periodicity type, the contract can't be attached to an invoice detail more than once. -
Contract Event - Select the contract event that is the object of the invoice detail. You can only choose from the list of contracts events from the selected contract.
-
-
In the Payment Data section, view in the following automatically filled in fields:
-
Currency - The currency selected at the commission level. You can't modify this field.
-
Exchange Rate - The exchange rate for Commission Currency to Invoice Currency valid on the date of the invoice, or the latest exchange rate recorded for Commission Currency to Invoice Currency. You can't modify this field.
-
-
In the Values section, view in the following automatically filled in fields:
-
Value - The commission value for the selected contract at the current date, calculated by Core Banking. You can't modify this field.
-
Equivalent Value - The commission's equivalent value in the invoice's currency, calculated by Core Banking as (
Exchange Rate * Value
). You can't modify this field.NOTEEquivalent Value
is summed up toTotal Amount To Pay
ifDetail Type = Payment Out
.Equivalent Value
is summed up toTotal Amount To Recover
ifDetail Type = Payment In
.
-
-
Click the Save and Close button.
-
Change the status of the invoice record to Approved to allow Core Banking to automatically process the payments.
You can create as many invoice details as needed for an invoice, but you can create only one invoice detail for the combination between a contract, a commission and a detail type. Core Banking prevents you to create duplicate invoice detail records containing the same combination of
Contract
, Commission
, and Detail Type
values.Follow these steps to create new third-party invoice records directly within the Agreement page of an approved agreement record:
-
Open an agreement in Approved status and scroll to its Invoices section. Here you can insert, delete or export invoices for the selected agreement.
The section displays information about the invoice: name, third-party, currency, start and end period, total amount to pay to the third-party and to recover by the financial institution, record's business status.
-
Click Insert to display the Add Invoice page:
-
In the General Data section of the newly displayed page, fill in, view or modify the following fields:
-
Name - Automatically filled in with the name of the invoice record, after saving the record. You can't modify this field.
-
External Identifier - Enter an external identifier for the invoice, if needed.
-
Invoice Date - Automatically filled in with the current date of the system. You can modify this date.
-
-
In the Period section, fill in the following fields:
-
Start Period and End Period - Select the starting and the ending date of the interval during which Core Banking filters the contracts that are subject to invoicing. The
Start Period
must be<= End Period
.
-
-
In the Payment Data section, fill in or view the following fields:
-
Currency - Select the currency in which the invoice is to be paid.
-
Total Amount To Pay and Total Amount To Recover - The total amounts to pay to and to recover from the third-party, expressed in the selected currency. You can't modify these fields. T hey are automatically calculated by Core Banking based on the invoice details entered later, after saving the invoice record.
-
-
In the Account Data section, view or fill in the following fields:
-
Agent/ Broker/ Insurer/ Merchant - Automatically filled in with the third-party entity for whom you are creating the invoice. You can't modify this field.
-
Bank Account - Select the third-party entity's settlement account. You can only choose from the list of the entity's accounts opened in the selected currency.
-
Reconciliation Account - Select the financial institution's reconciliation account. You can only choose from the list of the accounts opened in the selected currency.
-
-
Click the Save and Reload button.
After saving the invoice record, the Invoice page also displays the Invoice Details section, containing a list with all the invoice details attached to the invoice, and the Payments section, containing information about the payments performed by Core Banking.
-
Continue with adding an invoice detail to the invoice in Draft status. Click Insert within the Invoice Details section on the Invoice page.
The Invoice Detail page is displayed. -
On the Invoice Detail page's General Data section, fill in or view the following fields:
-
Name - Automatically filled in with the name of the invoice detail record, after saving the record. You can't modify this field. This is the contract number.
-
Invoice - Automatically filled in with the name of the invoice record. You can't modify this field.
-
Agreement - Select the agreement for which you are inserting the invoice detail. You can only choose from the list of agreements with Approved status created for the third-party mentioned in the invoice record.
-
Detail Type - Select the type of payment to be performed for the invoice detail:
Payment In
- for payments from the third-party's settlement account into the financial institution's reconciliation account;Payment Out
- for payments from the financial institution's reconciliation account into the third-party's settlement account.
-
-
In the Settings section, fill in the following fields:
-
Commission - Select the commission to be applied for this invoice detail. You can only choose from the list of commissions mentioned in the selected agreement, that have a valid value during the invoice's period.
NOTE
If the selected commission is ofThird-Party Clawback
commission type, thenDetail Type = Payment In
. -
Contract - Select the contract that is the object of the invoice detail. You can only choose from the list of contracts with the third-party having the role specified in the selected agreement, and having the activation date during the period of the invoice, for commissions with
Once
periodicity type.
For clawback commissions, the list is also filtered to display only the contracts having an event selected asClawback Transaction Types
selected earlier in the Agreement Pricing Detail section, within the clawback period.
If the commission is applied to contract installments, than the due date of the installment must be within the period of the invoice.NOTE
For commissions withOnce
periodicity type, the contract can't be attached to an invoice detail more than once. -
Contract Event - Select the contract event that is the object of the invoice detail. You can only choose from the list of contracts events from the selected contract.
-
-
In the Payment Data section, view in the following automatically filled in fields:
-
Currency - The currency selected at the commission level. You can't modify this field.
-
Exchange Rate - The exchange rate for Commission Currency to Invoice Currency valid on the date of the invoice, or the latest exchange rate recorded for Commission Currency to Invoice Currency. You can't modify this field.
-
-
In the Values section, view in the following automatically filled in fields:
-
Value - The commission value for the selected contract at the current date, calculated by Core Banking. You can't modify this field.
-
Equivalent Value - The commission's equivalent value in the invoice's currency, calculated by Core Banking as (
Exchange Rate * Value
). You can't modify this field.NOTEEquivalent Value
is summed up toTotal Amount To Pay
ifDetail Type = Payment Out
.Equivalent Value
is summed up toTotal Amount To Recover
ifDetail Type = Payment In
.
-
-
Click the Save and Close button.
-
Change the status of the invoice record to Approved to allow Core Banking to automatically process the payments.
You can create as many invoice details as needed for an invoice, but you can create only one invoice detail for the combination between a contract, a commission and a detail type. Core Banking prevents you to create duplicate invoice detail records containing the same combination of
Contract
, Commission
, and Detail Type
values.