Rental Property Bookkeeping from Bank Statements

TL;DR If you own one or a few rental properties, your bank statements can be the backbone of simple, reliable books. Convert each month's statement to a spreadsheet, check it balances, then tag every transaction with a property and a category: rent received, security deposits, repairs, mortgage payments, insurance, property tax, utilities and management fees. Treat security deposits and the principal part of mortgage payments separately from income and expenses. At year end, a pivot table by property and category gives your tax preparer a clean summary with the statements as backup.

Many small landlords start out tracking their rentals in a notebook or not at all, then scramble at tax time to work out what came in and what went out. Bank statements already contain most of that information: rent payments, repair bills, insurance premiums, mortgage payments and more. The trick is turning a pile of PDFs into something organized by property and by category.

This guide shows a practical approach for landlords with one to a handful of properties, whether you use a spreadsheet or plan to move into accounting software later. It's written for clarity rather than any specific tax system.

Disclaimer: This article is general information about record keeping, not tax, legal or accounting advice. How rental income and expenses are treated, what's deductible, and what records you must keep depend on your country, your situation and current rules. Work with a qualified tax professional for your circumstances.

Start with a separate account if you can

The single biggest improvement to rental bookkeeping is keeping rental money in its own bank account. When rent arrives in the same account as your salary and grocery spending, every transaction needs sorting, and personal and rental items get mixed up.

If you have more than one property, some landlords use one account per property; others use one account for all rentals and tag each transaction by property. Either works. One account per property makes separation automatic; one shared account is simpler to manage but needs consistent tagging.

If you've been using a personal account, you can still build good books from it. You'll just spend more time marking which transactions belong to the rental. Consider opening a dedicated account going forward.

Gather your statements

For the period you're working on, usually a calendar or tax year:

1. Download monthly PDF statements for every account that touches the rentals: the rental checking account, any savings used for reserves, the credit card you use for repairs and supplies, and the mortgage statements from your lender.
2. Check the chain. Each statement's closing balance should equal the next statement's opening balance.
3. Name the files consistently, such as rental-checking-2026-04.pdf.

If months are missing, how to get old bank statements explains the usual options.

Convert and verify

Convert each statement into a spreadsheet with one row per transaction: date, description, and a signed amount (money in positive, money out negative). SheetStatement does this and checks that each statement's opening balance plus transactions equals its closing balance, so you know nothing is missing. You can also copy and paste or use Excel's PDF import; our comparison of PDF to Excel methods for bank statements covers the options.

Combine all months into one table, with columns for the account and the source file.

Set up your columns

Add these columns to your transaction table:

Choose sensible categories

Keep the list short enough to use consistently. A typical starting point for a small landlord:

Money in

• Rent received
• Late fees
• Other income (laundry, parking, pet fees)
• Security deposits received (not income, see below)

Money out

• Mortgage payment (to be split, see below)
• Insurance
• Property tax
• Repairs and maintenance
• Cleaning and turnover
• Utilities paid by the landlord
• HOA or service charges
• Property management fees
• Advertising and tenant screening
• Legal and professional fees
• Travel to the property
• Supplies
• Capital improvements (often treated differently from repairs, see below)
• Security deposits returned
• Owner draws (money you take out for yourself)
• Transfers between your accounts

Your tax preparer may prefer particular categories that map to the forms they file. Ask them before you start; it's much easier to categorize once in their structure than to remap later.

Our guide to Excel formulas for categorizing bank transactions shows how to automate categories with a rules table, which works well for recurring items like the mortgage, insurance and management fees.

The tricky items

A handful of transaction types cause most rental bookkeeping errors. Handle these carefully.

Security deposits

A security deposit is money you hold on the tenant's behalf. In many places it isn't treated as income when received, and returning it isn't an expense, though rules differ and amounts you keep may be treated differently. Some jurisdictions also have rules about how deposits must be held. Track deposits in their own categories, note the tenant and unit, and ask your preparer how to treat any portion you keep.

Mortgage payments

A mortgage payment usually combines principal, interest and sometimes an escrow amount for property tax and insurance. Your bank statement shows only the total. The principal portion reduces your loan balance rather than being an ordinary expense, and the interest and escrowed items are treated differently.

