On-the-fly Advanced Mapping🚀-Emfino Super Feature #4

For quick implementation of automated reporting and consolidation across the entire Group, the Advanced mapping is there.

Even if data from Local entities appear less than perfect or lack key details - no worries! Advanced mapping offers a variety of ways to enhance both historical and newly imported actuals, ensuring smooth reporting and consolidation.

On-the-fly mapping feature ensures that each change in the mapping of Local COA and dimensions to Group COA and group dimensions is automatically reflected in all reports without the need to reimport the financial data.

Advanced mapping functionality is typically used during the transition period, before the Group COA is implemented across entities.

✨ Keep your financial team smiling 😊 - achieve Group reporting and consolidation fast, (even in one month), with minimal disruption to your existing accounting records.

Emfino Super Feature #4: On-the-fly Advanced Mapping

Examples of Advanced Mapping in Emfino DEMO System

Here’s how it works.

1) Start with the 'Usual' 😊 mapping

If your Local COA differs from the Group COA, begin with basic mapping:

• Step 1: Map local accounts to Group accounts

• Step 2: Map local dimensions to Group dimensions

Emfino Demo: 'Account mapping' from Local to Group accounts

Emfino Demo: Dimension mapping from Local to Group Profit/Cost centers

2) Enhance with Advanced Mapping

Once the 'Usual' mapping is done, you can import data into the system and proceed with data review, reporting, and consolidation. If you discover that the Local data lack necessary information for reporting and consolidation, then Advanced mapping can help.

Advanced mapping can be based on various criteria from Local data, such as account numbers, dimensions, partner names, comments, or document numbers. It can:

🆒 Add or adjust necessary dimensions in the transactions (1)

🆒 Add partner names if missing in transactions - especially useful for intra-group transactions to enable reconciliation and consolidation (6)

🆒 Move intra-group transactions into separate Group accounts for consolidation and reconciliation (2)

🆒 Transfer IFRS adjustments into distinct accounts (3)

🆒 Split transactions from a single Local account to multiple Group accounts (4, 5).

Emfino Demo: Advanced mapping definitions

3) More Visibility in Reports

Both Local and Group accounts are visible in Detailed Profit&Loss and Balance Sheet reports.

Emfino Demo: Visible Local accounts in the detailed P&L report

4) Drill-down Transparency

Both Local and Group accounts & dimensions are shown in drill-downs to the transaction level.

Emfino Demo: Visible Local accounts & dimensions in the drill-downs by transactions

5) Smart Mapping Setup

When new Local accounts or dimensions appear in imports, they’re automatically added to the mapping setup.

Emfino Demo: The unmapped Local account #5972 is automatically added to the mapping set-up

This comprehensive functionality demonstrates why Emfino’s advanced mapping is a must-have for modern multi-entity organizations willing to implement automated reporting and consolidation rapidly and without compromise. 😊

❗Find more in the article:

🌀 "Advanced Mapping - Emfino Super Feature #10"