Real Estate P&L Template

Download the .xlsx file and open it in Excel or Google Sheets — no macros, no plugins required. Start on the Monthly P&L sheet and review the pre-loaded revenue and expense categories. Most agents and property managers can go live with the categories as-is; just rename or remove the lines that don't apply to your business model (for example, if you don't manage properties, remove the property management revenue section and replace it with another income stream). First-time setup typically takes 15–20 minutes.

Once your categories are set, enter your revenue and expense figures for the current month. For commissions, pull your HUD-1 settlement statements or brokerage commission disbursements. For expenses, your bank statements or accounting software will have what you need. The Commission Tracker sheet is worth maintaining in parallel: log each closed deal with its sale price and commission rate, and the sheet will cross-reference with your monthly totals to make sure everything reconciles.

Return to the template at the close of each month — it takes about 20 minutes once the habit is established. After 3–4 months, the Annual P&L sheet becomes the most valuable view: you can see how your GCI is trending, whether your expense ratio is creeping up as you add technology tools or marketing spend, and how much of your income is recurring (property management) versus transaction-dependent (commissions). Real estate is a lumpy income business, and the P&L is what turns that lumpiness into a pattern you can plan around.

Real estate agents and small brokerages have an unusual financial profile: revenue is highly variable, tied to the volume and size of closed transactions, while many expenses are fixed regardless of how many deals close in a given month. MLS dues, E&O insurance, CRM subscriptions, and brokerage fees don't stop when the market slows. Without a P&L, it's easy to feel profitable during a hot spring market and then run out of runway during a slow Q4 — because the income spike was real but didn't account for the fixed cost base underneath it.

A proper real estate P&L separates commission income from recurring income — two streams that behave completely differently. Commission income is lumpy and seasonal, peaking March through August and slowing sharply in December and January. Property management fees are predictable monthly recurring revenue that offset the seasonal swings. When your P&L shows these separately, you can see what percentage of your income is stable and what percentage is transaction-dependent — and whether you need more managed units, more listings, or better deal flow to hit your annual income targets. Net margins for real estate professionals typically range from 15–35%, but that number is meaningless without knowing what's driving it.

The real operational value of a P&L for real estate comes from tracking expenses against income over time. Many agents underestimate their true cost per transaction: when you add up the pro-rated share of MLS fees, E&O, CRM, marketing, and transaction coordination, the cost per deal is often $800–1,500 before brokerage splits. Tracking this in a P&L lets you calculate your actual net per deal — not just your gross commission — and decide whether your current transaction volume and average price point are generating enough income to cover both expenses and your income goals.