UPCOMING: Exporting an ACH Bank Transfer File and Updating Pmt Reference Numbers
You must to configure Suppliers and a bank account prior to exporting a file for upload to RBC Royal Bank. Click here to learn how to configure a Supplier and bank account for the export.
To pull the list of payments to include in the exported file, navigate to:
Banking > ACH Bank Transfer
Once the ACH Bank Transfer List opens, you will want to add the following columns to your grid to assist you in reviewing, exporting, and emailing payments.
Next, set the date range for the checks to export. Check the box for Unexported Only 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 ACH Bank Transfer file.
If RBC Royal Bank rejects the file, you will need to verify the configuration data set up on the Supplier and the bank account and correct any errors.
After receiving confirmation of the ACH Transfers from your bank, you can update the Num. / Ref on the payment with the confirmation number directly on the ACH Bank Transfer List.
Right-click on any payment line on the grid and select "Update Payment Number / Ref."
You will get a pop-up that will include one line for each payment visible in the ACH Bank Transfer List. You can edit the Num. / Ref. field directly in the grid. When you have finished editing, click OK to update the payment documents with the new Reference/Check numbers.
