What is Intercompany Invoice Reconciliation?

Intercompany Invoice Reconciliation is the process of comparing invoices recorded between related entities to identify matched invoices, missing invoices, amount differences, tax differences, currency differences, timing differences, payment differences, Due To / Due From balance differences, and open items.

What files are required?

The main files are usually the intercompany invoice register, issuing entity ledger, and receiving entity ledger. Depending on the workflow, Due To / Due From ledgers, debit note registers, credit note registers, payment reports, journal reports, bank statements, tax reports, ERP exports, currency files, or supporting data may also be used.

Can Cointab identify invoices missing in one entity?

Yes. Cointab can show invoices that appear in the issuing entity but not the receiving entity, and invoices that appear in the receiving entity but not the issuing entity.

Can Cointab reconcile intercompany invoice amounts?

Yes. Gross invoice amounts, taxable values, tax amounts, net invoice amounts, debit values, credit values, open amounts, and paid amounts can be compared where data is available.

Can Cointab handle debit-credit reversal logic?

Yes. Cointab can compare invoice debits in one entity with corresponding invoice credits in the other entity, depending on the configured reconciliation logic.

Can Cointab reconcile debit notes and credit notes linked to invoices?

Yes. Debit notes, credit notes, reversals, corrections, recoveries, write-backs, and invoice-level adjustments can be matched and reviewed.

Can Cointab reconcile invoice payments?

Yes. Payments, receipts, partial payments, advances, net settlements, bank transfers, and clearing entries can be compared against intercompany invoices.

Can Cointab identify partially paid invoices?

Yes. Cointab can show invoices that are unpaid, partially paid, fully paid, overpaid, adjusted, reversed, or still open where payment data is available.

Can Cointab identify timing differences?

Yes. Invoices posted in different periods across entities can be identified separately from unresolved mismatches.

Can Cointab reconcile tax and withholding differences?

Yes. GST, VAT, service tax, TDS, withholding tax, input tax, output tax, taxable value, and tax reversals can be compared where data is available.

Can Cointab reconcile journals and manual adjustments?

Yes. Journal vouchers, accruals, provisions, reversals, reclassifications, eliminations, and manual adjustments can be compared where they affect invoice balances.

Can this page apply to branch invoices?

Yes. The same workflow can be used for head-office-to-branch, branch-to-branch, entity-to-branch, or branch-to-entity invoice reconciliation.

Can this page apply to related-party invoices?

Yes. Intercompany invoice reconciliation can support related-party invoices, group company invoices, parent-subsidiary invoices, branch invoices, and internal trading invoices.

Can I reuse this reconciliation every month or quarter?

Yes. Once this template is selected and the workflow is used, the same setup can be reused for monthly, quarterly, year-end, consolidation-period, audit-period, invoice-cycle, or custom reconciliation periods.

Can this run automatically?

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

What if my intercompany invoice and ledger reports have different formats?

Cointab validates uploaded files against the expected format. If the report formats are different, users can map fields, update the workflow, or create a custom reconciliation.

Can AI help with intercompany invoice reconciliation?

Yes. AI can help match difficult open records, review inconsistent narrations, analyze amount and tax differences, create derived identifiers, and suggest possible reasons and next actions.

Can I manually match intercompany invoice records?

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

Popular reconciliation template

Intercompany Invoice Reconciliation

Reconcile intercompany invoices across entities, branches, group companies, related parties, Due To / Due From ledgers, debit notes, credit notes, payments, journals, taxes, balances, and open items in one structured workflow.

Upload the intercompany invoice register, Entity A ledger, Entity B ledger, Due To / Due From ledgers, payment reports, journal reports, tax reports, and accounting data, select the period, run reconciliation, and review fully matched, partially matched, unmatched, timing-difference, tax-difference, balance-difference, and skipped records.

Start this reconciliation Schedule guided setup

View demo report

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

Intercompany Invoice Register

