The Rental Application Screening Scorecard in Excel That Keeps You Out of Court

Two applicants want your rental. One is warm, chatty, reminds you of your cousin, and makes $3,900 a month. The other is quiet, a little awkward, and makes $5,400 a month with a spotless payment record. Screen on instinct and you probably hand the keys to the first one. Six months later you are filing for eviction. A rental application screening scorecard in Excel exists to stop exactly that decision, because the tenant who feels right and the tenant who actually pays rent are not always the same person, and instinct cannot tell them apart.

Screening on gut feel is not just a business risk. It is a legal one. Every time you approve or reject an applicant on a vibe instead of a number, you leave yourself open to a fair housing complaint you cannot defend, because you have no record of why one person got the unit and another did not. A rental application screening scorecard fixes both problems at once. It grades every applicant on the same criteria, it produces a paper trail, and it takes the decision out of your head and puts it on a spreadsheet where it belongs.

Why "I Get a Feel for People" Is the Most Expensive Screening Method There Is

Gut-feel screening fails in two directions, and both are costly.

The first cost is the bad tenant you approve because you liked them. A single eviction is rarely a single line item. You lose rent from the first missed payment through the day the sheriff posts the notice, which in most states runs two to four months. You pay court and attorney fees. You pay to turn the unit after someone who stopped caring about it. Add it up and a routine eviction lands between $4,000 and $10,000 once you count lost rent, legal costs, and turnover. On a unit that nets $400 a month, that one bad approval erases a year or more of profit.

The second cost is quieter and larger. The Fair Housing Act bars you from treating applicants differently based on race, color, religion, sex, national origin, familial status, or disability, and many states and cities add protections like source of income, age, or marital status. You do not have to intend to discriminate to get in trouble. If you approve one applicant with a 640 credit score and reject another with a 660 score, and the two happen to differ by a protected characteristic, you have a problem you cannot explain away, because you never wrote down a rule. A single fair housing settlement commonly runs $10,000 to $20,000 before legal defense, and federal civil penalties for a first violation exceed $20,000. The scorecard is not busywork. It is the document that proves you applied the same standard to everyone.

The Five Numbers That Predict Whether Rent Actually Shows Up

A good scorecard measures the things that correlate with getting paid, weights them by how much they matter, and ignores everything else. Five inputs carry almost all the signal. Here is the rubric, scored out of 100 points.

Income to rent ratio is the single strongest predictor

The oldest rule in rentals is that gross monthly income should be at least three times the rent. It survives because it works. A tenant paying $1,600 rent on $4,000 a month has room to absorb a car repair. The same rent on $2,800 a month is one bad week from a missed payment. Weight it heaviest, because it is the number most directly tied to whether the check clears.

Credit score tells you about habits, not wealth

Credit score is a proxy for whether this person pays recurring bills on time. It is not a measure of how much money they have. Someone can earn well and pay late, and someone modest can carry a perfect record. Bands matter more than the exact number, which is why the rubric groups scores into tiers instead of using them raw. A 662 and a 716 both land in the same tier, and treating them the same keeps you from splitting hairs that do not predict anything.

History beats everything the applicant tells you

What a prior landlord actually reports outweighs anything typed on the application. A verified "paid on time, would rent to again" is worth more than a high income with no track record behind it. A prior eviction or an unpaid balance sent to collections is the one input that should pull the score toward zero on its own. Call the last two landlords, not just the current one, since the current landlord may be motivated to pass along a problem tenant.

Building the Scorecard in Excel

Lay it out so each applicant is a column and each criterion is a row. Enter the raw inputs at the top, let formulas convert them to points, and read the decision off the bottom. Here is the logic that does the work.

Put the income to rent ratio in its own cell first so you can see it, then score it. If gross monthly income is in B4 and monthly rent is in B5, then =B4/B5 in B6 gives you the ratio. Now convert that ratio to points with a single tiered formula. IFS reads top to bottom and stops at the first match, so order the bands from best to worst:

=IFS(B6>=3.5,30,B6>=3,22,B6>=2.5,12,TRUE,0)

The TRUE at the end is the catch-all that scores anything below 2.5x as zero, so no applicant ever slips through without a number. Do the same for credit, where the raw score sits in B7:

