Solver Blog

Intercompany Elimination Model for Dynamics 365 Business Central | Example, Uses

Written by Nils R. | 6/25/23 7:00 AM
What is an Intercompany Elimination Input Form ? An Intercompany Elimination Input Form serves as a tool for month-end consolidation and is utilized by Group Controllers and Accountants to manage intercompany entries required for the completion of the consolidation process. This type of input form offers a convenient way for users to input "due to" and "due from" journal entries. The form includes the intercompany accounts on the same row, along with a control/difference column, facilitating the user in ensuring that the entries are balanced. An example of this input form is provided below. Purpose of Intercompany Input Forms Intercompany Input Forms are employed by companies and organizations to efficiently and securely capture intercompany transactions. By incorporating these forms into the Finance & Accounting Department's best practices, a company can enhance its consolidation process and speed while mitigating the risk of unbalanced intercompany transactions or incomplete audit trails. Benefits to Users Utilizing an Intercompany Elimination Input Form offers several benefits to business users, enabling them to make informed decisions and enhance their efficiency in performing their roles. With this tool, users gain a clear overview of intercompany entries, ensuring accuracy and balance in financial consolidation processes. The user-friendly interface simplifies the input of "due to" and "due from" journal entries, reducing the likelihood of errors or omissions. Additionally, the inclusion of intercompany accounts on the same row, along with a control/difference column, facilitates quick reconciliation and verification. By streamlining the consolidation process, these forms enable users to save time, enhance data quality, and reduce the risk of incomplete audit trails, ultimately leading to improved decision-making capabilities and increased efficiency in their day-to-day tasks. Intercompany Input Form Example Here is an example of an Intercompany Elimination Input Form.

Intercompany Elimination Input Form from Solver

You can find hundreds of additional examples here. Who Uses This Type of Input Form ? The typical users of this type of input form are: Group Controllers and Accountants. Other Input Form s Often Used in Conjunction with Intercompany Input Forms Progressive Finance & Accounting Departments sometimes use several different Intercompany Input Forms, along with intercompany audit reports, consolidated financial reports and other management and control tools. Where Does the Data for Analysis Originate From? The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others. In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions. What Tools are Typically used for Reporting, Planning and Dashboards? Examples of business software used with the data and ERPs mentioned above are:
  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)
Corporate Performance Management (CPM) Cloud Solutions and More Examples Only Solver delivers a  one-day rapid deployment , including free and instant access to $100K of value available on Day 1 in the  Solver Marketplace . Solver is committed to helping you with all your advanced planning and reporting needs, so you can Accelerate Better Decisions – starting now. Take a free tour of Solver for any of these ERPs: