How should a real estate investor track rental income and expenses?
The most important principle is tracking everything by individual property. When you own multiple rentals, lumped-together numbers don’t tell you which properties are making money and which ones are draining it. Each property needs its own profit and loss so you can evaluate performance and make informed decisions about holding, selling, or reinvesting.
In QuickBooks Online, you can use classes or locations to tag every transaction to a specific property. Every rent payment, every repair bill, every insurance premium gets assigned to the property it belongs to. This lets you pull reports for each property individually or view the whole portfolio at once. Proper setup from the start saves a lot of cleanup later.
For rental income, track rent payments, late fees, pet fees, and parking fees as separate line items. Security deposits are not income. They’re a liability until they get applied to damages or returned to the tenant. Recording deposits as income is a common mistake that overstates what you actually earned and creates problems at tax time.
On the expense side, common categories include mortgage interest (not principal payments, which reduce your loan balance rather than your income), property taxes, insurance, repairs and maintenance, property management fees, utilities you cover, HOA fees, and advertising for vacant units. Keep repairs separate from improvements. A new faucet is a repair you can deduct immediately. A new roof is a capital improvement that gets depreciated over time. The distinction matters significantly on your Schedule E.
Use a dedicated bank account for your rental activity. Mixing rental income and expenses with personal finances makes tracking nearly impossible and creates a mess when it’s time to file. If you have multiple properties, one account for all rentals can work as long as you’re tagging transactions to the right property in your books. A small business bookkeeping service can help you set this structure up correctly so the reports actually tell you something useful.
Reconcile monthly. Don’t let months pile up. When you reconcile regularly, you catch missed rent payments, duplicate charges, and errors while they’re still easy to fix. Waiting until tax season to sort through a year of transactions means you’ll miss deductions and spend far more time getting organized than you would have with consistent monthly work.
Keep documentation for every expense. Photos of repair work, contractor invoices, receipts for materials. If you’re managing properties yourself, log your mileage when you drive to a property for maintenance or inspections. These smaller deductions add up fast across a portfolio.
The goal of good real estate investor bookkeeping is knowing exactly how each property performs so you can make decisions based on real numbers. When your books are organized by property with clean categories, tax prep becomes straightforward and you always have a clear picture of where your portfolio stands.
Long Beach's Trusted Bookkeeping Partner
The Next Step:
A Quick Discovery Call
Tell us where things stand with your books. We'll listen, ask a few questions, and give you a clear quote to get it handled.
More Questions
How do I track tips and gratuities in my books?
Credit card tips should be tracked as a liability until paid out to employees, not recorded as revenue. Cash tips don't flow through your bank account but still need to be reported through payroll for tax withholding.
Read answerWhat does a clean set of books look like at tax time?
Clean books mean every account is reconciled, all transactions are properly categorized, owner draws are separated from business expenses, and your balance sheet reflects reality. Your CPA can open the file and start working without cleanup.
Read answerWhat's the difference between accounts payable and accounts receivable?
Accounts payable is money your business owes to others. Accounts receivable is money others owe your business. Both show up on your balance sheet and directly affect your cash flow.
Read answerWhat documents should I gather for my bookkeeper every month?
At minimum, your bookkeeper needs bank statements, credit card statements, receipts for expenses, and any invoices you've sent or received. Building a simple monthly habit around gathering these keeps your books accurate and saves time on both sides.
Read answerWhy is it important to keep personal and business money in separate accounts?
Separate accounts protect your legal liability, simplify tax preparation, and give you accurate financial data to make decisions. Mixing personal and business money creates problems that get more expensive and harder to fix the longer it goes on.
Read answerWhat financial records should I keep for my California-based LLC?
Keep formation documents permanently and hold onto tax returns, bank statements, receipts, and financial reports for at least seven years. California has its own filing requirements on top of federal ones, so your records need to support both.
Read answer
