# 🏗️ Wholesaler's Command Center

---

## 1. Mission Control Dashboard
Your central operating hub. This page aggregates live data from your databases to visualize business health, deal velocity, and immediate action items.

### 📊 Business Health Snapshot
*Create a 3-column layout here. In each column, add a "Linked View" of the Deal Pipeline database with the specific configurations below.*

*   **Column 1: Active Pipeline**
    *   *View Type:* Board
    *   *Filter:* Status is not "Closed" and Status is not "Dead"
    *   *Group By:* Status
    *   *Purpose:* Visualize where every deal sits in the funnel.

*   **Column 2: Upcoming Tasks**
    *   *View Type:* List
    *   *Database:* Task & Activity Log
    *   *Filter:* Status is "Not Done" and Due Date is before or equal to "Tomorrow"
    *   *Sort:* Due Date (Ascending)
    *   *Purpose:* Never miss a follow-up or deadline.

*   **Column 3: Profit Analytics**
    *   *View Type:* Table
    *   *Database:* Deal Pipeline
    *   *Filter:* Status is "Closed"
    *   *Properties:* Address, Assignment Fee, Lead Source, Close Date
    *   *Purpose:* Track historical revenue and ROI per lead source.

### 📈 Key Performance Indicators (KPIs)
*Add these "Formula" properties to a dedicated "KPIs" database or simply calculate them manually in a "Callout" block if you prefer a static summary. For a premium system, we recommend a "Stats" database.*

*   **Total Potential Profit:** Sum of "Assignment Fee" (Status: Under Contract).
*   **Avg. Rehab to ARV Ratio:** (Sum of Rehab Estimate / Sum of ARV) for active deals.
*   **Deal Velocity:** Average days between "New Lead" and "Closed".

---

## 2. Deal Pipeline (CRM)
The heart of the system. Tracks the full lifecycle from lead to close, calculates MAO automatically, and manages buyer relations.

| Property Name | Type | Description/Options |
| :--- | :--- | :--- |
| **Address** | Title | Property Address. |
| **Status** | Select | `New Lead`, `Analyzing`, `Offer Sent`, `Under Contract`, `Closed`, `Dead`. |
| **Seller Name** | Text | Primary contact name. |
| **Phone** | Phone | Seller contact number. |
| **Lead Source** | Select | `Cold Call`, `Direct Mail`, `Driving for Dollars`, `PPC`, `Referral`, `Wholesaler`, `Bandit Signs`. |
| **ARV** | Number | After Repair Value (Currency). |
| **Rehab Estimate** | Rollup | Sum of "Estimated Cost" from **Rehab Estimator** DB. |
| **Wholesale Fee** | Number | Your target profit (Currency). |
| **Closing Costs** | Number | Fixed costs or % of ARV (Currency). |
| **Monthly Holding** | Number | Monthly carrying costs (Taxes, Insurance, Utilities) in $. |
| **Est. Hold Time** | Number | Estimated months to sell/assign. |
| **Total Holding Cost** | Formula | `prop("Monthly Holding") * prop("Est. Hold Time")` |
| **MAO** | Formula | See Logic Section 4. |
| **Assigned Buyer** | Relation | Link to **Cash Buyer Database**. |
| **Documents** | Relation | Link to **Document Vault**. |
| **Next Action** | Button | Label: "Add Task". Action: Edit page > Add block > "Task & Activity Log" linked view. |

> 💡 **Pro Tip:** Create a **Board View** grouped by "Status" to drag and drop deals through your pipeline. Create a **Gallery View** with a map embed to visualize territory coverage.

---

## 3. Rehab Estimator Database
Itemized scope of work linked to properties. Updates the CRM automatically.

