NetLoan - Commitment fees on lines of credit

Overview

A commitment fee charges the borrower for the part of a line of credit they haven't used. When commitment fees are enabled on a loan, NetLoan calculates the fee every period on the unused portion of the credit limit and accrues it to the schedule. It then bills the accrued amount at the frequency set on the loan.

Commitment fees are available on line of credit loans, both revolving and non-revolving. The way NetLoan measures the unused amount differs between the two:

Credit limit typeUnused amountHow the fee is calculated
RevolvingCredit limit minus the current loan balance. Repayments free up credit again.On the average daily unused amount for the period, once at period end.
Non-revolvingCredit limit minus the initial balance and all draws to date. Repayments don't free up credit.On each schedule line, so a draw's own line carries the fee up to that date.

The fee rate is an annual rate. It's applied using the loan's day count convention, the same way interest is.

Prerequisites

  • Line of Credit Loans is enabled on the System Features tab of NetLoan > NetLoan Setup > System Setup. Commitment fee fields are hidden on the loan type and loan until it's on.
  • Accounts and an item are set up for the commitment fee. See the setup steps below.

Step-by-step process

Set up the loan type

  1. Go to NetLoan > NetLoan Setup > Manage Loan Types and open the line of credit loan type.
  2. Check Enable Commitment Fee.
  3. Map these fields:
FieldDescription
Commitment Fee ItemThe item used for the commitment fee line on invoices (lender) and vendor bills (borrower). Map the item to the Commitment Fee Clearing Account. Billing fails with an error if this is blank.
Accrued Commitment Fee Receivable / PayableHolds the fee accrued each period until it's billed. It's a receivable for lender loans and a payable for borrower loans.
Commitment Fee Income / Expense AccountWhere the fee is recognized each period. It's income for lender loans and expense for borrower loans.
Commitment Fee Clearing AccountA clearing account between the accrual and the invoice or bill.
  1. Click Save.

Set up the loan

  1. Create the line of credit loan with the loan type and a Credit Limit. Enable Commitment Fee defaults from the loan type.
  2. Enter the Commitment Fee Rate, the annual rate charged on the unused amount.
  3. Select the Commitment Fee Payment Frequency: Monthly, Quarterly or Annually.
  4. Save, then generate the schedule and commence the loan as usual.

How commitment fees are billed

  • The fee accrues every period and is billed in arrears on the commitment fee frequency, counted in months from the loan's origination date. A Quarterly fee is billed every third period-end after origination, with three months of accrued fee on one invoice or bill.
  • The fee is billed by the normal billing run (Process Monthly Transactions or automated billing). It's added as a line on that period's invoice or bill, using the Commitment Fee Item.
  • After each billing date, the accrued balance starts again from zero.

Payoffs, refunds and refinances

  • Pay Off Remaining Balance: the payoff includes any accrued fee that hasn't been billed yet. It's shown read-only as Allocated to Commitment Fee on the modification and is billed with the payoff.
  • Refund (Full, or Principal and Fees): the refund includes commitment fees already billed. Any accrued fee that wasn't billed yet is reversed.
  • Refinance: accrued fee that hasn't been billed is moved to the new loan rather than billed on the old one.

Accounting

The table shows lender entries. Borrower entries use the same accounts with debits and credits swapped.

WhenDebitCredit
Each period, in the amortization journalAccrued Commitment Fee ReceivableCommitment Fee Income
Billing date, in the same journalCommitment Fee Clearing AccountAccrued Commitment Fee Receivable
Invoice from the billing runAccounts ReceivableCommitment Fee Clearing Account (through the Commitment Fee Item)

For borrower loans billed on vendor bills without billing items, the commitment fee line posts straight to the Commitment Fee Clearing Account.

Limitations / things to be aware of

  • The fee is calculated on the credit limit. A loan with no credit limit, or a balance at or above the limit, accrues no fee.
  • If the loan type doesn't have Enable Commitment Fee checked, the fields on a commenced loan stay hidden.
  • On a non-revolving line, repaying principal doesn't reduce the fee. Only the credit limit minus amounts drawn counts.

Related links


Was this article helpful?