NetLoan - Reporting Overview
NetLoan Reporting
Overview & User Case:
NetLoan is bundled with an assortment of reports to support monthly reconciliations, financial reporting, disclosures, and loan administration.
Report List
| Name | Description | Category |
1 | General Ledger transaction search that provides the loan liability G/L balances through the selected period by loan. These balances should be compared against the NetLoan subledger at period-end to ensure all expected transactions and balances per the subledger have been properly reflected in the G/L. | G/L & Recon Report | |
2 | Netgain scripted transaction report that provides a summary of loan balances and rolls forward activities for the selected period range and provides details of originations, payments, interest and other activity. Expand loan types to drill down to underlying transaction detail. | G/L & Recon Report | |
3 | Reconciliation report to highlight end-of-period balances in the Loan Payment Payable Clearing Account by Loan. | G/L & Recon Report | |
4 | Reconciliation report to highlight end-of-period balances in the Loan Payment Receivable Clearing Account by Loan. | G/L & Recon Report | |
5 | Standard NetSuite search that provides a summary calculation of weighted average rate, which are a required footnote disclosure item (valid for single currencies only). Filter by the last full period being reported on. | G/L & Recon Report | |
6 | Weighted Average Term Calculation | Standard NetSuite search that provides a summary calculation of weighted average term, which are a required footnote disclosure item (valid for single currencies only). Filter by the last full period being reported on. | G/L & Recon Report |
7 | Cap. Orig. Fee GL to NetLoan Reconciliation | General Ledger transaction search that provides the Cap. Loan G/L balances through the selected period by loan. These balances should be compared against the NetLoan subledger at period-end to ensure all expected transactions and balances per the subledger have been properly reflected in the G/L. | G/L & Recon Report |
8 | Full subledger including all amortization booked and expected in the future. | Subledger Report | |
9 | Netgain scripted report that highlights the expected interest to be posted over time. This is expected to be used as a forward-looking report. | Subledger Report | |
10 | Netgain scripted report that highlights the expected payments to be posted over time. This is expected to be used as a forward-looking report. | Subledger Report | |
11 | Detailed subledger to provide amortization line details across all loan in the system across all periods. | Subledger Report | |
12 | Standard NetSuite saved search that provides a summarized view of loan and associated future payment amounts. This is expected to be used as a forward-looking report. | Subledger Report | |
13 | Loan Principal Waterfall Report | Netgain scripted report that highlights the expected principal to be paid down over time. This is expected to be used as a forward-looking report. | Subledger Report |
14 | Standard NetSuite search that provides a detail listing of loans and their maturity date. Filter by maturity date to find loans that mature during a certain interval. | Management Report | |
15 | A listing of all loans originated over the interval. | Management Report | |
16 | A listing of all scripts in NetLoan. | Admin Report | |
17 | A listing of all the script deployments in NetLoan. | Admin Report | |
18 | A listing of all script logs generated from NetLoan scripts. | Admin Report | |
19 | A listing of all the instances of NetLoan batch jobs that have been invoked and their status. | Admin Report |