Rent Roll Tracking and Reconciliation
The rent roll is the foundation of property management bookkeeping. It is a living record of every unit under management: tenant name, lease start and end dates, monthly rent amount, security deposit held, and current payment status. Every month, the rent roll drives your revenue recognition — what was owed, what was collected, and what remains outstanding.
Reconciliation means matching every rent payment received against the rent roll for that period. Partial payments, late fees, prorated rents for move-ins and move-outs, and prepaid rents all need to be correctly recorded — not thrown into a general “rental income” bucket and sorted out later. Later never comes, and the discrepancies compound.
Deferred rent and prepaid rent are common sources of error. If a tenant pays January and February rent in December, only January is revenue in December (if you use accrual accounting) — February is a liability until the month it is earned. Cash-basis property managers often skip this distinction, which means their monthly income statements don’t reflect actual performance. It also creates problems when you are producing owner statements that owners then use for refinancing or sale decisions.
Vacancy tracking belongs on the rent roll too. A unit that sits empty for three weeks between tenants is a vacancy loss — a real economic cost even though no cash moved. Tracking vacancy loss by unit and by period tells you which properties are underperforming and why. See the vacancy loss section below for the accounting treatment.
Security Deposit Trust Accounting: California Civil Code 1950.5
Security deposits are not income. They are a liability — money held on behalf of the tenant until the lease ends and the property condition is assessed. California Civil Code 1950.5 governs every aspect of security deposit handling: what can be charged, how much can be collected, and what the return timeline looks like after move-out.
The accounting treatment follows the legal reality. When a security deposit is collected, it is recorded as a liability on your balance sheet, not as revenue. When it is returned in full, the liability is cleared. When deductions are applied — for unpaid rent, cleaning, or damage — those deductions are recorded as income (offsetting the expense) and the balance is returned with an itemized accounting within 21 days of the tenant vacating.
Co-mingling security deposits with operating funds is a practice to avoid. California does not legally require a separate trust account for residential security deposits, but the practical bookkeeping argument for separation is overwhelming. If deposits sit in your operating account and get spent, you now owe a refund you cannot fund — a cash crisis with a legal deadline attached. Holding deposits in a dedicated account and tracking each deposit as a separate liability line means you always know exactly what you owe and to whom.
Property management companies managing funds for owners add another layer: the owner’s operating funds and the security deposits you hold are both trust funds under California Bureau of Real Estate rules. Mixing them with your management company’s own funds is a licensing violation. Every management company handling owner funds should maintain at minimum two accounts: a trust account (for owner funds and tenant deposits) and an operating account (for management company revenue and expenses).
Maintenance and Repair Expense Categorization
Maintenance expenses are the most frequently miscategorized line items in property management books. The IRS distinguishes between repairs (deductible in the current year) and capital improvements (depreciated over time), and the distinction has real tax implications for your property owners.
A repair restores the property to its previous working condition: fixing a leaking faucet, patching drywall, replacing a broken window pane. It does not add value or adapt the property to a new use. Repairs are ordinary business expenses — deducted in full in the year incurred.
A capital improvement betters, restores, or adapts the property: replacing the entire roof, installing a new HVAC system, adding a deck, or renovating a kitchen. These must be capitalized and depreciated over 27.5 years for residential rental property — meaning a $15,000 roof replacement generates a deduction of roughly $545 per year, not $15,000 in year one.
The IRS $2,500 de minimis safe harbor allows property managers to expense items costing under $2,500 per invoice per item without capitalizing them, provided the property owner has a written accounting procedure in place. For the maintenance work that dominates day-to-day management — appliance replacements, plumbing fixtures, minor electrical work — this safe harbor makes categorization simpler. For larger jobs, the repair vs. improvement analysis matters. For a broader look at deductible expenses, see our post on small business tax deductions you may be missing.
Vendor invoices should be coded to the correct expense category at time of entry, not left in a generic “maintenance” account and sorted at year-end. Consistent categorization is what makes owner statements meaningful and year-end tax prep efficient.
Owner Statement Preparation: Monthly P&L Per Property
Owner statements are the primary deliverable of a professional property management company. A well-prepared statement shows the property owner exactly what happened financially in the prior month: gross rents collected, vacancy and concessions, management fees, maintenance expenses, capital expenditures, and net proceeds distributed.
The gold standard is a property-level P&L — one income statement per managed property, not a combined roll-up that hides individual property performance. An owner with four units in different buildings needs to see each property’s numbers independently to make informed decisions about where to invest, where to cut costs, and which properties to hold or sell.
Common owner statement errors that erode trust: maintenance expenses charged to the wrong property, management fees calculated on gross rents before vacancy adjustments, security deposit transactions showing as income, and capital expenditures expensed instead of capitalized. Owners who do their own tax returns or work with their own CPAs will catch these errors. A management company that produces error-free statements builds the kind of relationship that keeps clients for years. For more on what clean financial records enable, see our post on how clean books help you get a small business loan.
Owner distributions — the net proceeds wired to owners after expenses — must tie to the owner statement exactly. Any discrepancy between what the statement says was distributed and what actually hit the owner’s bank account is a reconciliation issue that needs to be resolved before the next statement cycle.
1099 Reporting for Vendors and Contractors
Property management generates a high volume of vendor payments: plumbers, electricians, landscapers, HVAC technicians, pest control companies, cleaning crews, painters. Most of these are small businesses or sole proprietors. Any vendor paid $600 or more during the calendar year for services must receive a 1099-NEC by January 31 of the following year.
The W-9 collection process is the critical step that most management companies botch. If you wait until December to collect W-9s from vendors you’ve been paying all year, you will spend weeks chasing contractors who have since moved, changed phone numbers, or simply stopped responding. The correct process: collect a completed W-9 before issuing the first payment to any new vendor. File it with the vendor record in your property management software. Then January 31 is an administrative task, not a fire drill.
Corporations (entities taxed as C-Corps or S-Corps) are generally exempt from 1099 reporting. LLCs, partnerships, and sole proprietors are not. Your vendor setup process should capture the entity type from the W-9 so 1099 obligations are tracked automatically.
If your management company pays vendors on behalf of property owners and passes those costs through, the question of who issues the 1099 matters. Generally, the entity that pays the vendor issues the 1099 — which means the management company, not the property owner, issues 1099s for maintenance vendors. This is a common area of confusion that causes duplicate filings or missed filings. Get clear on your obligations before year-end. The same vendor 1099 principles apply across industries — see our post on bookkeeping for contractors for how independent contractors handle the receiving end of these obligations.
Vacancy Loss Tracking
Vacancy loss is the economic cost of units that are not producing rent. It is calculated as the potential gross rent for a vacant unit multiplied by the number of days vacant. A two-bedroom unit at $2,800 per month vacant for 21 days represents $1,960 in lost revenue — real money even though no cash transaction occurred.
Property management software like AppFolio and Buildium tracks vacancy automatically. Your books need to reflect it too. The standard approach: record potential gross rent as revenue, then record vacancy loss as a contra-revenue line. This produces a gross-to-net revenue schedule that shows both what could have been earned and what was actually collected — a much more useful picture than a simple cash collection report.
Vacancy loss data by property over time reveals patterns. Is one building consistently above market vacancy rates? Are units turning faster in Q1 than Q3? Is a particular floor plan driving longer vacancy periods? These are management decisions, but they can only be made with the data. That requires tracking vacancy loss consistently in the books, not just in the leasing team’s spreadsheet.
AppFolio, Buildium, and Rent Manager Reconciliation
Property management software is the operational system of record: lease terms, rent collection, maintenance work orders, vendor payments, owner distributions. Your accounting books — whether you run a separate QuickBooks file, use the accounting module built into your PM software, or both — must reconcile to this operational data.
Monthly reconciliation for property management means: total rents collected in AppFolio (or Buildium, or Rent Manager) must match rent revenue in your books. Total owner distributions must match. Total vendor payments must match. Security deposit balances in the software must match the trust account liability on your balance sheet.
The most common reconciliation gap: bank feeds auto-matching incorrectly. When AppFolio pushes a deposit to QuickBooks and QuickBooks auto-matches it to the wrong transaction — or creates a duplicate — the books look right at the transaction level but wrong at the bank reconciliation. Reviewing auto-matches monthly before they become a six-month cleanup project is far less painful than the alternative.
If your PM software has a built-in accounting module, the reconciliation question becomes: is the PM software your book of record, or is QuickBooks? Having both systems with conflicting balances is the worst outcome. Choose one as the authoritative source for financial reporting and treat the other as a secondary operational tool. Most mid-size management companies use QuickBooks (or a similar general ledger) for accounting and rely on the PM software for operational management, with a monthly reconciliation process to keep them aligned.
What Good Property Management Books Look Like
A well-run property management bookkeeping operation produces: a rent roll that reconciles to the bank account every month, a trust account that ties to the security deposit liability on the balance sheet, maintenance expenses categorized correctly as repairs or capital expenditures, property-level P&Ls for every owner client, and 1099s filed on time in January without scrambling for W-9s.
It also means owners can answer the questions that drive portfolio decisions: Which properties are performing above market? Where is maintenance eating margin? Which units have the highest turnover cost? Which properties would qualify for a refinance based on their net operating income? Those answers live in the books — but only if the books were set up to capture the right data from the start.
Ledger Bee LLC works with property managers and independent landlords throughout Southern California — from multi-family operators in Los Angeles and Orange County to single-family rental portfolios in the Inland Empire and San Diego. If your books are not telling you what you need to know to run your properties well, that is something we can fix. If you’re not sure where your books stand, see our post on 5 signs you need a bookkeeper.