Morning file loading
Someone downloads the bank's file, opens it, fixes it and loads it before posting can start.
For finance teamsBy role
Bank files loaded by 7 am.
Bad rows flagged, not lost.
Payment files, billing exports and accounting systems move on schedules. SentraBridge loads and checks them, emails exceptions to finance, and keeps no copy of the payment data.
§ The problem
What gets in the way.
Bad rows found late
A malformed row stops the load or, worse, loads wrong.
Payments that need sign-off
Some movements of money shouldn't happen without a person approving.
§ How it works
How it works for finance
- 01Weekdays at 6 amThe flow starts on schedule.
- 02Read filesNew payment CSVs from the bank's folder.
- 03CheckValid rows continue; invalid rows split off.
- 04LoadUpsert into the payments table.
- 05Email exceptionsBad rows to finance as a CSV.
§ What you get
Built for finance.
Read bank files
CSV, JSON, JSON Lines and XML from SFTP, with host-key pinning and archive after read.
Learn more →Rules with an Invalid output
Required fields, number and date checks; bad rows go to finance as a CSV attachment.
Learn more →Approvals
Pause a flow until a person approves. It holds record IDs only and re-reads on approval.
Learn more →§ Examples
Flows that fit.
Generated from SentraBridge's ready-made templates.
SFTP server → PostgreSQL / PostGIS
Load the bank's daily payment file into the city database
Every morning, reads new payment CSV files from the bank's SFTP folder, cleans and checks them, loads them into a database table, and archives the…
Sentra 311 → SFTP serverNightly 311 export as a CSV file on SFTP
Every night, writes yesterday's changed Sentra 311 requests to a dated CSV file in an SFTP folder for another system to pick up.
Data quality alert (sub-flow)
A reusable sub-flow: other flows hand it the records that failed their checks, and it emails the data team a summary with a CSV attached.
§ Systems
Systems you likely run.
Each links to its connector page. Not listed? Any REST API, OpenAPI file, database or SFTP server works.
§ FAQ
Questions, answered
Does SentraBridge connect to Munis?
Tyler Munis is listed, but it needs the city's Tyler API access. Many finance teams also exchange files over SFTP, which SentraBridge handles directly.
Is payment data stored?
No. Rows are held in memory while the flow runs. History keeps counts, timings and record IDs.
What happens to the file after loading?
You choose: leave it, move it to an archive folder, or delete it, after a good run.
See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.