Dimensions

Learn how to create and manage accounting dimensions in Ottimate

What is a dimension?

In accounting systems, financial transactions like purchase orders and invoices need to be properly categorized for reporting and compliance. Transactions are assigned to specific GL accounts, departments, locations, projects, and other organizational segments based on a company’s accounting rules.

Ottimate represents these transaction classifications through dimensions. Each dimension consists of:

  • Dimension type: e.g., GL Account, Department, Location, Project, Customer, etc
  • Dimension name: The specific value within that dimension type (e.g., “Furniture & Equipment”, “Boston Office”)

Examples

GL Account coding: If a company codes office equipment purchases to GL Account 3421 “Furniture & Equipment” in their ERP, this appears in Ottimate as:

FieldExample ValueDescription
typeaccountdimension type representing ledger accounts in Ottimate
nameFurniture & Equipmentthe account label extracted from ERP
erp_dimension_id3421the ledger account identifier in the client’s ERP

Location coding: If the same purchase is assigned to a specific location like “Boston Office”, another dimension is assigned:

FieldExample ValueDescription
typelocationdimension type representing locations in Ottimate
nameBostonthe location label extracted from ERP
erp_dimension_idBSNthe identifer for the Boston Location assigned in the client’s ERP

Dimensions can be applied at both the invoice header and item level. A single transaction can be coded with multiple dimensions, allowing for detailed multi-dimensional reporting that matches your accounting system’s structure.

In the following image, we illustrate how dimensions appear in the Ottimate UI.

Supported Dimension Types

The following types of dimensions are commonly fetched from client ERP systems and stored in Ottimate for coding. We include the comparable ERP entities for reference.

GL Account

A GL Account (General Ledger Account) classifies how a transaction will be recorded in the company’s general ledger. For example, coding office supplies to an “Office Expense” account.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
accountAccountGL AccountGLAccountAccountAccount

Location

Represents geographic locations like offices, facilities, warehouses, or divisions within a company.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
locationLocationLocationLocationBranch/Location

Department

Represents internal business units or functions within a company.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
departmentDepartmentDepartmentDepartmentSubaccountDepartment

Project

Used to track transactions related to a specific initiative, job, or capital effort.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
projectJobProjectJobProject

Task

Represents specific tasks within a project for detailed tracking.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
taskTaskCost Code

Cost Type

Used for categorizing different types of costs within projects.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
cost_typeCost TypeCost Code

Item

Represents goods and services purchased from vendors.

Dimension TypeNetSuiteIntacctBusiness CentralAcumaticaQuickBooks Online
itemItemItemItemStockItemItem

Fetching dimensions from Ottimate

For supported ERPs, Ottimate automatically retrieves accounting dimensions. You can fetch the list of dimensions that Ottimate has synched from the accounting system with the dimensions API. For a list of supported operations and query parameters, see dimensions.

Sample Request

In this cURL example, we fetch all dimensions associated with a company in Ottimate.

GET
/v1/dimensions
1curl https://api.ottimate.com/v1/dimensions \
2 -H "X-Api-Key: <apiKey>"

Response

Response
1{
2 "version": "1.0.0",
3 "total_count": 100,
4 "page": 1,
5 "limit": 20,
6 "dimensions": [
7 {
8 "id": "dim_VOH21Up3M7HV",
9 "name": "Sales Account",
10 "type": "Account",
11 "erp_dimension_id": "ext_sales_001",
12 "dimension_type": "account",
13 "ottimate_company_id": 15196
14 }
15 ]
16}

Where id is the Ottimate assigned identifier for this specific dimension value, and erp_dimension_id is the ERP assigned identifier.

See /v1/dimensions for a complete list of functionalities and additional examples.