The same expense can mean very different things depending on the organization recording it.

For a holding company, a software bill may need to be assigned to the correct subsidiary, office, department, project, and shared-service category before it reaches consolidated reporting.

For a nonprofit, one supplier bill may need to be divided across programs, grants, funding sources, donor restrictions, locations, and functional expense categories.

Both organizations need more reporting detail than a traditional chart of accounts can comfortably carry. The structure behind that detail is different.

That is why this guide covers a multi-entity holding company and a grant-funded nonprofit together. They represent two common Sage Intacct environments where dimensional accounting in Sage Intacct has a major effect on reporting, transaction coding, allocations, and the monthly close.

Why a Generic Account Structure Fails Both Organizations

A chart of accounts can support core financial reporting. Problems begin when finance also asks it to identify A holding company and a grant-funded nonprofit need different reporting structures, but they often arrive at Sage Intacct with the same underlying problem.

Too much detail has been packed into the chart of accounts.

A holding company may have account codes that include the entity, department, location, and business unit. A nonprofit may use similar strings to identify the grant, program, restriction, location, and functional category.

That approach can work while the organization is small. It becomes harder to maintain each time finance adds another subsidiary, office, department, grant, or program.

Consider a holding company with:

• 5 legal entities
• 5 departments
• 3 operating locations

Those categories create 75 possible combinations for a single natural account:

5 entities × 5 departments × 3 locations = 75 combinations

Travel expense alone could require codes such as:

6100-ENT01-DEPT01-LOC01
6100-ENT01-DEPT01-LOC02
6100-ENT01-DEPT01-LOC03
6100-ENT01-DEPT02-LOC01
6100-ENT01-DEPT02-LOC02

The list keeps growing even though the underlying expense is still Travel Expense.

A nonprofit can face the same issue with Program Supplies. A new grant or program may trigger another set of account codes, even though the natural expense category has not changed.

This creates practical problems for finance:

• Several codes for the same expense
• Duplicate or inconsistent combinations
• New accounts whenever the organization changes
• Transactions posted to the wrong string
• Reports that depend on exact coding
• Long account lists that slow review during close

Sage Intacct allows finance to keep one natural account:

6100 | Travel Expense

The reporting detail can be assigned separately at the transaction-line level:

Entity: Summit Software
Department: Sales
Location: Houston
Project: Acme ERP Implementation

A nonprofit can apply the same approach with separate values for program, grant, funding source, restriction, and functional class.

The chart of accounts records the financial category. Dimensions carry the legal, operating, and reporting context.

With that distinction in place, the next step is choosing which Sage Intacct dimensions should hold each type of detail.

The Eight Standard Sage Intacct Dimensions

Once finance stops forcing every reporting category into the chart of accounts, that detail needs a clear place to live.

Sage Intacct provides eight standard dimensions that can be assigned to transaction lines and used in reports, dashboards, allocations, approvals, and other workflows.

Each dimension should have a defined job. The goal is to match the field to the reporting question finance needs to answer.

Standard dimension	Common uses
Location	Office, branch, facility, region, clinic, site, or operating territory
Department	Functional team, cost center, operating division, or administrative unit
Project	Client engagement, implementation, grant, contract, initiative, or capital project
Customer	Client, donor, funder, member, or revenue source
Vendor	Supplier, contractor, consultant, community partner, or service provider
Employee	Employee, salesperson, project manager, program lead, or transaction owner
Item	Product, service, fee type, inventory item, contribution type, or revenue category
Class	Functional category, revenue type, shared-cost category, or another reporting classification

Entity sits alongside these dimensions in a multi-entity environment.

An entity usually represents a legal or formal reporting unit. A location represents an office, branch, clinic, facility, or operating region.

That distinction matters because one entity may operate several locations, and several entities may conduct business in the same region.

Custom dimensions can be added when a recurring reporting category does not fit the standard fields.

For a nonprofit, those custom dimensions may include:

• Program
• Funding source
• Donor restriction

For a holding company, they may include:

• Product family
• Portfolio company
• Contract type
• Distribution channel

The field choice should follow the reporting need.

Reporting question	Likely field
Which legal company owns the transaction?	Entity
Where did the activity occur?	Location
Which team is responsible?	Department
Which engagement or award is involved?	Project
Which product or service generated the activity?	Item
How should the activity be classified for management or functional reporting?	Class
Which nonprofit program received the benefit?	Custom Program dimension
What type of funding supported the activity?	Custom Funding Source dimension
What donor restriction applies?	Custom Restriction dimension

