Skip to content
OpeniDevelopers

CasesEducation

Daily cash flow with 30 connected accounts

Unisuam's finance manager logged into each bank, consolidated statements and classified everything by hand, and the cash flow could run 30 days late. Today the accounts arrive through Open Finance, transactions are classified by rule and the result goes to MXM.

Unisuam
Request accessDocumentation

From source data to result

  1. 130 accounts
  2. 2Open Finance
  3. 3Classification
  4. 4MXM
less operational work per month
60 h
accounts connected via Open Finance
30
cash flow scenarios automated
3+

The challenge. Education.

A university collects tuition by boleto, card and Pix, across several accounts and banks, and pays payroll and suppliers from others. To know how much cash there is today, someone has to log into each bank, gather the statements and classify every line by revenue source and cost center. When that is manual, the cash flow always shows the past.

From statement to cash flow
Example
Statement (30 accounts)Cash flow

  • Boletos settled

    R$ 212,400.00

    Classified

    Tuition

    Undergraduate

  • Pix received

    R$ 38,950.00

    Classified

    Tuition

    Graduate

  • Payroll

    R$ 164,300.00

    Classified

    Personnel

    Group: payroll

  • Investment yield

    R$ 1,912.47

    Classified

    Financial income

    Daily yield

Sample data, to illustrate the flow.

How it was done. The project, in 3 workstreams.

  1. Custom classification rules, with new fields such as payment group and financial analysis variables.
  2. Entry tables, filters and edits tied to the reporting module, with scenarios by expense type and cost center.
  3. Connection of up to 30 accounts via Open Finance, with export to PDF, Excel and OFX and to MXM, the university's ERP.

What stays visible. Set apart for the people who operate.

  • Receipts broken down by source and cost center
  • Outflows by payment group
  • Daily yield of investments

Other cases

“We integrated Open Finance in one sprint. The documentation answers before we need to ask.”
Marina DuarteHead of Engineering, credit fintech
“The reconciliation that took the team two days now runs on its own.”
Rafael AntunesCTO, retail chain

Teams from fintechs, retail and accounting already integrate with Openi.

Request access

Build your reconciliation. With the same calls.

The cases use documented endpoints only. Request access and run the flow with your own operation's data.

Request accessDocumentation