Replacing the legacy finance core

An organisation replacing its legacy finance system as the first step into an ERP — mapped against the model, with the parts it cannot change alone made explicit.

Government200–2,000Australia

A composite worked example, not a client. It is assembled from patterns that recur in asset-intensive, externally regulated organisations, and from this library's model. No organisation is described. Every derived section — the streams, the modules dragged in, the phase order, the straddling interfaces — is computed from the same model the rest of the site runs on.

Where it stands

The finance core is the oldest system in the estate and the one everything else posts to. It holds the general ledger, payables, receivables control, cash and the fixed asset register, and it has been extended over enough years that nobody can now state its customisations without going to look.

It is not the only place finance happens. Customer billing sits in its own system and reaches the ledger as a summary; work order costs sit in the works and asset system and reach it as a periodic journal; project costs sit partly in both. The finance core is the place those three meet, which is why replacing it is not a finance project.

The reporting layer around it is spreadsheets. Statutory reporting, the regulatory cost allocation and the capital programme position are all assembled outside the system from extracts, and the assembly is held by a small number of people.

Support is thin. The people who know why the customisations exist are fewer each year, and the vendor's support position on the current version is the clock this programme is actually running against.

Why now

  • End of support on the current version, which converts a discretionary decision into a dated one.
  • Regulatory cost allocation is assembled manually each period, which makes the external submission expensive to produce and hard to defend line by line.
  • The capital programme is the largest thing the organisation does and its financial position is reconstructed rather than reported.
  • Segregation of duties is maintained by convention in a finance team small enough that several conflicting combinations sit with one person.
  • Every one of those is a reason to change something. Only the first is a reason to change it this year.

What that scope actually implies

7 areas picked, 24 topics in scope across 7 modules

The streams these picks sit on cross into Customer Relationship Management, Enterprise Asset Management, Integration, PMO & Programme Governance. Nobody picked those, and the work still happens there.

The end-to-end it sits on

Record-to-Report

Financial Accounting → Data & Analytics

Procure-to-Pay

Supply Chain Management → Financial Accounting

Order-to-Cash

Customer Relationship Management → Supply Chain Management → Financial Accounting

Cash & Treasury

Financial Accounting

Acquire-to-Retire (Assets)

Financial Accounting → Enterprise Asset Management

Migrate-to-Steady-State

Data & Analytics → Integration

Plan-to-Cutover (Go-Live)

PMO & Programme Governance → Data & Analytics → Integration

Deliberately out of scope

Exclusions cause scope fights when they are assumed rather than written. Each one here has the reason attached.

Customer billing

A large customer base, its own regulatory obligations and its own release cycle. It stays, and the receivable becomes an interface rather than a sub-ledger. This is the largest single scope decision on the programme and it should be made once, in writing.

Works and asset management

The maintenance system keeps the work orders and the physical asset register. Finance takes the costs and owns the financial asset register. The reconciliation between the two registers is in scope even though neither system is.

Payroll and HR

Out of scope for this release, in scope as an interface. The payroll journal and the net pay file both land in the finance core, so 'not changing payroll' still means testing payroll.

The operational technology estate

No financial transaction originates there. Named here only so that it is named, because it is the assumption most often left unstated.

Inventory

The model flags it as a prerequisite this scope leans on. If stores are staying where they are, that is a decision; if the ledger will take stock movements from a system nobody is changing, that interface belongs on the list below.

The boundary

Every system the finance core exchanges data with, and what happens to that interface. An interface with no disposition is an interface somebody will discover during testing.

Billing revenue and receivables

Rebuild

Revenue postings, receivable balances and cash appliedCustomer billing system

Today's interface posts a summary the ledger cannot decompose. If it is rebuilt at the same grain, regulatory revenue reporting stays a spreadsheet exercise. This is the interface to design first, not to port.

Bank statement and payment files

Rebuild

Statements in, ABA and direct entry files outBanking platform

