CointabCointab
Product
Solutions
Popular reconciliations
PricingResources
Schedule guided setupLogin
Start free

Popular reconciliation template

Entity A Ledger vs Entity B Ledger Reconciliation

Reconcile one entity's ledger with another entity's ledger to match intercompany invoices, payments, debit notes, credit notes, journals, advances, recoveries, balances, and open items in one structured workflow.

Upload Entity A ledger and Entity B ledger, select the reconciliation period, run matching, and review fully matched, partially matched, unmatched, timing-difference, balance-difference, and skipped records.

Start this reconciliationSchedule guided setup
View demo report

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

Entity A Ledger
Entity B Ledger
Intercompany Supporting Data
ERP / Accounting Data

Cointab Entity Ledger Reconciliation

MatchedPartially MatchedTiming DifferenceBalance DifferenceUnmatchedSkipped

Reconcile ledger balances between two entities

When two related entities record transactions with each other, the same transaction may appear differently in each entity's books due to posting timing, invoice references, debit notes, credit notes, payments, taxes, exchange rates, or accounting treatment. Cointab helps finance teams compare both ledgers and identify clear open items.

The Entity A Ledger vs Entity B Ledger Reconciliation template helps finance, accounting, controllership, audit, shared services, and group finance teams compare one entity's ledger with another entity's ledger.

This helps teams answer questions such as:

  • Which intercompany transactions are recorded in both entities?
  • Which entries appear in Entity A ledger but are missing from Entity B ledger?
  • Which entries appear in Entity B ledger but are missing from Entity A ledger?
  • Which invoices, debit notes, credit notes, payments, advances, recoveries, and journal entries match correctly?
  • Which amounts differ because of tax, exchange rate, withholding, rounding, bank charges, currency conversion, or accounting treatment?
  • Which transactions are timing differences and which are real unresolved differences?
  • Which intercompany balances agree at period-end?
  • Which balances need adjustment, posting correction, entity follow-up, approval, or audit review?
  • Which items should be cleared, written back, reclassified, or carried forward?

This template is useful for companies with multiple entities, group companies, holding-subsidiary structures, branches, shared service centers, finance teams, controllers, CFOs, auditors, and accounting firms that need a repeatable entity-ledger reconciliation process.

Required files for this template

Cointab's ready-made workflow is designed around common entity ledgers, intercompany ledgers, branch ledgers, group company ledgers, related-party ledgers, ERP exports, bank statements, journal reports, invoice reports, debit note files, credit note files, and supporting finance data.

Data sourceExample records
Entity A LedgerUsed as the first entity-side source containing voucher numbers, transaction dates, posting dates, document numbers, party names, descriptions, debit amounts, credit amounts, balances, currencies, tax values, references, and accounting status.
Entity B LedgerUsed as the second entity-side source containing corresponding intercompany entries, invoices, payments, debit notes, credit notes, journal postings, advances, recoveries, balances, currencies, references, and accounting status.
Intercompany Invoice RegisterOptional, but useful where invoice numbers, invoice dates, tax values, entity names, invoice amounts, and posting references need to be compared with ledger entries.
Debit Note / Credit Note RegisterOptional, but useful where intercompany debit notes, credit notes, recoveries, reversals, adjustments, and recharges need to be matched across both entities.
Journal Voucher ReportOptional, but useful where intercompany journal entries, accruals, reversals, provisions, reclassifications, and manual adjustments need review.
Payment / Receipt ReportOptional, but useful where payments, receipts, advances, bank transfers, settlements, and clearing entries need to be compared.
Bank StatementOptional, but useful where intercompany payments or receipts need to be traced to actual bank transactions.
Foreign Currency / Exchange Rate FileOptional, but useful where entity ledgers are maintained in different currencies or where exchange gain/loss differences need to be analyzed.
Tax / Withholding ReportOptional, but useful where GST, VAT, TDS, withholding tax, service tax, tax reversal, input/output tax, or other statutory values affect intercompany balances.
ERP / Accounting ExportOptional, but useful if both entities maintain records in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another accounting system.
Supporting DataOptional supporting files can be used for entity mapping, branch mapping, cost center mapping, GL mapping, document mapping, currency mapping, invoice mapping, tax mapping, vendor/customer mapping, or other enrichment.

