How to Track Rental Income and Expenses (Without QuickBooks)

QuickBooks is excellent at general accounting and average at rental property accounting. Below: what rental accounting actually requires, where spreadsheets break, the purpose-built PM platforms that handle trust accounting natively, and when a hybrid setup is right.

The landlord who opens a QuickBooks account and tries to run rental accounting in it is not wrong — QuickBooks is real accounting software. But it's built for businesses that sell products or provide services, not for the specific workflows of property management: per-unit ledgers, trust account separation, security deposit tracking, owner distributions, and 1099 generation for vendors paid per property. That mismatch creates workarounds. Workarounds create errors. Here's what actually works.

Why QuickBooks isn't always right for PMs

QuickBooks is designed around a chart of accounts for a business entity — one set of books, one bank, one P&L. Rental accounting adds several layers that QuickBooks handles only with significant customization:

Per-unit (per-door) tracking. A 20-unit building isn't 20 lines in QuickBooks — it's 20 separate rent ledgers, maintenance ledgers, and tenant deposit balances. QuickBooks can approximate this with classes or projects, but the workflow is manual and error-prone. PM software does this natively.

Trust account separation. Most states require security deposits (and often collected rents in PM relationships) to be held separately from operating funds. QuickBooks doesn't enforce this separation or flag commingling. You're on your own to keep the accounts distinct — and if you make an error, QBO won't catch it.

Owner distributions and statements. If you manage properties for owners other than yourself, each owner needs a monthly statement: rent collected, expenses paid, management fees, and net distribution. QuickBooks can produce a P&L, but it's not a property management owner statement. Rebuilding that report manually every month is 2–4 hours of work per 20 properties.

1099 prep for vendors by property. You need to issue 1099-NECs to vendors you paid $600+ across your entire portfolio. QuickBooks can track vendor payments, but attributing them correctly by property — and producing a 1099 list — requires discipline that the software doesn't enforce.

