For OMC directors and volunteer boards

Service charge budget and sinking fund for owners' management companies

Every year the OMC board has to propose a service charge budget, split it fairly between the units and show that the sinking fund will cover the big works ahead. The workbook does the three jobs together and produces a dashboard for board meetings and the AGM.

  • Up to 100 units and 30 components
  • Budget in the 9 MUD Act categories
  • Arrears aged 0–30 to 90+ days
  • 20-year sinking fund projection
Add to basket
OMC Service Charge Budget – Dashboard

Budget and levies

BUDGET compares last year's budget with what was actually spent and sets out the proposal in the nine categories of the Multi-Unit Developments Act 2011. LEVIES splits the service charge and the sinking fund per unit by the share in the lease or by floor area, payable annually, half-yearly or quarterly.

Is the sinking fund big enough?

COMPONENTS lists the common-area items – roofs, lifts, fire alarms, render – with when they were last done, their life, condition and cost. SINKING FUND projects twenty years of works and balances and recommends a contribution with a safety margin.

The Act sets €200 per unit per year as the default contribution unless a general meeting agrees another amount; the workbook shows whether that is enough for your building.

Common questions

Can units have different shares?
Yes. Each unit has its floor area and its share from the lease, and you choose which one is used.
Does it replace our managing agent?
No. It gives the board its own view of the numbers and is useful when discussing the budget with the agent.
Can we compare budget and actual mid-year?
Yes. Actual figures can be entered at any point, and the variance is shown per category.

A look at the sheets

Workbook facts

  • START
  • SETTINGS
  • UNITS
  • BUDGET
  • LEVIES
  • PAYMENTS
  • COMPONENTS
  • SINKING FUND
  • DASHBOARD
File format
.xlsx
Tabs
9
Units / components
100 / 30
Requires
Excel 2016+ / Microsoft 365
Macros
None

Arrears

  • Payments per instalment and balance owed per unit
  • Ageing in 0–30, 31–60, 61–90 and 90+ day bands
  • Totals for the board report

A budget the owners can follow at the AGM

Add the service charge budget to your basket and continue to payment.

Add to basket