Expense Tracking Spreadsheet Template

The simplest system that works is a single ledger with one row per transaction, a column for the IRS Schedule E line each item belongs to, a separate column for capital improvements, and a receipt reference on every row. Run it from a dedicated bank account and close it out once a month. At tax time you add up each column; when you sell, the improvement column gives you the basis records that decide how much tax you owe.

This page gives you that template (copy the tables below into any spreadsheet), explains each category, and walks through one full month for a hypothetical duplex. It is general information, not tax advice. Tax rules change and your situation may differ, so confirm anything material with a CPA or enrolled agent.

Why track by Schedule E line

If you own a residential rental as an individual (or through a single-member LLC that is disregarded for tax), you generally report it on Schedule E (Form 1040), Part I. That form lists specific expense lines. When your ledger uses the same categories, year-end is a matter of totaling columns instead of re-sorting a year of receipts. It also makes your records easy for a preparer to review and easy to defend if the IRS ever asks how you got a number.

The line names below are taken from the current Schedule E form posted on IRS.gov (the 2025 revision, the latest available when this page was written). The IRS can renumber or rename lines in a new year, so glance at the current form each January and adjust your column headings if anything changed.

A few income items surprise new landlords. IRS Publication 527 treats advance rent as income in the year you receive it, whatever period it covers. If a tenant pays one of your bills (say, the water bill) and deducts it from rent, the payment is still rental income to you, and you can deduct the bill if it is a deductible expense. If a tenant paints the unit instead of paying two months of rent, you include the value of the rent you gave up and can deduct the same amount as an expense. Record these as two rows so the ledger shows both sides.

If you are a cash-basis taxpayer, as most individuals are, you do not deduct rent you never collected, because you never counted it as income in the first place. Note unpaid rent in your tenant records, not as an expense row.

Set up a separate bank account first

Before you build any spreadsheet, open a checking account used only for the rental. Every rent payment lands there and every property bill leaves from there. That one step does more for accurate books than any template, because your bank statement becomes a complete, dated, third-party record of every rental transaction.

• Deposits: have tenants pay directly into the rental account. Do not let rent pass through your personal account first.
• Payments: pay contractors, utilities and the mortgage from the rental account. If you must use a personal card in an emergency, reimburse yourself from the rental account and note the receipt number on that row.
• Reserves: many landlords keep a second savings account for repair and capital reserves and transfer a fixed amount each month. Transfers between your own accounts are not income or expense; record them in a memo column so they don’t inflate either total.
• Security deposits: some states have rules on where deposits are held and whether interest is owed. Check your state before mixing deposits with operating cash; our state legal guides and security deposit interest guide are a starting point.

If you own more than one property, either open one account per property or add a property column to the ledger and tag every row. Schedule E reports each property separately (columns A, B and C on the form), so you need per-property totals either way.

The copyable ledger template

Copy the column headings below into a spreadsheet. Use one tab per year. Each transaction gets its own row; never net two items together (for example, don’t record rent minus a repair as one figure).

Add a summary tab with one row per Schedule E line and a formula that totals each line by month (a SUMIFS on the line column works in any spreadsheet). The summary should end in three numbers: total income, total deductible expenses, and total capital additions for the year.

Receipts and how long to keep records

A bank statement proves you paid someone; a receipt or invoice proves what you paid for. You need both, especially for anything that could be read either as a repair or an improvement. Photograph paper receipts the day you get them, name the file with the same reference you typed in the ledger, and store everything in one folder per tax year.

The IRS page “How long should I keep records?” ties retention to the period of limitations for the return:

• 3 years after filing in the normal case. Returns filed early are treated as filed on the due date.
• 3 years from filing or 2 years from paying the tax, whichever is later, if you file a claim for credit or refund after filing.
• 6 years if you do not report income you should have reported and it is more than 25% of the gross income shown on the return.
• 7 years if you file a claim for a loss from worthless securities or a bad debt deduction.
• Indefinitely if you do not file a return or file a fraudulent one.

