A person and a spreadsheet
Someone downloads the file every morning, fixes it in Excel and imports it.
Payment filesSolution
The bank's file, loaded.
Bad rows to finance.
Read the bank's daily payment files from SFTP, clean and check every row, load the good ones into the finance database, email the bad ones, and archive the file.
This solution
Payment & finance files
StartsOn a schedule · Weekdays at 6 am
SystemsSFTP server, Microsoft SQL Server, PostgreSQL / PostGIS, QuickBooks Online…
Templates2 ready-made flows to start from2
Stored recordsNone: pass-through, in memory only0
Preview any template on your own data before it writes anything.
§ The problem
What it looks like today.
Silent bad rows
A row with no account or a negative amount loads anyway and turns up at month end.
Files piling up
The SFTP inbox fills with files nobody is sure were processed.
§ How it works
How it works: Payment & finance files
- 01Weekdays at 6 amBefore the office opens
- 02Read filesNew CSVs on the bank's SFTP
- 03Clean and checkValid / Invalid
- 04Loadutility_payments table
- 05Email bad rowsCSV attached to finance
- 06ArchiveMove the file after a good run
§ 01 / Bank payments
Every morning, before anyone logs in.
Weekdays at 6 am, new payment CSVs are read from the bank's SFTP folder, cleaned and checked, and loaded into a database table. Bad rows are emailed to finance with a CSV attached, and the files are archived.
- Host key pinned on every connection
- Only new files since the last good run
- Each record keeps its source file name
§ 02 / Exports out
Files for the systems that want files.
The same steps run in reverse: a nightly CSV, JSON Lines or XML file written to an SFTP folder for another system to pick up.
- Dated file names
- One file per run or per record
- QuickBooks Online and Stripe connectors too
§ Templates
Ready-made flows for this.
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.
§ Systems
Works with
Pre-built connectors used in this solution. Anything else with an API, a database or SFTP works too.
§ Next
Who uses this
See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.