Tresio categories

Introduction

Categories are the foundation of all financial planning in TRESIO. Without correctly set up categories, TRESIO cannot process your financial data meaningfully: neither the liquidity forecast, nor reporting, nor TRENDS can deliver correct results without a functioning category structure.

Every transaction, every invoice, every planning entry, and every salary or loan payment is assigned to a category in TRESIO. This assignment directly determines where an amount appears in the liquidity forecast, how it is treated (for example as a fixed cash flow with no invoice reference), and how it can be broken down in reports such as TRENDS.

If your liquidity forecast doesn’t seem to add up or looks distorted, the first place to check is always the category structure: a missing assignment, a misconfigured category (for example a wrong data sign conversion rule or a missing “Is fixed” setting), or a record still marked as “Unclassified” will directly lead to incorrect or incomplete figures in the forecast.

Categories are managed in TRESIO under the “Categories” area, which consists of three sections: Categories, Category sources, and Category mapping.

1. The three sections at a glance

The categories area is divided into three screens, accessible via the tabs above the table:

  • Categories: Shows all categories and subcategories currently used in TRESIO. This is where new categories are created, existing ones edited, and categories no longer needed are disabled or removed.
  • Category sources: Shows which category groups (for example Tresio standard categories, Swiss SME short set, Bexio) are available, their status (Enabled, Create automatically, Enabled without category creation, Disabled), and how many categories and records exist per group.
  • Category mapping: This is where classification rules are defined and managed, for example rules that automatically assign imported Bexio data to specific TRESIO categories.

2. Categories screen

The Categories screen is the central place for managing categories and subcategories in TRESIO. Here you see all active categories in a hierarchical tree structure, with the columns Category No., Category name, Accounting logic, Records count, Category source, Showing for company, and Actions.

At the core of the structure are two fixed, locked system categories: Inflows and Outflows. All other categories and subcategories are arranged underneath them, regardless of whether they come from a standard chart of accounts, an integration such as Bexio, or manual entry.

Creating a new category or subcategory

Clicking “New” opens the “Create a new entry” dialog with two columns: GENERAL and PLANNING AND FORECAST.

GENERAL

  • Category name: Name of the new (sub)category.
  • Category No.: Optional account number, for example 301.
  • Category No. format: Determines the format of the category number. Available options are No number, Swiss (for Swiss accounting standards), and Other (a flexible, format-free option for non-standard use).
  • Category parent: The parent category under which the new (sub)category is placed, selectable from the entire existing category structure (Inflows and Outflows with all their subcategories).
  • Showing for company: For accounts linked to multiple companies, this determines for which companies the category is visible.
  • Category comment: Optional field for internal notes on the category.

PLANNING AND FORECAST

  • Is fixed: See section 6 (FAQs) for the detailed explanation.
  • Data sign conversion rule: Three options: Dont convert, Always positive, Always negative. See section 6 for details.
  • Accounting logic: Five options: Assets, Liabilities, Income, Costs, No accounting account. See section 6 for details.
  • Year-end logic: Default is preselected. See section 6 for the other options.

When editing an existing category (button “Edit”), the same dialog appears under the title “Edit category”. For locked system categories such as Inflows, individual fields such as Category parent and Showing for company are not editable; a note draws attention to this (“Can’t edit parent of system category”, “System categories can’t be disabled for companies”).

Time-saving tip: Using the checkbox next to an entry, it can easily be duplicated, which speeds up building complex category structures.

3. Three ways to your own category structure

Every business needs to decide for itself which category structure best fits it. TRESIO offers three basic ways to do this, which can also be combined. All three are managed via the Category sources screen.

The Category sources screen

The Category sources screen shows all available category groups in a table with the following columns:

  • Source name: Name of the source, for example Manually entered categories, System categories, Old category migration, Data upload, Tresio standard categories, Swiss SME short set, Swiss SME extended set, Bexio Software, STRIPE Software, Exxas Software, MOCO Software.
  • Records count: How frequently categories from this group are currently used, across all companies in your account.
  • Category count: Number of categories assigned to the category group.
  • Unused category count: Categories available from the corresponding group but not yet enabled.
  • Status: Enabled, Create automatically, Enabled without category creation, or Disabled. For groups with edit rights, the status can be changed directly by clicking the pencil icon.
  • Actions: Opens a source-specific dialog via the Configure button, for example a category import for an integration such as Bexio (see Way 1), the Create categories wizard for a standard chart of accounts (see Way 2), or, for sources no longer needed, the “Remove categories” option, which removes all categories from that source at once.

Locked groups such as Manually entered categories, System categories, and Old category migration are marked with a lock icon and cannot be changed.

Way 1: Using an integration (for example Bexio)

If your account is connected to Bexio or another accounting solution, it is usually a good idea to use the categories imported from it.

Bexio customers have two import options:

