Company settings

Purpose

Use the Company settings screen to edit your company’s Chart of Accounts, Tracking 1, and Tracking 2. Update these settings before importing or connecting your own accounting data.

Context

Each company in XLReporting can have its own accounts and tracking dimensions. You first select the company you want to maintain, then adjust its financial structure to match your accounting system. This setup ensures correct mapping for consolidation, budgeting, and reporting.

Steps

1. Select a company

• Choose the company you want to update from the dropdown list.
• The screen will load three tabs: Chart of Accounts, Tracking 1, and Tracking 2.

2. Edit the Chart of Accounts

This section defines the structure of all general ledger accounts. You can manually add new accounts or import them from your integration.

For each account, you can set:

• Account name – Optional custom name, which can differ from your accounting system.
• Account type – Classifies the account (e.g. Assets, Liabilities, Revenue, Expenses). Determines how XLReporting treats the account in reports and statements. Based on your selection, Statement and Account group are automatically filled.
• Account category – Optional custom grouping name. Start your custom category with “S” + code or sequence number followed by “:”, for example: S01: Operating income. This defines the display order in reports. If left empty, the Account group will be used.
• Budget – Indicates whether this account participates in budgeting or forecasting.
• Journal types – Defines which consolidation process steps include this account. You can add new journal types in Global settings.

3. Edit Tracking 1

Tracking dimensions let you analyse results by business segments. Different integrations use different names for tracking categories:

You can add new records manually (using the plus icon) or via your integration’s Update Settings option.

For each tracking code, you can set:

• Code – Combine the company code, “_”, and the tracking code or description. Do not change existing codes once created.
• Tracking 1 – Short descriptive name.
• Source – Defines the data origin (same as in Companies).
• Group – Used for reporting purposes to group several tracking codes.
• Active – Marks whether the tracking is visible.
• Budget – Marks whether the tracking dimension is included in budgeting.

4. Edit Tracking 2

This section works the same way as Tracking 1. Different systems use different names:

All columns and settings are identical to Tracking 1.

Example

For company “NL01”:

• Account 4000 – “Sales revenue”, type = Revenue, category = S01: Income
• Tracking 1 code “NL01_SALES” – “Sales department”, active = Yes, budget = Yes
• Tracking 2 code “NL01_PROJECT01” – “Project Alpha”, active = Yes

Common mistakes & tips

• Do not rename or delete existing codes after importing data — it can break data links.
• Use clear and consistent naming for custom categories.
• Always review account types; incorrect classification affects reporting totals.
• Update these settings before running your first import.

Related articles & videos

• Global settings
• Budget settings
• Consolidation process