Rent Ledger → Schedule E Categorizer
Paste your rent ledger (or upload a CSV) and get every transaction auto-sorted into IRS Schedule E lines — rents received, repairs, taxes, insurance, management fees, mortgage interest, and the rest — with per-line totals, manual overrides for anything the auto-match gets wrong, and a printable summary you can hand to your CPA. No sign-up, no upload: everything runs in your browser.
2026-01-05, January rent - Unit A, 1850 and 2026-01-12, Plumber - kitchen sink leak, -245. Positive amounts are treated as income, negative as expenses (flip with the checkbox if your file does the opposite). Don't have data handy? Load the sample ledger below to try it out.Private: this text never leaves your browser — categorization happens on your device.
Your Schedule E summary
Totals by Schedule E line
| Line | Category | Amount | Count |
|---|
Transactions (click a category to override)
Rows marked Needs review couldn't be matched confidently — pick the right Schedule E line from the dropdown.
| Date | Description | Amount | Schedule E category | Match |
|---|
How this categorizer works (and its limits)
How does the auto-categorization work?
Each transaction's description is scored against keyword sets for the real IRS Schedule E lines — Line 5 auto & travel through Line 18 other expenses, plus Line 3 rents received. The highest-scoring line wins; weak matches are flagged "Needs review" and you can override any row with a dropdown. It's pattern matching, not judgment: review every line before you rely on it.
Repairs vs. improvements — can it tell the difference?
No, and no keyword tool can. A $200 faucet fix is a repair; a $12,000 roof is an improvement that must be capitalized and depreciated (27.5 years for residential rental property under MACRS). The categorizer puts both under Repairs because the description looks like work done — you or your CPA must reclassify big-ticket items. When in doubt, treat anything that extends the property's life as a capital item.
What about security deposits?
Security deposits you hold are not income when received (and returning them is not an expense) — only a forfeited/applied deposit counts. The tool flags deposit lines as "Excluded — not income/expense (review)" so they don't inflate your numbers. Same logic: owner draws, transfers between your own accounts, and mortgage principal are excluded from totals.
Should I use this instead of accounting software?
For tax-time organization, this is a legitimate shortcut: many landlords keep a simple ledger all year and categorize once. But dedicated rental accounting (even a spreadsheet with these same categories) beats a once-a-year scramble. See our landlord bookkeeping guide for a year-round system.
Is my data stored or sent anywhere?
No. Categorization runs entirely in your browser with JavaScript. Close the tab and it's gone — nothing is uploaded, stored, or transmitted.
Related: Free Rent Ledger Spreadsheet · Landlord Bookkeeping Guide · Rental Property Tax Deductions · Best Tax Software for Landlords