Click main image to view in full screen.
BENEFITS OF THIS DOWNLOADABLE EXCEL DOCUMENT
- Creates a traceable control framework for recurring finance review.
- Connects source records, calculation logic, ownership, and outputs.
- Supports reconciliation, escalation, remediation, and audit evidence.
FINANCIAL MANAGEMENT EXCEL DESCRIPTION
Intercompany Balance, Recharge, and FX Reconciliation Matrix is an editable Excel control architecture focused specifically on intercompany balances, recharge calculations, foreign-exchange effects, counterparty matching, and settlement differences. It is designed for finance and operations teams that need transparent calculations, disciplined ownership, and objective evidence rather than disconnected status updates.
The workbook receives counterparty balances and recharge records through designated input areas. Its calculation and control layers organise those records into traceable schedules without requiring users to re-key calculated outputs. Product-specific mappings, assumptions, thresholds, owners, and reporting periods remain visible so reviewers can identify the cause of each result.
The principal outputs cover matched balances, FX and recharge differences, and settlement actions. Exception records identify the affected item, responsible owner, evidence state, timing, materiality, and resolution path. Integrity checks expose incomplete populations, inconsistent mappings, unsupported conclusions, and unresolved control states before management relies on the executive view.
Implementation begins by reviewing the workbook instructions, scope, and editable fields. The operating team then loads the applicable source population, confirms mappings and assumptions, assigns preparer and reviewer responsibilities, and investigates failed checks. Reported results should be accepted only after source completeness and exception status have been reviewed.
The model is suitable for controllers, finance managers, accountants, analysts, transformation teams, and advisers working within the stated product scope. Labels, periods, owners, thresholds, and organisational references can be adapted while preserving the control architecture. The workbook does not replace professional judgment, statutory advice, or approved accounting policy.
The canonical package provides the product-specific workbook together with the guides identified in its release archive. Every material output is intended to remain connected to a source record, formula, control step, or documented exception. This structure allows management to distinguish supported completion from assertion and to direct review effort toward the specific conditions that remain unresolved.
For this product, governance should retain a dated source population, named control owner, documented review result, and explicit record of every unresolved exception before executive reliance.
Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.
Source: Best Practices in Financial Management Excel: Intercompany Recharge and FX Reconciliation Matrix Excel (XLSX) Spreadsheet, Luke A.
ABOUT THE AUTHOR
CPA and Forensic Systems Architect specializing in financial control, ERP remediation, close governance, and automated reconciliation. Develops executive close control towers, J-SOX-oriented evidence frameworks, reconciliation governance, and finance operating models. Each framework makes exception handling, ownership, sign-off, and executive review visible and auditable. Fixed-price, ... [read more]
Ask the Author a Question
You must be logged in to contact the author.
