Input Verification and Edit Report

Use this report after you have submitted a file to validate that the file has been successfully processed. Files that are blocked or rejected should be reviewed immediately to determine the cause and to make the necessary corrections. Reconcile this report to your input file.

Report Totals in-conjunction with other reports should also be used to reconcile with your Client Value Date Totals Report or for Prefunding clients, your Client Settlement Totals Report. If it does not balance, contact your Cash Management Client Support Centre.

This mandatory report advises you of:

• Files received and processed
• Files blocked or rejected
• Transactions rejected
• Transactions containing “T” level errors (invalid payments)
• Total of your transactions In-Excess (“I”) held due to your Daily Limit being exceeded (ACH Credit clients only). The details of In-Excess payments are reported to you on the Daily Limit Payment Details Report.

Availability

This report is produced when an input file has been received by the bank. If your file had processing issues and became blocked, this report is produced again when you unblock a file.

For Prefunding clients, this report will also be produced if:

• Your input file was blocked due to a Prefunding Condition that has been rectified during the retry process and your file is unblocked
• Your input file was blocked due to a Prefunding Condition that has been rectified during the retry process, however another Prefunding condition comes up and your file remains unblocked

This report will not be produced if the same Prefunding Condition keeps re-occurring during the retry process and your input file remains blocked. This report will only be produced at the time your input file is unblocked.

This report can be received within 20 minutes after your input file is processed by RBC Royal Bank, via the online reports, data transmission or fax (subject to file size and system availability). If you do not receive this report within 20 minutes contact your Cash Management Client Support Centre.

Description of Errors

The report makes use of error messages to indicate the status of payment files. Error messages are printed following the transaction in error, and include one letter prefixes.

LETTER PREFIX	DEFINITION
B – blocked file	Contact your Cash Management Client Support Centre to correct (unblock) or delete the file. Payments destined to the United States and payments destined to Canada originating from a foreign country that are part of a blocked file are not sent for screening until the file is unblocked.
U- file unblocked	Indicates a file that was previously blocked has become unblocked.
F – rejected file	Correct your file and resubmit.
R – transaction rejected	The payment will not be held in the system pending correction. You must resubmit the payment with all the errors corrected if you still wish to process the payment to your customer. You can add a single payment via RBC Express ACH Payment Manager or resubmit it in another file.
T – transaction rejected and maintained in database	If you have chosen to retain “T” level errors, the transaction remains in the database for 40 calendar days awaiting correction. Make correction or delete the payment via RBC Express ACH Payment Manager or resubmit it in another file. “T” level error payments are not sent for screening until they have been corrected.
W – warning	Warnings only appear on this report if the transaction has a “T” level error associated with it. Transactions with only “W” errors will be processed and will appear on the Warnings Report. It is recommended that all Warning be corrected as payments can be returned or processed to an incorrect account. You are responsible for ensuring the banking information on each payment is correct. “W” Payments destined to the United States and destined to Canada originating from a foreign country are sent for screening.
I – In-Excess-For ACH Direct Deposit Service only.	Payments with an “I” status are not reported individually, only the total of these payments is reported. Details are reported in the Daily Limit- Payment Details Report. “I” payments that are dropped from the system are reported on the Payment Activity Report. You can change or delete “I” payments via RBC Express ACH Payment Manager.

Report Content

This report provides the following information:

Invalid Prenotes

Total number of invalid prenotes submitted on the input file. Applicable to ACH &STD Record Format only. Invalid prenotes will display on this report as a T or R level error.

Transactions To Be Distributed

The total number and amount of transactions received, less the “R”, “T” and “I” level errors.

Transactions Blocked

The total number and amount of transactions that have been blocked. Number of transactions blocked will equal the number of transactions to be distributed.

Transactions Destined For RBC Royal Bank

The total number and amount of valid transactions that have a RBC Royal Bank account number. Transactions with “T” level errors are not included.

Transactions Destined For Other FI’s

The total number and amount of valid transactions that have a Canadian institution and branch number other than RBC Royal Bank. Transactions with “T” level errors are not included.

Transactions Destined For FI’s Outside of Canada

The total number and amount of valid transactions that have a non-Canadian institution and branch number.

Paper PDS Items to Be Produced

This reporting line is no longer required and will be removed from this report in the near future.

Paper / Voucher Items To Be Produced

This reporting line is no longer required and will be removed from this report in the near future.

Transactions Held For Correction (“T” level errors)

The total number and amount of transactions, which contain "T" level errors if the client has chosen to retain “T” level errors.

Transactions Held Due to Daily Limit Excess (“I” In-Excess)

The total number and amount of transactions that exceed the daily limit. These transactions are not processed and are not included in the total of transactions to be distributed. Details of these transactions are reported on the Daily Limit- Payment Details Report.

Transactions Received

The total number and amount of transactions received including ones which contain errors.

Transactions Rejected

The total number and amount of transactions that have been rejected (“R” level errors).

Valid Prenotes

Total number of valid prenotes submitted on the input file. This applies to ACH & STD Record Format only. Details of valid prenotes will be listed on the Payment Register if you have selected this optional report. Valid prenotes destined to the United States and destined to Canada originating from a foreign country are also sent for screening.

Descriptions of other headings can be found in Report Heading Descriptions.