In finance, net interest margin is a measure of the difference between interests paid and interest received, adjusted for the total amount of interest-generating assets held by the bank.
Net interest margin is calculated daily in a bank and reported to the CFO and the entire finance team. This report is of paramount importance to the top stakeholders of the bank since it is an indicator of the financial health of the bank. The whole process is complex and requires productive hours of the team to complete the task. The client’s finance and accounts team proposed automation and chose SheetKraft as the ideal automation partner to make the process optimal.
As per the Bank’s defined process, a person has to collect all the required files from shared folder on daily basis. The file received is to be converted into excel format and calculations are done in the Excel file. The team invested one hour daily to produce the report.
But, manual process involves high risk and high chances of error. The data can be misplaced or missed while copying from one place to another or the formulas can be applied with incorrect references. The team has to make several iterations to ensure that the NIM report is accurate.
Before SheetKraft, the task required one hour to generate the report. But with the help of Sheetkraft, the task is competed in 20 seconds.
Triggers were created for:
Automating the NIM process has made it more flexible for the employees and stakeholders as it can be accessed easily. Dependency of employee working on it has been decreased as the output is generated daily without human involvement. Error rates in the report are negligible and the report is now more efficient.