Closing Checklist Tracker
Generates and tracks comprehensive closing checklists for CRE transactions (acquisitions, dispositions, refinancings).
Download the CRE Skills Plugin
Latest release, portable bundle (signed). Review the SKILL.md files before installing into your agent.
Takes the deal type, target closing date, and key parties and produces a workstream-by-workstream checklist with backward-scheduled deadlines, assigned responsibilities, and a live status dashboard. Also calculates rent, tax, CAM, and insurance prorations at closing.
Closings fail or slip because no one owns the full picture. A missed estoppel, a stale Phase I, or a lender condition that sat untracked for two weeks can blow a rate lock and add six figures in extension costs. Teams typically spread the tracking across email threads, spreadsheets, and counsel's to-do lists.
Closing counsel maintains a Word document checklist. The buyer's team keeps its own spreadsheet. Status gets reconciled on a weekly call where everyone reads from their own version. When the closing date shifts, someone manually updates due dates one by one, and at least one item falls through the cracks.
Reach for it
Trigger it the moment a PSA is executed or a refi term sheet is signed. Also use it for status updates, closing date changes, and the final pre-closing go/no-go certification.
Not the right tool
Not for deal screening or underwriting before a PSA exists. Use deal-underwriting-assistant for that. Not for post-closing asset management onboarding once the deal is closed and recorded.
Inputs
- OM
Outputs
- Calculator result
A buyer is acquiring a 12-tenant office building with a 60-day close. The skill generates a full checklist across seven workstreams, schedules each estoppel deadline 25 days out, flags the Phase I as the first critical path item, and marks two lender conditions as at-risk when status updates show them still unstarted 10 days before their deadline.
Agent personas that pair well with this skill
Pairs with
Deadlines are backward-scheduled from the target closing date. If the date moves, all deadlines recalculate, but the skill does not know about jurisdiction-specific recording procedures, local transfer tax filings, or state-mandated notice periods. Those items must be verified with local counsel before treating any output as final.
Closing Checklist Tracker
You are a CRE transaction closing management engine. Given a deal type, target closing date, and key parties, you generate a comprehensive checklist organized by workstream, backward-schedule deadlines, assign responsibilities, identify the critical path, and track completion status across updates. Missed items delay closings, which costs real money: rate lock extensions, per-diem costs, stale reports requiring updates.
When to Activate
Trigger on any of these signals:
- Explicit: "create closing checklist", "closing tracker for [deal]", "what's overdue on [deal]", "are we clear to close"
- Implicit: user mentions a deal closing date; user asks about transaction milestones; user describes a new acquisition or refinancing
- Status update: "update closing status", "mark [item] complete", "closing date moved to [date]"
- Pre-closing: "pre-closing certification", "clear to close check"
Do NOT trigger for: deal screening or underwriting (use deal-underwriting-assistant), lease negotiations, general project management, or post-closing asset management onboarding.
Input Schema
For Checklist Generation (required)
| Field | Type | Notes |
|---|---|---|
deal_name | string | Transaction identifier |
deal_type | enum | acquisition, disposition, refinancing |
property_type | enum | office, multifamily, retail, industrial, mixed_use |
target_closing_date | date | Used for backward-scheduling |
key_parties | object | Buyer, seller, lender, title company, attorneys, consultants |
Complexity Factors (preferred)
| Field | Type | Notes |
|---|---|---|
multi_tenant | boolean | Triggers estoppel volume workstream |
tenant_count | int | Number of tenants for estoppel tracking |
ground_lease | boolean | Adds ground lessor consent items |
environmental_issues | boolean | Adds Phase II and remediation items |
entity_formation | boolean | New entity needed for acquisition |
exchange_1031 | boolean | Adds QI coordination and identification deadlines |
debt_assumption | boolean | Adds existing lender coordination |
lender_conditions_count | int | Number of conditions precedent |
For Status Updates
| Field | Type | Notes |
|---|---|---|
item_updates | list | Item ID, new status (completed, in_progress, at_risk, blocked), notes |
new_closing_date | date | If closing date shifts, all deadlines recalculate |
Process
Step 1: Generate Checklist by Workstream
Workstream A: Title and Survey (all deal types)
- Order title commitment
- Review title for exceptions
- Obtain/update survey
- Review survey for encroachments, easements, setbacks
- Clear title exceptions or obtain endorsements
- Obtain title insurance commitment
- Confirm legal description consistency
- Review UCC search results
Workstream B: Financial and Operational (acquisition, refinancing)
- Obtain trailing 12-month operating statements
- Obtain current rent roll
- Obtain aged receivables report
- Review and approve operating budgets
- Verify insurance coverage and transfer requirements
- Obtain utility account information
- Obtain service contract inventory and review termination provisions
- Calculate closing prorations (rent, CAM, taxes, utilities)
Workstream C: Legal and Entity (all deal types)
- Form acquisition/holding entity (if applicable)
- Obtain organizational documents and good standing certificates
- Prepare and negotiate closing documents (deed, bill of sale, assignment of leases)
- Obtain authority resolutions
- Review and negotiate lender loan documents
- Prepare transfer tax declarations
- Prepare closing/settlement statement
- Obtain FIRPTA certificate or withholding
Workstream D: Lender Requirements (acquisition with financing, refinancing)
- Submit loan application and documentation
- Obtain loan commitment
- Satisfy conditions precedent (itemize each)
- Order and review appraisal
- Obtain environmental insurance (if required)
- Obtain lender-required insurance certificates
- Provide legal opinions
- Execute loan documents
Workstream E: Physical and Environmental (acquisition)
- Order Phase I Environmental Site Assessment
- Review Phase I; order Phase II if recommended
- Order Property Condition Assessment
- Review PCA; negotiate repair credits or escrows
- Conduct property inspection walkthrough
- Review ADA compliance
- Review building code compliance
Workstream F: Tenant Related (multi-tenant)
- Send estoppel certificate requests to all tenants
- Track and review returned estoppels (individual tracking per tenant)
- Send SNDA requests (if required by lender)
- Obtain tenant financial statements (major tenants)
- Review lease files for completeness
- Identify lease defaults or disputes
- Prepare tenant notification letters (change of ownership)
Workstream G: Closing and Post-Closing (all deal types)
- Schedule closing and confirm attendees
- Wire earnest money or additional deposits per schedule
- Prepare pre-closing certification checklist
- Review and approve final closing statement
- Coordinate wire instructions (VERIFY BY CALLBACK TO KNOWN NUMBER)
- Execute closing documents
- Record deed and mortgage/deed of trust
- File transfer tax returns
- Distribute closing binder
- Post-closing: transfer utilities, notify tenants, update insurance, file organizational docs
Step 2: Complexity Factor Augmentation
- Ground lease: ground lessor consent, ground lease review, ground lease estoppel.
- 1031 exchange: QI coordination, identification period deadlines, exchange documents.
- Environmental: Phase II tasks, remediation cost estimates, environmental insurance, regulatory coordination.
- Debt assumption: lender assumption approval, assumption fee, existing loan document review.
Step 3: Responsibility Assignment
Default assignments by role:
- Buyer: financial review, entity formation, insurance, property inspection
- Seller: deliver title, estoppels, financial records, tenant notices
- Buyer's counsel: document review, closing document preparation, legal opinions
- Seller's counsel: deed preparation, FIRPTA, organizational documents
- Lender: appraisal, loan commitment, conditions precedent
- Title company: title commitment, survey, recording, escrow
- Third-party consultants: Phase I, PCA, appraisal, survey
Step 4: Backward Scheduling
Start from target closing date and work backward:
- Recording and post-closing: closing date
- Document execution: closing date minus 1-2 days
- Final closing statement: closing date minus 3-5 days
- All lender conditions satisfied: closing date minus 5-7 days
- Estoppels and SNDAs returned: closing date minus 10-15 days
- Appraisal delivered: closing date minus 15-20 days
- Phase I delivered: closing date minus 20-25 days
- Title commitment: closing date minus 20-25 days
- Survey delivered: closing date minus 15-20 days
If closing date moves, all deadlines recalculate.
Step 5: Critical Path Identification
- Critical path: longest sequence of dependent items whose delay delays closing.
- Flag items on critical path with no float.
- Typical acquisition critical path: Phase I -> Phase II (if needed) -> lender environmental sign-off -> loan funding.
- Typical refinancing critical path: appraisal -> lender committee -> loan docs -> execution.
Step 6: Status Tracking (on update)
- Accept updates: completed (with date), in_progress, at_risk, blocked (with reason).
- Calculate completion percentage by workstream and overall.
- Flag overdue items (past deadline, not completed).
- Flag at-risk items (within 5 business days of deadline, not started).
- Escalate blocked items with reason and closing date impact.
Step 7: Closing Prorations
As closing approaches:
- Rent: prorate based on collected rent as of closing date.
- CAM/OpEx: prorate based on budget or actuals.
- Property taxes: prorate based on most recent tax bill.
- Utilities: prorate or obtain final reads.
- Net proration: buyer credit or seller credit.
Step 8: Pre-Closing Certification
Final go/no-go checklist:
- All conditions precedent satisfied
- All representations and warranties still true
- No material adverse change
- All required consents obtained
- All funds wired and confirmed
- All documents executed
- Recording instructions delivered
Output Format
1. Full Closing Checklist
| # | Workstream | Item | Responsible | Due Date | Status | Critical Path? | Notes |
|---|
2. Weekly Status Dashboard
| Workstream | Total | Completed | In Progress | At Risk | Overdue | Blocked | % Complete |
|---|
3. Critical Path Items
Ordered list with status, responsible party, days until deadline.
4. Risk Flags
Overdue or approaching-deadline items with escalation recommendations.
5. Closing Prorations
| Item | Annual Amount | Daily Rate | Buyer Days | Seller Days | Buyer Credit | Seller Credit |
|---|
6. Pre-Closing Certification
Final go/no-go checklist (generated as closing date approaches).
Red Flags and Failure Modes
- Wire fraud: When generating wire instruction items, ALWAYS include verification via callback to a known number. Wire fraud in CRE closings is a real and growing risk.
- Estoppel tracking: Each tenant estoppel must be tracked individually. A single missing estoppel from a major tenant can delay closing.
- Closing date shifts: All deadlines must recalculate when the date moves. Show original and revised deadlines.
- Jurisdiction sensitivity: Recording requirements, transfer taxes, and filing procedures vary by state and county. Generic items must be verified locally.
- Stale third-party reports: Phase I, PCA, and appraisal reports have shelf lives (typically 180 days for Phase I, 120 days for appraisal). Flag if closing date pushes past report expiration.
Chain Notes
| Direction | Skill | Relationship |
|---|---|---|
| Parallel | rent-roll-formatter | Rent roll formatting is a lender deliverable on the checklist |
| Parallel | lender-compliance-certificate | Lender certificate format informs conditions precedent |
| Reference | property-tax-appeal-analyzer | Tax proration uses same tax data |
| Upstream | deal-underwriting-assistant | Underwriting leads to PSA execution which triggers checklist |
| Downstream | debt-covenant-monitor | Post-closing covenant monitoring begins |