LSR Data Entry — Renu Anand & Associates

Green fields = your variable inputs (same as green cells in LSR_DATA_ENTRY.xlsx). Everything downstream auto-fills but remains editable.

Report Header

Bank / Format

Ref. No.

Report Date

Place

Addressee (branch block)

Advocate letterhead

Property & Loan (green inputs)

Property Details — full description (M_1)

State

Property Type

Property Category

Type of Loan

Kind of Seller

Type of Property

Ownership

If Leasehold — Authority

RERA project?

Prior mortgage exists?

Name of Bank (prior mortgage)

Property built by

Present owner(s) / title holder (M_11)Separate multiple owners with commas — count auto-detected.

Proposed Mortgagor / Borrower (M_12)

Search details (M_15)

Search period (from – to)

If joint names — share identified?

Property Description Table (Item / Survey / Extent / Location / Boundary)

Survey / Khata / House / Site No.

Extent / Area

Location (Sub-District / Village / Municipality)

Boundary East

West

North

South

These replicate your Excel formulas (white cells). Auto-filled from Tab 1 — edit anything freely. Press Recompute after changing Tab 1 inputs (your manual edits will be overwritten).

Derived answers (M-fields)

Build the chain of title once — it feeds (a) the Documents Scrutinized table, (b) auto-drafted Recitals, and (c) the Documents to be deposited for EM list. Use structured rows for auto-drafting, or paste free text per row.

Date

Document

Executed / Issued by

In favour of / In name of

In respect of (property)

Reg no · Book · Vol · Pages · Reg date · SR office

Status

Status options: Original / Photocopy / Certified Copy / Photocopy & Certified Copy / True Copy. "In respect of" defaults to Property Details (M_1) if left blank.

Brief history of the property ("Whereas…" clauses). Auto-generate from the chain, paste your own, edit freely, or leave blank.

Opening recital (colony / developer / allotment history — optional)

Chain recitals

Closing recital ("Now, …")

List of documents required to be deposited for creation of Equitable Mortgage. Auto-pulled from chain (edit status per document), tick standard items, add custom lines, or leave blank.

From chain of title

✓

Document

Date

Deposit as

Standard items

Custom / pasted items (one per line)

Final step. Export the case file and send it to the Advocate (email / WhatsApp / office shared folder). Report generation is done only on the Advocate's system.

Export

Submit sends the case directly to the Advocate's Generator inbox. If Submit fails (offline / local file), use Export Case File and send it manually. Also press 💾 Save Case (Tab 1) to keep a copy on this computer.

Checklist before export: ✔ Case Data complete ✔ Computed answers reviewed ✔ Chain of title entered ✔ Recitals generated/checked ✔ EM documents pulled from chain.