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 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 answerAre there any Jacksonville-area grants or programs my bookkeeper should help me track?
Jacksonville and Northeast Florida have several small business programs worth knowing about. Your bookkeeper's real value here is keeping your financials clean enough to qualify and tracking grant funds properly once you receive them.
Read answerWhat payroll taxes does a small business have to pay in Florida?
Florida has no state income tax, which simplifies things. But you still owe federal payroll taxes (Social Security, Medicare, and federal unemployment) plus Florida's reemployment tax on each employee's wages.
Read answerWhat's the best way to track accounts payable for a small business?
Enter every bill into your accounting software as soon as you receive it, not when you pay it. Use the bills feature rather than recording expenses directly, and run an AP aging report weekly to stay on top of what's due.
Read answerWhat business taxes do I still owe in Florida even without state income tax?
Florida's no-income-tax reputation only tells part of the story. You're still on the hook for sales tax, reemployment tax, commercial rent tax, tangible personal property tax, and all your federal obligations.
Read answerHow do I set up chart of accounts for a new business?
Start with the five standard account categories and add only the accounts you actually need to track your business activity. Keep it simple at first and expand as your business grows.
Read answer