- Before
- Has three days to check a cycle of nearly five thousand analyses, and can open a few dozen by hand.
- Now
- Starts Monday with every analysis checked and the exceptions ranked by money at stake; drops a document on the curve and sees what it does to the low point.
One cycle, from generated to print file
Wrenfield Home Loan Servicing’s December cycle: 4,812 annual escrow analyses, new payments from 1 December, print file closing Wednesday at 17:00. Here is the Monday, screen by screen, in the working solution.
- 01Monday morning
The cycle, already checked
Renee Okafor · Escrow analysis leadRenee opens the solution to the December cycle: 4,812 analyses checked over the weekend against their bills and policies, 4,431 matching, 157 corrections already approved, 224 open — and the print file closing in 2 days 8 hours. The first account on screen is drawn as its year of balances, with the cushion line and the low point ringed.
“No shortage · $32.69 surplus stays in the account. 1 document disagrees with it.”
- 02One drop
Last year’s tax bill, caught
Renee Okafor · Escrow analysis leadAdaeze Okonkwo’s analysis in Katy, Texas carried the 2025 Fort Bend County bill, $8,367.80. The agents found the 2026 statement, certified 2 Oct: $9,012.48. Renee drops it on the curve, the year reruns, and the January low point falls to $1,592.08 against a cushion of $2,204.08.
“Shortage $612.00 — the analysis used last year’s bill.” New payment $2,837.24 (+$123.19), not $2,732.52 (+$18.47).
- 03Next account
Three wrong figures on the Marsh loan
Renee Okafor · Escrow analysis leadTeresa and Daniel Marsh, Bradenton, Florida. The system projected Seagrape Casualty’s $7,940.00 renewal offer; the Marshes moved to Tarpon Key Mutual at $6,215.00, paid from escrow 11 Aug. It projected the gross Manatee County tax, $7,388.00, though Wrenfield pays in November for 4% off: $7,092.48. And it carried the 2025 flood premium, $1,148.00, after a renewal at $1,354.60.
“The system said: shortage $2,534.32 · the notice would have asked for $597.84 too much.”
- 04The list
Every exception, by money at stake
Renee Okafor · Escrow analysis leadAnalyses lists the 381 exceptions by kind — insurance not the current policy 142, tax from last year’s bill 88, tax not as it will be paid 61, flood 37 — with what the system says, what the check says, and the difference a month. 263 would have overstated the payment; 118 understated it and would bring a shortage next year.
- 0547 seconds
The Marsh case, checked step by step
The six agentsRenee opens the case and starts the check. The analysis reader reads the system’s analysis and 11 deposits; the tax bill checker reads the proposed-tax notice; the insurance checker reads four policy documents; the escrow recomputer reruns the account; the rule checker tests nine Reg X rules; the explanation writer drafts the letter. Each difference comes with its documents.
“Finished in 47 s · 6 agents · 9 documents.”
- 06The proof
Every figure against its document
Tax bill and insurance checkersBills and policies puts what the system projects next to what is bound and paid: homeowners −$1,725.00, county tax −$295.52, flood +$206.60. The escrow history for the computation year sits underneath, with the flood renewal paid 9 Feb and the Tarpon Key premium paid 11 Aug.
The insurance checker never accepts a renewal offer as a renewal without a bound policy or a payment.
- 07Recomputed
The account, month by month
Escrow recomputerBy the aggregate method: the account starts 1 December with $507.20, must not fall below a cushion of $2,443.68 — one-sixth of the year — and reaches its low point in November 2027, after the county tax is paid. The shortage is $1,936.48, not $2,534.32, spread over 12 months at $161.37.
- 08Drafted
A letter the Marshes can read
Explanation writer312 words at reading grade 6.4, in English and Spanish. Their payment goes from $2,925.69 to $3,225.38 on 1 December. The letter shows each bill last year and this year — county tax +$450.24, home insurance +$1,003.00, flood +$206.60 — and both options: spread the shortage at $161.37 a month, or pay it now. Customer care gets the same numbers in a prepared answer.
- 09Approved
Renee approves, and the statement joins the print file
Renee Okafor · Escrow analysis leadRenee approves the correction and the letter: three differences, each with its document, and 8 of 11 checks passed — the other three are these differences. Under $250 a month, no second analyst is needed. The corrected analysis goes to the servicing system, and the statement and letter join Friday’s print file.
“Approved by Renee Okafor · corrected analysis sent to the servicing system · statement and letter in Friday’s print file.”
- 10Before release
Every rule, on the exam log
Colleen Vasquez · Escrow managerNine rules tested on every analysis — aggregate method, cushion within one-sixth, a 12-month computation year, tax and insurance as billed or paid, surplus refunds, shortage spreads, statements held in bankruptcy or 30+ days late. Colleen releases the print file once every exception is approved, held or sent back.