Bring uploaded files, available business tables, and configured sources into the operating process. Agents can retrieve files from existing FTP connections and extract notice fields from PDFs for review, helping turn received information into data your team can use.
Data connected and prepared for your agents
Agents bring source records together, shape them into usable data, and prepare the inputs for reconciliation and reporting.
security_referenceSchema
Security reference 4 records
| security_id | name | currency | asset_type |
|---|---|---|---|
| AAPL | Apple | USD | Equity |
| MSFT | Microsoft | USD | Equity |
| BOND-27 | Corporate bond | USD | Fixed income |
| NVDA | NVIDIA | USD | Equity |
security_reference
- Source
- Data Storage
- Key
- security_id
- Status
- Live
Processes
| Process | Side A | Side B |
|---|---|---|
| Daily positions | FILE custodian_positions.csv | TABLE security_reference |
Loads
Drop .csv files
| File | Type | Header | Uploaded | |
|---|---|---|---|---|
| custodian_positions.csv | text/csv | Yes | Sep 15, 09:00 |
Runs
No runs.
The file and security reference are ready for preparation.
Thought process⌄
Reading custodian_positions.csv
Reading security_reference
Sources identified
Processes
| Process | Side A | Side B |
|---|---|---|
| Daily positions | FILE custodian_positions.csv | TABLE security_reference |
Loads
Drop .csv files
| File | Type | Header | Uploaded | |
|---|---|---|---|---|
| custodian_positions.csv | text/csv | Yes | Sep 15, 09:00 |
Runs
No runs.
The file and security reference are ready for preparation.
● Draft● LiveLive v1 · Draft v2
prepared_position · Proposed v2Checked
| Column | Type | Required |
|---|---|---|
| account_id | varchar(40) | Required |
| security_id | varchar(40) | Required |
| quantity | numeric(18,6) | Required |
| as_of_date | date | Required |
| currency | varchar(3) | Required |
✓ Review the checked configuration before publication.
Thought process⌄
Mapping account and security
Normalizing dates
Reviewing USD labels
● Draft● LiveLive v1 · Draft v2
prepared_position · Proposed v2Checked
| Column | Type | Required |
|---|---|---|
| account_id | varchar(40) | Required |
| security_id | varchar(40) | Required |
| quantity | numeric(18,6) | Required |
| as_of_date | date | Required |
| currency | varchar(3) | Required |
✓ Review the checked configuration before publication.
Prepared positions1 row needs review
| Account | Security | Quantity | As of | Currency |
|---|---|---|---|---|
| AC-101 | AAPL | 100 | 2026-09-15 | USD |
| AC-102 | MSFT | 250 | 2026-09-15 | USD |
| AC-103 | BOND-27 | 500 | 2026-09-15 | USD |
| AC-104 | Missing identifier | 75 | 2026-09-15 | USD |
Batch refused: row 4 is missing its security identifier. No rows added.
Thought process⌄
Checking required fields
Validating quantities and dates
One invalid row found
Prepared positions1 row needs review
| Account | Security | Quantity | As of | Currency |
|---|---|---|---|---|
| AC-101 | AAPL | 100 | 2026-09-15 | USD |
| AC-102 | MSFT | 250 | 2026-09-15 | USD |
| AC-103 | BOND-27 | 500 | 2026-09-15 | USD |
| AC-104 | Missing identifier | 75 | 2026-09-15 | USD |
Batch refused: row 4 is missing its security identifier. No rows added.
Processes
| Process | Side A | Side B |
|---|---|---|
| Daily positions | FTPCustodian SFTP | TABLE security_reference |
prepared_position · v2Approved preparation · same mapping retained
ApprovedCorrected sample
| Account | Security | Quantity | As of | Currency |
|---|---|---|---|---|
| AC-101 | AAPL | 100 | 2026-09-15 | USD |
| AC-102 | MSFT | 250 | 2026-09-15 | USD |
| AC-103 | BOND-27 | 500 | 2026-09-15 | USD |
| AC-104 | NVDA | 75 | 2026-09-15 | USD |
All required identifiers are present. Review before approving the preparation.
Custodian SFTP · connectedDaily positions file → approved v2 mapping → prepared_position
ReadyScheduled task
Daily positions importEvery day at 9:00 AM · America/New_York
Daily positions importEvery day at 9:00 AM · America/New_YorkEnabled · next run tomorrow at 9:00 AMLast run just now · Succeeded · next run tomorrow at 9:00 AM
Loads
| File | Type | Header | Source |
|---|---|---|---|
| custodian_positions.csv | text/csv | Yes | FTP Custodian SFTP |
Runs
| Process | Output | Records | Status |
|---|---|---|---|
| Daily positions | prepared_position | 4 added | Succeeded |
✓ First connected run complete. Daily imports use the same approved preparation.
Thought process⌄
Reviewing the corrected sample for approval
Switching to the custodian connection
Enabling daily data pulls
Start with the source records.
Upload the custodian file and identify the internal reference data it should use. Boagent can also retrieve a file from an existing configured FTP source, with the selected input visible.
Compatible with 200+ financial, custodian, and broker systems
-
SFTP
-
REST API
-
SWIFT
-
FIX Protocol
-
SQL
-
Email
Complete data drives back office automation
- AgentMap source fields
- HumanChoose sources
- AgentValidate input records
- HumanApprove data access
- AgentPrepare reusable data
- HumanReview field meanings
- AgentExplain validation findings
Questions worth asking.
Start with the work
your firm needs done.
Bring a process, its sources and the decisions that matter. We’ll work through how Boagent could fit your team.
Let’s talk