How do I use the Debt Eligibility reporting tool?

Introduction

When you use our app to facilitate the distribution of your guarantee or grant programmes, you benefit from our “Reporting” functionality, which assist you in tracking loans and preparing your activity reports for your program's guarantor entities.

This feature also enables you to make bulk modifications to reservation data, such as reporting dates or final validation date, so that you can easily report back to your distributors on the final decision that has been charged to their guaranteed loan application.

Creating a data template
Importing external data into Kls
Editing and exporting your data

How do I use the “Reporting” function for one of my guarantee or grant programmes?

The Reporting function is available for each of your programmes.

You simply need published programmes, that is, one which is either being distributed or paused.

On your Programme's home page, you will find a "Reporting" button in the top right-hand corner of your interface. Click this button to continue.

Distributors also have access to this functionality, although their view of reservations is limited to their own portfolio, and they are not able to modify any information.

Creating your Reporting template

Clicking the button will take you to the template creation page.

Here, you can select from all available fields within your programme those which are relevant to your reporting needs.

You may create and save your preferred templates for future use, with no restrictions on how often they are reused, clicking “Create a new template” in the top right-hand corner. After choosing a name, you will be taken to a page split into two sections:

On the left, a list of all available export fields
On the right, your selected fields for the template.

Tick the field(s) you require from the list on the left.

Use the arrow [➞] button between the tables to move fields into your template.

You can then rearrange your selected fields as you wish.

When ready to proceed, use the “Actions” button in the top right-hand corner and select “Start reporting”.

Once templates are saved, you can go directly on “Start reporting” without repeating the creation phase.

Importing external data for your reporting

Certain information you need to create your reports may be absent if not gathered through the Debt Eligibility interface (for example, credit data from your organisation's internal systems).

In these cases, you can import specific data into the reporting function, centralising your information and building comprehensive reporting packs.

On the reporting homepage, next to the template creation button, you will find the option to import data via a pre-existing import file.

The import file is an Excel template downloadable from the same page via the drop-down menu in the top right-hand corner.

Once the Excel template has been completed, re-import it and the new data will be incorporated into your next report.

Currently, the following data are not supported for import: CRD (Capital Outstanding), Maturity and guarantee payment details.

If you have additional requirements, please contact your Kls account manager.

Return to the homepage to launch a data export using one of your templates.

Editing information and data extraction

You are now in the interface dedicated to editing reservations and loans for your programme.

This interface allows you to view all the reservations and loans, edit reporting information and export all this data in Excel format for use in other tools, regulatory reports preparation, and more.

Use the filters on the left to refine your displayed results.

A central table lists all reservations for your programme. Editable reporting information appears in the first column, with the subsequent fields reflecting your chosen template layout.

You may select all or certain reservations to update dates or details as required, enabling a chronological record of your reservations.

Only selected lines will be updated.

Completing the validation date for a guaranteed loan request (reservation), will transfer the request to “Validated” status. This action confirms that the guarantee request has been reported to the guarantor and positively acknowledged.

You can revert any erroneous changes using the “Reset field to 0” button.

Once you have made all necessary updates, click “Export all”. The app will generate an Excel file containing all visible information.

You can then use this file to reconcile internal data, feed internal tools, or generate your regulatory reports as needed.