Open topic with navigation

Returned Item (Reversals) Report

Last Revised: NOvember 18, 2016

 

Table of Contents

When to use:  As desired

What it shows:  This lists all the reversal transactions made in a given reversal deposit date range. Included on the report are, for each reversal, the account number, tax year the original payment was applied to, the transaction amount reversed for that year, total check amount, check number, deposit date of the original payment, returned item (reversal) deposit and receipt dates, returned item reason code (if available), payer (fiduciary no.), remit sequence number, and the operator code.  The report is sorted by the reversal (returned item) deposit date, then by year and account number.  Subtotals are given for each reversal deposit and receipt date and for each deposit type (regular or eCheck). Grand totals are given at the end.  The Reversed Amount and Check Amount grand totals should be the same amount.

If a reversed transaction has paid multiple accounts, each account will be listed separately, but the check and deposit information will be given only once.

Voided payments are not listed on this report.

If a text file is generated (see the paramter below), the following data is provided on it: check amount, check number, original deposit date, returne item deposit number, returen item deposit date and the returned item receipt date. The file names are appended with designations for echeck, regular (non-echeck), and all (both echeck and non-echeck) returned items.

ClosedUser Entitlements

The following user entitlements must be set for each user who needs access to the Batch Menu and Batch Request screens. They are part of the Run Batch Processes task.  See Tasks, Entitlements, and Jobs for more information. The user entitlement for each batch menu no. mentioned below must be set to Y for each authorized user. Batch menu nos. default to N when they are added.

BATCH_MENU - access to the Batch Menu to generate the reports.

BATCH_REQUEST - access to the Batch Request screen to see the reports.

 

ClosedClient Preferences

RET_ITEM_RPT_RR_ONLY: Set to Y if you have want to see data only for Returned Item or Returned Item E-Check deposits.  If set to N, all reversals (those made with a reversal deposit and those in  returned item deposits) are listed on the report.

RETURN_ITEM_REPORT_PAYER: Set to Y to display the Payer (Fido) in addition to the other information the report. Set to N to not include this column of data.

To create a Returned Item Report:

  1. From the Main Menu, click on Products, then Batch Products.  The ACT Batch Menu will appear
  2. Click on the Returned Item (Reversals) Report line, batch menu no. 112. The parameter screen for this report appears.  
  3. Press Enter.

Note: Before pressing Enter, be sure the number of the report line you want is displayed in the Selection box.  You may need to key in that number before pressing Enter.

  1. Enter a Begin Reversal Date and End Reversal Date.
  2. In the Deposit or Receipt field, enter D to run the report using deposit dates or R to run it using receipt dates.  These dates refer to those entered in step 3.
  3. In the Reversal Type field, enter R to report only regular reversal or returned item deposits (depending on the RET_ITEM_RPT_RR_ONLY preference setting), E to report only eCheck reversal deposits,or B for both (in this case, eCheck deposits will be shown after the regular returned items).
  4. In the Create Text File field, enter Y to create a text file or N to not do so.
  5. Click Submit Job.
  6. Click OK on the "OK to Submit Job" pop-up screen.  
  7. To view the report, see Previewing and Printing Reports.