How Real Estate Agents Can Build a Simple Profit and Loss Statement for Their Business

by Editorial Staff | Mar 3, 2026 | Business and Financial Practices

You can create a clear profit and loss statement quickly by gathering your income and expense records, categorizing items like commissions and marketing, and using a simple Excel or Google Sheets template to automate totals. Start with gross income, subtract operating expenses to find net operating income, and verify entries against bank statements. Follow a concise step‑by‑step method and you’ll spot cash flow issues and tax considerations—next, learn which exact categories to include.

Quick Start: Build a Simple P&L for Real‑Estate Agents in 10 Minutes

Start by gathering all income and expense records for the period—bank and credit card statements, receipts, invoices, and any prior income statements. Then organize them into clear categories like advertising, property management fees, legal/professional fees, office costs, utilities, taxes, and insurance.

Next, use templates in Excel or Google Sheets to input categorized totals for the period, which speeds calculations and creates monthly or quarterly summaries. Sum revenues, total expenses, and subtract to calculate net profit; compute net operating income excluding interest and depreciation if needed.

Verify entries against statements, check for missing receipts, and double-check category allocations. Save a digital copy, generate simple trend graphs, and consult a CPA before finalizing for accurate profit tracking and disciplined expense management. This practice is integral for tracking business performance in real estate and assessing financial health for strategic decisions financial health.

What Income to Include in Your P&L (Commissions, Rentals, Other)

Although commissions still make up the bulk of many agents’ revenue, your P&L should also capture rentals, property-management fees, investment income, service charges, and digital or information-product sales so you can see both volatile and recurring cash flows.

You’ll record commission-based income by type: residential, commercial, team overrides, referral fees, BPOs, and differing commission structures that affect timing and net receipts.

Add property management and leasing fees as recurring monthly lines, and include landlord rental income or flip profits under investment income, plus REIT and mortgage-REIT dividends. It’s crucial to set aside 30–35% of earnings to prepare for potential tax liabilities associated with your income.

List service revenues—staging, inspections, seminars—and online product or advertising sales.

Categorize each item clearly so your P&L reveals income diversification benefits, highlights cash-flow stability, and supports strategic decisions. Building strong client relationships also increases referrals and repeat business, which reinforces Networking enhances deal closure opportunities.

Which Operating Expenses Matter Most : What to Subtract First

When you build a P&L, prioritize subtracting fixed, non-negotiable operating expenses first—property taxes, insurance premiums, and important maintenance—because they set the baseline cash outflow you can’t avoid.

After those, account for recurring but variable items like brokerage and technology fees, and finally marketing and advertising, which are critical for revenue generation but more discretionary and scalable.

You’ll apply Expense Prioritization: list mandatory items (property taxes, lender-required insurance, routine maintenance) to establish unavoidable outflows.

Next, perform Cost Analysis on brokerage, MLS, licensing, and tech subscriptions to forecast monthly variability. Remember that real estate licensing expenses can total around $525 before selling, which is vital for accurate budgeting.

Treat marketing and advertising as scalable within Budget Management, adjusting spend to lead generation performance.

Maintain disciplined Financial Tracking to reconcile actuals against projections and refine future P&Ls.

Also remember to include operating expense ratio in your review so you can see the percentage of income eaten by operating costs.

From Gross Income to NOI: Step‑by‑Step (Before Taxes & Depreciation)

First, consolidate all income sources and revenue streams — commissions, rental items, fees — and present net sales after concessions for financial clarity. A profit and loss statement summarizes revenues, expenses, and profits over a specific period. Additionally, understanding your average earnings for agents can provide context for your financial goals.

Next, apply cost allocation to COGS (turns, make-ready labor, unit utilities) and subtract from net revenue to compute gross profit and the gross profit margin.

Then categorize expense categories (property management, marketing, admin salaries, taxes, insurance, utilities) and subtract operating expenses from gross profit.

The resulting NOI measures operational efficiency and pre-tax profitability.

Use these figures to monitor profit margin targets and refine cost allocation going forward.

P&L Templates and Common Mistakes: Excel/Sheets Tools to Automate Totals

Because a reliable P&L turns raw transactions into actionable insight, you should use purpose-built Excel or Google Sheets templates that automate totals, track monthly and year‑to‑date performance, and present realtor‑specific categories like broker splits, MLS fees, and direct costs.

Use templates that auto-calculate gross income, total expenses, NOI, pre-tax net income, and net income via locked formulas. Implement template customization for tax rate, depreciation, and cash‑flow fields while keeping standard IRS-style categories for consistency. A P&L is essential for assessing property performance and making informed financial decisions. Additionally, integrating real-time expense logging ensures that your financial data remains current and accurate.

Prevent errors by gathering complete receipts, separating non-operating items (mortgage principal, capital improvements), and excluding depreciation from NOI. Leverage side-by-side monthly views and pre-built graphs to spot trends.

Finally, double-check entries and consult a CPA—templates inform decisions but don’t replace tax advice.

Frequently Asked Questions

How Do I Report Split Commissions With Partner Agents on a P&L?

Record split commissions as commission tracking expense line items under operating expenses, referencing partnership agreements for percentages and terms. Deduct partner shares from gross commission revenue, retain documentation, and report net commissions for taxable income.

Should I Include Home Office Expenses if I Work From a House?

Yes — you should include home office expenses as tax deductions if your space meets exclusive, regular use and principal place tests; choose simplified or actual method, keep precise records, and prorate indirect expenses by business percentage.

How Do I Handle Refundable Security Deposits in Income Reporting?

You treat refundable security deposits as liabilities, not income; record security deposit accounting on the balance sheet and only make income statement adjustments when you withhold portions, reclassifying withheld amounts to rental income and recording related expenses.

When Should I Capitalize Vs Expense a Major Repair?

Capitalize a major repair when capitalization criteria are met—betterment, restoration, or adaptation; otherwise expense it as a routine repair. Evaluate repair types, unit of property, and thresholds (including small taxpayer safe harbor) before deciding.

Can I Use P&L Figures to Apply for a Business Loan?

Yes — you can use P&L figures to apply for a business loan. You’ll demonstrate business loan eligibility and the importance of financial statements by providing accurate revenue, expenses, net income, and supporting documentation, ideally verified by a CPA.