April Does Not Need a Shoe Box. It Needs a Year You Already Logged.

What a CPA actually asks for in March

Most small landlords do not fail at tax time because they picked the wrong software. They fail because the year never existed as numbers. A tax preparer who handles a handful of doors typically wants four piles, not a story:

1. Rent actually received — by property, for the calendar year. Amount paid, not amount due, not “they said they would catch up.”
2. Owner costs — insurance, repairs, utilities you paid, property tax, mortgage interest (from the Form 1098 the lender already mailed), management fees, advertising, supplies. One row per bill with a date, a property, a category, and a receipt you can still find.
3. Deposits still held — money you have not refunded and have not lawfully kept. This pile is a liability list, not an income total.
4. What changed — units that sat empty, move-outs, deposits you kept for damage. Those facts explain the other three piles. They are not a fifth tax form.

Depreciation, cost basis, and improvements vs repairs are the CPA’s job (or a cost-segregation study’s job). A spreadsheet that pretends to depreciate the building is usually worse than a spreadsheet that leaves line 18 blank and says so.

You can keep those four piles on paper. The point of a workbook is that April is a filter and a print, not a reconstruction. Smart Files Shop (Etsy: SmartFilesShopUS) sells the digital downloads linked below. Everything named here was state=active on the 5 September 2026 catalog pull (94 live listings). Instant download — nothing ships. These are bookkeeping templates. They are not property-management software, not a filed return, and not tax, legal, or investment advice. Your bank statement and a CPA still win if numbers disagree.

Rent collected is not amount due

A rent roll that only stores “$1,800/month” is a lease file. Tax time needs the money that hit the account. If a tenant paid $1,600 of $1,800 in December, rental receipts for December are $1,600. The $200 still owed is a receivable, not 2026 income on a cash-basis return — which is how most small landlords actually report, unless a preparer has put them on accrual.

Three columns that get mashed together, and should not:

• Amount due — the lease number. Useful for “who is late.” Not the tax number.
• Amount paid — what you received. This is the income log.
• Late fee assessed vs late fee paid — an assessed fee you never collected is not income. A fee you collected is.

Recommended tool for the payment log — our listing, disclosed as ours:

Landlord Rent Roll Spreadsheet | Tenant Payment Log Excel

Listing 4483585796 · $6.99 · state active (Etsy Open API catalog pull, 5 September 2026)

This is the shop’s main landlord workbook for monthly collections. Use it when the problem is “who paid, who is partial, what repairs cost this month.” Live listing copy names a dashboard of rent collected, expenses, and net; a property and unit tracker; a tenant and lease database; a rent payment log with paid / partial / late flags; and an expense and maintenance tracker. Open START-HERE first. Replace the sample properties with your doors, then log rent as it arrives — not in a March panic.

It is not a deposit-remaining ledger and not a tax form. Lease end dates belong on the tenant/lease list in this file. That is operations. The tax-time extract is the year’s amount-paid total, by property.

Open the live Etsy listing →

Deposits are not rental income (until they are)

A security deposit you still hold is money you owe back, minus lawful deductions you have actually taken. Folding “$1,800 rent + $1,800 deposit” into one January total is how a first-year landlord overstates income and then cannot explain the refund in June.

A clean deposit ledger answers four questions per deposit ID:

1. How much did you receive, and on what date?
2. What did you itemize as a deduction (cleaning, damage, unpaid rent, keys) — with a date?
3. What refund did you actually send?
4. What is still remaining? Remaining should be a formula: received − deductions − refunds. Do not type the remaining number.

When you lawfully keep a deduction, that amount may become income in the year you keep it — your preparer decides the character. The ledger’s job is to show the math, not to choose the tax line.

Security Deposit Tracker Spreadsheet | Landlord Refund Deduction Log Excel Sheets

Listing 4562846904 · $6.99 · state active

