Power Planning Cuts Banking Corporation’s Profitability Processes by 70%


This banking corporation, with over 120 locations in the U.S. and China, helps businesses and community members on both sides of the Pacific explore new markets and create new opportunities through its team of experienced, multicultural professionals. The bank’s sustained growth and expertise in industries like real estate, entertainment and media, private equity and venture capital, high-tech, and aviation help build sustainable businesses and expand its employees’ potential for career advancement. 

deFacto Power Planning helped this company improve its financial reporting and budgeting processes by eliminating large portions of manual work and implementing critical business rules and calculati


The company’s financial reporting and budgeting process was inefficient and error-prone. It relied on laborious Excel spreadsheets and Access reports to separate reconciliation of monthly profitability reports and quarterly actual-to-budget reporting. There was a lack of exception reporting and checks/balances, which made it difficult to identify and address potential problems. Additionally, manual loading was needed to compile actual and ALM information, and further reconciliation was needed to verify accuracy. All of these factors contributed to a slow, inefficient, and error-prone process that could lead to inaccurate financial information. 

dF Solution Statement/Results

Through the use of custom business logic, the company was able to match and cut intercompany transactions for budgeting purposes, which provided a higher degree of accuracy in their financial reports. This feature allowed the company to easily track their financial transactions across different branches and departments, which was a key requirement for the organization’s financial reporting. In addition to custom business logic, the automation capabilities of Power Planning helped streamline the budgeting process. The software’s automation features allowed for a more efficient workflow, resulting in fewer errors and reduced manual intervention in the budgeting process. In total, the process time to assess profitability was slashed by 70%, and a once quarterly process could now be completed on a monthly basis. 

Overall, the implementation of Power Planning provided increased transparency and granted the company a clearer picture of overall and branch-specific performance.