Video walkthrough
Read the written stepsRead the transcript
Before you watch
- Have the complete rent roll and annual-expenses reference sheet ready.
- The recordings use separate prepared expense checkpoints. Enter every source expense in your own OM, then reconcile the total to $713,700.
- The review checkpoint includes the practice financial assumptions. Follow the linked assumption guides before relying on projections.
- In this practice, in-place NOI is $592,000 and cap rate is 6.40%. Compare cash-on-cash returns by column; the Valuation cash-on-cash summary uses Year 1.
- For the practice projections, use Lease-Up Scenario: 100% Immediate, a $6,000,000 loan with a 6.25% interest rate, no interest-only period, 30-year amortization and a 10-year term.
Outcome
Your operating statement is in CREBuilder and EGI and NOI match the source you are marketing from.
Navigation path
Document wizard > Income & Expenses
Access
Full financials
On this page
Before you start
Data, sources, and access to prepare
- Full financials selected in Financials Setup
- Current operating statement
- A Multi-year projection or Current vs. stabilized choice in Financials Setup
See how the statement feeds NOI
On phones, each income or expense row appears as a labeled card. In-Place and Pro Forma amounts stay visible together. Select an amount to edit it, or use the row handle to change its order.
Income and expense flow
Rental income comes from Rent Roll; this step adds other income and subtracts operating expenses.
Rent Roll
Base rent and reimbursements
Additional Income
Parking, fees, and property-specific sources
Effective Gross Income
Income after vacancy treatment
Operating Expenses
Taxes, insurance, management, and other
NOI
EGI minus operating expenses
- Rent RollEffective Gross Income
- Additional IncomeEffective Gross Income
- Effective Gross IncomeNOI
- Operating ExpensesNOI
Multi-Year Cash Flow
- Additional income columns
- Name, Annual Amount, Increase %
- Expense columns
- Name, Basis ($ or % EGI), Annual Amount, Increase %
Pro Forma
- Additional income columns
- Name, In-Place, Pro Forma
- Expense columns
- Name, Basis ($ or % EGI), In-Place, Pro Forma
Use suggestions as a starting point
Other income examples by property type
- Retail: percentage rent, parking, antenna or billboard, late fees
- Office: parking, storage, antenna or billboard, conference-room rental
- Industrial: parking, storage yard, antenna or billboard, late fees
- Multifamily: laundry, parking, pet, storage, late, and application fees, plus utility bill-backs (RUBS)
- Hotel: food and beverage, spa, parking, meetings, retail, and laundry
- Self-Storage: late, admin, insurance, truck rental, and retail income
- Mobile Home Parks: laundry, storage, RV parking, utility reimbursements, and late fees
Keep CAM in Reimbursements
Retail, Office, Industrial, Mixed-Use, and Net Lease show a CAM Reimbursements suggestion. When the rent roll already carries reimbursements, selecting it shows a warning: "Your rent roll already includes $X of reimbursements. Add CAM Reimbursements here only for income not already in the rent roll." Select Cancel when the recoveries are already entered per tenant, so CAM is not counted twice. Select Add anyway only for recoveries that are not in the rent roll.
Enter management fees as a % of EGI
When switching financial models, annual expense and additional-income amounts become In-Place amounts; blank Pro Forma forecasts stay blank and continue to carry In-Place. An Annual zero does not overwrite an existing In-Place amount. Switching to cash flow uses In-Place, then an existing nonzero Annual amount, then Pro Forma. Existing forecasts and rates remain saved. Zero is an entered amount. Each operating expense has a Basis toggle: $ for a fixed annual amount, or % EGI for a percent of effective gross income. A Management Fee row shows the hint "Management fees are usually a % of EGI". Switching a row to % EGI converts its current amount to a percent where it can, and otherwise starts a management fee at 4%. A % EGI row is recalculated from each column's EGI after vacancy: In-Place uses in-place EGI, each projected year uses that year's EGI, and Pro Forma uses Pro Forma EGI.
Blank cells carry an amount
In Pro Forma, a blank Pro Forma cell uses the In-Place amount and shows it muted with from In-Place. A row first entered as an annual amount shows from Annual in a blank In-Place cell. Totals, Valuation, and every page use the carried figure. Type a value to replace it; clear the cell to carry again.
Hotel expenses follow hotel convention
Enter departmental costs, management fees, franchise and royalty fees, OTA commissions, and an FF&E reserve (commonly about 4% of total revenue) as operating-expense rows. NOI then matches how hotel buyers underwrite. If you do this, leave the matching Reserves fields on Valuation blank so nothing is deducted twice.
Starter rows are editable
When no expenses exist, CREBuilder may create Property Tax, Insurance, and Management Fee starter rows. Replace their amounts or delete the rows to match your statement.
Annual Amount Recommended
Current annual income or expense in cash-flow mode.
- Format
- Currency amount
- Units
- Currency per year
- Save behavior
- Saved when the income or expense row editor commits the row.
- Downstream effect
- Enters the current statement total and supplies the starting amount for projected cash flow.
Increase % Optional
Annual compound growth for the row in projected years.
- Format
- Percentage
- Units
- Percent per projected year
- Save behavior
- Saved with the income or expense row when the row editor commits it.
- Downstream effect
- Compounds that row after In-Place in Multi-Year Cash Flow. A % EGI expense shows With EGI instead, because it grows with EGI and its own increase is not used.
Basis ($ or % EGI) Optional
Whether an operating expense is a fixed dollar amount or a percent of effective gross income.
- Format
- Select $ or % EGI; a % EGI row takes a percentage such as 4
- Units
- Currency per year, or percent of EGI
- Save behavior
- Saved with the expense row when the toggle or percentage changes. Switching back to $ keeps the current dollar figure.
- Downstream effect
- A % EGI row shows, for example, 4% of EGI and is recalculated from the EGI after vacancy of every column and projected year, so it moves with income.
In-Place Recommended
Current annual amount in pro-forma mode.
- Format
- Currency amount
- Units
- Currency per year
- Save behavior
- Saved when the income or expense row editor commits the row.
- Downstream effect
- Feeds the current column, current EGI or expenses, and current NOI in Pro Forma.
Pro Forma Recommended
Stabilized annual amount in pro-forma mode.
- Format
- Currency amount
- Units
- Currency per year
- Save behavior
- Saved when the income or expense row editor commits the row.
- Downstream effect
- Feeds the stabilized column, stabilized EGI or expenses, and stabilized NOI in Pro Forma.
Financial Footnotes Optional
Numbered notes for Income & Expenses and other supported output pages.
- Format
- Numbered plain-text notes
- Units
- Not applicable
- Save behavior
- Autosaves after note entry; verify the note remains after the save state completes.
- Downstream effect
- Places the note on the selected supported financial page without changing calculations.
Annual Amount
- Requirement
- Recommended
- What it means
- Current annual income or expense in cash-flow mode.
- Format
- Currency amount
- Units
- Currency per year
- Save behavior
- Saved when the income or expense row editor commits the row.
- Downstream effect
- Enters the current statement total and supplies the starting amount for projected cash flow.
Increase %
- Requirement
- Optional
- What it means
- Annual compound growth for the row in projected years.
- Format
- Percentage
- Units
- Percent per projected year
- Save behavior
- Saved with the income or expense row when the row editor commits it.
- Downstream effect
- Compounds that row after In-Place in Multi-Year Cash Flow. A % EGI expense shows With EGI instead, because it grows with EGI and its own increase is not used.
Basis ($ or % EGI)
- Requirement
- Optional
- What it means
- Whether an operating expense is a fixed dollar amount or a percent of effective gross income.
- Format
- Select $ or % EGI; a % EGI row takes a percentage such as 4
- Units
- Currency per year, or percent of EGI
- Save behavior
- Saved with the expense row when the toggle or percentage changes. Switching back to $ keeps the current dollar figure.
- Downstream effect
- A % EGI row shows, for example, 4% of EGI and is recalculated from the EGI after vacancy of every column and projected year, so it moves with income.
In-Place
- Requirement
- Recommended
- What it means
- Current annual amount in pro-forma mode.
- Format
- Currency amount
- Units
- Currency per year
- Save behavior
- Saved when the income or expense row editor commits the row.
- Downstream effect
- Feeds the current column, current EGI or expenses, and current NOI in Pro Forma.
Pro Forma
- Requirement
- Recommended
- What it means
- Stabilized annual amount in pro-forma mode.
- Format
- Currency amount
- Units
- Currency per year
- Save behavior
- Saved when the income or expense row editor commits the row.
- Downstream effect
- Feeds the stabilized column, stabilized EGI or expenses, and stabilized NOI in Pro Forma.
Financial Footnotes
- Requirement
- Optional
- What it means
- Numbered notes for Income & Expenses and other supported output pages.
- Format
- Numbered plain-text notes
- Units
- Not applicable
- Save behavior
- Autosaves after note entry; verify the note remains after the save state completes.
- Downstream effect
- Places the note on the selected supported financial page without changing calculations.
Required means the field is needed to complete or support this workflow. Some screens allow a draft to save before every required item is complete. The steps and troubleshooting call out controls the product actively blocks.
Enter and reconcile the statement
Income and expense steps
- 1
Confirm the column model
Income & Expenses
Check whether the page shows Annual Amount and Increase % or In-Place and Pro Forma.
Expected result: The columns match the projection shown in the summary bar.
If this step does not work
Select Edit setup in the summary bar and change How should income be presented? in Financials Setup if the wrong model is shown.

