How do I track maintenance requests and repair costs by property and unit?
The most effective setup in QuickBooks Online uses sub-customers for each property and classes for individual units. Create a parent customer that represents your entire portfolio or a property group, then add each property as a sub-customer underneath it. Classes get assigned to specific units within those properties. When you enter a bill or expense, you tag it with both the property (sub-customer) and the unit (class), which lets you pull reports at whatever level of detail you need.
Set up your chart of accounts to separate routine maintenance from capital improvements. This distinction matters for taxes. Routine maintenance like fixing a leaky faucet, replacing a garbage disposal, or repainting a unit is a current-year expense you can deduct immediately. Capital improvements that extend the useful life of the property or add value, like a new roof, replacing all the windows, or a full kitchen remodel, need to be capitalized and depreciated over time. If you lump everything together, your tax return will be wrong in one direction or the other.
Establish a dollar threshold for owner approval before money gets spent. If you’re managing properties for others, or even for yourself with a property manager in place, set a clear number. Anything under $500 (or whatever makes sense for your situation) gets handled without approval. Anything above requires sign-off before the work starts. This prevents surprise invoices and gives you a natural checkpoint to evaluate whether something is truly a repair or an upgrade that should be handled differently.
For tracking the actual requests, keep a simple log that connects each maintenance request to the expense when it’s paid. Some property management software handles this automatically, but if you’re running things through QBO, a consistent naming convention on your memos or descriptions works. Include the property address, unit number, and a brief description of the work. When you run a profit and loss by sub-customer at year end, every dollar ties back to a specific request and a specific unit.
Run a profit and loss report filtered by sub-customer quarterly at minimum. This shows you which properties are eating up your maintenance budget and which units are repeat offenders. A unit that needed $3,000 in repairs over six months might signal a deeper problem worth addressing with a larger capital project instead of constant patching. That kind of visibility only exists if the tracking is consistent from day one.
Real estate investors with growing portfolios often start tracking this way too late, after they’ve already lost sight of per-property profitability. If you’re behind on getting your books organized by property and unit, catching up now saves you from guessing at numbers when tax season arrives or when you’re evaluating whether to sell a property.
The system itself is straightforward. The hard part is discipline. Every expense needs to be coded correctly when it happens, not reconstructed months later from memory. If you don’t have time to stay on top of it yourself, small business bookkeeping services focused on real estate can maintain the structure for you and make sure nothing slips through the cracks.
Your Valley of the Sun Bookkeeper
The Next Step:
A Quick Conversation
Tell us what's going on with your books. We'll listen, ask a few questions, and give you a clear quote with no surprises.
More Questions
How do I know if my bookkeeping is behind and what does a catch-up engagement involve?
Common signs include unreconciled bank accounts, missing financial statements, and unfiled tax returns. A catch-up engagement works through the backlog month by month, reconciling accounts and categorizing transactions until your books are current and accurate.
Read answerCan I deduct hand tools and power tools as a self-employed electrician or do I depreciate them?
Most hand tools and power tools under $2,500 can be deducted immediately using the IRS de minimis safe harbor election. Tools over $2,500 can be fully deducted through Section 179 or depreciated over 5 to 7 years. Either way, keep every receipt because tool deductions are a common audit flag for trades.
Read answerWhat business entity type is best for an Arizona small business, LLC, S-Corp, or sole proprietor?
Most Arizona small businesses should start with an LLC, which costs just $50 to file with no annual report required. Consider the S-Corp tax election once net income consistently exceeds $50,000 to $60,000, where self-employment tax savings outweigh the added compliance costs.
Read answerHow do I track and account for medical equipment financing and lease payments?
The accounting depends on whether you have an equipment loan, capital lease, or operating lease. Recording the full monthly payment as an expense is the most common mistake. Each arrangement requires different treatment on your balance sheet and income statement.
Read answerHow do I handle patient copays and deductibles in my accounting when collected at different times?
Collect at the point of service whenever possible. When that doesn't happen, book the patient's balance as a separate accounts receivable from insurance A/R so you can track and collect it properly.
Read answerCan a landscaping business deduct the cost of a trailer and mowing equipment in the first year?
Yes. Section 179 lets you deduct the full purchase price of qualifying equipment like mowers, trailers, and trucks in the year you buy them. The 2024 limit is $1,220,000, which covers most landscaping equipment purchases easily.
Read answer