NetLoan - As-of-Date Fields, Payoff, and Overdue Reporting
Overview
Every NetLoan loan can report its balances as of a specific date. Setting the As Of Date on a loan recalculates a set of management-summary fields - most importantly the Payoff Amount and the overdue balances - so you can answer "what's owed as of this date?" on the spot. The same fields can also be refreshed in bulk on a schedule. This is general NetLoan reporting that supports collections work but applies to any loan, whether or not the Collections module is enabled.
Prerequisites
- A commenced loan with a generated schedule.
- When calculating directly on the loan, a NetSuite role with access to the underlying records (especially payment records). Permissions are enforced for the on-loan calculation but not for the scheduled refresh (see Considerations).
- To have UI-entered as-of dates persist on the record, the global Allow UI As-Of Updates setting must be enabled (see Record Structure).
Step-by-Step
Navigation
- Record: Open the loan at NetLoan > Loan Management > Loan Register, then go to the Management subtab.
Get balances as of a date on the loan record
- Open the loan record and select the Management subtab.
- Set the As Of Date field to the date you need figures for.
- The management-summary fields recalculate for that date - including Payoff Amount, Loan Balance, Accrued Interest, and the overdue amounts (payments, principal, interest, fees).
- Read the Payoff Amount for the total needed to pay the loan off as of that date, or the overdue fields for delinquency figures.
This on-record calculation runs through a client script, so it executes under your role and respects your record permissions. If Allow UI As-Of Updates is enabled, the recalculated values save to the record; otherwise they display for the session and revert on save.
Refresh the fields daily with the scheduled script
To keep the as-of fields current across all loans without opening each one, the management-summary Map/Reduce script refreshes them on a schedule. Out of the box it runs nightly with the As Of Date set to the run date, so each morning every loan shows current payoff and overdue figures.
- Confirm the scheduled management-summary script is deployed and scheduled. See NetLoan - Collections Scripts and Scheduled Jobs for the script and scheduling details.
- Adjust the deployment's schedule if you need a different cadence than nightly.
- After it runs, the As Of Date and the management-summary fields on each loan reflect the run date.
Considerations
The Payoff Amount is calculated by the Statement Controller and differs by schedule type. For standard/precision loans it's the time-adjusted principal balance plus accrued interest through the as-of date, plus overdue and open invoice amounts, minus prepayments applied to future invoices and any fee forgiveness from early-maturity settings; if that comes out negative while a balance remains, it's floored to $0. For dynamic installment loans it's the loan balance from the last schedule line on or before the as-of date plus accrued interest calculated through the as-of date. The time of day used for the payoff comes from the loan type's Payoff Modification Time of Day setting, which defaults to End of Day.
Role permissions behave differently depending on how the fields are calculated. When you set the As Of Date directly on the loan, the client script runs under your role, so the running user's permissions to the queried records (such as payment records) are enforced - a role that can't see payments will produce too-high or otherwise wrong payoff and overdue amounts. When the fields are updated by the scheduled Map/Reduce script, those user permissions are not considered, so the bulk refresh isn't subject to the same gaps. If an on-loan figure looks wrong, check the running role's permissions first.
To validate a figure, review the Amortization Schedule sublist on the loan, and check the last schedule line on or before the as-of date - its loan balance and accumulated accrued interest are the two primary inputs. Payments apply to fees first, then interest, then principal.
Related Articles
Record Structure
NetLoan Loan - Management subtab
| Field Name | Field Type | Description | Example | Field ID |
|---|---|---|---|---|
| As Of Date | Date | The date to calculate balances for. Changing it recalculates the fields below. | 01/31/2026 | custrecord_da_loan_as_of_date |
| Payoff Amount | Currency | Total to pay the loan off as of the As Of Date. | 24,512.88 | custrecord_da_loan_payoff_amt |
| Loan Balance (As Of) | Currency | Principal balance as of the As Of Date. | 23,900.00 | custrecord_da_loan_as_of_balance |
| Accrued Interest (As Of) | Currency | Accumulated accrued interest through the As Of Date. | 312.88 | custrecord_da_loan_as_of_accum_accr_int |
| Deferred Accrued Interest (As Of) | Currency | Deferred accrued interest through the As Of Date. | 0.00 | custrecord_da_loan_as_of_def_accum_int |
| Overdue Payments (As Of) | Currency | Total overdue payment amount as of the As Of Date. | 1,200.00 | custrecord_da_loan_overdue_payments |
| Overdue Principal (As Of) | Currency | Overdue principal portion as of the As Of Date. | 900.00 | custrecord_da_loan_overdue_principal |
| Overdue Interest (As Of) | Currency | Overdue interest portion as of the As Of Date. | 280.00 | custrecord_da_loan_overdue_interest |
| Overdue Fees (As Of) | Currency | Overdue fee portion as of the As Of Date. | 20.00 | custrecord_da_loan_overdue_fees |
| Days Overdue | Integer | Number of days the loan is overdue (also set by the collections job). | 31 | custrecord_da_loan_days_overdue |
| Utilized Credit (As Of) | Currency | Drawn balance as of the As Of Date (lines of credit). | 23,900.00 | custrecord_da_loan_as_of_utilized_credit |
| Available Credit (As Of) | Currency | Undrawn balance as of the As Of Date (lines of credit). | 6,100.00 | custrecord_da_loan_as_of_avail_credit |
Related settings
| Field Name | Field Type | Description | Example | Field ID |
|---|---|---|---|---|
| Allow UI As-Of Updates | Checkbox | Global setting. When enabled, as-of values entered in the UI save to the loan; when disabled, they display for the session and revert on save. | Checked | custrecord_da_gbl_allow_ui_as_of_updates |
| Payoff Modification Time of Day | Select | Loan type setting controlling the time of day used in the payoff calculation. Defaults to End of Day. | End of Day | custrecord_da_type_payoff_remain_time |
