What Is a Dimensional General Ledger?

Definition

A dimensional general ledger tags each transaction with attributes like location, department, or project, so you can report by any combination of them without adding new accounts to your chart of accounts.

In a traditional general ledger, every way you want to slice your numbers becomes part of the account number. Want rent expense by location? Add a segment. By department too? Add another. Over time, the chart of accounts grows into thousands of accounts, and every new location or program means more setup and more chances for error.

A dimensional general ledger takes a different approach. The account says what the transaction is, and dimensions say where, who, and why.

Segmented chart of accounts vs. dimensions

In a segmented chart of accounts, an account number such as 6100-02-310 might mean rent expense, location 02, department 310. Each combination has to exist before anyone can post to it.

In a dimensional general ledger, there is a single rent expense account. Each entry is tagged with values like location, department, and project. The result:

• A shorter chart of accounts: often a few hundred accounts instead of several thousand.
• No new accounts for growth: adding a location or a grant means adding a dimension value, not rebuilding the chart.
• Cleaner data entry: staff choose from lists instead of memorizing long account strings.
• Flexible reporting: any dimension can become a row, a column, or a filter on a report.

Common dimensions by industry

The right dimensions depend on how your leadership team needs to see the business. A few examples:

• Hotel management: property, owner, brand, and region.
• Equipment rental: yard, asset or asset class, and job.
• Nonprofits: program, grant, and funding source.
• Financial services: fund, client, and service line.
• Most organizations: location, department, project, customer, vendor, and employee.

Benefits for reporting

Because every transaction carries its dimensions, one set of data can answer many questions. The same entries produce a consolidated income statement, a P&L for one property, a profitability report for each crane, or a grant report for a single funder. Finance teams spend less time building spreadsheets and more time explaining the numbers.

Dimensions also make multi-entity accounting simpler. Entities can share one chart of accounts while dimensions keep each entity, location, and program separate for reporting and consolidation.

Dimensions in Sage Intacct

Sage Intacct is built on a dimensional general ledger. It includes standard dimensions such as location, department, project, customer, vendor, employee, item, and class, and you can add user-defined dimensions for things like property, asset, or grant.

When Acumen implements Sage Intacct, we start by designing the chart of accounts and dimensions around the reports your team actually needs. Getting this design right early is one of the biggest factors in how useful the system is later.

Example: one expense, many reports

An equipment rental company pays a $4,800 repair invoice for a crane at its Orlando yard. In a segmented chart of accounts, the bookkeeper needs the exact account string for repairs, Orlando, and the rental division, and someone has to create it first if it doesn't exist.

In a dimensional general ledger, the entry posts to one repairs and maintenance account, tagged with location: Orlando, department: rentals, and asset: Crane 112. That single entry now shows up in the company income statement, the Orlando yard P&L, the rental division report, and the profitability report for Crane 112, with no extra accounts and no spreadsheet work.