Option A: Import only used accounts (recommended)

  1. Navigate to Categories → Category sources.
  2. Find the Bexio Software row and change the status to Create automatically.
  3. TRESIO will then automatically pull the relevant accounts with every invoice import. No further action is required.

Option B: Import the complete chart of accounts

  1. Navigate to Categories → Category sources.
  2. Click Configure in the Bexio Software row.
  3. The “Source Actions” dialog offers two options:
    • Import categories: Imports all accounts from Bexio into TRESIO. Existing data in TRESIO is not changed.
    • Remap categories: Allows mapping Bexio accounts to existing TRESIO categories to ensure consistency.

Important: Each category must have a unique, identical name. If you also upload your own chart of accounts or enter categories manually in addition to the integration, overlapping or differing names can cause conflicts or duplicate entries.

Way 2: Using a standard chart of accounts

Alternatively, one of the predefined category groups can be used, for example Tresio standard categories, Swiss SME short set, or Swiss SME extended set.

Clicking Configure for these groups opens the Create categories wizard:

  • The left side shows the full category structure of the selected source. Using the checkboxes, you choose which categories and subcategories to adopt. At the top, it shows how many of the available categories are currently selected (for example “Selected 51 categories from 51 available”).
  • Import levels: Determines how many parent levels are included in the import.
  • Disable current categories: Creates the newly selected categories and simultaneously disables all currently added categories.
  • Clicking “Create categories” applies the selection.

Pro tip: To simplify data entry and improve clarity, start by selecting only the essential categories. Additional categories can always be added later if needed. It’s also advisable to disable categories that aren’t used: the more categories there are to choose from, the greater the risk of accidentally selecting the wrong one when assigning a category.

The “view categories” link in the Category count or Unused category count column also opens the Source categories preview: a sortable, paginated table with Category name and Records count for each category of the selected source.

Way 3: Building a fully custom structure

If your category structure doesn’t match the suggested standard logic, you can disable all standard categories and build your category structure entirely yourself:

  1. Disable the category groups you don’t need on the Category sources screen (set status to Disabled), or remove already created categories individually on the Categories screen using the checkbox and the Delete button.
  2. Use the “New” button on the Categories screen to create your own structure, category by category, matching your business model.
  3. If you accidentally delete important categories, you can always return to one of the predefined system suggestions by re-enabling the corresponding source on the Category sources screen.

Manually created categories appear on the Categories screen with the category source “Manually entered categories”.

Important: These three ways are not mutually exclusive. Many companies combine an integration such as Bexio with individual, manually added categories, for example to reflect additional product groups or cost centers.

4. Category mapping

The Category mapping screen is used to assign or reassign already imported records (for example all invoices from Bexio) to a specific category in bulk, rather than correcting each record by hand. This is especially useful when a whole group of imported data is incorrectly categorized or not categorized at all: instead of editing every invoice or transaction individually, you adjust the rule once and apply it to all affected records at the same time.

Each rule group is named following the pattern “[data type] classification based on [source] data”, for example “Invoices classification based on BEXIO data”. Within the group, a table shows:

  • Rule: The condition used for classification, for example “data type = Bexio / Invoices” (all invoices from Bexio), with a link showing how many records the rule currently affects (for example “Selected 4 records”).
  • Replacing category: The target category to which the affected records are assigned, for example Inflows → Open invoices (inflows).
  • Enabled: Checkbox used to enable or disable the rule.

Clicking “Apply” applies the rule to all affected records at the same time (for example “for 7 records”).

5. Where categories matter

Categories are not an isolated administrative function; they run through virtually every area of TRESIO. This is why any missing or incorrect category assignment directly affects the liquidity forecast.

  • Planning: Every planning row has a category column with a searchable selection field that shows the entire category structure (Inflows and Outflows with all subcategories).
  • Invoices: Here too, every invoice is assigned via the Category column to the same category structure.
  • Transactions: Here too, every transaction is assigned via the Category column to the same category structure. Transactions not yet assigned appear as “Unclassified” and can be classified directly using the category selection field in the table.
  • HR Planning: Salary costs can be planned in two ways. Either you record them as a combined item directly via Planning with a single category for all employees together, or you use the HR Planning tool, which shows individual items such as net salary, social expenses, or other personnel costs separately per employee. In the second case, categories are especially important: clicking “Settings” opens the “Category & cost settings” dialog, where you define which categories net salaries, social expenses, and other personnel costs are assigned to. Additionally, “Add additional expenses category” lets you assign further expense types (for example 13th-month salary, commission) individually to a category. Only if these assignments are correct will the individual salary components later be reported correctly in TRENDS as well. Unassigned entries appear as “Unclassified” and will then not be reflected in TRENDS at all.
  • Loans: Loan payments can also be represented in two ways. The simplest option is to record them via Planning with a single category, for example for the entire monthly loan instalment. Anyone who wants to report every interest and repayment individually instead uses the Loans tool: in the “Loan accounting settings” dialog, for each loan (its own tab per loan name), the “Loan payments category” field determines which subcategory of Financing the loan payments are assigned to. The “Last payment categories” table shows which payment has already been assigned to which category. Here too: for every individual payment to be correctly recognized and reported in TRENDS, the corresponding separate categories must exist and be correctly assigned.
  • TRENDS: The report in TRENDS (for example in the 12-month plan) directly reflects the category structure. Every row in the plan, from Inflows and Outflows down to the deepest subcategories (for example 5 – Personnel expenses → 500 – Salary expenses → 570 – Social insurance expenses → 5700 – AHV/IV/ALV consulting), corresponds to a category. Only what is cleanly categorized and correctly assigned in Planning is shown here broken down correctly.

