What is intercompany payment reconciliation?

It is the process of comparing transactions, balances, receivables, payables, payments, and settlements recorded by related entities to ensure both sides agree.

What files are required?

Typically, reports from both entities containing receivables, payables, balances, payments, settlements, or ledger data.

Can Cointab reconcile intercompany balances?

Yes. Cointab can compare outstanding balances, identify differences, and highlight transactions causing the variance.

Can Cointab reconcile payments between entities?

Yes. Intercompany payments, transfers, and settlements can be matched against corresponding records maintained by related entities.

Can I reuse this reconciliation every month?

Yes. Once this template is selected and the workflow is used, the same setup can be reused for future periods.

Can this run automatically?

Yes. Cointab can receive or pull required reports through email, SFTP, or APIs, run reconciliation automatically, and push output back to downstream systems.

What if our entities use different report formats?

Cointab validates uploaded files against the expected format. If formats differ significantly, users can adjust the workflow or create a custom reconciliation.

Can AI help with intercompany reconciliation?

Yes. AI can help review difficult open transactions, analyze differences, suggest possible reasons, and recommend next actions.

Can I manually match transactions?

Yes. Users can manually match transactions that the system and AI could not confidently match and undo manual matches if needed.

Can I download the reconciliation report?

Yes. Users can download Excel reports with fully matched, partially matched, unmatched, skipped, and transaction-level details.

Popular reconciliation template

Intercompany Payment Reconciliation

Reconcile intercompany payments, receivables, payables, transfers, settlements, and balances across entities to identify differences and maintain accurate group financial records.

Upload the required reports from both entities, select the period, run reconciliation, and review fully matched, partially matched, unmatched, and skipped records.

Start this reconciliation Schedule guided setup

View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Entity A Receivable Report

Entity A Payment Report

Entity B Payable Report

Entity B Payment Report

Cointab Intercompany Reconciliation

MatchedPartially MatchedUnmatchedSkipped

Reconcile transactions between group entities

Intercompany transactions often exist in multiple systems, books, or ledgers. Cointab helps finance teams reconcile records between related entities in a structured workflow.

The Intercompany Payment Reconciliation template helps organizations compare transactions recorded by one group entity against corresponding records maintained by another entity.

This helps finance teams answer questions such as:

Which intercompany payments have been recorded by both entities?
Which receivables remain unpaid?
Which payables have not been reflected correctly?
Which transfers are missing on one side?
Which transactions have amount differences?
Which balances do not agree between entities?
Which entries require follow-up or adjustment?
Which records are present in one entity but not the other?

This template is useful for finance teams managing multiple subsidiaries, business units, legal entities, branches, or group companies that require recurring intercompany reconciliation.

Required files for this template

Cointab's ready-made workflow is designed around common intercompany reconciliation reports maintained by finance teams.

Data source	Example records
Entity A Receivable or Payable Report	Used as the source record maintained by one entity for intercompany balances and transactions.
Entity B Receivable or Payable Report	Used as the corresponding record maintained by the related entity.
Intercompany Payment Report	Used to reconcile actual payments, settlements, transfers, and adjustments.
General Ledger or ERP Export	Optional, but useful when validating intercompany entries recorded in accounting systems.
Supporting Data	Optional supporting files can be used for entity mapping, transaction classifications, account mapping, approval references, or other enrichment.

What Cointab matches in intercompany reconciliation

Cointab compares transactions, balances, settlements, transfers, and accounting records across group entities.

Intercompany receivables and payables

Match transactions recorded by one entity against corresponding transactions recorded by another.

Payments and settlements

Verify that intercompany payments are reflected correctly across both entities.

Transfers and fund movements

Track transfers between entities and identify missing or incomplete records.

Balance confirmations

Compare opening balances, closing balances, and outstanding amounts.

Journal entries and adjustments

Review intercompany accounting entries, corrections, and manual adjustments.

Internal ERP records, if added

If ERP or accounting exports are included, Cointab can compare ledger entries alongside operational records.

Common intercompany reconciliation exceptions

Cointab helps finance teams focus on differences instead of manually reviewing every intercompany transaction.

Transaction missing on one side

A transaction exists in one entity's records but is not found in the corresponding entity's report.

Payment not reflected

A payment has been recorded by one entity but is missing from the other entity's books.

Amount mismatch

The transaction reference matches, but the recorded amounts differ.

Balance mismatch

The outstanding balance maintained by one entity differs from the balance maintained by the other entity.

Timing difference

A transaction is recorded in one period by one entity and a different period by the other.

Duplicate entry

The same transaction appears multiple times in one or both reports.

Missing or unclear reference

Transaction IDs, invoice numbers, journal references, or settlement references are incomplete or missing.

Adjustment difference

Manual journals, corrections, write-offs, or adjustments have not been reflected consistently.

Skipped record

A row cannot be reconciled because required data is missing, invalid, duplicate, or unusable.

How this ready-made reconciliation works

Cointab pre-configures the workflow so your team does not need to rebuild the intercompany reconciliation setup every period.

Select the template

Choose Intercompany Payment Reconciliation from popular reconciliations.

Select the period

Choose the month, quarter, year, lifetime period, or custom period you want to reconcile.

Upload intercompany reports

Upload reports from the participating entities along with any payment, settlement, or supporting files.

Validate file format

Cointab checks whether uploaded files match the expected structure and highlights missing or incorrect columns.

Run reconciliation

Cointab applies predefined data preparation and matching logic for intercompany transactions.

Review output