Format, testing window and the bank's own change lead time are on the critical path and are outside the programme's control. Book it early.

Payroll journal and net pay

Carry as-is

Period journal in, net pay file outPayroll system

Not changing payroll does not mean not testing payroll. A failed payroll journal is a month that does not close, and a failed pay file is a pay day that does not happen.

Work order costs and capitalisation

Rebuild

Labour, plant and materials costs; capitalised project costs; asset register alignmentWorks and asset management system

The highest-value and highest-risk interface on the programme. It carries most of the capital spend and it is the point where the financial and physical asset registers are supposed to agree.

Statutory and Treasury reporting

Rebuild

Statutory accounts, periodic returns, regulatory cost allocationDepartmental and regulator reporting

Currently assembled from extracts by a small number of people. The replacement either fixes this or inherits it, and inheriting it is a choice that should be made deliberately.

Supplier invoicing

Rebuild

Supplier invoices in, remittance advice outSuppliers, e-invoicing and portals

The chance to move non-PO spend onto a purchase order is here, and it closes once the new process is live and the workarounds have set.

Stores and inventory movements

Not decided

Stock movements and valuationStores system

Whether stores moves, stays or is absorbed has not been settled in this scope. Until it is, the ledger has a sub-ledger with no named owner.

Reporting extracts

Rebuild

Trial balance, cash position and dimensional extractsData warehouse and reporting

Every downstream report is written against the old chart of accounts. Chart changes are reporting changes, and the effort belongs in this programme rather than in the reporting team's backlog.

Flows the model says straddle this boundary

Derived from the scope, not written here: hand-offs where one side is being changed and the other is not. Compare them against the boundary list above — anything present here and missing there is a gap.

Payroll journalPayroll

General Ledger · per pay run · without it: Labour cost is missing from the period and the month cannot close.

Trial balance extractBusiness Intelligence

General Ledger · daily · without it: Reporting runs on stale numbers.

Cash position and forecastBusiness Intelligence

Cash Management · daily · without it: Treasury decisions are made on yesterday's balance.

Payroll journalGeneral Ledger

Payroll · per pay run · without it: Labour cost is missing from the period.

Net pay fileABA

Payroll · per pay run · without it: Staff are not paid.

Capitalised project costsProject Costing

Asset Management · monthly · without it: Capital work in progress never becomes an asset.

Asset register alignmentAsset Lifecycle Management

Asset Management · continuous · without it: The financial register and the physical register describe different assets.

Customer ordersSales Force Automation

Order Processing · continuous · without it: Orders are rekeyed and differ from what was agreed.

Stock movementsGeneral Ledger

Inventory Management · continuous · without it: Inventory value in the ledger stops matching the warehouse.

Reporting extractsGeneral Ledger

Business Intelligence · daily · without it: Management reporting diverges from the ledger.

What this context does to a generic finance build

Regulated and non-regulated activity

Where an economic regulator sets prices, cost has to be allocated by regulated service and the allocation has to be defensible line by line rather than reconstructed in a spreadsheet afterwards. That is a chart of accounts and cost allocation design decision, and it is the one that most constrains every other posting decision. Making it after the chart is built is the expensive order.

Two asset registers that are both correct

The statutory register carries fair value under the applicable financial reporting standards; a regulatory asset base carries a different valuation on a different roll-forward for price setting. They are not a reconciliation error — they are two answers to two questions. The system has to produce both without either being maintained by hand.

Capital is the main event

Most of what an asset-intensive organisation spends is capital. Capitalisation policy, treatment of overheads, work in progress ageing and the point at which a project becomes an asset are finance design decisions with an operational input, and they determine whether the capital programme can be reported at all.

Assets that arrive without an invoice

Contributed infrastructure and customer contributions arrive as assets and revenue with no supplier invoice and no cash receipt. They need a designed path in, or they become a year-end journal nobody can evidence.

Public sector reporting obligations

