Onboarding

6min

COS Reports onboarding guide
Introduction
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
Steps for onboarding a client to receive 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.
How reports are generated and named
Report generation process
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 file naming conventions
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
﻿COS Overdrawn Account Report﻿ 
﻿
Overdrawn Account Report_[date].xlsx
﻿RTP Daily Activity By Partner Report﻿ 
[PartnerName] RTP Activity Report_[timestamp].csv
Additional points
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.
﻿

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
COS Overdrawn Account Report	Overdrawn Account Report_[date].xlsx
RTP Daily Activity By Partner Report	[PartnerName] RTP Activity Report_[timestamp].csv

🤔

Have a question?

Our super-smart AI, knowledgeable support team and an awesome community will get you an answer in a flash.

To ask a question or participate in discussions, you'll need to authenticate first.

﻿

Updated 29 Sep 2024

Did this page help you?

Bank rails & accounts

Overdrawn account