Entity A Ledger

Entity B Ledger

Due To / Due From Ledgers

ERP / Tax / Payment Data

Cointab Intercompany Invoice Reconciliation

MatchedPartially MatchedTiming DifferenceTax DifferenceBalance DifferenceUnmatchedSkipped

Reconcile intercompany invoices across entities and ledgers

Intercompany invoices should be recorded consistently across both the issuing entity and receiving entity. In practice, invoice numbers, posting dates, tax values, debit-credit treatment, payment status, journal adjustments, currency conversion, and ledger balances often differ across books.

The Intercompany Invoice Reconciliation template helps finance, accounting, shared services, controllership, consolidation, audit, and group finance teams compare intercompany invoice records with entity ledgers, Due To / Due From accounts, payments, debit notes, credit notes, journals, tax records, and accounting balances.

This helps teams answer questions such as:

Which intercompany invoices are recorded by both entities?
Which invoices are issued by one entity but missing in the other entity's books?
Which invoices are recorded in the receiving entity but missing from the issuing entity's records?
Which invoices have amount, tax, currency, exchange rate, or posting-date differences?
Which debit notes, credit notes, reversals, and adjustments are linked to each invoice?
Which invoices are unpaid, partially paid, overpaid, settled, reversed, or still open?
Which invoice differences are true mismatches and which are timing differences?
Which Due To and Due From balances are affected by invoice-level differences?
Which entries need entity follow-up, journal correction, tax review, payment follow-up, consolidation adjustment, or audit review?

This template is useful for multi-entity companies, group companies, holding-subsidiary structures, branches, shared service centers, finance teams, controllers, CFOs, auditors, tax teams, treasury teams, and accounting firms that need a repeatable intercompany invoice reconciliation process.

Required files for this template

Cointab's ready-made workflow is designed around intercompany invoice registers, sales ledgers, purchase ledgers, Due To / Due From ledgers, entity ledgers, debit note files, credit note files, payment reports, journal reports, tax reports, ERP exports, and supporting finance data.

Data source	Example records
Intercompany Invoice Register	Used as the invoice-side source containing invoice numbers, invoice dates, issuing entity, receiving entity, invoice amounts, tax values, taxable values, currency, exchange rate, document references, invoice status, and accounting status.
Issuing Entity Ledger	Used as the issuing entity's ledger containing intercompany receivables, invoice postings, debit amounts, credit amounts, balances, voucher numbers, journal entries, debit notes, credit notes, tax entries, payment receipts, and open items.
Receiving Entity Ledger	Used as the receiving entity's ledger containing intercompany payables, invoice postings, debit amounts, credit amounts, balances, voucher numbers, journal entries, debit notes, credit notes, tax entries, payment entries, and open items.
Due To / Due From Ledgers	Optional, but useful where intercompany invoices are posted into Due To and Due From accounts and need to be compared with the invoice register and entity ledgers.
Debit Note Register	Optional, but useful where intercompany debit notes, cost recoveries, additional charges, reallocations, corrections, or recharges need to be linked to invoices.
Credit Note Register	Optional, but useful where intercompany credit notes, reversals, write-backs, corrections, discounts, returns, or adjustments need to be linked to invoices.
Payment / Receipt Report	Optional, but useful where intercompany invoices are paid, partially paid, settled, adjusted, netted, or cleared through internal payments or bank transfers.
Journal Voucher Report	Optional, but useful where invoices are adjusted through manual journals, accruals, provisions, reversals, reclassifications, eliminations, or consolidation entries.
Bank Statement	Optional, but useful where intercompany invoice settlements need to be traced to actual bank debits, bank credits, UTRs, and bank references.
Tax / Withholding Report	Optional, but useful where GST, VAT, service tax, TDS, withholding tax, input tax, output tax, tax reversal, or other statutory values affect invoice matching.
Foreign Currency / Exchange Rate File	Optional, but useful where intercompany invoices are issued or posted in different currencies and exchange rate differences need to be analyzed.
ERP / Accounting Export	Optional, but useful if intercompany invoice records are maintained in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another ERP/accounting system.
Supporting Data	Optional supporting files can be used for entity mapping, branch mapping, related-party mapping, invoice mapping, document mapping, GL mapping, tax mapping, cost center mapping, currency mapping, project mapping, department mapping, or other enrichment.

