Loan Management System III
User manual
Table of content
Introduction
Glossary
Web application login
Dashboard screen
Loans screen
FX Revaluation button
Delete loan button
Export button
Search field
Loan screen
Details tab
Transaction's tab
Repayment schedule tab
Schedule sub-tab
Payments sub-tab
Transaction sub-tab
Documents tab
Loan interest types tab
Rate field
Compounding field
Date options:
Interest calculation frequency field
Interest payment date schedule field
Calculations steps tab
Ticket system
Ticket types screen
Checklist's screen
Forms screen

Introduction

This user manual explains the loan management system inside the Asamco platform.

Glossary

Abbreviation

Explanation

LMS

Loan management system

MD

Master data

RT

Reports

LIT

Loan interest type

IPD

Interest payment date

DBM

Disbursement

The status symbols are as follows:
= LMS module (This button takes you directly into the loan management system)
= Refresh grid (This button refreshes the grid of the current screen you are in)
= Export button (This button exports the current screen you are in and all the content within that specific screen to an excel document)
= Column chooser (The column chooser allows you to filter on specific headers to make searching or finding a specific loan or transaction)
= Reset (This button reset the current screen you are in to its default state)
= Options (This button allows you to enable or disable certain filter parameters)

Web application login

Sign into the Asamco portal using this link: https://asamco-portal.azurewebsites.net/#!/auth/login
You should see the login page displayed as shown below:
Fill in your username and password and you will now be logged into the portal. Note that as the portal is developed the appearance might change slightly.

After logging in please select the relevant organisation, you want to work in. For this user manual we will be selecting the Asamco (demo) organisation.

Click on the Asamco (demo) organisation and you will be presented with the companies and the connected applications that are linked to each company.

After clicking on the Asamco B.V. company, you will be presented with an overview of all the connected applications linked to that company. The connected applications you can see here are managed by permissions that are assigned by the organisation's administrator.



To submit a new loan please open the LMS application.

Dashboard screen

The first screen you will see after logging in is the "Overview screen". You can click on the "submit new loan" button on the overview screen or the "submit new loan" node on the left tree menu (see below). Note that depending on permissions you might have more or less icons available on your dashboard.

Loans screen

After you have clicked the "Loans" button you will see the following screen displayed:
Users can view, open, add and delete loans in this loan overview screen.
This screen shows a grid of all loans. The columns and rows shown in this grid are customizable to the users' preferences through the Column Chooser and the header filters.

Clicking the eye button will open a loan and take the user to the loan screen.

FX Revaluation button


Click to carry out a currency revaluation on selected loans by pressing the FX Revaluation button, which opens the FX Revaluation popup screen.
Revaluation date: Select the revaluation date
Grouping option: Select between combined, principle & interest and compound interest
Auto reverse transactions: Toggle between ON and OFF.
Realized: Toggle between ON and OFF.
To export the FX revaluation click on the export button as shown below.

Delete loan button

Click on the red x button as shown below to delete a loan.
Note: This is only possible if there are no transactions existing on this loan.

Export button

All grid screens in LMS have an option to export to excel.

Search field

Users can filter loans here using a search term that will search through any column

Loan screen

Users can see all details for a loan here.
The top-right of the screen offers several action buttons:



Details tab

This tab shows all the specific details on the loan properties, such as agreement and maturity dates, principal, and interest amounts. Users can edit the loan's properties here by clicking the Edit loan button.

Transaction's tab

This tab shows a grid with all transactions on a loan.
Above the grid are several buttons that allow the user to create new transactions:

Repayment schedule tab

Schedule sub-tab



Payments sub-tab

Transaction sub-tab




Documents tab

Users can upload new documents to a loan, and download, edit and delete existing documents linked to the loan. The files can also be viewed in the separate DMS application.

Loan interest types tab

