Four applications for one unit, and the loudest opinion in the room usually wins. This matrix replaces the opinion with a scorecard: every applicant is scored on the same five criteria — income against YOUR threshold, credit band, references, rental history and move-in readiness — weighted the way YOU set on the Start Here tab, then ranked automatically.
The sample tells the story honestly. Marcus earns the most ($7,400 a month) — and finishes LAST, with a weighted score of 6.00, because a Fair credit band, weak references and a thin rental history drag him down. Priya Nair’s complete file scores 9.45 and gets the OFFER FIRST verdict. Elena Petrova ranks second at 8.25. Tom Becker ranks third but carries two flags: his ID was not verified and his $4,400 income sits below the 3x threshold on the $1,850 unit. The Ranking & Flags tab names every flag mechanically — no SIN, SSN or account numbers are stored anywhere, only a verified Yes/No.
What it does for you:
– Scores up to 4 applicants side-by-side on YOUR criteria and YOUR weights (weights checked — they must total 100%)
– Converts income to a ratio and a 0-10 score against your threshold (3x rent pre-filled, editable)
– Bands credit (Excellent / Good / Fair / Poor) into points — no sensitive numbers ever typed in
– Produces a ranked shortlist with mechanical flags: ID NOT VERIFIED, BELOW INCOME THRESHOLD, WEAK SCORE
– Adds a landlord admin expense log, zero-based monthly budget, dashboard and 12-month summary
What’s inside (.xlsx, works in Excel AND Google Sheets):
– Start Here — setup steps, unit rent, income threshold and the five scoring weights
– Applicant Matrix — the 4-applicant scorecard with ratios, checks, weighted totals, ranks and verdicts
– Ranking & Flags — the shortlist in rank order with every flag named
– Expense Log, Monthly Budget, Dashboard, Monthly Summary
Instant download. Type only in the yellow cells — formula cells are locked (password: sheetdaily, disclosed on the Start Here tab so you can unlock if you ever need to). Sample applicants are pre-filled so you can see exactly how it works; clear the yellow cells and type your own. Screening laws and protected grounds vary by jurisdiction — this is a comparison tool, not legal advice and not a background check.
Reviews
There are no reviews yet.