A rental property expense spreadsheet should record each transaction, identify the property, separate money received from money paid, and link every entry to supporting evidence. Then reconcile it to the bank statement. A category total without that check can hide missing payments or duplicate expenses.
This guide provides a copyable eight-column ledger for a long-term rental. It tracks actual transactions, not projected returns. Use the broader rental property management guide for operating responsibilities; use this ledger to explain where the money went.
Set up the ledger
Create a blank Excel or Google Sheets sheet. Add the eight column labels below across its first row. Freeze that row and turn on filters. Enter dates as YYYY-MM-DD and format the amount columns to two decimal places. Copy the fictional transactions later in this guide to practice checking totals before using your own records.
Every sample row is fictional, including the property name, dates and amounts. These are not Vidit's transactions or market estimates. Keep a practice sheet, then start a separate blank ledger with the same header for your actual records.
This is a manual template, not an app or a prebuilt workbook. It has no formulas, automatic bank feed, tax calculation or receipt attachments. You can add a pivot table in your spreadsheet, but review its range whenever you add rows.
What each column records
Keep one ledger tab per bank account so its totals can reconcile to one statement. The property column lets you filter several rentals within that account. Keep reserve and deposit accounts on separate tabs if you track them too.
| Column | What to enter |
|---|---|
| date | The transaction date, using YYYY-MM-DD. Note timing differences during reconciliation. |
| property | A consistent property or unit identifier. |
| category | A stable label, such as Management fee or Mortgage principal. |
| description | The vendor, purpose and any useful split-payment explanation. |
| cash in | Money entering this account, as a positive amount. Otherwise enter 0.00. |
| cash out | Money leaving this account, as a positive amount. Otherwise enter 0.00. |
| receipt reference | The filename or reference for the invoice, statement or rent record. |
| reconciled | No until matched to evidence and the statement; Yes after checking. |
Use two decimal places without dollar signs or thousands separators in the amount columns. Put a payment in one direction only. Split a transaction into several rows when it contains different categories, and give those rows the same reference.
Save receipts somewhere you control. A reference like SAMPLE-REPAIR-001 is only a label, not proof that an invoice exists. Keep account numbers, tenant personal details and sensitive documents out of any copy you share.
Keep unlike payments separate
The category is a bookkeeping label, not a decision about deductibility. IRS Publication 527 distinguishes rental income, rental expenses, improvements and depreciation. At this guide's October 2026 source check, the linked publication was the 2025 edition for preparing 2025 returns. It is not evidence of 2026 tax thresholds. This template is educational recordkeeping, not legal or tax advice.
- Operating costs. Group management fees, routine repairs, owner-paid utilities, insurance and property taxes separately. Add categories for your actual business. A cash payment and its tax treatment are different questions.
- Mortgage interest and principal. Split them using the lender's statement. In the sample, $650 interest and $350 principal explain one $1,000 bank debit. Do not also enter a third $1,000 expense. Publication 527 explains that principal payments cannot simply be deducted as rental expenses.
- Escrow funding. Label money sent into lender escrow separately from actual tax and insurance disbursements. Do not count both as the same expense. The sample assumes tax and insurance are paid outside escrow.
- Reserves and transfers. Moving your money into another account is not a repair bill. Exclude internal transfers when assessing property performance, but include them when reconciling each account.
- Refundable deposits. Track receipt, transfer, refund and any later application separately from rent. Publication 527 says a deposit intended to be returned is not income when received; a deposit intended as final rent is advance rent. The sample transfer is illustrative, not a statement of your jurisdiction's deposit-handling rules.
- Capital work. Flag potential improvements for review instead of hiding them under routine repairs. Publication 527 describes betterments, restorations and adaptations as improvements that require capitalization, subject to applicable rules. Keep invoices and project details. Depreciation belongs in a separate tax schedule, not as invented cash leaving the bank.
Check the fictional month
The sample represents one checking account for "Oak rental" in September 2026. Assume a fictional opening balance of $2,000 and that every row has cleared. Put the dates, categories and amounts below into your practice sheet. Use sample references, not real receipts, and mark these assumed-cleared entries Yes.
| September transaction | Money movement |
|---|---|
| 1 Sep, rent | In $2,200.00 |
| 1 Sep, deposit received | In $2,000.00 |
| 2 Sep, deposit transfer | Out $2,000.00 |
| 3 Sep, mortgage interest | Out $650.00 |
| 3 Sep, mortgage principal | Out $350.00 |
| 4 Sep, management | Out $220.00 |
| 8 Sep, repair | Out $175.00 |
| 10 Sep, utilities | Out $85.00 |
| 12 Sep, insurance | Out $110.00 |
| 15 Sep, property tax | Out $200.00 |
| 20 Sep, capital work | Out $900.00 |
| 25 Sep, reserve transfer | Out $300.00 |
The roof payment is an illustrative partial payment for a replacement project, not a quote for a roof. The two mortgage rows share one sample statement reference because they explain one bank debit.
| Balance check | Amount |
|---|---|
| Opening balance | $2,000.00 |
| Cash in | $4,200.00 |
| Cash out | $4,990.00 |
| Closing balance | $1,210.00 |
Cash in is $2,200 rent plus $2,000 refundable deposit. Cash out is $790 operating costs, $1,000 mortgage, $900 capital work, $300 reserve transfer and $2,000 deposit-account transfer. The balance is $2,000 + $4,200 - $4,990 = $1,210.
Property performance answers a different question. Collected rent of $2,200 minus $790 operating costs leaves $1,410 before financing and capital work. Subtract the $1,000 mortgage payment to get $410, then the $900 capital payment to get negative $490 before income taxes. The $300 reserve transfer leaves checking $790 lower for the month. The deposit receipt and matching transfer cancel in this checking-account calculation; neither is rental profit.
These are simplified cash records, not taxable income or a forecast. For the distinction between cash before and after financing, see levered versus unlevered cash flow.
Reconcile before closing the month
- Collect the records. Open the bank statement, rent receipts, lender statement and paid invoices. Enter missing activity and check the property labels.
- Match each bank line. Check its date, direction and amount. For split transactions, add the ledger rows and match their combined total to the bank line. Mark them Yes only after checking.
- Investigate differences. Look for duplicates, fees, refunds, uncleared payments and transfers posted in different periods. Do not add a made-up expense to force agreement. Document outstanding items separately.
- Check the balance. For cleared activity, opening balance plus cash in minus cash out should equal the statement's closing balance. Retain the statement and a dated, reconciled copy of the ledger.
If a manager sends a net distribution, obtain the owner statement. Rent collected less fees and bills must explain the distribution and changes in funds the manager holds. Do not record the distribution as rent and also record the same gross rent. Supermode's out-of-state rental guide covers oversight of that reporting relationship.
Frequently asked questions
Can I use this for several properties?
Yes. Use consistent property identifiers and filter category totals by property. Reconcile at the account level first. If you need tenant balances, unpaid invoices or several people entering records, this simple cash ledger may be insufficient.
Does every cash-out row reduce taxable rental income?
No. Principal, transfers and refundable-deposit movements are different from deductible expenses. Improvements may require capitalization, and deduction limits or personal use can matter. The IRS describes Schedule E as a form for reporting rental real-estate income or loss. Have a qualified tax professional review your records and current rules.
What should I send my accountant?
Send the reconciled ledger, category totals, statements, supporting invoices and a separate list of capital projects, deposit movements and unresolved items. Keep the original documents. A spreadsheet alone does not establish the correct tax treatment.