Users can view, add, edit, and delete the Loan Interest Types (LITs) that will be used with the functionality on the Calculate interest button in the Transactions tab.
A LIT is a calculation that runs on the basis of loan's outstanding principal amounts as well as the settings configured in each LIT. LITs can have fixed or variable interest rates, can compound upon themselves or other LITs, have fixed or variable schedules and dates. Each LIT can be assigned its own sub-transaction type. A loan can have as many different LITs as a user desire.

Create new interest type button: click to start creating a new LIT.
Save button: Changes will be saved only upon pressing the Save button. Changes to schedules (explained below) do not require pressing the Save button.
Delete button: Click to delete the currently selected LIT. This is only possible if there are no linked transactions of this LIT posted on the loan. A newly Reset loan should always allow the user to delete all LITs.

Configuration Headers:
Loan interest type (general)
Description: fill in a name for the LIT.
Calculation type: choose between 'Interest calculation' (calculation on the basis of loan principal) and 'Commitment fee' (calculation on the basis of loan facility amount).
Last calculation date: the system will update this field automatically after the user has used the Post button in the Calculate interest window in the Transactions tab.
Begin date: fill in a start date for the LIT calculation.
End date: fill in an end date for the LIT calculation.
Day count convention: choose the day count for the calculations on this LIT. ISDA/Actual and 360/365 days. Each LIT can have only one assigned day count convention.

Rate field

Interest rate: if the LIT should calculate on the basis of a fixed interest percentage, choose Fixed. The only other option then becomes Margin.
Margin: fill in the interest rate.

Compounding field

Compounding enabled: click this checkbox to enable compounding. Checking this box will also show the following options: Frequency: choose between compounding calculation frequency: daily, monthly, bimonthly, quarterly, semi-annually, or annually.

First compounding date: choose a date on which the first compounding transaction will take place and from which the compounding frequency period will start.
Compounding end of period: choose a date after which no more compounding transactions may take place.

Business day option: choose between:


Create compounding transactions: check this box for the calculation to post compounding transactions. If left unchecked, only compounding interest will be posted but not the actual compounding transactions themselves.

Only own transactions: check the box to allow the compounding calculations to take place only over transactions from this LIT. If left unchecked, the compounding calculation will take place over the total of all transactions, including those from other LITs.
Selecting this box allows the user to view the View compound schedule button: this opens the Compound schedule popup window.
Generate schedule button: generates a new schedule based on the chosen Frequency and Business Day options. Click the button to open the Generate schedule popup window.

Date options:

End date of loan interest type: the schedule will be generated with the chosen date of the LIT as its end date.

Maturity date of loan: the schedule will be generated with the maturity date of the loan as its end date.
Manual: pick any end date for schedule generation

After picking a date, click the Generate button to create the schedule in the Compound schedule window.

Reset schedule button: Click to remove the currently existing schedule. An empty schedule means that compounding dates will be based exclusively on the chosen Frequency and Business Day options.

Add compounding date button: Click the + button to add one more date to the schedule.






Refresh grid button: click to refresh the screen in case any updates have been directly made in the database.

Edit compounding date button: Click to manually select a different date for this compounding transaction. The original date will remain visible in the grid after picking a new date.

Delete compounding date button: Deletes a compounding date. This means no compounding will take place on this date as long as the compounding schedule has not been reset through the Reset schedule button.

Interest calculation frequency field

Frequency: choose how often interest calculation should take place: daily, monthly, bimonthly, quarterly, semi-annually, or annually.

First calculation date: choose a date on which the first interest transaction will take place. This date has to be between the Begin date and End date of the LIT.

Calculate interest end of period: check this box for interest calculation to take place at the end of the period chosen in the Frequency field. If left unchecked, will start running the frequency period from the first calculation date. For example: if the chosen Frequency is monthly, and first calculation date is on November 12, and this box is checked, then the first period of interest calculation will end on November 30. If the box is unchecked, the first interest period will end on December 12.

Business day option: choose between:

Interest payment date schedule field

Use IPD schedule: lick this checkbox to enable use of an interest payment date schedule. Use of the IPD allows to users to add transactions dates to the LIT without affecting the amount of interest being calculated. Checking this box will also show the following options:

