UK local government

    Retire Legacy ERP, Finance & HR Systems in UK Local Government

    Modernise finance, procurement, HR and payroll while retaining secure access to the historical records your authority still needs.

    Unit4 / AgressoOracleSAPLegacy PayrollHR SystemsBespoke Databases
    UK Public SectorSyntraETL data migration, archival and legacy application retirement services are available to UK public-sector buyers through the G-Cloud 15 framework.Explore G-Cloud 15 services →

    Modernisation Is Often Complete Before Legacy Retirement Is

    Legacy systems stay online because historical information is difficult to retrieve anywhere else. Removing that dependency — properly, with evidence — is the whole objective.

    ERP replacement / shared service / reorganisationThe transformation trigger
    New finance or HR platform implementedProgramme delivers and closes
    Only required operational data migratesOpen items, active suppliers, current establishment
    Historical data remains across old ERP and departmental systemsClosed years, leavers, completed procurement, scanned documents
    Finance, HR, audit and information teams still require accessExternal audit, FOI, DSAR, pension and pay queries
    Old applications remain onlineOften several of them, not one
    Licence, support, infrastructure and security costs continuePlus a standing entry on the risk register
    SyntraETL enables controlled retirementHistory preserved, reconciled and searchable — then the estate comes down

    Common Triggers for Legacy System Retirement

    ERP replacement

    Moving to a modern cloud finance or ERP platform, with the outgoing system left holding the history.

    Local government reorganisation

    Multiple legacy estates arriving at one new authority, each with its own finance, HR and payroll history.

    Shared services

    Finance, procurement, HR or payroll functions combined across authorities, leaving several source systems behind.

    Vendor or platform risk

    Legacy products becoming harder and more expensive to support, with scarcer skills behind them.

    Cloud migration

    On-premise infrastructure being reduced, where lifting an obsolete application into the cloud only relocates the cost.

    Budget pressure

    Old application run costs persisting after the transformation programme has closed and its budget has gone.

    Procure SyntraETL Services through G-Cloud 15

    Firstcron Services UK Ltd is registered on G-Cloud 15, so an authority can call this work off under the existing framework agreement rather than running a separate procurement exercise.

    Legacy Estate Discovery

    Inventory, volumes, retention requirements, target architecture and an implementation estimate.

    ERP / HCM data migration

    Finance, procurement, HR and payroll data moved into the new platform in reconciled cycles.

    Historical data archival

    Records preserved with retention periods, legal-hold status and lineage attached.

    Reconciliation & validation

    Counts, control totals and categorised exceptions as the evidence a shutdown is signed against.

    Legacy application retirement

    Staged decommissioning once business, contractual and technical dependencies are removed.

    How it is bought

    Defined-scope engagements, fixed-price work packages, a programme workstream or outcome-based delivery.

    View G-Cloud 15 Services →

    The final official G-Cloud listing and contract terms govern the scope of procurement. Where anything on this page differs from that listing, the listing governs.

    Is Unit4 / Agresso Still Running Only Because You Need the History?

    UNIT4 / AGRESSO

    Operational data

    • Active suppliers
    • Open transactions
    • Active employees
    • Current balances
    • Active commitments
    New ERP

    Historical data

    • Closed suppliers
    • Historic invoices
    • Historical purchase orders
    • Payments and journals
    • Former employees and payroll history
    • Attachments and audit records
    DataMove
    DataVault
    DataLens
    Unit4 Retired

    Preserve Historical Finance Without Preserving the Finance System

    The finance record classes an authority is most often asked for after the new system is live — by external audit, by members, and by its own accountants closing a prior year.

    General ledgerJournalsBudgetsCost centresAccounts payableAccounts receivableInvoicesPaymentsDebtors and creditorsFixed assetsHistorical reporting

    DataLens provides authorised access to this information after the source application is retired: named finance users search, retrieve, report and export against the archive, scoped by role and logged, without the ledger system running behind it.

    Maintain Procurement History After ERP Transformation

    Procurement history carries transparency and audit obligations that outlast the system which recorded it.

    SuppliersRequisitionsPurchase ordersReceiptsInvoicesApprovalsAttachmentsSupporting documents

    Scope covers the procurement data held in the source ERP. Contract-management records are only in scope where the source system actually holds them; SyntraETL does not provide contract management.

    HR and Payroll History

    HR

    • Employee history
    • Assignment history
    • Organisation structures
    • Job history
    • Absence
    • Compensation where available

    Payroll

    • Payroll results
    • Payments
    • Deductions
    • Historical reports
    • Employee payroll records

    Exact scope depends on what the source system actually holds and on the authority's own retention policy. Both are established during discovery rather than assumed.

    Retire the Long Tail of Legacy Applications

    A council's legacy estate is rarely limited to one ERP. Historical information often remains across Oracle databases, SQL Server applications, departmental systems and bespoke tools — individually small, collectively expensive, and almost never costed as a group.

    Oracle database · SQL Server application · departmental finance database · legacy HR application · old reporting repositoryThe applications that never made the strategic roadmap
    DataMoveOne extraction approach across all of them
    DataVaultOne archive, one retention model, one access-control model
    DataLensOne place users look, rather than five
    Multiple applications retiredA retirement programme rather than a project

    Consolidating the long tail is usually where the economics turn: a single archive replacing five applications removes five sets of licence, infrastructure, backup and support cost against one implementation.

    Each application still comes down the same way — the four-stage Syntra Legacy Exit model, and the same account of what retirement removes and what it must preserve. What changes at this scale is sequencing: applications are retired in renewal-date order, so each shutdown funds the next.

    Consolidate Historical Data During Local Government Reorganisation

    Reorganisation is the hardest version of this problem: several authorities, several ERP estates, one new organisation, and a legal obligation to keep every predecessor's records retrievable.

    Authority A — Unit4  ·  Authority B — Oracle  ·  Authority C — legacy payroll  ·  Authority D — bespoke SQL

    Required operational data

    • Open balances and commitments
    • Active suppliers
    • Current establishment
    • In-flight transactions
    New authority ERP / HCM

    Historical records

    • Each predecessor's closed years
    • Historical payroll and HR records
    • Completed procurement and payments
    • Attachments and audit history
    DataVault
    DataLens
    Legacy estates progressively retired

    Illustrative architecture. This is a description of how the approach applies to reorganisation, not an account of a delivered SyntraETL programme.

    Because each predecessor estate is archived on the same retention and access model, the new authority ends up with one place to answer a question about any of them — rather than inheriting four sets of applications it cannot switch off.

    Preserve Access Without Preserving the Application

    UK GDPRData Protection Act 2018Freedom of Information Act 2000DSAR handlingRetention schedulesLegal holdEvidenced disposalAccess audit trail
    Authorised searchNamed users find a record by the identifiers they actually use, scoped by role through your identity provider.
    Audit trailsEvery search, view and export is logged — usually tighter control than the legacy application offered.
    ExportsResults exported in a defensible format for FOI, DSAR, audit and legal responses.
    Records retentionYour retention schedule is applied to archived records, so disposal is scheduled rather than indefinite.
    Legal holdRecords under hold are exempt from scheduled disposal until released, and the hold itself is recorded.
    Controlled disposalAt the end of a retention period, disposal is actioned and evidenced.
    Information retrievalStatutory deadlines met from the archive rather than from a barely-supported legacy system.

    SyntraETL can support historical information retrieval and approved records-management processes. It does not provide legal advice, does not set retention periods, and does not by itself make an authority compliant with FOI or data-protection law.

    Validate the Archive Before Legacy Shutdown

    Reconciliation — illustrative example
    ValidationSourceArchiveStatus
    AP invoices4,821,0514,821,051
    Suppliers81,42181,421
    Journals12,331,08712,331,087
    Attachments442,901442,901

    Illustrative example. The figures show how reconciliation evidence is presented; they are not drawn from a specific engagement.

    Record counts

    Source, transformed, rejected and archived counts on every cycle.

    Financial totals

    Control totals on ledger and payables data, so a matching row count cannot hide a broken value.

    Relationship checks

    An archived invoice still resolves to its supplier, purchase order, approvals and attachments.

    Document counts

    Attachments reconciled separately from the transactions they belong to.

    Exception reporting

    Discrepancies categorised and explained rather than netted off.

    Business acceptance

    Finance, HR and information governance accept the evidence before shutdown is authorised.

    Reduce the Cost of Maintaining Historical Applications

    Cost of keeping the legacy application

    Vendor / support£80,000
    Infrastructure£35,000
    Database / technical support£25,000
    Application support£55,000
    Security, backup and DR£20,000
    Annual legacy cost£215,000 / year

    Illustrative Syntra Legacy Exit

    Implementation (one-off)£75,000
    Ongoing archive and support£20,000 / year
    Year one net position£120,000 saved
    Vendor and infrastructure cost removed£115,000 / year
    Three-year cost of the exit£135,000
    Potential three-year avoided operating cost, net of the exit itself, on these illustrative figures£510,000

    Illustrative example only. Actual savings depend on vendor contracts, infrastructure, data volumes, support models and retirement scope.

    Who This Is For

    Titles differ between authorities; the interests below do not.

    Finance

    Section 151 officer / finance leadership

    Legacy-system cost reduction, and continued access to finance history for closedown, audit and members' questions.

    Technology

    CIO / Director of IT

    Application rationalisation and technical debt reduction across an estate nothing ever leaves.

    Programme

    ERP Programme Director

    Controlled migration and a legacy retirement that actually closes the programme.

    Procurement

    Head of Procurement

    Historical supplier, purchase order and approval access for transparency and audit.

    People

    HR / payroll leadership

    Employee and payroll history for pensions, verification and employment relations cases.

    Governance

    Information governance / records

    Retention, retrieval, audit and evidenced disposal — and a defensible answer to FOI.

    Relevant international experience

    SyntraETL has not yet published a UK local-government engagement. The engagements below are the same architecture delivered elsewhere — including a local council in Ireland — and are shown on that basis.

    These are published SyntraETL engagements outside the UK, shown because the architecture is the same one applied here. They are not UK public-sector references and are not presented as such.

    Identify Applications You Can Retire

    Tell us which ERP, finance, HR, payroll and departmental systems remain in your estate. We'll help identify what can be retired and what historical information must remain accessible.

    If you would rather start with a single application than the whole estate, the shorter Legacy Exit Assessment returns an indicative scorecard for one system in a couple of minutes.

    UK Public SectorSyntraETL data migration, archival and legacy application retirement services are available to UK public-sector buyers through the G-Cloud 15 framework.Explore G-Cloud 15 services →
    Usually what sets the programme deadline
    We use your answers to prepare a scoped Discovery proposal. See our privacy policy.

    Council questions

    Can SyntraETL archive Unit4 / Agresso data for councils?
    Yes. Finance, procurement, HR and payroll records are extracted with their attachments and relationships into DataVault, reconciled back to Unit4, and made searchable through DataLens so the Unit4 environment can be decommissioned.
    Can multiple council systems be consolidated during reorganisation?
    Yes. Each predecessor authority's estate is archived on the same retention and access model, so the new authority has one place to answer a question about any of them rather than inheriting several sets of applications it cannot switch off.
    Can historical finance and procurement data remain searchable?
    Yes. Ledger, payables, receivables, supplier, purchase order, payment and approval records stay searchable and exportable in DataLens for named users, scoped by role.
    Can old Oracle and SQL Server applications also be retired?
    Yes, and this is usually where the economics turn. Departmental databases and bespoke tools are archived on the same model as the ERP, so one archive can replace several applications.
    How does SyntraETL support FOI and audit retrieval?
    Historical records remain searchable and exportable within statutory deadlines, with every access logged. SyntraETL supports the authority's approved records-management processes; it does not itself guarantee FOI or data-protection compliance.
    How is historical data reconciled before shutdown?
    Record counts, financial control totals, relationship checks and document counts are taken at source and at the archive on every cycle, with discrepancies categorised. That evidence pack is what the shutdown decision is signed against.
    Can documents and attachments be preserved?
    Yes. Scanned invoices, contracts and correspondence are archived against the transaction or record they belong to, not as a separate document dump.
    Can SyntraETL services be procured through G-Cloud 15?
    Yes. Firstcron Services UK Ltd is registered on G-Cloud 15, so the work can be called off under the existing framework agreement. The published listing and its call-off terms govern the scope.

    Identify Applications You Can Retire

    An estate assessment establishes which applications are being kept alive purely for historical access, what has to be retained and for how long, what they cost today, and what retiring them would return against the next renewal date.

    UK Public SectorSyntraETL data migration, archival and legacy application retirement services are available to UK public-sector buyers through the G-Cloud 15 framework.Explore G-Cloud 15 services →