Structure your accounting data by accounts and dimensions
A clean, nature-based chart of accounts (CoA) paired with dimensions like Department is the most sustainable way to structure financial data. It avoids duplication and supports flexible reporting as your business scales. Functional views belong in dimensions, not in your CoA.
The CoA is typically designed around natural classifications of income and expenses. These describe the type of transaction, regardless of who incurred it or for what purpose. Examples include:
To analyze financials by other perspectives - such as teams, projects, or regions - most accounting systems offer dimensions. These allow you to tag transactions with additional metadata, enabling more flexible reporting. Common examples:
This lets you answer questions like:
When companies start thinking in functions (like Sales or Engineering), it’s tempting to reflect this in the CoA. For example:
This gives a quick sense of departmental spend, but it’s not scalable. Over time, this approach leads to duplicated categories and a bloated CoA.
The real problem arises when you want to transition to proper dimensions. At that point, you’re forced to either:
Dimensions are the intended way to enable function-based views, not by duplicating functional logic in the CoA.
Use dimensions early – even in small or early-stage setups. Most ERPs support dimensions out of the box, and modern FP&A tools like Francis let you model across multiple dimensions without friction.
By keeping your CoA clean and nature-based, and tagging function via dimensions (e.g. Department), you get a system that scales with your business, without needing to change practice along the way.