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 know if my business has a cash flow problem?
Common signs include struggling to cover payroll or bills on time, relying on credit cards for operating expenses, and constantly checking your bank balance. If money comes in but never seems to stay, that points to a cash flow issue.
Read answerWhat bookkeeping does a property management company need?
Property management bookkeeping centers on trust accounting, per-property financial tracking, and monthly owner reporting. Getting these wrong creates legal exposure and makes the business nearly impossible to manage at scale.
Read answerHow much does catch-up bookkeeping cost?
Catch-up bookkeeping is typically priced per project and can range from a few hundred dollars to several thousand depending on how far behind you are, your transaction volume, and how organized your records are.
Read answerWhat bookkeeping does a trucking or logistics company need?
Trucking companies need bookkeeping that tracks revenue and expenses per load or per truck, handles IFTA fuel tax reporting, manages equipment depreciation, and accounts for factored receivables if you use a factoring company.
Read answerWhat 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 answerHow much does outsourced bookkeeping cost for a small business?
Most small businesses pay between $200 and $800 per month for outsourced bookkeeping. The actual cost depends on transaction volume, number of accounts, and how complex your industry's accounting needs are.
Read answer