ABC Costing: The Cost of Bank Products

ABC Costing: the cost of bank products, a solution by RBC Group

Which bank products earn money, and which live at the expense of others? ABC Costing calculates the full cost of every product using the bank’s own methodology on its real data, and shows what every amount is made of. The methodology does not have to be turned into code: it is entered as a table of steps and calculated straight away.

In brief

  • The cost of every product: for the bank, branches and outlets.
  • The bank model is calculated in seconds, and the methodology is changed by a methodologist, not a programmer.
  • A journal of every movement: any amount can be traced back to the source cost item.
  • A data collection portal with tasks, deadlines and acceptance instead of emailing files.
  • Runs inside the bank perimeter, Excel stays on input and output.

Sound familiar?

  • A consultant delivered a thick methodology, but it does not fit the management accounting system: it gets simplified and timelines grow.
  • The model lives in Excel: hundreds of steps in formulas and macros, and only the author of the workbook knows where a figure came from.
  • Departments send headcount, floor space and transaction volumes by email, deadlines slip and versions get mixed up.
  • Head office and branches keep their own copies of the model, and the overall picture is assembled by hand.
  • A product owner does not trust the cost of the product and has nothing to check it with.

As a result, decisions on tariffs and the product line are made on figures that are hard to verify and slow to update.

How the calculation works

ABC Costing calculation flow: department costs, drivers, processes, products, full product cost

Department costs are allocated to processes, then processes to products. Every transition is defined by a methodology step and a driver. Reciprocal flows between support departments are calculated by iterations, and the unallocated remainder is not lost: it is shown separately and allocated by a rule set in the methodology.

What ABC Costing can do

  • Methodology as a table. Steps of “source, driver, target” with groups and lists of objects. Any methodology is entered without programming.
  • All driver types. Named with weights, direct assignment, equal shares, bank-wide. An empty driver is automatically replaced with equal shares, so no money is lost.
  • Iterative allocation. Mutual services of support departments are calculated by repeating steps.
  • Cost tracing. For any product you can see which cost items and departments make up the amount.
  • Consolidation. Head office, branches and outlets keep separate models that roll up into one.
  • Data collection portal. Tasks, deadlines, submission and acceptance of data by departments.
  • Excel on input and output. Import of existing models, a template, export of results and the journal.

The model is calculated in seconds

One button, and all methodology steps are done and costs are assigned to products. Input costs equal costs on products, and the unallocated remainder is visible at once. Every calculation is saved and exported to Excel.

Model calculation screen in ABC Costing: input costs, costs assigned to products, product ranking by cost

Demo model screen, figures are illustrative, interface shown in Russian.

What a product cost is made of

A calculation result is always challenged: a product owner wants to know why the cost is what it is. ABC Costing answers with data.

Product cost structure in ABC Costing: by source cost items and by departments

  • Allocation journal. Every movement: step, source, target, amount, driver, numerator and denominator of the share.
  • Tracing. A product cost is broken down into source cost items and the departments where the costs arose, including across several consolidation models.
  • Sum preservation. Every calculation checks that input equals output.
  • Methodology check. Unknown names, drivers without values and steps without targets are visible before the figures go to management.

The core of the solution has been reconciled against a real bank calculation based on the methodology of an international consultant: 162 steps, 2,963 allocation lines, and the result matched.

The methodology is changed by a methodologist, not a programmer

Allocation steps, drivers, costs and reference data are edited in the browser as tables. Short rules let one step describe what takes dozens of rows in Excel. Before calculation the system itself finds references to non-existent objects and drivers.

ABC Costing model editor: table of allocation steps with sources and targets

Data collection portal

Instead of emailing forms, the methodologist opens a collection campaign, and the system itself creates tasks for the people responsible.

ABC Costing data collection portal: tasks, submitted and accepted, campaign readiness, overdue items

  • Campaign. Model, period, deadline. Tasks are assigned by a directory of owners: HR submits headcount, IT submits the number of users, business submits sales.
  • Entry. A contributor sees only their own tasks. The previous value stands next to the new one, so a mistake is visible at once.
  • Acceptance. The methodologist sees the change against the previous period and accepts the data or returns it with a comment.
  • Deadline control. Campaign readiness, overdue tasks, summary by contributor, reminders.
  • Into the model. Accepted data goes into the model, or into its copy for a new period, with one button.