Reporting under the jurisdiction's financial management legislation, the model financial report, periodic returns to Treasury and audit by the auditor-general are fixed inputs. They shape the close calendar, the evidence the system must retain, and the go-live window — a cutover that lands across statutory reporting is a cutover that will be moved.

Procurement probity

Government purchasing policy, social procurement obligations and the associated disclosure apply to the buying process regardless of what the finance system does. The system has to evidence them, not just permit them.

Australian payroll and banking obligations

Single Touch Payroll, superannuation guarantee and ABA payment files apply even where payroll is out of scope, because the files and the journals still land here. Allowances under an enterprise agreement are the part most likely to be assumed rather than tested.

The order to do it in

The grouping is computed from the model's dependency edges. The goal and the exit condition for each release are a delivery judgement.

01

Foundation

Procurement · Order Management · General Ledger · Data Migration

Chart of accounts, cost allocation, the ledger, procurement and the migration route standing, with the cutover plan being rehearsed rather than written.

Done when A trial balance in the new chart that reconciles to the old one, and a regulatory allocation produced from the system rather than from a spreadsheet.

02

Sub-ledgers

Accounts Payable · Accounts Receivable

Payables and receivables live against the new ledger, with three-way matching working from procurement data and billing revenue posting at the grain the regulatory view needs.

Done when A full period closed with both sub-ledgers agreeing to their control accounts, and no manual journal carrying the difference.

03

Cash and assets

Cash & Treasury

Cash, treasury and bank reconciliation running daily; both asset registers produced from the system; capital work in progress reported rather than reconstructed.

Done when A statutory close and a regulatory position produced from the system, audited, with the first full year-end inside hypercare cover.

Then

4. Cutover & Go-Live

The dependency order puts 1 more phase after the narrated releases.

The model also flags Programme Governance, Inventory as depended on but not included. Fine if they are staying as they are — a gap otherwise.

Decisions to settle

Does the receivable stay in the billing system, or move?

It decides the size of the programme. Moving it brings the whole customer base and its regulatory obligations with it; leaving it makes the revenue interface the most important design artefact on the programme.

By: Before scope is baselined — it is not a design decision, it is the scope. · Accounts Receivable

What is the chart of accounts, and does it carry the regulatory allocation natively?

Every posting decision, every report and every interface depends on it. A chart designed for statutory reporting alone leaves the regulatory submission where it is now.

By: Before configuration starts. Chart changes after the first sub-ledger posts are the most expensive change a finance programme makes. · General Ledger

Which system is master for the asset register, and for which attributes?

The financial register and the physical register will not agree unless somebody decides which one is right about what. Left undecided, the reconciliation becomes a permanent manual activity.

By: Before the works interface is specified. · Asset Management

How far does procurement change?

Payables inherits whatever procurement hands it. Three-way matching cannot be delivered without purchase orders and receipts, and a matching engine with no receipting discipline produces blocked invoices and manual workarounds.

By: With scope, because it determines whether supply chain is a stakeholder or a workstream. · Procurement

Does stores stay where it is?

The model flags inventory as a prerequisite this scope depends on without including. Either it is staying and the interface is named, or it is moving and the scope is larger than stated.

By: Before the first release is planned. · Inventory Management

Where does the cutover sit against the statutory calendar?

A cutover landing near a statutory reporting date, a regulatory submission or year-end will be moved, late and expensively. The calendar is fixed; the cutover is not.

By: At mobilisation, because it constrains everything else. · Cutover and Go Live

Who backfills the finance team?

The subject matter experts this programme needs are the people who close the month. Without funded backfill, the programme runs on evenings and the close slips, and both fail slowly.

By: Before mobilisation, with the budget. · Digital Transformation Readiness Checklist

Risks worth writing down

Revenue posts from billing at a grain the regulatory view cannot use.

So: The regulatory submission stays a manual assembly, and the largest single benefit of the programme is not delivered.

