Dimensions

Dimensions let you tag transactions and journal lines with a second layer of coding that sits alongside the chart of accounts — a property, a branch, a job, a department. Once transactions are tagged, you can filter any report to one property, or break a Profit & Loss into a column per property, without splitting the client into separate entities. If you have come from Xero, these are Tracking Categories; MYOB calls them Departments and QuickBooks calls them Classes.

How dimensions work

A dimension is the thing you are tracking — Property, Branch, Job. Each dimension holds a list of options — the actual values, like 12 Morton St or Auckland.

Every journal line can carry at most one option per dimension. A line can be tagged 12 Morton St and Maintenance at the same time, because those are two different dimensions — but it can never be tagged with two properties. That constraint is enforced in the database, and it is what makes a segmented report add up: every dollar lands in exactly one column.

An entity can have up to five active dimensions. In practice, two or three is usually plenty.

Setting up a dimension

Go to Workspace → Dimensions. The list has two tabs:

• Entity — dimensions that are live on a particular entity, with their type, enforcement level and option count.
• Templates — workspace-level definitions you can reuse across entities. Templates show how they reach entities and how many they have reached so far.

Click Create dimension to start.

Type and display name

Pick a Type first — Property, Location, Department, Project, Activity, Product / service, or Other. The type is what Prosaic understands the dimension to mean; it decides what extra information each option can hold. Choosing Property, for example, gives every option a set of address fields.

The Display name is entirely yours. A Department-type dimension can be shown as Branch, Team, Cost Centre or Programme — the name defaults to the type's label, and you can overwrite it. If you pick Other, you will be asked for a short description of what you are tracking.

The type locks once the dimension has its first option, since changing it would orphan the information already captured against each option. The one exception is promoting Other to a real type — that is allowed at any time.

Enforcement

Choose how strictly the dimension must be tagged during reconciliation:

• Off — tagging is optional, with no prompts.
• Warn — untagged transactions show a warning but can still be reconciled. This is the default and the right starting point for most dimensions.
• Required — transactions must be tagged before they can be reconciled.

You can change the level later, so there is no need to commit to Required on day one. A common pattern is to start on Warn, watch how consistently the tagging happens for a period, then tighten it.

Adding options

Under Options, add each value the dimension can be tagged with. For a Property-type dimension you also get Address line 1 and 2, Suburb or town, Region, Postcode and Country against each option. Filling the address in is optional, but it is worth doing — that information can only be captured at the time, and it opens the door to per-property reporting and benchmarking later.

Templates: define once, use across clients

If the same dimension applies across a number of clients, switch on Make this a template?. Templates are defined once at the workspace level, and Advanced settings → Automatic application controls how they reach entities:

• Not applied automatically — the template sits unassigned until you add it to an entity yourself. This is the default.
• Entities on chart templates — every entity using the chart templates you select receives it, including new ones.
• Entire workspace — every entity in the workspace receives it, including entities created later.

When a template reaches an entity, Prosaic copies the dimension and its options down to that entity, so each client's coding stays their own while the definition stays consistent across the practice.

You can also manage an individual client's dimensions from the entity's own Dimensions tab, and pick up extra templates when you create an entity.

Tagging transactions

Once an entity has dimensions, they appear wherever coding happens.

In the transactions list

Filter the list to a single entity and you get a column for each of that entity's dimensions, next to Account and Tax. Click a cell to search and pick an option, exactly like coding an account. When several entities are in view, the dimensions collapse into a single Dimensions column showing a count of the tags on each row.

Tagging a transaction before it is reconciled is safe — Prosaic remembers the tag and carries it onto the journal line when you reconcile.

When reconciling and splitting

The reconcile dialog carries the same pickers, and on a split each line is tagged independently — so a single payment can be apportioned across two properties and reported correctly against both.

In manual journals

Create a journal, choose the entity, and a column appears for each of that entity's dimensions alongside Account and Tax Rate. Every line that carries an amount can be tagged.

What you see when something is missing

Uncovered dimensions are flagged in the coding cell as you work — Missing in amber for a Warn dimension, Required in red for one you must fill in.

When a Required dimension has no option on a row, that row's OK button is greyed out until you pick one; hovering it names what is missing. In the reconcile and split dialogs the check runs line by line and saving is refused with the same explanation. Journals behave the same way — every line carrying an amount must be tagged before the journal can be created.

Reporting by dimension

Reports pick up two new controls once the selected entity has dimensions.

Filtering

Profit & Loss, Trial Balance and Balance Sheet each gain a Dimensions filter. Options are grouped under their dimension, and you can tick several at once — three properties out of five, say — without exporting anything to a spreadsheet.

Segmenting the Profit & Loss

The Profit & Loss adds a Segment by control. Choose a dimension and the report renders a column per option, with an (unassigned) column first so anything untagged is impossible to miss. Select a second dimension and its columns are added too, each prefixed with the dimension name.

Filtering and segmenting are alternatives rather than a combination — the Dimensions filter is unavailable while a segmentation is applied. Your selections are held in the report's URL, so a segmented report can be bookmarked or shared as-is.

Archived options behave the way you would want: they disappear from the pickers so nobody tags new transactions with them, but they still appear in reports covering periods where they carry data, marked (archived). History stays intact, and current-period reports stay tidy.

Not here yet

Dimensions have just landed, and some of the surrounding pieces are still to come. So you know where the edges are:

• Rules cannot yet apply a dimension option from the rules editor. Tagging is manual, or through the API and AI assistants.
• Bulk assign — there is no "tag all of these at once" action on already-reconciled transactions yet, and no filter for finding what is missing a tag.
• Fixed assets — depreciation journals cannot yet be attributed to a dimension.
• GST returns and report packs do not yet filter or remember dimension selections.
• Consolidating existing entities — if you currently run one entity per property, the tool to merge those into a single entity with one option per property is still being built. Please talk to us before restructuring anything.

Making a dimension Required currently applies across the entity rather than to chosen accounts — worth bearing in mind if you have accounts, like bank fees, where a property tag is not meaningful.

Need help?

If you are setting dimensions up for a client and want a second opinion on how to structure them, click the 💬 button in the app or email help@prosaic.works. We would genuinely like to hear what you are tracking — it tells us which dimension types to build out next.