How to export the OFX statement (PJ cash flow)
CaixaUnica imports OFX into the Cash Flow (PJ) module. Importer:
cashflow-ofx. OFX is an open standard — same importer works for every
Brazilian bank.
Most-used PJ banks
| Bank | Path |
|---|---|
| Itaú Empresas | bankline.itau.com.br → Statement → Period → Save as OFX. |
| Bradesco Net Empresa | neteempresa.bradesco.com.br → Account → Statement → Export OFX. |
| Santander Way Empresas | santandernetibe.com.br → Statement → Export OFX. |
| Banco do Brasil PJ | bb.com.br/empresas → Account → Statement → Save as OFX. |
| Inter Empresas | inter.co/empresas → Statement → Export → OFX. |
| C6 Bank Empresas | c6bank.com.br/empresas → Statement → Share → OFX. |
| Nubank PJ | App → Statement → Export → OFX (mobile only). |
| Sicoob / Sicredi | Web app → Statement → Period → Save as OFX. |
If your bank isn't listed, search for "export OFX" or "electronic statement" inside its internet banking. Most Brazilian banks support it.
Import in CaixaUnica
- Open Upload.
- Drop the
.ofxfiles; auto-detected ascashflow-ofx. - Select the PJ account (one per CNPJ).
- Click Run.
Format details
- Accepts OFX 1.x (SGML) and 2.x (XML); auto-detected.
- Each
<STMTTRN>becomes a transaction. The OFXFITIDidentifies the transaction, so re-importing the same file does not duplicate rows. - Categories show "(Uncategorized)" on first import — use Tools → Categorize to set rules.
Gotchas
- Two files per month — some banks split into "movements" and "investments". Import both.
- Aggregated lines — some banks consolidate batches into one line
(
Cheque compensado dia X). This is an OFX limitation upstream, not the importer. - Encoding — older Itaú files use latin-1; new ones UTF-8. Both handled.