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.
Federal Garnishment Calculator
Dani York, BOL user, has provided fellow BOL users with an the Excel spreadsheet to document your findings for covered garnishments:
- the protected amount,
- how much to garnish,
- time frames in which all should be or was accomplished,
- and more to complete the required notice (the Word doc).
All of the information required in the notice is located on the Excel worksheet.
This spreadsheet was updated May 15, 2013 with a formula that will more accurately select the end of a month in the "lookback" period. In accordance with 31 CR 212.3, "Lookback period means the two month period that begins on the date preceding the date of account review and ends on the corresponding date of the month two months earlier, or on the last date of the month two months earlier if the corresponding date does not exist." As an example, if the review date is April 30, 2013, the lookback is two months but February has only 28 days, not 30. The revised sheet now computes February 28 in the lookback period. The new worksheet includes a Revision date in A26 of 2013-05-15. This document is protected, but there is no password if you need to alter it.
First published on 04/01/2011