Support Center

Loan Fees Setup

Last Updated: Sep 25, 2018 03:19PM CEST

--------------------------------------------------------------------------------- Back to top

Setting Up a New Fee

There are different types of fees that can be applied to both loan and deposit accounts after being created or activated under each product.

To set up a new fee:

  1. Go to the "Product Fees" section in the Loan Product setup screen (New / Edit).
  2. Click on "Add Fee".
  3. Type the Fee Name - this is the name with which the fee will be shown in different screens (when applying to the account, when reporting, in the account statements etc.).
  4. Select the Fee Type - see more details about each fee type below.
  5. Define how the Fee Amount will be calculated - either as a fixed amount or a % (the available calculation options will differ depending on the Fee Type)
  6. Select if the fee is Optional or Required (only available for certain fee )
  7. Select the specific GL accounts (only if accounting is enabled, and if applicable)

After being applied to an account, fees will be paid according to the allocation order defined for that product.

--------------------------------------------------------------------------------- Back to top

Deactivating / Reactivating a Fee

If a fee is not applicable anymore, you can deactivate it by: click on the small green dot > Save Changes.  
When the fee is deactivated, this dot will turn from green to grey.


To reactivate a fee, follow the same procedure: click on the grey dot, then save changes. 

--------------------------------------------------------------------------------- Back to top

Deleting a Fee

Fees can be deleted only if they haven't been used (i.e. never applied in any account). This option is only available for specific cases when a fee was created by mistake and should be used with care.

To delete a fee click on the red "Delete" button > Save Changes

If the fee has already been used and you try to delete it, Mambu will show you a warning message preventing you from doing so. In that case, you should deactivate the fee and it won't be applied to any other accounts created under that product.

 

--------------------------------------------------------------------------------- Back to top

Manual Fees

Manual Fees can be applied at any point in time to a loan account - their trigger is manual, i.e. whenever the user needs to apply the fee. This type of fee applies when the event that triggers a fee application cannot be planned / predicted - for example: bounced cheques, lost cards, additional administration fee due to specific documents that had to be prepared, etc.

For Manual Fees the available calculation options are:

  • Flat amount - can be set to a fixed amount if the fee amount is the same for all loans in this product or left empty, in which case the user can enter the applicable fee amount on a case by case basis.
  • % of Disbursement Amount - calculated as a % of the approved loan amount.

--------------------------------------------------------------------------------- Back to top

Deducted Disbursement Fees

As the name suggests, this type of fee will be deducted from the approved principal amount at disbursement, i.e.: the client receives less money as actual disbursement, but still has to repay the full loan amount by the end of the loan term; this means that the fee will be effectively "paid" upfront. 