Enter income, vacancy, reimbursements, expenses, and footnotes in the rows that feed effective gross income and NOI. - 2
Add an additional-income row
Additional Income section
Select the control for adding a non-rental income source.
Expected result: A new editable income row appears.
If this step does not work
Press Escape if the row was added accidentally. If a reimbursement warning appears, select Cancel when the rent roll already carries that income.
- 3
Complete the additional-income row
Additional Income row
Enter the source name and all displayed numeric values.
Expected result: The row saves and appears in the total.
If this step does not work
Select the row again to correct an inaccurate value.
- 4
Review starter expenses
Operating Expenses section
Compare Property Tax, Insurance, and Management Fee starter rows with the source statement.
Expected result: Only categories and amounts from your statement remain.
If this step does not work
Edit or delete a starter row that does not apply. Deletion is immediate, so use it carefully.
- 5
Add an operating-expense row
Operating Expenses section
Select the control for adding an operating expense category.
Expected result: A new editable expense row appears.
If this step does not work
Remove the row if it duplicates an existing category.
- 6
Choose the expense basis
Operating Expenses row > Basis
Select $ for a fixed amount or % EGI for a percent of effective gross income, such as a management fee.
Expected result: A % EGI row shows the percent and the calculated dollar amount.
If this step does not work
Select $ to return to a fixed amount. The current dollar figure is kept.
- 7
Complete the operating-expense row
Operating Expenses row
Enter its current, growth, or pro-forma amounts, or its percent of EGI.
Expected result: Total operating expenses update from the saved row.
If this step does not work
Compare one category at a time and check annual versus monthly source units.
- 8
Order the rows
Operating Expenses or Additional Income
Drag a row by its handle to its new position.
Expected result: The new order saves and is used on Valuation and every financial page. Until you reorder, expenses list Property Tax, Insurance, and Management Fee first.
If this step does not work
From the keyboard, focus the handle, press Space, move with the arrow keys, then press Space to drop.
- 9
Review suggested property tax
Income & Expenses, Property Tax row
Compare a prefilled Property Tax amount with your statement.
Expected result: The saved property tax matches the figure you want to market.
If this step does not work
CREBuilder can prefill an empty Property Tax starter row from public tax records. Type over it when your statement shows a different amount.
- 10
Add page footnotes
Financial Footnotes
Enter concise numbered notes for supported pages.
Expected result: The notes remain after autosave.
If this step does not work
Shorten or correct a note that does not save.
- 11
Check the NOI Summary
Income & Expenses, NOI Summary
Read Effective Gross Income (after vacancy), Less: Operating Expenses, and Net Operating Income.
Expected result: The card shows the same figures as Valuation.
If this step does not work
Correct the first mismatched rent-roll or statement row if NOI is not what you expect.
- 12
Verify statement totals
Income & Expenses totals
Compare every displayed total with your statement.
Expected result: The totals match, and Continue moves you to Valuation.
If this step does not work
Continue does not check the numbers for you, so correct the first mismatched row before leaving.
Resolve statement mismatches
A monthly source amount makes the annual total too low
Likely cause: The page expects annual amounts.
- Annualize the source amount outside the row.
- Enter the annual total.
- Document the convention in a footnote if readers need it.
The page has no growth columns
Likely cause: The projection chosen in Financials Setup is Current vs. stabilized (Pro Forma).
- Enter separate In-Place and Pro Forma values.
- If annual growth is required, select Edit setup and choose Multi-year projection.
An expense shows With EGI instead of an increase rate
Likely cause: The row uses the % EGI basis, so it grows with EGI.
- Keep % EGI for fees that follow income, such as management.
- Select $ to give the row its own Increase %.
CAM or reimbursements look counted twice
Likely cause: Reimbursements are in the rent roll and also entered as Additional Income.
- Compare the Additional Income rows with the rent-roll reimbursement total.
- Delete the duplicate Additional Income row.
NOI differs from the source
Likely cause: Rental income, vacancy, reimbursements, additional income, or expense rows may differ.
- Reconcile rent-roll income first.
- Then additional income.
- Then total operating expenses.
- Compare EGI and NOI last.
Final verification
- Income & Expenses, Property Tax row: The saved property tax matches the figure you want to market.
- Financial Footnotes: The notes remain after autosave.
- Income & Expenses, NOI Summary: The card shows the same figures as Valuation.
- Income & Expenses totals: The totals match, and Continue moves you to Valuation.
- No blocking warning, failed status, or unresolved validation message remains in the completed workflow.
Related guides
Build a commercial rent roll
Build a tenant-by-tenant rent roll for retail, office, or industrial, and CREBuilder annualizes rent and recoveries from whatever basis your lease uses.
Open guideBuild and verify a pro forma analysis
Show buyers the upside: current and stabilized rent, income, expenses, and NOI side by side in one clean comparison.
Open guideRead and verify the cash-flow projection
Read the Multi-Year Cash Flow line by line, from base rent to cash flow after debt, so you can explain every number to a buyer.
Open guideYour next OM, done this afternoon
Turn your property facts, photos and financials into a polished, branded offering memorandum. Most brokers finish in 30 to 90 minutes.
No credit card required.