Standalone deposit file. Tabs named on the live listing and in the on-disk workbook used to write the sibling rent-roll guide: Start Here, Dashboard, Properties, Deposit Ledger, Deductions, Refunds Paid, and Lists (dropdown helper). One row per deposit. Return-by is a date you enter — the sheet treats a remaining balance after that date as a reminder, not a legal finding. It does not look up deposit-return law for any state.

Not a rent roll. Purple SAMPLE rows are there so formulas are visible before you overwrite them.

Open the live listing →

Owner costs need categories, not a pile

A shoe box of receipts is not a category. A CPA will re-sort them anyway, but the re-sort is cheaper if you already tagged each row as insurance, repairs, supplies, utilities, advertising, legal, taxes, or “ask the CPA.” Two rules that save the meeting:

• One property per row. A roof on Oak Street is not a roof on Maple. Mixing properties is how a profitable door hides an empty one.
• You set deductible yes/no. A template must not decide deductibility. Personal paint on the house you still live in is not a rental repair. A capital improvement (new HVAC, new roof) is often depreciated, not expensed in the year you paid the invoice — and a spreadsheet that auto-expenses it will fight your preparer.

Mortgage interest and property tax often arrive as Forms 1098 / local tax bills. Log them so the year ties out; do not invent the 1098 number from the monthly ACH. The lender’s form wins.

The Schedule E helper — and what it is not

US individual landlords commonly report long-term rental real estate on Form 1040 Schedule E, Part I. That form has labeled lines (rents received, advertising, auto and travel, cleaning and maintenance, insurance, legal, management, mortgage interest, repairs, supplies, taxes, utilities, depreciation, and other). A workbook that maps your category totals onto those labels is a packet. It is not the form, and it is not a filing.

Recommended tool when you want rent, owner costs, and deposits in one Excel file — our listing:

Landlord Expense Deposit Tracker Excel | Rental Security Deposit Schedule E Spreadsheet

Listing 4562934360 · $7.99 · state active

This is the file built for the year-end packet. Live listing and the opened workbook used on the sibling rent-roll page name these tabs: Setup Instructions, Properties & Units, Rent Roll, Expenses by Category, Security Deposits, Annual Summary, Schedule E Helper, and Lists.

What that file actually does, so you do not over-claim it:

• Rent Roll — Date, Unit ID, Amount due, Amount paid, Late fee, Method, Balance due, Status. Balance due is Amount due + Late fee − Amount paid. Status comes from those amounts.
• Expenses by Category — a Deductible Yes/No flag you set. The file does not decide deductibility. A Schedule E line fills from the helper tab.
• Security Deposits — remaining held = amount received + interest you type − itemized deductions − refund paid. Interest is an amount you enter; the file does not calculate statutory interest.
• Annual Summary — follows the year you type. Rent collected on that sheet is Amount paid, not Amount due.
• Schedule E Helper — maps category totals to common Schedule E Part I labels as a bookkeeping convenience. The sheet itself says it is not a tax form and that depreciation (line 18) is not calculated here. Do not file that tab. Hand the totals to a preparer with the 1098s and the closing statements.

Buy this instead of the standalone rent roll plus the standalone deposit file if you want those jobs in one place. It is still not a vacancy tracker, not a bank feed, and not e-file.

Open the live listing →

Empty days are a planning number, not a tax line

Days vacant × monthly rent ÷ 30 is a useful estimate of what empty time cost you. It is not a Schedule E deduction. You already did not collect that rent; you do not also deduct the rent you did not collect. What you can usually log, with a preparer’s sign-off, are the real costs of the empty period: make-ready cleaning, paint, locks, advertising the listing, and utilities you kept in your name.

Keep vacancy math on its own ledger so it cannot leak into “repairs” or into rental income.

Landlord Vacancy Tracker Spreadsheet | Tenant Turnover Make Ready Log Excel Sheets

Listing 4563056483 · $6.99 · state active

