Orders, payments and bank statements reconciled without spreadsheets
We automatically match orders, payments received, refunds and bank statements, and show what does not match, with the reason and how to resolve it.
Who it's for
For companies whose finance team spends hours cross-checking statements, PSP reports and the order system.
What it solves
- Month-end close depends on someone matching statements and orders in a spreadsheet.
- An unidentified Pix payment arrives and nobody knows which order it belongs to.
- Card sales arrive net of fees and, when paid in instalments, on several dates.
- A difference turns up at month-end and takes days to explain.
What we do
- Collecting the sources
- Bank statements, PSP and card acquirer reports, OFX and CNAB files, and the orders in your system.
- Matching rules
- Matching on transaction identifier (such as the Pix one), amount and date, with tolerances your team approves.
- Fees, instalments and refunds
- Deducted fees, instalment sales and partial refunds checked against the original order amount.
- Difference report
- Whatever did not match, grouped by reason, with the order and the transaction side by side.
- Reprocessing
- Once the cause is fixed, the period is checked again without duplicating entries.
- Export for accounting
- A file in the format your accountant or ERP accepts; accounting classification stays with them.
What you get
- An automatic reconciliation routine, running at the agreed time
- A difference report with the reason and status of each open item
- Documented matching rules that your finance team can review
- Automated tests covering payments, fees, instalments and refunds
- An export in your accountant's or ERP's format
How we do it
Mapping the sources
Which statements, reports and systems exist, and how each one identifies a payment.
Sample period
We reconcile a past period to find the real rules and exceptions.
Development
Collection, rules, difference report and reprocessing, tested with that period's data.
Parallel run
For a while, the routine runs alongside the manual check so the two can be compared.
Follow-up
Rules are adjusted as new kinds of difference appear.
Technology examples
- PostgreSQL
- Python
- API Pix
- OFX
- CNAB
Related services
FAQ
Does Balkan do the bookkeeping?
No. Balkan is not an accounting firm. We reconcile the data and deliver the file; accounting classification and tax interpretation stay with your accountant.
Does it work with more than one bank and payment method?
Yes. Each bank, PSP or card acquirer comes in through its own connector. The effort depends on the format available: API, CNAB file, OFX or an exported report.
What happens to items that do not match?
They go into the difference report with the likely reason. Your team settles the item or fixes the source, and the period is checked again.
Do we need to change our ERP?
No. Reconciliation reads from the systems you already have and sends the result back to them. Connecting those systems to each other is covered under systems integration.
Write to Balkan
Talk to us about your project