Skip to main content

Housing systems integration

Your housing systems, connected to finance from day one

PCL Finance One Housing Integrate links your rent, repairs, CRM, budgeting and banking systems to Oracle Fusion.

Your teams keep the systems they know. Finance sees every pound by scheme, block and property.

Live at Riverside: rents, repairs, care and support, and budgets, on one finance platform.

Short answer

How does a housing association connect its housing systems to Oracle Fusion?

PCL One links rent, repairs, CRM, budgeting and banking systems to Oracle Fusion, so your teams keep the systems they know and finance sees every pound by scheme, block and property. Integrations PCL One has delivered include Open Housing, rent and payroll systems, Salesforce, MuleSoft and TM1.

Last updated

Connectors already built for housing

Six housing connectors are built, tested and live in UK social housing. We confirm the product names and data flows with you in discovery, then switch them on.

Housing connectors and what each one does
ConnectorWhat it does
Rent systemPosts rent and service charge totals to the general ledger as journals, by scheme, block and property
Rent paymentsBrings receipts into finance and reconciles them daily, with exceptions flagged
Resident billingSends charge totals into Oracle and returns recoverable totals by property
Repairs and maintenanceTurns repairs orders and contractor invoices into payables invoices
Budgeting (TM1)Loads budgets and quarterly forecasts into Oracle and sends actuals back for planning
Housing managementKeeps the asset register and the housing system reconciled each month

Every connector is monitored daily and alerts your team when something needs attention.

How a file travels from your housing system to Oracle

Each system connects once, to your hub. Finance One is the single place where data is transformed.

1Your housing systemProduces its usual file2Your integration hubSuch as MuleSoft, passes it on3Finance OneMaps legacy codes, builds the import4Oracle FusionCreates journals or invoices5Job history backFinance sees every file's result

Steps, in order:

  1. Your housing system: Produces its usual file
  2. Your integration hub: Such as MuleSoft, passes it on
  3. Finance One: Maps legacy codes, builds the import
  4. Oracle Fusion: Creates journals or invoices
  5. Job history back: Finance sees every file's result
A housing system file, from your hub through Finance One into Oracle Fusion, with the result returnedShaded boxes: what happens at each step. Outlined in orange: the one place your data is transformed.
  1. Your housing system produces its usual file.
  2. Your integration hub, such as MuleSoft, passes the file to Finance One.
  3. Finance One maps your legacy codes to the new chart of accounts and builds the Oracle import file.
  4. The hub loads the file and Oracle creates the journals or payables invoices on schedule.
  5. Oracle's job history returns to Finance One, so your finance team sees what happened to every file.

Each system does what it does best

Your teams keep working as they do today. Finance gets one view of every pound.

Oracle Fusion holds

  • Accounting, dimensions and the chart of accounts
  • Budgets by scheme and block
  • Allocations and service charge apportionment
  • Summary journals and balances
  • Reporting and month-end reconciliation

Your housing system keeps

  • Tenancies and leases
  • Resident rent and service charge calculation
  • Resident statements and charge letters
  • Arrears and recovery
  • Section 20 notices and the resident relationship

Keep your codes

Finance One converts your legacy codes to the new chart of accounts as each file arrives. Your housing system keeps posting with the codes it uses today. When you redesign your chart of accounts, you change the mapping once, in Finance One, and every feed follows.

Chart of accounts transformation for UK housing associationsFinance One integration accelerator

Control you can audit

  • A history of every file received, transformed and sent
  • Oracle's import job history visible inside Finance One
  • Logging, alerts, error queues, retry and replay on every run
  • Documented data contracts for each interface
  • Single sign-on through your Microsoft Entra ID, with role-based access
  • Deployed on your own Azure services and network, so the data stays in your estate

Works with the hub you already run

If you already run MuleSoft or another integration hub, we build on it. Integration delivery is part of our implementation, and it adds no new compulsory middleware licence.

Connecting Oracle Fusion to housing and CRM systems through your integration hub

Systems our housing clients connect

Housing management system integration, CRM, banking and planning, all through PCL Finance One Housing Integrate.

Systems UK housing clients connect to Oracle Fusion
AreaSystems
Housing managementOpen Housing, Aareon QL, Orchard, OneHousing
CRMSalesforce, including Salesforce Nonprofit Cloud
BankingNatWest Bankline (CAMT statements), Lloyds, BACS payments through Bottomline
Budgeting and planningIBM Planning Analytics (TM1)
Repairs and maintenanceRepairs and job management systems
PeoplePayroll and HR journals
Data and documentsSQL Server warehouses, Power BI, document management

Open Housing

Rents, service charges and repairs, every day.

Open Housing integration

Salesforce

Batch first, then real time, on your CRM timeline.

Salesforce integration

Care and support

Income, costs and margin for every scheme.

Care and support finance

Proof from UK social housing

At Riverside, one finance platform now runs across the group, integrated with its housing, care and billing systems.

  • Rents post from Open Housing to the general ledger every day
  • Repairs flow into payables from the housing system, and care and support data flows in from Salesforce
  • Bank statements for all 37 bank accounts load in one daily file
  • Budgets and forecasts load from TM1, and actuals return for planning
  • 600,000+ assets and 30,000+ properties migrated and reconciled

Housing systems integration: questions housing associations ask

Do we have to replace our housing management system as well?

No. The finance system replaces the ledger and purchasing. Resident-level rent, arrears and statements, customer cases, repairs detail and payroll records stay in the systems that hold them today. The housing management system keeps posting with its current codes, and the integration layer maps them to the new chart of accounts.

Which housing systems do you connect?

Open Housing, Aareon QL, Orchard, OneHousing and Salesforce, plus repairs, TM1 budgeting, payroll and your banks. We confirm product names and data flows with you in discovery.

Can the new finance system use our existing integration hub?

Yes. Oracle Fusion is the finance core and your hub is the connector between it and the housing management system, CRM, repairs, payroll, document management and the data warehouse. Oracle Fusion exposes REST APIs and supported bulk file interfaces, orchestrated through your hub or through Oracle integration services where that is agreed. When a source system is later replaced, the interface is designed to be re-pointed rather than rebuilt.

Can Salesforce go live after finance?

Yes. Salesforce runs as its own track, so finance goes live on your date and the Salesforce link follows when your CRM is ready.

Which integrations does a housing association need on day one?

Usually rent, arrears and adjustment postings from the housing management system, payroll journals into the ledger, and bank payments and statements. Repairs, document management and data warehouse extracts follow the same pattern. CRM integration often has its own timetable, so it runs as its own workstream and finance go-live does not wait for it.

When should bank and housing management testing be booked?

At the start. The housing management and bank suppliers each need to provide specifications, access and test slots, and those dates go on the plan as early starts, because they are the most common source of delay in a finance implementation. Test stubs keep system testing moving if a partner is not ready, but live acceptance of every interface is completed before go-live.

See your systems connected before you commit

In 30 minutes we map your housing, CRM and banking systems to the connectors we already run, and show you what stays the same for your teams.

Book a 30-minute housing finance review

PCL One (PayrollCloud Limited)

International House, 12 Constance Street

London E16 2DQ

United Kingdom

info@pcl.one