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
What records do I need to keep for a DOT audit of my trucking company's finances?
DOT auditors review driver pay records, hours of service logs, vehicle maintenance records, drug and alcohol testing documentation, insurance filings, and IFTA/IRP compliance. Your financial records need to support everything you've reported. Keep records for a minimum of 3 years, though 6 years is safer for certain DOT requirements.
Read answerWhat is the difference between a contractual allowance and a bad debt write-off for a medical practice?
A contractual allowance is the gap between what you bill and what the insurer agreed to pay. It reduces revenue. Bad debt is money a patient or payer actually owed you but never paid. The IRS requires you to track them separately.
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 answerHow does Arizona tax construction contractors differently under TPT?
Arizona taxes prime contractors on 65% of the total contract price under the prime contracting TPT classification. Subcontractors, spec builders, and owner-builders each follow different rules. Getting the classification wrong is one of the most common filing mistakes.
Read answerHow do I calculate the true cost per cleaning job including overhead?
Add your loaded labor cost, supplies, and drive time as direct costs. Then allocate all overhead across your billable hours. Most cleaning businesses undercharge because they only count what they pay their cleaners.
Read answerWhat are Arizona's requirements for filing state payroll taxes and Form A-4?
Arizona uses a unique flat-percentage withholding system where employees choose their rate on Form A-4. Employers deposit withholding quarterly using Form A1-QRT and file an annual reconciliation on Form A1-R by February 28.
Read answer