How to Score Tenant Applicants in a Spreadsheet

Landlords who “go with gut feel” invite fair housing risk and inconsistent outcomes — and leasing offices lose time re-debating the same applicant. A free tenant screening scorecard spreadsheet scores applicants on income, rental history, references, and weighted criteria with a clear meets threshold result.

Define criteria before applications arrive

1. Income ratio — e.g. gross income vs. rent multiple
2. Employment stability — tenure, income type
3. Landlord references — paid on time, lease violations
4. Personal references — secondary signal only
5. Weighted score — template calculates total vs. threshold

Write thresholds in the sheet header and apply them identically — changing rules mid-batch for one applicant undermines defensibility.

Connect to leasing lead pipeline

When a leasing lead moves to application, copy prospect info to a scorecard row the same day. Delayed scoring slows approvals and lets competing units slip away on the availability board.

Screening services billing applicants to landlords uses the separate billing log — this scorecard is for criteria documentation.

FCRA and fair housing boundaries

This template supports consistent criteria documentation for front-office screening workflows. It does not pull consumer reports, generate adverse action notices, or replace compliant screening platforms where credit and criminal history checks are required. Verify Fair Credit Reporting Act obligations and fair housing law with qualified counsel.

When screening platforms win

Integrated credit/criminal pulls, applicant portals, and compliance workflows justify subscriptions at volume. Small landlords screening a few applicants per year often document criteria in a sheet until audit or volume demands automation.

These templates are criteria worksheets, not consumer reporting systems.