Intercompany Reconciliation Automation

Reconciling intercompany positions is a labor-intensive necessity for group closures and auditing. This skill automates the matching of payables and receivables across a corporate group to ensure every claim from Entity A against Entity B is perfectly mirrored by a corresponding debt from Entity B to Entity A.

What it does

The skill processes financial position data to identify discrepancies before consolidation. It performs the following high-level operations:

• Aggregation of intercompany balances per entity pair and type.
• Mirror-matching of every "Receivable" against its opposite "Payable".
• Generation of a detailed difference list highlighting "OK", "MISMATCH", or "MISSING" statuses.
• Filtering of items based on a user-defined tolerance threshold.

Why use this skill

Traditional manual reconciliation in Excel is prone to human error and scaling issues. This Python-driven skill treats financial data with structural integrity, ensuring no transaction is overlooked. It provides a clean, audit-ready CSV output that highlights exactly where the accountant needs to focus their investigation (e.g., timing differences, FX errors, or unbooked invoices).

Output

The skill produces a structured reconciliation table (reconciliation.csv) and a summary report of items to investigate, saving hours of manual data pivoting and lookup work during year-end closing.