What Cointab matches in intercompany invoice reconciliation

Cointab compares intercompany invoice records with both entities' ledgers, Due To / Due From accounts, debit notes, credit notes, payments, journals, taxes, currencies, and balances.

Intercompany invoices across entities

Match invoices issued by one entity with corresponding invoice postings in the receiving entity's ledger.

Invoice references

Compare invoice numbers, voucher numbers, ERP document numbers, sales invoice numbers, purchase invoice numbers, document references, journal references, and related-party references.

Entity and related-party details

Compare issuing entity, receiving entity, company code, branch code, related-party code, intercompany account code, customer/vendor code, and mapped party names.

Invoice amounts

Compare gross invoice amount, taxable value, tax amount, net amount, debit value, credit value, base currency amount, foreign currency amount, and balance impact.

Debit-credit treatment

Compare invoice debits in one entity with corresponding credits in the other entity, based on the configured intercompany logic.

Debit notes and credit notes

Match debit notes, credit notes, corrections, reversals, write-backs, recoveries, recharges, and invoice-level adjustments.

Payments and receipts

Compare invoice payments, receipts, partial payments, advance adjustments, net settlements, bank transfers, internal settlements, and clearing entries.

Journal entries

Compare manual journals, accruals, provisions, reversals, reclassifications, consolidation entries, and invoice-related adjustments.

Due To and Due From impact

Compare how intercompany invoices affect Due To balances, Due From balances, intercompany receivables, intercompany payables, and closing balances.

Dates and timing

Compare invoice date, document date, posting date, transaction date, payment date, bank date, settlement date, reversal date, and accounting period.

Currency and exchange differences

Compare transaction currency, base currency, exchange rate, converted amount, exchange gain/loss, revaluation amount, and rounding difference.

Taxes and statutory values

Compare GST, VAT, service tax, TDS, withholding tax, input tax, output tax, taxable value, tax reversal, tax collected, and tax deducted.

Accounting classifications

Compare GL account, ledger account, cost center, branch, project code, department, business unit, narration, and accounting treatment.

Common intercompany invoice reconciliation exceptions

Cointab helps finance teams focus on invoice-level differences instead of manually reviewing every intercompany invoice, ledger entry, debit note, credit note, payment, journal, tax entry, and balance movement.

Invoice in issuing entity not found in receiving entity

An intercompany invoice appears in the issuing entity's records but no matching entry is found in the receiving entity's ledger.

Invoice in receiving entity not found in issuing entity

An intercompany invoice appears in the receiving entity's records but no matching invoice is found in the issuing entity's records.

Invoice amount mismatch

The invoice reference matches, but gross invoice amount, taxable value, tax amount, or net amount differs.

Debit-credit mismatch

The invoice is posted as debit/credit incorrectly or does not mirror correctly across both entities.

Tax mismatch

GST, VAT, service tax, TDS, withholding tax, input tax, output tax, taxable value, or tax reversal differs across records.

Currency mismatch

Transaction currency, exchange rate, converted amount, base currency amount, revaluation amount, or exchange gain/loss differs.

Timing difference

The invoice is posted in one entity during the selected period but appears in the other entity in a later or earlier period.

Duplicate invoice

The same invoice number, ERP document number, voucher number, or document reference appears more than once.

Missing invoice reference

Invoice number, document number, voucher number, entity code, related-party reference, or narration is missing or incomplete.

Debit note mismatch

A debit note linked to an invoice is recorded in one entity but missing, duplicated, or recorded differently in the other entity.

