The Client
This regional financial services company operates multiple bank subsidiaries across several states. With total assets of more than $20 billion, it offers a broad range of retail and commercial financial products and services, including cash management services, mortgage banking and brokerage and trading services.
The Challenge
The company engaged Stonebridge to create an integrated custom application for automating cash reconciliation processes for all teller transactions at all branches of its subsidiary banks. The new teller cash reconciliation system would replace a paper-based process that was labor-intensive and error-prone.
The Solution
Stonebridge collaborated with the bank’s full-time IT staff to develop a custom teller cash reconciliation system for teller transactions across the enterprise. The custom solution was a Microsoft VB.NET / ASP.NET intranet application built using Microsoft Visual Studio and utilizing the .NET Framework.
All teller cash reconciliation data resides in a Microsoft SQL Server database. Daily balancing information is imported and examined for consistency and common data discrepancies, with import problems “red flagged” to the user for intervention. All user corrective actions are consolidated in a daily change log for review by the bank’s auditing department. Final daily balancing reports are exported directly to an Oracle database and also via XML Web services to a SQL Server-based corporate document system.
Microsoft Windows Integrated Security model provides security for the application. User-access levels are set in a company security access control point designed to accommodate multiple Web applications. Access to various parts of the application is restricted by user or group, based on their respective assigned roles.
The Benefits
- Enhanced processing of daily balancing tasks
- Fewer person-hours required for cash reconciliation
- Timely availability of standardized balance reports