Turnover Ledger is one row per notice-to-new-lease event. Days vacant, vacancy-loss $, make-ready $, and status are formulas. Vacancy loss $ uses monthly rent ÷ 30 — a planning estimate, which is what the Dashboard note in the file says, not a tax figure. Make-Ready is a walkthrough checklist (clean, paint, carpet, locks, smoke/CO). Costs roll to the ledger by Turnover ID. Work Orders are ongoing repairs by unit so an HVAC service on an occupied door does not have to pretend it is a make-ready.

Not a rent roll. Not a deposit ledger. Use it when a unit is on notice or empty so April does not have to reconstruct turnover week from texts.

Open the live listing →

A year you can close in one sitting

If you do the work monthly, tax time is a filter. If you do not, tax time is archaeology. A close that survives April is six steps, once a month, twenty minutes:

1. Bank first. Every rent ACH, check, or cash deposit gets a payment-log row. If the bank shows $1,800 and the log shows $1,600, the log is wrong.
2. Bills second. One expense row per invoice you paid for the rental. Category from a short list. Receipt filename or envelope number in a notes cell.
3. Deposits third. If nobody moved, this step is “no change.” If someone moved, itemize deductions, log the refund you sent, and let remaining calculate.
4. Empty doors fourth. Notice date, move-out, make-ready spend, new lease start. Do not hide those days on the rent roll as a blank month.
5. One-page totals. Rent collected (amount paid), expenses, net, deposits still held, vacant doors. That page is the monthly packet. Twelve of them are the year.
6. Do not “fix” the year in the same cells. If you find a missed plumber bill in March, add a dated row. Do not silently edit January so the story looks cleaner than the bank.

In January, export or print: Annual Summary, expense register, deposit remaining, the 1098s, property-tax bills, and a folder of PDFs. That is what you hand a preparer. The Schedule E helper tab is a map of those totals onto common labels. It is a conversation starter, not the return.

If you also sell on Etsy, that shop is usually a Schedule C activity, not Schedule E. Do not dump marketplace payouts into the rent roll. The shop’s seller workbook is a different job: Etsy Seller Bookkeeping Spreadsheet (listing 4533025325 · $6.99 · active). Guide: how to track Etsy seller fees and profit.

How to choose

Practical stack for tax time: the combined expense-and-deposit workbook if you want one file. Or the rent roll plus the security-deposit file if you already close months on the rent roll. Add vacancy only when a unit is on notice or empty. Do not buy all four to feel complete if you have not logged a week of rent yet.

Files open in Microsoft Excel and Google Sheets (upload in Drive). The workbooks opened for the sibling landlord guides do not use macros. The security-deposit listing copy says it is not tested in Apple Numbers — do not use Numbers.

Love Guarantee and custom work

Every listing on this page carries the same 14-day Love Guarantee.

Love Guarantee (14 days): Message Smart Files Shop if the file is not right — free fix, free small customization, or refund.

Free small customizations (typical examples): rename a column, add a header, change a property label, swap a category name, put your unit list on the dropdowns.

Paid customs — shop-wide / typical menu; message for a quote before any extra charge. Individual listings may quote lower for tweaks already in scope for that file — always by quote, never a surprise invoice. For paid customs, timeline is usually 1–3 business days after we lock the brief.

• Light custom $15–$29 — property names / header on every tab; extra categories
• Standard custom $39–$79 — extra unit slots, a board-report tab, a branded refund-letter data export
• Deep custom $89–$149 by scope — branding, data import, multi-entity

The shop says yes to requests like “add our property names to the rent-roll dropdowns.” It does not take full bookkeeping outsourcing, tax filing, or property-management work. One free polish pass is included on paid customs after first delivery.

What these files will not do

They will not connect to your bank, AppFolio, or a CPA’s e-file. They will not file Schedule E, compute depreciation, apply passive-loss limits, or tell you your state’s deposit-return deadline. They will not make a full-time physician a real-estate professional. They will keep a small landlord from reconstructing the year out of a text thread and a shoe box of plumber receipts.

If you want the files, buy them on Etsy through the live links above. This page is a guide, not a checkout. Browse the rest of the shop at etsy.com/shop/SmartFilesShopUS.

FAQ: Rental income, expenses, and tax-time logs