Accounting reports are central financial documents for businesses of all sizes – in simple terms, a structured summary of your company’s financial movements, presented so you can see at a glance where you stand. Typical examples include the income statement (shows whether a company is making a profit or a loss) or the balance sheet (shows what a company owns and what it owes).
In TRESIO, you can build these reports directly from your accounting data – fully customizable to your chart of accounts. That means: no manual Excel spreadsheets, no copy-pasting from your accounting software. TRESIO calculates the values automatically as soon as the data is available.
Typical use cases include monthly controlling, preparing figures for management meetings, communication with your tax advisor, or reporting to investors and banks. Reports can also be set up with a comparison period, so you can immediately see how figures have changed compared to the previous period – in absolute and percentage terms.
Where does the data come from?
All values in an accounting report are based on journal data. Journal data consists of the individual booking entries from your accounting – every payment, every expense, every revenue is recorded as an entry, assigned a date, and posted to accounts.
This data enters TRESIO in two ways:
- Import – e.g. automatically via a connection to Bexio. Bookings are synchronized directly from your accounting software.
- Manual – entries can be entered directly in TRESIO, for example for planning or scenarios.
Once journal data is available, TRESIO can automatically calculate the values for your reports. For more information on journal data and how to manage it, please refer to the corresponding article: Accounting Journal
How to create a predefined accounting report
Predefined reports provide a practical starting point with a typical structure that can be used directly or customized as needed.
To create a predefined accounting report, click + New in the tab bar at the top.

A new popup window appears where you can select a report from the system report library, or create your own report from scratch by selecting “Blank accounting report”.

For example, if you select “Swiss income statement” from the report library, the system will show you a preview of the report along with a short description. Clicking Create opens the report in a separate tab in view mode – the values are automatically calculated from your existing journal data.
For the newly created report, you can optionally add a comparison period to compare key figures from different time periods. Additional checkboxes allow you to activate the display of the absolute difference as well as the percentage difference.

Note: Predefined reports are templates – they serve as a starting point but are not tailored to every company. Since chart of accounts structures and formulas vary by company, you should check after creating the report whether the stored formulas and categories are correct. In some cases it is worth building a report from scratch – this gives you full control over which data flows in where.
How to create a blank accounting report
If you want to build a report completely from scratch, click + New, select Blank accounting report from the library, and click Create.
The blank report opens directly in edit mode. To add entries, click + New. In the row that appears, set the following fields:
- Type – Header or Income statement
- Text string – the display text in the report
- Position – alignment (Left, Center, Tab 1, etc.)
- Style – Simple or Bold
- Measurement – Currency or Percent
Click Create to add the entry to the table.gefügt.

How to edit an accounting report
Accounting reports have a view mode and an edit mode, so you can preview or make changes. Use the Edit and View buttons in the top right to switch between modes.
Clicking Edit opens the edit mode. In this screen you can customize the report: add new content, show or hide existing elements, copy, edit, or delete entries.

IIn edit mode you will see a table with all entries in the report. The columns are:
| Column | Meaning |
|---|---|
| ☰ (three lines) | Drag handle – move entries up or down via drag-and-drop |
| Index | Current order of entries |
| Type | Entry type (Header or Income statement) |
| Text string | Display text in the report |
| Position | Alignment (Left, Right, Center, Tab 1, etc.) |
| Style | Simple or Bold |
| Measurement | Display format (e.g. Percent or Currency) |
| Skip zeros | Whether rows with a value of 0 are hidden |
Using the edit icons on the right side, headers can be removed, duplicated, or hidden from the report view. Income statement entries have the same options but can additionally be edited (pencil icon).
Report header and footer with template variables
At the bottom of the edit mode you will find fields for Report header (appears at the top of the report) and Report footer (appears at the bottom). These fields can be filled in freely – additionally, two template variables are available that are automatically replaced with the current value when viewing or exporting:
{{company_name}}– automatically replaced with the current company name{{current_date}}– automatically replaced with the current date
For example, you can enter {{current_date}} – Confidential in the footer – when exported, the current date will appear automatically without having to update it manually each time.