Credit note mismatch

A credit note linked to an invoice is recorded in one entity but missing, duplicated, or recorded differently in the other entity.

Payment mismatch

A payment or receipt linked to an intercompany invoice is missing, partially matched, duplicated, or recorded with a different amount.

Partial payment mismatch

The invoice is partially paid in one entity but shown as unpaid, fully paid, or differently settled in the other entity.

Advance adjustment mismatch

An advance, prepayment, or intercompany funding entry is adjusted against the invoice in one entity but not in the other.

Journal adjustment mismatch

A manual journal, accrual, reversal, reclassification, or consolidation entry affects the invoice differently across entities.

Due To / Due From balance mismatch

Invoice-level entries do not correctly flow into Due To, Due From, receivable, payable, or related-party balances.

Wrong entity allocation

The invoice is mapped to the wrong entity, branch, related party, company code, department, project, or business unit.

Wrong GL or cost center allocation

The invoice is posted to the wrong GL account, ledger account, cost center, project, department, or classification.

Rounding difference

Small differences exist because of decimal rounding, tax rounding, currency conversion, or system-level rounding.

Skipped record

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

How this ready-made reconciliation works

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

Select the template

Choose Intercompany Invoice Reconciliation from popular reconciliations.

Select the period

Choose the month, quarter, financial year, consolidation period, audit period, close period, invoice cycle, lifetime period, or custom period you want to reconcile.

Upload invoice and ledger reports

Upload the intercompany invoice register, issuing entity ledger, receiving entity ledger, and any required Due To / Due From ledger, debit note register, credit note register, journal report, payment report, bank statement, tax report, currency file, ERP export, or supporting data.

Validate file format

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

Run reconciliation

Cointab applies predefined data preparation and matching logic for invoice references, entity mappings, debit-credit values, tax values, debit notes, credit notes, payments, journals, currencies, balances, and accounting classifications.

Review output

View fully matched, partially matched, unmatched, timing-difference, tax-difference, currency-difference, balance-difference, duplicate, 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 records where fixed rules are not enough.

Structured matching

Structured matching can use:

Invoice numberSales invoice numberPurchase invoice numberVoucher numberDocument numberERP document numberDebit note numberCredit note numberJournal voucher numberPayment referenceReceipt referenceBank referenceUTRTransaction IDIssuing entity codeReceiving entity codeCompany codeBranch codeRelated-party codeIntercompany account codeCustomer codeVendor codeGL accountLedger accountCost centerProject codeDepartmentBusiness unitDocument typeTransaction typeInvoice statusPayment statusClearing statusApproval statusReversal statusNarrationDescriptionGross invoice amountTaxable valueTax amountNet invoice amountDebit amountCredit amountOpen amountPaid amountAdjusted amountDebit note amountCredit note amountJournal adjustment amountOpening balancePeriod movementClosing balanceGST amountVAT amountService tax amountTDS amountWithholding tax amountInput tax amountOutput tax amountTax reversal amountBase currency amountForeign currency amountExchange rateExchange gain/loss amountRevaluation amountRounding differenceInvoice dateDocument datePosting dateTransaction datePayment dateBank dateSettlement dateReversal dateAccounting periodDerived or cleaned identifiers

Matching scenarios

