Guides · 2026-10-16

How to Track Rental Income and Expenses for Schedule E Without Linking Your Bank

You can keep organized rental records without giving an app access to your bank account. For a small portfolio, a consistent manual system can be practical: record each transaction, identify the property, save the supporting document, and check the records against your statements.

The goal is to answer ordinary questions throughout the year. Who has paid? Which property had that plumbing expense? Can you find the invoice behind a total? Tax preparation becomes easier when those answers are already in your records.

This is general information, not tax advice.

Start with one record for every transaction

Choose a spreadsheet or rental ledger that you can maintain consistently. Use a separate row or entry for each payment or expense rather than keeping only a running total.

For income, capture the date received, property, unit or tenant reference, amount, payment method, and rental period covered. For expenses, record the date, property, vendor, amount, description, proposed category, and receipt reference.

Use consistent property names. If one transaction says “Oak Street” and another says “Oak duplex,” you may accidentally split the same property's totals. A short identifier that stays the same across your records and document folders avoids that problem.

Do not place account passwords or unnecessary tenant identifiers in transaction notes.

Keep payment status separate from money received

A rent schedule tells you what was expected. A transaction record tells you what actually arrived. You need both to understand payment status.

For each rental period, compare the amount due with the payments received. If a tenant pays in installments, record the individual receipts and associate them with the relevant period. Do not mark the entire month paid after receiving only part of the amount.

Keep the payment reference or other supporting evidence. A ledger entry is useful, but it should be possible to trace that entry to the actual payment.

If a balance is disputed, check the lease, payment evidence, and applicable requirements before communicating a conclusion. Clear records help establish what happened; they do not decide a legal dispute by themselves.

Use categories that support your tax preparation

Review the IRS instructions for Schedule E with your preparer when setting up categories. Organizing transactions around the reporting categories can reduce the work needed to assemble year-end totals.

Keep descriptions specific. “Plumber: repaired kitchen drain” is more useful than “house expense.” The description helps explain the category and lets your preparer review an uncertain item without reconstructing the event.

Maintain a review list for expenses whose treatment is unclear. Choosing a category in software does not establish that an amount is deductible or determine the correct tax treatment.

Separate routine expenses from potential improvements

A repair and an improvement can require different treatment. Avoid placing every contractor invoice into one repairs category simply because the work happened at a rental.

Save invoices that describe the actual work and flag larger projects or replacements for review. Record the property, project description, dates, and supporting documents together. Your preparer can then assess the treatment using the facts rather than a vague transaction label.

The IRS discusses rental expenses, improvements, and depreciation in Publication 527. Keep project records even when the payment already appears in your ordinary expense log. The bank statement alone may not explain what was purchased or installed.

Identify transactions that are not ordinary rental expenses

Money leaving your account is not automatically an expense for tax purposes. Transfers between your own accounts, owner contributions, loan principal payments, and purchases of assets need to remain identifiable.

Likewise, do not automatically treat every incoming payment as rent. For example, refundable security deposits generally have different treatment from rent payments. Advance rent and amounts retained from deposits can raise additional questions. The IRS provides an overview in Topic 414, Rental Income and Expenses.

Record what happened first. Ask your preparer how to classify uncertain transactions before including them in filing totals.

Keep receipts outside your memory

Create a document folder for each property and year. Save invoices and receipts with filenames that make them easy to recognize, such as a date, vendor, and short description.

Put the same reference in the transaction record. You should be able to move from an expense entry to its supporting document without searching through your entire email history.

For paper receipts, make a readable digital copy promptly. Check that the image includes the vendor, date, items, and amount. A blurry photograph is easy to overlook until you need it.

Keep an independent backup of your records and documents. If your chosen app stores information locally, establish its documented backup and recovery process before relying on it as your only record.

Reconcile manually each month

Bank linking is a convenience, not a requirement for comparing records with statements. Set aside a regular session to check each rental bank and card statement against your ledger.

Look for missing transactions, duplicated entries, refunds, transfers, and payments assigned to the wrong property. Check payment processor statements when applicable so the records explain both the tenant's payment and any fees or timing differences.

Do not count a credit card purchase again when you pay the card bill. Similarly, distinguish a transfer between your own accounts from a new receipt of rental income.

Write down unresolved differences and investigate them. A total that looks plausible is not the same as a reconciled record.

Prepare a useful year-end handoff

Before sending records to your preparer, review each property separately. Check income, expense categories, uncategorized transactions, potential improvements, and any shared costs requiring allocation.

Provide the relevant totals alongside supporting records, project details, and your list of questions. Include prior depreciation information and other documents your preparer requests.

Schedule E category totals organize information; they are not a completed tax return. Ownership structures, personal use, losses, depreciation, and other circumstances may require additional work.

Choose a tool around the work you actually do

A spreadsheet may be enough if you maintain it reliably. If checking rent status and assembling category totals has become awkward, Rent Ledger by Krishiv offers an installable web app that works offline, with rental data stored on your device and no account or bank linking.

It is free for 1 property. Pro is $29 one-time for unlimited properties, Schedule E PDF/CSV export, free updates, and up to 5 devices. Payments use Paddle, and there is a 14-day no-questions refund. Schedule E reporting is US-only.

Whichever system you choose, make recording transactions and checking statements part of the same routine. Organized records depend on consistent entries, clear evidence, and regular review.