10.5 Reconciliation to consolidated amounts

Reconciliation is a crucial step in the consolidation process, ensuring accuracy and consistency in financial reporting. It involves comparing and aligning subsidiary accounts with parent company records, identifying discrepancies, and making necessary adjustments.

The process encompasses balance sheet, income statement, and cash flow reconciliations. Key components include intercompany transactions, timing differences, and accounting policy alignments. Effective reconciliation practices are essential for producing reliable consolidated financial statements.

Importance of reconciliation

• Ensures accuracy and completeness of consolidated financial statements by identifying and resolving discrepancies between subsidiary and parent company accounts
• Provides a clear audit trail and supports the integrity of the financial reporting process in the context of mergers, acquisitions, and complex financial structures
• Helps detect and prevent errors, fraud, or misstatements that could materially impact the consolidated financial statements and mislead stakeholders

Key reconciliation components

Balance sheet items

Top images from around the web for Balance sheet items

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

• 

  Examples of Current Liabilities | Financial Accounting View original

  Is this image relevant?

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

1 of 3

Top images from around the web for Balance sheet items

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

• 

  Examples of Current Liabilities | Financial Accounting View original

  Is this image relevant?

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

• 

  The Balance Sheet | Boundless Business View original

  Is this image relevant?

1 of 3

• Reconcile intercompany balances, such as receivables, payables, and loans, to ensure they eliminate in consolidation
• Verify consistency in the classification and valuation of assets (property, plant, and equipment) and liabilities (debt, provisions) across entities
• Reconcile equity accounts, including share capital, reserves, and retained earnings, to reflect the parent company's ownership interest

Income statement items

• Match intercompany revenues and expenses to ensure proper elimination and avoid overstating or understating consolidated profit
• Reconcile key performance indicators (gross margin, operating profit) to identify any inconsistencies or unusual variances between entities
• Verify the consistent application of accounting policies (revenue recognition, depreciation methods) across the group

Cash flow statement items

• Reconcile intercompany cash flows, such as dividends, interest payments, and capital contributions, to ensure appropriate elimination
• Verify the consistency of cash flow classifications (operating, investing, financing) across entities
• Investigate significant differences in cash flow ratios or trends between subsidiaries and the consolidated group

Reconciliation process overview

Data collection and validation

• Gather financial data from subsidiaries, including trial balances, general ledgers, and supporting schedules
• Validate the completeness and accuracy of the data received, checking for missing information or unusual transactions
• Import the data into a consolidation system or spreadsheet for further analysis and reconciliation

Identification of discrepancies

• Compare subsidiary data with the parent company's records to identify any differences or inconsistencies
• Analyze variances in account balances, transaction amounts, or financial ratios between entities
• Flag material discrepancies that require further investigation and resolution

Investigation and resolution

• Research the underlying causes of identified discrepancies, such as errors, omissions, or timing differences
• Communicate with subsidiary finance teams to gather additional information or clarify transactions
• Propose and implement adjusting entries to resolve discrepancies and align subsidiary data with the parent company's records

Common reconciliation issues

Intercompany transactions

• Inconsistent recording of intercompany sales, purchases, or expenses across entities, leading to elimination differences
• Failure to reconcile intercompany balances, resulting in mismatches between receivables and payables
• Incorrect elimination of unrealized profits on intercompany inventory transfers or asset sales

Timing differences

• Inconsistent cut-off procedures for recording transactions near the end of the reporting period (sales, accruals)
• Differences in the timing of recognizing revenue or expenses due to varying accounting policies or systems
• Delays in processing or recording intercompany transactions, leading to temporary reconciliation differences

Accounting policy differences

• Inconsistent application of group-wide accounting policies across subsidiaries (depreciation methods, inventory valuation)
• Failure to align subsidiary accounting practices with the parent company's policies post-acquisition
• Differences in the interpretation or implementation of accounting standards (IFRS, US GAAP) across jurisdictions

Reconciliation tools and techniques

Spreadsheet-based reconciliations

