> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ai-gust.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Line items

> Select the GL accounts of a management report with filters, move accounts between line items, check that every account is used once, and set the sign and the fixed/variable split.

A line item is the group in a [management report](https://docs.ai-gust.io/guide/reports/management-reports/overview.md) that holds GL accounts. It filters the source data: only the accounts that match its filters count towards it. At the lowest level, every report comes down to line items.

Today you filter on the GL account code.

![Group settings of the line item Services, with the types Section and Line item, Delete group, the Name Services with a translate button and NL, EN and FR. Under Data filters, the codes 610, 611, 612, 613, 614, 615, 616 and 619, each with a cross to remove it, and a field Insert glaccount pre- or suffix with three buttons. A Matches button with a badge of 91. Under Calculation, Reverse sign, turned off.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/line-item-settings.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=d9396be8add3055a63a5d22cf197c3ef)

The settings of a line item that holds the accounts starting with 610 to 616 and 619.

## Add a filter

1. Click the line item, so its **Group settings** open.
2. Under **Data filters**, enter the first digits of the accounts in **Insert glaccount pre- or suffix**, for example *70*.
3. Click **+** to add the filter.

Add a filter for each range you need. Turnover, for example, holds the accounts that start with 70 or 71: add *70* and *71*. An account matches when it meets any of them.

To remove a filter, click the **×** on it.

### Starts with, ends with, not

By default, a filter selects the accounts that start with the digits you enter. Two buttons in the field change that, before you click **+**:

| Button | What it does |
| - | - |
| **>\|** | Switches between *starts with* and *ends with*. |
| **⊘** (not) | Turns the filter around: the line item leaves out the accounts that match. A "not" filter shows struck through. |

![Data filters of the line item Sales: the filter 70, then AND, then the struck-through filter 700000. In the field Insert glaccount pre- or suffix, the button for starts with or ends with and the button for not are marked with arrows.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/filter-buttons.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=cad5c9023fe9d509a930f6a4393b53af)

The buttons for ends with and not, next to the field.

aiGust combines the filters like this:

* The filters that select accounts add up: an account matches when it meets **any** of them.
* The "not" filters add up too: an account is left out when it meets **any** of them.
* The two sets are combined with **AND**: an account must match a filter, and none of the "not" filters.

Say you want to show accounts 700001 and 700002 in a line item of their own:

* The new line item filters on *starts with 700001* and *700002*.
* The turnover line item filters on *starts with 70* and *71*, and *not 700001* and *not 700002*.

### Check which accounts match

The badge on **Matches** shows how many GL accounts match the filters. Click **Matches** to see them. **Double** marks an account that's also in another line item.

![Matches dialog: 23 GL accounts match these filters. We give priority to confirmed aiGust labels. Next, we look at the code from the compliance package. Only then do we fall back to the original account number. A list of accounts from 650000 Interest, commission and other charges relating to debts to 655000 Results from the conversion of foreign currencies, each marked Double.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/matches.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=eb10d584c3bc2ac4302ecd9aeb133fec)

The accounts that match the filters of a line item.

When no account matches, the definition shows *No GL accounts match the filters of this line item.*

## Which code aiGust filters on

aiGust filters on the account code, but not always the one from the bookkeeping. For each account, it uses the first code available, in the same order as for the [standard reports](https://docs.ai-gust.io/guide/concepts/labels.md#how-labels-affect-your-reports):

1. **The code of the confirmed label,** once you've confirmed or changed the [label](https://docs.ai-gust.io/guide/concepts/label-mapping.md) of the account in aiGust.
2. **The compliance code:** the code from a [compliance connector](https://docs.ai-gust.io/guide/concepts/financial-periods.md#compliance-connectors), such as the headings in the Adsolut fiscal files or the Silverfin mapping.
3. **The account number from the bookkeeping.** Most accounts use this one.

So if you remapped an account from 61 to 60 in aiGust, Adsolut or Silverfin, a filter on *60* selects it, and a filter on *61* doesn't. Hover over the code of an account in the definition to see which code aiGust used.

## Move an account to another line item

You can also drag an account from one line item to another:

1. Expand the line item, so you see its accounts.
2. Drag the account. Only the line items where you can drop it light up.
3. Drop it on the other line item.

aiGust adds the filters for you: a "not" filter on the account in the line item it came from, and a filter on the account in the line item you dropped it on.

![The definition of the Hospitality report. Account 700000 Sales now sits under the line item Food revenue, marked in red, with an arrow from the line item Sales in the Turnover section. In the group settings of Sales, the filter 70, then AND, then the struck-through filter 700000, marked in red. Reverse sign is turned on. At the bottom, the red bar 325 accounts are not used.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/move-account.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=aa40a693b22e68e8d84d9b63945349b7)

Account 700000 moved from Sales to Food revenue: Sales now leaves it out.

You can only drop an account on a line item: sections and formulas don't hold accounts.

## Check the accounts

The bar under the group settings shows whether every GL account of the administration is in the report exactly once:

* **All accounts are used once,** in green: every account is in exactly one line item.
* **325 accounts are not used,** in red, for example: those accounts aren't in any line item, so the report leaves them out.
* **23 accounts are used more than once,** in orange, for example: those accounts count in more than one line item.

The check is there to help you. Click the bar to open **GL Accounts**, with three tabs:

| Tab | Shows the accounts that are |
| - | - |
| **Unused** | In no line item. That can be normal: a profit and loss doesn't use the balance sheet accounts. |
| **Double used** | In more than one line item. You normally don't want that. |
| **In use** | In exactly one line item. |

The accounts are grouped by their first digits. To move an account, drag it in the definition: you can't drag from the check. See [Move an account to another line item](#move-an-account-to-another-line-item).

![The GL Accounts panel with GL Accounts to use 1 to 7, of which only 6 and 7 are checked, and a switch splitFixVar. The tabs Unused 2, Double used 23, selected, and In use 330. Under GL Accounts starting with 65, 23 accounts, from 650000 Interest, commission and other charges relating to debts to 650009 Interest Group. At the bottom, the orange bar 23 accounts are used more than once.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/account-check.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=78f2253a83795b85b005889db6c950e7)

The accounts used in more than one line item.

### Leave out account classes

Under **GL Accounts to use**, clear the account classes the report doesn't need, such as 1 to 5 for a profit and loss. The check then leaves those accounts out.

![The GL Accounts panel with GL Accounts to use 1 to 7, all checked and marked in red: decide which accounts can be used. The tabs Unused 325, selected, Double used 23 and In use 330. A pager with the classes 1 to 7, and under class 1, GL Accounts starting with 10 with 100000 Issued capital, 100009 Private and 101000 Uncalled capital (–), then the groups starting with 11, 12 and 13.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/account-classes.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=acff5d71b841eeb5327c6d16ab3c0f36)

Choose which account classes the check takes into account.

> [!NOTE]
>
> Your choice of account classes is only saved in your browser. Your colleagues, or you in another browser, still see all classes.

The check only warns you: you can save a report with unused accounts, or with accounts used more than once.

## Reverse the sign

aiGust doesn't keep debit and credit apart. Every amount has a sign: debit is positive, credit is negative. Revenue accounts are credit accounts, so their amounts are normally negative. Cost accounts normally have positive amounts.

Turn on **Reverse sign** under **Calculation** to turn the sign of the line item around. Do this for revenue, for example, so it shows as a positive amount instead of a negative one. Only line items have this setting.

Reverse sign and the **Operator** do different things:

* **Reverse sign** decides how the line item shows: as a positive or a negative amount.
* **Operator** decides whether a [formula](https://docs.ai-gust.io/guide/reports/management-reports/formulas.md) adds or subtracts the group.

So to show both turnover and direct costs as positive amounts, and still calculate *Gross margin* = *Turnover* – *Direct costs*, give *Direct costs* the operator minus.

## Split fixed and variable costs

A line item can also filter on whether an account is fixed or variable. You build, for example, a line item *Fixed rental costs* and a line item *Variable rental costs*. This is advanced: most reports don't need it.

1. Click the bar at the bottom of the group settings, to open the [account check](#check-the-accounts).
2. Turn on **Split fix/var**. aiGust then takes the fixed/variable split of the accounts into account.&#x20;
3. Under **Data filters** of the line item, choose **Fixed**, **Variable** or **All**.

![Group settings of the line item Food costs, with the filter 604010, and below it a switch Fixed, All and Variable, with Variable selected and marked in red. Under Calculation, Operator, Reverse sign and Use as vertical reference value. Under Formatting, Show this row in a distinct colour in the report and Open this section automatically. At the bottom, the orange bar 23 accounts are used more than once.](https://mintcdn.com/ai-gust/oXbrH58DqjwgH8R_/images/management-reports/fixed-variable-filter.jpg?fit=max\&auto=format\&n=oXbrH58DqjwgH8R_\&q=85\&s=de83d373336cef70da096271aa0f4171)

A line item that only holds the variable part of its accounts.

aiGust uses the fixed/variable split you set on the administration's accounts. See [Contribution margin](https://docs.ai-gust.io/guide/reports/definitions/profit-and-loss.md#contribution-margin).

> [!NOTE]
>
> For now, **Split fix/var** is only saved in your browser. Your colleagues, or you in another browser, have to turn it on again.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.