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.

January 2023 - Updated to more accurately identify which claim tier is applicable and both the liability and amount to refund. The Instructions tab hi-lites the changes.