All pages
Powered by GitBook
1 of 5

Loading...

Loading...

Loading...

Loading...

Loading...

Custom booking CSV file

Here, you will find parameters for custom booking CSV and a sample file.

Parameters with description

Row title
Description

accountId

An existing account technical identifier in Tuum.

Note: custom bookings should be permitted on the account.

transactionTypeCode

The transaction type, including the fee or transaction with the fee where custom bookings are allowed. For more details, see annex.

Note: the transaction direction is automatically derived from the transaction type.

valueDateRule

The following options are available:

  • APPROVAL_DATE - the value date will be the date when the custom booking is finally approved.

  • ENTERED_DATE - the value date will be the date that was entered as a custom booking value date.

valueDate

The value date; format: yyyy-mm-dd.

  • Mandatory if ENTERED_DATE;

  • Must be empty (“,,”) if APPROVAL_DATE.

Note: It cannot be in the future or before the allowed value date min date.

amount

Custom booking amount; must be positive.

currencyCode

Custom booking currency; must be allowed currency.

applyFee

The following options are available:

  • TRUE,

  • FALSE.

details

A textual description.

additionalInfo

Additional info not visible to the customer. Not mandatory

Note: If additionalInfo is empty then comma (“,”) must be still added to the file as field delimiter.

label

Label value posted with PERIODICAL or ONETIME fee to specify fee type at a more detailed level. Not mandatory

Note: If label value is empty then comma (“,”) must be still added to the file as last field delimiter

Sample CSV file

The CSV file below consists of five rows, each representing a different use case.

  1. row is the file header, which consists of the list of the parameter names. It is mandatory to have this row first in the file.

  2. row without additionalInfo, without label.

  3. row without additionalInfo, with label.

  4. row with additionalInfo, without label.

  5. row with long additionalInfo, with label.

accountId,transactionTypeCode,valueDateRule,valueDate,amount,currencyCode,applyFee,details,additionalInfo,label
ID-7479,CAMP2ACC,APPROVAL_DATE,,2000.01,EUR,TRUE,Text to account statement 0,,
ID-7479,SETUP_FEE,APPROVAL_DATE,,2001.01,EUR,TRUE,Text to account statement 1,,SETUP_VIBAN
ID-7479,CAMP2ACC,APPROVAL_DATE,,2002.01,EUR,TRUE,Text to account statement 2,Internal comment 2,
ID-7472,SETUP_FEE,ENTERED_DATE,2028-01-16,2003.01,EUR,TRUE,Text to account statement 3,Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. Internal comment 3 very long. END,SETUP_VIBAN

File upload guidelines

When creating your CSV file, adhere to the following guidelines.

  • Only include up to 1000 rows in the CSV file.

  • Avoid adding quotation marks around any text.

  • Ensure there are no commas inserted within the details or additionalInfo fields.

  • Use a unique name for each file you upload.

Custom booking view page

The custom booking view page is separated into different sections.

Some of the sections are dedicated to closed accounts only.

The custom booking page generally displays the following information:

  • Custom booking details - information about the custom booking, such as amount, transaction type, status, etc.

  • Related events -

    • Events caused by this custom booking on the closed account.

    • Events caused by this custom booking reversal on the closed account.

Related events section is dedicated to the closed accounts only.

  • Related account transactions -

    • Transactions caused by this custom booking on the open account.

    • Reversal transactions caused by this custom booking reversal on the open account.

  • Reversal account transactions - Transactions caused by another custom booking reversal on the open account that reversed the current custom booking on the open account.

  • Reversal events - Events caused by another custom booking reversal on the already closed account that reversed the current custom booking made when the account was still open.

  • Original transactions -

    • Transactions caused by another custom booking on the open account that are reversed by the current custom booking reversal on an open account.

    • Transactions caused by another custom booking made when the account was open are reversed by the current custom booking reversal made when the account was already closed.

Custom booking review process

If an approval process for a custom booking is enabled in the configuration, then any other employee(s) assigned to approve it must do so. The custom booking will be in the Waiting for Approval status until all necessary approvals have been made. Once all approvals are complete, the new custom booking will be initialised.

Search custom bookings for approval

  1. From the content menu, choose the Custom booking option.

  2. Fill in the search details > click on the Search button.

To ease the search use the Status parameter and search for custom bookings in the Waiting for approval status.

  1. Click on the Custom booking ID to view the custom booking details.

  2. Make the approval decision: Reject custom booking or Approve custom booking.

Open the .

account view page

Custom bookings

The BackOffice interface supports the custom bookings option. Here are some example use cases where you might need to make a custom booking.

  • Enter a card transaction manually or reverse it.

  • Reverse the applied fee for the customer.

  • Enter some transactions like fees, compensations or chargebacks manually.

  • Enter interest or fee corrections.

  • Make write-offs before account closure.

  • Making resolving entries on a closed account.

Below you will find more information about:

Make custom booking

  1. From the content menu, choose the Custom booking option.

  1. Click the Save button.

