Intercompany reconciliation
Intercompany reconciliation software for finance teams
Cointab helps finance teams reconcile transactions and balances between group entities, subsidiaries, branches, shared service centers, and related companies.
View live demo reportTrusted by teams reconciling multi-entity finance data
Cointab is used by finance and accounts teams handling recurring reconciliation across internal entities, vendors, customers, payments, banks, marketplaces, partners, and group-level finance systems.
Intercompany reconciliation becomes complex when entities record the same transaction differently
In intercompany workflows, two related entities often record the same transaction from opposite sides. One entity may record a receivable, another may record a payable. Differences in timing, currency, tax, reference numbers, allocations, and period cut-offs can make manual reconciliation difficult.
Due-to and due-from balances may not agree
One entity may show an amount receivable while the other entity shows a different payable balance.
Intercompany invoices may be missing on one side
An invoice raised by one group entity may not be recorded by the receiving entity in the same period.
Payments may not be allocated correctly
One intercompany payment may settle multiple invoices, advances, loans, reimbursements, or recharges.
Timing differences affect period close
One entity may post an entry in the current month while the counterparty entity records it in the next period.
Currency differences create open items
Entities using different currencies may have exchange rate differences, translation differences, or revaluation entries.
Cost allocations and recharges are hard to trace
Shared costs, management fees, IT charges, payroll allocations, rent recharges, and other group expenses may be split across entities using different logic.
Eliminations need clean support
Group finance teams need clear intercompany matching before consolidation and elimination entries.
Excel becomes difficult across entities
Finance teams often compare ledgers from multiple ERPs, accounting systems, entities, currencies, and account codes using repeated VLOOKUPs, pivots, and manual checks.
Open items need clear ownership
Teams need to know whether the issue belongs to Entity A, Entity B, group finance, tax, treasury, accounting, or operations.
What is intercompany reconciliation?
Intercompany reconciliation is the process of matching transactions, balances, invoices, payments, loans, recharges, and adjustments between related entities within the same group.
For example, Entity A may record an intercompany receivable from Entity B. Entity B should record the corresponding payable to Entity A. If both sides use the same reference, amount, period, account, and currency logic, the transaction should match. If not, it becomes an intercompany exception.
Cointab helps bring these records together so your finance team can answer:
- Which intercompany invoices are recorded by both entities?
- Which invoices are missing on one side?
- Which payments are recorded but not allocated?
- Which due-to and due-from balances match?
- Which balances differ because of timing, FX, tax, or posting differences?
- Which recharges or cost allocations are not reflected correctly?
- Which loan, advance, or settlement entries remain open?
- Which elimination entries are supported by matched transaction data?
- Which exceptions need follow-up with a specific entity or finance owner?
Bring together entity ledgers, intercompany invoices, payments, balances, and eliminations
Cointab can reconcile intercompany workflows using reports from ERP systems, accounting systems, entity ledgers, consolidation tools, bank data, and supporting finance files.
| Data source | Example records |
|---|---|
| Entity A ledger | Account code, entity code, invoice number, posting date, debit amount, credit amount, balance |
| Entity B ledger | Counterparty entity, account code, reference, invoice number, payable amount, receivable amount |
| Due-to / due-from report | Entity pair, intercompany account, opening balance, movements, closing balance |
| Intercompany invoice report | Invoice number, invoice date, issuing entity, receiving entity, tax amount, gross amount |
| Intercompany payment report | Payment date, amount, bank reference, allocation, entity pair, settlement reference |
| Loan / advance report | Loan reference, advance amount, repayment, interest, maturity, balance |
| Recharge / allocation report | Cost center, allocation basis, recharge amount, expense type, receiving entity |
| Debit note / credit note report | Adjustment number, reason, linked invoice, amount, issuing entity, receiving entity |
| FX / currency report | Transaction currency, reporting currency, exchange rate, revaluation difference |
| Elimination report | Elimination account, entity pair, transaction amount, elimination amount, difference |
| Bank statement | Intercompany payment, UTR/reference, debit/credit date, bank amount |
| Supporting data | Entity master, account mapping, currency mapping, cost center mapping, allocation logic |
Users can start with ledgers from two entities, then add invoice, payment, loan, recharge, FX, elimination, bank, or supporting reports as the workflow becomes more complete.
Find intercompany differences faster
Cointab helps finance teams separate clean intercompany matches from exceptions that need review before close, consolidation, audit, or reporting.
Invoice missing in receiving entity
The issuing entity records an intercompany invoice, but the receiving entity does not record the corresponding payable.
Invoice missing in issuing entity
The receiving entity records a payable or expense, but the issuing entity does not show the matching receivable or income entry.
Due-to and due-from mismatch
The balance payable by one entity does not match the balance receivable by the counterparty entity.
Payment not reflected
One entity records an intercompany payment, but the counterparty entity does not record the receipt.
Unallocated payment
A payment is present, but it is not clearly allocated to invoices, loans, advances, or recharges.
Timing difference
The same transaction is recorded in different periods by different entities.
Amount mismatch
The transaction reference matches, but the amount differs because of tax, FX, allocation, partial settlement, or adjustment.
Currency difference
The transaction amount differs because entities use different exchange rates, reporting currencies, or revaluation methods.
Tax or withholding difference
Tax, GST, VAT, withholding, or TDS treatment differs between the two entities.
Recharge mismatch
Shared costs or group recharges are recorded differently across entities.
Loan or advance mismatch
Intercompany loans, advances, repayments, or interest entries do not match between entities.
Duplicate intercompany entry
The same invoice, payment, loan, or journal entry appears more than once on one side.
Elimination mismatch
The intercompany balance does not support the elimination entry required for consolidation.
How Cointab automates intercompany reconciliation
Cointab gives finance teams a reusable workflow for preparing intercompany data, matching records, reviewing exceptions, and exporting reports.
Select or create the workflow
Start with an intercompany reconciliation template or build a custom workflow for your group entities, ERP exports, accounting ledgers, consolidation process, or internal reports.
Upload or automate data
Upload CSV, XLS, or XLSX files manually, or automate recurring data input through email, SFTP, or APIs.
Map required fields
Select date, amount, and identifier columns such as entity code, counterparty entity, account code, invoice number, journal number, payment reference, loan reference, settlement ID, or bank UTR.
Add supporting data
Use supporting files for entity mapping, account mapping, currency conversion, cost center mapping, allocation logic, tax treatment, opening balance treatment, or elimination logic.
Create derived columns
Use AI to create calculated fields such as normalized entity pair, clean invoice number, reporting currency amount, net intercompany balance, tax-adjusted amount, FX-adjusted amount, or combined matching reference.
Run reconciliation
Cointab applies structured matching logic across entity ledgers, intercompany invoices, payments, loans, advances, recharges, FX entries, balances, and elimination records.
Review exceptions
See fully matched, partially matched, unmatched, and skipped records, then drill into transaction-level details.
Download or automate output
Download Excel reports or push matched, unmatched, exception, or summary data back to ERP, accounting, consolidation, BI, analytics, or internal systems.
Match structured intercompany records with rules and difficult exceptions with AI
Cointab applies structured matching first, then uses AI to help with difficult open transactions where references are missing, entity names differ, amounts are split, or records are spread across multiple reports.
Structured matching
Cointab can match intercompany records using:
Matching scenarios
One-to-one
One intercompany invoice in Entity A matches one payable entry in Entity B.
One-to-many
One intercompany invoice maps to multiple payments, tax entries, recharges, or allocation records.
Many-to-one
Multiple intercompany invoices or balances are settled through one payment or journal entry.
Many-to-many
Multiple invoices, payments, loans, advances, recharges, and adjustments are grouped and compared together.
Partial matching
Entity pair or reference matches, but the amount differs because of tax, FX, timing, allocation, or partial settlement.
Contra / elimination matching
Receivables, payables, loans, advances, recharges, credit notes, debit notes, and elimination entries are netted against each other.
AI-assisted transaction matching
After structured rules run, AI helps match difficult open transactions where:
- Entity names are written differently
- Invoice numbers are formatted differently
- References are missing, partial, or embedded in descriptions
- One payment settles many intercompany items
- Amounts differ because of FX or tax treatment
- Cost allocations are grouped differently across entities
- Loan and advance references are not consistent
- Journal descriptions contain unstructured text
- Opening balance items are carried forward from older periods
- Multiple possible matches exist across ledgers, invoices, payments, and recharges
AI exception analysis
For transactions that remain open, AI can help identify possible reasons such as:
AI assists reconciliation, but Cointab keeps the output transparent, reviewable, and audit-friendly.
Clear intercompany reconciliation reports your team can use
Cointab gives finance teams a complete report showing what matched, what partially matched, what remains unmatched, and what was skipped.
Report categories
Fully matched
Intercompany invoices, payments, balances, loans, advances, recharges, or elimination records where identifiers and amounts match.
Partially matched
Records where entity pair, reference, invoice, payment, or account details match, but the amount differs.
Unmatched in Entity A
Records present in Entity B or counterparty data but not found in Entity A's ledger or reports.
Unmatched in Entity B
Records present in Entity A but not found in Entity B's ledger or reports.
Skipped
Rows excluded because of missing, invalid, duplicate, incomplete, or unusable data.
Report capabilities
- Summary cards
- Entity-wise summary
- Entity-pair summary
- Account-wise summary
- Transaction-level tables
- Matched transaction detail view
- Filters for review
- Difference amounts
- Invoice-wise review
- Payment-wise review
- Due-to / due-from balance review
- FX difference review
- Elimination support
- Excel export
- Manual match
- Undo manual match
- Audit-ready output
- Open-item reason and action analysis
Automate recurring intercompany reconciliation
Once your intercompany reconciliation workflow is configured, Cointab can automate data input, reconciliation runs, and output delivery.
Bring data into Cointab
Receive or pull data through:
- Entity ledgers exported from ERP or accounting software
- Due-to and due-from reports received from group entities
- Intercompany invoice reports uploaded on schedule
- Payment reports pulled from treasury systems
- Loan and advance reports received from finance teams
- Recharge and allocation files pushed from internal systems
- FX rate files uploaded automatically
- Elimination reports received from consolidation tools
- Bank payment data added through API or file upload
Run reconciliation automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- Fully matched intercompany transactions
- Partially matched records
- Unmatched Entity A records
- Unmatched Entity B records
- Due-to / due-from differences
- Invoice differences
- Payment differences
- Loan and advance differences
- Recharge mismatches
- FX differences
- Tax differences
- Elimination support reports
- Exception reasons
- Suggested actions
- Excel reports
- Structured API output
Start faster with intercompany reconciliation templates
Use a ready-made intercompany reconciliation template where available, or create a custom workflow for your group entities, ERP exports, account structures, and reporting formats.
Entity A Ledger vs Entity B Ledger
Best for comparing transaction-level intercompany records between two related entities.
View templateDue To vs Due From Reconciliation
Best for matching intercompany receivable and payable balances across entity pairs.
View templateIntercompany Invoice Reconciliation
Best for matching invoices raised by one entity with payables recorded by another entity.
View templateIntercompany Payment Reconciliation
Best for matching payments, receipts, settlements, and bank references between group entities.
View templateERP / Books Reconciliation
Best for teams that want to compare ERP or accounting records with operational, banking, vendor, customer, or partner data.
Explore solutionIf a specific intercompany template is not available yet, users can still create a custom reconciliation using their own entity ledgers, due-to/due-from reports, invoice reports, payment reports, loan reports, recharge files, FX reports, elimination reports, and supporting data.
See an intercompany reconciliation report before signing up
Open a sample Intercompany Reconciliation report and see how Cointab presents matched, partially matched, unmatched, and skipped transactions.
Intercompany Reconciliation Demo
See how records between two entities are matched, and how due-to/due-from differences, invoice gaps, payment mismatches, timing differences, FX differences, and elimination issues are highlighted.
View demo reportBuilt for finance teams managing multi-entity reconciliation
Cointab is useful for teams that regularly reconcile transactions, balances, invoices, payments, loans, recharges, eliminations, and entity-level finance data.
Group finance teams
For teams preparing intercompany reconciliation before consolidation, reporting, close, and audit.
Controllers and CFO teams
For teams that need visibility into group-level balances, open items, entity differences, and elimination readiness.
Accounting teams
For teams matching ledgers, invoices, payments, journal entries, and balances across related entities.
Shared service centers
For centralized teams reconciling intercompany accounts across many companies, business units, regions, or cost centers.
Multi-entity businesses
For companies operating through subsidiaries, branches, group companies, or multiple legal entities.
Treasury teams
For teams tracking intercompany payments, settlements, loans, advances, and bank references.
Tax and compliance teams
For teams reviewing intercompany tax treatment, withholding, GST, VAT, transfer charges, and supporting records.
Accounting firms
For firms handling recurring intercompany reconciliation for clients with multiple entities or group structures.
Trusted by teams handling complex finance reconciliation
Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across entities, vendors, customers, payments, banks, marketplaces, partners, and internal systems.
“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”
Intercompany reconciliation FAQs
Start reconciling intercompany transactions faster
Use a ready-made intercompany reconciliation template, build a custom workflow, or schedule a guided setup with the Cointab team.
View live demo reportNo credit card required · Manual uploads and automated data flows supported