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 insurance costs should a contractor track separately?
Contractors should track general liability, workers' compensation, commercial auto, builder's risk, and equipment insurance as separate line items. Each one behaves differently for job costing, premium audits, and tax purposes.
Read answerHow do I get customers to pay their invoices on time?
Late payments usually come from unclear terms, friction in the payment process, or no consequences for paying late. Fix those three things and most of your collection problems go away.
Read answerDo I need to issue 1099s to my subcontractors?
Yes, if you paid a subcontractor $600 or more during the calendar year. You'll file a 1099-NEC with the IRS and send a copy to the subcontractor by January 31st.
Read answerHow should an HVAC or plumbing company handle bookkeeping?
Separate service revenue from installation revenue and track job costs on larger projects. Your chart of accounts should reflect how your business actually operates, with distinct revenue streams and cost tracking that shows profitability by type of work.
Read answerDo I need a fractional CFO if I already have a bookkeeper?
They serve different purposes. A bookkeeper records what happened financially. A fractional CFO uses that information to help you plan, forecast, and make better business decisions.
Read answerHow do I track billable hours and tie them to my financials?
Use a time tracking method that connects directly to your accounting software so logged hours flow into invoices and revenue reports without manual rework. QuickBooks Online has built-in time tracking that handles this well.
Read answer