NHS IFRS 16 lease accounting Case Study: Find out how Cornwall NHS PFT cut lease management effort by over 50%

Technical illustration of lease records and monthly reporting in an NHS finance setting

Cornwall Partnership NHS Foundation Trust uses FMIS Lease Accounting to manage its IFRS 16 lease portfolio. Within its first six months of using FMIS, the trust estimated that it saved 5–10 staff hours in a typical month. Managing lease changes and early terminations showed the biggest improvement, with an estimated reduction of more than 50% in time or effort.

The challenge of managing leases in spreadsheets

The trust previously relied on spreadsheet models to manage its IFRS 16 lease portfolio. The finance team used manual workarounds for lease calculations and complex changes. The trust identified moving this work into a dedicated lease accounting system as the most valuable practical benefit.

Managing lease calculations and changes in FMIS

The finance team now manages lease calculations and complex changes within FMIS Lease Accounting, reducing its reliance on spreadsheet workarounds. The trust identified lease changes and early terminations as the process that improved most.

The trust also reported more consistent data, less manual administration, faster processing and fewer errors or adjustments. It highlighted improvements in financial control, compliance or audit readiness and rated FMIS as very effective in meeting its objectives.

Customer reported results

Customer reported results at Cornwall Partnership NHS Foundation Trust
Measure Customer-reported result
Managing lease changes and early terminations Estimated at more than 50% less time or effort
Staff time saved across the team Estimated at 5–10 hours in a typical month
Spreadsheets, databases or separate manual records 6–10 replaced or materially reduced

Source is the trust’s benefits and outcomes questionnaire, completed within its first six months of using FMIS.

Monthly reconciliations and annual accounts evidence

The finance team uses FMIS reports as the starting point for monthly lease reconciliations and as supporting evidence for the annual accounts. The team reviews the outputs and keeps supporting Excel schedules. The trust said this gives it a more robust basis for managing lease liabilities and right-of-use assets.

“FMIS has made our lease accounting more structured and reduced our reliance on spreadsheet work-arounds. It is particularly useful for lease changes, monthly reporting and supporting reconciliations.”

Cornwall Partnership NHS Foundation Trust

Implementation insight from FMIS

“Having the trust’s chief accountant and financial accountant involved throughout the implementation made a real difference. They were on hand to answer questions about the data and explain what the team needed from its reports. Knowing that from the start helped us work out what to record for each lease and right-of-use asset, including the cost centre codes the team needed to report on leases from start to finish, however long they ran. The trust had already set up its IFRS 16 ledger accounts, which made it easier for us to configure the postings in FMIS.”

Vicky Stanley
FMIS implementation consultant

Practical lessons for public sector finance teams

  • Review how you handle lease changes and early terminations. Identify where the team relies on manual spreadsheet workarounds and test how those cases would be handled in the lease accounting system.
  • Plan monthly reconciliations and annual accounts evidence together. Agree which system reports the team will review each month and which supporting schedules it will keep for the annual accounts.
  • Work through unusual leases early. Include relevant examples such as peppercorn leases when familiarising the team with the system. The trust reported that it was still building familiarity with more complex cases.

Questions about the lease accounting project

The trust estimated that managing lease changes and early terminations took more than 50% less time or effort.

The trust uses FMIS reports as a basis for monthly reconciliations and annual accounts evidence. The team reviews the outputs and keeps supporting Excel schedules.

Cornwall Partnership NHS Foundation Trust uses FMIS Lease Accounting.

Explore FMIS NHS IFRS 16 Lease Accounting Software

Explore how FMIS Lease Accounting supports IFRS 16 lease calculations, lease changes and financial reporting, or request a demonstration to discuss your finance team’s requirements.