closing-checklist-tracker

Name: closing-checklist-tracker
Author: mariourquia

36stars12forks

How to install closing-checklist-tracker?

mariourquia/cre-skills-plugin/closing-checklist-tracker

$npx -y skills add mariourquia/cre-skills-plugin --skill closing-checklist-tracker

Installs into the current project.

Summary

Generates and tracks comprehensive closing checklists for CRE transactions (acquisitions, dispositions, refinancings). Backward-schedules deadlines from closing date, assigns responsibilities, identifies critical path, and tracks completion status.

Files · 1

View on GitHub

SKILL.md

1	# Closing Checklist Tracker
2
3	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.
4
5	## When to Activate
6
7	Trigger on any of these signals:
8
9	- Explicit: "create closing checklist", "closing tracker for [deal]", "what's overdue on [deal]", "are we clear to close"
10	- Implicit: user mentions a deal closing date; user asks about transaction milestones; user describes a new acquisition or refinancing
11	- Status update: "update closing status", "mark [item] complete", "closing date moved to [date]"
12	- Pre-closing: "pre-closing certification", "clear to close check"
13
14	Do NOT trigger for: deal screening or underwriting (use deal-underwriting-assistant), lease negotiations, general project management, or post-closing asset management onboarding.
15
16	## Input Schema
17
18	### For Checklist Generation (required)
19
20	\| Field \| Type \| Notes \|
21	\|---\|---\|---\|
22	\| `deal_name` \| string \| Transaction identifier \|
23	\| `deal_type` \| enum \| acquisition, disposition, refinancing \|
24	\| `property_type` \| enum \| office, multifamily, retail, industrial, mixed_use \|
25	\| `target_closing_date` \| date \| Used for backward-scheduling \|
26	\| `key_parties` \| object \| Buyer, seller, lender, title company, attorneys, consultants \|
27
28	### Complexity Factors (preferred)
29
30	\| Field \| Type \| Notes \|
31	\|---\|---\|---\|
32	\| `multi_tenant` \| boolean \| Triggers estoppel volume workstream \|
33	\| `tenant_count` \| int \| Number of tenants for estoppel tracking \|
34	\| `ground_lease` \| boolean \| Adds ground lessor consent items \|
35	\| `environmental_issues` \| boolean \| Adds Phase II and remediation items \|
36	\| `entity_formation` \| boolean \| New entity needed for acquisition \|
37	\| `exchange_1031` \| boolean \| Adds QI coordination and identification deadlines \|
38	\| `debt_assumption` \| boolean \| Adds existing lender coordination \|
39	\| `lender_conditions_count` \| int \| Number of conditions precedent \|
40
41	### For Status Updates
42
43	\| Field \| Type \| Notes \|
44	\|---\|---\|---\|
45	\| `item_updates` \| list \| Item ID, new status (completed, in_progress, at_risk, blocked), notes \|
46	\| `new_closing_date` \| date \| If closing date shifts, all deadlines recalculate \|
47
48	## Process
49
50	### Step 1: Generate Checklist by Workstream
51
52	Workstream A: Title and Survey (all deal types)
53	- Order title commitment
54	- Review title for exceptions
55	- Obtain/update survey
56	- Review survey for encroachments, easements, setbacks
57	- Clear title exceptions or obtain endorsements
58	- Obtain title insurance commitment
59	- Confirm legal description consistency
60	- Review UCC search results
61
62	Workstream B: Financial and Operational (acquisition, refinancing)
63	- Obtain trailing 12-month operating statements
64	- Obtain current rent roll
65	- Obtain aged receivables report
66	- Review and approve operating budgets
67	- Verify insurance coverage and transfer requirements
68	- Obtain utility account information
69	- Obtain service contract inventory and review termination provisions
70	- Calculate closing prorations (rent, CAM, taxes, utilities)
71
72	Workstream C: Legal and Entity (all deal types)
73	- Form acquisition/holding entity (if applicable)
74	- Obtain organizational documents and good standing certificates
75	- Prepare and negotiate closing documents (deed, bill of sale, assignment of leases)
76	- Obtain authority resolutions
77	- Review and negotiate lender loan documents
78	- Prepare transfer tax declarations
79	- Prepare closing/settlement statement
80	- Obtain FIRPTA certificate or withholding
81
82	Workstream D: Lender Requirements (acquisition with financing, refinancing)
83	- Submit loan application and documentation
84	- Obtain loan commitment
85	- Satisfy conditions precedent (itemize each)
86	- Order and review appraisal
87	- Obtain environmental insurance (if required)
88	- Obtain lender-required insurance certificates
89	- Provide legal opinions
90	- Execute loan documents
91
92	Workstream E: Physical and Environmental (acquisition)
93	- Order Phase I Environmental Site Assessment
94	- Review Phase I; order Phase II if recommended
95	- Order Property Condition Assessment
96	- Review PCA; negotiate repair credits or escrows
97	- Conduct property inspection walkthrough
98	- Review ADA compliance
99	- Review building code compliance
100
101	Workstream F: Tenant Related (multi-tenant)
102	- Send estoppel certificate requests to all tenants
103	- Track and review returned estoppels

