Exception Tracking Spreadsheet (TicklerTrax™)
Downloaded by more than 1,000 bankers. Free Excel spreadsheet to help you track missing and expiring documents for credit and loans, deposits, trusts, and more. Visualize your exception data in interactive charts and graphs. Provided by bank technology vendor, AccuSystems. Download TicklerTrax for free.
Reg E Calculator & Liability Calculation Tool
When there are unauthorized withdrawal claims under Reg E the math gets tricky.
- When did the consumer learn of the loss or theft?
- When did the consumer notify the bank?
- How much was withdrawn in the first two business days, after that, and after the statement was delivered plus 60 days?
The math gets sloppy but if it is done wrong, the bank may have more liability than when the claim was made. This tool is designed to combat the common errors made when calculating liability. Be sure to read the "Instructions" tab to use it correctly.
This Excel tool is intended for use by a claims investigator to calculate liability to the consumer and the bank based on the date and dollar facts. The calendar not only shows trigger dates the bank must take action by, but helps indicate a pattern on the withdrawals. It may be verified by an auditor, or if not used originally it can be an auditing tool to verify the calculations and trigger dates for things like claims completion, when provisional credit is required to be paid and when various notifications are required.
The August 2022 update corrects a potential error in the calculations when there are any unauthorized transfers paid after the bank is notified of the claim. Prior calculations netted these late transfers claimed against the consumer's liability. In fact, the late transfers paid were the bank's liability. To make the consumer whole, these late paid amounts require reimbursement, not to be netted with the claim amount. This is now corrected.
First published on 03/01/2013