01
Custom categorization rules, with new fields such as payment group and financial analysis variables.
Unisuam · Education
A daily cash flow across 30 connected accounts
Unisuam's finance manager logged into each bank, consolidated statements and categorized everything by hand, and the cash flow could run 30 days behind. Now the accounts arrive through Brazil's Open Finance, transactions are categorized by rule and the result goes to MXM.
How the data moves
- 0130 accounts
- 02Open Finance
- 03Categorization
- 04MXM
- less operational work every month
- 60 h
- accounts connected through Brazil's Open Finance
- 30
- cash flow scenarios automated
- 3+
The challenge
Why it's hard.Education.
A university collects tuition by boleto (Brazil's bank slip), 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, pull the statements together and categorize every line by revenue source and cost center. When that's manual, the cash flow always shows the past.
From bank statement to cash flow
- Boletos settledR$212,400.00TuitionUndergraduate
- Pix receivedR$38,950.00TuitionGraduate
- PayrollR$164,300.00PersonnelGroup: payroll
- Investment yieldR$1,912.47Financial incomeDaily yield
Sample data.
The project
How Openi solved it.In 3 steps.
- 02
Entry tables, filters and edits tied to the reporting module, with scenarios by expense type and cost center.
- 03
Up to 30 accounts connected through Brazil's Open Finance, with export to PDF, Excel and OFX and to MXM, the university's ERP.
For the team
What's in plain sight.No digging.
- Receipts broken down by source and cost center
- Outflows by payment group
- Daily yield on investments
On the platform
Solutions used.
- Bank and crypto connectivityOpen Banking in Europe and Brazil, direct bank integrations and crypto wallets: accounts, payments and transactions wired into finance and the ERP.
- CategorizationCategory, GL account and cost center suggested from your history and your rules.
- Reporting and analyticsCash, P&L, results by unit, forecasts and scenarios on reconciled data, also as white label.
- ERP integration and workflowsSystems connected, data transformed, rules, approvals and runs tracked until the ERP confirms them.
Demo
See Openiin your operation.
Leave your details. An Openi specialist will get back to you by email.
You leave your details
It takes less than a minute.A specialist gets in touch
To understand your banks, your ERP and what takes up the most time today.You see Openi at work
Reconciliation, categorization and reporting in cases like yours.
