Three tabs: instructions, a weekly input sheet, and the one-page report that builds itself. Includes a filled example row so the format is obvious. Works in Excel, Google Sheets and LibreOffice.
Download the template Free to keep and modify. Attribution appreciated, not required.Pick one weekday and never move it, ideally the morning before your property manager call. Enter one row per property per week. Read the report before the call so the call is about decisions instead of explanations. Flag any budget line moving more than 5% and require a written reason: variance without an explanation is trivia, and the explanation is where the money is.
Twenty minutes a week, once you have the rhythm. The discipline does the work, not the file.
Being straight about the limits, because a template that overpromises wastes your time:
It does not connect to Yardi, RealPage, AppFolio or anything else, so somebody has to key the numbers in each week. It does not reconcile to your general ledger, produce budget-versus-actual commentary, build monthly owner reports or quarterly investor reports, or tell you what a variance means. Those are integration and judgment problems, not spreadsheet problems. This is the honest free version of the first step, and for a lot of owners the first step is the whole thing they were missing.
RentCadence AI produces this report and the monthly and quarterly reporting behind it. An AI system reads your property manager's exports whatever software they run, normalizes them, flags the variances and drafts the commentary; an operator with 15 years in real estate reviews every number before it reaches you. Pricing is published: $1,250 a month for reporting, $2,500 with oversight. You can also calculate what your current reporting lag costs before deciding anything.
Or just take the template and run it yourself. That is a genuinely fine outcome.