One-to-one
One intercompany invoice in the issuing entity matches one corresponding invoice entry in the receiving entity.
One-to-many
One invoice maps to multiple ledger entries, such as invoice base amount plus tax lines, invoice plus debit note, invoice plus journal adjustment, or invoice plus multiple payments.
Many-to-one
Multiple intercompany invoices are grouped and matched against one payment, settlement, journal entry, or clearing entry.
Many-to-many
Multiple invoices, debit notes, credit notes, payments, journals, tax lines, advances, and settlement entries across both entities are grouped and compared together.
Partial matching
References match, but invoice amount, tax value, currency value, payment value, posting date, GL account, or status differs.
Debit-credit matching
Invoice debits in one entity are compared with corresponding invoice credits in the other entity.
Invoice-to-ledger matching
Invoice register records are matched against ledger postings in both entities.
Invoice-to-Due-To-Due-From matching
Invoice records are compared with Due To and Due From account movements and balances.
Tax-level matching
Taxable values, GST, VAT, withholding, deductions, reversals, input tax, output tax, and statutory fields are compared where available.
Currency matching
Foreign currency amount, base currency amount, exchange rate, revaluation amount, and exchange differences are compared where applicable.
Balance-level matching
Invoice-level open amounts, cleared amounts, adjusted amounts, and closing balances are compared.
Net and contra matching
Invoices, payments, debit notes, credit notes, advances, recoveries, journal adjustments, reversals, write-backs, tax entries, and balances are netted where required.

AI-assisted transaction matching

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

Invoice numbers are missing or formatted differently
Voucher numbers differ across entities
Entity names are abbreviated or spelled differently
Related-party names do not match exactly
Narrations are inconsistent
One ledger uses debit/credit signs differently
Tax and base invoice values are posted separately
One invoice is split into multiple ledger lines
Multiple invoices are settled through one payment
Debit notes or credit notes are not clearly linked to invoices
Journal adjustments use unclear descriptions
Currency conversion creates differences
Bank references are missing
Amounts require business interpretation
Multiple possible matches exist

AI exception analysis

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

Invoice missing in receiving entityInvoice missing in issuing entityInvoice amount mismatchDebit-credit mismatchTax mismatchCurrency mismatchTiming differenceDuplicate invoiceMissing invoice referenceDebit note mismatchCredit note mismatchPayment mismatchPartial payment mismatchAdvance adjustment mismatchJournal adjustment mismatchDue To / Due From balance mismatchWrong entity allocationWrong branch allocationWrong GL allocationWrong cost center allocationPosting period differenceInternal ERP issueIntercompany posting issueUnclear reference

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

Audit-ready intercompany invoice reconciliation reports

Cointab gives your team a clear report showing which intercompany invoices matched, partially matched, remained unmatched, were timing differences, had tax differences, had currency differences, affected balances, or were skipped.

Report categories

Fully matched
Invoices where issuing entity, receiving entity, references, debit-credit values, amounts, tax values, dates, and status match.
Partially matched
Records where references match but invoice amount, tax value, currency value, payment value, GL account, date, or posting status differs.
Unmatched in issuing entity
Invoices or ledger records in the receiving entity that do not clearly match the issuing entity's records.
Unmatched in receiving entity
Invoices or ledger records in the issuing entity that do not clearly match the receiving entity's records.
Invoice amount differences
Records where gross invoice amount, taxable value, tax amount, net invoice amount, debit value, credit value, or open amount differs.
Debit-credit differences
Records where debit and credit treatment does not align across both entities.
Tax differences
Records where GST, VAT, service tax, TDS, withholding, taxable value, input tax, output tax, or tax reversal requires review.
Currency and exchange differences
Records where foreign currency, exchange rate, converted amount, revaluation amount, exchange gain/loss, or rounding requires review.
Timing differences
Invoices posted in different accounting periods across entities.
Debit note and credit note differences
Debit notes, credit notes, reversals, corrections, write-backs, and adjustment entries requiring review.
Payment and receipt differences
Payments, receipts, partial payments, settlements, advances, and clearing entries requiring review.
Journal adjustment differences
Manual journals, accruals, reversals, reclassifications, eliminations, and consolidation adjustments requiring review.
Due To / Due From differences
Records where invoice-level differences affect Due To balances, Due From balances, intercompany receivables, or intercompany payables.
Accounting classification differences
Wrong entity, branch, GL account, cost center, department, project, related party, or business unit allocation.
Skipped
Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

