An organisation equals a separate entity and file. A division is a sub‑layer inside that file used for internal reporting (locations, teams, departments). This article explains the different ways to structure your Magnifi file and helps you choose the right option before commencing the projections.
When setting up a new Magnifi file and deciding how to represent your organisations.
When you need to compare results across multiple divisions or organisations.
When preparing for consolidated reporting across organisations.
Best for: simple reporting.
Key points: default when you add an organisation.
How to: Add an Organisation. Link to come
Best for: locations, teams, or departments within one organisation.
Key points: assign accounts to divisions; you can exclude inter‑entity transactions; report by division or All Divisions (represents the organisation).
How to: Add Divisions
Best for: a quick consolidated view of multiple entities with minimal setup.
Key points: represent each entity as a division in one file; import at divisional level; All Divisions = consolidated view; you can exclude inter‑entity transactions. Limitation: you cannot have another sub‑layer under each entity (no “divisions within divisions”).
How to: Add Divisions for each entity.
Best for: complex groups needing depth and flexibility.
Key points: create one file per entity (each file is an organisation), then Group Files under a group name. Unlocks three layers of reporting: Group → Organisation (file) → Division (sub‑layer). Exclude inter‑entity transactions; consolidated reporting.
How to: Add a Group.
Best for: cross‑division reporting after setup. This can happen later.
Key points: combine selected divisions into segments for targeted views, without changing your structure.
Next step: Add Segment and select which divisions to include.
Tip: If you have multiple entities and you're unsure if you will ever require divisions within an entity, best to setup multiple files and use the group option to give you the flexibility down the track.
Tip: Consider how your accounts are structured for divisional reporting. For example, you can't setup divisions for a location if you don't have accounts by location because you need to assign the accounts to the division.
FAQ: Do I always need divisions? No. If you don’t require a divisional breakdown, keep a simple structure.
FAQ: Can I use divisions for tracking categories? Yes. If you are a Xero user you can basically map your division to a tracking category. However this only works when ALL accounts within your Xero file have been assigned to a tracking category.
Pitfall: Too many divisions can slow performance without adding reporting value. We would recommend keeping < 10 divisions per organisation