To split them, use the mortgage lender's statements or year-end summary. In your spreadsheet, you can either record the total as "Mortgage payment" and note the split at year end from the lender's summary, or split each month into separate rows. The year-end approach is simpler for most small landlords.

Repairs versus improvements

Fixing a broken window and replacing every window in the building may be treated differently. Repairs that keep the property in working order are often handled differently from improvements that add value or extend its life. The rules are specific and vary by country. Categorize clearly, keep invoices for larger jobs, add a note describing the work, and let your preparer decide the treatment.

Shared expenses across properties

If you have multiple properties and pay something that covers all of them, like a single insurance policy or a software subscription, tag it as "General" and decide with your preparer how to allocate it.

Personal use and mixed accounts

If you use the rental account for personal items or a personal account for rental items, tag those transactions clearly. Personal spending isn't a rental expense, and rental income deposited to a personal account still needs to be captured.

Transfers and owner draws

Moving money between your accounts or taking money out for yourself isn't an expense. Tag these so they're excluded from your income and expense totals.

Matching rent to tenants

A rent ledger helps you see who has paid. Create a small table with one row per tenant per month: expected rent, amount received, date received, and balance. Fill the "received" column from your categorized bank transactions using SUMIFS:

=SUMIFS(Tx[Amount], Tx[Category], "Rent received", Tx[Unit], $B2, Tx[Month], C$1)

Where rent arrives as an electronic transfer, the tenant's name usually appears in the description, making tagging easy. For cash or check deposits that combine several tenants, keep a record of who paid what when you make the deposit, because the bank statement will only show the total.

Late fees and partial payments are easier to track when the ledger shows a running balance per tenant.

Using the credit card statement

If you pay for repairs and supplies on a credit card, convert those statements too. Tag rental purchases with the property and category, and tag the card payment from your bank account as a transfer, so you don't count the expense twice: once as the purchase on the card and again as the payment from the bank. Our credit card statement converter handles card layouts.

If a property manager collects the rent

When a property manager handles a property, you usually don't see individual rent payments on your bank statement. Instead, the manager collects rent, pays some expenses on your behalf, deducts their fee, and sends you a net payment along with an owner statement listing what happened.

That creates a common bookkeeping mistake: recording only the net deposit as rent. If the manager collected $1,800, paid a $250 plumbing bill and took a $180 fee, you might receive $1,370. Recording $1,370 as rent understates both your income and your expenses.

A better approach:

1. Keep the manager's monthly owner statements alongside your bank statements.
2. Record the gross figures from the owner statement: rent collected, each expense paid, and the management fee.
3. Tie it to the bank. The net of those figures should equal the deposit on your bank statement. If it doesn't, the difference is usually a timing issue, a reserve the manager is holding, or an item you haven't recorded.

In your spreadsheet, you can add the owner statement lines as extra rows with an Account value of "Property manager", then add a balancing row that offsets the net deposit. That way, your bank account still balances to the statement, and your income and expenses reflect the full picture. Ask your preparer if they'd like it presented differently.

Vacancies, turnovers and one-off months

Rental cash flow is lumpy. A tenant moves out, the unit sits empty for a few weeks, you repaint and replace carpets, and then a new tenant pays first month's rent plus a deposit. Months like that can look alarming in a summary unless you can see what happened.

Use the Notes column generously during these periods:

• Note the move-out and move-in dates.
• Tag turnover costs with the unit and a short description, such as "Unit B turnover: paint, carpet clean".
• Tag the new tenant's deposit separately from rent.
• If a former tenant's deposit was partly kept for damage, note how much and why.

A pivot table with Month in columns and a filter for one property will then show the turnover clearly: a gap in rent, a cluster of costs, and a recovery. That context is useful for your own planning and for anyone reviewing the books later.

A simple monthly routine

Doing a little each month is far easier than a year-end scramble:

1. Download the month's statements for the rental account and the card.
2. Convert them and confirm each balances.
3. Append to your transaction table.
4. Tag property and category, using rules for recurring items.
5. Update the rent ledger and follow up on any late payments.
6. File receipts and invoices, adding references in the Receipt column.

