Vaulted

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.

ColumnCodeExpected onDefinition
Loan IDloan_idWhen knownVaulted's id for the loan.
Loan labelloan_labelWhen knownThe fund's loan number, when the loan is in a fund.
Property addressproperty_addressWhen knownThe collateral's address as entered.
Stateproperty_stateEvery loanTwo-letter state, from the deal profile or the address.
Property typeproperty_typeEvery loanSingle-family, 2 to 4 units, condo, 5+ units, mixed use, land or other.
Lien positionlien_positionEvery loanFirst or second lien.
Loan typeloan_typeEvery loanThe loan type entered on the loan (fix and flip, bridge, construction, DSCR...).
Loan purposeloan_purposeEvery loanBusiness or consumer purpose.
OccupancyoccupancyEvery loanInvestment property or owner-occupied.
Borrower typeborrower_typeEvery loanEntity or individual.
Personal guarantypersonal_guarantyWhen knownY when a guarantor is entered. Names are not exported.
Borrower experienceborrower_experienceEvery loanSimilar projects completed in the last 36 months.
Credit scorecredit_scoreEvery loanMost recent score recorded on the loan.
StagestageWhen knownThe loan's stage in Vaulted.
Origination dateorigination_dateWhen knownYYYY-MM-DD.
Original maturityoriginal_maturity_dateWhen knownMaturity before any approved extension.
Current maturitycurrent_maturity_dateWhen knownMaturity today, after approved extensions.
Original term (months)term_monthsWhen knownTerm at origination.
ExtensionsextensionsWhen knownNumber of approved extensions.
Loan amountloan_amountWhen knownTotal commitment, including any rehab holdback.
Unpaid principalunpaid_principalWhen knownLoan amount less principal paydowns recorded in Vaulted. Principal inside amortizing payments isn't separated.
Note rate (%)note_rateWhen knownAnnual interest rate on the note.
Default rate (%)default_rateWhen knownRate after default, if the note has one.
Payment structurepayment_structureWhen knownInterest-only or amortizing.
Amortization (months)amortization_monthsWhen knownFor amortizing loans.
Day countday_countWhen knownActual/365, Actual/360 or 30/360.
Monthly paymentmonthly_paymentWhen knownThe regular payment the note calls for today.
Origination feeorigination_feeWhen knownDollars.
Points (%)pointsWhen knownOrigination fee as a percent of the loan amount.
As-is valueas_is_valueEvery loanThe appraisal or valuation entered on the loan.
Purchase pricepurchase_priceRehab and construction loansFrom the deal profile.
Rehab budgetrehab_budgetRehab and construction loansSum of the budget categories, else the draw budget on the loan.
After-repair valueafter_repair_valueRehab and construction loansFrom the deal profile.
LTV (%)ltvWhen knownLoan amount / as-is value.
LTC (%)ltcWhen knownLoan amount / (purchase price + rehab budget).
LTARV (%)ltarvWhen knownLoan amount / after-repair value.
Draws fundeddraws_fundedWhen knownApproved draw amounts.
Holdback remainingholdback_remainingWhen knownRehab budget less draws funded.
Rehab disbursed (%)rehab_disbursed_pctWhen knownDraws funded / rehab budget.
Last inspection (% complete)last_inspection_pctWhen knownPercent complete at the most recent inspection.
Draws without inspectiondraws_without_inspectionRehab and construction loansApproved draws with no inspection recorded.
Draws without lien waiverdraws_without_lien_waiverWhen knownApproved draws with no lien waiver recorded.
Payment statuspayment_statusWhen knownFrom payments marked missed in Vaulted, and maturity.
Days past duedays_past_dueWhen knownDays since the oldest missed payment's due date.
Payments receivedpayments_receivedWhen knownCount of received payments (reversals excluded).
Last paymentlast_payment_dateWhen knownDate of the most recent received payment.
Monthly rentmonthly_rentRental (DSCR) loansFrom the deal profile.
Monthly taxesmonthly_taxesRental (DSCR) loansFrom the deal profile.
Monthly insurancemonthly_insuranceRental (DSCR) loansFrom the deal profile.
DSCRdscrWhen knownMonthly rent / (payment + taxes + insurance + HOA).
Exit strategyexit_strategyEvery loanSale, refinance, hold... as entered on the loan.
Source documents linkedsource_documentsWhen knownKey numbers (as-is value, purchase price, ARV, budget, credit, title, experience) with a document on file in Vaulted.
Changes recordedchanges_recordedWhen knownEdits 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