Instead: Design the revenue interface against the regulatory reporting requirement first, and prove it in the foundation release rather than at user acceptance.

The works and capitalisation interface is treated as a technical build.

So: Capital work in progress is wrong from go-live, and the capital programme cannot be reported in its first year.

Instead: Own it as a joint finance and asset design, with both register owners named and a reconciliation designed before the interface is specified.

Data migration starts when the programme needs it rather than when it needs to start.

So: Opening balances that nobody can reconcile to the legacy ledger, discovered at cutover rehearsal.

Instead: Cleansing begins before mobilisation, with quality measured and an owner per data domain; reconciliation totals agreed in advance of the first trial load.

Segregation of duties is designed around the team that exists.

So: Conflicts are built into the role design and become an audit finding the system now enforces.

Instead: Build the conflict matrix from business risk, then design roles against it; where separation is genuinely impossible, document the compensating control rather than leaving it silent.

Customisation is rebuilt because it exists.

So: The estate's unupgradeability is carried into the new system on day one.

Instead: Every customisation carried forward states its business reason and is assessed against standard behaviour; the ones whose reason no longer exists are dropped deliberately.

Change is funded as training.

So: A technically successful go-live where the finance team runs the old process through the new system and the benefits do not appear.

Instead: Change resourced from mobilisation with an accountable business owner, and adoption measured after go-live rather than assumed.

Readiness

Executive sponsorship with tenure

unknown

An eighteen-month programme needs a sponsor who will still be accountable at the end of it, and a succession position if they will not.

Finance capacity released and backfilled

gap

The most common reason a finance replacement slips. Named people, named percentages, funded backfill — or the programme is resourced on goodwill.

Master data quality measured

gap

Supplier and asset master duplication and completeness, measured rather than estimated, with an owner per domain and cleansing already under way.

Interface catalogue

gap

Including the scheduled extracts and spreadsheets nobody owns. The catalogue is the honest measure of what replacing this system actually costs.

Customisation register

gap

What was changed, and why. Without the why, every customisation is either rebuilt or dropped on a guess.

Governance that can decide at programme speed

unknown

Measure decision latency before mobilisation. A programme needs decisions faster than business as usual, not slower.

Statutory calendar mapped against the plan

gap

Close dates, reporting deadlines, audit and the regulatory submission — plotted before the cutover date is chosen rather than after.

The artefacts this programme has to produce

Each one has a guide behind it. The library is the general case; this list is the order it is needed in.

Chart of accounts and cost allocation design, carrying the regulatory viewFinance

General Ledger

Revenue and receivable interface specification, at reporting grainFinance and billing

Accounts Receivable

Procure-to-pay process design, including the non-PO spend positionFinance and procurement

Procurement

Three-way matching tolerances and the blocked invoice pathAccounts payable

3-Way Matching

Capitalisation policy and the works-to-finance costing interfaceFinance and asset management

Asset Management

Asset register mastership and reconciliation designFinance and asset management

Asset Lifecycle Management

Bank file, statement feed and reconciliation designTreasury

Bank Reconciliation

ABA and direct entry file specification and bank testing planTreasury

ABA

Data migration strategy, reconciliation totals and cleansing planFinance and data

Data Migration

Interface catalogue, with an owner on both sides of each oneTechnology

Integration Catalogue

Segregation of duties conflict matrix and role designFinance and risk

SoD and RBAC

Cutover plan, rehearsal schedule and go/no-go criteriaDelivery

Cutover and Go Live

Programme budget including internal effort, backfill and the year after go-liveDelivery

Comprehensive Guide to ERP Project Budgeting: Ensuring Financial Health Amidst Complexity

Change impact assessment by role, and the adoption measuresChange

Change is the word

Health check of the current estate, to test whether replacement is the right answerFinance and technology

ERP Health Check

Argue with it

The scope, the phase order and the straddling interfaces are all computed from the model. If a phase looks wrong, the dependency edge behind it is the thing to change — say so here.