Pass-through integration for local government · records are never stored System status1-559-251-7767Sentra familySign in
SentraBridgeIntegration platform
ExampleTemplate

Munis paid checks to the bank positive pay file

Every weekday afternoon, reads the AP checks Munis issued and writes the bank's positive pay file to the SFTP outbox, so the bank only clears checks the city actually wrote.

Try it on your dataAll examples
This flow

5 steps

StartsOn a schedule
SystemsTyler Enterprise ERP (Munis), SFTP server
Branches0
Stored recordsNone: pass-through
§ The flow

The whole flow, as it appears on the canvas.

Scroll sideways on small screens. Colors show the kind of step: start, read, change, decide, write.

Flow diagram: Munis paid checks to the bank positive pay fileEvery weekday afternoon, reads the AP checks Munis issued and writes the bank's positive pay file to the SFTP outbox, so the bank only clears checks the city actually wrote.Weekdays at 4 pmOn a scheduleAP invoices from MunisGet records · MunisPaid by checkFilterPositive pay fieldsMap fieldsWrite the positive pay fileWrite file · SFTP
StartReadFilesDatabaseChangeDecideWriteAct
§ Step by step

What each step does.

  1. 01 · Start · On a schedule

    Weekdays at 4 pm

    • Cron 0 16 * * 1-5 (workspace time zone)

    Then: AP invoices from Munis

  2. 02 · Read · Get records · Tyler Enterprise ERP (Munis)

    AP invoices from Munis

    • Reads AP invoices from Tyler Enterprise ERP (Munis)
    • Only records changed since the last good run
    • At most 5,000 records per run

    Then: Paid by check

  3. 03 · Decide · Filter

    Paid by check

    • Keeps only records where status is Paid and checkNumber is not empty

    Then: Positive pay fields

  4. 04 · Change · Map fields

    Positive pay fields

    • Shapes each record into 6 fields: account, check_number, amount, issue_date, payee, void

    Then: Write the positive pay file

  5. 05 · Files · Write file · SFTP server

    Write the positive pay file

    • Writes POSITIVE_PAY file positive-pay-{{ $today }}.csv to outbox
    • One file with every record
§ Systems

Connectors used

Swap any of them for another system with the same kind of data.

§ Next

Keep exploring

Example311 triage: route every request to the right systemExampleMeter reads from AMI to utility billing with zero-read checkExampleLoad the bank's daily payment file into the city databaseExampleNew hires from NEOGOV to Munis (employee and payee vendor)

Run this flow on your systems.

We'll set up a workspace with your systems in a sandbox and build your first flow with you.

Request a demoBrowse live examples