CU*BASE Query: Q-NSF Fees (NSFTR)

This Query is used to view information contained in the CU*BASE “NSFTR” file. This file stores collections information and this Query is designed to show all NSF fees charged during a certain period of time designated by the date range which replaces the ISO dates entered by default. The goal with this canned Query is to allow credit unions to review their NSF activity for the day, to determine if there are any refunds that they should proactively provide to members who have incurred fees.

Specifications

File(s) used by this Query: NSFTR

Access: Tool #1051 NSF Transactions by Day (NSFTR) (Shortcut: QNSFTR

The following fields will be displayed in this Query:

Transaction date
Transaction origin
Account base
Account type
Transaction amount
Resulting balance
Draft #

Sample Conditions

The following table lists a few sample conditions which can be used in the NSF transactions by day.

· NOTE: Generally, this Query is used to see fees charged for the previous day. In this case, replace both fields with the previous day's date in the ISO format presented upon entry. Below is an example of what that looks like if the previous date was April 15, 2024.

Description		Field	Test	Value
Show fees charged for the previous date if that date was April 15, 2024.		TRDATEISO	Between... and....	'2024-04-15' '2024-04-15'