For rental owners the most important rule is the one about property. The IRS says to keep records relating to property until the period of limitations expires for the year in which you dispose of it, because you need them to figure depreciation and your gain or loss on sale. In practice that means the closing statement from your purchase, every improvement invoice, and your depreciation schedules stay in the file for as long as you own the building, plus at least three years after the year you sell it. If you acquired the property in a 1031 exchange, the IRS says to keep the records for the old property too, because your basis carries over.

Keep copies of your filed returns as well. Your insurer, lender or state may require some records longer than the IRS does.

Repairs vs. improvements: getting the line right

This is the classification that matters most, because it decides whether a cost is deducted this year or recovered over decades. IRS guidance on the tangible property regulations says a cost is an improvement, and must be capitalized, if it is for:

• A betterment: fixing a material defect that existed when you bought the property, a material addition or expansion, or a material increase in capacity, efficiency, strength or quality.
• A restoration: for example replacing a major component or a substantial structural part, or returning a building that had deteriorated to a state of disrepair to working condition.
• An adaptation: converting the property to a new or different use.

For buildings, the analysis applies separately to the building structure and to each key building system: plumbing, electrical, HVAC, elevators, escalators, fire protection and alarm, gas distribution, and security. Publication 527’s Table 1-1 lists common improvements, including additions, new roofs, central air, water heaters, wall-to-wall carpeting, insulation and kitchen modernization.

Three simplifying rules can let you deduct some costs that would otherwise be capitalized. Each has conditions and most require an annual election statement with your return:

• De minimis safe harbor: taxpayers without an audited (applicable) financial statement can elect to deduct amounts up to $2,500 per invoice or item, if they treat them consistently in their books.
• Safe harbor for small taxpayers: if average annual gross receipts are $10 million or less and the building’s unadjusted basis is $1 million or less, total yearly repairs, maintenance and improvements on it can be deducted if they don’t exceed the lesser of 2% of the building’s unadjusted basis or $10,000.
• Routine maintenance safe harbor: recurring work you expect to do more than once in the 10 years after the building is placed in service, to keep it in ordinarily efficient operating condition.

Your ledger doesn’t need to decide every borderline case on the day you pay. Record anything over a few hundred dollars that replaces a component in the Capital column with a note, keep the invoice, and settle the treatment with your preparer at year-end. Moving a figure from Capital to Repairs later is easy. Rebuilding a missing invoice is not. Our tax deduction checklist and tax deduction cheat sheet cover the deductible side in more detail.

Track capital improvements and basis for the day you sell

Your basis starts with what you paid for the property plus certain purchase costs, minus the value of the land (land is never depreciated). Publication 527 says to add to basis the actual cost of any addition or improvement, including direct costs like materials and labor, but not your own labor. It also says to keep separate accounts for depreciable improvements made after the property is placed in service, because each improvement is depreciated on its own schedule. Residential rental buildings and structural improvements to them use a 27.5-year recovery period under the general depreciation system; appliances and carpets are 5-year property.

Keep a capital improvement log as its own tab, with these columns:

• Date placed in service
• Description and location (for example “Unit B water heater, 40 gal”)
• Total cost including labor, permits and related design or survey fees
• Recovery class (27.5-year, 15-year land improvement, 5-year, and so on)
• Depreciation taken each year
• Date retired or replaced, if the component is later replaced (a new improvement can sometimes allow the old component’s remaining basis to be written off; ask your preparer)

Why this matters: when you sell, your taxable gain is roughly the sale price minus selling costs minus your adjusted basis. Adjusted basis is your original basis plus improvements minus depreciation allowed or allowable. Every improvement you can document lowers your gain. Depreciation lowers basis, and the part of the gain created by depreciation (unrecaptured section 1250 gain) can be taxed at a maximum 25% rate, according to IRS Topic 409. If you are thinking about selling, put your basis and improvement totals into the keep-or-sell rental property calculator to see what you would actually net after tax, and compare that with keeping the property or doing a 1031 exchange.

A monthly close routine (about 30 minutes)

