Online Reconciliation Tool for Finance Teams

Cointab is an online reconciliation tool built for finance teams that need a structured way to compare internal records with external records, identify discrepancies, and produce audit-ready reconciliation reports. Instead of rebuilding Excel models every month, teams can upload files, map fields once, run reconciliation, and review matched, partially matched, unmatched, and skipped transactions in a clear workflow.

For businesses handling sales, settlements, bank entries, vendor statements, marketplace reports, or payment data, the challenge is rarely just matching rows. The real work is preparing files, handling exceptions, explaining differences, and keeping the process consistent across periods. Cointab is designed to make that process more reliable and reusable.

What an online reconciliation tool should do

A useful online reconciliation tool should help finance teams do more than compare two spreadsheets. It should support the full reconciliation workflow from file intake to report review.

That usually includes:

• Uploading Side A and Side B files in CSV, XLS, or XLSX format
• Mapping key fields such as date, amount, and identifier columns
• Handling multiple reports under the same reconciliation
• Creating supporting lookups or enrichment files when needed
• Running matching logic consistently across each period
• Separating matched, partially matched, unmatched, and skipped records
• Exporting reconciliation results in an audit-friendly format

This matters because reconciliation work often involves more than one source of truth. Finance teams may compare sales reports with payment gateway files, bank statements with books, marketplace settlements with internal ledgers, or vendor statements with payable records. An online reconciliation tool should support all of these workflows without forcing a different process each time.

How Cointab structures reconciliation

Cointab uses a Side A and Side B model to keep reconciliation simple and transparent.

• Side A contains the records your business expects to be correct, such as sales reports, ERP exports, ledgers, order files, or payable data.
• Side B contains external records received from banks, payment gateways, marketplaces, vendors, logistics partners, or customers.

Users can either choose a popular reconciliation template or create a custom reconciliation. Popular reconciliations are useful for standard partner reports, while custom reconciliations work well when a company has its own business logic.

The setup flow is straightforward:

1. Create a new reconciliation in the workspace
2. Select a popular or custom workflow
3. Upload the required files or configure automated data input
4. Map identifiers, amounts, and dates
5. Add supporting data if needed for lookup or enrichment
6. Create derived columns when a calculated field is required
7. Run reconciliation manually or on a schedule
8. Review the reconciliation report and exception details

Where the platform fits in finance operations

Cointab is useful anywhere finance teams need to compare two sides of financial or operational data.

Common use cases include:

• Sales vs payment gateway reconciliation
• Marketplace sales vs settlement reconciliation
• Bank statement vs books reconciliation
• Vendor reconciliation
• Customer reconciliation
• COD delivery partner reconciliation
• ERP reconciliation
• Payment reconciliation for multi-gateway environments

The goal is the same across these workflows: match records accurately, identify what does not match, and give the finance team a clean view of what needs attention.

Why manual reconciliation becomes difficult at scale

Many teams still rely on Excel formulas, VLOOKUPs, pivot tables, and repeated file comparisons. That may work for a small number of records, but it becomes hard to maintain when data grows or when multiple people are involved.

Common problems include:

• Manual preparation takes too long
• Formulas break or become difficult to audit
• Different team members prepare reports differently
• Large files become slow and hard to review
• Exceptions stay open for too long
• Missing files or late partner reports disrupt close cycles
• The same setup has to be recreated each period

An online reconciliation tool should reduce that repetition by making the workflow reusable. Once the reconciliation is configured, the same logic can be used again for future periods with much less setup.

Supporting data and derived columns

Not every reconciliation is a simple file-to-file comparison. Finance teams often need extra datasets to prepare the data before matching.

Cointab supports optional supporting data for tasks such as:

• Adding missing order or invoice details
• Merging reports before reconciliation
• Looking up fee or tax rates
• Pulling status information from another file
• Mapping partner IDs to internal IDs
• Enriching rows with product, store, or customer data

Users can also create derived columns on both sides. These are calculated fields built from existing columns, and they can be used for matching, filtering, or output.

Examples include:

