BankBI brings both credit unions’ core and general ledger data into one platform after a merger. Its team maps your data once, with rules for each chart of accounts, and the combined credit union gets daily statements, a monthly board pack, and budgets from the same data.
Lodestar converts merger data for Fiserv DNA credit unions, Vena collects budgets and forecasts through Excel templates, and Trintech automates reconciliation and the close.
When two credit unions in the same province merge, the Manager of Finance inherits two core banking systems, two general ledgers, and two charts of accounts (the list of accounts each general ledger uses). Until they’re combined, every report for the chief financial officer (CFO) and the board is pieced together by hand from several spreadsheets and data sources.
Each type of solution takes on a different part of that work:
This guide compares four options on five points:
The table sets out each option and the merger job it suits.
| Provider and type | Ideal for |
|---|---|
| BankBI, reporting and planning platform | Board pack, daily reports, budgeting, and profitability from core and general ledger data |
| Lodestar, data warehouse and merger services | Merger data conversion for Fiserv DNA credit unions, plus analytics |
| Vena, financial planning and analysis software | Budgets, margin forecasts, and rate scenarios for banks and credit unions |
| Trintech, financial close and reconciliation software | Account reconciliation, transaction matching, and close management |
In short: a reporting and planning platform runs the combined credit union’s reports and budget, a data warehouse moves and stores the data, planning software builds the budget, and reconciliation tools check account balances.
BankBI gives Canadian credit union finance teams daily financial performance reporting and planning, built from their own core banking and general ledger data. For a merger, its Canadian credit union page lists two things: merging source data from multiple core systems, and business rules for each credit union’s chart of accounts and product definitions.
Data arrives through pre-built connections for systems Canadian credit unions run:
If your core isn’t listed, BankBI asks you to get in touch. Its implementation team provides a one-off data mapping and takes care of the hard work, and your team confirms the reconciled results, with no upfront investment in infrastructure.
Crossroads Credit Union, whose Fiserv DNA core is hosted by Celero, began its project in January. Within a week its balance sheet was integrated into BankBI, and by the end of February it was live with financial performance insights. Its Manager of Finance said: “I can go in daily and have that information at my fingertips and in one platform.”
Lodestar is an analytics partner for banks and credit unions. Its data warehouse (one central database for data from many systems) pulls data from your core banking system, transforms it, and loads it into standardized tables that feed dashboards and business intelligence tools.
For mergers, Lodestar offers Merger Services designed specifically for Fiserv DNA credit unions. They cover:
A DNA credit union planning its conversion gets a partner focused on moving the acquired institution’s data correctly.
Vena offers financial planning and analysis software for banks and credit unions. Its net interest margin planning (the gap between interest earned and interest paid) forecasts from balance, rate, and asset liability management inputs; asset liability management tracks interest rate and liquidity risk. Its banking page also lists:
Vena connects to financial and core banking systems through its connectors, and reports through Power BI dashboards and PowerPoint.
Trintech sells financial close and reconciliation software to credit unions, with products including Adra and Cadency. Its credit union page lists account reconciliation and close management among its use cases, along with:
Trintech describes the aim as reducing manual work and strengthening control over the close. It suits finance teams whose priority is the account-by-account work of the month-end close.
After a merger, the hardest reporting job is putting two sets of figures on one basis. The two credit unions may run the same core banking system or different ones, and each has its own chart of accounts and product definitions.
The standard to ask for is a mapping of both charts of accounts to one structure, set up by the vendor and kept up to date. BankBI’s Canadian credit union page lists both parts: merging source data from multiple core systems, and business rules for each credit union’s chart of accounts and product definitions. Ask any vendor:
Lodestar’s Merger Services are designed for Fiserv DNA credit unions, from its own site; BankBI lists connections for Fiserv DNA, Fiserv Prologue Financials, Microsoft Business Central, CGI RFS360, and Mambu. Synergy Credit Union, whose financial performance and regulatory reporting were manual, chose BankBI to automate its financial performance management; BankBI lists automated data collation from multiple platforms among the benefits.
Once the data is combined, the figures should match the general ledger every day, not only at month-end. A daily reconciliation report compares general ledger balances with core banking data to identify potential differences.
BankBI reconciles data from your core banking systems with your general ledger. With Fiserv Prologue Financials, it keeps your general ledger codes and provides daily reconciliation reports of general ledger product balances against core banking product balances. Ask any vendor how often its data refreshes, and how a difference is shown and followed up.
The first board meetings after a merger ask for combined results. The board pack should come from the same data finance checks each day, so the pack and the dashboards show the same figures.
BankBI automates the board pack, designed around what your board asks for, and produces monthly management PDF reports from the same figures. Your CFO can also open a dashboard of key performance indicators (KPIs) on a tablet or phone.
A merger resets the budget: the combined credit union needs one plan, and the board will ask what the next few years look like. When the same vendor handles planning and reporting, the budget starts from the same actuals the reports use.
BankBI’s Planning, Budgeting & Forecasting sits in the same platform as its reporting. It uploads actuals from your general ledger and loan and deposit data, builds scenarios across several years, and reports on branch and departmental budgets. Vena, from its own site, collects budgets through governed Excel templates and models rate and deposit scenarios.
Two merger jobs sit alongside a reporting platform rather than in place of one. Converting the acquired credit union’s data into the surviving core is a conversion project, and services such as Lodestar’s Merger Services support it for Fiserv DNA credit unions.
Account-by-account reconciliation and close management is the job of tools such as Trintech’s. A data warehouse can also feed BankBI, so finance reporting and wider analytics start from the same store of data.
Start with the stage of the merger. If it’s still being planned, the job is modelling the combined credit union for the board; once it’s approved, the job is reporting on two sets of data until the cores are combined, then on one. Decide which you need:
Write down each credit union’s core banking system and general ledger, and whether one will be converted to the other. Bring both information technology (IT) leads in at this step, and ask each vendor whether it connects to every system on the list today. BankBI lists its connections on its integrations page.
Credit unions in Canada can be regulated either provincially or federally, as the BCFSA notes. Before choosing software, confirm with your regulator which returns the combined credit union will file, and in which format.
Match the model to the people you have during the merger:
With a small finance team carrying a merger, favour software the vendor sets up, with dashboards and reports ready to use and no report building.
If your finance team will report on two credit unions until the cores are combined, and the board wants a combined budget, choose a platform that merges both credit unions’ data, reports daily, and holds the plan too.
Crossroads Credit Union saw its balance sheet in BankBI within a week of its project starting. To see how BankBI would map both credit unions’ data, book a consultation with BankBI.
BankBI provides post-merger reporting and planning for Canadian credit unions. It merges data from more than one core banking system, sets business rules for each credit union’s chart of accounts, and reports daily from core and general ledger data, with budgeting in the same platform. For converting the acquired credit union’s data on Fiserv DNA, Lodestar offers Merger Services; for reconciliation and the close, Trintech; for budgets collected through Excel templates, Vena.
With BankBI, consolidated reports follow a one-off data mapping: its implementation team maps both credit unions’ data, your team confirms the reconciled results, and reports then refresh daily. How long the mapping takes depends on your systems and how different the two charts of accounts are. Ask any vendor for a plan built on your own systems.
It should, because the board will want combined results set against both credit unions’ past figures. Ask any vendor how history from each legacy credit union is loaded, how it’s mapped to the new chart of accounts, and how far back it goes. BankBI merges source data from multiple core systems, so ask it how much history it would load for your merger.
BankBI’s Canadian credit union page lists regulatory reporting in the regulator’s prescribed format, supporting federal and provincial formats including CSV text file, JSON, and Excel, from data merged across multiple core systems.
If the two credit unions reported in different provincial formats before the merger, the work is mapping both sets of data to the combined chart of accounts, so each return draws on one set of figures. Confirm with your regulator which returns the combined credit union files, then ask BankBI which it would produce.
A reporting bridge needs to load both cores at once and map them to one chart of accounts. BankBI merges source data from multiple core systems and sets business rules for each credit union’s chart of accounts. Ask BankBI how it would load each core until the conversion is complete, and how the mapping changes once one core is retired.
Planning software models scenarios by changing assumptions, such as loan growth, deposit growth, and interest rates, and showing the effect on the plan. BankBI’s Planning, Budgeting & Forecasting uses driver-based planning to link assumptions to financial outcomes, and builds scenarios across several years, with actuals uploaded from your general ledger. Ask BankBI how it would model the two credit unions’ balance sheets together before the merger closes.
If your finance team must report on a merged credit union from two sets of core and general ledger data, and plan its first combined budget, BankBI covers both from one platform that its own team sets up.
Every option in this guide takes on part of a merger’s data work. The difference is which part:
Some of these jobs sit alongside BankBI rather than in place of it. A conversion service moves the acquired credit union’s data into the surviving core, and a reconciliation tool checks the accounts at close, while BankBI reports and plans on the combined figures.
BankBI is the right choice for Canadian credit unions that need to report on, and plan for, a merged credit union without rebuilding the figures in Excel.
For your CFO, that means daily reporting, the board pack, and budgeting for the merged credit union all draw on the same core and general ledger data, available every day rather than only after month-end. In BankBI’s words, core banking systems weren’t designed to be business performance reporting systems; its daily financial reporting does that job for the combined credit union.
To see how BankBI would bring your two credit unions’ data together, book a consultation with BankBI.