First calculation date: choose a date for the first interest payment date. This date has to be between the Begin date and End date of the LIT.
Frequency: choose the frequency of new interest payment dates after the first calculation date: daily, monthly, bimonthly, quarterly, semi-annually, or annually.

Pay interest end of period: check this box for interest payment dates to take place at the end of the period chosen in the Frequency field. If left unchecked, will start running the frequency period from the first calculation date.

Business day option: choose between:


Miscellaneous field
Some additional options a user can select to apply to all transactions generated by this LIT. None of these options are mandatory.

Sub transaction: choose a sub transaction type for all transactions generated by this LIT.

Contra account id: fill in a contra account ID number for all transactions generated by this LIT.

Reference prefix: fill in a prefix for all transactions generated by this LIT.

Calculations steps tab

This tab displays all the calculations that have taken place out for the calculated transactions on this Loan. All Grid functionalities are available on this screen.

Show append toggle: click to toggle calculations for any chosen date in the future. Using this function will not post any transactions to the Loan.

Ticket system

Ticket overview screen

To navigate the ticket overview screen click on the left tree menu node under tickets.

Users can view, submit, edit, and archive Tickets in this grid (and of course export the grid to Excel).


Add ticket – (Click on the + button as shown below, this takes the user to the create new ticket screen).


Show archived tickets button – (Toggles between hiding and showing tickets with status 'Archived').



Export grid button – (Exports the grid to an Excel file.)

Edit ticket button (pencil icon) – (Takes the user to the Edit ticket screen for the selected ticket).

Archive ticket – (Sets ticket status to 'Archived'. This is only possible for tickets that have the status 'Approved').


Create new ticket / Edit ticket screen

– (The user can fill in all fields in order to create a new ticket or edit fields on an existing ticket).

Subject – (The user can enter a subject title for their new ticket or edit it for an existing ticket).
Ticket type – (The user can choose one of the existing ticket types that have been created in the Ticket types screen).

Note: The user can enter notes of longer length (text character limit is very large) and use the presented tools for formatting the text inside the box.
Ticket fields box – (The user can fill in the fields defined by the Form assigned to the selected Ticket type. The assignment of Forms is done in the Forms screen).

Comments box – (Any user with access to tickets can leave a comment inside this box. Posted comments remain permanently attached to a ticket).

Document box - Users can upload files here. The files will be permanently linked to the ticket and stored in the company's DMS system.


There are four buttons in the top right screen:





Ticket types screen

Users can view, submit, edit, and archive Ticket types in this grid (and of course export the grid to Excel).

Add Ticket type by clicking on the + button – (takes the user to the create new ticket type screen).










Export grid button – (Exports the grid to an Excel file).

Edit Ticket type button (pencil icon) – (Takes the user to the Edit ticket screen for the selected ticket type).

Delete Ticket type button – (Deletes the selected ticket type).










Create new ticket type / Edit ticket type

User can fill in the following fields:



Checklist's screen


Users can view, submit, edit, and archive Checklists in this grid (and of course export the grid to Excel).


Add Checklist by clicking the + button – (takes the user to the create new checklist screen).

Export grid button – (Exports the grid to an Excel file).

Edit Checklist type button (pencil icon) – (Takes the user to the Edit ticket screen for the selected Checklist).

Delete Checklist type button – (Deletes the selected Checklist).

Create new ticket type / Edit ticket type

User can fill in the following fields:



Add a new item by clicking the Add item button.

Clicking the Save button in the top-right corner will take the user back to the Checklist overview.

Forms screen


Users can view, submit, edit, and archive Forms in this grid (and of course export the grid to Excel).

Add Checklist button – (Takes the user to the Create new Form screen).




Export grid button – (Exports the grid to an Excel file).
Edit Form type button (pencil icon) – (Takes the user to the Edit ticket screen for the selected Form).
Delete Form type button – (Deletes the selected Form).

Create new ticket type / Edit ticket type

User can fill in the following fields:




Clicking the Save button in the top-right corner will take the user back to the Checklist overview.