Onboarding
This guide provides partners with the following:
- Instructions on how to onboard for receiving COS reports
- A description of the report generation process, including the generation schedule, SFTP file path conventions and report file naming conventions.
- Additional points on COS reports
- The partner emails Integration Support to set up an SFTP account.
- Integration Support sends the partner an SFTP setup form, which the partner fills out and sends back to Integration Support.
- CRB’s Integration Support emails the username/password information back to the partner.
- The partner configures access to the SFTP folders, including access permissions for the folders.
- The partner can set up sandbox and/or production folders within the SFTP master account.
- Integration Support notifies the partner when the process is complete.
Once the partner has been onboarded, the reports are scheduled to run daily at 3AM EST, and are uploaded immediately following that.
The report files are uploaded to the following paths:
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\AccountActivity
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\AccountBalance
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\AchActivity
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\Webhooks
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\WireActivity
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\Overdrawn Account Report
- \\sftp01\PTPs\<Partner Name>\PROD\COS\DailyReports\RTP Daily Activity By Partner
Report | Naming Convention |
|---|---|
Account Activity Report | [PartnerName]_Daily_Account_Activity_[timestamp].csv |
Account Balance Report | [PartnerName]_Daily_Account_Balance_[timestamp].csv |
ACH Activity Report | [PartnerName]_Daily_Ach_Activity_[timestamp].csv Note: Data team needs to consolidate the naming convention on this one since we have some variations. |
Webhooks Report | [PartnerName]_Webhook_Events_[timestamp].csv |
Wire Activity Report | [PartnerName]_Daily_Wire_[timestamp].csv |
 | Overdrawn Account Report_[date].xlsx |
[PartnerName] RTP Activity Report_[timestamp].csv |
- The partner receives a notification when a report is uploaded via SFTP.
- The report files in the SFTP folders are not deleted automatically.
- The reports will be PGP-encrypted.
- In addition to .csv and .xlsx, reports can be delivered in formats such as MT940 and PDF. Partners can contact the Relationship Manager for assistance with delivering reports in alternative formats.


