Annual operating budget template
An annual operating budget for a rental property plans a year of income and expenses, line by line, and shows the net operating income (NOI) and cash flow they leave. This free template spreads each line across four quarters, so seasonal costs like heat, snow and turnovers land when they really happen.
Example: 40 Grove St, 24 units, budget year 2027. Effective gross income $470,640.00, operating expenses $199,515.20, NOI $271,124.80.
| Line item | Type | Q1 (Jan to Mar) | Q2 (Apr to Jun) | Q3 (Jul to Sep) | Q4 (Oct to Dec) | Annual | Basis |
|---|---|---|---|---|---|---|---|
| Gross potential rent | Income | $118,800.00 | $118,800.00 | $118,800.00 | $118,800.00 | $475,200.00 | 24 units at an average of $1,650.00 a month, fully leased |
| Vacancy and credit loss | Income | -$5,940.00 | -$5,940.00 | -$5,940.00 | -$5,940.00 | -$23,760.00 | 5% of gross potential rent |
| Other income | Income | $1,800.00 | $1,800.00 | $1,800.00 | $1,800.00 | $7,200.00 | Laundry, parking and fees |
| Utility reimbursements | Income | $3,000.00 | $3,000.00 | $3,000.00 | $3,000.00 | $12,000.00 | Water and sewer billed back to residents |
| Effective gross income | Total | $117,660.00 | $117,660.00 | $117,660.00 | $117,660.00 | $470,640.00 | Rent less vacancy, plus other income and reimbursements |
| Property taxes | Expense | $13,500.00 | $13,500.00 | $13,500.00 | $13,500.00 | $54,000.00 | Quarterly installments from the tax bill |
| Insurance | Expense | $4,200.00 | $4,200.00 | $4,200.00 | $4,200.00 | $16,800.00 | Property and liability policy, spread evenly |
| Management fee | Expense | $9,028.80 | $9,028.80 | $9,028.80 | $9,028.80 | $36,115.20 | 8% of rent collected (rent less vacancy and credit loss) |
| Repairs and maintenance | Expense | $6,000.00 | $6,500.00 | $7,000.00 | $6,500.00 | $26,000.00 | Work orders and supplies; higher in summer |
| Turnover and make-ready | Expense | $3,000.00 | $4,500.00 | $4,500.00 | $2,000.00 | $14,000.00 | Most leases end in spring and summer |
| Water and sewer | Expense | $4,000.00 | $4,400.00 | $4,800.00 | $4,000.00 | $17,200.00 | Master-metered; offset in part by utility reimbursements |
| Electric, common areas | Expense | $1,050.00 | $900.00 | $1,200.00 | $1,050.00 | $4,200.00 | Hallways, exterior lights and laundry room |
| Gas for heat | Expense | $5,200.00 | $1,400.00 | $600.00 | $3,800.00 | $11,000.00 | Central boiler; peaks in winter |
| Trash removal | Expense | $1,350.00 | $1,350.00 | $1,350.00 | $1,350.00 | $5,400.00 | Contract rate |
| Landscaping | Expense | $0.00 | $2,400.00 | $2,400.00 | $1,200.00 | $6,000.00 | Contract season April to November |
| Snow removal | Expense | $2,800.00 | $0.00 | $0.00 | $1,200.00 | $4,000.00 | Per-event estimate from last two winters |
| Pest control | Expense | $450.00 | $450.00 | $450.00 | $450.00 | $1,800.00 | Monthly exterior service |
| Administrative and professional | Expense | $750.00 | $750.00 | $750.00 | $750.00 | $3,000.00 | Postage, bank fees, legal and accounting |
| Total operating expenses | Total | $51,328.80 | $49,378.80 | $49,778.80 | $49,028.80 | $199,515.20 | Sum of the expense lines |
| Net operating income | Total | $66,331.20 | $68,281.20 | $67,881.20 | $68,631.20 | $271,124.80 | Effective gross income less operating expenses |
| Replacement reserve | Below NOI | $2,400.00 | $2,400.00 | $2,400.00 | $2,400.00 | $9,600.00 | Saved for roofs, boilers and other capital items |
| Debt service | Below NOI | $21,000.00 | $21,000.00 | $21,000.00 | $21,000.00 | $84,000.00 | Principal and interest, if the property is financed |
| Cash flow after reserve and debt service | Total | $42,931.20 | $44,881.20 | $44,481.20 | $45,231.20 | $177,524.80 | Net operating income less reserve and debt service |
How to use it
- Start with gross potential rent: every unit at its current or planned rent for the full year. Add planned rent increases in the quarter they take effect.
- Subtract vacancy and credit loss as a percent, based on the property's own history.
- Add other income and utility reimbursements, then total effective gross income.
- Budget each expense from last year's actuals, adjusted for known changes such as new contracts, tax bills and insurance renewals.
- Spread each line into the quarter it will be paid. Heat in winter, landscaping in summer, turnovers when leases end.
- Subtract total operating expenses from effective gross income for NOI. Put the replacement reserve and debt service below NOI.
- Each month, compare actuals to the budget and explain any line that is off by more than a set amount.
What goes in a rental property operating budget?
Income (gross potential rent, vacancy and credit loss, other income), every operating expense, NOI, and below NOI the replacement reserve and debt service, which leave cash flow.
Why budget by quarter or month instead of by year?
Costs are seasonal. A yearly figure divided by 12 hides when cash is really needed, such as a winter heating bill or a summer of turnovers.
Is the management fee an operating expense?
Yes. Management fees are an operating expense and count in NOI. Here the fee is 8% of rent collected, which is gross potential rent less vacancy and credit loss.
Where do capital expenses and loan payments go?
Below NOI. Replacement reserves, capital projects and debt service don't count as operating expenses, so they sit under the NOI line.
How do I track the budget during the year?
Compare each month's actuals to the budget and look into the lines that are off. That comparison is called budget variance. In Zrico, budgets are kept by account and month for each property, in the same books as the actuals.
See Zrico run your portfolio.
Bring a property. We will show you, on your own data, what Zrico would have handled last month.