All guides
Guide · Financials – G/L

Departments, classes and locations on the ledger

Switching on G/L segments, keeping their value lists, the rules each account follows, tagging documents and journal lines, and reading reports and budgets by segment.

3 min read

Your chart of accounts says what money was for. Segments say where in the business it belongs. BeanDish has three: Department, Class and Location. Every journal line can carry one value of each beside its account, so you can read a P&L for one department or one location without an account for every combination.

Switching segments on

An Admin opens Settings › G/L and finds the Segments card. For each segment you want, tick Use this segment. You can rename it — "Region" instead of "Class", say — and the new name is what every screen shows.

Each segment has three more settings:

  • Required on income and expense lines — every income and expense line must carry a value.
  • Lowest-level values only — only values with nothing beneath them may be used.
  • Company default — the value that fills in when a line needs one and has none. A segment needs a default before it can be required.

The Separator joins an account code to its segment codes into a segmented account number, such as 6100-10. Click Manage values to keep the lists.

The value lists

Under Manage values, each segment has its own list. A value has a Code of up to ten letters or digits, a Name, and an optional Parent, so departments can roll up into larger ones. Values are archived rather than deleted. While Location is in use, each warehouse has a Location value of its own, made for you.

Rules per account

On an account's Details tab, Segment rules sets, for each segment in use, whether that account follows the Company rule or is Required, Optional or Not allowed. Balance-sheet accounts are optional unless their own rule says otherwise.

Tagging documents and entries

Sales orders, invoices, purchase orders and bills gain a Segments tab once a segment is on. Values flow down: from the customer or supplier, from the item, and from the warehouse for Location. Anything you set on a line yourself is kept.

On a manual journal entry, each line takes its segment values, and you can type a segmented number in Account number to fill the account and its values at once.

What a person sends is checked: a required segment left blank on an income or expense line, a value on an account that doesn't allow it, or an archived value is refused, naming the line. Postings BeanDish makes on its own are never refused for a segment: a required one left blank takes the company default.

Payments, stock postings, the year-end close and reclassifications all carry segment values through, so receivables, payables and retained earnings tie out by segment too. Reclassify can move a line to another department without changing its account.

Reports and budgets

The financial statements, statement layouts and the Journal can be filtered by segment value. A parent value includes the values beneath it. The Profit and Loss can also show Columns by segment, one column per value.

A budget can be set for an account and a combination of segment values, on the account's Budget tab or from Financials – G/L › Budgets. A budget report filtered by segment adds up every budget matching the filter.