Financial Reconciliation Features for Finance Teams
Cointab brings together the core features finance teams need to reconcile records across systems, partners, banks, marketplaces, vendors, and internal books. It is built for recurring reconciliation workflows where users upload files, map fields, run matching rules, review exceptions, and export audit-ready reports.
Core reconciliation features
The platform is designed around a clear Side A and Side B model:
- Side A holds the records your business expects to be correct, such as sales, books, ERP exports, receivables, or internal order data.
- Side B holds external records received from payment gateways, banks, marketplaces, delivery partners, vendors, customers, or tax sources.
| Feature | What it helps finance teams do |
|---|---|
| Popular reconciliations | Use pre-built setups for standard workflows such as sales vs payment, marketplace vs settlement, bank vs books, or COD reconciliation. |
| Custom reconciliations | Build business-specific workflows with your own Side A and Side B reports. |
| File upload and validation | Upload CSV, XLS, or XLSX files and validate that the structure matches the configured report format. |
| Field mapping | Map date, amount, and identifier columns once, then reuse the setup for future runs. |
| Supporting data | Upload lookup or enrichment files to prepare primary data before reconciliation. |
| Derived columns | Create calculated fields for cleaning IDs, deriving amounts, or preparing match logic. |
| Structured matching engine | Match transactions across one-to-one, one-to-many, many-to-one, many-to-many, net-to-net, and partial scenarios. |
| AI-assisted review | Use AI to analyze open items, explain possible reasons for mismatches, and support exception handling. |
| Manual match | Manually match unresolved transactions when business context is clear and totals tally. |
| Reporting and exports | Review matched, partially matched, unmatched, and skipped records, then download Excel reports. |
| Automation and reuse | Schedule runs and automate data flow through email, SFTP, or API once the workflow is configured. |
| Dashboard and audit trail | Track reconciliation history, run status, and activity in one shared workspace. |
A workflow built for recurring finance operations
Cointab follows a structured reconciliation flow that is easy for finance teams to understand and repeat:
- Sign in to a team workspace.
- Start a new reconciliation.
- Select a popular reconciliation or create a custom one.
- Upload the required files on Side A and Side B, or configure automated input.
- Map the required fields such as date, amount, and identifier columns.
- Optionally upload supporting data for lookups, merging, enrichment, or calculation.
- Optionally create derived columns using AI-generated Excel-style formulas.
- Run reconciliation manually or on a schedule.
- Review live progress while the reconciliation is running.
- Review matched, partially matched, unmatched, and skipped records once the report is ready.
This approach keeps the process transparent. Finance teams can see what data was used, what logic was applied, and what still needs review.
Matching logic that reflects real-world finance cases
Not every reconciliation is a simple exact match. Cointab’s reconciliation engine is designed for real transaction patterns such as:
- one-to-one matching
- one-to-many matching
- many-to-one matching
- many-to-many matching
- contra matching
- partial matching
- net-to-net comparison
The engine can compare identifiers and amounts using structured logic such as equals, contains, similar, and subset-based matching. This is useful when references appear in different fields, when partner data is incomplete, or when multiple rows need to be grouped before comparison.
For open items that remain after rule-based matching, AI can help analyze likely reasons and next steps. The system is designed to stay conservative: if the evidence is weak, the record should remain unmatched rather than forcing an unreliable match.
Reconciliation review, reporting, and audit readiness
Once reconciliation is complete, users can review the results in a clear report view.
Report views include
- fully matched transactions
- partially matched transactions
- unmatched transactions
- skipped transactions
- transaction-level tables
- filters for deeper analysis
- detailed matched transaction views
- Excel report downloads
This makes it easier to separate routine matches from exceptions that need attention. Partially matched items are especially important in finance operations because they often point to deductions, fees, refunds, rounding differences, missing data, or settlement adjustments.
Skipped records are also visible, so users know which rows were excluded and why. That helps teams maintain better control over data quality and review scope.
Cointab also keeps reconciliation runs available on the dashboard for future reference, supporting audit trails and period-over-period follow-up.
Features for automation and reuse
A major advantage of Cointab is that reconciliation setups do not need to be rebuilt every period. Once a workflow is configured, teams can reuse it for future runs with the same mappings, fields, and logic.
Automation features support recurring finance operations such as:
- daily payment reconciliation
- monthly bank reconciliation
- marketplace settlement reconciliation
- COD remittance reconciliation
- vendor reconciliation
- custom internal vs external data checks
Cointab can receive or pull data through email, SFTP, or API, then run reconciliation automatically when the required files are available. After the run, output can be delivered back through email, SFTP, or API for downstream finance, accounting, analytics, or reporting workflows.
If a file was missed, users can upload it under the same reconciliation and refresh the report. That is helpful in real finance operations where reports often arrive late or out of sequence.
Built for standard templates and custom workflows
Cointab supports two common ways of working:
Popular reconciliations
These are pre-built templates for standard partner and finance workflows. Examples include sales vs payment, marketplace vs settlement, bank vs books, and COD delivery partner reconciliation. They are useful when report structures are consistent and the matching logic is widely repeated.
Custom reconciliations
Custom reconciliations are built for business-specific workflows. Finance teams can define their own Side A and Side B reports, upload multiple files on both sides, use supporting data, create derived columns, and define reusable match logic.
This flexibility makes the platform suitable for teams that reconcile multiple sources across ERP, bank, marketplaces, payment providers, vendors, and internal reports.
Team workspace and control
Cointab supports team-based workspaces so finance teams can work in one shared environment instead of passing spreadsheets around by email. Work can be reviewed, repeated, and audited within a common account, which improves visibility into who ran each reconciliation and what changed between periods.
Who these features are designed for
Cointab’s features are especially relevant for:
- finance teams managing month-end close and recurring reconciliations
- controllers and CFOs who need clear visibility into exceptions and reporting
- accounts payable and receivable teams
- reconciliation managers and analysts
- audit and compliance teams
- eCommerce and marketplace finance teams
- businesses reconciling sales, settlements, payments, bank statements, vendors, or customer records
FAQ
What types of reconciliation can Cointab support?
Cointab can support a wide range of reconciliation workflows, including sales vs payment gateway, marketplace vs settlement, bank vs books, vendor reconciliation, COD reconciliation, and custom internal vs external comparisons.
Can finance teams reuse the same setup every month?
Yes. Once a popular or custom reconciliation is configured, the setup can be reused for future periods instead of rebuilding the workflow from scratch.
How does Cointab handle unmatched or partial transactions?
The platform separates fully matched, partially matched, unmatched, and skipped records so finance teams can focus on the exceptions that need review or follow-up.
Can reconciliation run automatically?
Yes. After a workflow is configured, Cointab can automate data input and scheduled reconciliation runs through email, SFTP, or API-based data flow.
