Sign in to continue
Set a password to finish setting up your account.
Connect your Supabase project
Paste the two values from your Supabase dashboard. Only needs to be done once — the app will remember them on this computer.
Example:
https://your-project.supabase.coIn Supabase: Project Settings → API Keys → copy the default Publishable key. Do not use the Secret key.
Sales Department
▾
Sales Department Home
All Leads
DTS Plecto
Leads Deep Dive
Self-Report Entries
Self-Report Dashboards
Dashboards
Dispo
🚨 Missed Opp Warning
Inbound Responses
Internal Marketing
JV Department
Transactions
Properties & Loans
Inventory ▾
Inventory
REO
Full REO
Deal Analyzer
Mgmt
▾
Lead Goals and Budget
Current Campaigns Registry
Self-Report Goals
DTS Cost Analysis
Andy's Cash Position
Andy's 1st Closings Dash
Settings ▾
TV Displays
Users
HR
Operations DashboardSales Department
Transactions
Dispo
Loans
Inventory
Company Cashflow
Mgmt
Total Cash Position
$0
Bank +$0
REO +$0
Bank Accounts
$0
Chase · usable owners
Credit Card Accounts
$0
Credit cards and lines of credit
Unusable in Bank Account
$0
Reserve — not spendable
REO Balance
$0
Sum of Cash Position
Add account balance
Entries
| Date | Owner | Type | Balance |
|---|
No entries yet. Add one on the left, or hit "Load sample data".
The cashflow forecast tables are missing in Supabase. Run
migration-cashflow-forecast.sql in your Supabase SQL Editor, then refresh.
Available Cash (Usable)
$0
Drives the rolling forecast
Credit Card Accounts
$0
Credit cards and lines of credit
Available Credit
$0
Not Usable in Bank
$0
Reserve — excluded from spendable
Total REO Cash Position
$0
Active short-term financed properties · tracker totals
4-Week Forecast
Window
2 weeks
4 weeks
8 weeks
13 weeks
Show
Closings
Loans
Cyclicals
Manual Entries
Entity
Ending cash < $50k buffer
Ending cash < $0
PProjected (estimated date)
Click a Cash IN / Cash OUT cell to expand line items.
Account Balances
Current cash positions. Update whenever balances change.
No accounts yet. Click "+ Add Account Balance Entry" to log the first one.
Cyclical Expenses
Recurring outflows. Changes apply to all future weeks unless overridden.
| Name | Amount | Frequency | Active |
|---|
No cyclical expenses yet.
Forecast Entries
One-off Cash IN / OUT items. Each entry hits the forecast in the week containing its date. Use Cyclicals (left) for items that recur every week or month.
| Date | Dir | Owner / Type | Description | Amount |
|---|
No forecast entries yet.
The
lenders, properties, or loans table is missing in Supabase. Run properties-loans-schema.sql in your Supabase SQL Editor, then refresh.
Properties
Job Costs
Draws
Ledger
Checklists
Loan Payments
Lenders
Lender Follow-Ups
Loans
Maturity
Payoff History
Upcoming Activity
Analytics
Rate Scenario
Company Cashflow
Upcoming Activity
Loan Payoffs
Purchases (Needs Funded)
▸ Undated (TBD close) — 0
Job Costs
| Job | Property | Budget | Actual | Variance | Used | Land | Interest | Soft costs | All-in | Last activity |
|---|
Lenders
Baseline Rate
Baseline Term
No lenders yet. Add one above.
Lender Follow-Ups
Auto-built from lenders holding an active loan. Monthly check-ins appear only for lenders whose “Likes Property Updates” is Yes or Sometimes — set it to No and they stop. Listed, under-contract and payoff items appear for every lender regardless — unless that lender is set to No, which switches off follow-ups entirely. Payoff shows within 30 days of the projected date. Mark an item done to log it.
Loan Payments
The interest split is the point — it is the only way to see what carry
has cost on a job.
Log a Payment
| Property | Loan | Date | Total | Interest | Principal | Memo |
|---|
No payments logged yet.
Checklists
Steps marked conditional can be set N/A without blocking completion.
No checklists started yet. Pick a template and a property above.
| Step | Owner | Due | Notes | Status |
|---|
Ledger
Every dollar in or out on a property before and at closing. EMD and the
due-diligence fee are applied to the purchase price, not expenses.
Each row carries a memo to paste into QuickBooks.
Settlement statement
| Line | Description | Amount | What to do with it |
|---|
New Ledger Entry
| Property | Date | Type | Amount | Paid to / from | Status | Memo |
|---|
No ledger entries yet.
Draws
New Draw
| Property | # | Phase | Total | Paid By | Status | Requested |
|---|
No draws yet.
Properties
New Property
All
Spec builds
Client builds
| Address | Type | Entity | Status | # Loans | Total Borrowed | Lenders |
|---|
No properties yet.
JobTread
Loans on this property
| Loan # | Lender | Type | Pos | Amount | Rate | End Date | Status |
|---|---|---|---|---|---|---|---|
| Total | $0 | ||||||
No loans on this property yet.
Loans
to
days
⚠ Pending Loan Requests
| Lender | Amount | Address | Interest | Orig Fee | Start Date | Submitted By |
|---|
Upcoming Loans
| Loan # | Property / TC | Lender | Type | Pos | Amount | Rate | End Date | Status | Funding Status |
|---|
No upcoming loans.
Active Loans
| Loan # | Property | Lender | Type | Pos | Amount | Rate | End Date | Status |
|---|
No loans yet.
General / Business Loans
| Loan # | Lender | Lent To | Cash In/Outgoing | Type | Amount | Rate | Start | End Date | Status |
|---|
No general loans.
Maturity Dashboard
Loan Maturity Dashboard
Total $ Maturing — Next 30 Days
$0
0 loans
Total $ Maturing — Next 60 Days
$0
0 loans
Payoff History
| Lender | Property Address | Loan # | Position | Type | Principal | Interest Rate | Funding Date | Payoff Date | Total Payoff | Interest Paid |
|---|
No loan payoffs in this window.
0 properties match · no filters
Properties Matched
0
across all properties
Total Borrowed
$0
0 active loans
Avg Loan / Property
$0
across matched properties
Avg Listed Price
$0
no data
Sum Listed Price
$0
0 listed
Avg Sq Ft
—
no data
Avg Build Year
—
no data
Avg Beds
—
Avg Baths
—
Avg Lot Size
—
Avg Days Since Purchase
—
Breakdown by Status
Matching properties
| Address | Status | PM | Entity | Listed Price | Total Borrowed |
|---|
No properties match these filters.
Three-table model: a Lender has many Loans · a Property has many Loans · each Loan links a Lender to a Property. Edits sync to Supabase and across tabs in realtime.
Entry
Inventory
Properties
Handoffs
Projected Profit
Cash Position
Global REO Schedule
Andy Inventory View
Lifecycle Status
Asset Type
Finance Status
Entity
Project Manager
Realtor
Listed Price ($)
–
Build Year
–
Square Footage
–
Project Start Date
–
Listed Date
–
Date Vacant
–
Projected 2nd Closing Date
–
Sale Closing Date
–
Refi Closing Date
–
| Address | Lifecycle Status | Tracker Cash Position | Total Rehab Spent | Projected 2nd Closing |
|---|
No properties yet. Use + Add Property above to add your first one.
Responsibilities
TC Handoffs
Project Team Handoffs
Rental Team Handoffs
Properties grouped by responsible department. Change a property's department with its dropdown; hand off newly-purchased deals to PM or Project Management.
Pull report
Properties the Transaction team currently owns (Just Purchased + Transaction Management). Click Hand off to pass one to another department.
Recently Handed to Us (last 14 days)
Recently handed off (last 14 days)
Properties
Properties the Project Management team currently owns. Click Hand off to pass one to another department.
Recently Handed to Us (last 14 days)
Recently handed off (last 14 days)
Properties
Properties the Property Management (Rental) team currently owns. Click Hand off to pass one to another department.
Recently Handed to Us (last 14 days)
Recently handed off (last 14 days)
Properties
% of sale price — agent commission plus closing costs.
Applies to spec builds only; a client build is handed over, not sold.
LIVE
Movement
| Property | Spread Today | Chg | Chg % | Spent to Date | Chg | Trend |
|---|
Spec Builds — Projected Profit
Live from what is entered now
| # | Property | Status | Target Sale | Sale Price | Land | Build | Carry | Loan Fees | Selling | All-In Cost | Projected Profit | Margin |
|---|
No spec builds in progress.
Client Builds — Projected Margin
Contract amount less cost to build. No sale, no selling costs.
| # | Property | Status | Target Completion | Contract | Build | Other Costs | Total Cost | Projected Margin | Margin |
|---|
No client builds in progress.
Cash Position
| Address | Status | Cash Position | Holdback Remaining | Tracker Synced |
|---|
No properties with these statuses.
Global REO Schedule
Entity
Extend loan
| Extend by | Fee | % of loan | New maturity |
|---|
Deal Analyzer
Underwrite
Bid Sheet
Investor Summary
Model Notes
Project
Sale price is per unit. Everything downstream scales by the unit count.
Gross income (price × units)—
Total heated sqft—
Target profit @ 20% of gross—
Land & horizontal costs
Everything it takes to get to a pad-ready lot. These are the pursuit costs you spend before a vertical loan draws.
Horizontal + soft costs—
Pad-ready cost per pad—
Land price per pad—
Land + horizontal—
Vertical build
Either price it per square foot, or pull the total straight off the Bid Sheet tab.
Vertical cost—
GC fee—
GC deposit due—
All-in cost to build—
All-in cost per sqft—
Loan & holding costs
Leave the loan amount blank to size it to the all-in build cost, the way the sheet does.
Lender's cost basis—
Loan amount—
Average balance over the hold—
Interest per day (average)—
Interest for the hold—
Monthly interest payment—
Points—
Loan request (with padding)—
Max at LTC—
Max at LTV—
Loan funded—
—
Gap funds to cover—
Total loan holding costs—
—
Carry costs (annual)
Entered per year; charged per day across the hold, per unit.
Per year / month / day—
Carry cost for the hold—
Private money
Whoever covers the gap above. Interest accrues daily and pays at the end of the hold, so a longer build costs the deal more -- and it is already counted in Total loan holding costs.
| Lender | Amount | Rate % | Daily | Total over hold |
|---|---|---|---|---|
| Total | — | — | — | — |
Capital needed upfront—
Raised from lenders above—
Payback at the end of the hold—
Days until lenders are repaid—
Closing & selling costs
Purchase closing costs—
Selling closing costs—
Total closing costs (ex. commission)—
Sales commission—
Final numbers
—
Sell price (gross)—
Land purchase—
Horizontal construction—
Vertical construction—
GC fee—
Loan holding costs—
Carry costs—
Closing costs—
Commission—
Total expenses—
Profit—
Profit per build—
Profit % of build cost—
Profit % of gross—
Lot cost % of ARV—
Capital & return
Gap funds—
Points—
Purchase closing—
Other purchase costs—
Land (your share)—
Cash in the deal—
—
Less private money raised—
Your cash after private money—
Fronted before draws—
Return on your cash—
Cash-on-cash (before private money)—
Per month over the hold—
Annualized—
Bid sheet
The client bid template, trade by trade. Sqft and the grand total drive the $/SF figure a lender or a client asks for. Feeds the Underwrite tab when its vertical source is set to Bid Sheet total.
| Trade | Price | Bid status | Notes |
|---|
Deal at a glance
—
Purchase price—
Loan amount requested—
Sale price—
Horizontal construction costs—
Vertical construction costs—
Holding costs—
Carry costs—
Closing costs—
Commission—
Construction cost per sqft—
Project sqft—
Projected profit—
Cash-on-cash return—
Capital split
Equity (your capital in)—
Debt (construction loan)—
Debt rate—
Equity / lender rate—
Blended cost of capital—
Underwriting guardrails
The rules of thumb baked into the sheet.
How this differs from the spreadsheet
Five places where the workbook maths did not do what its labels said. Each is corrected here, so expect numbers to move.
- Loan interest was undercounted. The sheet worked out the interest for the whole hold, then divided it by 365 to get a "per day" figure, then multiplied that by the hold days again. On the Greenbriar example that charged $3,793 of interest instead of $9,230 — profit was overstated by about $5,400. Here, per-day interest is loan × rate ÷ 365, and the hold charge is that × hold days.
- Monthly cash-on-cash was inverted. The sheet multiplied the return by the hold days and divided by 30, reporting 419% a month on Greenbriar. Dividing instead gives 16.8% a month, which is what a 84% return over 150 days actually works out to. Annualized is shown alongside it.
- All-in cost per sqft used one unit of area. It divided the total build cost by the sqft of a single unit, so any multi-unit project read several times too expensive per foot. Here it divides by total sqft.
- "Horizontal costs + land purchase" skipped clearing and grading. The formula added every horizontal line except that one. All nine are included here.
- Commission was charged on one unit. It applied the commission percentage to the per-unit sale price rather than gross proceeds, undercharging on multi-unit deals. Here it is charged on gross.
What carried over unchanged
- Purchase closing costs are a percentage of land price plus loan amount.
- All-in cost to build is horizontal + soft costs, plus vertical, plus the GC fee.
- The loan request adds a padding percentage on top of the loan amount, and the lender funds LTC% of that request; the shortfall against all-in build is your gap.
- Capital needed upfront is gap funds + points + purchase closing + other purchase costs + horizontal & soft costs + land.
- Carry costs are entered annually and charged per day across the hold, multiplied by the unit count.
- The 20% guardrails: target profit is 20% of gross, and land should come in under that same number.
Deal
Deal
Pipeline
Open in REsimpli ↗
Flip Grading View
Inventory View
Hand off property
Pass purchase details to the receiving department.
Rental Handoff Form
Fill this out when the property is fully complete (inspections passed, punchout done, cleaned). Posts to
#rental-handoffs on save.Rental Ownership Sign Off
This form is to only be signed when taking full ownership from Project Management to Property Management. Posts to
#rental-handoffs on save.Remedy / Punchout Walkthrough
Note anything that needs to be remedied by section. Blank sections are fine — only filled ones are sent to Projects. Posts to
#rental-handoffs on save.Handoff details
Most recent handoff submitted for this property.
Address
Units · each unit carries its own lifecycle → department for Responsibilities
Funding
Tracker
Construction & Budget
Leverage
Mark as Sold
Refi Closed
On save: lifecycle status flips to Long Term Tenant and finance status flips to Long Term.
PAYOFF STATEMENT
Address
Submit Loan Request
Logs a prospective loan and pings #funding-needed.
PROPERTY PAYOFF SNAPSHOT
Address
FINAL SALE REPORT
Address
EOD Report
EOD Report
Copied to clipboard ✓
1st Closing
Enter the profit captured at first closing — the cash that actually
hit our account today. Excludes any assignment holdback (add that
below). $0 (break-even) and negative values (loss) are both allowed.
Owner-occupied or vacant → we’ll ask Utilities to switch service into our name.
Tenant-occupied → the alert routes the team to Eddy instead.
1st Closing Holdbacks (optional)
Turn on for any holdbacks tied to this closing. Amount and due date can be
entered now; the "received" fields can be filled in later from the Closings modal.
When the seller-side clause is decided (used for reminders later).
Already excluded from the confirmed profit above.
Fallout
On Hold
Edit Lender
Outstanding
$0
Headroom
$0
% Capacity Used
0%
Edit Loan
Lender Rollover
Lender Requested to Roll
Saving with notes posts an @channel message (roll source, roll amount, projected 2nd closing, notes).
Payoff Update
Property picker searches inventory and TC View deals. Amounts and rates persist as new loan rows tied back to this source loan.
HR
People, time off, handbook, and onboarding.Time Off
Calendar
Handbook & Docs
Directory
Loading…
Loading…
Handbook
Payroll Documents · admin only
Loading…
REO — Full Book
Loading…
column groups:
expenses:
REO — Source of Truth & Game Plan
Loading…Scenario runner — assumptions
The Game Plan — sell waves
Decision drift — where our plan differs from the model
Properties — source of truth
Tracker — what we said last time
Users
Admin-only. Invite team members, assign roles, deactivate.| Name | Role | Status | Invited By | Last Sign In | Actions |
|---|
No users yet. Click "Invite User" to add one.
Invite User
User created ✓
Email:
Role:
Fallback: temp password (only if email didn't arrive)
Temp password:
They can use this to sign in once and use "Forgot Password" to set their own.
Roles & Permissions
E = can edit ·
V = view only ·
— = no access
Account Balance History
| Date | Owner | Type | Balance |
|---|
No balance entries yet.