A real estate profit and loss (P&L) template in Excel is a worksheet that records property income and expenses for a chosen period and calculates the result. Set up columns for the date, category, description, and amount, then use formulas to total income, total expenses, and profit; the example below shows a practical layout for Microsoft Excel for Microsoft 365 on Windows.
What a real estate P&L shows
A P&L summarizes revenue and expenses over a period, such as a month, quarter, or year. For a rental property, it can show rent and other property income against costs such as repairs, insurance, and property management. The main purpose is to make activity visible and comparable across periods, not to replace a bank statement, accounting system, tax return, or property-level cash flow forecast.
Real estate reports use several measures that are easy to confuse. Net operating income (NOI) is generally income from property operations minus operating expenses, before financing costs and depreciation. Net income after interest and depreciation is a different measure. Cash flow is different again: it reflects money received and paid, and may include mortgage principal, capital purchases, and other cash movements that do not appear as P&L expenses in the same way.
Choose a consistent reporting basis and period. A cash-basis worksheet records income and costs when money is received or paid; an accrual-basis report records them when earned or incurred. The appropriate treatment depends on the owner’s reporting and tax situation, so confirm accounting and tax requirements with a qualified professional.
A simple Excel layout
For a one-property monthly report, put category names in column A and amounts in column B. Add columns for the transaction date, vendor or tenant, description, and receipt or invoice reference if you want the sheet to double as a transaction log. A useful summary section can sit above or beside the detailed transactions.
- Income: rent, parking, laundry, storage, and other property-related receipts. Keep refundable security deposits separate from earned income unless your reporting method and circumstances say otherwise.
- Operating expenses: property tax, insurance, utilities paid by the owner, repairs, management fees, HOA charges, and other recurring costs.
- Below-the-line items: mortgage interest and depreciation, when included in the report. Separate them from operating expenses so the NOI calculation remains clear.
- Summary: total income, total operating expenses, NOI, any additional specified expenses, and the resulting profit measure.
Use one row per transaction in a detailed log and a separate summary by category. This is easier to audit than typing monthly totals over earlier numbers. In Excel, select the transaction range and choose Insert > Table; a table expands as you add rows and makes filtering by date or category easier. Give the table clear column headers and avoid merged cells in the data area.
Worked example and formulas
Suppose a monthly summary uses column A for labels and column B for amounts. Put rent of 2,400 in B2, fees of 50 in B3, and other income of 0 in B4. Label B5 Total income. The example assumes the amounts are in the same currency and period.
With income amounts in B2:B4 and the total-income cell in B5, enter =SUM(B2:B4) in B5. It returns 2,450, because 2,400 plus 50 plus 0 equals 2,450.
For expenses, enter property tax of 250 in B7, insurance of 120 in B8, utilities of 90 in B9, repairs of 180 in B10, management of 180 in B11, HOA charges of 0 in B12, and other operating expenses of 0 in B13. Label B14 Total operating expenses.
With those expense amounts in B7:B13 and the total in B14, enter =SUM(B7:B13) in B14. It returns 820: 250 + 120 + 90 + 180 + 180 + 0 + 0.
With total income in B5 and total operating expenses in B14, enter =B5-B14 in B15 and label it NOI. The result is 1,630, since 2,450 minus 820 equals 1,630. If the report also includes interest of 400 in B16 and depreciation of 500 in B17, label B18 Income before income taxes.
With NOI in B15, interest in B16, depreciation in B17, and the result in B18, enter =B15-B16-B17. The example returns 730: 1,630 minus 400 minus 500. This is an illustrative calculation, not tax or accounting guidance. Do not subtract mortgage principal from NOI; principal repayment is a cash outflow but is not interest expense. Track principal separately when the purpose is to understand cash available.
Build a report that stays usable
Keep the source data orderly and make the summary formulas refer to it. A transaction table might use columns for Date, Property, Category, Description, and Amount. Record expenses as positive values in the log and let the summary subtract expenses from income; mixing positive and negative conventions can make totals hard to interpret. If you prefer signed amounts, document that choice and apply it consistently.
For multiple properties, include a Property column rather than combining every transaction without an identifier. You can then filter the table to review one building or prepare a portfolio total. A separate worksheet per property can also work for a small portfolio, but use matching categories and layouts on each tab. Otherwise, consolidating reports becomes error-prone. Keep a copy of original statements and invoices, and use a reference column to find the supporting document.
In Excel for Microsoft 365 on Windows, use descriptive worksheet names, freeze the header row with View > Freeze Panes > Freeze Top Row, and apply currency formatting from Home > Number. Format values as numbers or currency rather than typing currency symbols into cells; this preserves normal arithmetic. The formulas shown also work in Excel for Mac and Excel for the web. Ribbon placement can differ slightly on Mac, and Excel for the web may present a simplified ribbon, but no special Mac-only formula is required.
Choose categories that fit the property
A useful template is detailed enough to answer questions but not so granular that every transaction needs a new category. Start with a short, stable category list, then add a category only when it supports a meaningful comparison or reporting requirement. Keep operating costs distinct from financing, owner contributions, and capital improvements.
- Repairs generally describe work that maintains or restores the property; substantial improvements may need separate tracking.
- Insurance, taxes, utilities, management, and association charges are often useful as separate lines because they behave differently and can change at different rates.
- For mixed-use or multi-unit properties, record the unit or property area where relevant, but do not allocate shared costs arbitrarily. Document the method used and check it with an accountant when needed.
- For short-term rentals, consider whether cleaning, platform fees, and guest-related supplies deserve their own lines. Keep gross receipts and fees visible rather than obscuring them in one net deposit figure.
Categories should match the purpose of the report. A management review may need detailed operational costs, while a quick owner summary can group them. Preserve the detailed transactions even if the visible monthly report uses fewer lines.
Monthly comparisons and common mistakes
Once each month is recorded, compare actual amounts with prior months or a budget. A month with unusually high repairs is not automatically a data error, but it deserves a note and supporting invoice. Compare periods of equal length and remember that seasonal rentals, annual insurance bills, and property tax installments can make monthly results uneven.
Common problems include recording a mortgage payment as one expense, counting a tenant deposit as rent, entering a transaction twice, or including a personal expense in property costs. A mortgage payment may contain both principal and interest; review the lender statement and separate the components if the report needs them. A security deposit is generally a liability while refundable, rather than earned rental revenue, but the correct treatment depends on the circumstances and applicable requirements.
Another frequent error is treating a cash P&L as a complete picture of investment performance. The P&L may omit loan principal, capital expenditures, owner contributions, or changes in property value. Conversely, depreciation can reduce accounting or taxable income without representing a current cash payment. Label the report’s purpose and basis, and do not compare it with a report using a different basis as if the figures were directly equivalent.
Template versus accounting software
An Excel template is flexible, inexpensive to start, and easy to adapt for a small number of properties. It can be sufficient for tracking monthly results when one person maintains the workbook, transaction volume is modest, and the owner checks the figures against source records. Excel also makes it straightforward to add notes and custom categories.
Its limitations grow with complexity. A workbook does not automatically reconcile every entry to bank activity, enforce a controlled approval process, or guarantee that every user follows the same categorization. Multiple editors, many properties, security requirements, and formal reporting needs may justify dedicated property-management or accounting software. Software can also require subscriptions, configuration, and training, so compare the total cost and features rather than assuming one option is always better.
Whichever approach you use, retain source documents, restrict access to financial information, and make periodic backup copies. Protecting a worksheet from casual edits can help prevent accidental changes, but sheet protection is not a substitute for secure file storage or access controls.
Frequently Asked Questions
Is there a free real estate profit and loss template in Excel?
A basic one can be made in a blank workbook using the categories and formulas above. Excel may also offer downloadable templates through its template gallery, but review the categories and formulas before relying on a downloaded file.
What should a rental property P&L include?
It commonly includes rent and other earned property income, operating expenses, and clearly separated financing or non-cash items when relevant. The exact categories depend on the property and the reporting purpose.
Should mortgage payments be included as an expense?
Do not treat the full payment as one operating expense. Interest and principal are different components; principal affects cash flow but is not the same as interest expense or an operating cost. Check the lender statement and ask a qualified accounting professional how to present them for your situation.
How often should I update the spreadsheet?
Monthly entry is a practical routine for many owners because it makes unusual costs easier to spot and supports period comparisons. Reconcile the entries to bank statements and invoices on a schedule that fits the transaction volume.
Can one workbook handle more than one property?
Yes. Add a Property field to the transaction log and use consistent categories, or keep identical worksheets for each property. For a larger portfolio or multiple users, dedicated accounting software may be easier to control and consolidate.
Use the numbers with the right context
A well-structured real estate P&L workbook makes income, operating costs, and the calculation behind the result easy to inspect. Keep transaction records, define whether figures are cash or accrual, separate NOI from financing and depreciation, and check totals against source documents. Spreadsheet results are only as reliable as the entries and assumptions behind them. For financial, tax, or legal treatment, confirm real circumstances with a qualified professional rather than relying on a generic template.
Related
- Microsoft Excel Time Tracking Template: Setup and Tips
- Microsoft Excel Strikethrough Shortcut and How to Use It
- Excel: How to Shade Every Other Row
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clear Email Address Cache in Outlook: Step-by-StepTo clear Outlook’s remembered email addresses, remove individual suggestions with the X beside them, or, in classic Outlook…
- How to Properly Archive Emails in Microsoft OutlookTo archive email in Outlook, select the message and choose Archive on the toolbar; Outlook moves it to…
- Excel Cell Won’t Move With Arrow Keys? Fixes That WorkIf an Excel cell will not move when you press an arrow key, first check whether Scroll Lock…
- How to Insert an Image in Google Sheets: In a CellTo insert an image in Google Sheets, open the sheet in a web browser, select Insert > Image,…
- How to Add Images to a Mail Merge in Microsoft WordTo add a different image to each mail-merge result in Word, put each image’s full file path in…
- How to Insert a Check Box in Word Using Alt+X ShortcutTo insert an empty check box in Word on Windows, type 2610 and press Alt+X; Word converts the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.