Renaming and reordering reports
When a report is in edit mode, you can rename it using the pencil icon next to the report name, and change the order of reports using the arrow icons.

Editing the content of an accounting entry (formulas and variables)
Every entry of the type “Income statement” contains a formula that determines how the displayed value is calculated. In simple terms: you define which accounts are added or subtracted – and TRESIO automatically calculates the value from your journal data.
To edit an accounting entry, click the pencil icon. A new popup window appears with the following fields:
- Name – the label of the entry as it appears in the report
- Calculation formula – the currently applied formula (e.g.
A - Bor(A - B) / C). To change the formula, simply select a different one from the dropdown list. - Measurement – display format of the result (Percent or Currency)
- Variable table – shows which variables (A, B, C …) are used in the formula, with details on Source, Year, Quarter, Month, and Calculation mode
- Disable pre-calculate – checkbox to turn off the preview calculation (useful for large data sets)
Example: An entry “Operating income from deliveries and services” uses the formula A. In the variable table you can see that variable A has the source “Journal” – it is therefore calculated directly from the journal data. (Image 6 from your screenshots)

Editing formula variables
To edit formula variables, click the pencil icon next to the variable (e.g. A). This defines where the data for this variable comes from.
Two options are available as data source (Image 8 from your screenshots):
- Journal – the variable is calculated directly from the journal data. You also select the category selection (Image 9 from your screenshots):
- Manual – you select the desired accounts/categories individually from a list. The list shows how often each category is used on an annual, quarterly, and monthly basis in your journal data.
- Swiss number mask – you enter a number mask (e.g.
34xxx...359xxx), which automatically selects the matching accounts from the Swiss chart of accounts.
- Metric – the variable is based on a pre-calculated key figure from the Metrics Library. This is useful when the same key figure is needed in multiple reports – the formula only needs to be maintained once.
At the bottom, a results preview (Year / Quarter / Month) of the current selection is shown. Click Save to update the variable.

Important: After every adjustment, check which categories are stored in the variable. A common mistake is that incorrect or too many accounts are unintentionally included in the calculation – causing a value to show 0 or appear unexpectedly high.
Metrics Library
The Metrics Library is a central collection of all pre-calculated key figures for your company. It is accessible via the left navigation under Accounting Journal → Metrics Library.

Each metric belongs to a group (e.g. “Swiss income statement” or “Individual KPI”) and has an assigned measurement (Percent or Currency). Metrics can be used as a data source for variables in any number of reports – meaning a formula only needs to be defined once and is available identically everywhere.
New metrics can be created via + Add calculated KPI.
For more information on the Metrics Library, click here.
Managing and exporting reports
In addition to creating and editing, several further functions are available to help you manage your reports efficiently.

Duplicating entries
To use an existing entry as a template for a new one, click the duplicate icon. In the new entry you can then adjust the following fields: Type (Header or Income statement entry), Text string (entry name), Position, Style, and Measurement (Currency, Company currency, Number, or Percent – Image 10 from your screenshots). Click Create to add the new entry to the end of the table.
Exporting reports
Finished reports can be exported from TRESIO – for example to share with your tax advisor, prepare for an investor update, or use internally in a presentation.
In view mode, click Export in the top right. Two formats are available:
- Export XLS – opens the report in Excel. Ideal if you want to further process, annotate, or insert the figures into an existing template.
- Export CSV – a simple table format suitable for importing into other tools or systems.
The export contains the data as displayed in the current view mode – including any comparison periods and differences.

Removing a report
To remove a report, click Remove – the entire report tab will be deleted. The button is available in both view mode and edit mode.
Resetting a template
If you have modified a predefined report and want to return to the original version, click Reset template.
Common mistake: variables not checked
When creating or customizing a report, it is important to check the variables of each entry. A common mistake is not verifying which categories are stored in the variables – and therefore which values are actually being added together. If a value shows 0 or appears unexpectedly high, it is worth checking the category selection in the affected variables.