Pick a fixed day, such as the 5th, after rent has cleared. Then work through the same steps every month:

1. Download the statement for the rental account (and the reserve account, if you have one).
2. Enter or import every transaction into the ledger. Each bank line should become one or more ledger rows; a loan payment, for example, becomes an interest row and a principal row.
3. Assign a Schedule E line to every row. Anything you’re unsure of goes to Capital with a note.
4. Match receipts. Every expense and capital row should have a receipt reference. Chase any missing ones now, while the vendor still remembers the job.
5. Reconcile. Opening bank balance plus deposits minus withdrawals should equal the closing balance on the statement. If it doesn’t, find the gap before moving on.
6. Check rent received against rent due. Compare the rent roll with deposits and follow up on anything short, in writing.
7. Review the month’s totals against the same month last year and against your budget. A utility bill that doubled may mean a leak.
8. Move the reserve transfer for capital expenditures, and note it in the memo column.
9. Back up the ledger and the receipt folder.

Quarterly, add one more step: look at year-to-date net income and decide whether you need to make an estimated tax payment. Annually, request Form 1098 from your lender, the property tax bill and the insurance declarations page, and make sure the ledger matches all three.

Worked example: one month for a duplex

Hypothetical: a side-by-side duplex. Unit A rents for $1,350 and Unit B for $1,400. The owner pays water and sewer; tenants pay their own electricity and gas. The loan payment is $1,620 a month with no escrow (the owner pays taxes and insurance directly, and neither falls due in March). The rental checking account opens March with $6,000.00.

The principal row carries $515.00 in the Non-P&L memo column (the $1,620 payment minus $1,105 of interest). Here is how the month adds up.

Income (Schedule E line 3)

$1,350.00 + $1,400.00 + $50.00 late fee = $2,800.00. The late fee counts as rent. Charge one only if the lease provides for it and your state allows it; some states cap late fees or set a grace period.

Deductible expenses

• Line 12, mortgage interest: $1,105.00
• Line 17, utilities: $142.00
• Line 14, repairs: $185.00
• Line 15, supplies: $46.00
• Line 7, cleaning and maintenance: $80.00

$1,105 + $142 + $185 + $46 + $80 = $1,558.00.

Net rental income before depreciation

$2,800.00 − $1,558.00 = $1,242.00. Depreciation is figured once a year, not monthly, so it is not in this number.

Cash flow and reconciliation

Cash out was $1,558.00 of expenses + $515.00 of principal + $1,450.00 for the water heater = $3,523.00. Net cash flow: $2,800.00 − $3,523.00 = −$723.00. Closing bank balance: $6,000.00 − $723.00 = $5,277.00, which should match the March statement exactly.

This month shows why profit and cash are different. The duplex earned $1,242 of taxable income before depreciation but the bank balance went down by $723, because the water heater and loan principal used cash without being current-year expenses. The water heater is on the capital log for now. It may qualify for the de minimis safe harbor (the invoice is under $2,500) if the owner elects it and treats it that way consistently. If not, it is depreciated, and either way the invoice belongs in the permanent property file.

Common mistakes to avoid

• Deducting the whole mortgage payment. Only interest is deductible. Principal reduces the loan.
• Expensing improvements. A new roof or a kitchen remodel is capital, not a repair, unless a safe harbor applies. Misclassifying it overstates this year’s deductions and understates basis.
• Counting security deposits as income when received, or forgetting to count the part you keep.
• Mixing personal and rental spending on the same card or account, which makes every statement line a judgment call.
• No receipt reference. A row with no matching document is hard to support three years later.
• Throwing away the purchase file. The closing statement and improvement invoices are needed until the limitations period runs out for the year you sell.
• Deducting prepaid insurance all at once. Publication 527 says that if you pay a premium for more than one year in advance, you deduct only the part that applies to each year.
• Waiting until April. Classifying twelve months of transactions at once is where most errors come from. Close monthly.

For a broader introduction to landlord bookkeeping, see our guide to rental property accounting basics; to check whether your expenses are in a normal range, try the expense ratio calculator.