NetLoan - Standard Reports

NetLoan Reporting Configuration

Overview & User Case:

NetLoan is bundled with an assortment of reports to support monthly reconciliations, financial reporting, disclosures, and loan administration.

These reports provide practically all of the standard reports customers need to support required disclosures, as well as additional reports to support loan management and compliance with key loan terms.

Each of the included reports are briefly described below. Most reports rely on the custom fields within NetLoan and therefore do not require additional configuration after being loaded to your NetSuite account. Note however, that additional reports are dependent on GL accounts and therefore require customization. Reports details and customization steps are outlined in this section.

NETLOAN STANDARD REPORTS

Overview & User Case:

NetLoan comes packaged with an assortment of standard reports designed to meet most of your day-to-day needs relative to Loan Accounting and Administration. In addition to the standard reports loaded, NetLoan users may find the need to further customize and configure reporting to meet your specific needs.

The standard reports available are listed below with a short description.

Reconciliation & GL Reports: Reports designed to reconcile balances between the subledger (loan schedules tied to each record) and the general ledger, as well as details within each clearing account by each loan.

  • Loan Liability Subledger Reconciliation > Reconciliation support between the subledger and GL for all loan GL accounts
  • Capitalized Loan Origination Fee Subledger Reconciliation > Detailed reconciliation support between the subledger and GL for all loan GL accounts 
  • Loan Payment Clearing Account Reconciliation > Reconciliation report to highlight end-of-period balances in the Loan Liability Clearing Account by Loan
  • Loan Proceeds & Fees Clearing Account Reconciliation> Reconciliation report to highlight end-of-period balances in the Loan Proceeds & Fees Clearing Account by Loan 

Loan Subledger Reports: Reports designed to support required financial reporting and disclosures.

  • Loan Activity Details > Subledger search that sums payment and expense details across loans for the defined period range 
  • Amortization Schedule Details > Detailed subledger to provide amortization line items across all loans in the system
  • Subledger Period End Details > Asset & Liability balances for all loans at a defined period (must be filtered by a single period)
  • Loan Balance Roll-Forward Report  > Report that rolls historical loan balances forward from one period to the next, indicating beginning balances, additions, deletions, and other adjustments. This is a Netgain-scripted report bundled with NetLoan
  • Loan Future Waterfall Report  > Report that projects future loan payments period by period and thereafter for the defined period range. This is a Netgain-scripted report bundled with NetLoan
  • Undiscounted Loan Maturity Analysis >Detailed schedule of future payments to calculate undiscounted loan payments by quarter

Loan Administration & Disclosure Reports: To support management in reporting & disclosing of loan transactions and abstract data.

  • Loan Additions > Detailed listing of new loan additions for the selected period range
  • Loan Modifications > Detailed listing of loan modifications for the selected period range 
  • Loan Completions > Detailed listing of loans completed during the defined period
  • Loan Payments> Detailed listing of loan payments for the selected period range 
Was this article helpful?