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
How do I set up bookkeeping for a brand new business?
Start by separating personal and business finances, picking accounting software, and building a chart of accounts that fits your industry. The most important thing is getting the foundation right from day one so you're not paying to fix it later.
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 should I expect during the first month with a new bookkeeper?
The first month is mostly onboarding and information gathering. Your bookkeeper will need access to your accounts, review your current books, and ask a lot of questions before producing useful reports.
Read answerCan my bookkeeper handle payroll processing for me?
Some bookkeepers do process payroll, but many focus on setting up your payroll system and recording payroll transactions in your books. The actual payroll runs are often handled through dedicated software like QuickBooks Payroll or Gusto.
Read answerWhy do contractors need specialized bookkeeping?
Contractors run project-based businesses where revenue, costs, and cash flow all move differently than a typical company. Standard bookkeeping tracks income and expenses but doesn't tell you whether a specific job made or lost money.
Read answerWhat KPIs should a small business owner watch every month?
Focus on revenue trends, gross and net profit margins, cash flow, accounts receivable aging, and owner's draw relative to profit. Five to seven KPIs reviewed consistently each month reveal more than a complex dashboard you never check.
Read answer