• Clean order ID
• Net amount
• Refund amount as negative
• Normalized transaction reference
• Amount after fee
• Combined reference field

For finance users, this is helpful because the reconciliation logic stays reviewable while still allowing flexible preparation of the data.

How the reconciliation engine matches records

Cointab’s reconciliation engine uses structured matching logic to compare records across sides. It supports a range of matching patterns, including:

• One-to-one matching
• One-to-many matching
• Many-to-one matching
• Many-to-many matching
• Net-to-net matching
• Contra matching
• Partial matching

It also supports different identifier and comparison rules, such as equals, contains, similar, and subset-based matching.

This is important because real finance data is not always clean. One order may split into several settlement rows. A single payment may cover multiple invoices. References may appear in different fields. Amounts may differ by fees, refunds, or deductions. Cointab is built to handle those situations in a structured way instead of forcing teams to rely on ad hoc spreadsheet logic.

AI support for difficult open items

AI plays a supporting role in Cointab’s reconciliation workflow.

It can help finance teams in three practical ways:

• Formula creation: Users can describe a derived column in natural language and have AI generate an Excel-style formula.
• Open-item analysis: After structured matching is complete, AI can review remaining unmatched transactions and help interpret difficult cases.
• Reason and action analysis: AI can suggest why an item may be open, whether a file may be missing, or whether a refund, fee, return, or deduction may explain the difference.

The key principle is conservatism. If there is not enough evidence, the transaction should remain unmatched rather than being forced into a weak match.

What users see after reconciliation runs

Once a reconciliation run is complete, users can review a report dashboard that shows:

• Total summary
• Fully matched records
• Partially matched records
• Unmatched records
• Skipped records
• Transaction-level tables
• Filters for deeper analysis
• Detailed matched transaction views
• Downloadable Excel report

This makes it easier for finance teams to focus on exceptions rather than reviewing every record manually.

Fully matched

Fully matched records are those where the reconciliation logic confirms the identifiers and amounts line up as expected.

Partially matched

Partially matched records usually share a reference but differ in amount. These are often important because they show the transaction is related, but the difference still needs review.

Unmatched

Unmatched records appear on one side but do not have a match on the other side. These may point to missing files, timing differences, refunds, deductions, or data issues.

Skipped

Skipped records were excluded from the reconciliation because of an invalid row, missing required data, a duplicate, or another file issue. Making skipped records visible helps teams understand what was not included and why.

Reuse and automation for recurring periods

One of the biggest advantages of an online reconciliation tool is reuse. Once a workflow is configured, the same reconciliation can be run again for a new period without rebuilding everything from scratch.

Cointab also supports recurring automation through email, SFTP, and API integrations. That means data can be received or pulled automatically, validated, loaded into the correct workflow, and reconciled on a schedule.

This is especially useful for daily, weekly, monthly, or end-of-day reconciliation processes where finance teams need the same logic to run repeatedly with minimal manual effort.

If a file is missed, users can upload it later under the same reconciliation and refresh the report. That flexibility is useful in real-world finance operations where reports do not always arrive together.

Team workspace and audit readiness

Finance work is rarely done by one person. Cointab supports shared team workspaces so multiple users can work under a common account with roles, permissions, and audit logs.

That helps teams keep reconciliation work visible and consistent across users. It also makes it easier to review who ran a reconciliation, what files were used, and how exceptions were handled.

For reporting and audit preparation, users can download Excel outputs that show matched, partially matched, unmatched, and skipped records. That makes the reconciliation process easier to explain internally and easier to review during close or audit cycles.

Why finance teams choose a structured recon platform

An online reconciliation tool is most valuable when it reduces repeat work without hiding the logic from the user. Finance teams still need control, visibility, and clear exception handling.

Cointab is built around that idea:

• Upload your files and map fields once
• Reuse the same workflow for future periods
• Review matched and unmatched records clearly
• Use AI only where it helps with formulas or difficult open items
• Keep reconciliation output available for later review
• Support audit-ready reporting without relying on scattered spreadsheets

For teams that reconcile high-volume or multi-source data, that structure can make financial operations faster, cleaner, and easier to manage.