To view the Wealth Reporting Guide please navigate via Download File -> User Guide -> Download
Contents
Chapter 1: A Practical Guide to Finticx. 10
1.1 Getting Started with Finticx. 10
1.2 Navigating through Finticx. 11
1.4 Inviting others to Finticx. 16
1.4.4 Walkthrough: Restrict user’s access with data and report roles. 18
1.5 Custom Look: Applying Your Brand Identity in Finticx. 20
1.6.3 Sorting, Filtering, and Replacing.. 22
1.8 Customizable Dropdowns. 29
1.10 Case Study: Finvision Family Office.. 31
1.10.1 Case Study: Intro to Finticx. 31
Chapter 2: Organisational Structure.. 36
2.1 The Concept of Families. 36
2.1.3 Actuals and Forecasts. 38
2.1.5 Case Study: Creating New Families. 40
2.2 How to Structure Entities. 45
2.2.2 Entity vs Direct Participation. 45
2.2.5 Case Study: Creating an Entity Structure.. 51
2.2.6 Case Study: Creating and Assigning Roles. 56
2.3.2 Case Study: Creating a Strategic Allocation. 63
Chapter 3: Managing Assets. 64
3.2.2 IBAN and Offsetting IBAN.. 66
3.2.3 Cash & Equivalents as part of a Bank Portfolio.. 68
3.2.4 Case Study: Creating Cash & Equivalent Assets. 69
3.3.2 Bank-Portfolio without Instrument Details. 78
3.3.3 Bank-Portfolio with Instrument Details. 78
3.3.4 Case Study: Creating Bank-Portfolios. 79
3.3.5 Case Study: Allocating Geographies, Sector and Currency Exposure.. 83
3.4.3 Real Estate Project Development. 89
3.4.4 Case Study: Creating Real Estate Assets. 90
3.4.5 Case Study: Creating Project Development Assets. 96
3.5.4 Case Study: Creating Private Equity Asset. 100
3.6 Direct Participations. 104
3.6.1 General Information. 104
3.6.2 Entity or Direct Participation. 104
3.7 Borrowings & Lendings. 106
3.7.1 General Information. 106
3.7.4 Case Study: Creating Borrowings. 108
3.7.5 Case Study: Creating Lendings. 111
3.7.6 Case Study: Linking a Borrowing to a Real Estate Asset. 113
3.8 Other Valuation Groups. 115
3.8.1 Collections & Varia. 115
Chapter 4: Net Asset Value, Performance, Transactions and Valuations. 116
4.2.1 General Information. 117
4.3.1 General Information. 118
4.3.2 Transaction Type Sections. 118
4.3.3 Practical Transaction Guide.. 120
4.3.5 Single Sided vs Mirrored Transactions. 163
4.4.1 General Information. 165
4.4.2 Net Asset Value as a result of a Valuation. 165
4.4.3 Net Asset Value as a result of Transactions. 165
4.4.4 Net Asset Value as a result of Valuations and Transactions. 166
4.4.5 Net Asset Value as a result of Quantity x Market Price (Listed). 167
4.5.1 General Information. 168
4.5.3 Realised Performance.. 169
4.6 Basic Case Study: Metlen Energy & Metals (Direct Participation). 170
4.6.1 Case Study: Creating a Valuation – Creating the Initial Valuation. 170
4.6.2 Case Study: Creating Transactions. 173
4.7.1 General information. 178
4.7.2 Document Levels and Categories. 178
4.7.3 Working with the Document Library. 179
4.7.4 Case Study: Building Carlton's Document Library. 179
Chapter 5: Finticx’ Import Module.. 181
5.4 Import Template Files. 184
Chapter 6: Forecasting & Cash Planning.. 186
6.2.1 General Information. 186
6.2.2 Private Fund Forecast. 186
6.2.4 Real Estate Forecast. 188
6.2.5 Case Study: Forecasting Real Estate.. 189
6.2.6 Forecasting Transactions. 192
6.3.1 General Information. 193
Chapter 7: Report – Wealth Reporting Dashboard.. 195
7.2 Navigating through the Reports. 196
7.2.1 Navigating through the top bar. 196
7.2.2 Navigating through the navigator. 197
7.3.1 General Information. 198
7.3.2 Defining the reporting scope and customizing your view.. 199
7.3.3 Working with filters. 200
7.3.4 Customizing Visuals. 201
7.4 Time Window (MTD, QTD, STD, YTD, HTD, Custom, ITD, LTM). 204
7.6 Investment Portfolio.. 207
7.6.1 General Information. 207
7.6.2 Net Asset Value & Performance Summary. 209
7.6.3 NAV and Performance Breakdown by category. 209
7.6.4 Periodic & Cumulative Total Performance and Change in NAV.. 209
7.7 Family Assets & Operating Participations. 212
7.8 Analysing Performances. 212
7.9 Overview in Time Series. 213
7.11 Cash and Quantity Reconciliation. 216
Chapter 8: Report – Wealth Reporting Booklet. 218
Chapter 9: Report – Custom Reports (Add-on). 219
Chapter 10: Instrument Reporting (Add-on). 220
10.2 Benefits of Instrument-Level Reporting.. 220
10.3 Data Entry Methods for Instruments. 221
Chapter 11: Current Account Bank Integration. 222
Appendix A: Input Field Explanation. 228
E.6. Private Equity Classification. 233
E.7. Private Equity – J Curve (& Forecast Parameters). 233
E.8. Private Equity - Fee Structure | Gross to Net. 234
E.9. Private Equity - Other. 235
E.12. Forecast Parameters – Real Estate.. 236
E.13. Borrowings & Lendings. 237
Introduction
Welcome to the Wealth Reporting Bible — the comprehensive user guide for the Wealth Reporting Module of Finticx. Finticx is a reporting platform designed to provide family offices, wealth managers, and private asset holders with a structured, transparent, and consolidated view of their entire wealth portfolio.
This guide follows the same layered approach that underpins the Finticx data model. It begins with the foundations: getting started with the platform, navigating the interface, and configuring user roles and permissions. From there, it covers the organisational structure — the hierarchy of Families, Entity Groups, and Entities that forms the backbone of all data organisation and reporting.
With the organisational layer in place, the guide introduces the wealth components: the diverse range of assets — from Bank Portfolios and Real Estate to Private Funds, Direct Participations, and beyond — that together make up a wealth portfolio. The guide then brings everything together through valuations and transactions, explaining how these interact to determine Net Asset Value and performance over time. Building on this, the document covers bulk data import, forecasting, and cash flow planning capabilities.
Finally, the guide addresses the reporting layer — where all data converges into meaningful dashboards, booklets, and custom reports designed for actionable wealth analytics. Optional add-ons such as Instrument Reporting are covered for users requiring look-through transparency at security level.
Each topic combines a clear theoretical explanation with practical case studies built around a fictional family office — Finvision Family Office — ensuring every concept is grounded in a realistic scenario. Whether you are an administrator, contributor, or report consumer, this guide equips you with the knowledge to get the most out of Finticx.
Chapter 1: A Practical Guide to Finticx
1.1 Getting Started with Finticx
Your Finticx journey begins with an invitation email. You will receive this email either from an invitation from the administrator of your license or directly from a Finticx employee.
To access Finticx, navigate to app.finticx.com or use the direct link provided in your welcome email.
To create your account, select ‘No account? Create one’ in the application. You will then receive a confirmation code at the same email address where you’ve received the invitation email. Once confirmed, you will be prompted to set up Multi-Factor Authentication (MFA) using your phone number, where you will receive an additional verification code. You will be prompted to review and accept the General Terms & Agreements prior to entering the application.
Follow the on-screen instructions to set your password and choose your display name. The display name you select will appear at the top of your Finticx environment.
After logging in, if you are unable to see any data or modules, your user role may not yet have been assigned. In that case, please contact the owner of your license to request access.
1.2 Navigating through Finticx
Some terms will frequently come back in the explanations. We have listed the most important ones here.
1.2.1 Glossary
Workspace. The Workspace is your personal Finticx environment — the complete platform as it appears after you log in. It reflects your organisation's branding and displays only the data, modules, and reports your user role grants you access to.
Module. A Module is a self-contained functional area within Finticx, grouping related data entry tables, configurations, and reports around a specific domain. The Wealth Reporting module, for instance, covers all aspects of multi-asset portfolio tracking from data input through to reporting output. In the future, more modules, such as Financial Reporting, will become available.
Input Table. An Input Table is a structured data entry screen accessible from the Side Panel. It presents records in a tabular format and supports creating, editing, sorting, filtering, and deleting entries. Input tables are the primary means by which data is entered into Finticx before being pushed to the reporting layer via the Process Monitor.
Form View. The Form View is the individual record screen that opens when you create or edit an entry in an input table. It displays all fields associated with a given record and indicates which fields are required. Fields highlighted in red signal missing or incorrect data.
User Menu. The User Menu is located in the top-right corner of the Application Header. It shows your display name and the currently active family, and allows you to switch between families and access basic account settings such as updating your display name.
1.2.2 The Side Panel
The Side Panel runs along the left side of the screen and serves as the main navigation hub for wealth reporting. At the top, a dropdown lets you switch between available reports. Below it, you can find the organisation pages that contain the core input data. They are listed and grouped by category. At the bottom of the panel, you can trigger a report refresh and see when the data was last updated.
Selecting a Report
On top, you can find the “Wealth Reporting” dropdown menu, which allows you to select the report you wish to view. All subscriptions include the “Wealth Reporting Dashboard” as a standard report as well as the “Wealth Reporting Booklet”, which is a print-friendly alternative to the Dashboard. In addition, Finticx offers the flexibility to create custom reports fully tailored to your specific reporting and analytical needs (cfr. Chapter 9).
Wealth Reporting–Specific Section
Organization Contains the core data input areas — Family, Entity, Entity Rollup, and Strategic Allocation. These sections are used to define and structure your organization within Finticx.
Wealth Components Provides access to and management of the various assets (and instruments, if included in your subscription) that together make up your wealth portfolio.
Valuations & Transactions Used to input and review valuation and transaction data. Each valuation and transaction is always linked to a previously created asset.
Process Monitor Pushes new or updated data from the input tables to the reporting layer, ensuring all reports reflect the latest changes. It also runs data quality checks on each refresh. Click Refresh Now to trigger a refresh directly or click the widget to open the Process Monitor page.
1.2.3 Application Header
The Application Header is on top of the screen. On the left, a dropdown lets you switch between available modules, like Wealth Reporting. On the right, your currently selected Family is displayed. Use the dropdown to switch between families — Finticx displays data for one Family at a time.
To the right, you will see your profile icon. Clicking on it opens the User Menu, which gives access to user and platform settings.
1.2.4 User Menu
The User Menu is accessible from the top-right corner of the screen by clicking your initials. It provides access to platform-wide settings and support resources. The options available depend on your user role.
User Settings Update your display name and preferred language. Currently available in English only. Accessible to all users.
Notification Provides an overview of all system messages generated by Finticx, such as successful exports and validation errors. Notifications can be filtered by module using the dropdown at the top.
Admin Center Restricted to administrator and covers connectivity, configurations, access management, and settings.
Support Hub Provides access to support resources and documentation that help you explore the features and understand how Finticx works.
Contact Offers a direct channel to technical support for specific questions or urgent issues.
Website Opens the Finticx website for general information about the platform.
1.3 User Roles
Finticx features a smart user role system, designed to give each user the appropriate level of access and control within the platform. This system allows administrators to assign specific permissions and restrictions based on user responsibilities. You can find an overview of the available roles and pricing on the finticx.com.
There are four predefined roles in Finticx: Admin (Workspace & Module), Contributor, Viewer, and Consumer. Internally, a fifth role ‘None’ exists, which (temporarily) removes all access from a user. All roles can view reports, but their permissions for data access and editing differ. An overview of these permissions is presented in the visual below.
Admins
The individual who signs the agreement with Finticx and purchases the license is automatically assigned the role of Workspace Admin. This is the highest access role. This person is responsible for inviting additional users to the platform and assigning appropriate user roles to them based on their responsibilities. There can be one or more workspace admins.
Next to the workspace admins, is also the role Module Admin. A module admin manages other users’ roles and data access inside the Wealth Reporting module.
Contributors can both enter and edit data.
Viewers can access and review input data but cannot make any changes to it.
Consumers have report-only access. They can view reports but do not have access to any underlying data.
1.4 Inviting others to Finticx
1.4.1 General Information
As mentioned above, the Application Admin has the right to invite a specific number of users, depending on the organization’s subscription plan. Both the Application Admin and designated Module Admins can manage the permissions and access rights of other users within the platform.
Additional users can always be requested and added to your subscription at the agreed contractual rate.
1.4.2 Inviting Users
To add a new user to your Finticx license, navigate via the user menu to the Access Management page.
This section provides an overview of all users. In the status column you can see whether they are active or invited, which modules they have access to, when they last logged-in, and since when they are a member. You can delete the user by selecting the bin icon.
To invite a new user, click Add New User on the bottom right of the screen. A form will appear where you can enter the user’s name and email address. Once submitted, the user will receive an invitation email to join your workspace in Finticx.
1.4.3 User Management
Here, the Admins manage all users across Finticx. The admins select the applicable user roles for each non-admin user for all available modules.
Each user has three distinct role types which will be explained in the following sections:
- User role
- Report role
- Data role
User Role
When you click on the User Role Dropdown, you can select from these 5 standard roles:
- Module Admin
- Contributor
- Viewer
- Consumer
- No Role
These roles determine the user’s level of access and editing rights within the Wealth Reporting module (cfr. section 1.3). Users assigned the role “No Role” will not have access to any data or functionality within the application. They will only gain visibility and access once their role is updated to one of the four predefined roles: Module Admin, Contributor, Viewer, or Consumer.
Data Role
A data role defines which families and entities a user can view, both in the data tables and in the reports. By assigning a data role to a user, you ensure that each person sees only the data relevant to their responsibilities. Every environment includes the pre-configured role "Access to all" as a starting point. For a step-by-step guide to creating and assigning Data Roles, see section 1.4.4.
Report Role
A report role defines which reports a user can access within the Wealth Reporting module. When a user is invited to Finticx, no report role is assigned by default, meaning they will not see any reports until one is set. By assigning a report role, you control whether they can view the Wealth Reporting Dashboard, the Wealth Reporting Booklet, or both. If your subscription includes custom reports, access to those can be managed in the same way. Every environment includes the pre-configured role "Access to all" as a starting point, but you can create additional roles to suit your needs. For a step-by-step guide, see section 1.4.4.
1.4.4 Walkthrough: Restrict user’s access with data and report roles
In this walkthrough, we give our colleague Ward Verfaillie restricted data and report access as we only want him to see the data of three entities and to have access to the report “Wealth Reporting Dashboard”.
1.4.4.1 Restricting Data Access
To grant a user restricted access within the application, the first step is to create a data role. It defines which families and entities a user can view in both the data tables and the reports.
To create a new data role, navigate to Admin Center → Access Management → Data Roles. Click Add Role to create a new role and give it a name - because Ward is responsible for following up on the family's investments, we will call this one Investment Role. Click the Access dropdown to select the families and entities this role should have access to. In Ward's case, we limit his visibility to three entities within the Harrington family: Harrington Investments, Biotech, and Development. Save the role once your selection is complete.
The second step is to assign a user to a data role. To do this, navigate to User Management. Select the relevant user, choose the appropriate role from the dropdown, and confirm your selection. In our case, we select Ward and choose “Investment Role” from the dropdown.
Please note that any changes made to data roles will only take effect in the reports after the full report refresh is completed in the Process Monitor (cfr. section 1.7). Please note that Admins always have access to all Families and Entities.
1.4.4.2 Restricting Report Access
A report role defines which reports a user can view from the available reports in your workspace. The process mirrors that of creating a data role: first create the role, then assign it to the user.
To create a new report role, navigate to Admin Center → Access Management → Report Roles and click Add Role. Give the role a name — we will call this one Wealth Reporting Dashboard, because we want Ward to only have access to this report. Click the Access dropdown to select the reports this role should have access to. We select only Wealth Reporting Dashboard from the list. Save the role once your selection is complete.
To assign the role, navigate back to Access Management click on Ward’s row. Select Wealth Reporting Dashboard from the Report Role dropdown and save. You can also apply this role to other people in your team.
1.5 Custom Look: Applying Your Brand Identity in Finticx
Workspace Administrators have the possibility to define and modify the brand identity of their organization’s Finticx environment. This includes uploading the company logo and customizing the color palette to align the platform with your corporate branding.
To configure these settings, navigate to Admin Center → Settings
In the Logo section, click Browse Files to add your logo. The maximum supported image size is 1024 × 1024 pixels, although a logo with dimensions of around 1024 × 700 pixels generally provides the best results.
Next, you can tailor the appearance of your Finticx workspace by selecting your preferred color scheme. You can click directly on the color dots or use the pipette tool to choose custom colors.
- The navigation bar color determines the appearance of the Side Panel.
- The accent color defines the look of interactive elements such as the user icon and buttons, and info elements.
- The styling of the report is based on the 6 report colors, as well as the navigation bar color and the accent color. The additional 6 color fields influence the styling of reports, including chart and graph colors.
Once you have made your selections, click Save to apply your changes.
1.6 Input Functionalities
When you open any input table from the Side Panel, you will find several actions available depending on the table you are working in. You can create, duplicate, or delete records, and you can sort and filter the table to create a view that meets your needs. These customised views can be saved and loaded again at a later time.
In addition, you can export and import both Excel and CSV files from and into the tables.
1.6.1 Creating
To create a new entry, click the plus icon in the bottom-right corner of the page.
Before adding anything, make sure you are working in the correct input table. You can verify this in two ways: by checking which section is highlighted in the Side Panel, or by hovering over the plus icon to see what type of entry will be created. When you click the icon, an entry form will appear where you can create a new asset, valuation, or any other relevant record.
This method allows you to add entries one by one. If you want to add multiple entries at once, you can use the import function with Excel files. This process is explained later in this document.
1.6.2 Editing
Depending on your user role (cfr. section 1.3), you may have permission to either view or edit data. If the icon in the row is a pencil, you can edit the entry. If the icon is an eye, you only have viewing rights.
The color of these icons also indicates the completeness of the data. If an icon appears red, it means that some of the required information is missing or incorrect, which may result in errors or incomplete outcomes in the reports. It is recommended to review and correct these entries as soon as possible.
To open or edit an entry, click the corresponding icon.
1.6.3 Sorting, Filtering, and Replacing
You can sort one or more columns by clicking the column header you want to sort. To sort multiple columns, hold the Ctrl key on your keyboard while selecting additional headers. The number next to each column name indicates the order in which the sorting is applied. Columns that are currently sorted are highlighted in your selected accent color.
To filter values in one or more columns, use the search bar. Depending on the data type, you can either type a value or select one or more options from the dropdown list.
- For Yes/No or True/False fields, click the +/- box to apply your filter.
- For dates or periods, a calendar appears where you can select the desired time range.
- For number or percentage fields, you can define a lower and upper limit to filter by a range.
If you need to replace values in a column, look for the pencil icon next to the column name. Select from the dropdown the text you want to replace and the new value you want to substitute it with. A replacement is only applied when the full content of the cell matches the value entered in the “replace” field. In the example below, all Collection Types “Rare Books” will be replaced with “Valuable Books”.
Beyond individual replacements via the form, Finticx offers two bulk replace options: Replace all values overwrites every existing value in the column, while Replace all empty values fills only those cells currently without a value. Note that bulk changes are difficult to reverse once applied!
To limit changes to a subset of records, two approaches are available. The first is to apply an active filter before executing a bulk replace — the operation will then affect only the rows visible in the filtered view. This is particularly useful when a value is relevant only to specific valuation groups. The second is to manually select the target cells before applying the replace; only the selected cells will be updated.
1.6.4 Column Options
In the tables, you will also find several options in the bottom-left corner that allow you to adjust how your data and columns are displayed.
Click the reload icon to refresh the table and ensure that all recent changes are visible. This will also re-calculate the color of the pencil icons and check if possible errors are resolved.
You can manually adjust column widths by dragging the space between two cells to the right or left. If you want the columns to resize automatically to fit the widest content in each column, click the auto-width icon.
The filter icon indicates whether filters are currently active. It appears grey when no filters are applied and red when filters are in use. You can return to the default, unfiltered table view by clicking the icon.
Click the eye icon to customise which columns are visible. This allows you to display only the columns relevant to your work and hide those you do not need.
1.6.5 Custom Views
Each table contains different columns, sometimes up to more than one hundred. To avoid excessive scrolling, Finticx offers Custom Views, which allow you to set up your ideal table layout and save it for future use. You can also choose from predefined views that are included in your license. For example, in the asset table there is a predefined view for each valuation group, allowing you to quickly access all Real Estate or Private Equity assets.
By clicking the Load View button, you can select from these ready-made configurations.
In addition to the predefined options, you can save your own view. After applying your preferred filters, sorting, and column selections, click the Save View button and give your view a name. This saves your layout so you can easily return to the same configuration at any time.
1.6.6 Export and Import
In the Finticx platform, you can export the data from the table you are currently viewing. To export to CSV or Excel, click the Export icon. If you have applied filters, the export will include only the filtered results, as well as the columns currently visible in your view.
Note that the export process does not take the “maximum shown items” setting (5, 10, 20, or 50) into account. Instead, it exports all records that match the filters and criteria you have applied.
If you have access to multiple families, you can also choose to export across all available families.
You can also import data in bulk into any table by clicking the import icon. Make sure you are on the page of the data you want to upload. For example, if you want to import assets, you must be in the Assets table view before starting the process. A comprehensive guide to importing data can be found in Chapter 5.
The import process consists of four guided steps:
- Upload File – Upload your file in either Excel or CSV format.
- Matching – Match the columns from your file to the corresponding columns in Finticx.
- Dry Run – Review a preview of the entries that will be imported. This step highlights any missing data or errors.
- Result – Confirm the results and verify your imported data one final time.
Once the process is complete, return to the table view to see your imported data reflected in the system.
1.7 The Process Monitor
The Process Monitor forms the bridge between data input and reporting output. Whenever you change or add data and want to see these updates reflected in the reports, you must start a refresh. This triggers a series of preparations and calculations that typically take around 10 minutes to complete.
The Process Monitor is used in three main ways:
- To check data quality across your entries.
- To push changes or additions from the data tables to the report.
- To apply changes in user access rights to the report.
The easiest way to start a new refresh is by clicking on Refresh Now on the sidebar. Clicking on the widget itself will lead you to the Process Monitor for a more detailed view of the results.
Data Quality Checks
When you perform a data quality refresh, the table below provides an overview of any issues found. For each section (for example, Entity, Asset, or Valuations), it shows which families contain errors or incomplete data (marked as Not OK) and which are error-free (marked as OK).
We recommend reviewing and resolving all sections marked as Not OK before running a full report refresh, as data quality directly affects the accuracy and completeness of your reports.
To correct data issues, navigate to the relevant table and locate the entries marked in red. When you hover over a red entry, an explanation of the issue appears. You can also open the entry to see which fields are highlighted in red, along with a description of the error.
Full Report Refresh
A full report refresh is required to push any data changes to the report. Until the refresh is completed, no updates will be visible in the reporting output. This process usually takes around 10 minutes.
During the refresh, you can monitor the status, which indicates whether the report is currently running, whether changes have been successfully pushed, or whether the refresh has failed. If the refresh fails, none of the updates will appear in the report. In most cases, failures are due to temporary system issues that must be addressed by the Finticx support team. If this occurs, please contact Finticx Support through a ticket on the Contact page.
User Access Rights
A full report refresh is also required whenever you make changes to user access rights—for example, when adjusting user roles or modifying row-level security (which families or entities a user can access). These changes will only take effect once the refresh has completed.
1.8 Customizable Dropdowns
For many fields (like “Sector” and “Geography”), you will see a list of predefined dropdown options. If the value you need is not available, you can click the plus icon to add a new dropdown item. An example of this can be seen in the case study (cfr. section 2.2.5), where a new entity is created and assigned to a newly added Entity Group. Once this new Entity Group is created, it will automatically appear in the dropdown list the next time you create another entity, allowing it to be selected like any other predefined option.
Clicking on the bin icon permanently deletes the option from the list. Be aware that all existing entries linked to this selection will go into error.
1.9 Allocations
When creating assets, you will notice that some fields include a “To be allocated” option at the top of the dropdown list. This option is available for all assets for the fields Asset Class, Currency Exposure, Geography, and Sector. For Private Funds assets, additional fields—Enterprise Size, Fund Size, Fund Style, and Vintage—can also be allocated over multiple values.
Selecting “To be allocated” allows you to distribute the asset across several categories rather than choosing a single value. For example, instead of assigning one geographic region to a Bank Portfolio, you can for example allocate the portfolio across Europe EMU, North America, and Emerging Markets.
Once “To be allocated” is selected, an Allocation tab appears at the top of the asset page. In this tab, you define the allocation percentages, ensuring that all selected categories add up to 100%. Each allocation requires a Start Period, indicating when the allocation becomes effective. If the allocation changes over time, you can add additional sets of percentages with new start periods. For a step-by-step example within a case study, see section 3.3.4.
1.10 Case Study: Finvision Family Office
Throughout this User Guide, each chapter and section is explained using a fictitious case study featuring the family office Finvision. In this scenario, Finvision is a multi-family office with several employees working in Finticx and three clients: Carlton, Harrington, and Mendoza.
Every chapter will include practical examples based on Finvision’s situation, demonstrating how the concepts and functionalities apply in a real-life context.
1.10.1 Case Study: Intro to Finticx
In this first chapter, we begin by setting up Finvision’s Finticx environment: adding the employees who will use the platform, assigning the appropriate user roles, configuring access rights, and customising the environment with Finvision’s corporate colours and logo.
The owner of the Finticx license within Finvision is Elisa Vollrath. As the license holder, she is automatically assigned the role of Workspace Admin.
Next, we will add two additional colleagues to the Finticx environment: Victor Leclercq and Ward Verfaillie. To do this, navigate to Settings → User Management → Add User, and enter their names and email addresses.
Next, we will assign the appropriate roles to both users. Elisa Vollrath automatically is the Module Admin. This allows her to manage the roles of other users, create and maintain data role configurations, and set up new Families and Entities. In addition, she can create and edit assets, including their valuations and transactions. Ward Verfaillie, on the other hand, will focus solely on creating and managing assets, along with their valuations and transactions. For this reason, we assign him the role of Contributor.
To do this, navigate to Configurations → Users, and select the pencil icon next to the users and change the user role to the desired role.
The final thing to do in this part of the case study, is customizing the look and feel of the Finticx environment, to the one of Finvision Family Office. This is something only the Workspace Admins are entitled to do.
To do this, navigate to Admin Center → Settings, where you can upload the company logo and change the colors to those of the Family Office. Once you’re done, click “Save” in order for the changes to take place.
Chapter 2: Organisational Structure
2.1 The Concept of Families
2.1.1 General Information
In the Wealth Reporting module, the “Family” represents the highest level of reporting and data organization. All reporting, data aggregation, and analytics occur within a single family—cross-family reporting is not supported.
Every asset, regardless of its type (e.g., financial, real estate, private equity, etc.), is always linked to one specific family. This structure ensures clarity and data integrity, but it also means that the way you organize your hierarchy of Families, Entity Groups, and Entities (cfr. section 2.2) requires careful consideration.
It’s important to note that the concept of “Family” does not necessarily have to represent an actual family. You may use it to represent a holding structure, investment group, or any other organizational unit that fits your reporting needs.
Your subscription defines the number of families you can manage:
- The basic subscription includes one family by default.
- If you require additional families, you can easily expand your setup by purchasing the Family Add-on, which provides one additional family per add-on.
2.1.2 Historical Data
For each Family, you should determine how far back in time you wish to include data for reporting purposes, i.e. the ACT Opening Period. This decision can differ per family, depending on the availability and reliability of historical information.
For example, if you are a multi-family officer, you might choose to include historical data for your first family (e.g., FAM001) starting from January 2022, because you have complete transaction and valuation details from that date onward. In this case, you would set the ACT Opening Period to 2022‑01
If, however, you do not have similar data for another family but plan to start collecting information from January 2026, you would set the ACT Opening Period for that second family (e.g., FAM002) to 2026‑01.
Choosing the ACT Opening Period has several important implications and should be done thoughtfully:
- Starting Valuation
For every asset that existed at the start of the ACT Opening Period, you will be required to record a valuation on the period prior to your ACT Opening Period. This valuation will represents the asset’s value at the start of the reporting period and will serve as a starting point for your History-To-Date Performance (HTD). If you prefer to, you may still enter complete historical data, but it is not mandatory.
For instance, if your ACT Opening Period is 2024-01, the starting should be entered with the “From Period” equal to 2023-12.
- Reporting Scope
Reports will only include periods equal to or after the ACT Opening Period. Any data entered before this period will only be used to calculate historical returns in a period equal or after the ACT Opening Period.
There are, however, some exceptions to this rule. For certain valuation groups—specifically Private Equity, Private Debt, and Real Estate—all historical transactions are taken into account in order to calculate an accurate Internal Rate of Return (IRR) and to project a correct J-Curve.
In all reports, you will have the option to view History-To-Date (HTD) performance. It is important to note that this calculation reflects performance up to the ACT Opening Period, not from the date of the initial investment in the asset. For the latter, one should select Investment-To-Date (ITD) which will calculate the returns over all the historical transactions.
- Starting Allocations and Ownership
For Entity Ownership (cfr. section 2.2.4), Strategic Allocation (cfr. section 2.3), Asset Allocation (cfr. section 1.9), and Instrument Allocation (cfr. section 10.4), you will need to define the allocation percentages as of the period immediately preceding the ACT Opening Period.
For instance, if your ACT Opening Period is 2024-01, the first set of allocation or ownership percentages should be entered with the “From Period” equal to 2023-12. These figures serve as starting points for all subsequent ownership and allocation calculations.
2.1.3 Actuals and Forecasts
While the ACT Opening Period is a one-time decision made by the Family Officer and normally remains unchanged, the ACT Closing Period is updated regularly. You will need to adjust the ACT Closing Period each time you open a new reporting period.
The ACT Closing Period represents the last period in which Actuals are entered. In other words, it is the cut-off point between Actuals and Forecasts:
- All Actuals dated on or before the ACT Closing Period are included in the reporting.
- All Forecast entries dated after the ACT Closing Period are taken into account.
This separation ensures that the reporting reflects a clear distinction between historical (Actual) data and forward-looking (Forecast) data.
Let’s clarify this with an example. Imagine that the Family Office Finvision reports quarterly to one of its families, Carlton. The last completed report covered the period 2025-06. Now, in September, the family officer wants to begin preparing the next report.
He can already enter the new valuations for July, August, and September. However, as long as he does not update the ACT Closing Period, these valuations will not appear in the report, because they fall after the current closing period.
To make these new Actuals visible in the reporting output, he must update the ACT Closing Period to 2025-09. Once this is done:
- All Actuals up to and including 2025-09 will be taken into account.
- All Forecasts that were generated for periods before September will be ignored, as they are now replaced by newly entered Actuals.
This ensures that the report correctly reflects the latest available Actual data.
2.1.4 Other
Each Family has its own Base Currency, which defines the currency in which the reporting is presented. In Finticx, you can enter valuations and transactions in any currency. During reporting, all foreign-currency amounts are automatically converted into the FO Base Currency using the exchange rates published by the European Central Bank (ECB).
Note: Within the report, you still have the option to select a different reporting currency if needed. However, the Family’s Base Currency remains the default currency for all calculations.
For all other fields, we refer to Appendix A, which provides a detailed explanation of every input field
2.1.5 Case Study: Creating New Families
We’ll continue with our case study on Finvision Family Office. In this section, we will create Finvision’s three clients as separate Families in Finticx: Carlton, Harrington, and Mendoza. Each Family has its own characteristics, reporting preferences, and historical data availability.
Carlton is the first Family Finvision will onboard. For this client, Finvision has extensive historical data going back to 31/12/2023, stored in well-structured Excel files that can easily be imported into Finticx. For this reason, the ACT Opening Period will be set to 2024-01, as valuations and transactions are available from that point forward. The first reporting period for Carlton using Finticx will be December 2025, which means the ACT Closing Period for their initial report will be set to 2025-12. Carlton is based in Belgium and reports in EUR, so the FO Base Currency for this Family will be EUR.
The second Family, Harrington, has a similar level of historical data available, and Finvision will also report to them for the first time at the end of 2025. Their ACT Opening Period is therefore 2024‑01, and their initial ACT Closing Period is set to 2025-12. However, unlike Carlton, Harrington is a London-based Family and traditionally reports in British Pounds. As such, the FO Base Currency for Harrington will be GBP.
The third Family, Mendoza, is an Italian family client based in Rome. They are a recent addition to Finvision’s customer base, meaning historical data prior to their onboarding is not available. Data collection will begin as of 31/12/2025, resulting in an ACT Opening Period of 2026-01 and an initial ACT Closing Period of 2026-01. Since Mendoza reports in euros, their FO Base Currency will be EUR.
For none of the Families do we want forecasts to be rolled over into Actuals by default (cfr. section 6.1.7), nor do we want accrued interest to be included in the NAV of Instruments (cfr. Chapter 10). Therefore, both Default FC Roll into ACT and NAV Includes Accrued Interest are set to No.
To create these Families, navigate to Family → Add a New Family and click the green + icon in the bottom-right corner of the screen.
2.2 How to Structure Entities
2.2.1 General Information
A second level of reporting in Finticx is the entity level, which consists of individual Entities that can be grouped into Entity Groups. You can create as many entities as needed for your reporting purposes. An entity may represent a legal or financial structure—such as a holding company, natural person, or investment vehicle—that owns wealth components in the form of assets.
Entities marked as a private person serve as participants within the family structure. You designate an entity as a participant by setting the Private Person field to Yes during creation. In practice, participants are typically the individuals behind the family — the husband, wife, or children — as opposed to the legal and financial structures, such as holding companies or investment vehicles, that make up the rest of the entity hierarchy. How to set up the family/entity structure is explained in section 2.2.4.
As you begin working in Finticx, it is important to think carefully about how you want to structure your entities, as a well-designed setup can save time and simplify reporting later on. Every asset you create must be linked to one entity, and this relationship is fundamental to how Finticx organises and aggregates data. This means that an asset cannot be split across multiple entities, nor can it simultaneously belong to multiple families.
2.2.2 Entity vs Direct Participation
When deciding which entities to create within a Family, it is important to consider the level of look-through you wish to achieve in the reporting. This choice determines how much underlying detail will be visible in the reports and directly influences whether you should model something as an Entity or as a Direct Participation asset. The distinction is best illustrated with an example.
Imagine a family that owns Company XYZ and wishes to include it in their wealth reporting. The family officer can model Company XYZ in two different ways, depending on the desired level of transparency:
Option 1: Direct Participation (no look-through)
If only the high-level value of Company XYZ needs to be reflected—without reporting on its underlying assets—the family officer can simply create a Direct Participation asset, for example:
DIR001 | Company XYZ, and link it to the appropriate existing entity within the Family.
In this setup, Company XYZ appears as a single consolidated asset in the reports. Valuations and transactions are entered at the level of this one asset, and no further detail is required.
Option 2: Entity with full look-through
If the family officer wishes to see a more granular breakdown of what is inside Company XYZ, then Company XYZ should be modelled as an Entity, for example: ENT001 | Company XYZ.
After creating the entity, the family officer can then create all underlying assets that Company XYZ owns. For example:
- If Company XYZ owns real estate, individual Real Estate assets (RES) can be created.
- If it holds cash or term deposits, Cash & Equivalent assets (CCE) can be added.
- If Company XYZ has stakes in subsidiary companies, these can be modelled as Direct Participation assets (DIR) within the entity.
This approach provides full look-through visibility, allowing the report to show each underlying asset, its valuations and transactions, and its contribution to the overall wealth.
2.2.3 Entity Groups
Entities can be organised into Entity Groups to simplify reporting. By assigning multiple entities to a single group, you can view reports that consolidate all entities within that group, making it easier to analyse specific parts of your organisational structure.
It is important to note that each entity must be linked to exactly one Entity Group. This relationship is one-to-one, similar to how each asset must be linked to exactly one entity. An entity cannot belong to multiple Entity Groups at the same time.
2.2.4 Entity Rollup
The entity rollup is the tool through which you define how entities within a family relate to one another and in what proportions. Participants are natural persons that always sit at the top of this hierarchy, acting as the ultimate owners of the entities below them. Intermediate entities such as a holding company serve as structural nodes that pass ownership upward to the participants but are not assigned a value of their own in the rollup.
Consider the example in the diagram below. To track the wealth of a husband and wife separately, each is created as a participant. If they jointly own a family house, you only need to create the asset once under a shared entity. Through the ownership percentages in the entity rollup, Finticx will automatically assign half of the asset's value to each participant. In this example, both participants own 50% of ENT003 | Holding, which holds RES001 | Family House.
In more complex structures, ownership can span multiple levels. In the example below, ENT006 | Company Z holds DIR001 | Company ABC, valued at €1,000,000. The family owns 70% of Company Z, so €700,000 is attributed to that entity. Company Z is in turn owned by ENT003 | Holding, which is owned equally by both participants. ENT003 | Holding itself receives no value in the rollup — it is an intermediate entity. The €700,000 passes through it and is divided equally between the two participants, assigning €350,000 to Participant 1 and €350,000 to Participant 2.
In the report, grouping by entity shows the full €700,000 at the level of Company Z. Switching to grouping by participant shows €350,000 for each.
To create an entity rollup, navigate to Entity Rollup and click the green + icon. Start by selecting a scenario. Three options are available: Actual, Scenario 1, and Scenario 2. The Actual scenario reflects your real ownership structure. Scenario 1 and Scenario 2 are what-if simulations — for example, what your portfolio would look like if ownership stakes in specific entities were different. Next, select the family and the From Period, which is the month from which the ownership percentages take effect.
In the Ownership section, you define the individual relationships that make up the structure. A single rollup record can contain multiple rows, each representing one ownership relationship. For each row, select the Parent Entity and Child Entity. The child entity is the entity that is owned by the parent. If an entity is owned directly by the family rather than by another entity, leave the Parent Entity field blank. Also specify the Ownership Type for each relationship: full, usufruct, or bare ownership. Use the green + icon to add additional rows.
To model the ownership from the second example, the entry looks like this:
Once all ownership relationships are defined, you can visualise the full structure also as a tree structure.
Entity ownership deserves particular attention, as it directly impacts how NAV and returns are calculated across the portfolio.
Ownership percentages can range from 0% to 100% and represent the share of an entity that belongs to a given family. When ownership is below 100%, only the corresponding proportion of that entity's asset valuations and transactions will contribute to the family's overall portfolio. For example, a buy transaction of 1,000,000 EUR with 50% ownership will contribute 500,000 EUR to the portfolio.
You can set different ownership percentages for different months if the Family’s stake in an entity changes over time. Each percentage remains valid until a new percentage is entered for a later month, ensuring that valuations and transactions are allocated correctly according to the ownership applicable at that point in time. If no ownership percentage is specified (either at all, or until the first ownership value is defined), Finticx assumes 100% ownership by default.
While it is technically possible to adjust valuations or transactions manually by calculating and entering the ownership-adjusted amounts yourself, using Entity Ownership is strongly recommended. It centralises the logic, simplifies data input, and ensures consistent reporting.
In practice, the choice comes down to how you prefer to enter your data. Consider the following example:
A Family “Carlton” owns 75% of the entity “Company XYZ”, which has a real estate asset worth 1,000,000 EUR.
You have two options:
-
Use Entity Ownership
- Set Entity Ownership to 75%
- Enter a valuation of 1,000,000 EUR for the asset
- Finticx automatically includes 750,000 EUR (75%) in the portfolio
-
Adjust values manually
- Set Entity Ownership to 100%
- Enter a valuation of 750,000 EUR for the asset
- Finticx takes 100% of the manually adjusted value, resulting in the same 750,000 EUR
Both approaches lead to the same result in the report. However, using Entity Ownership (Option 1) is cleaner, reduces manual work, and avoids mistakes when ownership changes over time.
2.2.5 Case Study: Creating an Entity Structure
To illustrate how entity structures can be set up within Finticx, we continue with the case of Finvision Family Office and their client Carlton. Just like with any family, Finvision must decide how detailed the reporting should be and how the underlying wealth should be organised into entities and entity groups. A well-structured setup helps ensure clean reporting, correct ownership handling, and an intuitive overview of the family’s wealth.
To keep the case study clear and avoid unnecessary complexity, we will focus exclusively on the Carlton family from this point onward. Harrington and Mendoza have been introduced to explain the general concepts, but all practical examples, structures, and walkthroughs will now be based on Carlton alone.
For Carlton, Finvision opts for a straightforward structure that reflects the key components of the family’s wealth: a central holding company, a real estate entity, an operating business with partial ownership, and a minority participation that does not require look-through reporting. This example demonstrates how to combine Entities, Entity Groups, Entity Ownership, and Direct Participation assets to create a clean and functional organisational structure that supports accurate reporting.
The organigram above provides a clear overview of how the Carlton family is structured within Finticx. Their organisation is divided into four main Entity Groups: Carlton Holding, Carlton Real Estate Companies, Carlton Ltd., and Private Assets. Each of these groups contains the entities that belong to that part of the family’s wealth. For example, the holding group includes the central holding company and the minority stake in Omega Tech where they desire a look-through, while the real estate group contains the two property-related companies. Carlton Ltd. groups together the fully owned operational entities, and the Private Assets group represents the individual family members and their personal portfolios.
To create these Entities and Entity Groups, navigate to Entity → Add a New Entity and click the green + icon in the bottom-right corner of the screen.
To create a new Entity Group, open the dropdown field, enter the name of the Entity Group you wish to add, and click the green + icon.
2.2.6 Case Study: Creating and Assigning Roles
Now that both Families have been created and the organisational structure of Finvision Family Office has been translated into a clear entity structure within Finticx, the next step is to invite the individual family members and assign the appropriate roles to all users. This includes granting each person the correct user role and configuring their Row-Level Security, ensuring they have access only to the Families and Entities that are relevant to them. Setting up user access at this stage is essential, as it determines which parts of the reporting they can view, which data they can edit, and how securely the information is shared within the family office environment.
First, all users of the Carlton family are invited to Finticx.
The next step is to create new Row-Level Roles, where you can define which Role can see which entities and families. To do so, navigate to Configurations → Roles → Row level security and click the “Add role” icon. Then you’ll be able to give your role a name, in this case we’ll call our role “Family Carlton”.
Once the role has been created, you can configure its permissions. To do this, click the Add permission button on the right-hand side of the screen. This allows you to define which Families and Entities are accessible for the selected role. In this case, the role should have access to all Entities within the Carlton Family, so we assign permissions accordingly.
Now that the role is created, you simply need to save the role by clicking the save button at the top right corner of your screen.
Now it’s finally time to assign the roles to Philippe and Katrien. To do so, navigate to Configurations → Users and select the pencil icon next to the user and change the roles as described above (cfr. section 1.10.1). Philippe and Katrien will be Consumers and will thus only have access to the reports.
2.3 Strategic Allocation
2.3.1 General Information
A Strategic Allocation defines the target portfolio composition for a Family. It specifies how the total investment portfolio should ideally be distributed across asset classes, along with the expected return for each class. This serves as a benchmark against which the actual portfolio can be measured in the reporting dashboard.
Strategic Allocations are defined at Family level and are always linked to a specific starting period (From Period). Each allocation remains in effect until a new allocation with a later From Period is entered, allowing you to reflect changes in investment strategy over time.
When creating a Strategic Allocation, you assign a percentage to each asset class you wish to include. The total of all percentages should add up to 100%. In addition, you can define a Return Target for each asset class, representing the expected annualised return. These targets are used in the reporting to compare actual performance against the family's strategic objectives.
It is important to note that the first Strategic Allocation should be entered with a From Period equal to the period immediately preceding the ACT Opening Period, consistent with how Entity Ownership and Asset Allocations are set up. For example, if the ACT Opening Period is 2024-01, the first Strategic Allocation should have a From Period of 2023-12.
Strategic Allocations are not mandatory, but they are strongly recommended. Without a defined target allocation, the benchmark and deviation analyses in the Wealth Reporting Dashboard will not be available.
To create a Strategic Allocation, navigate to Strategic Allocation in the Side Panel under Organisation, and click the green + icon in the bottom-right corner of the screen. Select the Family, define the From Period, and then add the desired asset classes with their respective allocation percentages and return targets.
2.3.2 Case Study: Creating a Strategic Allocation
To create an allocation, navigate to Strategic Allocation → Add a New Strategic Allocation and click the green + icon. In this example we’ve selected "Carlton" as the Family, and set the From Period to 2023-12. Then add each asset class with its corresponding percentage and return target. Ensure that all allocations sum to 100%.
Once saved, this allocation will serve as the benchmark in the Wealth Reporting Dashboard, where you can compare the actual portfolio composition against these targets and identify any deviations that may require rebalancing.
If the Carlton family decides to adjust their strategy at a later date — for example, increasing their Private Equity allocation from 15% to 20% while reducing Cash from 5% to 0% — a new Strategic Allocation can be added with the appropriate From Period. The previous allocation will remain valid for all earlier periods, ensuring historical comparisons remain accurate.
Chapter 3: Managing Assets
3.1 General Information
Once your organisational structure has been set up in Finticx, the next step is to create all assets that should be included in the reporting of the overall wealth portfolio.
The most important distinction between assets is their Valuation Group. This term is used to classify assets based on the type of master data they require. For example, a Real Estate asset needs information such as city, property type, and surface area, while a borrowing at a bank requires different details, such as loan amount and interest rate.
Another important concept in Finticx is the Performance Type. There are three Performance Types: Investment Portfolio, Family Assets, and Operating Participations.
Assets classified under the Investment Portfolio form the core of the reporting module. These are the assets that are expected to generate returns and for which performance tracking is essential.
Family Assets represent leisure or lifestyle-related holdings, such as the family home, vintage car collections, or art collections. These assets are included when calculating the total wealth, but their performance is typically not monitored, as they are not considered return-generating investments.
Operating Participations are usually the companies from which the family’s wealth originates, often involving active ownership or board roles. These assets can be important to include for a complete wealth overview, but, similar to Family Assets, they are not the primary focus of the performance analytics.
Because the reporting module is designed around the Investment Portfolio, it is important to choose the Performance Type of each asset carefully. Only Investment Portfolio assets will appear in the full range of detailed performance reports, while Family Assets and Operating Participations are included more selectively.
In the following sections, we will discuss each Valuation Group in turn, outlining their specific requirements and explaining the key differences between them. We will cover the most important characteristics and practical considerations for each asset type, but we will not describe every input field individually. For a complete list of all fields and their detailed explanations, we refer to Appendix A.
3.2 Cash & Equivalents
3.2.1 General Information
The first assets that you need to create are all Cash & Equivalents (CCE). These include all Current Accounts, Term Accounts, Savings Accounts, and other cash-equivalent positions that you want to have reflected in the reporting.
Cash & Equivalent assets are created first because Finticx allows you to automatically mirror transactions using the Offsetting IBAN. This functionality links certain transactions directly to the associated cash account.
For example, imagine you receive rental income on a Real Estate asset. You would create a transaction with the Transaction Type Rental Income on that asset, and in that same transaction you can specify the Offsetting IBAN. By doing so, the amount of the rental income is virtually added to the most recent value of the CCE asset linked to that IBAN.
Each asset can have a default Offsetting IBAN, so you do not need to manually look it up for every transaction. If you know that all rental income for a particular property is always received on the same current account, you can store that Offsetting IBAN as the asset’s default. From that point on, every new transaction for that asset will automatically suggest the correct Offsetting IBAN.
This is why Cash & Equivalent assets—specifically the current accounts and their IBANs—must be created before you begin entering valuations and transactions for other assets.
3.2.2 IBAN and Offsetting IBAN
For all Current Accounts (Valuation Type), it is possible to enter the IBAN. These are the only Cash & Equivalent assets for which the IBAN field is available, which is why Current Accounts should always be created first.
Once all Current Accounts have been set up, you can proceed with creating Term Accounts and Savings Accounts. Unlike Current Accounts, the IBAN field will be greyed out for these asset types. Instead, the field Offsetting IBAN becomes available. This field allows you to specify the default Current Account on which transactions should be mirrored.
For example, for a Term Account, the Offsetting IBAN can indicate the Current Account where the funds will be transferred once the maturity date is reached. The full logic behind mirroring transactions will be explained in Chapter 4, where we explore how to enter transactions in more detail.
Every Offsetting IBAN in Finticx is defined by a unique combination of IBAN and Asset Currency. This means that no two Offsetting IBANs can share the same IBAN–currency pair.
3.2.3 Cash & Equivalents as part of a Bank Portfolio
In some situations, a Cash & Equivalent asset may need to be included within a Bank Portfolio asset. This is particularly common for Current Accounts, as it can be important to track the cash position inside a portfolio separately and in more detail. The way you handle this depends on the type of license your organisation has.
Licenses with the Instrument Add-on
If you have an Instrument license, you can create Current Accounts directly as instruments. When a Current Account is created as an instrument, it will automatically be linked to the relevant Bank Portfolio through the transactions and valuations you enter for that instrument. No additional linking steps are required. More info can be found in Chapter 10.
Licenses without the Instrument Add-on
If your license does not include instruments, you can still incorporate Cash & Equivalent assets into a Bank Portfolio. In this case, you create the Current Account as a standard Cash & Cash Equivalent asset. You can then link it to a Bank Portfolio by selecting the appropriate Asset ID in the “Part of Bank Portfolio” dropdown, which contains all previously created portfolios.
For a detailed step-by-step explanation, including screenshots, on how to set up Current Accounts within Bank Portfolios, see section 3.3.6.
3.2.4 Case Study: Creating Cash & Equivalent Assets
In this part of the case study, we will focus on creating all Cash & Equivalent assets for Partners SRL (ENT005). In practice, this is the entity with the highest number assets within the Investment Portfolio. It holds several Current Accounts, multiple Term Accounts, and even one Savings Account that is used to set aside cash for future opportunities—such as acquiring assets at an attractive price.
To create these Cash & Equivalent assets, navigate to Assets → Add a New Asset and click the green + icon in the bottom-right corner of the screen.
Upon opening the form, you’ll be asked to give the asset a name and select the Valuation Group, which is “Cash & Equivalents” in this case.
The distinction between Current, Term & Savings Accounts can be made under Valuation Type. In this case we’re creating a Current Account, where we are required to fill in the IBAN.
The other fields can be filled in according to your own preferences. In our case, we indicate that the money on this Current Account is available cash, i.e. cash that we can use for other investments. The asset currency and the currency exposure is both EUR. The geography is Europe EMU and we’ll create “Cash” as a new Sector.
In line with the above instructions we create the other Current Accounts.
Next, we will create all Term Accounts. When selecting Term Account as the Valuation Group, the Offsetting IBAN field becomes editable. The dropdown list is populated with all unique IBAN–currency combinations created earlier. For a Term Account, you can simply choose the IBAN of the Current Account to which the funds are expected to be transferred once the maturity date is reached.
It’s important to remember that this is only the Default value for the Offsetting IBAN on the transaction level, this can always be overruled when creating a transaction.
3.3 Bank-Portfolio
3.3.1 General Information
Bank Portfolios represent assets held with a bank and typically consist of securities such as stocks, ETFs, bonds, or funds. In Finticx, you can manage Bank Portfolios with or without instrument details, depending on the level of reporting detail you require. Managing portfolios with instrument details is only available when using the Instrument Details Add-on.
Bank Portfolios without instrument details are treated as a closed box. In this setup, you report on the portfolio as a single aggregated asset, without tracking individual instruments or their movements.
Bank Portfolios with instrument details, on the other hand, provide full look-through reporting. Each underlying instrument must be created separately, and all transactions and valuations are recorded at instrument level. While this approach requires more detailed input, it offers a fully transparent view of the composition and performance of the portfolio.
The use of instrument-level reporting is only available when the Instrument Details Add-on is enabled (see Chapter 10).
3.3.2 Bank-Portfolio without Instrument Details
For a Bank Portfolio without instrument details, you only enter valuations and transactions at the portfolio level, not for each individual instrument. This means you only need to record contributions to and withdrawals from the portfolio. Any transactions or reallocations that occur within the portfolio itself do not need to be entered, as the portfolio is treated as a single consolidated asset.
3.3.3 Bank-Portfolio with Instrument Details
When working with a Bank Portfolio with instrument details, each underlying instrument is created and managed individually within the portfolio. In this setup, you record all valuations and transactions at instrument level. The total value of the Bank Portfolio is then calculated automatically as the sum of the valuations of its instruments.
This approach provides full transparency and enables detailed reporting, allowing you to clearly see how each instrument contributes to the overall portfolio value and performance.
Please note that this method requires additional effort, as valuations and transactions must be entered for every instrument in each reporting period. It is therefore important to consider the increased workload when deciding whether to use instrument-level tracking.
3.3.4 Case Study: Creating Bank-Portfolios
In this part of the case study, we will create all Bank Portfolio assets for Carlton Holding (ENT001). In this section, we focus exclusively on Bank Portfolios without instrument details—that is, accounts treated as a closed box, where the underlying instruments do not require look-through reporting. Bank Portfolios with instrument details will be covered separately in Chapter 10.
Carlton Holding manages seven Bank Portfolios, all held with Belgian banks (BNP Paribas Fortis, Belfius, and KBC). Each portfolio has its own investment focus. Some have a global mandate, investing across all major markets, while others are dedicated to specific regions such as Europe or North America. Carlton Holding also maintains a few sector-focused accounts, such as those invested mainly in technology or healthcare. Together, these portfolios provide broad diversification across geographies and investment themes while remaining consolidated under Carlton Holding for reporting purposes.
We’ll focus on the creation of “BNP Paribas Flexible Global Opportunities Fund (Class A EUR)”. To create this Bank Portfolio asset, navigate to Assets → Add a New Asset and click the green + icon in the bottom-right corner of the screen.
When the form opens, we enter all required details: the name of the fund, the Valuation Group (Bank Portfolio), and the Valuation Type, indicating that it is an Equity Fund that capitalises its returns. The asset currency is set to EUR, as the investment is made in euros and the valuations provided by BNP are reported in euros. We also assign the Performance Type as Investment Portfolio, since this asset is held to generate returns and its performance needs to be tracked.
For the fields Currency Exposure, Geography, and Sector, we want to specify the exact percentage distribution across currencies, regions, and sectors. To do this, we select “To be allocated” from the dropdown menu. The actual allocations will be completed in the next part of the case study.
This fund is discretionary, and both the Bank asset manager and Custodian are BNP. The remaining fields are optional and not relevant for our reporting purposes, so we leave them blank.
3.3.5 Case Study: Allocating Geographies, Sector and Currency Exposure
As explained in section 1.9 Allocations, the attributes Asset Class, Geography, Sector, and Currency Exposure (and, for certain private funds, several additional characteristics) can be allocated across multiple values, and these percentages may evolve over time.
In this part of the case study, we will allocate the Geography, Sector, and Currency Exposure for the BNP Paribas Flexible Global Opportunities Fund (Class A EUR), using a yearly update of the allocation percentages.
Because this asset was already owned by the family before the ACT Opening Period (2024-01), we begin entering allocations starting from 2023-12. This ensures that the Starting Valuations of December 2023 are allocated correctly across the various exposure categories as well.
To enter the allocations for this asset, navigate to Assets, then click the pencil icon next to the asset you want to update. The pencil will appear in red, indicating that something is incomplete for this asset—in this case, the fields were set to “To be allocated” but no allocation percentages have been entered yet.
Upon opening the form, the fields that require allocation will appear at the top of the screen.
In this example we’ll allocate the geographical distribution of the fund. To do so, navigate to Geography → Add a New Geography Allocation and click the green + icon in the bottom-right corner of the screen.
You can now enter the allocation percentages starting from a specific point in time. As long as no new allocation is defined, the previous one remains in effect. In this case, we will only enter allocations for 2023-12 and 2025-01; all periods between these dates will automatically follow the allocation set for 2023-12. By clicking the + icon, you can add a new classification line for each period in which the allocation changes.
3.4 Real Estate
3.4.1 General Information
Real Estate assets can include apartment buildings, malls, office spaces, or even the family residence. In Finticx, we distinguish between completed real estate (Valuation Group: Real Estate) and real estate under development (Valuation Group: Real Estate Project Development), such as construction projects or properties that are still in the development phase.
This distinction improves reporting accuracy, as completed properties and development projects have very different risk and return profiles. Developments typically involve higher uncertainty, timelines, and capital requirements, so separating them provides a clearer picture of the portfolio’s composition and risk exposure.
For real estate assets, you can forecast rental income (taking into account indexation and occupancy), OPEX and CAPEX expenditures, as well as the expected sales value on the projected exit date.
3.4.2 Real Estate
In addition to the standard input fields, Real Estate assets include several fields that are specific to this valuation group. These fields allow you to capture the essential master data needed to describe the property accurately. For example, you can enter the purchase value of the asset, both with and without purchase-related costs, along with the purchase date. You can also specify physical characteristics of the property, such as the surface area, the real estate type (e.g., apartment, office building, retail unit), and any other structural details that may be relevant for reporting.
Finticx also provides a complete set of address fields, enabling you to record the property’s location down to the country, province, city, and street level. This allows you to analyse your real estate exposure geographically and provides a clear overview of where your investments are situated. In larger portfolios, this level of detail supports better diversification analysis, regional risk assessment, and reporting consistency across asset categories.
These additional fields ensure that every real estate asset is documented thoroughly, allowing for more precise valuations, more reliable forecasts, and a richer understanding of the underlying characteristics of your property investments.
3.4.3 Real Estate Project Development
Because most families view project developments differently from completed real estate, Finticx provides a separate Valuation Group specifically for Real Estate Project Development. These assets represent properties that are still under construction—such as office buildings or apartment complexes—that are expected to generate returns only once they are completed.
Unlike completed Real Estate assets, Project Development assets do not use the forecast parameter functionality. This is because developments typically do not generate rental income or similar recurring cash flows during the construction phase. However, you can still forecast future CAPEX by entering transactions and marking them as forecasts. This process will be explained in more detail in Chapter 4.
3.4.4 Case Study: Creating Real Estate Assets
In this part of the case study, we will add a real estate asset to the portfolio of the Entity Carlton Immo NV which belongs to the entity group Carlton Real Estate Companies. In this exercise we will also add a forecast for the rental income and the expenditures associated with the asset.
We will add our first real estate asset to the entity: a residential apartment building with 12 apartment units that are fully rented out in Leuven that was purchased in January 2020 for 2.45 million. Rental income is around 168k per year.
As you can see, we have already added some assets to the family. Click on the + icon in the bottom right corner to add a new asset. When you add an asset, make sure that you are viewing the right family: Carlton (as you can see on the top right corner).
When the form opens, we enter all required details: the name of the real estate asset, the Valuation Group (Real Estate) with defaulted Valuation Type. The asset currency is set to EUR, as the residence is located in Europe and most income and expenditures will be in Euros. The Offsetting IBAN chosen is the current account via which all cash flows, such a rental income, are recorded. We also assign the Performance Type as Investment Portfolio, since this asset is held to generate returns and its performance needs to be tracked, contrary to choosing Family Assets which would be given to a family residence for example. We also add classifications, such as Geography (Europe EMU) and Sector (Real Estate).
You can see that there are real estate-specific fields available, such as the purchase value and purchase date: In our case, the Parkview Apartments Leuven were purchased on January 1st 2020 for 2.45M Euros. Further, we can add the exact address which will help later when viewing all owned apartments in a specific street, region, city, or country.
Once the asset has been created and saved, you can proceed to set up the forecast. In this step, you can enter the rental income the property will generate when fully rented, the current occupancy rate (for example, 95% to reflect minor tenant turnover), and the indexation rate for annual rent increases. Because we do not plan to sell this asset, the sales date and sales value can be left blank. Annual OPEX expenses amount to approximately €28,000, and all CAPEX items were added individually in the CAPEX table. After completing the forecast parameters, click the Regenerate button at the bottom of the screen to generate and display the full forecast in table form.
After clicking on regenerate you can see that the forecasted income and expenditures are displayed in three-weekly intervals.
3.4.5 Case Study: Creating Project Development Assets
In the previous case study, we added a completed real estate asset. Now, we'll add a real estate project development asset to the entity Carlton Development BV (ENT004), which specializes in properties under construction. We're adding a residential development that will transform a former industrial site in Mechelen into 24 modern apartments.
Project development assets have a simpler setup process compared to completed real estate properties. Since the property is under construction, there are no fields for recording an initial purchase value or acquisition price. Additionally, the forecast functionality is not available at the asset level for development projects. Instead, all development costs, construction phases, and valuations must be tracked through transactions as the project progresses over time
When we create this asset, we select Carlton Development BV from the Entity dropdown list and give it the name 'Mechelen City Gardens'. The valuation group is Real Estate Project Development, from which the corresponding Valuation Type automatically follows. Since the construction is located in Mechelen and most cash flows will be in Euros, we set the Asset Currency to Euro. We select the appropriate current account through which all cash transactions related to the asset will flow. This is an investment with expected returns, so we classify it under the investment portfolio category and complete the remaining classification fields. Further down the page, we also fill in all the address fields for the property location.
3.5 Private Funds
3.5.1 General Information
Private Funds are the main category used in Finticx for illiquid alternative investments, but this should not be confused with direct investments in non-listed companies. Direct investments—where the family owns shares directly in a private company—should be recorded as Direct Participations. Private Funds, on the other hand, refer to investment vehicles that operate with a commitment structure, including commitments, capital calls, and distributions. When creating such a fund in Finticx, you select either Private Equity or Private Debt, depending on the nature of the investment.
3.5.2 Private Equity
Private Equity (PE) investments represent ownership stakes in private companies, typically acquired through buyout, growth capital, or venture capital strategies. When creating a PE fund in Finticx, you can define several key characteristics—such as enterprise size, fund size, investment style (e.g., buyout, growth, co-investments), and the fund’s vintage year. These fields help structure your PE portfolio, enable exposure analysis across the full PE book, and support performance comparison between similar funds.
Among all valuation groups, Private Equity (and Private Debt) require the most detailed master data. Some of these fields are used to model forecasted cash flows, while others provide essential information for exposure and portfolio monitoring. It is important to note that while management-fee–related fields can be captured for reporting completeness, they are not used to calculate gross-to-net returns; instead, they serve purely for tracking cost structures across the PE portfolio.
A central component of PE funds in Finticx is the commitment structure. Here you specify the total committed capital, the expected timing and pace of capital calls during the investment period, and the anticipated return of capital during the harvesting period. These inputs allow Finticx to model the typical J-curve, showing when cash outflows occur during capital deployment and when returns are expected later in the fund’s lifecycle. You can configure the duration of the investment and harvesting phases, as well as how quickly capital is deployed and how distributions are made.
3.5.3 Private Debt
Private Debt investments provide financing to private companies through instruments such as loans, mezzanine financing, or other credit-based structures. Unlike Private Equity, Private Debt typically generates returns earlier and in a more predictable manner, mainly through recurring interest payments and scheduled principal repayments. As a result, distributions tend to be more stable and the characteristic J-curve effect is generally less pronounced.
In Finticx, Private Debt funds are set up in the same way as Private Equity funds: they follow the same commitment structure, cash flow logic, and allocation principles. The only differences lie in the Valuation Group, Valuation Type, and Asset Class, which should reflect the debt nature of the investment.
3.5.4 Case Study: Creating Private Equity Asset
In this part of the case study, we will add a Private Equity asset to Carlton Holding (ENT001). As outlined in the general information, Private Funds in Finticx are used for illiquid alternative investments that operate with a commitment structure.
Carlton Holding has committed to several Private Equity funds as part of its alternative investment strategy. These funds span different styles, geographies, and enterprise sizes, providing diversification within the illiquid portion of the portfolio. We'll focus on the creation of "Thomas H. Lee Equity Fund VIII", a buyout fund targeting small-cap companies in the EMU (Europe Monetary Union).
When the form opens, we enter the key identifying details. The Asset Name is Thomas H. Lee Equity Fund VIII, the Valuation Group is Private Equity, and the Valuation Type Private Equity Fund, indicating that this vehicle invests directly into portfolio companies through a structured commitment and capital call mechanism. The Asset Currency is set to EUR, since the commitment and capital calls are denominated in euros. The Offsetting IBAN is a Belfius Current Account (BE279889 5838 5773_EUR), which is the cash account from which capital calls will be funded and into which distributions will be received. The Asset Closing Period is left at the default of 2099-12, as the fund is open-ended from a reporting perspective. We further enter all general classification fields.
The Private Equity Classification section captures the characteristics that define the fund's strategy. The Enterprise Size is set to Small-Cap Firms (≤ €50M EV), indicating the size category of the companies in which the fund invests, while the Fund Size is 250-1000M which represents the total size of the fund. The Style is Buyout, meaning the fund acquires controlling or significant stakes in its target companies.
The J Curve section is where the commitment structure is modelled. The Commitment Date is set to 16/09/2024, and the Committed Amount in asset currency is €6,000,000. The Expected Call Ratio is 0.90, meaning Finticx assumes that 90% of the total commitment will ultimately be called by the fund manager. The Fund Duration is set to 10+2, reflecting a standard 10-year fund life with the possibility of two additional extension years. The Investment as of Year and Quarter is 2024 Q3, marking the start of capital deployment. The Investment Duration is 4 years, with an Investment Pace of 1-2-3-4. This pace pattern determines how capital calls are distributed across the investment period - in this case accelerating over time. The Harvest is set to 2028 Q3, which is when distributions are expected to begin. The Harvesting Duration is 6 years, with a Harvesting Pace of 1-2-3-4.
The fields from the section Fee Structure | Gross Net are valuable for tracking cost structures. The Management Fee After Investment is set to 2.5%, calculated on a Commitment base - meaning the post-investment management fee is charged as a percentage of committed capital. The Management Fee During Investment is 2%, also calculated on the Commitment base. The Fund Target IRR is 14%, representing the expected annualized return the fund aims to achieve over its investment period, taking into account cash flows, reinvestments, and exit values. The Hurdle Rate is set to 8%, which is the minimum annual return the fund must achieve before carried interest is paid to the general partner. The Catch Up toggle is set to Yes, indicating that the fund includes a catch-up mechanism in its profit-sharing structure - once the hurdle is cleared, the GP receives a disproportionate share of profits until they have caught up to their entitled carry. The Carry is set to 20% which represents the percentage of profits allocated to the general partner once the hurdle and catch-up mechanisms are met.
Finticx also includes a Private Equity – Other section for capturing additional administrative details such as the Legal Form, Reporting Frequency, Fiscal Structure, Share Class, and Participation Type. These fields are optional.
3.6 Direct Participations
3.6.1 General Information
This valuation group is used for investments where you hold a direct ownership stake in a company or asset, typically with greater control or visibility into the underlying investment. Finticx supports several types of Direct Participation investments, each aligned with a specific asset class. These include Direct Participation Equity (for stakes in operating companies), Direct Participation Collections & Varia (for tangible collectibles), Direct Participation Hedge Fund (for direct investments in hedge fund strategies), and Direct Participation Real Estate (for property investments).
In most situations, Direct Participation Equity will be the most commonly used option. However, the choice ultimately depends on how you wish to structure and present these investments within Finticx.
When setting up a Direct Participation in Finticx, you define the share type, which determines your ownership position and rights within the company’s capital structure. Through valuations (see Section 4.1.2), you can enter the amount of shares as well as both the Enterprise Value and Equity Value of the company. This allows Finticx to calculate your effective ownership percentage and provides clear insight into the value of your participation.
3.6.2 Entity or Direct Participation
As mentioned earlier, this type of investment often raises the question of whether it should be modelled as a separate Entity or as a Direct Participation asset (see section 2.2). When you do not require look-through visibility into the underlying assets of the company in which you hold a stake, creating a Direct Participation asset is the most appropriate approach. This allows you to report the investment as a single consolidated position while still capturing its value and performance at the participation level.
If detailed insight into the company’s underlying assets, structure, or cash flows is required, modelling the investment as an Entity would be the better choice.
3.6.3 Listed Companies
For Direct Participations, just as for Instruments held within Bank Portfolios (see Chapter 5), Finticx supports automatic revaluations when the asset is listed on a stock exchange.
Within the asset’s master data, you can enter an Asset External ID. If this identifier is a valid ISIN, Finticx will automatically populate the (read-only) ISIN field, as shown below. This enables the system to retrieve market prices for valuation purposes.
To determine the initial value at the start of the reporting, you must enter a valuation in the period prior to the ACT Opening Period. This represents the value of the asset in your chosen currency at that point in time. If you want Finticx to perform automatic valuations based on market prices, you must also enter the quantity held. This allows Finticx to calculate the asset’s value by multiplying the number of shares by the corresponding stock price.
For automatic valuations, Finticx uses the end-of-day price of the last trading day of each month. You can always override this by manually entering a valuation for a specific period, for example if a different reference price is required.
3.7 Borrowings & Lendings
3.7.1 General Information
Borrowings and Lendings represent financial positions where money is either borrowed by or lent from the portfolio. While both valuation groups follow a similar structural setup, they are treated as separate valuation groups in Finticx because of their different behaviour in the Net Asset Value (NAV) calculation. Borrowings contribute a negative NAV, whereas Lendings contribute a positive NAV, making this distinction important for accurate reporting.
3.7.2 Borrowings
Borrowings represent liabilities within the portfolio: funds are received with the obligation to repay them under agreed terms. The most common example is a bank loan, where capital is borrowed from a financial institution.
When setting up a Borrowing in Finticx, you can define several key parameters, such as the principal amount, any applicable credit limit, the loan duration, and the interest rate. Interest can be specified as either fixed or variable, with variable rates typically based on a floating reference rate—such as EURIBOR—combined with a spread expressed in basis points. It is important to note that these parameters are captured as master data for reporting purposes only. They are not used by Finticx to perform interest or cash flow calculations.
In addition, a borrowing can be linked to the asset that serves as collateral, such as a Real Estate asset. In the Detailed Real Estate Report, the outstanding borrowed amount is then deducted from the asset’s NAV, resulting in a NAV Net Debt that reflects the value of the asset after financing.
The Borrowings valuation group supports three valuation types, each reflecting a different repayment structure. A Bullet Loan is repaid in full at maturity, with no interim principal repayments. Monthly Repayment loans reduce the outstanding balance gradually through scheduled instalments; loans with quarterly or yearly repayments can also be managed using this structure. An Overdraft represents a flexible credit facility with no fixed drawdown or repayment schedule.
3.7.3 Lendings
Lendings represent financial assets where the portfolio provides funds that are expected to be repaid in the future, such as private loans. The setup closely mirrors that of Borrowings: you define the loan amount, any applicable credit limit, the loan duration, and the interest rate terms.
Within the Lendings valuation group, two valuation types are available. Debt Own Company is used when the loan is granted to a related or group company and represents an intercompany financing arrangement. Direct Lending is used for loans made to external parties, such as private individuals or businesses, and is typically applied to investment-driven lending activities.
3.7.4 Case Study: Creating Borrowings
In this case study, we demonstrate how to create a bank loan asset with monthly repayments in Finticx. In this scenario the Carlton family has taken out a real estate mortgage from UBS to finance an investment property (RES001 | Parkview Apartments Leuven). The loan was originated in January 2024 with a 16-year term and monthly repayments.
When the form opens, we enter all required details: the name of the borrowing asset (Bank Loan - UBS - Real Estate), the Valuation Group (Borrowings) with the Valuation Type set to Monthly Repayment. The asset currency is set to EUR, as the loan is denominated in Euros. The Offsetting IBAN chosen is the BNP Current Account via which all loan repayments will be recorded. We set the Asset Closing Period to 2040-12 when the final payment due. The Maturity Date is set to 31/12/2040 which reflects the 16-year loan term.
We assign the Performance Type as Investment Portfolio, since this borrowing is related to an investment property, contrary to choosing Family Assets which is used for personal borrowings. We also add classifications, such as Geography (Europe EMU), Currency Exposure (EUR - Euro), and Sector (Real Estate), to properly categorize the loan in reporting.
You can see that there are borrowing-specific fields available in the "Borrowings & Lendings" section: In our case, the loan has a Loan Amount and Credit Limit of €850,000, with the Borrowing Type set to Mortgage. The Duration is 204 months (16 years), with an Interest Rate of 2.75%, comprised of the EURIBOR 3M reference rate plus 150 basis points.
3.7.5 Case Study: Creating Lendings
In this case study, we demonstrate how to create a lending asset in Finticx. In this scenario the Carlton family (specifically entity Carlton Holding NV) provides a private loan to Sarah Carlton to help her finance a business venture. The loan was given out in January 2024 with a 5 year term and will be repaid quarterly with interest.
In the form, we enter and select all required details: Asset Name (Loan to Family Member – Sarah Carlton), Valuation Group (Lendings) and applicable Valuation type (Direct Lending). The asset currency is set to Euro, as the loan and repayments are denominated in Euros. From the dropdown menu we select the current account via which all loan repayments will be received. We set the asset closing period will to December 2029 at which point the asset will be a closed asset (as seen at the Asset Closing Period).
We assign the Performance Type as Investment Portfolio, since this lending generates interest income. The valuation class is automatically set to Fixed Income, as lendings generate predictable payback and interest payments. For the asset Class, we stay with the preselected asset class Fixed Income. We also add the remaining classifications, such as Currency Exposure (Euro), Geography (Europe EMU), and Sector (Private Debt).
At the end of the form, you can see that there are lending-specific fields available in the Borrowings & Lendings section. In our example, the loan has a loan amount of €250,000 and lending type Private Credit. The duration is 60 months (5 years) with an interest rate of 1.5%. As this is a private loan, the fields Reference Interest Rate are not relevant here.
3.7.6 Case Study: Linking a Borrowing to a Real Estate Asset
In Finticx, it is possible to link a Borrowing directly to a Real Estate asset. This is useful when a loan has been taken out specifically to finance a property purchase, as it allows you to link them together. In this case study, Katrien has taken out a loan to finance a villa in Knokke. We will first create the Real Estate asset, and then create the Borrowing and link the two together.
Step 1: Create the Real Estate Asset
Start by creating the real estate asset following the usual steps: navigate to Assets → Add a New Asset, enter all relevant details, such as the Asset Name (Real Estate – Villa Knokke), select Real Estate as the Valuation Group, assign the current account, and enter the asset purchase value along with any additional costs. Once everything is filled in, save the asset.
Step 2: Create the Borrowing Asset
Next, create the Borrowing asset that represents the €5,000,000 loan used to purchase the property. Follow the standard steps for creating a borrowing - enter the name, select Borrowings as the Valuation Group, and fill in the loan details.
Step 3: Link the Borrowing to the Real Estate Asset
When you scroll down to the Borrowings & Lendings section when creating the Borrowing Asset, you will see the option to select an Indebted Asset. This is where you link the loan to the property it was used to finance. For our example, we select the Real Estate asset we just created: RES002 | Real Estate – Villa Knokke.
3.8 Other Valuation Groups
3.8.1 Collections & Varia
The Collections & Varia valuation group is used to manage physical collectibles and other miscellaneous assets within a portfolio. This includes items such as boats, classic cars, watches, aircraft, sports cars, and other valuable objects. If your assets do not fit within the standard categories, Finticx also allows you to create custom collection types.
Assets in this valuation group are often classified under the Performance Type “Family Assets”, as they typically represent personal or lifestyle-related holdings—such as a family’s art collection or classic car collection—rather than return-driven investments.
3.8.2 Direct Commodities
The Direct Commodities valuation group is used to track physical commodity holdings within the portfolio. This includes precious metals such as gold and silver, as well as other tangible commodities that are held directly. When creating a Direct Commodity asset, you specify the commodity type (for example, gold or silver) and the unit of measure, such as kilograms, ounces, pounds, or tons. This allows Finticx to correctly record quantities and valuations and to report on commodity exposure in a clear and structured way.
Chapter 4: Net Asset Value, Performance, Transactions and Valuations
4.1 General Information
When you create an asset in Finticx, you are essentially defining its profile. At that stage, the asset exists in the system but does not yet have a value. The asset’s value, and ultimately its performance, is introduced through valuations and transactions.
A valuation establishes the official value of an asset for a specific period. Transactions entered after that valuation can increase or decrease this value. When a new valuation is entered for a later period, it becomes the new reference point and effectively overrides the impact of all previous valuations and the transaction movements that occurred since the last valuation. The NAV performance reflects changes in the asset’s value that are not explained by transactions alone, such as market movements.
To illustrate this, consider the example shown in the graph below.
- In January, a valuation of 100 is entered, so the asset's NAV is 100.
- In February, a NAV-increasing transaction of 20 is recorded (a capital increase for example). The NAV increases from 100 to 120, but the user enters a new valuation of 110. The difference between the expected NAV (120) and the actual valuation (110) represents a NAV Performance of -10.
- In March, a transaction of 10 is recorded. The NAV increases from 110 to 120, with no NAV Performance.
- In April, a NAV-decreasing transaction of -5 is recorded (for example, a partial sale). Based purely on transaction logic, the NAV would be 115 (120 - 5). However, the user enters a new valuation of 118. The difference between the expected NAV (115) and the actual valuation (118) represents a NAV Performance of +3.
- In May, a transaction of 15 is recorded. The NAV increases from 118 to 133, with no NAV Performance.
- In June, a transaction of 5 is recorded. Based purely on transaction logic, the NAV would be 138 (133 + 5). However, the user enters a new valuation of 145. The difference between the expected NAV (138) and the actual valuation (145) represents a NAV Performance of +7.
4.2 Valuations
4.2.1 General Information
Valuations in Finticx define the value of an asset for a specific period. When a valuation is recorded, it establishes a new baseline that overrides the impact of all previous valuations and transaction movements. This valuation then serves as the starting point from which subsequent transactions will increase or decrease the asset’s value until a new valuation is entered.
More specifically, entering a valuation for a given period means that this value always equals the Net Asset Value (NAV) for that period. Regardless of any prior valuations or transactions, a manually entered valuation fully determines the NAV for that period and supersedes all earlier information.
For each asset—and, where applicable, for each instrument—it is possible to enter one valuation per day.
When entering a valuation for a specific period (for example, 2025-12), Finticx automatically assigns the valuation date to the last day of that month (for example, 31/12/2025).
If no new valuation is recorded for a later period, Finticx automatically rolls forward the most recent valuation. This ensures continuity in reporting and means you do not need to enter a valuation for every period if the asset’s value has not changed.
4.2.2 Additional Fields
When recording a valuation for an asset or instrument, you specify the amount and currency, along with additional details that depend on the asset type. For example, for Direct Participation assets, you can choose to enter values such as the Enterprise Value and the Equity Value.
The valuation interface guides you through this process by displaying only the relevant fields and highlighting which inputs are required. In ‘Appendix A: Input Field Explanation - section G. Valuations”, we explain all of the additional valuation fields.
4.3 Transactions
4.3.1 General Information
Transactions in Finticx represent all cash flows and movements that affect the value or performance of an asset over time. They are used to capture events such as contributions, withdrawals, income, expenses, repayments, and other value-impacting activities that occur between valuation moments.
While valuations define the official value of an asset at a given point in time, transactions explain how and why that value changes. Transactions can increase or decrease an asset’s Net Asset Value (NAV), generate realised performance (such as interest or dividends), or reflect transfers of cash between assets. Together, valuations and transactions provide a complete and transparent view of how an asset evolves throughout the reporting period.
4.3.2 Transaction Type Sections
In Finticx, a wide range of transaction types is available to capture different kinds of asset movements and cash flows. These transaction types are organised into logical sections, making it easier to identify and select the appropriate one. The section in which a transaction type appears already indicates how it will behave in reporting—for example, whether it increases or decreases the Net Asset Value (NAV), impacts performance, or represents a neutral transfer.
The Contribution section groups transaction types that represent capital flowing into an asset or structure. These transactions increase exposure, invested capital, or principal. Typical examples include asset purchases, capital calls in private funds, capital expenditures on real estate, or principal amounts lent out. Transactions in this section generally increase NAV or invested capital and form the starting point for performance calculation.
The Withdrawal section contains transactions that represent capital flowing out of an asset or structure. This includes sales, distributions of capital, principal repayments, and withdrawals from portfolios. These transactions reduce exposure or outstanding balances and typically decrease NAV or invested capital, without necessarily generating performance on their own.
The Net section is used to record inflows to or outflows from assets that are outside the current reporting scope. These transactions capture movements of value between the reported portfolio and external parties or structures that are not modelled in Finticx. While they affect NAV, they do not represent performance and are used purely to reflect value changes originating outside the reporting universe.
The NAV Adjustment section is used to make corrections to the Net Asset Value (NAV) of an asset without impacting NAV performance. These transactions allow you to align the NAV with an external statement or correct historical inaccuracies, while explicitly avoiding the creation of artificial performance.
The Realised Performance section groups transactions that generate actual income or gains. This includes dividends, interest received or paid, rental income, realised gains or losses on sales, and profit distributions from funds. These transactions directly impact performance reporting, rather than merely changing invested capital or exposure.
This Operating Income / Expense section captures general operating income and expenses that relate to portfolio management rather than to a specific investment transaction. These transactions are typically used at portfolio or cash-account level and affect cash balances, without altering asset positions or performances.
The Fees section includes all costs charged by third parties, such as management fees, brokerage fees, custody fees, transaction fees, and performance fees. These transactions reduce realised performance and cash but do not represent changes in ownership or exposure. They are essential for understanding the cost structure of the portfolio.
The Taxes section is used to record tax-related cash flows, including withholding taxes, capital gains taxes, securities transaction taxes, and tax refunds. These transactions affect cash and realised performance but are kept separate from gross income to allow transparent gross-versus-net analysis.
Notional transactions are non-cash, non-NAV-impacting entries used for tracking commitments, reference amounts, or rights. Examples include unfunded commitments or subscription rights. These transactions do not affect NAV or performance but provide important context and exposure tracking, especially for private funds.
The Reconciliation Differences section is reserved for resolving temporary or unexplained differences between Finticx and external statements, typically at cash-account level. These transactions are used to balance discrepancies during reconciliation.
4.3.3 Practical Transaction Guide
How to read this guide
This guide answers a single practical question for each of the most common situations a wealth manager meets: “I need to record something happened — which transaction do I create, how do I fill it in, and what will it do to my reporting?” Each case follows the same four-part structure as outlined in the table below. All input is described for the creation of manual entries in Finticx.
| Case | The real-world situation that prompts a transaction. |
| Input Guidelines | The exact transaction type to pick and the key fields to complete in Finticx. |
| NAV | What the entry does to Net Asset Value — each increase and decrease listed separately, including whether the asset's own NAV is unaffected. |
| Performance | What the entry does to performance, identifying whether it is realised performance or unrealised NAV Performance, and why. |
Two mechanics worth keeping in mind
Mirrored vs single-sided. Most transactions have an asset side and a cash side. With an Offsetting IBAN and Single Sided = No, Finticx books both legs automatically (e.g. a Buy raises the asset and lowers the funding account). Set Single Sided = Yes — or use a “(single sided)” type — when the other leg lives outside Finticx; in that case total NAV genuinely moves.
NAV Performance vs Realised Performance. NAV Performance is the unrealised difference between the NAV expected from transactions and a newly entered valuation (market moves). Realised Performance comes from specific income/gain/cost transaction types (dividends, interest, rent, realised gains, fees, taxes). Contributions, Withdrawals, Net and NAV-Adjustment entries move value around or correct it without creating performance.
▲ increases raises ▼ decreases lowers ● neutral no effect / value relocates ◆ depends on direction
1 · Contributions — capital flowing in
These increase exposure, invested capital or principal and form the starting point for performance — they do not themselves create a return.
Case 1. Buying a listed instrument in a Bank Portfolio (without instrument details)
Transaction type: Buy Section: Contributions
| Case | You buy EUR 100,000 of a listed equity inside a Bank Portfolio that is tracked at portfolio level only (no instrument detail). |
| Input Guidelines |
On the Bank Portfolio asset, go to Transactions → Add a New Transaction. Transaction Type: Buy. Amount Transaction Currency: 100,000 (the purchase amount). Offsetting IBAN: the current account that funds the purchase, so the cash side is mirrored. Leave Single Sided = No so the funding account is reduced in the same step. |
| NAV |
▲ increases NAV (Bank Portfolio): increases by the invested amount. ▼ decreases NAV (current account): decreases by the same amount. ● neutral NAV (total): unchanged — value simply moves from cash into the portfolio. |
| Performance |
● neutral No changes on creation because a Buy is invested capital, not a return. Future gains, however, surface later as NAV Performance (revaluation) or as a realised result on sale. |
Case 2. Buying a listed instrument in a Bank Portfolio (with instrument details)
Transaction type: Buy Section: Contributions
| Case | You buy EUR 100,000 of a specific instrument inside a Bank Portfolio that is tracked with instrument details, funded by a current account that is itself an instrument in the same portfolio. |
| Input Guidelines |
On the Bank Portfolio asset, add a transaction and select the Instrument you are buying. Transaction Type: Buy. Amount Transaction Currency: 100,000; Amount After Fees if a commission is deducted (available here because the portfolio is instrument-detailed). Quantity: Optional field that can be filled in to calculate the price per share.Offsetting IBAN: the current account funding the purchase. |
| NAV |
▲ increases NAV (bought instrument): increases by the invested amount. ▼ decreases NAV (cash instrument / current account): decreases by the same amount. ● neutral NAV (Bank Portfolio total): unchanged when both legs are instruments in the same portfolio — value moves between instruments. |
| Performance |
● neutral None on entry — invested capital, not a return. Subsequent value changes appear as NAV Performance, or as a realised result on sale. |
Case 3. Capital call from a private equity fund
Transaction type: Call Section: Contributions
| Case | Your private equity fund issues a drawdown notice for EUR 500,000 against your committed capital. |
| Input Guidelines |
On the Private Equity asset, add a transaction with Transaction Type: Call. Amount: 500,000 in the call currency. Offsetting IBAN: the cash account the wire leaves from. |
| NAV |
▲ increases NAV (private equity): increases by the called amount. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance |
● neutral None. A Call deploys committed capital — it is a contribution, not performance. It also reduces your remaining unfunded commitment (tracked separately via Notional). |
Case 4. Capital call where the entry fee sits inside the commitment
Transaction type: Call (Entry Fee inside Commitment) Section: Contributions
| Case | A drawdown is issued, but the subscription/entry fee is counted against your commitment rather than billed on top. |
| Input Guidelines |
On the Private Equity / Private Debt asset, choose Call (Entry Fee inside Commitment). Amount: the full drawn amount including the embedded fee. Offsetting IBAN: funding cash account. Do not book a separate Entry Fees Paid line — the fee is already inside this call by definition. |
| NAV |
▲ increases NAV (private equity): increases by the called amount. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance |
● neutral Treated as contributed capital. Because the fee is inside the commitment, it does not surface as a separate realised cost. |
Case 5. Fund recalls a previously distributed amount
Transaction type: Call (recalled Distribution) Section: Contributions
| Case | The GP exercises a recall provision and pulls back EUR 80,000 of a recallable distribution you received earlier. |
| Input Guidelines |
On the Private Equity / Private Debt asset, select Call (recalled Distribution). Amount: 80,000; Offsetting IBAN: the account paying it back. Use this (not a plain Call) so reporting links the inflow back to the original recallable distribution. |
| NAV |
▲ increases NAV (private equity): increases by the recalled amount. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance |
● neutral Capital movement, not a return. It restores invested capital that had been temporarily returned. |
Case 6. Renovating an investment property (real estate Capex)
Transaction type: Capex Section: Contributions
| Case | You spend EUR 120,000 renovating an apartment building you already own and report as Real Estate. |
| Input Guidelines |
On the Real Estate asset, add Transaction Type: Capex. Amount: 120,000; Date: when the works are paid. Offsetting IBAN: the account the contractor is paid from. Distinguish from Real Estate Opex: Capex is value-adding investment, Opex is recurring running cost. |
| NAV |
▲ increases NAV (property): increases by the capitalised spend. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance |
● neutral Capex is invested capital, so it raises the cost base without itself creating performance. Whether the spend was “worth it” shows up later as NAV Performance when the next valuation is entered. |
Case 7. Construction spend on a development project
Transaction type: Capex Assets under Construction Section: Contributions
| Case | You pay a EUR 300,000 milestone on a building still under construction (Real Estate Development). |
| Input Guidelines |
On the Real Estate (Development) asset, choose Capex Assets under Construction. Amount: 300,000; Offsetting IBAN: funding account. Keep using this type for every construction-phase drawdown until the asset becomes operational. |
| NAV |
▲ increases NAV (development asset): increases by the construction spend. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance | ● neutral Contribution of capital into the project; no return recognised at this stage. |
Case 8. Transferring cash into a holding structure
Transaction type: Contribution Section: Contributions
| Case | You inject EUR 250,000 of cash into a holding vehicle's reported cash account. |
| Input Guidelines |
Use Contribution when capital flows into a CCE or BNK asset and you want both legs recorded. Amount: 250,000; Offsetting IBAN: the source cash account. Finticx creates the mirrored entry (one side up, the funding side down). |
| NAV |
▲ increases NAV (receiving account): increases by the contributed amount. ▼ decreases NAV (source account): decreases by the same amount. ● neutral NAV (total): unchanged if both accounts are inside scope — value relocates. |
| Performance | ● neutral None — capital movement, recorded under Net Contributions in the waterfall. |
Case 9. Recording one leg only of a contribution
Transaction type: Contribution (single sided) Section: Contributions
| Case | Capital enters an asset from a source that is NOT modelled as a cash account asset in Finticx, so only one leg should be booked. |
| Input Guidelines |
Choose Contribution (single sided) — cash fields are disabled and no mirror is created. Amount: the contributed value; no Offsetting IBAN. Use when the counter-leg lives outside Finticx, or to avoid double counting where the cash side is captured elsewhere. |
| NAV |
▲ increases NAV (asset): increases by the contributed amount. ● neutral No offsetting cash decrease is booked because the other leg is outside scope. |
| Performance | ● neutral None — it is a contribution. |
Case 10. Recording history that pre-dates your reporting start
Transaction type: Invested Capital Section: Contributions
| Case | An asset was bought years before your ACT Opening Period and you want an accurate IRR / cost base from day one. |
| Input Guidelines |
Use Invested Capital to log capital deployed before the family's ACT Opening Period. Enter one line per historical cash flow (multiple entries give a sharper IRR), each with its real date and amount. Available across all valuation groups; pair it with the opening valuation that sets the starting NAV. |
| NAV | ● neutral The opening valuation defines NAV; Invested Capital records what was put in, not extra value. |
| Performance |
● neutral Does not itself create performance. It anchors the cost base so subsequent IRR / MWR are calculated correctly. |
Case 11. Lending money to a private borrower
Transaction type: Principal Lended Section: Contributions
| Case | You extend a EUR 400,000 private loan to a third party and report it as a Lending. |
| Input Guidelines |
Create a Lending asset, if you not yet have. On the Lending asset, add Principal Lended. Amount: 400,000; Offsetting IBAN: the account the money leaves from. This establishes the outstanding lending position that interest and repayments will run against. |
| NAV |
▲ increases NAV (lending asset): increases by the principal advanced. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance |
● neutral Principal advanced is capital, not income. The return arrives later as Interest Received. |
Case 12. Drawing down on a credit line / loan facility
Transaction type: Principal Withdrawal Section: Contributions
| Case | You draw EUR 200,000 from a bank facility, increasing what you owe. |
| Input Guidelines |
Create Borrowing asset if you not yet have. On the Borrowing asset, add Principal Withdrawal. Amount: 200,000; Offsetting IBAN: the current account that receives the proceeds. Borrowings carry a negative NAV, so a draw makes that liability larger (more negative). |
| NAV |
▼ decreases NAV (borrowing): the liability grows (more negative) by the drawn amount. ▲ increases NAV (receiving account): increases by the proceeds. |
| Performance |
● neutral Drawing debt is a financing movement, not performance. The cost shows later as Interest Paid. |
Case 13. Receiving extra shares as a stock dividend
Transaction type: Stock Dividend Section: Contributions
| Case | A company pays its dividend in new shares instead of cash; you receive additional shares. |
| Input Guidelines |
Quantity: how many new shares you received. Leave Offsetting IBAN empty — no cash moves. Your original cost stays the same but is now spread over more shares, so the cost per share goes down. If your country taxes the value of these free shares, record that tax separately as a Stock Dividend Tax line. |
| NAV | ● neutral NAV (holding): broadly unchanged at the event — more shares at a proportionally lower cost per share, with no cash in or out. |
| Performance |
● neutral The stock dividend itself does not create realised performance. Value changes surface through revaluation (NAV Performance). |
Case 14. Forward stock split (more shares)
Transaction type: Stock Split - In Section: Contributions
| Case | A 3-for-1 forward split triples your share count without changing total value. |
| Input Guidelines |
On the holding, add Stock Split - In for the additional shares received. Quantity: the extra shares created by the split (e.g. +2,000 if you held 1,000 going to 3,000). No cash, no Offsetting IBAN. If priced via Quantity × Market Price, the market price adjusts for the split automatically. |
| NAV | ● neutral NAV (holding): unchanged — the same value is simply spread across more shares. |
| Performance | ● neutral None. A split is a unit re-denomination, not a gain. |
Case 15. Shares received in a corporate merger
Transaction type: Stock Merger - In Section: Contributions
| Case | A company you hold merges into another; you receive shares of the surviving entity. |
| Input Guidelines |
Add Stock Merger - In on the surviving-entity holding for the shares received. Fill in both the Quantity of shares received and the Amount Transaction Currency (only enter the currency amount where it is relevant). Pair it with the Stock Merger - Out on the old holding for the shares surrendered. On the surrendered holding asset, also enter a new valuation of 0 so the asset is closed properly. |
| NAV |
▲ increases NAV (new holding): increases by the currency amount entered. ▼ decreases NAV (old holding): decreases via the Merger - Out leg; the 0 valuation closes it cleanly. ● neutral NAV (total): value is preserved across the two legs. |
| Performance |
● neutral The swap itself is value-neutral. Any premium/discount is captured later through revaluation, or as a realised gain/loss if cash is involved. |
Case 16. Shares received from a spin-off
Transaction type: Stock Spin Off - In Section: Contributions
| Case | A parent company spins off a division and you receive shares in the new standalone company. |
| Input Guidelines |
Add Stock Spin Off - In on the new company holding asset. Fill in both the Quantity of shares received and the Amount Transaction Currency (only where relevant). On the parent, book Stock Spin Off - Out to reduce its cost base for the value transferred. If the parent position is fully closed, also enter a new valuation of 0 so the asset is closed properly. |
| NAV |
▲ increases NAV (new company): increases by the currency amount entered. ▼ decreases NAV (parent): reduced by the Spin Off - Out leg. ● neutral NAV (total): value is preserved across both legs. |
| Performance | ● neutral No performance is created by the event itself. |
Case 17. Shares received in a swap / exchange
Transaction type: Stock Swap - In Section: Contributions
| Case | In a restructuring you exchange one security for another and receive the new shares. |
| Input Guidelines |
Add Stock Swap - In on the received security. Fill in both the Quantity of shares received and the Amount Transaction Currency Book the matching Stock Swap - Out on the security given up. On the surrendered security, also enter a new valuation of 0 so the asset is closed properly. |
| NAV |
▲ increases NAV (received security): increases by the currency amount entered. ▼ decreases NAV (surrendered security): decreases via the Out leg; the 0 valuation closes it. ● neutral NAV (total): value-neutral exchange. |
| Performance | ● neutral None from the exchange itself. |
Case 18. Share class conversion (assimilation in)
Transaction type: Stock Assimilation - In Section: Contributions
| Case | Your shares of one class are converted into another class. |
| Input Guidelines |
Add Stock Assimilation - In for the asset of the incoming share class. Fill in both the Quantity of incoming shares and the Amount Transaction Currency (only where relevant). Pair with Stock Assimilation - Out on the asset of the original class. On the asset of the original class, also enter a new valuation of 0 so the asset is closed properly. |
| NAV |
▲ increases NAV (new share class): increases by the currency amount entered. ▼ decreases NAV (original class): decreases via the Out leg; the 0 valuation closes it. ● neutral NAV (total): value shifts between share classes. |
| Performance | ● neutral None from the conversion itself. |
2 · Withdrawals — capital flowing out
These reduce exposure or outstanding balances. On their own they do not generate performance; realised gains/losses on sales are booked separately.
Case 19. Selling an asset (cost plus realised gain or loss)
Transaction type: Sell - at Cost + Sell - Realised Gain / Loss Section: Withdrawals
| Case | You sell a position that cost EUR 200,000 for actual proceeds of EUR 250,000 — a EUR 50,000 gain (the same logic applies for a loss). |
| Input Guidelines |
A sale is recorded as a combination of transactions. First add Sell - at Cost for the original cost basis (200,000); add Quantity if share-based; Offsetting IBAN = the account receiving proceeds. Then add Sell - Realised Gain for the surplus over cost (50,000) — or Sell - Realised Loss if proceeds are below cost. Together the two legs equal the full proceeds received. |
| NAV |
▼ decreases NAV (sold asset): decreases by the cost amount (the position leaves the portfolio). ▲ increases NAV (current account): increases by the full proceeds received Sell-at Cost transaction + Sell – Realised Gain transaction). |
| Performance |
▲ increases Realised performance: the gain leg (50,000) is crystallised and appears on the right of the NAV waterfall. ▼ decreases If sold below cost, the Sell - Realised Loss leg reduces realised performance instead. |
Case 20. Return of capital from a fund
Transaction type: Distribution Capital Section: Withdrawals
| Case | A private equity fund returns EUR 150,000 of your invested capital (not profit). |
| Input Guidelines |
On the Private Equity / Private Debt asset, add Distribution Capital. Amount: 150,000; Offsetting IBAN: the receiving account. Use a Distribution Profit / Capital Gains type instead when the cash represents profit rather than returned capital. |
| NAV |
▼ decreases NAV (fund position): decreases by the returned capital. ▲ increases NAV (receiving account): increases by the same amount. |
| Performance |
● neutral Return of capital is not a gain. It reduces invested capital without creating realised performance. |
Case 21. Recallable capital distribution
Transaction type: Distribution Capital (recallable) Section: Withdrawals
| Case | The fund returns capital that it may later recall under the LPA. |
| Input Guidelines |
Add Distribution Capital (recallable) rather than the plain type. Amount and Offsetting IBAN as usual. Tagging it recallable lets a later Call (recalled Distribution) tie back to it cleanly. |
| NAV |
▼ decreases NAV (fund position): decreases by the distribution. ▲ increases NAV (receiving account): increases by the same amount. |
| Performance | ● neutral None — capital movement only. |
Case 22. Over-called capital refunded
Transaction type: Repayment of Call Section: Withdrawals
| Case | A deal fell through and the GP refunds part of a capital call. |
| Input Guidelines |
Add Repayment of Call on the private equity / private debt asset. Amount: refunded sum; Offsetting IBAN: receiving account. |
| NAV |
▼ decreases NAV (fund position): decreases (the earlier call is partly reversed). ▲ increases NAV (receiving account): increases by the refund. |
| Performance | ● neutral None — it unwinds a contribution. |
Case 23. Repaying borrowed principal
Transaction type: Principal Repayment Section: Withdrawals
| Case | You pay EUR 5,000 of principal on a mortgage you report as a Borrowing. |
| Input Guidelines |
On the Borrowing asset, add Principal Repayment for the principal portion only. Offsetting IBAN: the account the payment leaves from. Book any interest portion separately as Interest Paid. |
| NAV |
▲ increases NAV (borrowing): the liability shrinks (less negative) by the repayment. ▼ decreases NAV (funding account): decreases by the same amount. |
| Performance |
● neutral Repaying principal is a financing movement, not a cost. Only the interest leg hits performance. |
Case 24. Receiving principal back on a loan you made
Transaction type: Principal Repayment Received Section: Withdrawals
| Case | A borrower repays EUR 20,000 of principal on your private loan. |
| Input Guidelines |
On the Lending asset, add Principal Repayment Received. Amount: 20,000; Offsetting IBAN: the receiving account. |
| NAV |
▼ decreases NAV (lending asset): the outstanding loan reduces. ▲ increases NAV (receiving account): increases by the repayment. |
| Performance | ● neutral Principal return only; the interest is booked under Interest Received. |
Case 25. Withdrawing cash from a structure
Transaction type: Withdrawal Section: Withdrawals
| Case | You take EUR 100,000 of cash out of a reported holding vehicle to another in-scope account. |
| Input Guidelines |
Use Withdrawal (mirrored) with Offsetting IBAN = the receiving account. Finticx books both legs: source down, destination up. |
| NAV |
▼ decreases NAV (source account): decreases by the withdrawn amount. ▲ increases NAV (destination account): increases by the same amount. ● neutral NAV (total): unchanged if both ends are in scope. |
| Performance | ● neutral None — recorded under Net Contributions. |
Case 26. Withdrawal where the other leg is outside Finticx
Transaction type: Withdrawal (single sided) Section: Withdrawals
| Case | Cash leaves a reported account to a destination not modelled in Finticx (e.g. a personal account you don't track). |
| Input Guidelines |
Use Withdrawal (single sided) — it is single-sided by definition; cash fields are disabled. Amount: the outflow; no Offsetting IBAN. |
| NAV |
▼ decreases NAV (account): decreases by the outflow. ● neutral No counter-leg is booked, so total NAV falls because the receiving side is outside the reporting universe. |
| Performance | ● neutral None — capital leaving scope, not a loss. |
Case 27. Shares surrendered in a merger / spin-off / swap / assimilation (the Out legs)
Transaction type: Stock … - Out Section: Withdrawals
| Case | Counterparts to the corporate-action 'In' cases: shares leaving the old position. |
| Input Guidelines |
Use Stock Merger - Out, Stock Spin Off - Out, Stock Swap - Out or Stock Assimilation - Out on the position being reduced. Fill in both the Quantity surrendered and the Amount Transaction Currency (only where relevant); for a spin-off this is the cost-base reduction. Where the old position is fully closed, also enter a new valuation of 0 so the asset is closed properly. Always book the matching- In' leg on the receiving security in the same step or date. |
| NAV |
▼ decreases NAV (old position): decreases by the currency amount entered. ▲ increases NAV (new position): increases via the paired '- In' leg. ● neutral NAV (total): value-preserving corporate action. |
| Performance | ● neutral No performance created by itself. |
Case 28. Reverse stock split / consolidation
Transaction type: Stock Split - Out Section: Withdrawals
| Case | A 1-for-10 consolidation reduces your share count. |
| Input Guidelines |
Add Stock Split - Out for the shares removed by the consolidation. Quantity: the reduction in shares; no cash. |
| NAV | ● neutral NAV (holding): unchanged — fewer shares at a proportionally higher price. |
| Performance | ● neutral None. |
3 · Net — value crossing the reporting boundary
Movements between the reported portfolio and the world outside its scope. They change total NAV but are excluded from performance by design.
Case 29. Receiving an asset as a gift / inheritance
Transaction type: Gift In Section: Net
| Case | A family member gifts a EUR 600,000 property into the reported portfolio with no payment. |
| Input Guidelines |
On the relevant asset, add Gift In (available for all valuation groups). Amount: 600,000; no cash leg / Offsetting IBAN — nothing was paid. Pair with creating the asset itself if it is new to the portfolio. |
| NAV |
▲ increases NAV (asset): increases by the gifted value. ▲ increases NAV (total): rises — new value genuinely enters scope. |
| Performance |
● neutral Net transactions explicitly do NOT count as performance. The increase shows under Net Contributions, not return. |
Case 30. Gifting an asset out of the portfolio
Transaction type: Gift Out Section: Net
| Case | You donate EUR 50,000 of a holding to charity. |
| Input Guidelines | Add Gift Out on the asset for 50,000; no cash leg. |
| NAV |
▼ decreases NAV (asset): decreases by the gifted value. ▼ decreases NAV (total): falls — value leaves scope. |
| Performance | ● neutral Not treated as a loss — it is a Net movement, excluded from performance. |
Case 31. Value entering from outside the reporting scope
Transaction type: Net In Section: Net
| Case | Value transfers in from an external structure that Finticx does not model. |
| Input Guidelines |
Add Net In on the receiving asset for the amount entering scope. Use Net In (vs Contribution) when the source genuinely sits outside the reporting universe. |
| NAV |
▲ increases NAV (asset): increases by the amount entering scope. ▲ increases NAV (total): rises — value originates outside scope. |
| Performance | ● neutral Excluded by design; appears in Net Contributions. |
Case 32. Value leaving to outside the reporting scope
Transaction type: Net Out Section: Net
| Case | Value moves to an external party/structure not modelled in Finticx. |
| Input Guidelines | Add Net Out on the asset for the amount leaving scope. |
| NAV |
▼ decreases NAV (asset): decreases by the amount leaving scope. ▼ decreases NAV (total): falls — value exits the reporting universe. |
| Performance | ● neutral Not a loss; recorded as a Net movement. |
4 · NAV Adjustments — correcting value, never performance
For aligning NAV to an external statement or fixing history — explicitly without creating artificial performance.
Case 33. Aligning NAV up to match an external statement (no fake gain)
Transaction type: NAV Adjustment - Positive Section: NAV Adjustment
| Case | A custodian statement shows the position EUR 10,000 higher than Finticx, due to a historic data gap rather than a market move. |
| Input Guidelines |
Add NAV Adjustment - Positive for 10,000 on the asset. Use this specifically when you must correct NAV without creating performance. If the difference is a genuine market move, enter a normal valuation instead so it flows to NAV Performance. |
| NAV | ▲ increases NAV (asset): increases by the adjustment to match the statement. |
| Performance |
● neutral Explicitly NONE — this is the whole point of the NAV Adjustment section. It corrects value while avoiding artificial NAV Performance. |
Case 34. Aligning NAV down without recognising a loss
Transaction type: NAV Adjustment - Negative Section: NAV Adjustment
| Case | A historic over-statement needs correcting downward by EUR 8,000, but it isn't a real impairment. |
| Input Guidelines |
Add NAV Adjustment - Negative for 8,000. Reserve this for corrections/alignments. For a real impairment you intend to show as performance, use a valuation. |
| NAV | ▼ decreases NAV (asset): decreases by the adjustment. |
| Performance | ● neutral None — no artificial NAV Performance is generated. |
5 · Realised Performance — income, gains and losses
These crystallise actual income, gains, losses and (for sales) realised results. They drive the realised side of the performance waterfall.
Case 35. Receiving a cash dividend
Transaction type: Dividend Section: Realised Performance
| Case | A listed holding pays you EUR 12,000 in cash dividends. |
| Input Guidelines |
On the Bank Portfolio / Direct Participation, add Dividend for 12,000. Offsetting IBAN: the account the dividend is paid into. If you want gross-vs-net visibility, book Dividend - Gross plus a separate Dividend - Withholding Tax line instead. |
| NAV |
▲ increases NAV (current account): the dividend lands in the cash account. ● neutral NAV (holding itself): unchanged — the dividend is paid out, it does not change the share position's value. |
| Performance | ▲ increases Realised performance: income is crystallised and shown to the right of the NAV waterfall. |
Case 36. Booking a dividend gross, with tax shown separately
Transaction type: Dividend - Gross Section: Realised Performance
| Case | You want to report the full declared dividend and track withholding tax for potential recovery. |
| Input Guidelines |
Add Dividend - Gross for the full declared amount. Add Dividend - Withholding Tax for the amount withheld (Taxes section). Net cash received = gross minus the withholding. |
| NAV |
▲ increases NAV (current account): rises by the net amount once both lines are booked. ● neutral NAV (holding itself): unchanged. |
| Performance |
▲ increases Realised performance: gross dividend recognised as income. ▼ decreases The withholding line reduces it to the net actually received. |
Case 37. Interest received on a deposit or loan
Transaction type: Interest Received Section: Realised Performance
| Case | A term account or private loan pays you EUR 3,500 of interest. |
| Input Guidelines |
On the CCE / Bank Portfolio / Lending asset, add Interest Received. Amount: 3,500; Offsetting IBAN: the receiving account. |
| NAV |
▲ increases NAV (current account): interest lands in cash. ● neutral NAV (underlying asset itself): unchanged. |
| Performance | ▲ increases Realised performance: directly increased by the interest income. |
Case 38. Interest paid on a borrowing
Transaction type: Interest Paid Section: Realised Performance
| Case | You pay EUR 1,200 of mortgage interest (the interest portion of a monthly instalment). |
| Input Guidelines |
On the CCE / Bank Portfolio / Borrowing asset, add Interest Paid. Offsetting IBAN: paying account. Keep this separate from the Principal Repayment portion. |
| NAV |
▼ decreases NAV (current account): decreases by the interest paid. ● neutral NAV (borrowing itself): unchanged — interest is a cost, not a change in the principal owed. |
| Performance | ▼ decreases Realised performance: reduced by the interest cost. |
Case 39. Rental income from a property
Transaction type: Rental income Section: Realised Performance
| Case | A tenant pays EUR 4,000 monthly rent on your Real Estate asset. |
| Input Guidelines |
On the Real Estate asset, add Rental income for 4,000. Offsetting IBAN: the account rent is received on; you can store it as the asset default. |
| NAV |
▲ increases NAV (current account): rent lands in the cash account. ● neutral NAV (property itself): unchanged — rent received does not change the property's value. |
| Performance | ▲ increases Realised performance: rental income, feeding Rental Yield metrics in the Real Estate report. |
Case 40. Routine property running costs
Transaction type: Real Estate Opex Section: Realised Performance
| Case | You pay EUR 900 of property management and insurance for the month. |
| Input Guidelines |
On the Real Estate asset, add Real Estate Opex for 900. Offsetting IBAN: paying account. Distinct from Capex, which capitalises into NAV. |
| NAV |
▼ decreases NAV (current account): decreases by the cost. ● neutral NAV (property itself): unchanged — Opex is expensed, not capitalised. |
| Performance | ▼ decreases Realised performance: reduced by the running cost. |
Case 41. Fund distribution of realised capital gains
Transaction type: Distribution Capital Gains Section: Realised Performance
| Case | Your private equity fund passes through EUR 70,000 of realised gains from a profitable exit. |
| Input Guidelines |
On the Private Equity / Private Debt asset, add Distribution Capital Gains. Offsetting IBAN: receiving account. Use Distribution Capital (Withdrawals) only for returned capital, not gains. |
| NAV |
▲ increases NAV (current account): proceeds received. ● neutral NAV (fund position itself): unchanged by the gains pass-through (its value follows the fund valuation). |
| Performance | ▲ increases Realised performance: pass-through gains recognised as return. |
Case 42. Fund distribution of realised losses
Transaction type: Distribution Capital Losses Section: Realised Performance
| Case | The fund passes through a EUR 15,000 realised loss from a write-down. |
| Input Guidelines | Add Distribution Capital Losses on the private equity / private debt asset for 15,000. |
| NAV |
◆ NAV (current account): reflects the actual cash effect of the distribution as booked. ● neutral NAV (fund position itself): unchanged by the loss pass-through. |
| Performance | ▼ decreases Realised performance: reduced by the realised loss. |
Case 43. Carried-interest / profit distribution
Transaction type: Distribution Profit Section: Realised Performance
| Case | You receive your profit share above the preferred return hurdle. |
| Input Guidelines | Add Distribution Profit on the private equity / private debt asset; Offsetting IBAN = receiving account. |
| NAV |
▲ increases NAV (current account): profit received. ● neutral NAV (fund position itself): unchanged. |
| Performance | ▲ increases Realised performance: your share of fund profits. |
Case 44. Issue premium on a subscription
Transaction type: Issue Premium Section: Realised Performance
| Case | You subscribe above par and a premium over nominal applies. |
| Input Guidelines |
On the Private Equity / Private Debt asset, add Issue Premium for the excess over par. Offsetting IBAN: the funding account. |
| NAV |
▼ decreases NAV (current account): cash paid for the premium. ● neutral NAV (fund position itself): the premium is a cost, not added position value. |
| Performance | ▼ decreases Realised performance: the issue premium is a cost and therefore reduces realised performance. |
Case 45. Miscellaneous income (royalties etc.)
Transaction type: Income Other Section: Realised Performance
| Case | An asset earns EUR 2,000 of royalty income not classified as dividend or interest. |
| Input Guidelines | On the BNK / RES / DIR asset, add Income Other for 2,000; Offsetting IBAN = receiving account. |
| NAV |
▲ increases NAV (current account): income received. ● neutral NAV (underlying asset itself): unchanged. |
| Performance | ▲ increases Realised performance: increased by the income. |
Case 46. Profit/loss on non-cash holdings (commodities, collections, developments)
Transaction type: P&L Income / P&L Cost Section: Realised Performance
| Case | A direct commodity or collectible generates a realised gain (or cost) you want recognised directly. |
| Input Guidelines |
On the RPD / DCM / COL asset, add P&L Income for a gain or P&L Cost for a cost. For cash-management gains/costs on a current account, use the (cash) variants on the CCE asset. |
| NAV |
◆ NAV (current account): moves with the cash effect of the item. ● neutral NAV (asset itself): unchanged unless a separate valuation says otherwise. |
| Performance |
▲ increases P&L Income increases realised performance. ▼ decreases P&L Cost reduces realised performance. |
6 · Operating Income / Expense — cash, but not performance
General operational cash items at portfolio/cash-account level that affect cash but are deliberately kept out of performance.
Case 47. General portfolio admin expense (no performance impact)
Transaction type: Operating Expense Section: Operating Income / Expense
| Case | You pay EUR 1,500 of general administration not attributable to a specific investment. |
| Input Guidelines |
On the CCE / Bank Portfolio (cash) asset, add Operating Expense. Offsetting IBAN: paying account. Note: by design this type does NOT generate realised performance — it is treated as a cash movement. |
| NAV | ▼ decreases NAV (current account): decreases by 1,500. |
| Performance | ● neutral Explicitly none — operating income/expense affect cash balances without altering performance. |
Case 48. General portfolio operating income (no performance impact)
Transaction type: Operating Income Section: Operating Income / Expense
| Case | A miscellaneous operational receipt of EUR 800 not tied to an investment. |
| Input Guidelines | On the CCE / Bank Portfolio, add Operating Income for 800; Offsetting IBAN = receiving account. |
| NAV | ▲ increases NAV (current account): increases by 800. |
| Performance | ● neutral None by design — use Realised Performance types when you DO want it counted as return. |
7 · Fees — third-party costs
Third-party costs. They reduce realised performance and cash without changing ownership or exposure.
Case 49. Management fee on a fund
Transaction type: Management Fees Section: Fees
| Case | Alongside a capital call you are billed a EUR 5,000 management fee. |
| Input Guidelines |
On the Private Equity / Private Debt / Bank Portfolio asset, add Management Fees for 5,000. Offsetting IBAN: paying account. Book it separately from the Call so cost is transparent. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (fund position itself): unchanged — the fee is a cost, not a change in position. |
| Performance | ▼ decreases Realised performance: reduced by the fee. |
Case 50. Brokerage commission on a trade
Transaction type: Brokerage Fees Section: Fees
| Case | You pay EUR 250 commission on an equity trade. |
| Input Guidelines |
On the Bank Portfolio / Direct Participation, add Brokerage Fees for 250. Alternatively fold it into the Buy via Amount After Fees but booking it separately gives clearer cost reporting. |
| NAV |
▼ decreases NAV (current account): decreases by the commission. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the commission. |
Case 51. Custody fee
Transaction type: Custody Fees Section: Fees
| Case | Your custodian charges EUR 600 for safekeeping. |
| Input Guidelines | On the Bank Portfolio / Direct Participation, add Custody Fees; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the fee. |
Case 52. Entry / subscription fee billed separately
Transaction type: Entry Fees Paid Section: Fees
| Case | You pay a 2% entry fee on a fund subscription, charged on top of the investment. |
| Input Guidelines |
Add Entry Fees Paid on the BNK / PEQ / PDB asset for the fee amount. Use this when the fee is billed separately — NOT when it is embedded in the commitment (use the Call entry-fee type instead). |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (fund position itself): unchanged. |
| Performance | ▼ decreases Realised performance: front-end load reduces realised performance. |
Case 53. Exit / redemption fee
Transaction type: Exit Fees Section: Fees
| Case | A back-end load applies when you redeem from a fund. |
| Input Guidelines | Add Exit Fees on the BNK / PEQ / PDB asset; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (fund position itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced at divestment. |
Case 54. Performance fee / carried interest paid
Transaction type: Performance Fees Section: Fees
| Case | The manager earns a EUR 9,000 incentive fee above the hurdle. |
| Input Guidelines | Add Performance Fees on the BNK / PEQ / PDB asset for 9,000. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (fund position itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the incentive fee. |
Case 55. Per-transaction trading fee
Transaction type: Transaction Fees Section: Fees
| Case | A flat per-trade fee of EUR 15 applies. |
| Input Guidelines | Add Transaction Fees on the CCE / Bank Portfolio; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the fee. |
Case 56. FX settlement fee on a cross-currency trade
Transaction type: Forex settlement Fees Section: Fees
| Case | You incur a conversion fee transacting in a non-base currency. |
| Input Guidelines | Add Forex settlement Fees on the Bank Portfolio; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the fee. |
Case 57. Any other third-party fee
Transaction type: Other Fees Paid Section: Fees
| Case | Legal or administrative charges not covered by a specific fee type. |
| Input Guidelines | Add Other Fees Paid (available for all groups) for the amount; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the fee. ● neutral NAV (asset itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the fee. |
8 · Taxes
Tax cash flows, kept separate from gross income so you can read gross-versus-net clearly.
Case 58. Withholding tax on a dividend
Transaction type: Dividend - Withholding Tax Section: Taxes
| Case | 15% is withheld at source on your dividend; you already booked Dividend - Gross. |
| Input Guidelines |
Add Dividend - Withholding Tax on the BNK / DIR asset for the withheld amount. Keeping it separate enables gross-versus-net analysis and tracks recoverable amounts under tax treaties. |
| NAV |
▼ decreases NAV (current account): the withheld portion never arrives in cash. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced, leaving the net dividend as the true return. |
Case 59. Withholding tax on interest
Transaction type: Interest - Withholding Tax Section: Taxes
| Case | Tax is withheld at source on interest received. |
| Input Guidelines | Add Interest - Withholding Tax on the CCE / BNK asset for the withheld amount. |
| NAV |
▼ decreases NAV (current account): the withheld portion is not received. ● neutral NAV (underlying asset itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax. |
Case 60. Capital gains tax on a disposal
Transaction type: Capital Gain Tax Section: Taxes
| Case | A realised gain triggers EUR 7,000 of capital gains tax. |
| Input Guidelines | Add Capital Gain Tax on the asset (BNK/PEQ/RES/RPD/DIR/DCM/COL/PDB) for 7,000; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the tax. ● neutral NAV (asset itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax, kept separate from the gross gain. |
Case 61. Tax on a fund distribution
Transaction type: Fund Distribution Tax Section: Taxes
| Case | Tax is charged on a profit distribution from a collective vehicle. |
| Input Guidelines | Add Fund Distribution Tax on the PEQ / PDB asset for the tax amount. |
| NAV |
▼ decreases NAV (current account): decreases by the tax. ● neutral NAV (fund position itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax. |
Case 62. Annual securities account tax
Transaction type: Securities Account Tax Section: Taxes
| Case | A wealth-style annual tax on the value of securities held applies. |
| Input Guidelines | Add Securities Account Tax on the BNK / DIR asset for the levy; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the levy. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax. |
Case 63. Stock-exchange / transaction tax on a trade
Transaction type: Securities Transaction Tax / Stock Exchange Tax Section: Taxes
| Case | A financial-transaction tax applies to a securities trade. |
| Input Guidelines | Add Securities Transaction Tax (or Stock Exchange Tax) on the BNK / DIR asset for the tax. |
| NAV |
▼ decreases NAV (current account): decreases by the tax. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax. |
Case 64. Tax on a stock dividend
Transaction type: Stock Dividend Tax Section: Taxes
| Case | Your jurisdiction taxes the deemed value of shares received as a stock dividend. |
| Input Guidelines |
Add Stock Dividend Tax on the BNK / DIR asset for the tax on the deemed value. Pair it with the Stock Dividend contribution that delivered the shares. |
| NAV |
▼ decreases NAV (current account): decreases by the tax payment. ● neutral NAV (holding itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax. |
Case 65. Receiving a tax refund
Transaction type: Tax Return Section: Taxes
| Case | You recover EUR 2,000 of previously withheld tax under a treaty. |
| Input Guidelines | Add Tax Return (all groups) for 2,000; Offsetting IBAN = receiving account. |
| NAV |
▲ increases NAV (current account): increases by the refund. ● neutral NAV (holding itself): unchanged. |
| Performance | ▲ increases Realised performance: increased — it recovers a cost previously charged. |
Case 66. Any other tax / duty
Transaction type: Other Taxes Section: Taxes
| Case | Stamp duty or a local levy not covered by a specific type. |
| Input Guidelines | Add Other Taxes (all groups) for the amount; Offsetting IBAN = paying account. |
| NAV |
▼ decreases NAV (current account): decreases by the tax. ● neutral NAV (asset itself): unchanged. |
| Performance | ▼ decreases Realised performance: reduced by the tax. |
9 · Notional — non-cash tracking
Non-cash, non-NAV entries that track commitments and rights for exposure context only.
Case 67. Tracking an unfunded commitment
Transaction type: Notional Section: Notional
| Case | You commit EUR 2,000,000 to a fund but only part has been called so far. |
| Input Guidelines |
On the Private Equity / Private Debt asset, add Notional for the commitment / remaining unfunded amount. Notional is a non-cash, non-NAV tracking entry — no Offsetting IBAN. This is purely “for your information”: it records exposure context and does nothing to the reported figures. |
| NAV | ● neutral NAV: unaffected — notional entries never change NAV. |
| Performance | ● neutral Unaffected — purely commitment / exposure tracking, with no effect on the reporting. |
Case 68. Recording subscription rights received
Transaction type: Rights Attributed Section: Notional
| Case | A rights issue grants you entitlements to subscribe additional shares. |
| Input Guidelines |
On the holding, add Rights Attributed (all groups) to record the entitlement. This is purely “for your information”: it is a non-cash tracking entry that does nothing in the reporting — no NAV change, no performance. Any later exercise of the rights is booked separately as a Buy. |
| NAV | ● neutral NAV: unchanged — the entry does nothing in the reporting. |
| Performance | ● neutral Unchanged — context only. |
10 · Reconciliation Differences
Cash-account entries that resolve gaps against bank statements; some are performance-neutral, the P&L variants are not.
Case 69. Closing a cash reconciliation gap (no P&L)
Transaction type: Net Cash In / Net Cash Out - Reconciliation Difference (cash) Section: Reconciliation Differences
| Case | Your Finticx balance is EUR 300 below the bank's actual balance and the difference is not a real profit or loss. |
| Input Guidelines |
On the current account (CCE) asset, add Net Cash In - Reconciliation Difference (cash) to add the missing 300 (or Net Cash Out if Finticx is too high). Use the Auto Reconciliation feature on the account to have these balancing entries generated for you. |
| NAV | ▲ increases NAV (current account): corrected upward to match the bank (or down with Net Cash Out). |
| Performance | ● neutral These Net Cash reconciliation types do not create realised performance — they just rebalance. |
Case 70. Reconciling an unidentified income or expense item
Transaction type: Operating Income/Expense - Reconciliation Difference (cash) Section: Reconciliation Differences
| Case | A small unexplained receipt/payment needs absorbing without distorting returns. |
| Input Guidelines |
On the CCE asset, add Operating Income - Reconciliation Difference (cash) or Operating Expense - Reconciliation Difference (cash). Use these when the item is operational in nature; they do not generate performance. |
| NAV | ◆ NAV (current account): adjusted up or down to match the statement. |
| Performance | ● neutral None — operating reconciliation differences are performance-neutral. |
Case 71. Reconciling a timing-related P&L variance (with performance)
Transaction type: P&L Income/Cost - Reconciliation Difference (cash) Section: Reconciliation Differences
| Case | A genuine but unmatched income or cost item should be recognised as return while reconciling. |
| Input Guidelines |
On the CCE asset, add P&L Income - Reconciliation Difference (cash) (income) or P&L Cost - Reconciliation Difference (cash) (cost). Choose these — not the Net Cash variants — when the difference truly represents profit or loss. |
| NAV | ◆ NAV (current account): adjusted to match the bank. |
| Performance |
▲ increases P&L Income variant increases realised performance. ▼ decreases P&L Cost variant reduces realised performance. |
11 · Workflow flags & corrections
Not separate transaction types, but flags that change how an entry behaves.
Case 72. Cancelling a transaction you entered incorrectly
Transaction type: Reversal = Yes Section: Workflow flag
| Case | You booked Buy €500 by mistake and need to undo it cleanly (audit-friendly). |
| Input Guidelines |
Open the erroneous transaction and set Reversal = Yes to cancel it out, then add a fresh, correct transaction (e.g. Buy €600). Reversal preserves an audit trail versus simply deleting. (Not available for every transaction type.) |
| NAV | ● neutral The reversal exactly offsets the original entry's NAV effect, leaving the correct replacement to take effect. |
| Performance | ● neutral Any performance from the original entry is offset too; only the replacement counts. |
Case 73. Planning a future cash flow without affecting today's numbers
Transaction type: ACT | FC = FC Section: Workflow flag
| Case | You want to model an expected capital call next quarter for forecasting. |
| Input Guidelines |
Enter the transaction normally but set ACT | FC = FC (forecast). Optionally set FC Roll Into ACT = Yes so it converts to actual once the period becomes actual. |
| NAV |
● neutral NAV (today): unaffected — forecast transactions are excluded from cash and NAV until flipped to ACT. ◆ Once ACT, it behaves exactly like the equivalent actual transaction (e.g. a Call raising NAV). |
| Performance | ● neutral Performance (today): forecast transactions are excluded until they become actual. |
12 · When NOT to use a transaction
Sometimes the right answer is no transaction at all.
Case 74. A pure market move with no transaction at all
Transaction type: Valuation (not a transaction) Section: NAV / Performance mechanics
| Case | A listed holding simply rose in value over the quarter; no cash flow occurred. |
| Input Guidelines |
Do NOT book a transaction. Instead enter a new valuation for the period (or rely on Quantity × Market Price for listed assets). A manual valuation overrides cumulative transaction movements since the last valuation and sets the new NAV baseline. |
| NAV | ▲ increases NAV (asset): set directly by the new valuation. |
| Performance | ▲ increases NAV Performance: the difference between the transaction-expected NAV and the entered valuation is recognised as unrealised NAV Performance — the mechanism behind market gains/losses. |
4.3.4 Transaction Types
4.3.4.1 Contributions
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Buy | Standard purchase of an asset at market price. Increases the portfolio position and is recorded at acquisition cost for inventory valuation purposes. | CCE, BNK, RES, RPD, DIR, DCM, COL |
| Call | Capital call from a private equity or venture fund requiring the investor to contribute committed capital. Represents deployment of previously committed but uncalled capital. | PEQ, PDB |
| Call (Entry Fee inside Commitment) | Capital call where entry fees (subscription fees) are included within the commitment amount rather than charged separately. | PEQ, PDB |
| Call (recalled Dis-tribution) | Capital call that recalls a previously distributed amount back into the fund. | PEQ, PDB |
| Capex | Capital expenditure on real estate property, representing investment in improvements, renovations, or upgrades that increase the property's value or extend its useful life. | RES |
| Capex Assets under Construction | Capital expenditure for real property development projects not yet completed. Tracks construction-phase investments before the asset becomes operational. | RPD |
| Contribution | General capital contribution to an investment structure, typically cash or assets transferred into a portfolio or holding vehicle. Creates a mirrored entry for tracking purposes. | CCE, BNK |
| Contribution (single sided) | One-sided capital contribution that does not create a corresponding cash entry. Used for specific accounting treatments where only one leg of the transaction is recorded. | CCE, BNK, DIR |
| Invested Capital | Recording of capital deployed into an investment. Universal transaction type applicable across all asset classes to track the cumulative invested amount before the family’s ACT Opening Period. Multiple entries are possible in order to have a more accurate IRR. | All groups |
| Principal Lended | Amount of principal provided as a loan to a borrower. Establishes the lending position that will be repaid over time plus interest. | LEN |
| Principal Withdrawal | Withdrawal of principal from a borrowing facility such as a bank. Represents drawing down on an available credit line or loan commitment. | BOR |
| Stock Assimilation - In | Corporate action where shares of one class are converted or absorbed into another share class. Records the incoming shares from the assimilation process. | BNK, DIR |
| Stock Dividend | Distribution of additional shares to existing shareholders instead of a cash dividend. Increases share count without cash outlay while adjusting the per-share cost basis. | BNK, DIR |
| Stock Merger - In | Receipt of shares resulting from a corporate merger. Records the new or converted shares received when a held company merges with another entity. | BNK, DIR |
| Stock Spin Off - In | Receipt of shares in a newly independent company distributed from a parent company. Records shares received when a company separates a business unit into a standalone entity. | BNK, DIR |
| Stock Split - In | Increase in share quantity from a forward stock split. Records the additional shares received when a company increases its outstanding shares proportionally. | BNK, DIR |
| Stock Swap - In | Receipt of shares through an exchange or swap transaction. Records shares received when exchanging one security for another, often in corporate restructurings. | BNK, DIR |
4.3.4.2 Withdrawals
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Distribution Capital | Return of invested capital from a private equity or fund investment. | PEQ, PDB |
| Distribution Capital (recallable) | Capital distribution that may be recalled by the fund under certain conditions. Subject to potential callback provisions specified in the fund's limited partnership agreement. | PEQ, PDB |
| Principal Repayment | Repayment of borrowed principal on a loan facility. Reduces the outstanding borrowing balance. | BOR |
| Principal Repayment Received | Receipt of principal repayment on a loan extended to a borrower. Reduces the outstanding lending position. | LEN |
| Repayment of Call | Refund or return of a previously called capital amount from a fund. May occur when a deal falls through or capital was over-called. | PEQ, PDB |
| Sell - at Cost |
This transaction type represents the sale of an asset at its original cost basis, with no gain or loss recognised at that stage. It is typically used for specific accounting treatments or transfers between related entities. The amount recorded here is deducted from the most recent NAV to determine the new NAV after the sale. Any difference between the actual sale proceeds and this Sell – at Cost amount must be recorded separately as either a Sell – Realised Gain or Sell – Realised Loss transaction. |
CCE, BNK, RES, RPD, DIR, DCM, COL |
| Stock Assimilation - Out | Removal of shares absorbed in a corporate assimilation. Records the outgoing shares replaced by the assimilated share class. | BNK, DIR |
| Stock Merger - Out | Removal of shares surrendered in a merger transaction. Records shares given up in exchange for new merged entity shares or cash consideration. | BNK, DIR |
| Stock Spin Off - Out | Adjustment to parent company position following a spin-off. Records the cost basis reduction in the original holding to reflect value transferred to the spun-off entity. | BNK, DIR |
| Stock Split - Out | Reduction in share quantity from a reverse stock split (consolidation). Records shares removed when a company reduces its outstanding shares proportionally. | BNK, DIR |
| Stock Swap - Out | Surrender of shares in an exchange or swap transaction. Records shares given up when exchanging one security for another. | BNK, DIR |
| Withdrawal | General capital withdrawal from an investment structure. Represents cash or assets removed from a portfolio or holding vehicle with a mirrored entry. | CCE, BNK |
| Withdrawal (single sided) | One-sided capital withdrawal without a corresponding cash entry. Used for specific accounting treatments where only one leg of the transaction is recorded. | CCE, BNK, DIR |
4.3.4.3 Net
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Gift In | Receipt of assets as a gift or donation into the portfolio. Records incoming value without a corresponding capital contribution, typically for estate planning or family transfers. | All groups |
| Net In | Net transfer of assets into the portfolio from external sources not included in the reporting scope. | All groups |
| Gift Out | Transfer of assets as a gift or donation out of the portfolio. Records outgoing value without a sale, typically for charitable giving or family transfers. | All groups |
| Net Out | Net transfer of assets out of the portfolio to external destinations not included in the reporting scope. | All groups |
4.3.4.4 NAV Adjustment
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| NAV Adjustment - Positive | Upward adjustment to the net asset value of a position. Used to record valuation increases, mark-to-market adjustments, or correction entries that increase portfolio value. | All groups |
| NAV Adjustment - Negative | Downward adjustment to the net asset value of a position. Used to record valuation decreases, impairments, or correction entries that reduce portfolio value. | All groups |
4.3.4.5 Realised Performance
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Distribution Capital Gains | Distribution from a fund representing realized capital gains. These gains are passed through to investors, typically from profitable exits of underlying portfolio companies. | PEQ, PDB |
| Distribution Capital Losses | Distribution from a fund representing realized capital losses. These losses are passed through to investors, typically from unprofitable exits or write-downs of underlying portfolio companies. | PEQ, PDB |
| Distribution Profit | Distribution from a fund representing profit participation or carried interest above the preferred return hurdle. Represents the investor's share of fund profits. | PEQ, PDB |
| Dividend | Cash distribution from a company's earnings to shareholders. Regular income payment on equity holdings, distinct from return of capital distributions. | BNK, DIR |
| Dividend - Gross | Dividend amount before withholding tax deductions. Recorded as the full declared dividend with taxes tracked separately for tax credit or recovery purposes. | BNK, DIR |
| Income Other | Miscellaneous income not classified under standard dividend or interest categories. May include royalties, licensing fees, or other contractual income streams. | BNK, RES, DIR |
| Interest Paid | Interest expense paid on borrowed funds. Recorded as a cost of borrowing on loan facilities or credit lines. | CCE, BNK, BOR |
| Interest Received | Interest income received on lending positions or fixed-income investments. Represents the return earned on capital lent to borrowers. | CCE, BNK, LEN |
| Issue Premium | Premium paid above the nominal value when subscribing to a fund or security. Represents the excess over par value charged for new issue subscriptions. | PEQ, PDB |
| P&L Cost | General profit and loss expense item for non-cash holdings. Captures costs related to investment management or operations not classified elsewhere. | RPD, DCM, COL |
| P&L Cost (cash) | Cash-related profit and loss expense. Captures costs associated with cash management or treasury operations. | CCE |
| P&L Income | General profit and loss income item for non-cash holdings. Captures income from investments or operations not classified under standard income categories. | RPD, DCM, COL |
| P&L Income (cash) | Cash-related profit and loss income. Captures income from cash management activities such as sweep account interest. | CCE |
| Real Estate Opex | Operating expenses for real estate properties. Includes maintenance, property management, insurance, and other recurring costs of property ownership. | RES |
| Rental income | Recurring rental income received from real estate property tenants. The primary income stream from investment properties. | RES |
| Sell - Realised Gain | Profit realized from selling an asset above its cost basis. The positive difference between sale proceeds and the “Sell – at Cost” transaction. | CCE, BNK, RES, RPD, DIR, DCM, COL |
| Sell - Realised Loss | Loss realized from selling an asset below its cost basis. The negative difference between sale proceeds and the “Sell – at Cost” transaction. | CCE, BNK, RES, RPD, DIR, DCM, COL |
4.3.4.6 Operating Income / Expense
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Operating Expense | General operational expense related to portfolio management or administration. Covers costs not directly attributable to specific investments. These transactions will not generate realised performance. | CCE, BNK |
| Operating Income | General operational income from portfolio management activities. Covers income not directly attributable to specific investments. These transactions will not generate realised performance. | CCE, BNK |
4.3.4.7 Fees
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Brokerage Fees | Commission fees paid to brokers for executing securities transactions. Includes trading commissions and settlement charges. | BNK, DIR |
| Custody Fees | Fees paid to custodian banks for safekeeping assets and related administrative services. Covers secure storage and record-keeping of securities. | BNK, DIR |
| Entry Fees Paid | Subscription or entry fees paid when investing in a fund. Also known as front-end load, charged at the time of initial investment. | BNK, PEQ, PDB |
| Exit Fees | Redemption or exit fees charged when withdrawing from a fund. Also known as back-end load, charged at the time of divestment. | BNK, PEQ, PDB |
| Forex settlement Fees | Fees charged for foreign exchange conversion and settlement. Incurred when transacting in currencies different from the base currency. | BNK |
| Management Fees | Ongoing fees paid to investment managers for portfolio management services. Typically calculated as a percentage of assets under management. | BNK, PEQ, PDB |
| Other Fees Paid | Miscellaneous fees not classified under standard fee categories. Covers administrative charges, legal fees, or other service costs. | All groups |
| Performance Fees | Incentive fees paid to managers based on investment returns exceeding a benchmark or hurdle rate. Also known as carried interest in private equity. | BNK, PEQ, PDB |
| Transaction Fees | Fees charged per transaction for buying or selling investments. Covers exchange fees, clearing costs, and other trade-related charges. | CCE, BNK |
4.3.4.8 Taxes
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Capital Gain Tax | Tax liability on realized capital gains from investment sales. | BNK, PEQ, RES, RPD, DIR, DCM, COL, PDB |
| Other Taxes | Tax charges not classified under specific tax categories. May include local taxes, stamp duties, or regulatory levies. | All groups |
| Tax Return | Recovery or refund of previously paid taxes. Represents credits received from tax authorities for overpayment or applicable deductions. | All groups |
| Dividend - Withholding Tax | Tax withheld at source on dividend payments. Deducted before distribution and may be recoverable depending on tax treaties. | BNK, DIR |
| Fund Distribution Tax | Tax withheld or charged on distributions from investment funds. Applied to profit distributions from collective investment vehicles. | PEQ, PDB |
| Interest - Withholding Tax | Tax withheld at source on interest payments. Deducted before receipt and may be recoverable depending on tax treaties. | CCE, BNK |
| Securities Account Tax | Annual tax levied on the value of securities held in an account. Common in certain jurisdictions as a wealth or account maintenance tax. | BNK, DIR |
| Securities Transaction Tax | Tax imposed on securities trading transactions. Charged as a percentage of transaction value on purchases and/or sales. | BNK, DIR |
| Stock Dividend Tax | Tax liability arising from stock dividend distributions. Calculated on the deemed value of shares received as dividends. | BNK, DIR |
| Stock Exchange Tax | Tax levied on stock exchange transactions. A form of financial transaction tax applied in certain jurisdictions. | BNK, DIR |
4.3.4.9 Notional
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Notional | Non-cash tracking entry for commitments or reference amounts. Used to record unfunded commitments or contingent positions without affecting NAV calculations. | All groups |
| Rights Attributed | Recording of subscription rights or warrants received. Tracks entitlements to purchase additional securities at specified terms. | All groups |
4.3.4.10 Reconciliation Differences
| Transaction Type | Description | Valuation Groups |
|---|---|---|
| Net Cash In - Reconciliation Difference (cash) | Cash inflow adjustment for reconciliation purposes. Used to resolve discrepancies between book and bank balances on the positive side. | CCE |
| Net Cash Out - Reconciliation Difference (cash) | Cash outflow adjustment for reconciliation purposes. Used to resolve discrepancies between book and bank balances on the negative side. | CCE |
| Operating Expense - Reconciliation Difference (cash) | Expense adjustment to reconcile cash account differences. Captures unidentified or unmatched expense items during reconciliation. | CCE |
| Operating Income - Reconciliation Difference (cash) | Income adjustment to reconcile cash account differences. Captures unidentified or unmatched income items during reconciliation. | CCE |
| P&L Cost - Reconciliation Difference (cash) | Cost adjustment for profit and loss reconciliation. Used to capture unexplained or timing-related expense variances. These transactions will generate realised performance. | CCE |
| P&L Income - Reconciliation Difference (cash) | Income adjustment for profit and loss reconciliation. Used to capture unexplained or timing-related income variances. These transactions will generate realised performance. | CCE |
4.3.5 Single Sided vs Mirrored Transactions
In general, each transaction in Finticx consists of an asset side and a cash side, ensuring that both the debit and credit aspects of a movement are captured. This becomes clearer when illustrated with an example.
Option 1: Mirrored Transactions
Suppose you purchase a real estate asset. You would start by entering a Buy transaction for the asset RES001 | Parkview Apartments Leuven and select the correct Offsetting IBAN, which represents the cash account used to finance the purchase. You then enter an amount of 1.000.000 EUR as the transaction amount and currency. This single transaction has two effects: it increases the value of the real estate asset by 1.000.000 EUR and simultaneously decreases the value of the linked cash account by 1.000.000 EUR. No value is created or lost; the transaction simply reflects a transfer from cash to the asset.
Option 2: Two Single-Sided Transactions
Alternatively, you can record this movement using two single-sided transactions. In this case, you first enter a Buy transaction on the real estate asset and set Single sided to Yes. This disables all cash-related fields, such as Offsetting IBAN, cash amount, and cash currency.
You then record a second transaction on the cash account, using either Withdrawal or Withdrawal (single sided) as the transaction type, again setting Single sided to Yes. For the Withdrawal (single sided) transaction type, this behaviour is inherent, as it is always single-sided by definition.
4.4 Net Asset Value
4.4.1 General Information
The Net Asset Value (NAV) represents the value of an asset at a specific point in time. In Finticx, NAV is the central concept used to determine portfolio value, exposure, and performance across all reports. NAV is not entered directly. Instead, it is derived from the interaction between valuations, transactions, and where applicable, quantities and market prices. Depending on the asset type and the way data is entered in the tool, NAV can be determined in different ways.
4.4.2 Net Asset Value as a result of a Valuation
When a valuation is entered for an asset, that valuation directly defines the NAV for the corresponding period. A manually entered valuation always overrides any previous valuations and all transaction movements that occurred since the last valuation.
In practical terms, entering a valuation means explicitly stating what the asset is worth at that point in time. Regardless of how the NAV may have evolved through transactions in prior periods, the valuation becomes the new reference value and sets the NAV for that period exactly equal to the valuation amount.
4.4.3 Net Asset Value as a result of Transactions
In Finticx, it is not mandatory to enter valuations in order to determine the Net Asset Value (NAV) of an asset. In certain cases, NAV can be derived entirely from transactions.
When no valuation is entered, the NAV equals the cumulative sum of NAV-impacting transactions. For example, if an asset only has Contribution and Withdrawal transactions, the NAV will reflect the net invested capital resulting from these cash flows. In this scenario, the NAV simply represents the amount that has been invested into—or withdrawn from—the asset over time.
This approach is commonly used when the value of an asset is assumed to be equal to the invested capital, or when no periodic valuation is available or required. As long as no valuation is entered, transactions continue to build the NAV directly. Once a valuation is recorded, however, that valuation becomes the new baseline and overrides the effect of all prior transaction-driven NAV calculations.
4.4.4 Net Asset Value as a result of Valuations and Transactions
For many assets, the Net Asset Value (NAV) in Finticx is determined by a combination of valuations and transactions. In this setup, a valuation establishes the NAV at a specific point in time, after which transactions explain how the NAV changes until the next valuation is recorded.
A typical example of this behaviour is a Private Equity fund (even though this mechanism works for all valuation groups). These funds usually provide an official valuation only on a quarterly basis. However, between these valuation moments, capital calls and distributions often occur and should be reflected in the NAV.
For instance, suppose a Private Equity fund reports a valuation of 500kEUR at the end of March. In April and May, additional capital calls of 100kEUR and 50kEUR are made, and a distribution of 30kEUR is received. Even though no new valuation is available until the end of June, these transactions still affect the NAV. As a result, the NAV at the end of May will reflect the March valuation, adjusted for the net effect of the capital calls and distributions that occurred in the intervening months.
When the next valuation is entered at the end of June, it becomes the new baseline and overrides the cumulative effect of all transaction-driven NAV movements since the previous valuation. From that point onward, subsequent transactions again adjust the NAV until the next valuation is recorded.
The difference between the cumulative effect of all transaction-driven NAV movements since the previous valuation and the new valuation is what we call “NAV Performance” and will be explained further in this chapter.
4.4.5 Net Asset Value as a result of Quantity x Market Price (Listed)
For certain assets, the Net Asset Value (NAV) can be calculated automatically based on Quantity × Market Price. This method is only available for Instruments or Direct Participations with a valid ISIN.
In this setup, the user only needs to indicate the quantity held. This is typically done once in the first valuation (if applicable). Any subsequent changes to the position—such as purchases, sales, or partial disposals—must then be recorded through quantity-increasing or quantity-decreasing transactions.
Once this method is used, users should not enter manual valuations for the asset. Finticx will automatically determine the NAV for each period by multiplying the quantity held by the applicable market price, based on the end-of-day price of the last trading day of the period. Entering manual valuations would override this logic and is therefore not recommended.
This approach ensures a consistent and automated valuation process for listed instruments, while still allowing full control over position changes through transactions.
4.5 Performance
4.5.1 General Information
In Finticx, Performance represents the return earned on an investment over a period of time. While the Net Asset Value (NAV) shows the value of an asset at a specific point, performance explains how much value has been generated during a given period. Performance itself is never entered manually. It is always calculated automatically based on transactions or the interaction between valuations and transactions.
NAV Performance arises from differences between expected NAV (based on transactions) and actual valuations
Realised Performance arises directly from specific transaction types that represent income or gains
Both components are calculated independently and then combined to determine Total Performance. This separation ensures that unrealised value changes and realised cash-based returns are clearly distinguished in reporting.
4.5.2 NAV Performance
NAV Performance represents the unrealised change in value of an asset that is not explained by transactions. It is calculated as the difference between:
- The NAV that would be expected based on the cumulative effect of all transaction-driven NAV movements since the previous valuation, and
- The new valuation entered for the asset
This difference is recorded as NAV Performance. For example, suppose an asset has:
- A valuation of 100 at the end of January
- NAV-impacting transactions of +15 between February and March
Based on transactions alone, the expected NAV would be 115. If a new valuation of 120 is entered at the end of March, the difference of 5 is recorded as NAV Performance.
NAV Performance reflects changes in fair value, market movements, or revaluations that are not explained by transactions. It remains unrealised until the asset is sold or otherwise realised.
In the waterfall chart the NAV Performance can be found between the “Return Base” and the “Net Asset Value” columns.
4.5.3 Realised Performance
Realised Performance represents value that has been actually realised through cash movements. It is generated by transaction types that explicitly represent income or gains.
Examples include:
- Dividends
- Interest received or paid
- Rental income
- Realised gains or losses on sales
These transactions directly impact cash balances and represent performance that has been crystallised, rather than merely reflected through valuation changes.
Unlike NAV Performance, Realised Performance does not depend on valuations. It is fully driven by transaction entry and is immediately reflected in performance reporting.
In the waterfall chart, Realised Performance appears on the right-hand side of the “Net Asset Value” column.
4.6 Basic Case Study: Metlen Energy & Metals (Direct Participation)
In the case studies of this section, we will focus on adding basic valuations and transactions for a single asset, allowing us to cover all key concepts discussed. Specifically, we will use a Direct Participation that later becomes listed on a European stock exchange, Metlen Energy & Metals, as the running example.
In 2023, the Carlton family acquired a stake in Metlen Energy & Metals, a European energy and metals group, as part of their long-term investment portfolio. At that time, Metlen Energy & Metals was still a privately held company. The shares were acquired for a total investment of approximately 5 million EUR, reflecting the family’s conviction in the company’s long-term growth potential in the energy transition and industrial materials sector.
Following Metlen Energy & Metals’ IPO in 2025, the investment became a listed Direct Participation. This asset will be used throughout this chapter to illustrate how valuations, transactions, Net Asset Value (NAV), and performance are recorded in Finticx.
4.6.1 Case Study: Creating a Valuation – Creating the Initial Valuation
The acquisition of the stake in Metlen Energy & Metals took place before the Family’s ACT Opening Period. It is important to note that Finticx offers two ways to handle such situations: you can either enter the full historical transaction history, or you can enter an initial valuation at the start of the reporting period—specifically, a valuation in the period immediately preceding the ACT Opening Period. In this case study, we will follow the latter approach and enter an initial valuation to establish the opening position.
The asset was already created in one of the earlier case studies. Navigate to the Assets section and select the relevant Metlen Energy & Metals Direct Participation. Once opened, navigate to Valuations (at the top of your screen) → Add a New Valuation and click the green + icon in the bottom-right corner of the screen.
Next, we select 2023-12 as the Period (or 31/12/2023 as Date) because the ACT Opening Period is 2024-01 and enter the amount of shares the Carlton family had at that point in time. These were valued at 35 EUR per share, resulting in a total of 5,007,430 EUR.
4.6.2 Case Study: Creating Transactions
In this second part of the case study, we will illustrate how transactions are added for the Metlen Energy & Metals Direct Participation. To cover the most common transaction scenarios, we will record three types of transactions that occurred after the initial investment.
First, the Carlton family made an additional investment in Metlen Energy & Metals on 15 June 2024, representing a follow-on Buy transaction that increases the existing position.
Next, we will record dividends received on 30 September 2024 and 30 September 2025, reflecting the company’s annual dividend payments. On each of these dates, a corresponding withholding tax transaction will also be entered, representing the tax deducted at source on the dividend income.
Together, these transactions demonstrate how additional investments, dividend income, and withholding taxes are captured in Finticx, and how they affect NAV and realised performance over time.
Navigate to the Assets section and select the relevant Metlen Energy & Metals Direct Participation. Once opened, navigate to Transactions (at the top of your screen) → Add a New Transaction and click the green + icon in the bottom-right corner of the screen.
Buy Transaction
Dividend Transaction
Withholding Tax Transaction
4.7 The document library
4.7.1 General information
The Document Library is a central repository within Finticx where supporting documents can be stored and organised alongside the wealth data they relate to. Rather than keeping relevant files — statutes, appraisal reports, loan agreements, bank statements, dividend notices, and so on — scattered across separate drives or mailboxes, the Document Library keeps them in the same environment as the figures that are derived from them. This provides a single source of truth, supports a clear audit trail, and makes the underlying documentation easy to retrieve during reporting cycles and family reviews.
The Document Library can be reached in two ways, both leading to the same documents.
The first route is centrally, from the Side Panel. Under the Library heading, select Documents to open the document library across the workspace, where documents for all Families, Entities, and Assets are listed together but what you see at a given time depends on the family that you are currently viewing. You can switch the family in the top right corner.
The second route is in context, from within a record. When you open a Family, an Entity, or an Asset, a Documents tab appears at the top of the form view, alongside the other tabs for that record (for an asset, for example, next to Asset, Valuations, Transactions, Forecast Parameters, and Forecast). Opening this tab shows only the documents attached to that specific record, which is convenient while you are already working on it.
Either way, documents are always attached to a single Family, Entity, or Asset, and the level they belong to determines where they live and who can see them.
4.7.2 Document Levels and Categories
The Document Library mirrors the three reporting layers of Finticx, and the categories available depend on the level you are working in.
Family level — General documents. Documents that concern the family as a whole. Typical examples include the family charter, the Investment Policy Statement, the engagement letter with the family office, the consolidated wealth report, and KYC/AML documentation.
Entity level — General documents. Documents that relate to a specific legal or financial structure within the family. Typical examples include the articles of association, annual accounts, an extract from the UBO register, and the shareholder register.
Asset level — General, Valuations, and Transactions. At asset level, documents are organised into three categories so that the supporting evidence sits next to the data it underpins:
- General — documents describing the asset itself, such as a title deed, a fund prospectus, a share purchase agreement, an energy performance certificate, or a loan agreement.
- Valuations — documents that support the valuations recorded for the asset, such as an appraisal report, a bank or portfolio statement, or a valuation note.
- Transactions — documents that support the transactions recorded for the asset, such as a purchase deed, a trade confirmation, a dividend notice, a capital call notice, or a repayment schedule.
The Document Library accepts the common file formats used in a family office context, including PDF, Word, Excel and CSV, images, and presentations.
4.7.3 Working with the Document Library
To add a document, open the document library by either route described in section 4.8.1 — from the Side Panel under Library → Documents, or from the Documents tab of an open Family, Entity, or Asset. When working from the central view, select the Family, Entity, or Asset the document belongs to; when working from a record, you are already in the right context. For assets, choose the relevant category (General, Valuations, or Transactions). Then click the green + icon in the bottom-right corner of the screen to add one or more files. You can also drag-and-drop files onto the folders.
Once uploaded, documents can be opened, downloaded, replaced, or deleted, depending on your user role (cfr. section 1.3). As with all data in Finticx, access to documents respect each user’s data role, so users only see documents belonging to the families and entities they are permitted to access (cfr. section 2.2.6).
As a matter of good practice, use clear and consistent document names, and store the underlying source behind each valuation and transaction so that any figure in the report can be traced back to its supporting evidence.
4.7.4 Case Study: Building Carlton's Document Library
To illustrate how the Document Library is used in practice, we continue with the Carlton family and attach a set of supporting documents across the three levels.
At Family level, we add Carlton's general documentation: the family charter, the Investment Policy Statement, the engagement letter, the family organigram, the consolidated wealth report for December 2025, and the KYC/AML file. These describe the family as a whole and are not specific to any single entity or asset.
At Entity level, we open Carlton Holding NV, select its Documents tab, and add its general documents: the articles of association, the annual accounts for 2024, the UBO register extract, and the shareholder register. The same approach is followed for the other entities, such as Carlton Immo NV, Carlton Development BV, and Omega Tech.
At Asset level, we open each asset and use the three categories on its Documents tab to keep evidence next to the data. For the real estate asset Parkview Apartments Leuven, we add the title deed, the energy performance certificate, and a lease overview under General; the 2025 appraisal report under Valuations; and the 2020 purchase deed under Transactions. For the direct participation Metlen Energy & Metals, we add the share purchase agreement under General, the 2023 valuation note under Valuations, and the dividend notice and withholding tax certificate under Transactions.
Once these documents are in place, every key figure in Carlton's reporting — from the holding's net asset value to the dividends and rental income shown in the performance reports — is backed by its source document, stored in the same environment and accessible to the right users.
Chapter 5: Finticx’ Import Module
5.1 The Import Process
In Finticx, entries can be added either directly in the application or through bulk uploads. In this chapter, we will explain in detail how to upload multiple entries at once using the import functionality. Imports can be used both to create new entries and to update existing ones. Working with Excel imports allows you to make large-scale changes efficiently and apply updates across multiple records in just a few seconds.
Step 1: Uploading the file
Start the import process by clicking the Import icon in the bottom-right corner of the data table you want to upload to. For example, if you want to upload assets into Finticx, you must be on the Assets page. You will then be prompted to select the file containing the data to import. The file must be provided in CSV or Excel format.
Step 2: Match the settings and columns to your data
In the next step, you are asked to map the columns from the uploaded file to the fields expected by Finticx for a successful import. On the left-hand side, you will see the column headers from your Excel or CSV file. On the right-hand side, you can map each of these source columns to the corresponding Finticx fields.
A single source column can be mapped to multiple target fields in Finticx. For example, if you want the Asset Name and Asset External Name to be identical, you can map one column from your file to both fields in Finticx.
Step 3: Check the Dry Run
In the next step, you are presented with a dry run of your import file, allowing you to visually validate the potential outcome before the data is actually imported. Based on the quality and completeness of the data, records may or may not be created.
If the information in a row is critically incorrect or incomplete, that entire row will not be imported into Finticx. In the visual below, we explain the meaning of the different icons that may appear during the import process.
By hovering over any of these icons, a message will be displayed explaining what is incorrect and what needs to be adjusted in order for the row to be imported successfully.
If the dry run produces the result you expect in Finticx, you can proceed by clicking the Confirm button at the bottom of the screen. If you want to make changes to your file or adjust the column mapping, you can cancel the import during the dry run by clicking the Close button in the top-right corner of the screen.
5.2 Create by Importing
If you want to create a large number of assets, transactions, valuations, or other records in Finticx without entering them one by one, you can do so using an import file. Before starting the import, you first need to prepare this file. You can either create your own import file or use one of the template files available in the Support Hub.
The concept is straightforward: you create an Excel file in which the first row contains the column headers, not data values. These headers—such as Family, Asset, Period, or similar—are used to indicate how each column in your file should be mapped to the corresponding fields in Finticx during the import process.
5.3 Edit by Importing
If you need to make multiple corrections to data that already exists in your Finticx environment, this can also be done using an import. Instead of editing each entry individually, you can apply changes in bulk by uploading an updated file.
Unlike imports used to create new entries, edit imports typically start from an export from Finticx rather than from a blank Excel file or an import template. At the bottom-right corner of each table in Finticx, you will find an Export button. This export respects the columns currently selected and any filters applied to the table.
After exporting the data in CSV or Excel format, you can open the file locally, make the required changes, and then upload the file back into Finticx.
For edit imports, it is essential to include the ID column, as this field is used to identify exactly which existing records should be updated.
5.4 Import Template Files
To make it as easy as possible to enter large amounts of data into Finticx with minimal effort, Finticx provides import template files, which can be accessed via the Support Hub.
There is at least one import template per table in Finticx (such as Family, Entity, Asset, Valuations, and Transactions). For Transactions and Valuations, a distinction is made between Bank Portfolio assets with Instrument Details and all other scenarios, each of which has its own dedicated template. For Assets, a separate import template exists for each Valuation Group, with an additional dedicated template for Bank Portfolio assets with Instrument Details.
All templates follow the same structure. Each file opens with a READ.ME sheet that explains every field available in the import. This includes both the functional meaning of each field (how it should be interpreted) and the required formatting. For example, fields such as Family or Asset must always be entered using their technical ID format (e.g. FAM001).
The second sheet is used for data entry. Each column is colour-coded to indicate how it should be handled:
- Yellow columns are mandatory
- Blue columns are optional
- Grey columns must not be modified or filled in
This standardised structure ensures consistency across imports and reduces the risk of errors
Chapter 6: Forecasting & Cash Planning
6.1 General Information
In this chapter, we will explain how Finticx can be used to forecast and manage future cash flows. Currently, Finticx offers modelled forecast functionality for two specific valuation groups. For all other valuation groups, forecasting is also possible by entering future-dated transactions and marking them as forecast rather than actual.
Forecasting is closely linked to cash flow planning, as most future transactions have a direct impact on cash positions. In this chapter, we will first explain the available forecast modules, followed by an overview of how to enter additional forecast transactions manually. We will also show how these forecasts influence future cash flows and how the resulting cash flow projections can be analysed in the Wealth Reporting Dashboard.
6.2 Forecasting
6.2.1 General Information
It is important to reiterate the distinction between actuals and forecasts, as this is essential for correctly interpreting forecasted values. This distinction is entirely determined by the ACT Closing Period, which acts as the cutoff period and includes the last set of actual data.
For all periods after the ACT Closing Period, actual entries are ignored and only forecasted values are taken into account. Conversely, for all periods up to and including the ACT Closing Period, forecast entries are ignored, as Finticx expects actual data for these periods.
This mechanism ensures a clear separation between historical actuals and future projections in both reporting and cash flow analysis.
6.2.2 Private Fund Forecast
One of the key tasks in managing private fund investments is projecting future cash flows—both the capital calls that require funding and the distributions that return capital and profits. Finticx supports this through the Private Funds Forecast functionality, which models the expected J-curve based on the fund’s structure, commitment details, and the timing of investments and distributions.
To generate a forecast, you first define a set of core parameters. The Commitment Date represents the moment you formally committed to the fund. From this date onward, Finticx automatically generates a forecast covering the next 96 quarters (24 years).
The Committed Amount, combined with the expected call ratio, determines the forecasted capital calls. These projected calls, together with the expected net return, are then used to calculate the forecasted distributions over time.
You then specify when the Investment period began (or will begin)—that is, the period during which the first capital calls occur—as well as the start of the Harvesting period, when distributions begin. Both the investment and harvesting periods are expressed in years, indicating how long you expect capital to be drawn and how long distributions will take place.
Next, you define the Investment Pace and Harvesting Pace, which determine how cash flows are spread across each period. Pace values range from 1 to 4, representing the weighting of calls or distributions across the years of each phase. For example, a pace of “2-2-2-2” indicates a constant pattern of calls or distributions, while “1-2-3-4” represents an increasing pattern, with fewer cash flows at the beginning and more toward the end of the period.
6.2.3 Real Estate Forecast
To record future transactions for a real estate asset—such as rental income, OPEX, or CAPEX—you have two options. You can enter them manually as individual transactions, just as you would for any other asset. Alternatively, you can use the forecast functionality, which is specifically designed for real estate and is especially useful when planning recurring income or expenditures over multiple future periods.
To generate a forecast, you first need to complete the forecast parameters. These parameters determine the expected rental income by taking into account occupancy rates, rent indexation, and, if applicable, the expected sales value at a future disposal date. In addition to rental income, you can specify an annual OPEX amount and record any planned CAPEX in the dedicated table below the forecast section. This makes it easy to model maintenance costs, renovations, or significant improvements over time.
Once all parameters and future expenditures have been entered, click Regenerate to create the full forecast. Finticx will automatically generate projected income and expenses at three-month intervals, giving you a clear and structured view of the property’s expected cash flows.
Please note: all values before the asset’s closing period are treated as Actuals and will appear in the report as such, while values after the closing period are treated as Forecasts.
6.2.4 Case Study: Forecasting Real Estate
In Case Study 3.4.2, we added the real estate asset Parkview Apartments Leuven to the entity Carlton Immo NV. Now we'll set up a forecast for this property.
There are two ways to enter forecasted revenue and expenses: you can add individual transactions via the Transactions tab, or you can use the Forecast Parameters tab to generate them automatically. Since the forecast generator is more efficient for recurring income and expenses, we'll use that approach here.
The asset must be saved before you can set up a forecast. The Forecast Parameters tab contains three input sections: Forecast Parameters, OPEX, and CAPEX.
Forecast Parameters
This section captures the property's rental income assumptions. Parkview Apartments generates €14,000 per month when fully rented, so we enter €168,000 as the annual rent at full occupancy. The complex rarely has vacancies, so we set the occupancy rate to 95% - the forecast applies this rate to discount the rental income accordingly. We also set the annual rent increase to 2.5%, with an indexation date of 1 January. Each year, the forecasting tool automatically adjusts the rent from that date forward. Since we have no plans to sell this property, we leave the expected sales date and expected sales value empty.
OPEX
Annual operating expenses - such as cleaning services, garden maintenance, utilities, and property management fees - amount to roughly €28,000 per year. We enter this as a single annual figure. The forecast treats OPEX as a predictable, recurring cost.
CAPEX
Capital expenditures are larger, one-off investments and are added individually in the CAPEX table by clicking the plus icon at the bottom. For Parkview Apartments, we add two items: a roof replacement planned for February 2026 at an estimated cost of €45,000, and a bathroom renovation across several rental units scheduled for August 2028 at €35,000.
Generating the Forecast
Once all parameters are in place, click the Regenerate button at the bottom of the screen. The system generates a complete forecast and displays all projected income and expenditures in table form at three-monthly intervals.
After clicking Regenerate, the Forecast tab displays the projected cash flows for Parkview Apartments Leuven in quarterly intervals. Each row shows the expected rental income (adjusted for the 95% occupancy rate and the annual 2.5% rent increase), the OPEX spread across quarters, and any CAPEX items in the period they are scheduled. For example, the roof replacement of €45,000 appears in Q1 2026, while the bathroom renovation of €35,000 shows up in Q3 2028. Notice that the rental income gradually increases year over year as the indexation is applied, while OPEX rises proportionally. The Sell column remains empty since no sale is planned.
6.2.5 Forecasting Transactions
Although Finticx provides modelled forecast functionality for Private Funds and Real Estate assets, it is also possible to enter an unlimited number of forecast transactions for all valuation groups, including Real Estate and Private Equity.
Entering a forecast transaction works in the same way as entering a regular transaction. The only difference is that the transaction must be explicitly flagged as “FC” (Forecast) instead of “ACT” (Actual).
Finticx does not automatically determine whether a transaction is an actual or a forecast based on its date. This is intentional, as there may be situations where you want to enter actual transactions for periods after the ACT Closing Period.
6.3 Cash Flow Planning
6.3.1 General Information
In the forecasting section above, we focused primarily on the asset side of forecasting—explaining how forecasts are generated, which parameters are used, and how forecasted values are calculated at asset level. However, it is important to emphasise that all forecasted movements also have a direct impact on cash positions.
For modelled forecasts (such as those for Private Funds or Real Estate), all forecasted cash flows are automatically mirrored to cash assets using the Default Offsetting IBAN defined in the asset’s master data. This ensures that forecasted capital calls, distributions, rental income, OPEX, CAPEX, or other expected cash movements are consistently reflected in the corresponding cash accounts, allowing future cash balances to be analysed accurately.
For manual forecast transactions, the logic is the same as for actual transactions. An Offsetting IBAN can be selected per transaction, giving you full control over which cash account the forecasted amount should impact. This allows you to model different cash scenarios, such as directing future income to specific accounts or planning future funding needs.
By combining asset-level forecasts with their corresponding cash impacts, Finticx provides a coherent view of future asset evolution and expected cash flows, enabling more accurate cash flow planning and liquidity analysis across the entire wealth portfolio.
Chapter 7: Report – Wealth Reporting Dashboard
7.1 General Information
The Wealth Reporting Dashboard is the main report of the platform. It brings together all wealth components into a single consolidated report and allows you to navigate between all available report pages depending on your analysis needs. You can access the Wealth Reporting Dashboard by navigating to Wealth Reporting → Wealth Reporting Dashboard in the application header.
This chapter provides a comprehensive walkthrough of the Wealth Reporting Dashboard - from navigating the interface and working with filters, to analysing individual asset classes and monitoring performance over time.
The Wealth Reporting Dashboard is organised around three core pillars of a client's wealth:
- Investment Portfolio. The primary focus of the Wealth Reporting Dashboard. The Investment Portfolio has the most extensive set of reports, including overview reports for all valuation groups, individual asset card reports, detailed reports and more.
- Family Assets. Real estate for personal use, personal property, collectibles, and other non-financial assets held by the family that do not serve investment purpose are consolidated under the section Family Asset. Reporting on family assets is kept at a summary level: an overview report and an all-purpose card report is available, but granular valuation-group-level reports are not provided.
- Operating Participations. Shares or stakes held in the companies from which the family’s wealth oftentimes originates, often involving active ownership or board roles are similarly represented at a high level within the dashboard. As with family assets, the reporting for operating participations is limited to overview and card-level views. That ensures that the global wealth picture is accurate and complete, while acknowledging that the detailed reporting and monitoring of such holdings typically falls outside the standard wealth management scope.
Note: Throughout this chapter, the explanations will primarily draw on the Investment Portfolio, as this is where the full breadth of the reporting functionality is available and most relevant to daily use.
7.2 Navigating through the Reports
7.2.1 Navigating through the top bar
The top navigation bar is always visible and provides direct access to the main sections of the dashboard. When viewing Global Wealth, the top bar shows the five main sections: Global Wealth, Investment Portfolio, Family Assets, Operating Participations, Analysis, and Reconciliation.
The navigation bar is context-sensitive: its contents change depending on the report page you are currently viewing. When you navigate to any page within the Investment Portfolio, the bar updates to show the available valuation groups - Bank, Real Estate, Private Funds, and so on. Under Other, you also have access to the Direct Commodities, Project Development, and Collections & Varia reports.
Clicking on these header items will open up a dropdown menu which shows all the available report for that section. For example, when clicking on Bank, you will see that there are 5 report available: Overview, Card, Asset Manager, Instrument Breakdown, and Instruments. To close the menu, click anywhere on the page.
7.2.2 Navigating through the navigator
The Navigation Page provides a complete map of all available reports. You can access it via the compass icon 🧭 on each page in the top right corner.
The page is organised into four tabs along the top: Global Wealth, Investment Portfolio, Operating Participation, and Family Asset.
Selecting a tab displays all reports available for that section. Each row represents a valuation group (e.g. Bank, Real Estate, Private Funds), and its available report types - Overview, Card, Detail, Curve, etc. - are shown as buttons to the right of each row. Clicking any button navigates directly to that report page.
On the right side of the Navigation Page, an Analysis panel lists all cross-portfolio analytical reports: Transactions, Benchmark, Performance, Valuation, Time Series, and the three Reconciliation reports.
7.3 The Slicer Panel
7.3.1 General Information
The Slicer Panel is a collapsible control panel available on every report page. It can be opened by clicking the hamburger menu (☰) in the top right corner of the screen.
It allows users to control what is shown on the visuals of each report page - from family and entity selection, to reporting period and currency, dynamic filters, and visual configuration of charts and tables.
The panel is designed so that each control is positioned directly above the visual it affects. For example, the Matrix Row Structure dropdown sits above the matrix table it controls, and the Donut Detail selector is placed above the corresponding donut charts.
Most selections made in the Slicer Panel are synced across pages. This means that filters applied on one report - such as entity selection or reporting period - will carry over when navigating to other reports, with the exception of a few page-specific settings. The available options in the panel adapt to each page, so only the controls relevant to the active report are displayed.
7.3.2 Defining the reporting scope and customizing your view.
The top row of the Slicer Panel contains the core context controls: family selection, entity selection, reporting currency, and reporting period. Together, these four settings define the basic context of every report.
The Family Name dropdown appears as the first control in the Slicer Panel. This allows the you to switch, if applicable, between different client families without needing to leave the report. Changing the family selection reloads all report data for the newly selected family, while keeping the same report page and layout active. Note that you can only view one family at a time and reporting across families is not possible. The Entity Selection dropdown filters the report to one or more entities (or entity groups) within the selected family. By default, all entities are included. Selecting a specific entity - or a combination of entities - limits all visuals to the assets and data attributed to those entities only.
The Reporting Period dropdown defines the last month of the reporting window. You will see that above most visuals, a period toggle bar allows you to select the length of the reporting window: MTD, QTD, STD, YTD, HTD, ITD, LTM, or Custom (cfr. Section 7.4). The combination of these two settings determines the data range shown. For example, selecting YTD with a Reporting Period of April 2025 means all data from January to April 2025 is taken into account. For cases where a custom window is needed, the Custom From Period field allows you to define the starting month of the reporting period. Note that the Custom From Period setting has no effect unless Custom is actively selected on a visual. You can see an example of a visual with a custom period as shown in the screenshot below.
The Reporting Currency dropdown controls the currency in which all values are displayed. By default, the Base Currency is selected - this is the currency you defined as the main currency when creating the family. Other options include Asset Currency, which is most relevant for card report pages and displays all numbers in the currency of the asset, and Instrument Currency. Note that when a report covers assets in multiple currencies - such as the Global Wealth or Investment Portfolio Overview - selecting a non-base currency may result in some visuals being empty, as a mix of currencies cannot be displayed together.
There are also some options to change the display of numbers. Decimal and Decimal (%) set the number of decimal places shown for absolute values and percentages respectively. Scale allows you to display large numbers in thousands (K), millions (M), or billions (B), which can make reports easier to read for large portfolios.
7.3.3 Working with filters
The Slicer Panel contains four dynamic filters that allow you to slice the report data along any dimension you choose. Each filter consists of two dropdowns: the first lets you select the dimension you want to filter on (e.g. Geography), and the second lets you select one or more values within that dimension (e.g. Europe EMU, Europe non-EMU, North America).
By default, all four filters are set to show all data. You can activate one or more filters independently, and they stack - meaning each active filter further narrows down the data shown. For example, setting Filter 1 to Sector → Health Care and Filter 2 to Geography → North America will show only assets that match both criteria simultaneously.
Since filters are synced across pages, any filter you apply will remain active as you navigate to other reports. If filters are active, you will see that an info card appears that says Filters Active.
7.3.4 Customizing Visuals
Several visuals in the dashboard can be customized directly from the Slicer Panel, allowing you to control how data is grouped and displayed.
Customizing the Donut Charts
Donut charts across the dashboard have a Donut Detail dropdown positioned directly above them in the Slicer Panel. The donut charts display the NAV by a category of your choice. In the example below, the chart on the left is showing the NAV by Valuation group (Real Estate Project Development, Private Equity, Bank-Portfolio, etc.) and the right one is showing the NAV by Asset Currency (EUR, USD, GBP). This way you can see at a glance how the wealth is distributed across the categories that matter most to you, and switch between different classification dimensions.
Every visual includes a focus mode icon in its top-right corner. Clicking this icon expands the selected visual to fill the report canvas, hiding the surrounding visuals on the page. This provides a larger, more legible view of a single chart, table, or KPI without leaving the report. To exit focus mode, click Back to report in the top-left corner. The booklet returns to its original layout with all visuals visible.
Customizing the Matrix
The matrix visual can also be customized through the Matrix Row Structure selector in the Slicer Panel. This dropdown supports multiple selections and controls how the rows of the matrix are grouped and nested. The options are organised the same way as the donuts selector:
The order in which items are selected determines the hierarchy: the first selected category becomes the top-level row grouping, and each subsequent selection adds a deeper level of nesting beneath it. In the example below, Valuation Group is selected first, displaying categories such as Bank – Portfolio, Borrowings, and Cash & Equivalents as the primary rows. A second selection then defines the sub-level visible beneath each, such as the regional breakdown shown under Bank – Portfolio. You can add a third, or even fourth category that will group the data further.
Another possible view could be the division by sector and nested geography. If you first select sector, and then geography, the matrix will display the following:
7.4 Time Window (MTD, QTD, STD, YTD, HTD, Custom, ITD, LTM)
Most visuals contain buttons on the top left of the visual that let you choose the time window of the data over which performance and NAV figures are calculated.
All periods end at the chosen reporting period and differ only in their start date. In the graphic below you can see the options for the chosen reporting period May 2026 visualized.
MTD (Month-to-Date) covers only the current calendar month, from the first to the last day of the chosen reporting period's month. For example, with May 2026 as the reporting period, MTD runs from 1 May to 31 May 2026. QTD (Quarter-to-Date) extends back to the first day of the current quarter - in this case the start of Q2 which is 1 April 2026. STD (Semester-to-Date) and YTD (Year-to-Date) both start on 1 January of the current year and are therefore identical when the reporting period falls within the first half of the calendar year - here both starting on 1 January 2026. They diverge in the second half, when STD resets to 1 July while YTD continues from 1 January.
HTD (History-to-Date) reaches back to the family's ACT Opening Period. This makes HTD the standard long-term performance window for most reporting purposes. In the example above, the ACT Opening Period is January 2024, so HTD covers the full period from January 2024 to Mai 2026. ITD (Investment-to-Date) goes even further, starting from the first transaction date of each individual asset. LTM (Last Twelve Months) is a rolling window that always covers exactly the past twelve months, regardless of where they fall in the calendar year - in this example running from 1 June 2025 to 31 Mai 2026.
Finally, the Custom range allows you to define any start date manually.
7.5 Global Wealth
The Global Wealth tab provides a consolidated, top-level view of the family's entire wealth portfolio - all assets across the three Performance Types: Investment Portfolio, Family Assets, and Operating Participations.
The page is structured around four visual components: a summary performance table breaking down NAV and returns by Performance Type, a Periodic & Cumulative Total Performance chart tracking MWR over time, a Change in NAV waterfall chart decomposing the movement in portfolio value across the selected period, and a set of four donut charts showing NAV distribution by Valuation Group for each Performance Type. Each of these visuals follows the same logic and uses the same controls as their counterparts in the Investment Portfolio tab, where they are described in detail (cfr. section 7.6).
7.6 Investment Portfolio
7.6.1 General Information
The Investment Portfolio forms the core of the Wealth Reporting Dashboard, bringing together all assets classified under the Investment Portfolio performance type. As these assets are most relevant to wealth managers, the Investment Portfolio has the most extensive set of reports available. Depending on the valuation group, these include an Overview, Card, and Detail report, as well as a number of additional reports.
There are a main set of visuals that come back on many report pages. In this section, we’ll explain in more detail, based on the Overview report, what each visual displays.
7.6.2 Net Asset Value & Performance Summary
At the top of the dashboard (1), the total Net Asset Value is displayed prominently and reflects the family's wealth with investment purpose up until the selected Reporting Month.
Directly alongside the NAV, the dashboard shows two key performance indicators for two independently selected time periods (2). By default, these are set to MTD and YTD. The first indicator, Total Performance, expresses the absolute change in NAV attributable to performance in the base currency. The second, Total MWR/TWR, expresses the Money-Weighted Return or Time-Weighted Return as a percentage.
7.6.3 NAV and Performance Breakdown by category
Below the summary figures (3), the performance table breaks down total NAV and performance by Valuation Group. By default, the rows represent Valuation Groups, but this can be changed via the slicer panel to any other categorisation that suits your needs (cfr. section 7.3.4). For each category, the table shows the absolute NAV, its percentage share (taking the selected filters into account), its percentage share within the Investment Portfolio, the Total Performance in absolute terms, and the Total Return as a percentage. The row can be expanded to show the individual asset-level breakdown. This makes it immediately clear which parts of the portfolio are driving overall performance and where the largest wealth concentrations lie.
7.6.4 Periodic & Cumulative Total Performance and Change in NAV
The right-hand side of the dashboard contains two charts that together show how performance has evolved over time and what drove the change in portfolio value over the selected period.
The upper chart (4) - Periodic & Cumulative Return per period as bars alongside a cumulative return line. You can control the time horizon is controlled separately via the 1Y / 2Y / 3Y / HTD buttons.
The lower chart (5) - Change in NAV - breaks down the movement in portfolio value as a waterfall, from the opening NAV through Net Contributions, NAV Performance, and Realised Performance to the closing NAV (cfr. section 4.5). Two toggles control how this breakdown is presented. The F/N toggle isolates currency effects by splitting performance into organic and FX components when set to F. The D/S toggle switches between a Detailed view - where contributions, withdrawals, cash movements, and NAV adjustments are shown separately - and a Simplified view that combines these into a single Net Contribution bar.
7.6.5 Card Report
Each Valuation Group in the investment portfolio has a dedicated Card report which gives you a focused view of one asset at a time. You can switch between assets using the dropdown selector at the top of the left panel, which also displays an image and, where available, additional context such as the property address for real estate assets.
The left panel shows the asset's details across three tabs:
The Masterdata tab contains all administrative and classification fields of the asset that you have entered when creating the asset. The Valuations tab lists all valuations within the selected time window (format: YYYYMM), shown in both the valuation currency and the selected reporting currency, with a toggle to switch between actuals and forecasts. The Transactions displays all transactions recorded against the asset within the same time window.
The right panel shows the asset's NAV, Total Performance, Total Return, the Change in NAV waterfall, and the Periodic & Cumulative Total Performance chart but only for the individual selected asset.
7.6.6 Detail Report
In addition to the standard Overview and Card pages, certain Valuation Groups offer a Detail page that provides asset-type-specific metrics and analytics beyond the standard tables and visuals. Detail pages are currently available for Real Estate, Private Funds, and Direct Participations. While each Detail page is tailored to the characteristics of its asset type, they all follow the same principle: extending the standard reporting with the metrics and context that are most relevant for that category of assets. To illustrate this, we use the Real Estate Detail page as an example.
At the top of the page, the headline figures for NAV, Debt, Debt Ratio, and Net NAV give an immediate picture of the overall financial position of the real estate portfolio. The debt figures are particularly relevant here, as real estate assets are often partially financed through borrowings — the Debt Ratio and Net NAV allow you to quickly assess the degree of leverage across the portfolio. Alongside these, aggregate performance and rental metrics are shown for two independently selected periods.
The performance table in the middle of the page lists all individual properties and allows you to compare them side by side. In addition to the standard NAV and performance columns, it includes metrics relevant to the real estate assets, such as Rental Yield and Purchase Value. This makes it straightforward to identify which properties are generating the strongest rental returns, which carry the most debt, and how each contributes to the overall portfolio.
7.7 Family Assets & Operating Participations
Family Assets and Operating Participations each have their own dedicated section, as you can view in the screenshot below:
As these asset types are not the primary focus for wealth managers, the range of reports available is more limited compared to the Investment Portfolio. Both Family Assets and Operating Participations offer an Overview and a Card report. The Overview report combines all assets belonging to the relevant performance type into a single consolidated view, regardless of their valuation group. The Card report allows you to view one asset at a time across all valuation groups, but always filtered for the relevant performance type - Family Assets or Operating Participations respectively.
7.8 Analysing Performances
The Performance report provides a detailed breakdown of how the total NAV has evolved over a selected period. It is used to understand the drivers behind NAV changes at portfolio level because it decomposes the movement into its key components: NAV Start, Net Contributions (Contribution, Withdrawal, Cash In/Out, Net In/Out, NAV Adjustments), Return base, NAV Performance, Realised Performance, and NAV End (see section 4.5 for a more detailed explanation for each component). These components are displayed both as summary KPIs at the top of the page and visually in a Change in NAV waterfall chart.
Below the waterfall chart, a detailed asset-level table breaks down each component per individual asset. By default, the table is structured with the Asset Label at the highest level, followed by the transaction type. This structure allows you to start from an asset and understand which transaction types drove its NAV movement.
For example, expanding CCE001 | JPM Current Account reveals the individual transaction types that impacted this account during the period - such as Capex, Dividend, Interest Received, and Principal Repayment.
7.9 Overview in Time Series
The Time Series page allows you to track a selected metric across your portfolio over a custom date range. You can view the values side by side month by month, quarter by quarter, or year by year.
Three view options are available in the top-right area of the matrix. Matrix – Standard displays the data as a plain table, while the Matrix – Coloured presents the same layout but applies colour coding to make increases and decreases more immediately visible. Ribbon Chart switches the display from a table to a stacked visual chart.
Each category is represented as a colour-coded band, with the height of each band reflecting its value for that period. The grouping of the chart is determined by the first row dimension selected. Additional row dimensions have no impact on the ribbon view. Within the chart, categories are ordered by value: those with the lowest values appear at the bottom and those with the highest values at the top.
At the top of the page, three controls determine what is displayed in the visuals below.
- Year Month Nr Use the two date fields to define the start and end of the period range you want to analyse. Enter values in YYYYMM format (for example, 202001 for January 2020 and 204012 for December 2040).
- Row Dimension This dropdown controls how the rows of the matrix are organised. It determines the grouping and labelling of assets in the left-hand column. For example, selecting Entity Label and then Asset Label groups assets by entities and displays the asset labels as subcategories. You can select as many subcategories as you want.
- Metrics This dropdown defines the value displayed in each cell of the matrix. You can select from NAV Start, Contribution, Withdrawal, Cash In/Out, Net In/Out, NAV Adjustment, and NAV End to track balance and cash flow figures over time. For performance analysis, the available options are NAV Performance, NAV Return (%), Realised Performance, Realised Return (%), Total Performance, and Total Return (%). Only one metric can be selected at a time, and it applies across all rows and periods in the matrix.
Use this page to track how individual assets or groups of assets have developed over an extended period. It is well suited for spotting trends, identifying outliers, and supporting client conversations with concrete historical data. For example, you can show a client how the NAV of their private equity portfolio has evolved over the past three years, or compare contribution and withdrawal activity across assets over a specific period.
7.10 Benchmarking
The Benchmark page allows you to compare the performance of an individual asset against a benchmark of your choice. Where other pages provide a portfolio-level view, this page focuses on a single asset at a time and places its performance in context by setting it against a reference.
At the top of the page, four controls determine what is displayed. Use Choose an asset to select the asset you want to analyse. Use Choose a Benchmark to select the reference you want to compare it against. The dropdown lists all assets flagged as Benchmark Purpose Only (cfr. Appendix A, E.2.), as well as any regular asset you may wish to use as a reference. As on all other pages, you have Performance Classification and Return Classification options as well.
The right side of the page displays two charts – period and cumulative performance. You can choose to view them either as a bar chart or as a line chart by clicking the Line Chart or Bar Chart buttons above the charts.
7.11 Cash and Quantity Reconciliation
The Cash and Quantity Reconciliation section serves as a data quality tool: it surfaces discrepancies between the cash flows and quantity movements recorded in Finticx and the opening and closing balances on file for a selected period.
The reconciliation section is divided into two sub-pages REO – Current Accounts and RECO- Quantities.
RECO – Current Accounts focuses on cash positions. For each current account in scope, it shows the Opening Balance, Closing Balance, Change in Cash Balance, and Cash Flow recorded through transactions. Where the change in balance cannot be fully explained by the recorded cash flow, a Reconciliation Difference is shown in the final column.
To reduce the need for manual cash reconciliation, Finticx offers the Auto Reconciliation feature for assets and instruments linked to an IBAN. When enabled on a Current Account asset (cfr. Appendix A, E.4) , the system automatically generates a reconciliation transaction between two valuations to align the recorded cash flows with the change in cash balance. For example, if a current account has a valuation of 100 in January 2024 and 120 in December 2024, Finticx automatically creates a transaction of 20 to cover the difference.
RECO – Quantities performs the equivalent check for instrument positions, tracking Opening Balance Quantity, net Quantity Flow, and Closing Balance Quantity. Any unexplained gap appears in the Reconciliation Difference column, which is particularly relevant for Bank Portfolio assets where quantity accuracy drives NAV calculation.
Where a difference is intentional and understood, it can be formally resolved by recording a Reconciliation Differences transaction (cfr. section 4.3.2).
Chapter 8: Report – Wealth Reporting Booklet
8.1 General Information
Explain focus on printing vs analysing
….
Chapter 9: Report – Custom Reports (Add-on)
Explain the possibility of creating a custom report
Chapter 10: Instrument Reporting (Add-on)
10.1 General Information
Instrument Reporting in Finticx enables look-through reporting at the level of individual securities held within a Bank Portfolio, such as shares, bonds, ETFs, or funds. This functionality is available exclusively to users with the Instrument Details Add-on.
Without the add-on, Bank Portfolios are managed as a closed box, meaning valuations and transactions are entered at portfolio level only. While this approach is efficient and sufficient for high-level reporting, it does not provide insight into the underlying instruments that make up the portfolio.
When the Instrument Details Add-on is enabled, each security within a Bank Portfolio is modelled as a separate Instrument. Transactions, valuations, and performance are recorded at instrument level, and the total value of the Bank Portfolio is calculated automatically as the sum of its instruments. This allows for consistent aggregation across portfolio, entity, and family level reporting.
10.2 Benefits of Instrument-Level Reporting
The primary benefit of instrument-level reporting is increased transparency and analytical depth. By tracking individual securities, you gain detailed insight into:
- The exact composition of each Bank Portfolio
- Exposure by geography, sector, currency, asset class
- Concentration and overlap risks, especially across multiple portfolios
- Performance attribution, showing which instruments drive returns
This is particularly valuable in environments where multiple banks or asset managers are involved. It is common for different managers to hold positions in the same underlying securities—such as large-cap equities or widely held ETFs—across different portfolios. Instrument-level reporting makes these overlaps visible and allows them to be analysed at consolidated level.
As a result, instrument reporting supports better-informed investment decisions, risk management, and portfolio oversight.
10.3 Data Entry Methods for Instruments
Instrument-level reporting requires more detailed data input than portfolio-level reporting. All transactions and valuations must be maintained per instrument, which can significantly increase operational workload if done manually.
Finticx supports two ways of maintaining instrument-level data:
- Manual entry, suitable for smaller portfolios or limited instrument activity
- Automated SFTP connections, recommended for larger portfolios or frequent trading
The following sections explain both approaches in detail, allowing you to choose the method that best fits your operational setup.
Chapter 11: Current Account Bank Integration
Overview
The Current Account Integration in Finticx allows you to connect your bank accounts directly to the platform, eliminating the need to manually enter daily balances and individual transactions. Once a connection is established, Finticx receives a daily feed from your bank covering both the account valuation and any new transactions that have occurred since the last update.
The integration is built on top of Salt Edge, a regulated account information service provider that handles the secure connection between Finticx and the participating banks. The list of supported banks is wide and covers most major European institutions, including Belgian banks such as KBC, BNP Paribas Fortis, ING, and Belfius.
Impact on Your Workflow
Connecting your current accounts changes how two specific data types are handled in Finticx: valuations and transactions.
Valuations
For any current account that is connected, valuations are no longer entered manually. Every day, Finticx receives the official end-of-day balance from the bank and stores it as the valuation of the corresponding Cash & Equivalent asset. This means:
- Your reporting always reflects the actual bank balance, without lag or rounding from manual entries.
- The monthly or quarterly habit of typing in current account balances is no longer needed.
- Historical valuations build up automatically from the moment the connection is active.
Transactions
Transactions follow a slightly different logic. Instead of being booked directly, every incoming transaction arrives in a Pending Transactions queue, waiting for data enrichment.
Finticx pre-fills everything the bank can provide:
- The transaction date
- The amount
- The Offsetting IBAN (the counterparty's account number)
What Finticx cannot determine on its own is the meaning of the transaction within your portfolio. The user is therefore expected to add two pieces of information:
- The Transaction Type (for example: Call, Distribution, Subscription, Redemption, Fee, Transfer)
- The Asset ID — the specific asset the transaction relates to
A concrete example: a five-hundred-thousand-euro outflow from your current account toward a private equity fund will arrive in the Pending Transactions queue with the date, amount, and counterparty IBAN already filled in. To complete it, the user sets the Transaction Type to "Call" and links it to the relevant Private Equity asset. Once saved and approved, the transaction is fully booked, and reporting is up to date.
Setting Up the Connection
Setting up a new current account connection is reserved for users with the Application Admin role. Regular users do not have access to the Connectivity section of the Admin Center and will therefore not be able to initiate or manage connections themselves.
The setup process consists of three steps: establishing the bank link, configuring the connection inside Finticx, and triggering the initial data load.
Step 1 — Establishing the Bank Link
- Open the Admin Center from the profile dropdown in the top-right corner of the platform.
- Navigate to the Connectivity tab.
- The Connectivity screen lists the different connection types available in Finticx. The second section is dedicated to Current Account connections.
- Click the green plus icon in the Current Account section to start a new connection.
- A pop-up will appear asking you to confirm that you agree with the Salt Edge user license terms. Agreement is mandatory to proceed.
- After confirming, click the Connect button. You will be redirected to a Salt Edge interface where you can select the bank you wish to connect — for example, KBC.
- Once a bank is selected, you are redirected to the bank's own login page. The first thing the bank typically asks is the name and ownership of the account. This information is collected purely to comply with anti-money laundering regulations, so the exact selection here has no impact on how the account behaves in Finticx.
- After completing the bank's authentication flow — typically using itsme or an equivalent strong authentication method — you may be asked which accounts you wish to share with Finticx. This step is bank-specific: some banks connect all accounts by default, while others let you pick. Select the relevant account(s) and confirm.
Step 2 — Configuring the Connection
Once the bank link is established, the connection appears in the Connection Management tab a few minutes later. Initially, the connection will show as failed. This is expected: at this point Finticx knows how to reach the bank, but it doesn't yet know which Cash & Equivalent asset in your portfolio the incoming data should be mapped to.
There are two equivalent ways to complete the configuration:
- Click the connection in the Connection Management tab and select the Configure button on the right-hand side.
- Or, alternatively, go to the Admin Center and open the Configurations tab directly.
Both paths lead to the same configuration screen. Here, you link the connected current account to the correct Cash & Equivalent asset for the correct family. Once the link is set, confirm your selection by locking the toggle button on the right.
Step 3 — Triggering the First Data Load
Once configured, valuations and transactions will automatically flow into Finticx starting from the next daily cycle (typically the following morning).
If you want the data to be transferred immediately rather than waiting for the next cycle, you can go back to the Connectivity page and refresh the connection manually. This triggers an on-demand upload of the entries.
After the refresh, the connection should switch to a successful status, and the data becomes available in two places:
- The Valuations table, where the first valuation entry for the linked asset appears. Sorting the ID column in descending order is the fastest way to surface the newest entries.
- The Pending Transactions table, where all newly imported transactions are queued for enrichment.
Working with Pending Transactions
The Pending Transactions table is the day-to-day touchpoint for users working with connected current accounts. This is where data enrichment happens and where transactions move from a raw bank feed to fully booked entries in the portfolio.
Approving a Transaction
For each transaction, the workflow is straightforward:
- Identify the transaction in the queue. The date, amount, and Offsetting IBAN are already filled in.
- Select the relevant Transaction Type (for example, Call, Distribution, Fee).
- Select the relevant Asset ID — the asset in your portfolio that this transaction relates to.
- Click the green checkmark to approve the transaction. The transaction is now booked and leaves the pending queue.
Saving Without Approving
In some teams, transaction enrichment and transaction approval are split between two people — for example, an analyst prepares the entries and a controller signs off on them. To support this, Finticx allows you to fill in the asset ID and transaction type and save the data without approving. The transaction remains in the pending queue, but with its enrichment fields already populated, ready for a second user to review and finalize.
Rejecting a Transaction
Not every transaction is relevant for reporting. Personal expenses such as groceries, restaurant payments, or other private outflows do not need to be tracked in Finticx and can be rejected.
It is important to be aware that rejecting transactions creates a reconciliation difference: the bank's balance includes the rejected outflow, but Finticx no longer does. To prevent these differences from accumulating, we strongly recommend enabling the Auto Reconciliation feature on any current account where transactions are regularly rejected. Auto Reconciliation generates an automatic balancing entry so that the Finticx balance matches the bank's. The Auto Reconciliation feature is covered in detail in the Current Accounts section of this Bible.
Inspecting Transaction Details
Clicking on a transaction opens an extra detail view with the full set of fields received from the bank — useful when the description or counterparty information is needed to identify what the transaction relates to. If you want to access this detailed view for several transactions at once, a dedicated button at the top of the table opens a bulk detail view.
Table Features
The Pending Transactions table supports the standard set of Finticx input table transformations, which makes it easy to work through large batches:
- Grouping — transactions can be grouped by IBAN, by Counterparty, or by status. Grouping by Counterparty is particularly useful when several transactions belong to the same fund or relationship and can be processed in one logical block.
- Sorting and filtering — both work as in any other input table and help narrow the view to the transactions that are relevant at a given moment (for example, only transactions above a certain amount or only those tagged with a specific counterparty).
- Bulk mapping — multiple transactions can be selected at once and assigned the same Transaction Type and Asset ID in a single action. This is the fastest way to process a series of similar entries, such as recurring management fees or multiple drawdowns on the same private equity commitment.
Key Things to Remember
- Only Application Admins can create or configure current account connections.
- A newly created connection always shows as failed until it has been linked to the correct Cash & Equivalent asset in the Configurations screen.
- Valuations are pushed automatically once per day — no user action is required after setup.
- Transactions always arrive in Pending status. They never reach the booked portfolio without explicit user enrichment and approval (or rejection).
- The user is responsible for two fields per transaction: Transaction Type and Asset ID. Everything else is provided by the bank.
- Rejecting transactions creates reconciliation differences — use Auto Reconciliation to absorb them automatically.
Appendix A: Input Field Explanation
A. Family
Header
Family Name: Name of family you report to. The family serves as the umbrella under which all entities and their assets are organized.
General
ACT Opening Period: The month and year to start reporting in Finticx. This determines the history-to-date return calculation. All wealth components in possession before the starting period can be entered by assigning them a valuation. All wealth components acquired during or after the starting period need to be entered using a buy/contribution transaction type.
ACT Closing Period: This is the closing period of the Actuals. This means that ACT valuations and transactions after the ACT Closing Period are not considered in the report and FC valuations and FC transactions before that period are also disregarded. The ACT Closing Period is the cut-off between Actual and Forecast.
FO Base Currency: The standard currency used for reporting purposes for the family. Any transactions or valuations in other currencies are automatically converted to this base currency using ECB exchange rates.
Default FC Roll into ACT: Select Yes if you want forecast transaction records to automatically become actual records when the closing period is updated to a date later than the forecasted transaction.
NAV includes Accrued Interest: Set the default for creating valuations. Choose Yes if you want the reported NAV for instruments to include accrued interest.
Single Sided: Set your default for all transactions. Select Yes if you want transactions to automatically exclude the cash side when creating them. This disables all cash-related fields, such as Offsetting IBAN, cash amount, and cash currency. You can override this default individually for each transaction when you add them.
Valuation Method: Choose between FIFO and Moving Average, or select Not applicable.
B. Entity
Header
Family: The family that the entity belongs to.
Entity Name: The name of the entity. Entities represent legal or financial that hold wealth components in the form of assets. Each family should have at least one entity.
General
Entity Group: The group that an entity belong to. Grouping entities enables easy selection of multiple entities in the report.
Private Person: Select Yes if the entity is a natural person. Select No for legal entities (trusts, foundations, holding structures).
Date of Birth: It is optional to include a date of birth for entities.
C. Entity Ownership
Header
Family: The family associated with the respective entity.
Entity: The entity for which you wish to define the ownership.
General
From Period: The month and year as of when the ownership percentage applies. All ownership percentages apply until a new ownership percentage for a later From Period is defined.
Ownership (%): The ownership percentage of the entity. Give a percentage of less than 100% if an entity is not fully owned by the family and thus should not take the full 100% of the reported amounts. For example, if the valuation is €100,000 and the entity holding the asset is 50% owned, only €50,000 will be included in the NAV calculation.
D. Strategic Allocation
Header
Family: The family for which the strategic allocation is being added. Although recommended, it is not mandatory to add a strategic allocation for the family.
From Period: The month and year when the strategic allocation is applied. All strategic allocations apply until a new allocation for a later From Period is defined.
Classification
Class Name: The asset class to be included in the desired portfolio.
Allocation (%): The proportion of the selected asset class in the portfolio.
Return Target (%): The expected yearly return for the selected asset class.
E. Asset
E.1. Header
Family (ID): The family associated with the asset. An asset always belongs to one family. After creation, the family cannot be changed anymore.
Entity (ID): The entity associated with the asset. An asset always belongs to one entity.
Asset Name: Name of the asset.
Valuation Group: Group with distinct requirements as regards their data collection and valuation. Once an asset with a certain valuation group has been saved, the valuation group of that asset can no longer be changed.
Instrument Details (Subscription add-on): Selection possible for the valuation group Bank - Portfolio. Select yes if you want to report on individual instruments, rather than only on the consolidated bank portfolio. If you don't want to use instrument details, you fill in transactions and valuations on the bank asset itself, if you do, you add valuations and transactions on the instruments.
Valuation Type: Based on the valuation group but further specifies the type of asset. For example, when choosing valuation group Private Equity, you can further specify whether it is a Direct Fund or Fund of Funds asset.
E.2. General
Asset Currency: Select the currency in which the asset is valued.
IBAN: Bank account number associated with Cash & Equivalent assets with valuation type Current Account. The input is mandatory for all current accounts. A family can have multiple current accounts with the same IBAN but the combination of IBAN and currency has to be unique for each family.
Offsetting IBAN. Select the current account that offsets the financial impact of this asset. The dropdown shows the current account assets, current account instruments and their corresponding currency that were added previously.
Asset Opening Period: No input required. The date is based on the by the first transaction or the Report Opening Period selected for the family owning the asset. For example, the Opening Period of the family is January 2024 (202401) but the asset is bought in March 2025 (202503), then the asset opening period is 202503 from the buy transaction.
Asset Closing Period: The date when the asset will be closed, sold, or becomes inactive. Leave the date as 2099-12 if the asset is still active and there is no definite closing date.
Closed Asset: The asset closing period can be overruled by selecting Yes which sets the status of the asset as closed no matter the Asset Closing Period.
Maturity Date: Date when the asset reaches its end term and principal is repaid. It is available for several valuation groups and is used in cash flow forecasting.
Benchmark Purpose Only: Select yes if the asset is used only for benchmarking and should not be treated as an actual investment. The means that the asset’s value does not contribute to the portfolio value. Benchmark-only assets can be used to compare yields with assets that are currently owned.
Forecast Only: Select yes if asset should only be included in forecast models and should not be treated as an actual investment at this point in time. The means that the asset’s value does not contribute to the current portfolio value. Forecast-only assets can be used to forecast prospective investments’ returns.
E.3. Classification
Performance Type: Indicate whether the asset is classified as family inventory, as an investment, or as company-held. Each performance type serves a different purpose and carries its own return expectations. Assets within the investment portfolio are assets where you expect a specific return on. Family Assets are leasure & pleasure assets (family residence, old-timer collection, art collection etc.). Operating participation are assets where the family is steering a company in management or is part of the board of directors.
Valuation Class: No input required. It is derived from the valuation type.
Asset Class: Based on the previously selected valuation type. If there is more than one asset class available, you can allocation them by choosing To be allocated.
Cash Availability: Indicate whether the asset has liquid cash available for new investments or if it is already committed.
Currency Exposure: The currency in which the asset’s transactions are financially denominated. Select To be allocated for selecting multiple currencies.
Geography: Choose the geographic region or focus of the asset. You can select from the default categories, add a custom location, or choose To be allocated if the asset is distributed across multiple regions.
Sector: Choose the sector to which the asset belongs. You can select from the default categories, add a custom sector, or choose To be allocated if the asset spans multiple sectors.
Country Region: Select the specific country or region associated with the asset. Select from the default categories or add your own.
E.4. Cash & Equivalents
Part of Bank Portfolio: Select the relevant bank portfolio asset from the dropdown if the asset you're creating should be included as part of an existing investment portfolio. This is especially relevant for current accounts that are part of a bank portfolio without instrument details.
Include in Cash Flow: Select yes if the Cash & Equivalents asset generates cash inflows or outflows that should be included in the cash flow model.
Auto Reconciliation: Relevant for the valuation type Current Account. Select Yes to let automatically generate reconciliation transactions to match cash account balances between periods. For example, if the valuation changes from 100 in 202401 to 120 in 202412, Finticx creates a transaction of 20 to reconcile the difference.
E.5. Bank Portfolio
Portfolio Type: The type of portfolio the asset belongs to.
Bank Asset Manager: The institution responsible for overseeing and managing the asset.
Custodian: The entity that holds and safeguards the asset.
E.6. Private Equity Classification
Enterprise Size: Relevant for Private Equity Assets. Select the size of the companies in which the fund is invested in. Select from the default categories, add a custom enterprise size, or choose To be allocate if the asset spans multiple categories.
Fund Size: Relevant for Private Equity assets. Select the total size of the fund from default categories, or add your own.
Style: Relevant for Private Equity assets. Select the investment style or strategy. Select from the default categories or add your own.
Vintage: Relevant for Private Equity assets. Select the year the asset was acquired or created. Select from the default categories, add a custom enterprise size, or choose To be allocated if multiple years are applicable.
E.7. Private Equity – J Curve (& Forecast Parameters)
Expected Call Ratio: Enter the percentage of committed capital that is expected to be drawn down over time. This represents how much of the committed funds will actually be invested. Enter a positive decimal number between 0 and 2 with 0.1 increments.
Expected Net Return: Enter the projected net return on investment after deducting fees, costs, and carried interest. Enter a positive decimal between 0 and 5 with 0.1 increments.
Commitment Date: Select the date when the capital commitment was formalized (e.g., when the agreement was signed).
Committed Amount Asset Curr: Enter the total capital committed to this investment in the asset’s currency. This is the amount investors have agreed to provide.
Fund Duration: Enter the total expected lifetime of the fund in years, including both the investment and harvesting periods.
Investing as of Year Quarter: Select the year and quarter when the fund started deploying capital into investments.
Investment Duration in Years: Enter the expected period (in years) during which the fund will be actively investing.
Investment Pace: Define the expected speed at which the fund deploys capital into investments. By defining an investment pattern. The investment period is divided into four quarters, with each number representing the relative intensity of deployments in that quarter. A faster pace means the fund plans to invest assets more quickly, while a slower pace suggests a more a more gradual approach.
Harvest as of Year Quarter: Select the year and quarter when the fund begins exiting investments (start of harvesting phase).
Harvesting Duration in Years: Enter the expected timeframe (in years) for the fund to fully exit its investments. Enter a positive integer.
Harvesting Pace: Define the expected speed of asset exits by selecting a distribution pattern. The harvesting period is divided into four quarters, with each number representing the relative intensity of exits in that quarter. A faster pace means the fund plans to liquidate assets quickly, while a slower pace suggests a more extended divestment period.
E.8. Private Equity - Fee Structure | Gross to Net
Management Fee After Investment (%): Enter the annual management fee percentage charged after the fund’s investment period has ended.
Management Fee Base After Investment: Select the base on which the post-investment management fee is calculated (e.g., NAV, committed capital, amount called).
Management Fee During Investment (%): Enter the annual management fee percentage charged during the investment period.
Management Fee Base During Investment: Select the base on which management fees are calculated during the investment period (e.g., committed capital).
Issue Premium (%): Enter the percentage premium applied at subscription, representing the surcharge above the fund’s NAV.
Entry Fee (%): Enter the percentage fee paid upon entering the fund, typically charged to cover distribution or placement costs.
Fund Target IRR (%):The expected internal rate of return (IRR) that the fund aims to achieve over its investment period. This percentage represents the fund's targeted annualized return, taking into account cash flows, reinvestments, and exit values.
Hurdle: Enter the minimum annual return percentage the fund must achieve before carried interest is paid to the general partner.
Catch Up: Select Yes if the fund includes a catch-up mechanism in its profit-sharing structure.
Carry: Enter the percentage of profits allocated to the general partner once the hurdle and catch-up mechanisms are met.
E.9. Private Equity - Other
Issuer: Enter the legal entity issuing the fund or investment.
Country of General Partner: Select the country where the general partner is legally established.
Legal Form: Enter the legal structure of the investment vehicle (e.g., NV, SA, CommV).
Reporting by: Select who is responsible for providing the reporting.
Reporting Frequency: Choose how often reporting is received.
Fiscal Structure: Enter the fund’s tax structure or regime applicable to investors.
Share Class: Select the share class of the investment (e.g., A, B, Institutional).
Private Equity Shares: Enter the number of shares held in this private equity investment.
Participation Type: Defines the nature and structure of the private equity investment. This classification determines how the investment is categorized in terms of capital deployment strategy and investment approach. Select from the categories or add your own.
E.10. Real Estate
Real Estate Type: Relevant for valuation group Project Development. Choose the type of real estate project from the list, or add your own.
Asset Purchase Value Asset Curr: The purchase price of the real estate asset in the currency of the transaction.
Additional Purchase Cost Asset Curr: Any additional costs related to the purchase of the asset, such as transaction fees, notary costs, or legal fees.
Total Purchase Value: No input required. The total cost of acquiring the real estate asset, including both the purchase price and additional costs.
Purchase Date: The date when the real estate asset was acquired.
Surface m2: The total surface area of the real estate asset in square meters.
Real Estate Type. The type of real estate asset.
City: The city where the real estate asset is located.
E.11 Address Info
Street: The street name where the real estate property is located.
N°: The house or building number of the property.
Unit: The unit, apartment, or suite number if applicable.
ZIP/Postal Code: The postal code for the property’s location.
City: The city where the property is located.
Province/State: The province or state of the property’s address.
Country: The country in which the property is located.
Region: The broader geographic region the property belong to.
E.12. Forecast Parameters – Real Estate
Annual Rent at Full Occupancy: The total yearly rent the asset would generate if fully occupied.
Occupancy Rate (%): The average occupancy rate of the real estate asset in percent.
Indexation Date: The date from which rent indexation is applied.
Annual Rent Increase (%): The expected annual rent increase for the asset, based on inflation.
Expected Sales Date: The estimated date when the real estate asset is expected to be sold. Leave this field empty if no sale is expected.
Expected Sales Value: The estimated sales price of the real estate asset at the expected sales date.
Annual OPEX Expenses: The estimated yearly operating expenses for repairs and maintenance of the real estate asset.
Capex – Date: The date when planned capital expenditure for the real estate asset is expected to occur.
Expected Capex: The expected cost of the planned capital expenditure (e.g. renovations, upgrades, or major replacements) for the real estate asset.
Expected Capex Period: Automatically filled in. The last date of the quarter in which the real estate asset is expected to be sold.
E.13. Borrowings & Lendings
Loan Amount: The total value of the loan granted.
Credit Limit: The maximum amount of credit that a lender is willing to extend to a borrower. Unlike the loan amount, the credit limit is not necessarily drawn down in full but represents the upper boundary of available borrowing. The amount needs to be equal or greater than the loan amount.
Borrowing Type: The specific type of borrowing arrangement.
Lending Type: The type of lending arrangement, such as term loans or lines of credit.
Duration (Months): The length of time, in months, over which the loan is to be repaid.
Interest Rate: The rate at which interest is charged on the loan or credit.
Reference Interest Rate: The benchmark interest rate used to calculate loan interest.
Basepoints vs Reference Interest Rate: The difference between the loan’s interest rate and the reference rate, expressed in basis points.
Endebted Asset. The asset pledged as collateral for the loan or credit. The dropdown list contains all assets that are not other borrowings.
Intercompany Counterparty: The related entity within the same corporate group involved in the loan or credit transaction. The dropdown list contains all entities from the same family.
Guarantees: A promise or commitment made by a third party (often someone other than the borrower, such as a guarantor) to cover the debt or obligation if the primary borrower defaults.
E.14. Other
Share Type: Available for the valuation group Direct Participation. Select the types of shares.
Collection Type: Available for valuation group Collections & Varia. Select which category of collectibles the asset belongs to.
Commodity Type: Available for the valuation group Direct Commodities. The category of the commodity.
Unit of Measure: Available for the valuation group Direct Commodities. The measurement unit used for the commodity.
Asset External ID: Select an identifier for the asset from your own system.
Asset External Name: The name assigned to the asset in your external system.
ISIN: Relevant for valuation group Direct Participation. No input required. If in the field Asset External ID, a valid ISIN is entered, then it will be shown in the ISIN field as well.
Project: Groups assets into projects which enables reporting on project basis across states.
Price Method: Determines how the commodity's price is determined.
URL Image: Add the URL of an image you want display on the asset page in the report.
Asset Information: Additional metadata or details about the asset.
E.15. Custom Fields
Custom Fields 1–3: Define them yourself in the Configurations under Customizable Settings. Enter any value.
F. Instrument
All fields with (auto) are automatically filled in if a valid ISIN has been entered as instrument ID.
Header
Instrument ID: Enter the ISIN, IBAN, or instrument code of the asset. If the instrument is publicly traded and the ISIN is recognized, all publicly available information will be automatically populated. Save the instrument with a valid ISIN and name, and the data will refresh automatically after approximately 30 minutes. For privately listed instruments without an ISIN, the fields must be completed manually.
Instrument Name (auto): The name or identification of the financial instrument. Automatically filled in if a valid ISIN has been entered as instrument ID.
ISIN: No input required. This field indicates whether a valid ISIN has been filled in for Instrument ID.
Valuation Type: Select the valuation type that describes the instrument best.
Instrument Type: It shows what kind of financial product an ISIN represents, for example a stock (EQU), bond (BND), or fund (ETF).
IBAN: Only available for instruments with the valuation type Current Account (bnk) and for Investor Account.
Classification
Cash Availability: Indicate whether the instrument has liquid cash available for new investments or if it is already committed.
Valuation Class: Based on the previous selected valuation type.
Asset Class: Based on the previously selected valuation type. If there is more than one asset class available, you can allocation them by choosing To be allocated.
Currency Exposure (auto): The currency in which the instrument’s transactions are financially denominated. Select To be allocated for selecting multiple currencies.
Geography: Choose the geographic region or focus of the asset. You can select from the default categories, add a custom location, or choose To be allocated if the asset is distributed across multiple regions.
Sector: Choose the sector to which the asset belongs. You can select from the default categories, add a custom sector, or choose To be allocated if the asset spans multiple sectors.
Industry Classification: The specific industry in which the issuing company operates (e.g., Pharmaceuticals, Software, Retail).
Parent Industry Classification: A broader sector grouping that includes multiple related industries (e.g., Healthcare, Information Technology, Consumer Goods).
General
Instrument Currency (auto): The currency in which the instrument is listed and traded.
Country of Instrument (auto): The country where the instrument is legally registered or issued.
Company Location: The city where the issuing company is based.
Market Ticker: The unique symbol used to identify the instrument on its primary trading exchange.
Selected Trading Venue: The exchange where the instrument is most actively traded, such as NASDAQ for Apple Inc..
Company Short Name: The name of the company that issued the instrument
Trade Status: Indicates whether the instrument is currently traded or not.
Instrument Status: The financial instrument’s condition, determining whether it is still tradable or has matured.
Issue Date: The date when the instrument was first issued or made available to investors.
Maturity Date: The date when the instrument is due for repayment or closure, marking the end of its lifecycle.
Corporate Action
Last Corporate Action Company: Describes the last corporate action specifically affecting the company (e.g., ISIN-level events like redenomination or delisting).
Last Corporate Action Company Date: The date by which an investor needs to purchase and hold shares to be eligible for the benefits of a corporate action, such as dividends or stock splits.
Last Corporate Action Instrument: Describes the last corporate action specifically affecting the instrument (e.g., ISIN-level events like redenomination or delisting).
Last Corporate Action Instrument Date: The date by which an investor needs to purchase and hold shares to be eligible for the benefits of a corporate action, such as dividends or stock splits.
G. Valuations
Header
Family: The family associated with the asset or instrument to be valued.
Asset: The asset for which the valuation is being entered.
Instrument (subscription add-on): This field appears if the asset selected is a Bank Portfolio with Instrument Details. The dropdown list contains all private and public instruments.
Period: The year and month when this valuation becomes effective. The valuation remains valid until a new one is entered. If you enter a date in the field Date, then the period is automatically set for you.
Date: When a period is entered, the date is automatically set the last date of the selected month. If you want to enter a valuation for a specific date, use the field and the period will adjust accordingly.
Valuation
Quantity: For assets with the valuation group Direct Participation, and Bank Portfolio it represent the number of shares, while for Direct Commodities, is the amount in the selected unit of measure.
Price: No input required. It calculates the price per share or per unit of measure by dividing Amount Valuation Currency with Quantity.
Use ECB conversion: Only relevant for BNK Assets with Instrument Details. Select Yes to automatically convert amounts between valuation currency and asset currency using ECB rates for the selected period. Select No to manually enter your own amounts.
Amount Valuation Currency: The valuation amount, expressed in the selected valuation currency.
Accrued Interest Valuation Currency: The accumulated interest on bank portfolio up until the chosen period in the valuation’s selected currency. Input is only possible for assets with valuation group Bank Portfolio with instrument details.
Valuation Currency: The currency applicable for this specific valuation.
Amount Asset Currency: The valuation amount of all shares combined, expressed in the asset’s currency. Input is only possible for assets with valuation group Bank Portfolio with instrument details. The amount is automatically calculated based on the selected amount and valuation and asset currencies using ECB rates but can be manually overwritten.
Accrued Interest Asset Currency: Entry only possible for Bank Portfolio with Instrument Details. The accumulated interest on bank portfolio up until the chosen period in the asset’s currency.
Yearly Net Asset Value Growth (%) : The percentage change in the asset’s net asset value (NAV) over the course of one year. This will result in a monthly increase of approximately 1/12th of this yearly amount. Input is possible for the assets with valuation groups Bank Portfolio, Real Estate (Development), Direct Participation, Direct Commodities, and Collections & Varia.
NAV includes Accrued Interest: Choose Yes if you want the reported NAV for instruments to include accrued interest.
Amount at Cost: Represents the original purchase price or book value of the asset in its base currency.
Asset Currency: No input required. The currency of the asset for which you are entering a valuation.
Direct Participation
Ownership (%): No input required. It is calculated by dividing the Equity Value by the Amount Valuation Currency.
Equity Value: The value of the company’s equity, calculated as Enterprise value minus debt.
Enterprise Value: The total value of the business, including both equity and debt.
Real Estate
Occupancy (%) : The percentage of the property that is currently rented out.
Ownership : Choose whether the property is fully owned or held in usufruct (the right to use the property and receive income from it, without having full ownership).
Walt : Weighted Average Lease Term. The average remaining duration (in years) of all active lease agreements, weighted by rental income.
Walb: Weighted Average Lease Break. The average time (in years) remaining until tenants can exercise their first break option, weighted by rental income.
Private Equity:
Reported IRR (%): The annualized return on investment based on the fund’s reported valuations and cash flows. This metric reflects the fund’s performance over time, considering actual and forecasted gains.
Info
Comment: Enter any relevant notes or additional information regarding the asset or transaction.
H. Transactions
Header
Family: Select the family associated with the asset or instrument.
Asset: The asset for which the transaction is recorded.
Instrument (subscription add-on): This field appears if the asset selected is a Bank Portfolio with Instrument Details. The dropdown list contains all private and public instruments.
Transaction Type: Select the type of transaction. The dropdown list shows the categories possibles for the selected valuation group.
Date: The date of when the transaction occurs and its impact is recorded.
Offsetting IBAN: Only relevant for transaction types that require cash mirroring. The dropdown list contains all IBANS combined with their asset currency of the current account assets and instruments of the family.
Transaction – Asset side
Quantity: For assets with the valuation group Direct participation and Bank Portfolio. It represent the number of shares, while for Direct commodities, it is the amount in the selected unit of measure.
Price: No input required. It calculates the price per share or per unit of measure by dividing Amount Valuation Currency with Quantity.
Use ECB conversion: Only relevant for BNK Assets with Instrument Details. Select Yes to automatically convert amounts between valuation currency and asset currency using ECB rates for the selected period. Select No to manually enter your own amounts.
Amount Transaction Currency: The amount involved in the transaction in the selected transaction currency.
Amount After Fees Transaction Currency: The amount of the transaction after all fees are deducted in currency of the transaction.
Transaction Currency: The currency in which the transaction occurred.
Amount Asset Currency: Only relevant for instruments. The total amount of the transaction in the asset’s currency.
Amount after Fees Asset Currency: The amount after deducting all fees (in the currency of the asset).
Asset Currency: No input required. The fields displays the asset currency.
Transaction – Cash side
Cash Amount: Only relevant for all assets that require cash mirroring. The amount is automatically calculated based on the selected transaction amount and cash currency using ECB rates. Should this exchange rate not be applicable to this transaction, you can manually overwrite it.
Cash Currency: This is the currency of the selected offsetting IBAN.
Singe Sided: Select Yes to record the cash side of the transaction via the Offsetting IBAN as well. You can set the default for this field on the family page.
Details
ACT | FC: Select whether the transaction is an actual transaction or a forecasted transaction. Forecasted transactions are excluded from performance and cash calculations until they are changed to ACT.
Reversal: Select Yes if you want this transaction to cancel out an incorrectly entered transaction. For example, if you entered Buy €500 incorrectly, you can either delete it or add a Reversal transaction that undoes the Buy €500, then create a new transaction with the correct values, such as Buy €600. Note that this is not available for all transaction types.
FC Roll Into ACT : Select Yes if you want forecast transaction records to automatically roll into actual records when the period in which the transaction was recorded becomes actual.
Info
Comment: Add any relevant notes or additional information regarding the asset or transaction.
Bank Statement Field 1: Provide here additional context or details, if applicable.
Bank Statement Field 2: Provide here additional context or details, if applicable.
Comments
0 comments
Article is closed for comments.