People who liked this also viewed

6 picks

Type

closing-checklist-tracker

36stars12forks

View on GitHub

How to install closing-checklist-tracker?

mariourquia/cre-skills-plugin/closing-checklist-tracker

$npx -y skills add mariourquia/cre-skills-plugin --skill closing-checklist-tracker

Installs into the current project.

Summary

Files · 1

View on GitHub

SKILL.md

1	# Closing Checklist Tracker
2
3	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.
4
5	## When to Activate
6
7	Trigger on any of these signals:
8
9	- Explicit: "create closing checklist", "closing tracker for [deal]", "what's overdue on [deal]", "are we clear to close"
10	- Implicit: user mentions a deal closing date; user asks about transaction milestones; user describes a new acquisition or refinancing
11	- Status update: "update closing status", "mark [item] complete", "closing date moved to [date]"
12	- Pre-closing: "pre-closing certification", "clear to close check"
13
14	Do NOT trigger for: deal screening or underwriting (use deal-underwriting-assistant), lease negotiations, general project management, or post-closing asset management onboarding.
15
16	## Input Schema
17
18	### For Checklist Generation (required)
19
20	\| Field \| Type \| Notes \|
21	\|---\|---\|---\|
22	\| `deal_name` \| string \| Transaction identifier \|
23	\| `deal_type` \| enum \| acquisition, disposition, refinancing \|
24	\| `property_type` \| enum \| office, multifamily, retail, industrial, mixed_use \|
25	\| `target_closing_date` \| date \| Used for backward-scheduling \|
26	\| `key_parties` \| object \| Buyer, seller, lender, title company, attorneys, consultants \|
27
28	### Complexity Factors (preferred)
29
30	\| Field \| Type \| Notes \|
31	\|---\|---\|---\|
32	\| `multi_tenant` \| boolean \| Triggers estoppel volume workstream \|
33	\| `tenant_count` \| int \| Number of tenants for estoppel tracking \|
34	\| `ground_lease` \| boolean \| Adds ground lessor consent items \|
35	\| `environmental_issues` \| boolean \| Adds Phase II and remediation items \|
36	\| `entity_formation` \| boolean \| New entity needed for acquisition \|
37	\| `exchange_1031` \| boolean \| Adds QI coordination and identification deadlines \|
38	\| `debt_assumption` \| boolean \| Adds existing lender coordination \|
39	\| `lender_conditions_count` \| int \| Number of conditions precedent \|
40
41	### For Status Updates
42
43	\| Field \| Type \| Notes \|
44	\|---\|---\|---\|
45	\| `item_updates` \| list \| Item ID, new status (completed, in_progress, at_risk, blocked), notes \|
46	\| `new_closing_date` \| date \| If closing date shifts, all deadlines recalculate \|
47
48	## Process
49
50	### Step 1: Generate Checklist by Workstream
51
52	Workstream A: Title and Survey (all deal types)
53	- Order title commitment
54	- Review title for exceptions
55	- Obtain/update survey
56	- Review survey for encroachments, easements, setbacks
57	- Clear title exceptions or obtain endorsements
58	- Obtain title insurance commitment
59	- Confirm legal description consistency
60	- Review UCC search results
61
62	Workstream B: Financial and Operational (acquisition, refinancing)
63	- Obtain trailing 12-month operating statements
64	- Obtain current rent roll
65	- Obtain aged receivables report
66	- Review and approve operating budgets
67	- Verify insurance coverage and transfer requirements
68	- Obtain utility account information
69	- Obtain service contract inventory and review termination provisions
70	- Calculate closing prorations (rent, CAM, taxes, utilities)
71
72	Workstream C: Legal and Entity (all deal types)
73	- Form acquisition/holding entity (if applicable)
74	- Obtain organizational documents and good standing certificates
75	- Prepare and negotiate closing documents (deed, bill of sale, assignment of leases)
76	- Obtain authority resolutions
77	- Review and negotiate lender loan documents
78	- Prepare transfer tax declarations
79	- Prepare closing/settlement statement
80	- Obtain FIRPTA certificate or withholding
81
82	Workstream D: Lender Requirements (acquisition with financing, refinancing)
83	- Submit loan application and documentation
84	- Obtain loan commitment
85	- Satisfy conditions precedent (itemize each)
86	- Order and review appraisal
87	- Obtain environmental insurance (if required)
88	- Obtain lender-required insurance certificates
89	- Provide legal opinions
90	- Execute loan documents
91
92	Workstream E: Physical and Environmental (acquisition)
93	- Order Phase I Environmental Site Assessment
94	- Review Phase I; order Phase II if recommended
95	- Order Property Condition Assessment
96	- Review PCA; negotiate repair credits or escrows
97	- Conduct property inspection walkthrough
98	- Review ADA compliance
99	- Review building code compliance
100
101	Workstream F: Tenant Related (multi-tenant)
102	- Send estoppel certificate requests to all tenants
103	- Track and review returned estoppels

People who liked this also viewed

6 picks

Type