Understanding Global vs Entity Reporting Master Data in Horizon Finance

Overview

Horizon Finance is built around the principle of standardized financial reporting, especially in environments with multiple entities using different local accounting systems. To achieve this, the platform uses two layers of reporting logic:

• Global Reporting Master Data: A centralized "common data model" set by the ultimate customer.

• Entity Reporting Master Data: A mapping layer used at the local entity level to align local GL codes with the global structure.

This article explains the role and structure of both components and how they interact to support accurate and consistent financial reporting.

🌍 Global Reporting Master Data

What is it?

The Global Reporting Master Data represents the standardized financial framework adopted by the customer. It defines how all accounting data should be interpreted and structured across all entities, regardless of their source accounting system.

This master data can be accessed by navigating to:

Organisation / Fund Level → Settings → Reporting Master Data

Global Reporting Master Data Structure

⚠️ There are 11 predefined GL Sections, spread across two reports:

Income Statement

• Revenue

• Cost of Sales

• Operational Costs

• Below EBITDA

• Other Comprehensive Income

Balance Sheet

• Non-Current Assets

• Non-Current Assets Depreciation

• Current Assets

• Current Liabilities

• Non-Current Liabilities

• Equity

Cash Flow Configuration Columns

• Depreciation

• Interest Paid

• Purchase of Non-Current Assets

• Foreign Exchange Gain/Loss

• Repayment of Senior Debt, etc.
  Note: Items already considered above EBITDA (e.g. Revenue) should be left blank. |
  | Direct Cash Flow Category | Determines where tagged bank transactions appear in the Direct Cash Flow Statement. Categories include:

• Revenue

• Operational Costs

• Related Party Payments

• Investing Activities

• Financing Activities

• Distributions and Transfers

• Cash Flow from Operating Activities |

✅ Best Practice: Every Global Code should have a Direct Cash Flow Category assigned to ensure all tagged transactions contribute to the cash flow statement.

🏢 Entity Reporting Master Data

What is it?

The Entity Reporting Master Data is where local chart of accounts (CoA) are imported by entity and mapped to the Global Codes defined in the Global Reporting Master Data.

This mapping process creates a bridge between local accounting systems and the centralized reporting logic.

How it Works:

1. A user imports the entity’s local GL codes into the system.

2. Each local GL code is then mapped to a Global Code.

3. Once mapped, all other columns (e.g. Reporting Line, GL Section, Cash Flow Categories) are automatically populated based on the Global Master structure.

🔁 Changes to the Global Reporting Master Data will cascade down to the entity level, ensuring consistency.

🧩 Summary

🔗 Related Articles

• How to Add a New GL Code

• Understanding the Financial Statement Layouts

• How to Tag Bank Transactions