Summary cards
Invoice-level filters
Entity-level filters
Related-party filters
Branch-level filters
GL-level filters
Cost center filters
Project filters
Debit note filters
Credit note filters
Payment filters
Journal filters
Tax filters
Currency filters
Difference amounts
Balance view
Open-item view
Timing-difference view
Matched transaction drill-down
Manual match
Undo manual match
Excel export
Audit-friendly output

Automate recurring intercompany invoice 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, where available

Run automatically

Schedule reconciliation:

MonthlyQuarterlyAt month-end closeAt quarter-end closeAt year-end closeBefore consolidationBefore auditAfter intercompany invoice register exportAfter ERP ledger exportAfter debit note register exportAfter credit note register exportAfter payment report exportAfter journal report exportAfter all required files are availableAt a custom frequency

Push output back

Send reconciliation output to:

ERPAccounting systemConsolidation systemFinance operations dashboardShared services dashboardIntercompany close dashboardControllership dashboardTax dashboardTreasury dashboardBI dashboardInternal finance systemAnalytics databaseData warehouseInternal exception trackerEntity follow-up workflowIntercompany adjustment workflowJournal correction workflowPayment follow-up workflowClose management workflowAudit or compliance system

Matched intercompany invoices
Matched invoice ledger entries
Matched debit notes
Matched credit notes
Matched payments
Matched journals
Unmatched issuing entity records
Unmatched receiving entity records
Invoice amount differences
Debit-credit differences
Tax differences
Currency differences
Timing differences
Due To / Due From balance differences
Duplicate invoices
Wrong entity allocation records
Wrong GL allocation records
Open items
Suggested actions
Excel reconciliation report
Structured API output

View an intercompany invoice reconciliation demo report

See how Cointab presents intercompany invoice reconciliation output with matched, partially matched, unmatched, timing-difference, tax-difference, currency-difference, balance-difference, and skipped records.

Intercompany Invoice Reconciliation Demo

Explore a sample report showing intercompany invoices, entity ledgers, Due To / Due From impact, debit notes, credit notes, payments, journals, tax differences, timing differences, currency differences, and open items.

View demo report

Explore related intercompany invoice and ledger reconciliations

Cointab supports other intercompany, entity, books, ledger, bank, vendor, customer, ERP, and finance reconciliation workflows.

Due To vs Due From Reconciliation

Reconcile payable-side and receivable-side intercompany balances across entities, branches, ledgers, invoices, payments, journals, and open items.

View template

Entity A Ledger vs Entity B Ledger

Reconcile one entity's ledger with another entity's ledger across intercompany invoices, payments, debit notes, credit notes, journals, balances, and open items.

View template

Intercompany Reconciliation

Reconcile intercompany transactions, invoices, debit notes, credit notes, payments, journals, and balances across entities.

View template

Books Reconciliation

Reconcile accounting books across ledgers, reports, ERP exports, bank records, invoices, payments, and open items.

View template

Bank Statement vs Books

Compare bank statement entries with accounting or books records.

View template

ERP / Books Reconciliation

Reconcile ERP exports and accounting books across transactions, ledgers, journals, bank entries, invoices, and balances.

View template

Built for teams reconciling intercompany invoices

This template is useful for teams that regularly reconcile intercompany invoices, related-party invoices, Due To / Due From balances, debit notes, credit notes, payments, journals, taxes, currencies, and open items.

Group companies

For groups reconciling invoices between parent, subsidiary, associate, branch, or related-party entities.

Holding and subsidiary structures

For teams comparing intercompany invoices, receivables, payables, recharges, management fees, recoveries, and closing balances.

Multi-entity businesses

For finance teams handling invoice reconciliation across multiple legal entities, branches, regions, cost centers, departments, or business units.

Shared service centers

For shared service teams preparing recurring intercompany invoice reconciliation reports for monthly close, consolidation, and audit.

Finance teams

