Bank fees are one of the few costs that treasury controls directly, yet in most companies nobody knows the total. Fees are debited straight from the accounts, every bank names its services differently, and accounts opened for old projects or acquired companies stay open for years. The result is a bill that grows quietly, and a list of accounts that nobody fully trusts.
This toolkit shows how to analyse bank fees across all your banks, find the savings and clean up the account structure. It combines a short guide with two Excel tools and a ready procedure for opening and closing accounts.
WHAT IS INCLUDED
• Bank Fee Analysis and Account Rationalization guide (PowerPoint, 13 slides)
• Bank Fee Analyzer (Excel): one table for all banks with each bank's own wording mapped to a standard list of services, an automatic check of volume x price against the amount billed, a price benchmark showing the best and worst bank for every service and the saving at the best price, fees by bank and category, a ranking of the most expensive services and a savings plan with achievable percentages
• Bank Account Register (Excel): one list of every account with purpose, activity, balance, fees and signatories; suggested actions from rules you set (keep, close, merge, connect to the cash pool); accounts by bank before and after, fees saved and the interest given up on cash outside the pool
• Bank Account Opening and Closing Procedure (Word): principles, approval table, set-up checklist, yearly review and an 11-step closure checklist
• Licence and terms of use
WHO IT IS FOR
Treasurers and cash managers, finance directors and controllers of groups with several banks or entities, shared service centres, and anyone preparing a bank fee negotiation or a bank tender.
WHAT YOU RECEIVE
A 13-slide guide in which every slide has a headline that states the point, a body that shows it and a closing takeaway. It covers why fees escape control, where fees and hidden costs sit, how to collect the data and build one service list, the 80/20 of fees, price benchmarking, billing errors, account mapping, rationalization rules, and a savings plan with a safe closure sequence.
The archive contains 3 working files and a licence. Nothing is password-protected or locked.
HOW THE SPREADSHEETS ARE BUILT
Input cells use blue text on a sand background. Formulas are in black and links to other sheets in green. Each file opens with a How to use sheet and a Setup sheet. Example data for an invented group with four banks and 28 accounts is shown in italics so you can see the tools working before you replace it. Print areas are set.
WHAT THIS IS NOT
This is educational material, not financial, legal or banking advice. All banks, company names, prices and figures are invented. Each file includes a licence page: you may use and adapt the material inside your own organisation, but you may not resell or redistribute it
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Cost Reduction Assessment, Financial Management PowerPoint Slides: Bank Fee Analysis and Account Rationalization PowerPoint (PPTX) Presentation Slide Deck, g64266623o55