Click to return to BOL home page
Banker Store Read A Reg BOL Insiders Career Connect Learning Connect Bankers Information Network

Search BankersOnline
using Google

MAIN CONTENT 
Compliance

    Agency Road Maps

    Alphabet Soup

    Compliance Tools

    FACTA/FCRA

    OFAC

Lending

    FACTA/FCRA

    Lending Tools

    SCRA

Marketing

Operations

    Check 21

    Operations Tools

    SAR Resrch Guide

Security

    AML/BSA

    Bank Robbery

    Counterfeits

    ID Fraud/Phishing

    Security Tools

Technology/eBanking

    Info Security


SPECIAL AREAS 
BOL Archives

BOL Blogs

Briefing Archive

Calendar

Court Watch

e-Card Exchange

Examiner's Corner

Executive Briefing

HR Corner

Infovault

Launch Pad

Regulator Roadmaps

Risk Management

Site Map

Site Orientation

Top Stories


~ ~ ~
SERVICES 
CrimeDex

Em@il Education

ID Verification


~ ~ ~
SHOP 

Banker Store

Bankers Info Ntwk

CONNECT 

Career Connect

Learning Connect

Guru Central

INTERACT 

Ask a Guru
Bankers Threads

Contact Us

Give Us Feedback


TOOLS 


60 Second Solutions

Alphabet Soup

Banker Tools

BOL Forms

FUN 

BOL Recipes

eCard Exchange

LEARN MORE 


About Our Sponsors
About Us




Print Friendly! Email This Article! Discuss NOW!

Regulation CC Funds Availability Calendar

By Andy Zavoina, BOL Guru
Bio and Contact Info

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.

Download the - 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.





Privacy Policy    Disclaimer   Recommend This Site !   Contact Us


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.