
Three departments calculate product profitability, and each gets its own figure. A branch budget does not match management reporting, and regulatory data is assembled by hand in the last days. RBC Group starts with calculation rules and then transfers them into the data warehouse, the planning system and reporting.
In brief
- Methodology: budget management system, cost allocation, funds transfer pricing, risk models.
- Data: corporate data warehouse and data marts for the regulator.
- Automation: budgeting and forecasting on IBM Planning Analytics, reports and dashboards.
- People: HR records and payroll for a bank with a branch network.
- Experience: more than 30 projects for banks, with clients including Tsesnabank, Bank Eskhata, Turonbank, Ipak Yuli Bank and PASHA Bank.
Sound familiar?
- Finance, risk and business units calculate profitability differently and argue about figures, not decisions.
- Transfer rates are set by expert judgement, and branches do not understand where their result comes from.
- Shared costs are split “equally”, so loss-making products look profitable.
- Regulatory reporting is assembled from exports all over again every time.
What we do for banks

Methodology
A system will not fix the figures if the bank has no common calculation rules. That is why we start with methodology: we describe the rules, agree them with finance, risk and business, and only then automate.
Budget management system
Financial structure, responsibility centres, budget set, planning and plan versus actual regulations. Read more: budget management methodology.
Funds transfer pricing
Internal rates at which treasury buys and sells funds to business units. The bank sees the interest margin of every branch, product and customer separately from interest rate risk. Read more: transfer pricing methodology.
Cost allocation
Rules for distributing shared and overhead costs to products, sales channels and customer segments. The result is full cost and real profitability. Read more: cost management methodology. A ready solution for product costing: ABC Costing.
Risk models
Methodology and automation of credit risk models and IFRS 9 provisions, scenario stress testing, calculations under Basel Committee requirements. The models run on the same data as the budget and management reporting.
Data
Corporate data warehouse
One source of data for management, financial and regulatory reporting. Data is checked before loading, and the warehouse is managed through a portal. Read more: RBC Data Platform.
Data marts for the regulator
Banks in Kazakhstan are preparing data marts under the requirements of the financial market regulator (ARDFM) by 1 January 2027. We build data marts on the warehouse so that regulatory and management reporting rely on the same data. Read more: ARDFM data marts.
Automation
Budgeting and forecasting
Budget by branch, product and responsibility centre, scenarios, rolling forecast. The main platform is IBM Planning Analytics. We also supply Oracle EPM Planning. We have project experience on SAP BPC, and the portfolio also includes Infor EPM.
Reports and dashboards
Management reporting and dashboards for the board on top of the warehouse: Apache Superset, IBM Cognos Analytics, QlikView, Microsoft Power BI and Oracle Analytics Publisher.
HR and payroll
HR records, timesheets and payroll for a bank with a branch network, with data passed to banking systems. Read more: HR management.
Experience in banks
The RBC Group team has delivered more than 30 projects for banks in Kazakhstan, Uzbekistan, Azerbaijan, Tajikistan and other countries: methodology, corporate data warehouses, management reporting, budgeting.
- Tsesnabank JSC, Kazakhstan. Pre-project survey for a bank management system based on a data warehouse: management and budget reporting, funds transfer pricing, cost allocation, credit risk and IFRS 9. Then corporate data warehouse methodology, projects on SAP BPC and SAP FS-PER.
- Bank Eskhata JSC, Tajikistan. Budgeting on SAP BPC.
- Turonbank, Uzbekistan. Terms of reference for a corporate data warehouse and a management and prudential reporting module.
- Ipak Yuli Bank, Uzbekistan. Automation of management reporting on SAP PCM and SAP BPC, methodology of funds transfer pricing and funds management.
- PASHA Bank, Azerbaijan. Quality control and methodology support for a data warehouse implementation on Oracle.
What else the team has done
- ABC Costing. Activity-based costing methodology and prototype for a central bank, an ABC Costing model for a large commercial bank.
- Budget management. Budget policy, budgeting and management accounting regulations, transfer-based funds management.
- Cost allocation. Allocation methodology for a financial group, administrative expense budget.
- Risk. Risk management methods under Basel II requirements, internal risk management policies and regulations.
- Data warehouses. Architecture, audit and re-implementation of warehouses, requirements for platform selection.
How we work
- Survey. We review current rules, reports and data sources.
- Methodology. We agree calculation rules with finance, risk and business.
- Data. We build the warehouse and data marts.
- Automation. We transfer the rules into the planning and reporting system.
- Support. We train the bank team and support the solution.
Frequently asked questions
Where to start: with methodology or with a system?
With methodology. First the bank agrees on the rules: financial structure, transfer rates, cost allocation bases. Then these rules are transferred into a system.
Can we order methodology only, without implementation?
Yes. We develop methodology as a separate project, and the bank receives documents that can be used to configure any system.
Which platforms do you use to automate a bank budget?
The main platform is IBM Planning Analytics. We have project experience on SAP BPC, and the portfolio also includes Infor EPM and Oracle EPM Planning.
Is a data warehouse needed for management reporting?
For a bank, almost always yes. Funds transfer pricing, allocations and profitability are calculated on data from many systems, and without a single warehouse the figures diverge.
In which countries do you work with banks?
RBC Group works in Kazakhstan, Ukraine, Azerbaijan, Uzbekistan and across Europe, and a bank project has also been delivered in Tajikistan.
Let us discuss your bank’s task
Tell us what hurts most: methodology, data or reporting. We will propose the order of work and show the solution on an example.
Request a meetingmarketing@rbc-grp.solutions, +7 727 258 1712
