Landlord Schedule E Ledger: Rental Income & Expense Tracker, Auto Totals by IRS Line, One-Time Purchase, No Subscription
Price notice: the Ledger is $9 now. On December 2 the price goes to $15. Anyone who buys before then pays $9.
Launch price $9. First buyers: enter code FIRST2 at checkout for $2 off.
Free rent logs make you add up the columns yourself. This one does it for you: log each payment once, pick the Schedule E line from a drop-down, and the Summary tab totals every line for every unit, plus total expenses (line 20) and net income or loss (line 21). You pay once for the file. No subscription, no login, nothing to renew.
A spreadsheet for small landlords to log rent and expenses by unit all year, then see the totals on the same line names as IRS Schedule E (Form 1040), Part I, tax year 2025.
You log each payment on one sheet: date, unit, Schedule E line (picked from a drop-down), a short description, and the amount. The Summary tab adds everything up for you. Each column is a unit, with a Total column, and lines 20 (total expenses) and 21 (net income or loss) are worked out as on the form. A check row shows a number other than 0.00 if an entry has a missing or misspelled unit or line.
It is an organizer. It does not file anything, give tax advice, or decide what you can deduct. Please confirm your figures with a tax professional.
What's included
- Schedule_E_Ledger_BLANK.xlsx: the empty ledger, ready for your own units
- Schedule_E_Ledger_SAMPLE.xlsx: the same ledger filled with one fake year (2025) for three made-up units, so you can see how it works
- Quick_Start.pdf: a 2-page guide with setup steps and a table of the Schedule E line names with typical items listed beside each, as a general guide only
What the file does:
- Works for 1 to 4 rental units
- Uses the Schedule E Part I line names from the 2025 form: lines 3 and 5 through 19, plus total expenses (20) and net income or loss (21)
- Tabs: Start Here, Summary, Units, Entries, Lists
- Room for 999 entries
- Plain .xlsx with no macros
- Standard .xlsx file with plain formulas, no add-ons to install
- Make a copy for each tax year
Not covered: royalties (line 4), loss limits (lines 22 to 26), Schedule E Part II and later, and fair rental days per property. The line names are from the 2025 form and the IRS may change them in later years.
How this was made
The line names were taken from the IRS 2025 Schedule E, and the sample file's totals were checked against a separate calculation. We are not tax professionals.
Free update to the 2026 form for buyers.
Refund
Digital file, so there is no return shipping. If it does not open or does not work as described here, message us within 30 days of purchase for a full refund.
Want to try it first? Download the free one-property sample: https://payhip.com/b/POwTY