What Cointab matches in Entity A Ledger vs Entity B Ledger reconciliation

Cointab compares both entity ledgers across transaction references, document numbers, debit-credit values, dates, balances, currencies, taxes, journals, payments, and open items.

Entity A entries and Entity B entries

Match ledger entries recorded in Entity A with corresponding ledger entries recorded in Entity B.

Document references

Compare invoice numbers, voucher numbers, journal numbers, debit note numbers, credit note numbers, payment references, receipt references, bank references, and ERP document numbers.

Debit and credit values

Compare debit amounts in one ledger with corresponding credit amounts in the other ledger, and vice versa.

Intercompany invoices

Match intercompany sales invoices, service invoices, recharge invoices, expense allocations, management fees, cost allocations, and transfer entries.

Debit notes and credit notes

Compare debit notes, credit notes, reversals, corrections, recoveries, write-backs, and intercompany adjustments.

Payments and receipts

Match payments recorded by one entity with receipts recorded by the other entity, including bank transfers, advances, settlements, and clearing entries.

Journal entries

Compare journal vouchers, accruals, provisions, reversals, reclassifications, manual adjustments, and consolidation entries.

Balances

Compare opening balances, period movements, closing balances, entity-wise balances, GL-wise balances, branch-wise balances, and currency-wise balances.

Dates and timing

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

Currency and exchange differences

Compare transaction currency, base currency, exchange rate, converted amount, exchange gain/loss, and currency revaluation differences where available.

Taxes and statutory values

Compare GST, VAT, service tax, TDS, withholding tax, tax reversal, input tax, output tax, and statutory deductions where applicable.

Accounting classifications

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

Common Entity A Ledger vs Entity B Ledger reconciliation exceptions

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

Entry in Entity A not found in Entity B

A transaction appears in Entity A ledger but no matching entry is found in Entity B ledger.

Entry in Entity B not found in Entity A

A transaction appears in Entity B ledger but no matching entry is found in Entity A ledger.

Debit-credit mismatch

A debit entry in one ledger does not match the corresponding credit entry in the other ledger.

Amount mismatch

Document references match, but transaction amounts differ.

Balance mismatch

Opening balance, period movement, or closing balance does not agree between Entity A and Entity B.

Invoice mismatch

An intercompany invoice exists in one entity but is missing, duplicated, or recorded differently in the other entity.

Debit note mismatch

A debit note is recorded by one entity but missing or incorrectly recorded by the other entity.

Credit note mismatch

A credit note is recorded by one entity but missing or incorrectly recorded by the other entity.

Payment mismatch

A payment recorded by one entity does not match the receipt recorded by the other entity.

Advance mismatch

An advance, prepayment, or intercompany funding entry is recorded differently across entities.

Journal mismatch

A manual journal, accrual, reversal, or reclassification exists in one ledger but not in the other.

Timing difference

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

Tax mismatch

GST, VAT, TDS, withholding tax, tax reversal, or statutory deduction differs across both ledgers.

Currency mismatch

Transaction currency, exchange rate, converted amount, or exchange gain/loss differs between both entities.

Rounding difference

Small differences exist due to decimal rounding, currency conversion, or system-level rounding.

Duplicate entry

The same invoice, payment, journal, debit note, credit note, or voucher appears more than once.

Wrong entity or GL allocation

A transaction is mapped to the wrong entity, branch, GL account, cost center, project, department, or business unit.

Narration mismatch

Both entries may relate to the same transaction, but descriptions or narrations are inconsistent.

Missing or unclear reference

Invoice number, voucher number, journal number, payment reference, entity code, bank reference, or narration is missing, incomplete, or inconsistent.

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 entity-to-entity ledger reconciliation every period.

01

Select the template

Choose Entity A Ledger vs Entity B Ledger from popular reconciliations.

02

Select the period

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

03

Upload both entity ledgers

Upload Entity A ledger, Entity B ledger, and any required invoice register, debit note register, credit note register, journal report, payment report, bank statement, tax report, ERP export, currency file, or supporting data.

04

Validate file format

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

05

Run reconciliation

Cointab applies predefined data preparation and matching logic for document references, debit-credit values, invoices, payments, journals, debit notes, credit notes, taxes, currencies, and balances.

06

Review output

View fully matched, partially matched, unmatched, timing-difference, balance-difference, duplicate, and skipped records.

07

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:

Entity A codeEntity B codeCompany codeBranch codeGL accountLedger accountCost centerProject codeDepartmentBusiness unitVoucher numberDocument numberERP document numberInvoice numberDebit note numberCredit note numberJournal voucher numberPayment referenceReceipt referenceBank referenceUTRTransaction IDNarrationDescriptionParty nameRelated party nameIntercompany account codeDocument typeTransaction typeDebit amountCredit amountNet amountOpening balancePeriod movementClosing balanceTaxable valueGST amountVAT amountTDS amountWithholding tax amountTax reversal amountBase currency amountForeign currency amountExchange rateExchange gain/loss amountRounding differenceTransaction dateDocument dateInvoice datePosting datePayment dateBank dateAccounting periodClearing statusApproval statusReversal statusDerived or cleaned identifiers

Matching scenarios

  • One-to-one

    One ledger entry in Entity A matches one corresponding ledger entry in Entity B.

  • One-to-many

    One transaction in Entity A maps to multiple entries in Entity B, such as invoice plus tax, payment plus bank charge, or one journal split across multiple GL lines.

  • Many-to-one

    Multiple Entity A entries are grouped and matched against one Entity B entry, such as multiple invoices paid through one settlement.

  • Many-to-many

    Multiple invoices, payments, debit notes, credit notes, journals, and tax lines across both ledgers are grouped and compared together.

  • Partial matching

    References match, but amount, date, currency, tax value, GL account, or status differs.

  • Debit-credit matching

    Debit entries in one entity are compared with corresponding credit entries in the other entity.

  • Balance-level matching

    Opening balances, period debits, period credits, period movement, and closing balances are compared entity-wise, GL-wise, branch-wise, or currency-wise.

  • Timing-difference matching

    Transactions posted in different periods are identified and separated from unresolved differences.

  • Currency matching

    Foreign currency amount, base currency amount, exchange rate, and exchange difference are compared where applicable.

  • Tax-level matching

    Taxable values, tax amounts, withholding, deductions, reversals, and statutory fields are compared where available.

  • Net and contra matching

    Invoices, payments, debit notes, credit notes, advances, recoveries, journal adjustments, reversals, write-backs, and balances are netted where required.

AI-assisted transaction matching

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

  • References are incomplete
  • Voucher numbers are formatted differently
  • Invoice numbers are written differently across entities
  • Narrations are inconsistent
  • Entity names are abbreviated
  • One ledger uses debit/credit signs differently
  • One transaction is split into multiple lines
  • Multiple small entries match one larger balance
  • Tax and base amount are posted separately
  • Bank references are missing
  • Journal entries use different descriptions
  • Currency differences require context
  • Amounts require business interpretation
  • Multiple possible matches exist

AI exception analysis

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

Entry missing in Entity BEntry missing in Entity ADebit-credit mismatchAmount mismatchBalance mismatchInvoice mismatchDebit note mismatchCredit note mismatchPayment mismatchAdvance mismatchJournal mismatchTiming differenceTax mismatchCurrency mismatchRounding differenceDuplicate entryWrong entity allocationWrong GL allocationPosting period differenceNarration mismatchInternal ERP issueIntercompany posting issueUnclear reference

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

Audit-ready Entity A Ledger vs Entity B Ledger reconciliation reports

Cointab gives your team a clear report showing which entity ledger entries matched, partially matched, remained unmatched, were timing differences, had balance differences, or were skipped.

Report categories

  • Fully matched

    Transactions where Entity A and Entity B records match by reference, debit-credit value, amount, date, and status.

  • Partially matched

    Records where references match but amount, date, tax, currency, GL account, or posting status differs.

  • Unmatched in Entity A

    Entity B records that do not clearly match Entity A ledger entries.

  • Unmatched in Entity B

    Entity A records that do not clearly match Entity B ledger entries.

  • Debit-credit differences

    Records where debit and credit treatment does not align across both ledgers.

  • Balance differences

    Records where opening balance, period movement, closing balance, or ledger total differs.

  • Timing differences

    Transactions posted in different periods across both entities.

  • Invoice differences

    Intercompany invoice records that are missing, duplicated, or mismatched.

  • Debit note and credit note differences

    Debit notes, credit notes, reversals, and adjustment entries requiring review.

  • Payment and receipt differences

    Payments, receipts, advances, settlements, and clearing entries requiring review.

  • Journal differences

    Manual journals, accruals, provisions, reversals, and reclassifications requiring review.

  • Tax differences

    GST, VAT, TDS, withholding, taxable value, and tax reversal differences requiring review.

  • Currency and exchange differences

    Foreign currency, exchange rate, converted amount, exchange gain/loss, and rounding differences requiring review.

  • Accounting classification differences

    Wrong entity, branch, GL account, cost center, department, project, or business unit allocation.

  • Skipped

    Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

  • Summary cards
  • Entity-level filters
  • GL-level filters
  • Branch-level filters
  • Cost center filters
  • Project filters
  • Document-level filters
  • Invoice 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 entity ledger reconciliation

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

1

Bring data into Cointab

Data can be received or pulled through:

EmailSFTPAPI integrations, where available
2

Run automatically

Schedule reconciliation:

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

Push output back

Send reconciliation output to:

ERPAccounting systemConsolidation systemFinance operations dashboardShared services dashboardIntercompany close dashboardControllership dashboardBI dashboardInternal finance systemAnalytics databaseData warehouseInternal exception trackerEntity follow-up workflowIntercompany adjustment workflowJournal correction workflowClose management workflowAudit or compliance system
  • Matched intercompany entries
  • Matched invoices
  • Matched debit notes
  • Matched credit notes
  • Matched payments
  • Matched journals
  • Unmatched Entity A records
  • Unmatched Entity B records
  • Debit-credit differences
  • Balance differences
  • Timing differences
  • Currency differences
  • Tax differences
  • Duplicate entries
  • Wrong GL allocation records
  • Wrong entity allocation records
  • Open items
  • Suggested actions
  • Excel reconciliation report
  • Structured API output

View an Entity A Ledger vs Entity B Ledger demo report

See how Cointab presents entity-to-entity ledger reconciliation output with matched, partially matched, unmatched, timing-difference, balance-difference, and skipped records.

Entity A Ledger vs Entity B Ledger Demo

Explore a sample report showing intercompany invoices, payments, debit notes, credit notes, journals, balances, tax differences, timing differences, currency differences, and open items.

View demo report
Your browser does not support the video tag.

Explore related intercompany and ledger reconciliations

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

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

Vendor Ledger vs Vendor Statement

Reconcile vendor ledgers with vendor statements across invoices, payments, debit notes, credit notes, deductions, and open items.

View template

Customer Ledger vs Customer Statement

Reconcile customer ledgers with customer statements across invoices, receipts, credit notes, debit notes, deductions, and open items.

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 ledgers across entities

This template is useful for teams that regularly reconcile intercompany ledgers, related-party balances, branch balances, group company entries, journal postings, payments, taxes, currencies, and open items.

Group companies

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

Holding and subsidiary structures

For teams comparing intercompany receivables, payables, recharges, advances, recoveries, and closing balances.

Multi-entity businesses

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

Shared service centers

For shared service teams preparing recurring intercompany and entity-ledger reconciliation reports.

Finance teams

For teams reconciling entity-wise ledgers during month-end, quarter-end, year-end, consolidation, and audit.

Accounting teams

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

Controllers

For controllers who need visibility into open intercompany items, timing differences, balance mismatches, 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 settlements, advances, repayments, funding transfers, and bank movements.

Tax teams

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

Auditors

For audit teams reviewing entity-wise balances, intercompany confirmations, open items, and supporting transaction trails.

Accounting firms

For CA, CPA, or outsourced accounting teams handling intercompany, multi-entity, branch, related-party, and books reconciliation for multiple clients.

Trusted by teams handling entity ledger reconciliation

Cointab is used by finance and operations teams that reconcile high-volume, multi-source transaction data across entities, ledgers, ERP systems, banks, invoices, payments, journals, books, and internal systems.

  • Ixigo logo
  • Abhibus logo
  • Confirmtkt logo
  • Keventers logo
  • Lotus Herbals logo
  • The Belgian Waffle Co logo
  • PharmEasy logo
  • FormulaRX logo
  • Borosil logo
  • Croma logo
  • Checkers logo
  • Charleys logo
  • Ascott logo
  • FoxTale logo
  • Newtap logo
  • Vibgyor School logo
  • Gameskraft logo
  • Recode Studios logo
  • Bonkers Corner logo

“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

Entity A Ledger vs Entity B Ledger Reconciliation FAQs

Entity A Ledger vs Entity B Ledger reconciliation is the process of comparing ledger entries between two entities to identify matched intercompany transactions, missing entries, debit-credit differences, amount differences, timing differences, balance mismatches, and open items.

The main files are Entity A ledger and Entity B ledger. Depending on the workflow, intercompany invoice registers, debit note files, credit note files, journal reports, payment reports, bank statements, tax reports, ERP exports, currency files, or supporting data may also be used.

Yes. Cointab can match intercompany invoices using invoice numbers, document numbers, voucher numbers, entity names, amounts, dates, and supporting references.

Yes. Debit notes, credit notes, reversals, corrections, recoveries, write-backs, and adjustment entries can be compared across both entity ledgers.

Yes. Payments in one entity and receipts in the other entity can be matched using payment references, UTRs, bank references, dates, amounts, and clearing entries.

Yes. Cointab can show entries that appear in Entity A but not Entity B, and entries that appear in Entity B but not Entity A.

Yes. Transactions posted in different periods across the two entities can be identified separately from unresolved open items.

Yes. Opening balances, period movements, debits, credits, and closing balances can be compared where the required data is available.

Yes. Cointab can compare debit entries in one entity with corresponding credit entries in the other entity, depending on the configured reconciliation logic.

Yes. Transaction currency, base currency, exchange rate, converted amount, exchange gain/loss, and rounding differences can be compared where available.

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

Yes. Journal vouchers, accruals, provisions, reversals, reclassifications, manual adjustments, and consolidation entries can be compared.

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

Yes. Entity-ledger reconciliation can support related-party balances, intercompany accounts, group company accounts, parent-subsidiary balances, and internal trading accounts.

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, or custom reconciliation periods.

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

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

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

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

Yes. Users can download Excel reports with fully matched, partially matched, unmatched, timing-difference, balance-difference, skipped, document-level, ledger-level, entity-level, GL-level, and transaction-level details.

Start Entity A Ledger vs Entity B Ledger Reconciliation

Use Cointab's ready-made entity ledger reconciliation workflow to match intercompany invoices, debit notes, credit notes, payments, journals, taxes, balances, currency differences, review exceptions, and export audit-ready reports.

Start this reconciliationSchedule guided setup
View demo report→

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

CointabCointab

Reconciliation automation for finance teams. Match sales, payments, marketplaces, banks, and partner reports with reusable workflows and audit-ready reports.

Product

  • Reconciliation automation
  • Popular reconciliations
  • Data automation
  • Reconciliation reports
Explore product
Solutions
  • Payment gateway
  • Marketplace
  • Bank reconciliation
  • COD reconciliation
All solutions
Popular
  • Sales vs payment gateway
  • Amazon MTR vs disbursement
  • Flipkart sales vs settlement
  • Bank statement vs books
All templates

Resources

  • Blog
  • Guides
  • FAQs
Resources hub

Company

  • About
  • Pricing
  • Contact
  • Schedule guided setup

© 2026 Cointab. All rights reserved.

Privacy policy·Terms of service