This tool consists of an Excel spreadsheet designed to allow a user to calculate when funds must be made available under Reg CC and a short online video to help the user understand how to use the tool correctly. There is also a printable calendar that may be used where computer access is limited. This is based on the Reg. CC Calendar program Andy did and Jim Bedsole enhanced with an easy to use interface.
Here's how it works: When you open the spreadsheet you will enter the current business date for the deposit date. Adjust that date to reflect the business date on which you are operating, being mindful of when you are working after cutoff hour (on the next business day). Use the pull down menu to select the hold type, and verify the hold release and computer hold release dates. The computer hold release date is set for one business day prior to the hold release.
The current version has been amended to remove nonlocal items in accordance with the Reg CC changes effective Feb. 27, 2010. The standard hold dates are 2, 7, or 9 business days. Added to this new version is a field for the bank to enter the number of business days applicable to new accounts. This period can vary based on the banks option which is why it is user-entered. (The field is restricted to a number between 1 and 30.) This entry will be shown on the calendar tab of this Excel program as well.
You need to have Excel set properly for the program to work. In Excel, go to the "Tools" menu, and then to "Add-Ins". Make sure the checkbox for "Analysis ToolPak" is checked on. You should then have no problems with the program.
This program may be revised from time to time; check for updates periodically. You may use it at no cost, but may not redistribute it. The program comes with no warranties. Please advise us if you see any errors or desired "tweaks" to make it function better for you.
by RIGHT clicking on the link and saving the xls (Excel) file to your hard drive.
You can also save the file to your institution's intranet directory to make it available to all in your institution that have intranet access.
Be sure you turn on the Analysis ToolPak-VBA as noted in the steps on the Output tab. This short video will show you how to avoid the most common error and begin using the tool.
Updated 12-09-11. First published on BankersOnline.com 11-08-01.
BankersOnline is a free service made possible by the generous support of our advertisers and sponsors. Advertisers and sponsors are not responsible for site content. Please help us keep BankersOnline FREE to all banking professionals. Support our advertisers and sponsors by clicking through to learn more about their products and services.