UPCOMING: Exporting a Check Verification File for RBC Royal Bank

You must to configure the bank account prior to exporting a file for upload to RBC Royal Bank.  Click here to learn how to configure a bank account for the export.

To pull the list of payments to include in the exported file, navigate to:

Banking > Check Verification

Once the Check Verification Bank List tab opens, you will want to add the following columns to your grid to assist you in reviewing payments for export.

Next, set the date range for the checks to export. Check the box for Unexported Only if you wish to limit the list to checks that have not been included in a previous export file. Click Fetch to populate the payments in the grid.

In my example, there is only a single bank account populating.  If you have multiple bank accounts, you will see all payments from all bank accounts.  You can create multiple files for multiple bank accounts at one time.  The system will create one file for each configured bank account and include all payments that are visible in the grid.  You can use the available pre-fetch and post-fetch filters to remove any payments you do not want to include in the export.

Once you have filtered your grid to the payments you wish to include, click on the Export button in the header.

You will receive pop-ups confirming the export details.  Click Yes to proceed and No to cancel the file creation.

After clicking Yes, you will see a popup allowing you to navigate to the folder of your choice and save the file.  You can edit the file name prior to saving. Click Save to export the file to the selected folder.

After exporting the file, you will need to log into your bank to upload the Check Verification file.  

If RBC Royal Bank rejects the file, you will need to verify the configuration data set up on the bank account and correct any errors.