A Schedule E spreadsheet for 1 to 10 doors
Schedule E (Form 1040) Part I asks for rents and expenses per property, by line. If every expense you log already has its line number, year-end is a lookup, not a weekend.
Tag every expense with a line
Give the expense log a dropdown with these labels (Data validation, list). The Year summary is then one SUMIFS per cell: property by line.
| Line | Label | Typical small-landlord costs |
|---|---|---|
| 5 | Advertising | rental listings, signs |
| 6 | Auto and travel | mileage to the property, trips for repairs |
| 7 | Cleaning and maintenance | cleaning between tenants, routine upkeep |
| 8 | Commissions | leasing agent fees |
| 9 | Insurance | landlord and liability policies |
| 10 | Legal and other professional fees | lawyer, accountant, eviction filing |
| 11 | Management fees | property manager |
| 12 | Mortgage interest paid to banks | mortgage interest (Form 1098) |
| 13 | Other interest | other loan interest |
| 14 | Repairs | fixing what broke |
| 15 | Supplies | light bulbs, filters, small parts |
| 16 | Taxes | property tax |
| 17 | Utilities | water, trash, gas, electric you pay |
| 19 | Other | anything else, labeled |
Line 18, depreciation, depends on purchase price, improvements and dates. Leave it to your accountant.
Sample Year summary, 2026
| Schedule E line | 412 Alder St | 88 Fenwick Ave | 1907 Larkin Rd |
|---|---|---|---|
| Rents received | $23,150 | $18,150 | $19,700 |
| 5 Advertising | $1,780 | $0 | $1,375 |
| 6 Auto and travel | $0 | $1,160 | $1,060 |
| 7 Cleaning and maintenance | $610 | $1,330 | $0 |
| 9 Insurance | $0 | $0 | $1,760 |
| 10 Legal and other professional fees | $0 | $1,375 | $1,890 |
| 12 Mortgage interest paid to banks | $0 | $1,235 | $1,295 |
| 14 Repairs | $3,760 | $0 | $445 |
| 15 Supplies | $1,295 | $1,855 | $1,150 |
| 16 Taxes | $2,045 | $0 | $700 |
| 17 Utilities | $1,955 | $2,155 | $0 |
| 19 Other | $830 | $1,775 | $3,735 |
| Total expenses | $12,275 | $10,885 | $13,410 |
| Net before depreciation | $10,875 | $7,265 | $6,290 |
Doorledger organizes your numbers. It is not tax advice; your accountant decides what goes where.
Skip building it. Doorledger's Year summary fills itself from the expense and rent logs for up to 10 properties. The full Doorledger workbook ($29 once, no monthly fee) adds a Monday view, 24 recurring repair jobs, leases, deposits, expenses and a Year summary by Schedule E line.