• Use Excel or Google Sheets to compare and analyze subsidiary data, identifying discrepancies and variances
• Create reconciliation templates with built-in formulas and checks to streamline the process and reduce errors
• Utilize pivot tables, VLOOKUP, and other functions to efficiently summarize and compare large datasets

Specialized software solutions

• Implement dedicated consolidation and reconciliation software (Oracle Hyperion, SAP BPC) to automate data collection and validation
• Leverage built-in reconciliation modules to identify and resolve discrepancies, with workflow management and audit trails
• Utilize reporting and analytics capabilities to gain insights into reconciliation trends and performance

Automation opportunities

• Explore robotic process automation (RPA) to automate repetitive reconciliation tasks, such as data extraction and comparison
• Implement machine learning algorithms to identify patterns and anomalies in reconciliation data, flagging potential issues for review
• Integrate reconciliation processes with enterprise resource planning (ERP) systems to enable real-time data synchronization and validation

Documenting reconciliations

Reconciliation templates

• Develop standardized templates for each type of reconciliation (intercompany, balance sheet, income statement) to ensure consistency
• Include clear instructions, data requirements, and sign-off procedures within the templates
• Regularly review and update templates to reflect changes in accounting policies, group structure, or reporting requirements

Supporting schedules and workpapers

• Maintain detailed supporting schedules that break down reconciliation variances and adjustments by account or transaction type
• Document the rationale and calculations behind each adjusting entry, providing a clear audit trail
• Organize and reference supporting documents (invoices, contracts, email correspondence) to substantiate reconciliation decisions

Review and approval process

• Establish a formal review and approval process for all reconciliations, with clear roles and responsibilities assigned
• Require preparer and reviewer sign-offs on each reconciliation, attesting to its completeness and accuracy
• Implement a tiered review structure for high-risk or material reconciliations, with additional oversight from senior management or the audit committee

Reconciliation best practices

Regular and timely reconciliations

• Perform reconciliations on a regular basis (monthly, quarterly) to identify and resolve discrepancies promptly
• Establish and adhere to strict deadlines for subsidiary data submission and reconciliation completion
• Prioritize the reconciliation of high-risk or material accounts to ensure timely resolution of significant issues

Segregation of duties

• Assign separate individuals to prepare and review reconciliations to maintain an appropriate level of checks and balances
• Restrict access to sensitive reconciliation data and adjusting entries based on job roles and responsibilities
• Implement system controls to prevent unauthorized changes to reconciliation templates, formulas, or posted entries

Continuous improvement initiatives

• Regularly assess the effectiveness and efficiency of the reconciliation process, identifying areas for improvement
• Solicit feedback from preparers, reviewers, and auditors to gather insights into common pain points or bottlenecks
• Implement process improvements, such as automation, standardization, or training initiatives, to enhance the quality and timeliness of reconciliations

Reconciliation vs elimination entries

• Reconciliations involve identifying and resolving discrepancies between subsidiary and parent company accounts, ensuring data consistency and accuracy
• Elimination entries are adjustments made to remove the effects of intercompany transactions (sales, balances) from the consolidated financial statements
• Effective reconciliations are a prerequisite for accurate elimination entries, as they help identify and correct any intercompany differences before the elimination process

Reconciliation in multi-level consolidations

• In complex group structures with multiple levels of subsidiaries, reconciliations must be performed at each level to ensure data consistency
• Start with reconciliations between the lowest-level subsidiaries and their immediate parent companies, resolving any discrepancies
• Progress to higher-level reconciliations between intermediate holding companies and the ultimate parent, considering the impact of lower-level adjustments
• Ensure consistent application of group-wide accounting policies and elimination rules across all levels of the consolidation hierarchy

Auditor expectations for reconciliations

• Auditors rely on effective reconciliations to provide assurance over the accuracy and completeness of consolidated financial statements
• Expect reconciliations to be performed regularly, with all material discrepancies investigated and resolved on a timely basis
• Look for clear documentation of the reconciliation process, including templates, supporting schedules, and evidence of review and approval
• May test the design and operating effectiveness of reconciliation controls, as well as the accuracy of specific high-risk reconciliations
• Expect management to demonstrate a strong control environment and commitment to the integrity of the reconciliation process