The same Sage Intacct fields can support both organizations. The difference lies in how those fields are arranged, named, grouped, and applied during transaction entry.

What Dimensional Accounting Looks Like in Practice

Dimensions become easier to understand when you see the reports they are meant to produce.

A holding company may want to know which subsidiary is profitable, how much each office spends, and where shared costs are landing.

A nonprofit may need to know which grant paid for an expense, which program benefited, and whether the spending meets donor restrictions.

Both organizations use Sage Intacct dimensions. They arrange them differently because they are answering different financial questions.

Example 1: A Multi-Entity Holding Company

Summit Technology Holdings owns three operating companies:

• Summit Software
• Summit Managed Services
• Summit Consulting

The leadership team wants a consolidated view of the group, but each company president also needs a separate income statement.

Finance must also report by office, department, project, service line, and shared-cost category.

That leads to a structure like this:

SUMMIT TECHNOLOGY HOLDINGS
│
├── ENTITY
│   ├── Summit Technology Holdings
│   ├── Summit Software
│   ├── Summit Managed Services
│   └── Summit Consulting
│
├── LOCATION
│   ├── Houston
│   ├── Dallas
│   ├── Atlanta
│   ├── Chicago
│   └── Phoenix
│
├── DEPARTMENT
│   ├── Finance
│   ├── Sales
│   ├── Marketing
│   ├── Product and Engineering
│   ├── Professional Services
│   └── Managed Services
│
├── PROJECT
│   ├── Client Projects
│   ├── Internal Projects
│   └── Capital Projects
│
├── ITEM
│   ├── Software Subscriptions
│   ├── Implementation Services
│   ├── Consulting Services
│   ├── Training
│   └── Support
│
└── CLASS
    ├── Recurring Revenue
    ├── Nonrecurring Revenue
    ├── Corporate Overhead
    ├── Shared Services
    └── Intercompany

The natural account still identifies the financial category, such as software expense or consulting revenue.

The dimensions add the business context:

Dimension	Question it answers
Entity	Which company owns the transaction?
Location	Which office or market is involved?
Department	Which team is responsible?
Project	Which client engagement or internal initiative applies?
Item	Which product or service is involved?
Class	Is the activity recurring revenue, overhead, shared service, or intercompany?

One Bill, Three Subsidiaries

Suppose Summit receives a $12,000 software bill that benefits all three operating companies.

Amount	Entity	Department	Location	Class
$5,000	Summit Software	Product and Engineering	Houston	Shared Services
$4,000	Summit Managed Services	Managed Services	Dallas	Shared Services
$3,000	Summit Consulting	Professional Services	Atlanta	Shared Services

Finance enters one bill, but each line flows to the correct subsidiary, department, and location.

That detail can support consolidated financial statements, entity-level income statements, departmental budgets, regional reporting, and shared-cost analysis.

The structure stays manageable when finance follows a few boundaries:

• Use entities for legal or formal reporting units.
• Use locations for offices, facilities, markets, and regions.
• Use departments for teams with financial responsibility.
• Use items for products and services.
• Give class one clear reporting purpose.
• Document how shared and intercompany costs should be coded.

The result is one reporting model that serves both the subsidiaries and the parent company.

Example 2: A Grant-Funded Nonprofit

Community Health Access Network operates several health programs and receives funding from government agencies, foundations, corporate sponsors, and individual donors.

When finance reviews an expense, the account alone is not enough.

The team may also need to know:

• Which program used the funds
• Which grant paid for the expense
• What donor restriction applies
• Where the activity occurred
• Which team owns the cost
• How the expense belongs in functional reporting

That leads to a different structure:

COMMUNITY HEALTH ACCESS NETWORK
│
├── LOCATION
│   ├── Houston Clinic
│   ├── San Antonio Clinic
│   ├── Rio Grande Valley Mobile Unit
│   ├── New Orleans Clinic
│   └── Albuquerque Clinic
│
├── DEPARTMENT
│   ├── Finance
│   ├── Development
│   ├── Programs
│   ├── Clinical Operations
│   └── Community Outreach
│
├── PROGRAM
│   ├── Primary Care
│   ├── Maternal Health
│   ├── Mobile Health Outreach
│   └── Nutrition Education
│
├── GRANT
│   ├── HRSA Community Health Award
│   ├── CDC Prevention Initiative
│   ├── Hope Foundation Grant
│   └── Unrestricted Operating Support
│
├── FUNDING SOURCE
│   ├── Federal Government
│   ├── Private Foundation
│   ├── Corporate
│   └── Unrestricted Operating Funds
│
├── RESTRICTION
│   ├── Without Donor Restrictions
│   ├── Purpose Restricted
│   ├── Time Restricted
│   └── Purpose and Time Restricted
│
└── CLASS
    ├── Program Services
    ├── Management and General
    └── Fundraising