Twenty or thirty minutes a month for a few properties is typical once the rules table is set up. Our expense tracking from bank statements guide has more tips on keeping the routine light.

Year-end summary

With every transaction tagged, a pivot table gives you a clean year-end summary:

• Rows: Category
• Columns: Property
• Values: Sum of Amount
• Filter: exclude transfers, owner draws and security deposits

That produces a table of income and expenses by property for the year. Add the mortgage interest and escrow figures from your lender's year-end statement, and list any larger repair or improvement jobs with their invoices.

A package for your preparer might include:

1. The pivot summary by property and category.
2. The full transaction table, so they can drill into any number.
3. The original bank and credit card statements.
4. Lender year-end mortgage statements.
5. Invoices for larger repairs or improvements.
6. A security deposit list showing deposits held, received and returned.
7. A short notes page for anything unusual: a vacancy, a major repair, a property bought or sold during the year.

Our guide on bank statements for tax preparation covers what preparers commonly ask for in more detail. Our bank statement pivot table guide shows how to build the summary.

A worked example

A landlord owns a duplex and a single-family home. Rent for all three units goes into one checking account, and she uses one credit card for repairs.

1. Gather. Twelve checking statements and twelve card statements for the year, plus two mortgage year-end statements.
2. Convert and verify. All 24 statements are converted and balance.
3. Tag property. Rent from each tenant is tagged to "Duplex A", "Duplex B" or "House". The two mortgages are tagged by property. A single landlord insurance policy covering both properties is tagged "General".
4. Categorize. Rules handle rent, mortgages, insurance, the lawn service and the water bill for the duplex. Repairs are categorized by hand with notes, such as "Water heater replaced, House".
5. Tricky items. A new tenant's security deposit is tagged as a deposit received, not rent. Card payments from checking are tagged as transfers.
6. Rent ledger. The ledger shows one tenant paid late twice, with late fees recorded.
7. Summary. A pivot table by property and category is exported to a PDF, and the package goes to her preparer with the statements, mortgage statements and the water heater invoice.

Her preparer has everything in one place and asks only one question: how to allocate the shared insurance policy.

Moving into accounting software later

If you outgrow spreadsheets, your categorized transactions transfer easily. Use your categories as the chart of accounts and properties as classes, locations or tracking categories, depending on the software. Import statements a month at a time and reconcile each month. See our guides to importing bank statements into QuickBooks Online and the Xero CSV import format.

Get started with your statements

Upload your rental account statements to SheetStatement, confirm each one balances, and download Excel or CSV to start tagging. The free plan covers 3 pages a month; for a full year across several accounts, paid plans are $9, $19 or $39 a month. See pricing.

FAQ

Can I do rental bookkeeping with just bank statements?

Bank statements capture most transactions and are a solid foundation. You'll usually also need mortgage lender statements to split principal and interest, and receipts or invoices for larger expenses.

Should I have a separate bank account for my rental?

It makes bookkeeping much simpler and reduces the risk of mixing personal and rental items. If you use a personal account, tag rental transactions carefully.

Are security deposits income?

Treatment varies by jurisdiction and depends on whether you keep any of the deposit. Track deposits separately and ask your tax professional how to treat them.

How do I handle mortgage payments in my records?

Record the total from the bank statement, then use the lender's year-end statement to separate principal, interest and escrow. Principal reduces the loan rather than being an ordinary expense.

How do I track expenses for more than one property?

Add a Property column and tag every transaction. Shared costs can be tagged "General" and allocated as your preparer advises.

Is this tax advice?

No. It's general information about organizing records. Tax treatment of rental income and expenses depends on your jurisdiction and circumstances, so consult a qualified professional.

What if my property manager pays expenses for me?

Record the gross rent, each expense and the management fee from the manager's owner statement, not just the net deposit. The net of those figures should match the deposit on your bank statement.

How long should I keep rental records?

Retention requirements depend on your jurisdiction and circumstances. Ask your tax professional, and keep statements, invoices and summaries together so they're easy to find.