Open standard · free to use
A loan tape standard for private lenders
A loan tape is the spreadsheet a lender sends a loan buyer, a credit line or a fund's investors: one row per loan. Every buyer has its own template, and small lenders rebuild the same file by hand each time. This is one common field list, with a definition for every column, that anyone can use.
Why a standard
Money moves toward loans it can check. When residential mortgages standardized their data (the MISMO standards, started by the Mortgage Bankers Association in 1999), lenders could deliver loans to buyers without rebuilding every file. Private lending is going through the same change: rated securitizations of fix-and-flip loans began in 2024, and buyers now pool loans from dozens of small lenders.
Buyers ask for the same core facts: the collateral, the leverage, the borrower's track record, the rehab budget and how much of it has been drawn, the maturity, and how the loan has paid. This list covers those, and says which ones are expected on which kind of loan.
Rules
- No personal details. No borrower or guarantor names, emails, phone numbers or ID numbers. Loans are identified by an id, and collateral by address. Names go under an NDA if a buyer asks.
- Dates as YYYY-MM-DD. Percentages as numbers (75 means 75%). Dollars without symbols or commas.
- Every number traces to a record: the appraisal, the budget, the payment history. A plausible number isn't enough.
The fields
53 columns, in order.
| Column | Code | Expected on | Definition |
|---|---|---|---|
| Loan ID | loan_id | When known | Vaulted's id for the loan. |
| Loan label | loan_label | When known | The fund's loan number, when the loan is in a fund. |
| Property address | property_address | When known | The collateral's address as entered. |
| State | property_state | Every loan | Two-letter state, from the deal profile or the address. |
| Property type | property_type | Every loan | Single-family, 2 to 4 units, condo, 5+ units, mixed use, land or other. |
| Lien position | lien_position | Every loan | First or second lien. |
| Loan type | loan_type | Every loan | The loan type entered on the loan (fix and flip, bridge, construction, DSCR...). |
| Loan purpose | loan_purpose | Every loan | Business or consumer purpose. |
| Occupancy | occupancy | Every loan | Investment property or owner-occupied. |
| Borrower type | borrower_type | Every loan | Entity or individual. |
| Personal guaranty | personal_guaranty | When known | Y when a guarantor is entered. Names are not exported. |
| Borrower experience | borrower_experience | Every loan | Similar projects completed in the last 36 months. |
| Credit score | credit_score | Every loan | Most recent score recorded on the loan. |
| Stage | stage | When known | The loan's stage in Vaulted. |
| Origination date | origination_date | When known | YYYY-MM-DD. |
| Original maturity | original_maturity_date | When known | Maturity before any approved extension. |
| Current maturity | current_maturity_date | When known | Maturity today, after approved extensions. |
| Original term (months) | term_months | When known | Term at origination. |
| Extensions | extensions | When known | Number of approved extensions. |
| Loan amount | loan_amount | When known | Total commitment, including any rehab holdback. |
| Unpaid principal | unpaid_principal | When known | Loan amount less principal paydowns recorded in Vaulted. Principal inside amortizing payments isn't separated. |
| Note rate (%) | note_rate | When known | Annual interest rate on the note. |
| Default rate (%) | default_rate | When known | Rate after default, if the note has one. |
| Payment structure | payment_structure | When known | Interest-only or amortizing. |
| Amortization (months) | amortization_months | When known | For amortizing loans. |
| Day count | day_count | When known | Actual/365, Actual/360 or 30/360. |
| Monthly payment | monthly_payment | When known | The regular payment the note calls for today. |
| Origination fee | origination_fee | When known | Dollars. |
| Points (%) | points | When known | Origination fee as a percent of the loan amount. |
| As-is value | as_is_value | Every loan | The appraisal or valuation entered on the loan. |
| Purchase price | purchase_price | Rehab and construction loans | From the deal profile. |
| Rehab budget | rehab_budget | Rehab and construction loans | Sum of the budget categories, else the draw budget on the loan. |
| After-repair value | after_repair_value | Rehab and construction loans | From the deal profile. |
| LTV (%) | ltv | When known | Loan amount / as-is value. |
| LTC (%) | ltc | When known | Loan amount / (purchase price + rehab budget). |
| LTARV (%) | ltarv | When known | Loan amount / after-repair value. |
| Draws funded | draws_funded | When known | Approved draw amounts. |
| Holdback remaining | holdback_remaining | When known | Rehab budget less draws funded. |
| Rehab disbursed (%) | rehab_disbursed_pct | When known | Draws funded / rehab budget. |
| Last inspection (% complete) | last_inspection_pct | When known | Percent complete at the most recent inspection. |
| Draws without inspection | draws_without_inspection | Rehab and construction loans | Approved draws with no inspection recorded. |
| Draws without lien waiver | draws_without_lien_waiver | When known | Approved draws with no lien waiver recorded. |
| Payment status | payment_status | When known | From payments marked missed in Vaulted, and maturity. |
| Days past due | days_past_due | When known | Days since the oldest missed payment's due date. |
| Payments received | payments_received | When known | Count of received payments (reversals excluded). |
| Last payment | last_payment_date | When known | Date of the most recent received payment. |
| Monthly rent | monthly_rent | Rental (DSCR) loans | From the deal profile. |
| Monthly taxes | monthly_taxes | Rental (DSCR) loans | From the deal profile. |
| Monthly insurance | monthly_insurance | Rental (DSCR) loans | From the deal profile. |
| DSCR | dscr | When known | Monthly rent / (payment + taxes + insurance + HOA). |
| Exit strategy | exit_strategy | Every loan | Sale, refinance, hold... as entered on the loan. |
| Source documents linked | source_documents | When known | Key numbers (as-is value, purchase price, ARV, budget, credit, title, experience) with a document on file in Vaulted. |
| Changes recorded | changes_recorded | When known | Edits in the loan's change history: who changed which number, and when, is on the loan page. |
Vaulted fills this tape from the records a lender already keeps, scores each loan against it, and can send a buyer a read-only, expiring link. The standard is free to use either way. Suggestions: [email protected].
Keep every loan ready for a buyer, without rebuilding the spreadsheet.
Start your 30-day trial