How should a real estate investor track rental income and expenses?
The most important thing is tracking by individual property. Every dollar of income and every expense needs to be tied to a specific address. If you own three duplexes and lump everything together, you have no idea which one is making money and which one is quietly draining your cash flow. Your CPA also needs property-level numbers to file your Schedule E correctly.
In QuickBooks Online, set each property up as a separate class or project. When rent comes in, it gets coded to that property. When you pay for a roof repair, plumbing call, or property management fee, it goes to that property. If you own multi-unit buildings, decide whether you need to track by building or by individual unit. For most investors, tracking by building works until you start needing unit-level profitability.
Open a dedicated bank account for your rental activity. Mixing rental income and expenses with your personal checking account creates a mess that takes hours to untangle. A separate account means every transaction in that account is rental-related by default, which makes monthly bookkeeping dramatically simpler.
Pay attention to your expense categories because they matter at tax time. The IRS distinguishes between repairs and improvements, and they’re treated very differently. Fixing a leaky faucet is a repair and gets deducted in the current year. Replacing all the plumbing in a unit is an improvement and gets depreciated over time. Miscategorizing these can trigger issues if you’re audited or cause you to miss deductions you’re entitled to.
Common categories for real estate investors include mortgage interest, property taxes, insurance, repairs and maintenance, property management fees, utilities paid by the owner, HOA fees, advertising for vacancies, and depreciation. Set these up in your chart of accounts from the start so you’re not reclassifying hundreds of transactions at year end.
Security deposits need special handling. A deposit you hold for a tenant is not income. It’s a liability because you owe it back. Only when you keep part or all of a deposit for damages does it become income. Recording deposits as revenue when received will overstate your income and create a tax headache.
Reconcile your rental bank account monthly. This catches duplicate charges, missed rent payments, and vendor errors before they become bigger problems. It also means your books are always ready when your CPA needs them or when you’re evaluating whether to buy another property.
If you’re behind on organizing your rental finances or still tracking everything in a spreadsheet, working with an outsourced bookkeeping team in Jacksonville can get your books structured correctly and keep them current going forward. The goal is clean property-level data that tells you your actual return on each investment and makes tax season painless.
The First Coast's Trusted Bookkeeping Partner
The Next Step:
A Free Discovery Call
Tell us where things stand with your books. Whether you're months behind or just looking for reliable bookkeeping going forward, we'll give you an honest assessment and a clear price.
More Questions
What are the benefits of outsourcing bookkeeping instead of hiring in-house?
Outsourcing gives most small businesses better expertise at a fraction of the cost. You avoid a full-time salary for work that rarely fills 40 hours per week, and you get coverage that doesn't disappear when someone calls in sick or quits.
Read answerWhat kind of financial reports does a fractional CFO provide?
A fractional CFO delivers forward-looking financial analysis beyond standard bookkeeping reports. Expect cash flow forecasts, budget vs. actuals, profitability analysis, and KPI dashboards tailored to your business.
Read answerHow do I set up QuickBooks Online for my business?
Start with your company settings and chart of accounts before connecting bank accounts or entering transactions. Getting the foundation right determines whether QBO gives you useful financial data or a mess you'll need to clean up later.
Read answerHow do I create a budget for my small business?
Start with your actual numbers from the past 12 months, not guesses. List your fixed costs, estimate variable expenses by month, project revenue conservatively, and review the budget against actuals every single month.
Read answerWhat financial reports does a trades business need to review monthly?
At minimum, review your profit and loss statement, cash flow report, and accounts receivable aging every month. These three reports tell you whether you're actually making money, whether you can cover upcoming expenses, and who still owes you.
Read answerHow much does a fractional CFO cost compared to a full-time CFO?
A fractional CFO typically costs between $1,000 and $5,000 per month, while a full-time CFO runs $200,000 to $400,000 or more per year when you factor in salary, benefits, and bonuses. Most small businesses get the strategic guidance they need at a fraction of the cost.
Read answer