Search
 
Alexander Hamilton Awards

Automation Streamlines Bank Statement Management

Congratulations to Microsoft, winner of the 2021 Silver Alexander Hamilton Award in Technology Excellence!

Microsoft: Winner of the 2021 Silver Alexander Hamilton Award in Technology Excellence

Microsoft’s bank account structure reflects the company’s size and global market position. Every day, Microsoft receives more than 1,600 bank statements from more than 80 banking partners. Managing these data flows and pulling transaction information into the corporate enterprise resource planning (ERP) system used to be a significant pain point for the cash operations team.

“The process for importing bank statements was very cumbersome,” says Sabin Jafri, senior treasury manager in the cash operations group. “We leveraged predefined ERP reporting to extract data from the statements. But our ERP system and bank account database did not talk to each other, so the ERP didn’t always know when a new account was added or an old account was deleted. Someone had to review line items on a daily basis to ensure the account structure was up to date and all our bank statements were coming in on time via SWIFT.”

The cash operations group used Excel to track receipt of electronic bank statements. They extracted data using macros and VLOOKUP formulas. “We were trying to be more efficient by creating macros to run behind the scenes, but there was the potential for errors if data came through in a different format,” Jafri says. “Invalid formats cause issues with VLOOKUP and require additional manual corrections.”

Complete your profile to continue reading and get FREE access to Treasury & Risk, part of your ALM digital membership.

Your access to unlimited Treasury & Risk content isn’t changing.
Once you are an ALM digital member, you’ll receive:

  • Critical Treasury & Risk information including in-depth analysis of treasury and finance best practices, case studies with corporate innovators, informative newsletters, educational webcasts and videos, and resources from industry leaders.
  • Exclusive discounts on ALM and Treasury & Risk events.
  • Access to other award-winning ALM websites including PropertyCasualty360.com and Law.com.

Already have an account?

NOT FOR REPRINT

© 2023 ALM Global, LLC, All Rights Reserved. Request academic re-use from www.copyright.com. All other uses, submit a request to [email protected]. For more information visit Asset & Logo Licensing.

Meg Waters

Meg Waters

Meg Waters is the editor in chief of Treasury & Risk. She is the former editor in chief of BPM Magazine and the former managing editor of Business Finance.

More from this author

Dig Deeper

 

Recommended Stories

Investments Shift away from Bank Deposits

Investments Shift away from Bank Deposits

Tom Hunt |

The 2023 AFP Liquidity Survey found that treasurers are reducing bank deposits and moving investments toward more secure vehicles, reflecting the U.S. economic climate of 2022 and the bank failures of 2023.

Alexander Hamilton Awards Deadline Extended

Alexander Hamilton Awards Deadline Extended

T&R Staff |

The deadline for submitting projects for consideration for the 2024 Alexander Hamilton Awards is now September 11. Submit your innovative initiative today!

Treasury & Risk

Join Treasury & Risk

Don’t miss crucial treasury and finance news along with in-depth analysis and insights you need to make informed treasury decisions. Join Treasury & Risk now!

  • Free unlimited access to Treasury & Risk including case studies with corporate innovators, informative newsletters, educational webcasts, and resources from industry leaders.
  • Exclusive discounts on ALM and Treasury & Risk events.
  • Access to other award-winning ALM publications including PropertyCasualty360.com and Law.com.

Already have an account? Sign In Now
Join Treasury & Risk

Copyright © 2023 ALM Global, LLC. All Rights Reserved.