For teams reconciling invoice-level intercompany balances during month-end, quarter-end, year-end, consolidation, and audit.

Accounting teams

For teams matching intercompany invoices, ledger postings, payments, journals, debit notes, credit notes, tax entries, and balance movements.

Controllers

For controllers who need visibility into invoice-level open items, timing differences, balance mismatches, tax differences, and posting issues.

CFOs

For finance leaders who want stronger control over intercompany balances, group reporting, consolidation readiness, audit readiness, and financial close accuracy.

Treasury teams

For teams reviewing intercompany invoice settlements, advances, repayments, netting, funding transfers, and bank movements.

Tax teams

For teams reviewing intercompany tax values, withholding, GST, VAT, input tax, output tax, related-party entries, and statutory deductions.

Auditors

For audit teams reviewing intercompany invoices, related-party confirmations, balance support, open items, and transaction trails.

Accounting firms

For CA, CPA, or outsourced accounting teams handling intercompany invoices, multi-entity books, branch accounts, related-party ledgers, Due To / Due From balances, and finance reconciliation for multiple clients.

Trusted by teams handling intercompany invoice reconciliation

Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across entities, intercompany invoices, Due To accounts, Due From accounts, ERP systems, banks, ledgers, payments, journals, books, 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 Invoice Reconciliation FAQs

Start Intercompany Invoice Reconciliation

Use Cointab's ready-made intercompany invoice reconciliation workflow to match invoices, debit notes, credit notes, payments, journals, taxes, Due To / Due From balances, currency 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 Invoice Reconciliation

View demo report

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

Data source

Example records

Intercompany Invoice Register

Used as the invoice-side source containing invoice numbers, invoice dates, issuing entity, receiving entity, invoice amounts, tax values, taxable values, currency, exchange rate, document references, invoice status, and accounting status.

Issuing Entity Ledger

Used as the issuing entity's ledger containing intercompany receivables, invoice postings, debit amounts, credit amounts, balances, voucher numbers, journal entries, debit notes, credit notes, tax entries, payment receipts, and open items.

Receiving Entity Ledger

Used as the receiving entity's ledger containing intercompany payables, invoice postings, debit amounts, credit amounts, balances, voucher numbers, journal entries, debit notes, credit notes, tax entries, payment entries, and open items.

Due To / Due From Ledgers

Optional, but useful where intercompany invoices are posted into Due To and Due From accounts and need to be compared with the invoice register and entity ledgers.

Debit Note Register

Optional, but useful where intercompany debit notes, cost recoveries, additional charges, reallocations, corrections, or recharges need to be linked to invoices.

Credit Note Register

Optional, but useful where intercompany credit notes, reversals, write-backs, corrections, discounts, returns, or adjustments need to be linked to invoices.

Payment / Receipt Report

Optional, but useful where intercompany invoices are paid, partially paid, settled, adjusted, netted, or cleared through internal payments or bank transfers.

Journal Voucher Report

Optional, but useful where invoices are adjusted through manual journals, accruals, provisions, reversals, reclassifications, eliminations, or consolidation entries.

Bank Statement

Optional, but useful where intercompany invoice settlements need to be traced to actual bank debits, bank credits, UTRs, and bank references.

Tax / Withholding Report

Optional, but useful where GST, VAT, service tax, TDS, withholding tax, input tax, output tax, tax reversal, or other statutory values affect invoice matching.

Foreign Currency / Exchange Rate File

Optional, but useful where intercompany invoices are issued or posted in different currencies and exchange rate differences need to be analyzed.

ERP / Accounting Export

Optional, but useful if intercompany invoice records are maintained in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another ERP/accounting system.

Supporting Data

Optional supporting files can be used for entity mapping, branch mapping, related-party mapping, invoice mapping, document mapping, GL mapping, tax mapping, cost center mapping, currency mapping, project mapping, department mapping, or other enrichment.

Start Intercompany Invoice Reconciliation

View demo report

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