Connections/Banking data
Connections
Data points
Bank feed (BAI2)
Prior-day statements and lockbox detail
Enabled byTO Tom Okafor Jul 2026
Support Treasury
Docs frostbank.com
Health Healthy · 1 h ago
Environments
4 of 4 environments have full access · BAI2 via SFTP, prior day at 05:30
Integration credential
SFTP drop · Connected
Sync and profiling
Connection-wide preferences for how this source enters the model
Propose mappings automatically
New source values get a suggested treatment and wait for review.
Alert on schema and reference changes
Source-System Protection watches for new codes, renamed fields, and dropped tables.
Include archived and voided records
Keep history for reconciliation. Excluded from current-period calculations.
Feeds the model
Data points that read from this connection
About this connection
Overview
Bank feeds deliver prior-day BAI2 statements and lockbox detail for the operating, payroll, and receipt accounts, so cash can be reconciled against recorded payments every morning.
How it works
Files arrive by SFTP at 05:30. BAI type codes map to bank transaction types, lines match to Sage payments on amount and reference, and unmatched lines surface for review.
Bank transactionsLockbox receiptsACH and wire detailBalances