View fully matched, partially matched, unmatched, and skipped records.

Download or automate

Download the Excel report, or automate future data input and output through email, SFTP, or APIs.

Structured matching first, AI assistance for difficult cases

Cointab applies structured reconciliation logic first, then uses AI to help with difficult open transactions where fixed rules are not enough.

Structured matching

Structured matching can use:

Invoice numberJournal referenceTransaction IDPayment referenceSettlement referenceEntity codeAmount fieldsDate fieldsAccount referencesDerived or cleaned identifiers

Matching scenarios

One-to-one
One transaction recorded by one entity matches one transaction recorded by another.
One-to-many
One transaction corresponds to multiple settlement or adjustment entries.
Many-to-one
Multiple transactions are grouped into a single settlement or journal entry.
Many-to-many
Multiple records across both entities are grouped and compared.
Partial matching
Identifiers match, but amounts differ.
Net and contra matching
Payments, credits, adjustments, and reversals are netted where required.

AI-assisted transaction matching

After structured rules run, AI helps match difficult open transactions where:

References are incomplete
Descriptions are inconsistent
Transactions are recorded differently across entities
Manual journals affect matching
Settlement information is fragmented
Multiple possible matches exist

AI exception analysis

For transactions that remain open, AI can help identify possible reasons such as:

Timing differenceMissing reportPayment not postedJournal adjustmentBalance carry-forward issueDuplicate entryInternal accounting issueEntity mapping issueManual correction required

AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.

Audit-ready intercompany reconciliation reports

Cointab gives your team a clear report showing which transactions matched, partially matched, remained unmatched, or were skipped.

Report categories

Fully matched
Transactions where references and amounts match across entities.
Partially matched
Transactions where references match but amounts differ.
Unmatched in Entity A
Records present in Entity A but not found in Entity B.
Unmatched in Entity B
Records present in Entity B but not found in Entity A.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

Summary cards
Transaction-level details
Filters for review
Difference amounts
Matched transaction drill-down
Manual match
Undo manual match
Excel export
Audit-friendly output

Automate recurring intercompany reconciliation

Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.

Bring data into Cointab

Data can be received or pulled through:

EmailSFTPAPI integrations

Run automatically

Schedule reconciliation:

MonthlyWeeklyDailyAfter file receiptAfter all required files are availableAt a custom frequency

Push output back

Send reconciliation output to:

ERPAccounting systemBI dashboardInternal finance systemAnalytics databaseData warehouseInternal exception tracker

Matched intercompany transactions
Outstanding receivables
Outstanding payables
Balance differences
Unmatched records
Open items
Suggested actions
Excel reconciliation report
Structured API output

View an intercompany reconciliation demo report

See how Cointab presents intercompany reconciliation output with matched, partially matched, unmatched, and skipped transactions.

Intercompany Payment Reconciliation Demo

Explore a sample report showing intercompany transactions, payments, balances, adjustments, and open items.

View demo report

Explore related reconciliation workflows

Cointab supports other finance and accounting reconciliation workflows.

Bank Statement vs Books

Compare bank statement entries with accounting or ERP records.

View template

Vendor Ledger vs Vendor Statement

Reconcile vendor balances, invoices, payments, and adjustments.

View template

Customer Ledger vs Customer Statement

Match customer balances, payments, and credit notes.

View template

Bank Statement vs Payment Register

Reconcile outgoing payments against bank statement records.

View template

Built for finance teams managing multiple entities

This template is useful for organizations that regularly reconcile transactions between subsidiaries, business units, branches, or group companies.

Corporate finance teams

For organizations managing intercompany transactions across multiple entities.

Shared service centers

For teams responsible for centralized accounting and reconciliation processes.

Multi-entity businesses

For businesses operating multiple legal entities or subsidiaries.

Controllers and accounting teams

For teams preparing month-end close and balance confirmations.

Outsourced finance teams

For accounting firms managing intercompany reconciliation for clients.

Trusted by teams handling recurring financial reconciliations

Cointab is used by finance and operations teams that reconcile high-volume, multi-source financial and operational data across entities, partners, banks, marketplaces, 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.”
— Urbanic

Intercompany Payment Reconciliation FAQs

Start intercompany payment reconciliation

Use Cointab's ready-made intercompany reconciliation workflow to match transactions, identify differences, review exceptions, and export audit-ready reports.

Start this reconciliation Schedule guided setup

View demo report

Ready-made workflow · Reusable every period · Manual upload and automation supported

Intercompany Payment Reconciliation

Reconcile intercompany payments, receivables, payables, transfers, settlements, and balances across entities to identify differences and maintain accurate group financial records.

Upload the required reports from both entities, select the period, run reconciliation, and review fully matched, partially matched, unmatched, and skipped records.

View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Data source

Example records

Entity A Receivable or Payable Report

Used as the source record maintained by one entity for intercompany balances and transactions.

Entity B Receivable or Payable Report

Used as the corresponding record maintained by the related entity.

Intercompany Payment Report

Used to reconcile actual payments, settlements, transfers, and adjustments.

General Ledger or ERP Export

Optional, but useful when validating intercompany entries recorded in accounting systems.

Supporting Data

Optional supporting files can be used for entity mapping, transaction classifications, account mapping, approval references, or other enrichment.

Start intercompany payment reconciliation

Use Cointab's ready-made intercompany reconciliation workflow to match transactions, identify differences, review exceptions, and export audit-ready reports.

View demo report

Ready-made workflow · Reusable every period · Manual upload and automation supported