BackOffice users with the MAKE_TRANSACTION privilege can initiate custom bookings.

Make custom booking bulk upload

To upload the CSV file:

  1. Administration > File import.

  2. On the file import page, click the Import file button.

  3. In the file import window, set the Import type to Custom bookings, upload the CSV file > click the Import button.

The outcome can be an error or success once you have uploaded your file with custom bookings.

  1. Error: Should the Tuum system encounter an error in any row of your custom booking file, it will reject the entire file. The response will detail the error associated with the specific problematic row.

  2. Success: The Tuum system has created all custom bookings in the CSV file.

The Tuum system bypasses account balance checks for custom booking file uploads. Therefore, transactions can push account balances into the negative, regardless of the negative balance allowance settings.

Make custom booking on a closed account

The Tuum system supports custom bookings on closed accounts. This functionality is needed when transactions or transaction reversals need to be registered in Tuum after the account is closed. For example, if the information about the card purchase is received after the card account is closed.

To register custom booking on a closed account, you need to complete two steps:

Register a custom booking on a closed account

  1. From the content menu, choose the Custom booking option.

  2. Click the New custom booking in closed account button.

  1. Fill in the custom booking details, and click Save.

  • When creating a reversal on the closed account, you need to refer to the original transaction.

Resolve a custom booking

After creating a new incoming custom booking on a closed account, it needs to be resolved to choose where the funds are directed:

  • Transferred to the internal account - to transfer funds to an internal account.

  • Registered a bank revenue - to register funds as a bank income.

To resolve a custom booking:

  1. Find a custom booking on a closed account.

  2. Open the custom booking view page > on the upper right corner, click the Resolve button.

  1. The BackOffice will open the Custom booking resolve page > fill in the parameters > click the Resolve button. See below for more details.

Search custom booking

  1. Accounts > Search > Custom bookings.

  2. Fill in the search details > click the Search button.

  3. Click the Custom booking ID to view the details.

Custom booking parameters

,

,

,

Open the .

Click the New custom booking button and fill in the .

Using the BackOffice interface, you can bulk upload the custom booking files in the comma-delimited CSV format. Find information about the CSV file here: .

,

.

the closed account in question > open the .

Only allowed transactions can be reversed. See the page for more details.

Parameter name
Type
Description
account view page
parameters
custom booking CSV file
Find
account view page
account transaction types
Make custom booking
Make custom booking bulk upload
Make custom booking on a closed account
Search custom booking
Register custom booking on a closed account
Resolve custom booking

Direction*

List

Select the custom booking direction:

  • Incoming - credit to the account,

  • Outgoing - debit from the account.

Transaction type*

List

Select the transaction type.

Note: only a subset of transaction types are available for custom bookings.

Transaction subtype

List

Select the transaction subtype.

Note: this field is only available when the transaction type has subtypes.

Fee type

List

This parameter fills up automatically based on the chosen Transaction type and cannot be edited.

Note: this field is available only when the chosen Transaction type is onetime fee (e.g. SETUP_FEE) or periodic fee (e.g. ACC_ADM_FEE).

Fee subtype Note: the fee subtype name is displayed.

List

Select the fee subtype. (Fee subtypes for onetime or periodic fees are categorised with labels.)

Note: If the fee subtype has a pricelist or special price, the price will automatically fill up the amount.

Negative balance allowed

Checkbox

This checkbox about negative balance allowance fills up automatically and cannot be edited.

Value date rule*

List

Select the value date rule:

  • Entered date - the value date will be the date that was entered as a custom booking value date.

  • Approval date - the value date will be the date when the custom booking is finally approved.

Value date*

Date

Select the custom booking value date. Format: DD.MM.YYYY.

Note: this field is only available when the Entered date rule is chosen.

Custom booking currency code

List

Select the currency. Note: The default value is the default currency of the account.

Available balance

Number

This field fills up automatically and shows the available account balance in the currency selected for the Custom booking currency code.

Amount, currency*

Number

Enter the custom booking amount.

Note: the currency fills up automatically with the currency selected for the Custom booking currency code.

Details*

Text

Enter custom booking details. Note: This text will be included in the customer account statement.

Additional info

Text

Enter additional info if needed. Note: This text is for internal purposes and will not be included in the customer account statement.

Fee transaction type

Text

This additional fee transaction type parameter fills up automatically and cannot be edited.

Note: this field is available only when the chosen transaction type has a related transactional fee. For example, with the base transaction CARD_TOPUP, the related fee transaction CARD_TOPUP_FEE can be posted if a pricelist or special price exists.

Fee amount, currency

Text

These parameters are filled up automatically and cannot be edited.

Note: this field is available only when the chosen transaction type has a related transactional fee and a pricelist or special price.

Apply fee

Checkbox

Select or deselect the checkbox for the applicability of the additional fee transaction.

Note: this field is available only when the chosen transaction type has a related transactional fee and a pricelist or special price.