Each field adds a different piece of the funding and program story.

Dimension	Question it answers
Program	What work received the benefit?
Grant	Which award paid for it?
Funding source	What type of funder provided the money?
Restriction	What donor-imposed limits apply?
Location	Where did the activity take place?
Department	Which team owns the cost?
Class	How should the expense appear in functional reporting?

The distinction between program and grant is especially important.

A program represents the work the nonprofit performs. A grant represents one source of funding for that work.

One grant may support several programs. One program may also receive funding from several grants.

One Bill, Three Reporting Outcomes

Suppose the nonprofit receives a $7,500 supplier bill.

Expense	Amount	Program	Grant	Restriction	Class
Prenatal supplements	$3,500	Maternal Health	Hope Foundation Grant	Purpose Restricted	Program Services
Mobile clinic supplies	$2,500	Mobile Health Outreach	HRSA Award	Purpose and Time Restricted	Program Services
Administrative materials	$1,500	Management and General	Unrestricted Support	Without Donor Restrictions	Management and General

The organization pays one vendor bill. Each line still reaches the correct grant report, program budget, restriction report, and functional-expense statement.

A clear nonprofit setup usually follows a few basic rules:

• Create a separate grant record for each award.
• Keep programs separate from funding sources.
• Use restriction only for donor-imposed limits.
• Use class for functional expense categories.
• Add dates, owners, budgets, and reporting deadlines to each grant.
• Close expired awards to new transactions.

The result is a structure that connects spending to both the mission and the funding behind it.

These examples use the same basic Sage Intacct concept. The difference is the question finance needs the data to answer.

The holding company needs to see performance across subsidiaries and operating units. The nonprofit needs to connect spending to programs, awards, restrictions, and functional reporting.

Use Dimension Groups for Repeated Reporting Needs

The two examples above show how dimensions create the organization’s core reporting structure.

That structure answers questions such as:

• Which entity owns the transaction?
• Which program received the benefit?
• Which location was involved?
• Which grant funded the expense?

Finance may also need reports that pull together selected records from different parts of that structure.

That is where dimension groups come in.

A hierarchy shows how records permanently relate to one another. A dimension group collects selected records for a recurring report, dashboard, allocation, or management review.

Instead of rebuilding the same filters each month, finance can save the required records as a reusable group.

Multi-Entity Group Examples

Dimension group	Included records	Reporting use
Operating subsidiaries	Summit Software, Summit Managed Services, Summit Consulting	Consolidated operating-company results
Southern locations	Houston, Dallas, Atlanta	Regional revenue and expense reporting
Revenue departments	Sales, Professional Services, Managed Services	Revenue-producing department reports
Shared-service departments	Finance, Human Resources, Marketing	Corporate cost allocations
Active client projects	Current implementation and consulting projects	Project margin reporting

Nonprofit Group Examples

Dimension group	Included records	Reporting use
Active federal awards	Current HRSA and CDC grants	Federal grant portfolio reporting
Restricted awards	Purpose, time, and combined restricted grants	Restricted activity reporting
Clinical programs	Primary Care, Maternal Health, Behavioral Health	Clinical program reporting
Program-service departments	Programs, Clinical Operations, Community Outreach	Functional expense reporting
Texas service locations	Houston, San Antonio, Rio Grande Valley	State-level operating reporting

Groups can change without changing the main hierarchy.

For example, finance can add a new clinic to the Texas Service Locations group. Reports using that group can include the clinic without changing where it sits in the location hierarchy.

Each group should have:

• A defined reporting purpose
• Clear membership rules
• A designated owner
• A consistent naming standard
• A review schedule
• A process for adding and removing records

The hierarchy defines the organization’s permanent structure. Dimension groups create reusable reporting views across that structure.

Once the hierarchy, groups, and line-level coding rules are defined, finance can document the setup in a format the implementation team can use.

Download a Sage Intacct Dimension Planning Template

The worked examples show what a completed structure may look like. Most organizations still need to map their own entities, programs, grants, locations, departments, and reporting groups before configuration begins.

