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.
| Connector | What it does |
|---|---|
| Rent system | Posts rent and service charge totals to the general ledger as journals, by scheme, block and property |
| Rent payments | Brings receipts into finance and reconciles them daily, with exceptions flagged |
| Resident billing | Sends charge totals into Oracle and returns recoverable totals by property |
| Repairs and maintenance | Turns repairs orders and contractor invoices into payables invoices |
| Budgeting (TM1) | Loads budgets and quarterly forecasts into Oracle and sends actuals back for planning |
| Housing management | Keeps 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.
Steps, in order:
- Your housing system: Produces its usual file
- Your integration hub: Such as MuleSoft, passes it on
- Finance One: Maps legacy codes, builds the import
- Oracle Fusion: Creates journals or invoices
- Job history back: Finance sees every file's result
- Your housing system produces its usual file.
- Your integration hub, such as MuleSoft, passes the file to Finance One.
- Finance One maps your legacy codes to the new chart of accounts and builds the Oracle import file.
- The hub loads the file and Oracle creates the journals or payables invoices on schedule.
- 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.
| Area | Systems |
|---|---|
| Housing management | Open Housing, Aareon QL, Orchard, OneHousing |
| CRM | Salesforce, including Salesforce Nonprofit Cloud |
| Banking | NatWest Bankline (CAMT statements), Lloyds, BACS payments through Bottomline |
| Budgeting and planning | IBM Planning Analytics (TM1) |
| Repairs and maintenance | Repairs and job management systems |
| People | Payroll and HR journals |
| Data and documents | SQL Server warehouses, Power BI, document management |
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.
PCL One (PayrollCloud Limited)
International House, 12 Constance Street
London E16 2DQ
United Kingdom