=IFS(B7>=720,25,B7>=660,18,B7>=600,10,TRUE,0)

Enter the history, stability, and reference points directly from your rubric definitions, since those are judgment calls against fixed language rather than pure math. Then total the five point cells:

=SUM(B8:B12)

Turn that total into a decision so you are reading a word, not eyeballing a number. If the total is in B13:

=IF(B13>=75,"APPROVE",IF(B13>=60,"CONDITIONAL","DECLINE"))

That sorts the score into three lanes. Seventy-five and up is a clean approval. Sixty to seventy-four is conditional, meaning you can approve with a larger deposit, a co-signer, or first and last month up front. Below sixty is a decline. Add one more layer to catch disqualifiers that should override the total no matter how high it climbs, like an unpaid prior eviction judgment. Put a knockout flag in B14 and let it win:

=IF(B14="yes","AUTO-DECLINE",B15)

where B15 holds the normal decision from the formula above. Define these knockouts before you ever see an applicant, and apply them to every single one:

• Unpaid eviction judgment or a rent balance in collections
• Income to rent ratio below 2.5x with no qualified co-signer
• Application details that do not match the pay stubs or the prior landlord
• Refusal to authorize a credit and background check

A Real Two Applicant Decision

Run the two applicants from the top of this article through the sheet and watch the friendly conversation stop mattering.

Applicant A makes decent money and seems great across a kitchen table. On the sheet, a 2.44x ratio and a 648 credit score put the total at 38. Applicant B, the awkward one you almost passed on, scores 85. The spreadsheet just made the decision your gut was about to get wrong, and it did it in numbers you can show anyone who asks, including a fair housing investigator. That last point is the one landlords underrate. The scorecard did not only protect your cash flow. It documented that the reason for the decline was a score, not a person.

The Rule That Turns a Spreadsheet Into a Legal Shield

The scorecard only protects you if you use it the same way every time. A rubric you apply to some applicants and skip for others is worse than no rubric, because it proves you had a standard and chose when to ignore it. Follow four rules.

1. Set the weights and thresholds before you list the unit. Decide your approve line, your knockouts, and your conditional terms in advance. Never adjust them mid-search to fit a specific person you took a liking to.
2. Score every applicant in the order received. Run the first qualified applicant through the full rubric. If they clear the bar and accept, you are done. A written first-qualified policy is itself a consistent, defensible standard.
3. Keep every completed scorecard for at least two years. The federal statute of limitations for many fair housing claims is two years, and several states run longer. A saved sheet per applicant, dated, with the raw inputs, is your evidence that the decision was about the numbers.
4. Send an adverse action notice when you decline on a report. If you reject or charge more based on a credit or background report, the Fair Credit Reporting Act requires you to tell the applicant, name the reporting agency, and note their right to dispute. A one-paragraph template covers it.

One caution on criminal history. Federal guidance treats blanket criminal bans as a fair housing risk, because they can produce a disparate impact on protected groups. If you consider it at all, weigh the nature and recency of a specific conviction against a written policy, not a yes or no checkbox, and keep it out of the automated total. When in doubt, lean on income, credit, and verified rental history. Those are the inputs that actually predict whether rent shows up.

From Scorecard to a System That Runs Itself

A standalone screening tab is a strong start. The problem it does not solve is what happens after you approve someone. The reason you screen this hard is to protect the return on the property, and that return lives in a different set of numbers: rent against the mortgage, taxes, insurance, a maintenance reserve, and vacancy. A tenant who scores 85 still loses you money if the unit itself never cash flowed in the first place.

That is why the screening scorecard belongs inside a full rental analysis instead of off on its own. Our Rental Property Analyzer wires the tenant scoring rubric into the same workbook that runs your cash flow, cap rate, and cash on cash return, with the income ratio bands, credit tiers, and decision thresholds already built and the adverse action language ready to drop in. You enter an applicant, you get an APPROVE or DECLINE and a saved record, and the same file tells you whether the rent that applicant will pay actually covers the property. Screen on numbers, hold the tenants who pay, and keep the paper that proves you did it fairly. Stop deciding with your gut and start deciding with the scorecard.