For Deducted Disbursement fees the available calculation options are:

  • Flat amount - can be set to a fixed amount if the fee amount is the same for all loans in this product or left empty, in which case the user can enter the applicable fee amount on a case by case basis (for example, in case the fee amount is calculated based on a very specific formula or logic that Mambu doesn't automatically replicate);
  • % of Disbursed Amount - calculated as a % of the approved loan amount

Additionally, disbursement fees can be either Required or Optional - the required fees will be applied to all loans disbursed in this product, while the optional fees can be selected by the user to be applied or not at disbursement.

 Any additional fees added on the account which have a calculation based on % of disbursed amount will be calculated based on the sum of loan amount and deducted disbursement fee amount.
For example:
Loan amount = $1,000
Deducted Disbursement Fee = $100 => disbursed amount = $900
Manual fee as 10% of disbursed amount = $100  =>  ($900 + $100) *10% = $100


--------------------------------------------------------------------------------- Back to top

Capitalized Disbursement Fees

As the name suggests, this type of fee will be added to the approved principal amount at disbursement, i.e.: the client receives the approved amount as actual disbursement, but has to repay a higher amount, including the loan fees, by the end of the loan term. Thus, the fees are effectively "paid" upfront but financed by the lender. 

Capitalized Disbursement Fees are identical to the Deducted Disbursement fees in all other respects - same fee amount calculation options, as well as the "required / optional" feature, are available.

 
 
Any additional fees added on the account which have a calculation based on % of disbursed amount will be calculated based on the sum of loan amount and capitalized disbursement fee amount.
For example:
Loan amount = $1,000
Capitalized Fee = $100
Manual fee as 10% of disbursed amount = $110  =>  ($1,000 + $100) *10% = $110


--------------------------------------------------------------------------------- Back to top

Upfront Disbursement

As the name suggests, the Upfront Disbursement will be applied on the account as a “Fee” transaction, immediately after the account is disbursed and will be paid with one of the future payments. It can be selected when defining the Disbursement Details for a loan or when performing the disbursement.

Fixed Term Loans and Payment Plans will have the upfront fees automatically allocated on the first due installment and then can be changed by the users when editing the schedule. Dynamic Term and Tranched Loans will have the fee marked as due immediately.

Upfront Disbursement fees can’t be reversed by themselves, but they will be automatically reversed when the disbursement is undone. 

--------------------------------------------------------------------------------- Back to top

Late Repayment Fees

Late Repayment Fees will be applied any time the client misses an installment and is set to "Late" status in the schedule. 

For Late Repayment Fees the available calculation options are:

  • Flat amount - can be set to a fixed amount if the fee amount is the same for all loans in this product; since this fee is applied to all payments in the schedule in advance, it can't be left empty and specified on a case by case basis;
  • % of Disbursement Amount - calculated as a % of the approved loan amount
  • % of Repayment Principal Amount - calculated as a % of the principal amount that was expected with the installment that was missed 

Note: when triggered, the Late Payment Fee will respect the arrears tolerance period defined for that product. E.g. if there is a tolerance period of 2 days, the Late Payment Fee will only be applied to the account 2 days after the due date of the installment. 

--------------------------------------------------------------------------------- Back to top

Payment Due Fees

The specificity of these fees is that they are calculated in advance and added to the loan's repayment schedule, along with the interest and principal due with each installment. 

For Payment Due Fees the available calculation options are:

  • Flat amount - can be set to a fixed amount if the fee amount is the same for all loans in this product; since this fee is applied to all payments in the schedule in advance, it can't be left empty and specified on a case by case basis;
  • Flat ($) / Num of Installments - when the loan is disbursed, the fee will be charged on each installment based on the formula:
    • the flat amount of the payment due fee divided by the number of installments
  • % of Disbursement Amount - calculated as a % of the approved loan amount
  • % of Disbursement Amount / Num of Installments - when the loan is disbursed, the fee will be charged for each installment, calculated as % of the approved loan amount divided by number of installments

 Additionally, payment due fee can be either Required or Optional - the required fees will be applied to all loans disbursed in this product, while the optional fees can be selected by the user to be applied or not at disbursement.


---------------------------------------------------------------------------------Back to top

Arbitrary Fees

These are fees which can be applied manually to the accounts at any point during the accounts' lifetime and with any given amount. By default this option is not checked when creating a new product, so if you will need to apply arbitrary fees to the accounts under that product you should check the "Allow Arbitrary Fees" box.


The difference between a Manual and an Arbitrary Fee is is that a Manual Fee is pre-defined (i.e. it has a pre-set name and amount that the user can't change when applying the fee). An arbitrary fee is completely flexible - no predefined name and/or amount, up to the user to input when applying such a fee onto the account. 

Arbitrary fees should be used with caution. We recommend setting Manual Fees for more granular reporting and control. 

--------------------------------------------------------------------------------- Back to top

Fee Amortization

Fee amortisation is available for recognising up-front fees over the whole lifecycle of the loan. This option only becomes available only if “Accrual Accounting” is selected in the “Accounting Rules” section.
 
There are 3 calculation methods (“Amortisation Profiles”) available:
  • Sum-of-Year Digits - a declining balance amortisation that uses the number of installments and the sum of number of installments to calculate the amortisation rate. This method is available for Deducted Fees.
  • Straight Line - A flat amortisation method that equally divides the fee over the loan term. This method has a custom amortisation frequency that can be defined for custom intervals or full term of the loan for manual fees (see the attached files from the bottom) and account installments due dates amortisation frequency which is available for Deducted, Capitalised and Manual Fees.
  • Effective Interest Rate - A declining balance amortisation profile that uses the schedule periodic payment and interest rate to calculate the amortisation rate. This method is available for all types of predefined Fees.
    • When selecting EIR method you have the option to choose amortisation frequency. To custom define the term select "Custom Interval" under "Amortization Frequency". You can define the frequency (in days, weeks, months, years) and over how many intervals the EIR is amortised. Mambu will apply the EIR calculation based on the Frequency and Period selected.
    • For Capitalised Disbursement, Deducted Disbursement and Payment due fee types, there is an additional option for amortisation frequency: "Account Installments Due Dates (Daily Booking)" and the calculation for this frequency is still based on the repayment frequency, however the accounting booking is performed daily.


For Manual, Deducted Disbursement, Capitalised Disbursement, Upfront Disbusement with Straight Line or Effective Interest Rate amortization method and amortisation frequency Account Installments on Due Dates or Account Installments Due Dates (Daily Booking) it will be possible to choose if the amortisation will end on the original account or if the amortisation will continue on the Rescheduled or Refinanced account.

The newly added Fee Amortisation upon Reschedule/Refinance drop-down menu will have as default value End Amortisation on the Original Account and it will be possible to reschedule or refinance the account with any product, regardless of the product setup.

The default option can be changed with Continue the Amortisation on the Rescheduled/Refinanced account. This option implies that the Reschedule or Refinance has to be done with the same product.

For detailed examples of these methods and calculation formulas, we recommend checking the supporting file "Amortization_Profiles.xlsx" at the bottom of this article.

 In V6 version, we've changed the way we are calculating the Effective Interest Rate amortisation method for payment due fees only: when calculating the IRR step, we are using the principal balance as IRR input and we add the fee amount to the PMT for each installment. See "Amortization_payment_due_fees" at the bottom of this article.

How it works:  
When the account is disbursed, Mambu will book the fee as Deferred Fee Income (liability)
DR Portfolio Control
CR Deferred Fee Income
CR Deferred Taxes (if applicable)
 
Then on each installment due date, a part of the amount (determined by the amortization profile) will recognise the deferred amount as actual fee income, generating an additional Journal Entry as follows:
 
DR Deferred Fee Income / DR Deferred Taxes (if applicable)
CR Fee Income / CR Taxes Payable (if applicable)
 
If the loan is Paid Off (settled/ closed early), the remaining fees that are not yet amortised will be booked in accounting as income (same entry as above).
 
The Amortisation Profile cannot be changed for the fees that are in use.
 
Reversing the disbursement (and the disbursement fees) will also reverse the deferred income and amortisation journal entries, posted in accounting.

If Fee amortisation is enabled, a Deferred Fee Income GL account has to be specified - this can be either a specific GL account for each fee or one generic account for all fees, if specified in the “Accounting Links” section.

--------------------------------------------------------------------------------- Back to top

Accounting for Loan Fees

If accounting is enabled for the Loan Product, the Fee Setup screen allows you to link each fee to specific GL accounts for accounting purposes, as well as defining fee amortisation profiles for some fees. These are explained in more details in a separate article - please visit Fees Accounting

--------------------------------------------------------------------------------- Back to top

support@mambu.com
http://assets3.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete