Daily Limit – Payment Details Report
(ACH Direct Deposits Only)

Use this report to reconcile your Client Value Date Totals Report. This report is not produced for Prefunding clients.

This mandatory report lists all payments with a status of “I” for exceeding the daily limit. These payments will not be processed until you have taken some action and will be dropped after 3 business days.

This report also lists:

  • all payments with a status of “I” for “In-Excess” that have become "Valid"
  • payments that have switched from "Valid to “In-Excess” status

The above applies to payments being received from your input file or online transactions on RBC Express ACH Payment Manager. A delete or a change may cause a payment to go from “I” In-Excess to valid. Furthermore, this report also provides the additional dollar amount required to release payments that are In-Excess.

The 3-business day count starts on the due date or the value date of the payment. As an example a payment with a due date or a value date of Monday June 3rd, will be dropped off on Wednesday June 5th at night and will be reported on the Payment Activity Report of June 6th.
In order to clear payments of being In-Excess, you delete or change a payment amount to allow for more available limit, the action of changing/deleting the payment online will be reported on your Payments Activity report. All other payments affected by the online change or deletion, which changed from In-Excess to valid will be reported on this report.

Availability

This report is only produced during the day when payments become In-Excess or change between valid and In-Excess states. A final report will be produced at the end of the day listing all the payments In-Excess that are outstanding.

This report can be received 20 minutes after it is produced, via the online reports or data transmission. The end-of-day report is available the next day. Fax service is not available for this report.

Description of Reasons for Payment Status

The “I” in the front indicates In-Excess payments.
Mass Request or online changes that will put payments into “In-Excess” are not allowed.
If you send us one physical input file with many logical files, only one report will be produced. If there are payments In-Excess from each file they will be listed together, organized by the FCN, and have one total at the end.

The report uses the following standard reasons to explain the status of payments listed in the report. Some reasons will cause an automated email to be sent to your client profile email address.

Reasons Which Trigger Automated Emails

  • I-Payments Reclassified as In-Excess because of a change in the Daily Limit.
  • I-Daily Limit exceeded during normal file input. Payments Classified as In-Excess.
  • I-Payments Reclassified as In-Excess because of a change in the Temporary Limit.
  • Payments Reclassified as In-Excess because of a change to the Temporary Limit Date.
  • Payments Reclassified as In-Excess because Account Ownership changed.
  • Change to Daily Limit or Temporary Limit resulting in NO In-Excess payments.

Reasons Which Do Not Trigger Automated Emails

  • Payments Reclassified as Valid because of a change in the Temporary Limit.
  • Payments Reclassified as Valid because of a change to the Temporary Limit Date.
  • Payments Reclassified as Valid because of an increase in the Daily Available Limit.
  • Payments Reclassified as Valid because of a Mass Request.
  • Payments Reclassified as Valid because of Online Transaction.
  • Payments reclassified as Valid because Account Ownership changed.
  • Daily Limit exceeded after Suspended payments cleared for processing.
  • I - Pending Payments In-Excess that are outstanding at the end of the day.

Report Content

This report provides the following information:

  • Daily Limit and Temporary Limit as indicated on your Grads profile
  • Details on each of the payments such as File Creation Number, File Creation Date, Customer Number, Payment Number, Customer Name.
  • Payment Amount, Institution and Branch and payment due date, Select Date and Value Date
  • Reasons for the payments to be reported
  • Summary for each date payments are In-Excess
  • Additional Amount required to release payments In-Excess
 
  Related
Information
Report Heading Descriptions