How detailed your categorization is remains entirely up to you: you can break income and expenses down to the level of individual products (for example a single product sold as its own subcategory), or leave it at a broad breakdown per product group. Both approaches are valid; what matters is that the chosen granularity fits your reporting needs.

For HR Planning and Loans, the level of detail needed in categories depends directly on how detailed you want to plan there: if you choose combined entry via Planning, a single category is enough. If you instead use the HR Planning or Loans tool for a granular breakdown per employee or per payment, you need a correspondingly large number of correctly assigned categories so that these items later appear individually in TRENDS as well. This care applies generally to all the areas listed above: any record left as “Unclassified” will cause that amount to be missing or incorrectly placed in TRENDS and in the liquidity forecast.

6. FAQs

What does the “Is fixed” checkbox mean when managing categories and subcategories?

Activate this checkbox if cash flows are planned in this category, which you record via Planning, but there are no invoices generated for them.

Examples: rent, salaries, loan repayments, or leasing.

Typical categories with “Is fixed” include: salaries and their related components (allowances, profit sharing, variable salaries, board of directors’ fees), rent for business premises, as well as all financing categories (Financing, Divestments, Investments, New financing, Repayment, Interest). All other categories generally generate an invoice and are accordingly not marked as “Is fixed”.

This type of cash flow is included in both planned and actual data and is therefore correctly reflected in financial analyses.

What does the data sign conversion rule mean?

The data sign conversion rule determines how positive and negative numbers are treated in financial data. You can choose from three options:

  • Dont convert: Negative numbers are treated as deductions, positive numbers as additions. This is the default behavior of most accounting systems. Since amounts can be partly positive and partly negative in this case, they must be entered manually with a plus or minus sign.
  • Always positive: All numbers are treated as positive values, regardless of their original sign. Useful in scenarios such as accounts payable, where certain systems use negative signs. TRESIO applies the sign automatically in this case.
  • Always negative: All numbers are treated as negative values, regardless of their original sign. Useful for categories where all amounts fundamentally reduce the total. Here too, TRESIO applies the sign automatically.

What does accounting logic mean?

Accounting logic defines how a category is treated in journal calculations, and determines whether the category is assigned to specific financial accounts or excluded entirely from accounting. The available options are:

  • Assets: Categories that reflect resources owned by the company.
  • Liabilities: Categories representing obligations or debts of the company.
  • Income: Categories indicating revenue-generating activities.
  • Costs: Categories reflecting expenses incurred by the company.
  • No accounting account: Categories with this setting are not included in journal entries and are used exclusively for liquidity planning.

What is the purpose of year-end logic?

Year-end logic defines how category balances are treated at the end of the fiscal year (usually December 31) when the old year is closed and a new one is opened. The available options are:

  • Default: Applies the default year-end treatment defined by TRESIO based on the category type.
  • Transfer of balance journals: Used for balance sheet categories (for example bank accounts, assets, liabilities). The previous year’s balance is carried over into the new year.
  • Opening balance journals: Used for income statement categories (for example income, expenses). The balance is reset to zero at the start of the year; amounts from the previous year are not carried into the new period.

Example: income and expenses start each year at zero in January, while bank balances keep their amount from the previous year for the carry-over.

Why are some records shown as “Unclassified”?

“Unclassified” means that a record (for example a transaction, an invoice, or a planning entry) has not yet been assigned to a category. Here’s how to fix this:

  1. Open the affected area (for example Transactions, Invoices, Planning, or HR Planning).
  2. Assign a suitable category to the entry using the category selection field directly in the table.
  3. For larger volumes of data, especially data imported from an integration, it’s also worth checking Category mapping: check whether a classification rule is missing or inactive, and add or enable it as needed.

What happens if my category structure differs from the suggested logic?

If your financial setup requires a unique category structure that doesn’t match TRESIO’s standard logic, proceed as described in section 3, Way 3: delete or disable existing categories, build your own structure, and if needed fall back on a system suggestion again via Category sources.

Need support?

Given the central importance and complexity of categories, we recommend carrying out the initial setup together with a TRESIO advisor, to ensure accuracy and avoid potential issues that could affect your data integrity in the future. Our team is happy to support you in setting up your categories, usually as part of your TRESIO onboarding. Contact us at support@tresio.ch.