Quick Guide: How to Edit Entity-Level Reporting Master Data

Once your entity’s Chart of Accounts has been imported into Horizon Finance, you may need to review or edit how these Local GL Codes are mapped to the Global Reporting Master Data. This mapping is essential to ensure that your financial statements (Income Statement, Balance Sheet, and Cash Flow) reflect your data accurately and align with your organization’s Common Data Model.

🔍 Where to Navigate

To review or edit Entity-Level Reporting Master Data, follow these steps:

1. Navigate to the Entity
   Use the left-hand entity list or search from the Fund / Organisation level to select the entity you want to update.

2. Go to Settings
   Once in the entity, click on the Settings tab in the top menu.

3. Select ‘Reporting Master Data’
   This will take you to the screen where you can view and manage the mapping between the Local GL Codes and the Global Reporting Master Data.

🛠 How It Works

• You will see a table listing all Local GL Codes imported from the entity’s accounting system.

• For each line item, you will need to map the Local GL Code to the appropriate Global Code.

• Once you select the Global Code:

  • All corresponding columns (e.g., Global Name, Reporting Line Item, GL Section, Cash Flow Tags) will auto-populate based on the Global Reporting Master Data.

• You can edit or update the mapping by clicking into the relevant fields. A dropdown will appear for you to search and select the correct Global Code.

Note: Each Local GL Code can be mapped to only one Global Code to avoid conflicts in reporting.

💡 Best Practice Tips

• Always double-check mappings for Income Statement items below EBITDA and Balance Sheet accounts, as these impact the Indirect and Direct Cash Flow Statements.

• If a Local GL Code doesn’t match any existing Global Code, contact your admin or raise a ticket to request a new Global Code be added.

🙋 Need Help?

If you're unsure about how to map a particular GL code or if something doesn't look right, use Help > Contact Support within Horizon Finance to raise a support ticket — our team is here to assist.