NetLoan - Loan Balance Roll Forward Report
Purpose
This report 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.
How To
Navigation:
NetLease > Reports (All or GL & Recon) > Loan Balance Roll Forward Report > Run
Filtering:
The report search can be narrowed down by adjusting the filters for subsidiary, department, class, location, accounting period, or date. Once desired filters are set, click preview to view the reconciliation.
Results
Upon running the report the user will see the beginning balance of each loan account and the related roll forward activities for the period by loan type. The loan types can be expanded to drill down to the individual lease and underlying transactions. Select the export button to download report into Excel.
Troubleshooting
Unable to reconcile the "Other Activities" column?
1. The "Other Activities" column within the report represent the modifications that have been made to the loan.