Product updates
3-Way Reconciliation and Multi-Amount Matching Now Available in Cointab
Finance teams often need to reconcile more than two reports and compare more than one financial value for the same transaction.
Cointab now supports two new capabilities designed for these workflows:
- 3-way reconciliation
- Multiple amount comparisons
These features make it easier to build more complete reconciliation workflows without splitting the process across multiple reconciliations or checking different amount fields separately.
Reconcile three connected sides in one workflow
A common reconciliation process may involve three connected stages.
For example:
ERP → Payment Gateway → Bank
Previously, this would typically require two separate reconciliation workflows:
- ERP vs Payment Gateway
- Payment Gateway vs Bank
The Payment Gateway report would also need to be uploaded and processed in both workflows.
With 3-way reconciliation, the complete flow can now be configured within a single Cointab workflow.
For example:
ERP → Stripe + PayPal + Adyen → Bank
The user can upload the required ERP, payment gateway, and bank reports and run the connected reconciliation together.
This reduces repeated setup and avoids having to upload the same intermediate data in separate reconciliation workflows.
2-way and 3-way reconciliation
Cointab now supports both 2-way and 3-way reconciliation structures.
2-way reconciliation
A 2-way reconciliation compares two logical sides.
Examples:
- Books vs Bank Statement
- ERP vs Payment Gateway
- Vendor Ledger vs Vendor Statement
- Sales Report vs Marketplace Settlement
Each side can contain one or more reports.
For example:
ERP vs Stripe + PayPal + Adyen
is still a 2-way reconciliation, even though the workflow contains four reports or data sources.
3-way reconciliation
A 3-way reconciliation connects three logical sides within the same workflow.
Examples:
- ERP vs Payment Gateway vs Bank
- POS vs Delivery Platform vs Bank
- Internal Sales vs Marketplace Settlement vs Bank
This is useful when the reconciliation process naturally moves through three connected stages.
Compare multiple amounts within the same reconciliation
Reconciliation often involves more than checking whether one amount matches.
Consider an ERP vs Marketplace reconciliation.
A finance team may want to compare:
- Product value
- Sales tax / GST
- TDS / withholding tax
- Discount
- Commission
- Fees
- Net amount
Previously, a Cointab workflow supported one primary amount comparison.
With multiple amount comparisons, users can now configure several amount pairs within the same reconciliation.
For example:
| ERP field | Marketplace field |
|---|---|
| Product Value | Item Value |
| GST | Tax |
| TDS Receivable | Withholding Tax |
| Discount | Discount |
| Net Amount | Settlement Amount |
Cointab can then evaluate these values for the same matched transactions.
Understand exactly where the difference is
Matching the transaction identifier is often only the first part of reconciliation.
Two systems may contain the same Order ID while individual financial values differ.
For example:
| Field | ERP | Marketplace |
|---|---|---|
| Product Value | 10,000 | 10,000 |
| Tax | 1,800 | 1,800 |
| Discount | 500 | 500 |
| Withholding Tax | 100 | 120 |
| Net Amount | 11,200 | 11,180 |
Instead of only knowing that the overall transaction has a difference, the finance team can see that the difference relates specifically to the withholding tax amount.
This makes reconciliation output more useful for investigation and exception review.
Use multiple reports and multiple amount comparisons together
The new capabilities can also be combined.
For example, a workflow may contain:
ERP → Stripe + PayPal + Adyen → Bank
Within the same workflow, the user may compare:
- Gross amount
- Tax
- Gateway fees
- Refund amount
- Net settlement amount
This gives finance teams a single workflow for both the movement of transactions across systems and the financial values that need to agree between them.
Why this matters
Complex reconciliation processes often become difficult to manage because they are divided across spreadsheets, separate workflows, and multiple manual checks.
3-way reconciliation and multiple amount comparisons help reduce this fragmentation.
Finance teams can:
- Configure connected reconciliation stages in one workflow
- Avoid uploading the same intermediate report multiple times
- Compare several financial values for the same transaction
- Identify exactly which amount differs
- Keep reconciliation logic reusable for future periods
- Review exceptions from a more complete view of the transaction
Build the workflow that matches your reconciliation process
Cointab supports simple 2-way reconciliations as well as more complex multi-report and 3-way workflows.
You can start with common reconciliations such as Bank, Vendor, Customer, Payment Gateway, or Marketplace reconciliation, or build a custom workflow around your own reports and business rules.
Start free or schedule a guided setup to map your reconciliation workflow in Cointab.