BCS ProSoft has created a separate planning template for each vertical so finance can document those decisions in one place.

Multi-Entity Dimension Planning Template

Use the multi-entity template to document:

• Legal entities
• Ownership structure
• Subsidiaries
• Operating locations
• Regional hierarchies
• Departments and cost centers
• Products and services
• Customer segments
• Shared-service categories
• Intercompany activity
• Dimension groups
• Required fields by transaction type
• Legacy account mappings
• Record ownership rules

Download: Multi-Entity Sage Intacct Dimension Planning Template

Nonprofit Dimension Planning Template

Use the nonprofit template to document:

• Programs
• Grants and awards
• Grant periods
• Funding sources
• Donor restrictions
• Functional expense categories
• Locations and departments
• Funders
• Dimension groups
• Payroll allocation requirements
• Indirect cost rules
• Required fields by transaction type
• Legacy account mappings
• Grant and program ownership

Download: Nonprofit Sage Intacct Dimension Planning Template

How Vitamin Angels Used Custom Dimensions to Find $200,000 in Logistics Savings

For Vitamin Angels, better dimension reporting led to a practical question: where was the organization spending the most to move products around the world?

The public health nonprofit works across more than 70 countries and distributes nutrition interventions through thousands of partner organizations. Before Sage Intacct, its finance team used QuickBooks and spreadsheets to track international entities and inventory across 13 warehouses. That made it difficult to compare logistics costs across such a large operation.

Vitamin Angels began tracking shipping costs with Sage Intacct dimensions and reporting on those costs by country and region.

The added detail helped finance identify $200,000 in logistics savings. The organization used those funds to provide vitamins and minerals to another 800,000 undernourished women and children.

That result shows the purpose of a custom dimension more clearly than a technical definition can.

A well-chosen dimension helps finance answer a question the organization will ask repeatedly, such as:

• Which countries have the highest shipping costs?
• How do logistics costs compare across regions?
• Where is spending increasing?
• Which changes could make more funding available for programs?

The dimension is useful because the reporting category matters to real operating decisions. It gives leadership a consistent way to compare costs instead of rebuilding the analysis in a spreadsheet each time.

Vitamin Angels also used Sage Intacct to support multi-currency transactions, intercompany accounting, global consolidations, and separate country entities. The organization reported a 60% improvement in accounts payable productivity and $14 million in additional restricted revenue over three years.

When a Custom Dimension Makes Sense

Create a custom dimension when	Use an existing field instead when
Leadership reviews the category regularly	Another dimension already captures the same detail
Finance needs to compare results across regions, programs, channels, or partners	The category is needed for one temporary report
Users can apply the value consistently to transaction lines	Users would struggle to select the correct value
The category has a clear owner and reporting purpose	No one is responsible for maintaining the records

Vitamin Angels did not add logistics detail simply to create another reporting field. It used dimensions to expose a meaningful cost pattern, act on it, and direct more money toward its mission.

See How Sage Intacct Could Be Set Up for Your Organization

Dimensional accounting in Sage Intacct works best when the structure is built around the reports finance actually needs to produce.

For a multi-entity company, that may mean separating legal entities, locations, departments, projects, shared costs, and intercompany activity while preserving a consolidated view of the group.

For a nonprofit, it may mean connecting every expense to the right program, grant, funding source, restriction, location, and functional category.

The fields themselves are only part of the setup. The real work is deciding what each dimension should represent, how records should be grouped, which values should be required, and how users will apply them during daily accounting.

When those decisions are made early, finance gets more than cleaner reports. The team gains a structure it can use to review performance, explain spending, manage funding, allocate costs, and add new entities, programs, or awards without rebuilding the chart of accounts.

BCS ProSoft helps organizations design and configure Sage Intacct around their actual reporting requirements. That includes the dimension structure, transaction rules, integrations, testing, and reporting needed to support the system after go-live.

Talk With BCS ProSoft About Sage Intacct

Key Takeaways

• Dimensional accounting in Sage Intacct should reflect each organization’s legal structure, operating model, and reporting requirements.
• Multi-entity companies need separate dimensions for entities, locations, departments, projects, shared costs, and intercompany activity.
• Nonprofits need distinct fields for programs, grants, funding sources, donor restrictions, locations, and functional categories.
• Line-level tagging and dimension groups support detailed reporting without creating a bloated chart of accounts.
• Planning templates, clear ownership rules, and pre-go-live testing help keep the structure accurate as the organization grows.

Frequently Asked Questions