Client Settlement Totals Report

This report is produced for Prefunding clients only. Use this report to balance and reconcile all of your payments. Returned items are not included in this report but are reported on the Returned Items Report.

You may also use the following reports to ensure that all your transactions are accounted for:

• Input Verification & Edit Report
• File Input Payment Confirmation Report
• Payments Activity Report
• Mass Request Report
• Payment Register Report (optional report)
• Payment Selection Error Report
• Returned Items Report (to account for all returned payments)

This report lists the date/time and dollar value of all payments activities processed through your input file, RBC ACH Payment Manager and all Mass Request functions (except for Reversals). It also provides a net total showing the accumulation of all payments activities debits or credits, which will be debited or credited to your control account for that date and reported as a separate transaction on your bank statement.

This report also shows a net total of your single reversal and Mass reversal requests. However the details of these transactions are only reported on the Payment Activity Report or Mass Request Report. The total of your Reversals reflects the amount debited/credited to your control account for that date and is reported as a separate transaction on your bank statement.

The following conditions apply when a single reversal or a Mass reversal of payments is done:

• If some payments are still pending in our database they will be deleted and the funds will be available immediately in your control account. The value for these funds is credited to your account for that date and shows on the Client Settlement Totals Report.
• If some payments are already processed and if the reversal or Mass Reversal is done BEFORE 2:00 p.m., the funds will be credited to your account for that date. They will appear on the Client Settlement Totals Report. Please note that funds will not be available in your control account during the day.
• If some payments are already processed and destined to FI’s in Canada, if the reversal or Mass reversal is done AFTER 2:00 p.m. then the value for these payments will not be credited to your account until the next business day. They will appear on the Client Settlement Totals Report on the next business day. Funds will not be available in your control account until your account has been credited.
• Payments with a “Suspended” status are not included in the count and amount of a Mass Request. When these “Suspended” payments are released or cleared for processing, if such payments are part of a Mass Delete or Mass Reversal, they will be deleted and funds will be made available immediately to your control account for that date. They will appear on the Client Settlement Totals Report.

Availability

This report is produced when an input file has been processed and when an addition, change, correction, deletion or reversal has been made to any payment(s).

It can be picked up one day later via the online reports or data transmission. Fax service is not available for this report.

Report Headings

The following headings are used on the Client Settlement Totals Report:

HEADING	DEFINITION
ACCOUNT	Your branch and control account number debited or credited for the disbursements and activities of all your payments.
TIME	The time your input file(s) or payment activities were performed.
FILE RECEIVED (DEBIT)	The total amount of each input file received and processed.
ONLINE CREDITS	The amount and the function performed on each payment activity and Mass function.
ONLINE DEBITS	The amount and the function performed on each payment activity and Mass function.
FILE TOTAL	The dollar value debited to your control account for that date. This is an accumulated amount of all your payments from your input files regardless of the due date or value date of those payments.
ONLINE DEBIT TOTAL	The dollar value debited to your control account for that date. This is an accumulated total of all payment activities regardless of the due date or value date of those payments.
ONLINE CREDIT TOTAL	The dollar value credited to your control account for that date. This is an accumulated total of all payment activities regardless of the due date or value date of those payments.
REVERSAL TOTAL	The dollar value debited/credited to your control account for that date. This is an accumulated total of all single or Mass Reversals.

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

Report Content

This report shares some messages with the Payments Activity Report and the Mass Request Report.

The following payment messages are only used in the Client Settlement Totals Report:

Not Funded

This message indicates that you are converting from a Daily Limit to a Prefunding Service option.

The amount beside this message represents a total of all valid payments that were within your Daily Limit and/or payments that were In-Excess at the time of conversion (regardless of the due date or the value date of those payments).

To reconcile this amount use the Payment Activity Report, Previous Client Value Date Total Report, and Daily Limit- Payment Details Report.

Refunded

This message indicates that you are converting from a “Prefunding” to a “Daily Limit” Service option.

The amount beside this message represents a total of all valid pending payments (regardless of the due date or the value date) that we debited to your account upon receipt of these payments. These payments are being refunded and funds are being made available immediately to your control account. Your account will be debited for these payments on the Value Date of the payments.

This message could also reflect a change to the “Cross Border Indicator” on your profile. You are still set up with a “Prefunding” option but the “Cross Border Indicator” on your profile has been changed. The amount beside this message represents a total of payments that were valid at the time your input file was received and we debited your account with upon receipt of these payments. However, because of a change to the “Cross Border Indicator” on your profile, these payments can no longer be sent to the United States. These payments are revalidated and the status is changed from “Valid” to “Reject”.

This message could also reflect that you are still set up with a “Prefunding” option and the amount beside this message represents any of the following conditions and funds that are being refunded:

• Your profile is deleted and you have outstanding payments that have not been processed and are subsequently deleted.
• “Suspended” payments have been deleted.
• “Suspended” payments have cleared for processing and are subsequently deleted.
• “Suspended” payments that have cleared for processing and as they were part of a “Mass Delete” request are subsequently deleted.
• “Suspended” payments that have cleared for processing and as they were part of a “Mass Reversal” request are subsequently deleted.

To reconcile this amount use previous Client Settlement Reports, Payments Activity Report and Mass Request Report.

Select Error

This message indicates a payment that was valid upon receipt; however at the time of selecting this payment for distribution, there is an error attached to it and cannot be processed.

Therefore as we debited your control account upon receipt of this payment, we will make funds available immediately in your control account for this payment and we will credit your control account. This transaction is now invalid and can be corrected using RBC Express ACH Payment Manager.

To reconcile this amount use the Payment Selection Error Report.