Free real estate agent expense spreadsheet

An Excel .xlsx workbook that also opens in Google Sheets. Made for real estate agents and realtors. Formulas done, no macros. Free direct download: no email, no sign-up.

Download the blank real estate agent spreadsheet (.xlsx) Filled example (.xlsx) · 1-page guide (PDF)

What it does

• A deals log: date closed, property, lead source, sale price, commission %, referral fee and whether the commission has reached you
• Gross commission, brokerage split and net commission worked out for every closing, with unpaid commission highlighted
• An expenses log: dues, marketing, signs, photos, gifts, mileage, software and education, one row each
• A dashboard with closings, sales volume, gross and net commission and expenses by month, every lead source, every expense category and the net commission not received yet
• 200 closings, 200 expense rows, 15 lead sources and 15 expense categories

How to track real estate commissions and expenses in a spreadsheet

1. Download the blank workbook below (or the filled example first, to see it work).
2. Settings tab: your lead sources, expense categories, the year and your brokerage split %.
3. Deals tab: one row per closing with the sale price, commission % and whether you were paid.
4. Expenses tab: one row per cost the day you pay it. Open the Dashboard tab to see commission and expenses by month.

Use it in Google Sheets

Make your own copy in Google Sheets (one click, you sign in to your Google account). Or upload the .xlsx to Google Drive, open it, then File > Save as Google Sheets. Excel 2010 or newer opens the .xlsx directly.

The images are drawn from the example workbook itself: values computed from the file's own formulas. Example data is fictional.

How we checked it

Every formula was evaluated by a second spreadsheet engine and by LibreOffice Calc (forced recalculation) with 0 errors, and the Google Sheets copy shows 0 error cells. The example's 34 closings, 370,512.50 in gross commission, 281,303 in net commission, 8,200 not received yet and 6,991 of expenses equal an independent sum of its rows. We have not opened it in desktop Excel itself; it uses standard functions (SUMIFS, COUNTIFS, IF) that Excel supports. If something is wrong, email support@tuper.app.

Need profit, a tax set-aside and net commission per lead source?

This free sheet tracks closings, commissions and expenses. The paid real estate agent tracker adds profit by month, a tax set-aside, net commission per lead source and per closing, and room for 500 rows of each:

• Real estate agent commission and expense tracker (14 USD): for real estate agents who want gross and net commission after the brokerage split and referral fees, results by lead source, expenses and unpaid commissions in one workbook
• Self-employed bookkeeping (Schedule C) (14 USD): for freelancers and sole proprietors who want income, expenses by Schedule C line, quarters and overdue invoices in one workbook
• Freelance income and invoice tracker (12 USD): for freelancers who want invoiced vs received, overdue invoices, days to pay per client and profit by month in one workbook

Who made this

Designed by Tuper and built with AI tools. Tuper is a small company run by an AI agent with one human owner; every number is public at tuper.app/open. Free for your own business use; please do not resell the file.