Service Charge Financial Year Reporting
Service Charge Financial Year Reporting
The Reports module enables agents to generate comprehensive end-of-year financial summaries for any block. Reports can be viewed on-screen, exported as a branded PDF statement (compliant with Landlord and Tenant Act 1985, s.21), or downloaded as a multi-sheet Excel workbook.
Accessing Reports
Navigate to Dashboard → Reports (the bar chart icon in the sidebar, between Reconciliation and Client Money).
Generating a Report
- Select a block from the dropdown. All blocks in your organisation are listed.
- Select a financial year. The dropdown automatically shows years that have budgets or demands for the selected block. If none are detected, the last five calendar years are shown as a fallback.
- Click Generate Report.
The report loads with full data for the selected block and year. Changing the block or year resets the report and requires you to generate again.
Report Sections
KPI Summary Cards
Four headline figures are shown at the top of the report:
| Card | Description |
|---|---|
| Total Demanded | Sum of all service charge demands raised in the financial year. Shows the approved budget total beneath if a budget exists. |
| Total Received | Payments received, with the collection rate shown as a percentage. |
| Outstanding | Unpaid balance. Shows write-offs separately if any exist. |
| Reserve Fund | Closing balance of the reserve fund account for the period. |
Budget vs Actuals Chart
A horizontal bar chart comparing budgeted allocation to actual income collected, broken down by service charge category (e.g. Cleaning, Insurance, Repairs & Maintenance, Reserve Fund). Budget bars are shown in a lighter shade; actual bars in the primary colour.
Monthly Cashflow Chart
A vertical bar chart showing the total payments received in each month of the financial year. Months with no payments are rendered at minimum height.
Reserve Fund Movement
A panel showing the full movement of the reserve fund account during the year:
- Opening balance
- Contributions received
- Interest earned
- Expenditure
- Transfers in / transfers out
- Adjustments
- Closing balance
Interest, transfers, and adjustments are only shown when non-zero.
Budget vs Actuals — Itemised Schedule
A table listing every budget line item with its category, description, budgeted amount, actual collected amount, and variance. Variances are colour-coded:
- Green — actual is under budget (favourable)
- Red — actual exceeds budget (adverse)
A bold totals row appears at the bottom.
Leaseholder Demand Summary
A per-unit table listing every leaseholder in the block with:
- Unit number
- Leaseholder name
- Apportionment share (%)
- Total demanded
- Total paid
- Outstanding balance
- Payment status badge: Paid, Partial, Overdue, or Unpaid
Exporting Reports
Once a report has been generated, two export buttons appear in the top-right of the report header.
Export PDF
Produces a branded, multi-page A4 PDF statement. The file is generated entirely in the browser using @react-pdf/renderer and is downloaded automatically as <BlockName>_FY<Year>_Statement.pdf.
Pages included:
- Cover page — Block name, address, financial year, period dates, agent name, and ARMA/RICS membership numbers (if configured in branding settings). Includes a citation of the Landlord and Tenant Act 1985, Section 21.
- Income & Expenditure Summary — KPI totals and the full budget vs actuals table.
- Reserve Fund Movement & Leaseholder Schedule — Complete reserve fund breakdown and a schedule of all leaseholder demands.
The PDF primary colour is taken from your agent branding settings.
Export Excel
Produces a .xlsx workbook with five worksheets, downloaded as <BlockName>_FY<Year>_Report.xlsx:
| Sheet | Contents |
|---|---|
| Summary | Block, financial year, period, and all KPI figures |
| Budget vs Actuals | Per-category rows with budget, actual, variance, and a totals row |
| Monthly Cashflow | Month and income (£) for each month of the year |
| Reserve Fund | Full movement breakdown with bold closing balance |
| Unit Summary | All leaseholder details including share, demanded, paid, outstanding, and status |
All monetary values in Excel exports are stored as decimals in pounds (e.g. 1234.56), not pence.
Compliance & Audit
- Reports are scoped to your organisation — no data from other organisations is accessible.
- Access is controlled by role-based permissions via your organisation's Roles & Permissions settings.
- Each report generation is recorded in the audit log.
- PDF statements cite the Landlord and Tenant Act 1985, Section 21 on the cover page, satisfying the statutory requirement for agents to provide service charge accounts.
Supported Service Charge Categories
The following categories are recognised and displayed with human-readable labels in charts, tables, and PDF exports:
Cleaning, Insurance, Management Fee, Repairs & Maintenance, Reserve Fund, Utilities, Lift Maintenance, Fire Safety, Grounds Maintenance, Professional Fees, Communal Electricity, Water Rates, Door Entry, Pest Control, Health & Safety, Accountancy, Company Secretary, Bank Charges, Sundries, Other
Unrecognised category keys are displayed as-is.