Cash basis vs accrual by tenant. Rent collected in advance (first/last month's rent), security deposits, and late fees often need to be tracked differently. PM-specific software handles this without manual journal entries.

For operators managing 1–4 units of their own with no owner clients, QuickBooks (or even simpler options like Wave) may be entirely adequate. The friction grows as you add doors, add owners, or accept security deposits.

What you actually need (chart of accounts, trust accounting, 1099)

Before evaluating tools, know the accounting requirements for rental property management:

1. A property-level chart of accounts. You need income and expense categories that track at the property (or unit) level, not just the company level. Standard categories:

Income: Rent, late fees, application fees, pet rent, parking, laundry, tenant reimbursements Expenses: Mortgage interest, property taxes, insurance, repairs and maintenance, landscaping, utilities, property management fees, advertising, professional fees (accounting, legal), depreciation

2. Trust account separation. Security deposits go in a trust account (separate bank account), not your operating account. In many states, this isn't optional — it's a violation to commingle. Your accounting system needs to reflect this separation clearly.

3. Owner ledger tracking. If you manage for owners, each owner's funds (collected rent, paid expenses, held reserves, distributed cash) need a clean ledger you can reconcile monthly.

4. 1099 reporting. Track vendor payments by TIN (tax ID) across the full year. At year-end, identify who crossed $600 in services and generate 1099-NECs for those vendors.

5. Depreciation tracking. Your accounting system needs to handle or interface with your fixed asset schedule for depreciation.

None of these are exotic. But most general accounting tools weren't designed to deliver all five cleanly for a rental portfolio.

Spreadsheet method (limits and pitfalls)

A spreadsheet — Google Sheets or Excel — can handle rental accounting for operators running 1–8 units with no owner clients. Here's what it can realistically do:

Works well:

• Simple income/expense log per property
• Annual P&L summary for Schedule E
• Security deposit log (dates, amounts, returns)
• Vendor payment tracking for 1099 prep

Breaks down at:

• 10+ units (one spreadsheet per property or one massive sheet — both become unmanageable)
• Owner-managed portfolios (generating clean statements from a spreadsheet is manual labor)
• Any trust account requirement (spreadsheets don't enforce separation; you can commingle with a keystroke)
• Month-end reconciliation at scale
• Tracking partial months, prorations, credits, and move-out deductions across multiple units simultaneously

The failure mode isn't a dramatic crash — it's a slow accumulation of errors that you discover at tax time or when an owner asks a question you can't answer cleanly. Most operators hit the spreadsheet wall somewhere between 8 and 15 doors.

If you're using spreadsheets, keep them clean with these disciplines:

• One tab per property
• Date every entry at the time of the transaction, not retroactively
• Reconcile against your bank statement every month
• Never track security deposits in the same sheet as operating funds

Purpose-built PM platforms

Purpose-built property management software handles the full accounting stack — and the accounting integrates with the operational workflow (rent collection, maintenance, leasing) so entries happen automatically when a payment clears, not when you remember to log it.

Key players in the PM accounting space for independent operators:

The meaningful divide in this table is between the platforms with genuine trust accounting (where deposits are tracked separately and the software enforces the balance) and those without. If you manage for owners or hold security deposits, the "no trust accounting" options aren't appropriate tools — regardless of price.

Proprietio is built specifically for independent operators running mixed portfolios. It handles the full accounting workflow — trust accounts, owner statements, 1099 preparation — without requiring QuickBooks as a companion tool.

Hybrid setups

Some operators run a hybrid: PM software for operational workflows (rent collection, maintenance, tenant communications) and QuickBooks for the final accounting layer their CPA needs.

This works when:

• Your CPA is already fluent in QuickBooks and won't learn a new system
• You have non-rental income streams that QuickBooks tracks (e.g., you also run a contracting business)
• You're over 50 doors and need QuickBooks-level reporting for bank or investor relationships
• Your PM software exports clean transaction files that QuickBooks can import

The integration usually works via CSV export from your PM software and import into QuickBooks, or through a direct sync if your PM software offers a QBO integration. Buildium and DoorLoop both offer QuickBooks Online sync. That sync isn't always clean — expect to reconcile discrepancies, especially around security deposit accounting and mid-month prorations.

For most operators under 50 doors managing residential properties, the hybrid adds friction without much benefit. A PM platform with full accounting covers the Schedule E reporting, the 1099 workflow, and the owner statements without a second tool.

Migration considerations

Moving from spreadsheets to PM software (or from one PM platform to another) requires a clean cutover. Tips:

• Pick a fiscal quarter start date for the migration, not mid-month. January 1 is cleanest; October 1 also works.
• Import your tenant roster first: names, unit assignments, lease dates, monthly rent amounts.
• Enter security deposit balances as of the cutover date. This populates your trust account ledger. Verify each balance against your actual trust bank account.
• Enter lease-to-date payments only if you need historical data. Many operators do a clean-start migration: only current balances and open items carry over.
• Set opening bank balances in the software to match your actual bank accounts on the cutover date.
• Run parallel for 30 days if you can — keeping the old system active while verifying the new one. This catches errors before they compound.

The migration effort is usually 8–20 hours for a 20-property portfolio. The payoff is every subsequent month-end being faster and cleaner.

For detailed guidance on the monthly close process once you're on a platform, see owner distribution reports: what property managers need to send. And for the full 1099 workflow that your new system should automate, see 1099 for landlords: who gets one and when.

FAQ

Do I need separate bank accounts for each property? No — one operating account and one trust account typically cover a portfolio. Some operators open per-property accounts for simplicity, but most PM software handles per-property ledgers within a single bank account through internal sub-ledgers.

Can I use Wave (free accounting software) for rental property? Wave works for very small portfolios (1–5 units) where you don't manage for others and have simple transactions. It has no PM-specific features — no trust accounting, no owner statements, no 1099 prep — so it's roughly equivalent to a well-organized spreadsheet.

How do I track security deposits separately from operating funds in QuickBooks? You create a separate liability account for security deposits and a separate bank account (or use QBO's class tracking). But QuickBooks won't stop you from accidentally transferring funds between the two, and it won't alert you if your liability account balance drifts from the actual bank account. Manual discipline is required.

My CPA does my taxes from an Excel export. Do I need PM software? If you're under 10 units with no owner clients, probably not urgently. But as you grow, the CPA will increasingly be working from your data — and clean, platform-generated reports are faster (cheaper) for them to use than a spreadsheet.

---

Need built-in trust accounting, 1099 reports, and owner statements without bolt-ons? Try Proprietio free.

This isn't tax advice. Talk to a CPA who works with rental real estate before acting on anything here.