Due To vs Due From Reconciliation

Due To vs Due From reconciliation is the process of comparing payable-side and receivable-side intercompany balances to identify matched transactions, missing entries, debit-credit differences, timing differences, amount mismatches, balance differences, and open items.

The main files are the Due To ledger and Due From 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 compare Due To and Due From balances across entities, branches, related parties, GL accounts, and accounting periods.

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 Due To and Due From ledgers.

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

Yes. Cointab can show entries that appear in Due To but not Due From, and entries that appear in Due From but not Due To.

Yes. Transactions posted in different periods across the two ledgers 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 ledger with corresponding credit entries in the other ledger, depending on the configured reconciliation logic.

Yes. Transaction currency, base currency, exchange rate, converted amount, exchange gain/loss, revaluation, 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, eliminations, and manual adjustments can be compared.

Yes. The same workflow can be used for head-office-to-branch, branch-to-branch, entity-to-branch, or branch-to-entity Due To and Due From reconciliation.

Yes. Due To and Due From 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.