Real Estate Income Statement Template

Start by setting up the template for your specific practice. Download the .xlsx file and open it in Excel or Google Sheets — no macros or add-ins required. On the Monthly Income Statement sheet, review the pre-loaded revenue and expense categories and adjust them to match how you operate. Solo agents typically simplify the revenue section to GCI and referral income. Teams and brokerages may want to expand the expense categories to separate agent-paid marketing from company marketing. Most users spend about 15 minutes on this initial setup.

Enter your closed deals in the Transaction Log as they happen. Each row captures the closing date, sale price, commission rate, and broker split, and the sheet calculates your net commission automatically. At month end, the monthly income statement pulls from the log, so your revenue figures are always current without manual entry. Fill in operating expenses once a month — log your MLS renewal, CRM subscription, advertising spend, and any other costs as they hit your account. The whole monthly update takes about 20 minutes.

Use the Annual Summary and Dashboard to track your business quarterly and at year end. The dashboard shows whether your GCI is growing, whether your marketing spend is producing deals at a reasonable cost, and whether your net margin is where it should be. Agents who track income and expenses consistently find they make better decisions about where to invest — whether to increase marketing, upgrade their CRM, or cut costs in a slow quarter. The template also gives you a clean year-end summary to hand off to your accountant or use for tax prep.

Real estate is a business where income looks high on paper but disappears fast once you account for all the costs. A top-producing agent with $150,000 in GCI might net $70,000 after broker splits, MLS fees, E&O insurance, marketing, and technology costs — and that's before taxes. The gap between gross commission and take-home income is real, and it's the kind of thing that sneaks up on agents who don't track expenses carefully. An income statement built for real estate makes that gap visible so you can manage it.

A proper real estate income statement separates costs into two layers. The first is direct costs — your broker split and any referral fees you've paid out. These come off the top of every deal and determine your net commission income before you've spent a dollar on running your business. The second layer is operating expenses — the recurring costs that don't change deal to deal: MLS and board dues, E&O insurance, CRM and transaction management software, marketing and advertising, vehicle expenses, and continuing education. Understanding both layers lets you set a realistic GCI target for the year, knowing exactly how much it costs to operate before you see any profit.

The practical use case for this template is monthly and quarterly tracking, not just year-end accounting. Log deals as they close, add expenses as they hit your account, and review your income statement at the end of each month. You'll quickly see whether your marketing spend is proportional to your income, whether you're on track to hit your annual GCI goal, and whether any expense categories are growing faster than expected. Agents who review their numbers monthly catch problems — like an inflating ad budget with no clear return — early enough to change course before they affect year-end results.