Mortgage Payoff & Reconciliation

Consolidated Analytics, Inc.; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Consolidated Analytics, Inc. seeks a Real Estate Mortgage Payoff & Reconciliation SME to ensure accurate payoff calculations and daily reconciliations between closing agents and internal ledgers.

This role coordinates lien releases and escrow settlements to secure clear title transfers. Ideal candidates have 5+ years in mortgage servicing and strong Excel and accounting skills, with thorough attention to transaction security.

Qualifications

• Education in Accounting, Finance, Real Estate or related field.
• 5+ years in real estate mortgage servicing or related areas.
• Advanced Excel skills (VLOOKUP, pivot tables, data sorting).
• Strong numerical and analytical abilities; focus on transaction security.
• Excellent written and spoken communication.

Responsibilities

• Prepare payoff statements for real estate loans and track per-diem interest, escrow deficits, fees, and taxes.
• Process closing funds (wires, ACH, checks) and verify against statements.
• Initiate lien releases by submitting mortgage satisfaction documents to county recorders.
• Close escrow accounts with accurate tax/insurance payments and refunds.
• Execute daily cash reconciliations across transaction accounts and ledgers.
• Research and resolve closing breaks; balance ledger variances.
• Audit ledger lines to trace unapplied funds and correct misposted items.
• Post adjustments/entries for correct principal, interest, and escrow postings.

Skills

Excel expert

Mortgage servicing

Data analysis

Problem solving

Education

Accounting, Finance, Real Estate degree

Tools

Mortgage management systems

Job description

About this position

Consolidated Analytics | End-to-End Mortgage Solutions. Real Expertise. Real Results.

Consolidated Analytics is a data-driven mortgage solutions partner supporting the full life of the loan, from origination through servicing and capital markets. We combine asset-level intelligence with enterprise-scale solutions to power smarter decisions and measurable business outcomes. Our integrated capabilities span due diligence, residential and commercial valuation, collateral and risk analytics, process and technology optimization, and regulatory compliance, helping clients operate with clarity, agility, and confidence in a rapidly evolving market.

What sets us apart?

We bring together deep mortgage industry expertise, integrated technology, and a multidisciplinary workforce to help clients optimize quality, drive operational performance, and enhance decision-making at scale. Across the loan lifecycle, whether managing volume, acquiring assets in bulk, scaling originations, launching or expanding servicing, or navigating market and regulatory change, our teams deliver with clarity, compliance, and speed.

Core Services

• Mortgage Due Diligence
• Property Valuation + Analytics
• Mortgage Fulfillment (Origination and Servicing)
• Default Services (Claims, REO, Rental Management)
• Risk + Compliance Advisory
• Business Process Solutions (BPS)

Our Evolution

Over the past decade, we’ve strategically acquired and integrated best-in-class firms, including OpEXNOW, Equitable Mortgage Solutions, Carrington Property Services, and RealInfo into a unified platform designed to meet the demands of today’s dynamic market.

We’re not just a vendor, we’re a partner built for transformation.

Careers

We’re always hiring talented professionals who want to grow, lead, and win.

DESCRIPTION

The Real Estate Mortgage Payoff & Reconciliation SME handles the critical final phase of the residential and commercial real estate transaction cycle. This position ensures the flawless calculation and processing of real estate mortgage payoffs while executing daily transactional reconciliations between external closing escrow agents and internal accounting ledgers. The role acts as the primary financial operational bridge during property sales and refinances, reconciling wires, mitigating escrow breaks, and coordinating lien releases to secure clear title transfers for borrowers.

RESPONSIBILITIES

• Prepare and review official payoff statements for real estate loans, tracking per-diem interest, escrow deficits, recording fees, and property tax/insurance advances.
• Process incoming real estate closing funds (wires, ACH, certified checks) received from title insurance companies and closing attorneys, verifying them against outstanding statements.
• Initiate the lien release process by preparing and submitting satisfaction of mortgage documents to county recorders to grant clear property titles to buyers.
• Administer final escrow account closing procedures, including checking for active real estate tax/homeowners insurance payments, calculating surpluses, and issuing timely refunds.

Transactional Reconciliation & Risk Control

• Execute daily cash reconciliations across real estate transaction clearing accounts, mortgage suspense accounts, and general ledgers.
• Research and resolve closing breaks, such as payoff shortfalls or overages originating from real estate settlement statements.
• Audit ledger lines to trace unapplied closing funds, ensuring misdirected funds are promptly identified, coded, and matched.
• Post adjustments and journal entries to correct posting errors in principal, interest, and real estate escrow accounts in line with regulatory accounting standards.
• Partner with title closers and escrow officers to secure outstanding balances or return excess funds resulting from closing table timeline shifts.

Client & Stakeholder Support

• Respond to internal quality inquiries and escalations.
• Participate in client calibration sessions when required.
• Ensure consistent application of client-specific requirements.
• Maintain strong working relationships with production teams and stakeholders.

EDUCATIONAL QUALIFICATIONS & SKILLS

• Education: Degree in Accounting, Finance, Real Estate Business, or equivalent industry experience.
• Experience: 5+ years in real estate mortgage servicing, Real Estate Payoff & Closing Operations, Transactional Reconciliation & Risk Control, real estate accounting, or title/escrow closing operations.
• Technical Skills: Advanced Microsoft Excel capabilities (VLOOKUPs, pivot tables, data sorting) and experience with mortgage management systems.
• Competencies: High mathematical acuity, strict commitment to transaction security, and strong problem-solving skills for balancing ledger variances.
• Excellent communication skills (Written and Spoken)

Share this Job: