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.
View demo reportReconcile 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 source | Example records |
|---|---|
| Entity A Ledger | Used 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 Ledger | Used 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 Register | Optional, 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 Register | Optional, but useful where intercompany debit notes, credit notes, recoveries, reversals, adjustments, and recharges need to be matched across both entities. |
| Journal Voucher Report | Optional, but useful where intercompany journal entries, accruals, reversals, provisions, reclassifications, and manual adjustments need review. |
| Payment / Receipt Report | Optional, but useful where payments, receipts, advances, bank transfers, settlements, and clearing entries need to be compared. |
| Bank Statement | Optional, but useful where intercompany payments or receipts need to be traced to actual bank transactions. |
| Foreign Currency / Exchange Rate File | Optional, but useful where entity ledgers are maintained in different currencies or where exchange gain/loss differences need to be analyzed. |
| Tax / Withholding Report | Optional, but useful where GST, VAT, TDS, withholding tax, service tax, tax reversal, input/output tax, or other statutory values affect intercompany balances. |
| ERP / Accounting Export | Optional, but useful if both entities maintain records in SAP, Oracle, NetSuite, Microsoft Dynamics, Tally, Zoho Books, QuickBooks, or another accounting system. |
| Supporting Data | Optional 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.
Select the template
Choose Entity A Ledger vs Entity B Ledger from popular reconciliations.
Select the period
Choose the month, quarter, financial year, consolidation period, audit period, close period, lifetime period, or custom period you want to reconcile.
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.
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 document references, debit-credit values, invoices, payments, journals, debit notes, credit notes, taxes, currencies, and balances.
Review output
View fully matched, partially matched, unmatched, timing-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:
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:
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.
Bring data into Cointab
Data can be received or pulled through:
Run automatically
Schedule reconciliation:
Push output back
Send reconciliation output to:
- 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 reportExplore 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 templateBooks Reconciliation
Reconcile accounting books across ledgers, reports, ERP exports, bank records, invoices, payments, and open items.
View templateBank Statement vs Books
Compare bank statement entries with accounting or books records.
View templateVendor Ledger vs Vendor Statement
Reconcile vendor ledgers with vendor statements across invoices, payments, debit notes, credit notes, deductions, and open items.
View templateCustomer Ledger vs Customer Statement
Reconcile customer ledgers with customer statements across invoices, receipts, credit notes, debit notes, deductions, and open items.
View templateERP / Books Reconciliation
Reconcile ERP exports and accounting books across transactions, ledgers, journals, bank entries, invoices, and balances.
View templateBuilt 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.
“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.”
Entity A Ledger vs Entity B Ledger Reconciliation FAQs
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.
View demo reportReady-made workflow · Reusable every period · Manual upload and automation supported