| Property Name | Type | Description/Options |
| :--- | :--- | :--- |
| **Property** | Relation | Link to **Deal Pipeline**. |
| **Category** | Select | `Roof`, `Foundation`, `HVAC`, `Kitchen`, `Plumbing`, `Electrical`, `Cosmetic`, `Landscaping`. |
| **Item Description** | Text | Specifics (e.g., "Master Bath Tile"). |
| **Estimated Cost** | Number | Contractor quote (Currency). |
| **Actual Cost** | Number | Final invoice amount (Currency). |
| **Contractor** | Text | Vendor name. |
| **Status** | Select | `Pending`, `In Progress`, `Completed`. |

> 💡 **Pro Tip:** Create a **Table View** grouped by "Property" and then by "Category" to generate a professional PDF Scope of Work for your buyers.

---

## 4. Cash Buyer Database
Active buyers ready to take down contracts. Speed to contact is critical.

| Property Name | Type | Description/Options |
| :--- | :--- | :--- |
| **Buyer Name** | Title | Company or Investor Name. |
| **Buyer Type** | Select | `Rehabber`, `Landlord`, `Wholesaler`, `Buy & Hold`. |
| **Buy Box** | Multi-select | `SFR`, `Multi-Family`, `Distressed`, `Turnkey`, `High End`. |
| **Criteria** | Text | Specific area/bed/bath preferences. |
| **Email** | Email | Contact email. |
| **Phone** | Phone | Contact number. |
| **Last Contacted** | Date | Track engagement. |
| **Active Deals** | Rollup | Count of relations in **Deal Pipeline**. |

> 💡 **Pro Tip:** Use a **Gallery View** with buyer logos to quickly scan your list when you get a new property under contract.

---

## 5. Task & Activity Log
CRM essentials for tracking communication and ensuring no lead falls through the cracks.

| Property Name | Type | Description/Options |
| :--- | :--- | :--- |
| **Task Name** | Title | Description of action. |
| **Related Deal** | Relation | Link to **Deal Pipeline**. |
| **Type** | Select | `Call`, `Text`, `Email`, `Site Visit`, `Meeting`. |
| **Status** | Select | `Not Started`, `In Progress`, `Done`. |
| **Due Date** | Date | When to follow up. |
| **Notes** | Text | Call summary or outcome. |

---

## 6. Document Vault
Centralized repository for contracts and NDAs.

| Property Name | Type | Description/Options |
| :--- | :--- | :--- |
| **Document Name** | Title | e.g., "124 Maple - PSA". |
| **Related Deal** | Relation | Link to **Deal Pipeline**. |
| **Category** | Select | `Contract`, `Title Report`, `Inspection`, `Disclosure`. |
| **File** | Files | Upload PDF/Doc. |

---

## 7. MAO Calculator Logic (Premium)
The Maximum Allowable Offer (MAO) now includes **Holding Costs** for precision.

### Step 1: Calculate Total Holding Costs
Create a Formula property named `Total Holding Cost` in the **Deal Pipeline**:
```javascript
prop("Monthly Holding") * prop("Est. Hold Time")
```

### Step 2: Calculate MAO
Create a Formula property named `MAO` in the **Deal Pipeline**:
```javascript
if(prop("ARV") > 0, (prop("ARV") * 0.7) - prop("Rehab Estimate") - prop("Wholesale Fee") - prop("Closing Costs") - prop("Total Holding Cost"), 0)
```

---

## 8. Implementation Guide

1.  **Duplicate Structure:** Copy the tables above into Notion.
2.  **Convert to Databases:** Hover over each table full-width and select "Turn into Database".
3.  **Link Relations:**
    *   In **Rehab Estimator**, add Relation `Property` → **Deal Pipeline**.
    *   In **Deal Pipeline**, add Relation `Assigned Buyer` → **Cash Buyer Database**.
    *   In **Task & Activity Log**, add Relation `Related Deal` → **Deal Pipeline**.
    *   In **Document Vault**, add Relation `Related Deal` → **Deal Pipeline**.
4.  **Configure Rollups:**
    *   In **Deal Pipeline**, set `Rehab Estimate` to Rollup `Estimated Cost` (Sum) from **Rehab Estimator**.
5.  **Setup Views:** Create the Board, List, and Gallery views described in the "Mission Control" section.