For retail banks and building societies
Where net interest income came from this month, and what moved it. Which products grew balances and gave the margin away. Which segments hold the fees. Which branches and channels are opening accounts that never fund. From the product, balance and fee files you already produce, reconciled to the ledger.
A rise in income can be more balances at a thinner margin, and a flat month can hide a product growing and another running off. Covirage splits each movement into balance, rate and mix, by product and segment, and the lines sum exactly to the change in the ledger.
Net interest income by product and segment, with each period's change split into the three drivers and reconciled.
Fee and commission income by line, with customers paying, average per customer and the movers.
Accounts opened by branch and channel against accounts funded and active, so volume targets do not hide empty accounts.
Three steps, in this order.
What a region, a branch, a product and a segment are called in your files.
Balances and rates by product, fee income, and account openings. Totals are checked against the ledger figure you give.
Where did income come from, what drove the change, and which branches explain it, with the rows behind each answer.
Short answers. The Help centre has the long ones.
No. Customer and account identifiers are enough. Names never need to leave the bank.
Change in margin multiplied by the prior balance, by product. Balance effect is change in balance at the prior margin, and mix is what remains. The three sum to the total change, and that is checked.
Average balances and rates or interest by product and segment, fee income by line, and account openings. A cost centre file adds the cost side.
Analytics software for retail banking, compared · Alternatives to named products
Written for this desk: the measures, the data you already hold, and the arithmetic.