NetLoan - Escrow tracking
Overview
NetLoan tracks escrow on a loan with Escrow Payment Due records. Each record holds the escrow amounts billed to the borrower and how often they are billed. When escrow billing runs, NetLoan creates a customer invoice for each record that is due, with one line for each escrow type that has an amount.
Each Escrow Payment Due record carries up to six escrow types:
| Escrow type | Billed with item set in NetLoan Setup |
|---|---|
| Escrow | Escrow Item |
| Insurance | Insurance Item |
| Taxes | Taxes Item |
| Initial Deposit | Initial Deposit Item |
| Adjustment | Adjustment Item |
| Special Assessments | Special Assessments Item |
Escrow is billed separately from loan billing. Escrow invoices are linked to the Escrow Payment Due record, not to the loan's payment schedule.
Prerequisites
- The Escrow checkbox is checked on the System Features tab of NetLoan > NetLoan Setup > System Setup.
- On the Escrow & Other Payments tab of the same page, an item is selected for each escrow type you bill. Escrow billing stops with an error if no escrow items are set.
How escrow tracking works
Recurring and one-time records
- A recurring record (any frequency other than One-Time) bills on its frequency, starting from its Effective Date. A loan has one recurring record in effect at a time.
- A one-time record bills once. It is billed in addition to the loan's recurring record, so a supplemental bill, special assessment, or initial deposit doesn't require changing the recurring amount.
Billing dates
- Next Bill Date is set by the system. It starts at the Effective Date and moves forward by the record's frequency each time the record bills. For one-time records it is cleared after billing.
- Last Billed Date shows the date of the most recent cycle billed.
- Total Amount is the sum of the six escrow amounts and updates automatically.
Changing escrow amounts
To change what a loan pays, create a new recurring record with a later Effective Date. Don't edit the existing one. The current record keeps billing until the new record's Effective Date, then stops and becomes inactive. Billing cycles before that date are still billed, so no periods are skipped.
Escrow totals on the loan
As of Date reporting fills in two fields on the loan record:
- Total Escrows Paid - customer payments applied to the loan's escrow invoices. Credit memo applications are not included.
- Total Escrows Overdue - the unpaid balance on escrow invoices that are past due. Credits do reduce this balance.
Step-by-step process: enter an escrow payment due
- Open the loan and go to the Escrow subtab.
- Click New Escrow Payment Due. A new record opens with the Loan filled in and the Effective Date set to the loan's next billing date.
- Review the Effective Date and change it if needed. This is the date the record starts billing.
- Select a Frequency. Choose One-Time to bill the amounts once, or a recurring frequency to bill them on that schedule.
- Enter an amount for each escrow type you want to bill. Leave the others blank. Total Amount updates as you type.
- Optionally, change the Name. It fills in automatically from the loan and Effective Date.
- Click Save.
- If the loan already has a recurring record, NetLoan asks you to confirm that the new record takes over on its Effective Date.
- If every amount is zero or blank, NetLoan asks you to confirm. A record with a zero total stops escrow billing on the loan from its Effective Date onward.
The record is billed the next time escrow billing runs for a period that includes its Next Bill Date.
Updating escrow on many loans at once
Use the Bulk Escrow Update page to enter new escrow amounts for several loans in one step. It creates a new Escrow Payment Due record for each loan, filled in from the recurring record already in effect.
How escrow is billed
Escrow billing runs in two ways:
- Automated job. The escrow billing automated job bills every record due up to the period end. If Run All Months Up To And Including is unchecked, it bills only records whose Next Bill Date falls in the selected period.
- Monthly processing. When invoices are billed from NetLoan Monthly Journal Processing, escrow is billed in the same run. Use View Escrow Billing on the processing record to open the matching escrow run.
Each run bills one cycle per record. A record several cycles behind needs one run per cycle to catch up.
Reversing an escrow billing run deletes its invoices and moves Next Bill Date back to the earliest cycle that was reversed, so those cycles are billed again on the next run.
Limitations / things to be aware of
Some fields can't be changed after saving
Loan, Frequency and Effective Date are locked once the record is saved. Once the record has billed, its amounts are locked too. To make a change after that, create a new record.
Recurring records can't be back-dated
A recurring record can't take effect on or before the date escrow has already been billed through on the loan, because those periods would be billed twice. To bill a charge in a period that has already been billed, use a One-Time record.
- A loan can have only one active recurring record per Effective Date. You can add as many one-time records as you need.
- Escrow invoices aren't linked to a loan through the invoice's Loan field. Saved searches or reports that join invoices to loans that way will not include escrow invoices.
- If Run All Months Up To And Including is unchecked, a record due before the period start isn't billed by that run or by later runs for later periods. Check it, or run the earlier period, to catch the record up.