Every action is written to the audit log: entry with the old and new value, submission, acceptance, return.

The bank network: models and consolidation

Every branch and outlet keeps its own model with its own methodology. Costs that head office assigned to a branch are passed to its model and allocated by its steps. The system determines the calculation order itself and warns if costs go to another model without a link. The roll-up matches the calculation of a single model, with no double counting.

Who needs it

  • CFO and shareholders. Which products earn and which are subsidised: the cost of every product for the bank and branches.
  • Management accounting methodologist. A step editor, integrity checks, calculation in seconds and a journal to explain any figure.
  • Head of the branch network. The cost of the network’s products including head office costs.
  • Owners in departments. Their own tasks with deadlines and previous values, without emailing files.

ABC Costing, Excel or a large system

Management accounting system Excel ABC Costing
Methodology Adjusted to fit the system Manual formulas Entered as is, as a table of steps
Time to first figures Months of implementation Fast but fragile Weeks
Where a figure comes from Depends on the system Tracing formulas by hand Journal of every movement and tracing
Branches and consolidation Customisation Linking workbooks by hand Model hierarchy out of the box
Data collection Often a separate project Emailing files Portal with deadlines and acceptance
Teamwork Yes The file sits with one person Roles and work in the browser

Technology and installation

  • Inside the bank perimeter. Installed on the bank’s servers without internet access, data stays with the bank.
  • Storage. The StarRocks analytical database for journals of millions of rows, and the built-in database is enough for a pilot.
  • Interface. Work in the browser, roles: administrator, methodologist, contributor.
  • Integration. Excel on input and output, results are available to BI tools, for example Apache Superset.
  • Security. Roles and an audit log of all changes.

How to start

  • Demonstration. We show the calculation, journal, consolidation and portal on a demo model.
  • Pilot on the bank’s data. We transfer the bank’s methodology into the head office model and reconcile it with the current calculation.
  • First collection campaign. Drivers for the period are collected through the portal by real contributors.
  • The whole network. Branch and outlet models, consolidation, production installation.

Methodology and experience

There is practice behind the solution. The RBC Group team developed an activity-based costing methodology for a central bank and an ABC Costing model for a large commercial bank, as well as an allocation methodology for a financial group. If the bank has no methodology yet, we will develop it as a separate project: cost management methodology. Product costing works together with transfer pricing and the budget, read more on the solutions for banks page.

Frequently asked questions

What is ABC Costing?

Activity-Based Costing: department costs are allocated to processes, and processes to products, using drivers. The bank gets the full cost of every product.

We already have a methodology. Will it have to be redone?

No. The methodology is entered into the solution as a table of steps: source, driver, target. No programming is needed, and changes are made by the bank’s methodologist.

We calculate product cost in Excel. Why change?

Excel stays on input and output: the model is loaded from a workbook, and results are exported to a workbook. What goes away is manual work: recalculation by macros, merging copies, emailing forms. What appears is a calculation journal, sum control and user roles.

How long does a pilot take?

Weeks, not months. The timeline depends on how ready the bank’s methodology and data are. A pilot includes loading reference data and costs, transferring the methodology, the first driver collection campaign and the first calculation.

Where is the data stored?

Inside the bank perimeter. The solution is installed on the bank’s servers and works without internet access.

Can branches be calculated separately?

Yes. Head office, branches and outlets keep their own models, and the result rolls up into a consolidation without double counting.

If there is no methodology yet, can you help?

Yes. RBC Group develops cost allocation and product costing methodology as a separate project and then transfers it into ABC Costing.

We will show ABC Costing on a demo model

In one meeting you will see the calculation, journal, consolidation and data collection portal. Then we will discuss a pilot on your bank’s data.

Request a demomarketing@rbc-grp.solutions, +7 727 258 1712