Products / Owner Report Pack
Send every owner the same clean statement each month.
Keep one ledger for all your properties. Pick a property and a month, and the statement, the maintenance log and the year-to-date P&L fill in from it.
Who it's for
Property managers with roughly 10 to 150 doors who build owner reports by hand from a spreadsheet or a bank export.
If AppFolio, Buildium or similar software already sends your owner statements, you probably don't need this.
A look at the actual file

What's inside
One workbook, 9 tabs, in this order.
| Tab | What it does |
|---|---|
| Start here | How to use it each month, how the reserve works, limits, colour key and the disclaimer. |
| Statement | The owner statement for the property and month you pick: income, expenses by type, your fee, reserve, payout and the balance carried forward. Prints on one page. |
| Setup | Each property once: owner, management fee % and reserve target. Up to 150 properties. |
| Ledger | One row per rent payment, fee, expense, owner contribution or payout, with an invoice or photo link. Up to 5,000 rows, each with a row check. |
| Maintenance log | That property's repairs for the month with clickable invoice links. Prints as page 2 of the statement. |
| YTD P&L | January to the chosen month for one property, including your fee, the reserve and what went to the owner. |
| Portfolio | Every property for the chosen month on one page, so you can check each payout before you send. |
| Checks | Flags text in number cells, unknown types or properties, a fee typed as 8 instead of 8%, a full ledger and totals that don't tie. |
| Owner email | Wording for telling owners you are moving to one standard report. |
A look at the file
| Line | Amount |
|---|---|
| Income | |
| Rent collected | 6,400.00 |
| Late fees | 75.00 |
| Total income | 6,475.00 |
| Expenses | |
| Repairs | (310.00) |
| Total expenses | (310.00) |
| Management | |
| Management fee (8% of rent collected) | (512.00) |
| Net income for the month | 5,653.00 |
| Owner account | |
| Reserve held (target 250.00) | (250.00) |
| Owner payout | 5,403.00 |
Rent of 1,600.00 from each of four units, a late fee, one repair with its invoice linked on the Maintenance log, and an 8% fee on rent collected. The reserve is topped up to its 250.00 target and the rest is paid out. Amounts in brackets are money out.
| Property | Owner | Income | Expenses | Management fee |
|---|---|---|---|---|
| 14 Alder St | R. Okafor (example) | 6,475.00 | (310.00) | (512.00) |
| 9 Cedar Ct | M. Lindqvist (example) | 2,150.00 | (276.00) | (215.00) |
Format
- File
- 1 Excel workbook (.xlsx), 9 tabs
- Software
- Microsoft Excel. Designed to open in Google Sheets.
- Limits
- 150 properties, 5,000 ledger rows, 40 repairs per property per month, 12 units listed by name on a statement (more are added together on one line).
- Delivery
- Instant download after purchase. Nothing is shipped.
- Price
- US$19, one-time. Launch price until 15 Nov, then US$29. No subscription.
What it does not do
- It does not replace any trust-account records your state or licensing body requires. Ask your broker, accountant or attorney what you must keep.
- It does not connect to your bank or property software. You type or paste the ledger rows.
- The management fee is worked out on rent collected only; late fees and other income are left out of the fee base.
Questions
Which version of Excel do I need?
Excel 2010 or later on Windows, Excel 2016 or later on Mac, or Excel for the web. We checked every formula in this workbook against the version of Excel that first supported it: the newest thing it uses arrived in Excel 2007, so it needs no Microsoft 365 subscription. There is nothing in it that only newer Excel can run, such as XLOOKUP, LET, IFS or TEXTJOIN, and there are no macros or add-ons. Excel 2003 and earlier are not supported.
The totals look blank when I open it. What is wrong?
Nothing. Excel opens a downloaded file in Protected View and does not calculate until you click Enable Editing. The figures appear as soon as you do.
Does it work on a Mac?
Yes, in Excel for Mac. There are no macros, so nothing in the file is Windows-only. It is also designed to open in Google Sheets in a browser.
Can I use it in Google Sheets?
The workbook is made in Excel and designed to open in Google Sheets: upload it to Drive and open it with Google Sheets. It uses no macros, scripts or add-ons. If something does not work as described there, email hello@goodcolumns.com and we fix it or refund you.
What if I want a refund?
No change-of-mind refunds on digital files. If a file is faulty or not as described, email hello@goodcolumns.com within 30 days and we fix it or refund you.
Is this tax, legal or financial advice?
No. It organises your ledger into statements. It does not replace any trust-account records your state or licensing body requires.
The small print
Good Columns templates help you organise records. They are not tax, legal, accounting or financial advice, are not endorsed by the IRS or any government body, and may not suit your situation. You are responsible for the figures you enter.
Licence: use within your own business; no resale or redistribution.
No change-of-mind refunds on digital files. If a file is faulty or not as described, we fix it or refund you.
Full terms: Terms and refunds.