Preference - Bookkeeping

In the Account set preferences, you can define account sets to be used when defining posting rules. An account set consists of a code, account set name, and individual accounts. Define an account number and name for each account.

You can add the accounts manually one by one or click Import/export and then copy and paste the accounts on separate lines as text.

You can also fetch the account name and number dynamically from the account information of a portfolio or reported transaction's security:

In the General preferences, you can define the logic used to create bookkeeping postings from transactions. The following table lists the configurations available:

In the Posting rule preferences, you can define different rules that affect the formation of the bookkeeping report or the generation of postings (if bookkeeping is enabled). These rules describe, which transactions, linked to a security with certain characteristics, are recorded to the debit and credit sides of the chosen bookkeeping account.

A posting rule consists of a name, a code, and a link to a defined account set. The link to an account set defines the accounts available for defining the posting rules: only the accounts defined for the linked account set are available.

In addition to the basic information, a posting rule consists of multiple precise rules, which are defined against a certain bookkeeping account: the whole posting rule is a combination of several, individual rules, each representing an entry in bookkeeping. A new individual rule to the posting rule is added with the Add button at the bottom of the window.

When posting-based bookkeeping is enabled, you can see an extended set of selectable rules and charge types compared to the available fields in standard bookkeeping. When bookkeeping is not enabled, you can only see the standard options. In addition, you can search for posting rules by filtering a posting rule set with the content of the available columns.

An individual rule is defined as a combination of a certain transaction type, security's characteristics, account from the chosen account set, and decision of debit/credit:

A new individual rule is added to the posting rule or the changes made to the rule are saved with the + button, after which the rule is shown in the rule table below the posting rule basic information.

The individual rules within an entire posting rule are shown in the table, grouped under the rule-defining conditions of transaction type + security's chosen characteristic. If an individual rule is changed, it is then re-grouped if necessary - you can always see an up-to-date grouping of your individual posting rules.

The posting rule table allows you to see all the individual rules with a quick glance, and the information of the rules is divided into columns.

To manage the posting rules more effectively, the following functions are available:

Duplicating an entire posting rule. To duplicate an entire posting rule set, e.g. all the individual rules defined within a posting rule set, click the Duplicate button on the left below the defined posting rule sets. A new posting rule set is created, and the code and name of the set are set with the text "-copy" at the end.

Duplicating a group of rules. To duplicate a group of rules, e.g. all the individual rules with the same name / the same combination of transaction type and security characteristics, right-click the posting rule group and select "Duplicate". Define the combination of transaction type and security characteristic you want the copied rules to be applied to, and new rules are created with these new selections.

Duplicating an individual rule. To duplicate an individual rule, right-click the individual rule and select "Duplicate". The selections of the copied rule are shown as default - define the combination of transaction type and security characteristic you want the copied rule to be applied to, and a new rule is created with these new selections.

Exporting posting rules in the XLS file . To export rules as an Excel file, choose the rule set, click and download the file.

Exporting posting rules in the CSV file. To export the rules in the CSV file that you can edit and import back in the system, choose the rule set, click Export , and download the file.

Importing posting rules in the CSV file. To import a CSV file with posting rules, click Add posting rule, fill in the Name, unique Code , and Account set fields, and click Import to upload the file. Note that the CSV file must contain the same account as in the selected account set.