XBRL Report Switzerland (eBilanz) [TEST]

In this article

    XBRL Report Switzerland (eBilanz) [TEST]

    XBRL Report Switzerland (eBilanz) [TEST]

    Productivity
    Switzerland

    Important: The extension for generating Swiss XBRL instances (eBilanz) is currently under development and testing and has not yet been released for public use. Please do not use this extension yet.

    This document is Work in Progress

    Introduction

    This guide explains how to use the XBRL Report Switzerland extension to prepare an XBRL CH report from a Banana Accounting file.

    The process consists of three phases:

    1. Map the accounts in the operational chart of accounts to the corresponding XBRL CH taxonomy concepts.
    2. Complete the entity, reporting-period, profit-allocation and notes information required for the report.
    3. Review the generated reports and validation results before generating the XBRL CH file.

    The extension is currently available for testing and is not intended for production use or official filing.

    Before running the extension

    Prerequisites

    • Download and install Banana Accounting+ Dev Channel (Version 10.2.10 or later).
    • Have the Advanced Plan of Banana Accounting Plus.

    Installing and using the extension

    • Install the [DEV] Schweizer eBilanz (XBRL) extension. 
    • Visit the Extensions Management documentation to learn how to install the extension.
    • Once installed, the extension will be visible in the Extensions menu where it can be run.

    Supported legal forms

    The legal forms currently supported by this extension are:

    • Company limited by shares.
    • The Limited Liability Company.
    • Associations.
    • Foundations.

    Extension status

    ItemCurrent support
    Extension version1.0
    Extension statusTest
    Banana Accounting version10.2.10 or later
    Supported taxonomyCH Taxonomy 2025
    Supported reporting period2025
    Official filingNot supported
    Type of accounting supported
    • Double  entry without VAT and without foreign currencies.
    • Double  entry with VAT.
    • Double  entry with foreign currencies.
    • Double  entry with VAT and foreign currencies.

    XBRL CH report and XBRL Mapping Reference

    Two elements are important for understanding the process:

    • XBRL CH report.
    • XBRL Mapping Reference.

    XBRL CH report

    The XBRL CH taxonomy defines the concepts, relationships, rules, and information structures used for Swiss financial and tax reporting. For further information, see: 

    XBRL Mapping Reference

    The extension uses the Swiss SME chart of accounts as the reference structure for this process. For the mapping rules, account ranges, XBRL tags, and sign handling, see:

     

    Workflow for creating the XBRL CH file

    PhaseWhat you doResult
    A – Account mappingAssociate accounting accounts with XBRL CH taxonomy concepts.Complete mapping without unresolved accounts.
    B – Creating instance XBRL CH fileEnter and review entity, period, allocation and notes information.Report data ready for review.
    C – Reviewing and Generating XBRL CH fileReview previews and verification reports, then generate the XML file.XBRL CH report generated for testing.

    Account mapping

    Introduction

    Account mapping is the first step of the XBRL CH process.

    The operating accounts of your chart of accounts need to be linked to the corresponding XBRL CH taxonomy concepts, so that the amounts can be calculated and related to each other when generating the reports for the XBRL CH file.

    Without this mapping, the XBRL CH file cannot be created.

    Phase A - Account mapping

    To perform the account mapping, follow these steps:

    1. Open the accounting document with the year-end closed accounts. Before proceeding, make sure that the company's registration details have been entered and that the accounting period matches the one currently supported by the XBRL CH file (currently, 2025 accounting data).

    Check the period of accounting

    1. Go to the "Extensions" menu, select "[DEV] Swiss Electronic Balance Sheet XBRL", the click "[DEV] 1. Account Mapping...".
    • This process processes the operating accounts in the open document, identifying those linked to the SME chart of accounts, so they can be matched to the chart of accounts required by the XBRL CH standard.

    Swiss eBalance Mapping Dialog

    1. The "Swiss eBalance Mapping" dialog opens, showing a table with the operating chart of accounts and the proposed matches to the XBRL CH taxonomy concepts. Review the proposed mappings between your operating accounts and the XBRL CH taxonomy concepts, and correct any proposed mapping that does not reflect the nature of the account.

    The table shows 6 columns:

    ColumnWhat it indicates
    AccountYour operating account number
    DescriptionThe name of the account
    SME Ref.The SME chart of accounts reference used by the extension to determine the corresponding XBRL CH taxonomy concept. Select an appropriate reference here to complete a missing mapping or correct a proposed one
    XBRL DebitThe XBRL element to map the account/group to when its balance is Debit, as defined by the XBRL CH taxonomy
    XBRL CreditThe XBRL element to map the account/group to when its balance is Credit, as defined by the XBRL CH taxonomy
    XBRL StatusWhether the operating account of the row has been matched to an XBRL concept: "mapped" or "unmapped". Accounts the extension cannot automatically match will show "unmapped"
    1. Complete the missing mappings and correct any proposed mappings that are inaccurate.
    • Check that all accounts required for the report are mapped correctly and that no relevant account remains Unmapped.
    • Once this check is complete, you can continue to Phase B - Creating instance XBRL CH file.

    Creating, reviewing and generating

    Phase B - Creating instance XBRL CH file

    Once the mapping between the operating accounts and the reporting concepts has been validated, you can proceed to complete the information required for the report. To do so:

    1. Open the menu for the document on which the mapping was performed.
    2. Select "[DEV] Swiss Electronic Balance Sheet XBRL" → "2. [DEV] Create Electronic Balance Sheet.".
    3. The Swiss eBalance Report dialog opens four sections.
      1. General.
      2. Company information.
      3. Allocation of profits.
      4. Notes.

    General

    Swiss eBalance dialog General info

    This section shows:

    • The taxonomy version used to export the accounting data in XBRL format.
    • The accounting reference period, which must match the fiscal year of the document.

    This section also lets you choose the output type to generate (Print preview or XML file) — see Phase C for details on each option.

    Company information

    Swiss eBalance dialog Company information

    Company data is partly retrieved automatically from the accounting document's information - specifically, the data entered via the main menu:

    • File→File Properties (basic data)→Accounting and Address.

    In particular, the following data is retrieved:

    • Company name.
    • Address.
    • City/Town.
    • Postal code.
    • Country.
    • Currency.

    UID

    • The UID number must be entered manually by the user.
    • The UID number is a unique identifier assigned to every active company, in the standard format CHE-XXX.XXX.XXX.
    • It consists of nine digits preceded by the country prefix.
    • For further details, please refer to the official page of Swiss Confederation - Federal Statistical Office: Enterprise Identification Number UID.
    • To verify your UID number, you can consult official page of Swiss Confederation - Federal Statistical Office: UID register.

    Legal forms

    • A field for the company's legal form is also included, to be selected manually from a drop-down menu.
    • Unlike the other company data, this field is not retrieved automatically from the accounting document.
    • You must select the legal form matching your company from those currently supported by the XBRL CH:
      • Company limited by shares.
      • The Limited Liability Company.
      • Associations.
      • Foundations.

    Allocation of profits

    Swiss eBalance dialog Allocation of Profits

    This section allows you to set the allocation of profit across:

    1. Legal reserves.
    2. Optional reserves.
    3. Dividends.
    4. Other allocations.

    The allocation can be entered either as an absolute amount, i.e. a specific figure, or as a percentage of profit to be assigned to each individual item.

    This section also shows the profit carried forward at the beginning and end of the fiscal year, the profit available for allocation, and the resulting amount of profit remaining after entering the allocation amounts or percentages.

    Entering the profit allocation does not automatically generate an accounting entry to validate it. This means that, after entering the allocations, the corresponding accounting entries must be recorded manually in the document to reflect the decided profit distribution.

    If the profit allocation has already been decided beforehand and the relevant accounting entries have already been recorded, then in this section you will need to verify that values entered exactly match those already recorded in the accounts.

    Notes to Statement of Financial Statement

    Swiss eBalance dialog Notes

    To manage the notes, reference is made to the content of the Documents table.

    The Documents table must be created within the accounting document.

    To add it, go to the main menu:

    • Tools → Add/Remove Functionalities...
    • Then select Add Document Table

    A new documents table is then created.

    Documents table

    Table Documents with Notes

    The table consists of three columns:

    1. Id.
    2. Description.
    3. Attachments.

    Id

    • The name of attached document. The Id is free text, but should be unique within the table.
    • For clarity, it is recommended to adopt an identifying prefix (for example attachment_) for attachments related to the XBRL electronic balance sheet. However this is simply a suggested convention for explanatory purposes, not a binding rule recognized or automatically interpreted by the extension.

    Description

    • Describes the content of the document (what the document represents).

    Attachments

    Contains the actual content of the attachment.

    To insert an attachment:

    • Click the corresponding cell in the "Attachments" column and set the cell format to text/html.
    • Once this setting is confirmed, the attachment's content can be edited directly by clicking the button inside the cell that allows you to type within the attachment editing dialog.

    Phase C - Reviewing and Generating XBRL CH file

    The desired output is defined in the Swiss eBalance Report window, in the first compilation section General within Output group.

    OutputPurpose
    Print previewVisual preview of the generated XBRL CH documents
    Print preview with verification reportPreview with account-by-account mapping detail and related amounts
    XML fileGeneration of the XML file for testing and verification

    Print preview

    Swiss eBalance dialog print preview

    The primary purpose is to enable a visual review of what is presented in XBRL CH tax-relevant documents.

    This feature displays a preview of the fiscal accounting documents such as:

    1. Statement of Financial Position.
    2. Statement of Income.
    3. Allocation of Profit.
    4. Notes to Statement of Financial Statement.

    All items shown are those correctly mapped to the reporting concepts.

    If a fiscal accounting document or a specific item does not appear, this is due to the mapping between the XBRL CH accounts and those used in the accounting document: in other words, accounts not mapped to the XBRL CH accounts are not displayed. To identify these cases, dedicated error messages indicate which accounts are not correctly matched to the XBRL CH accounts.

    A preview of the following documents will be available, as shown in the example screenshots below.

    Statement of Financial Position preview

    Statement of Financial Position preview

    Statement of Income preview Statement of Income preview

    Allocation of profit preview Allocation of profit preview

    Print preview with verification report

    With the Print preview function combined with verification report flag, a print preview of the tax reports is generated, including:

    • Additional details on the associations between operating accounts and XBRL CH accounts.
    • As well as the amounts associated with each XBRL CH account.

    For each XBRL account entry, the corresponding operating account and its amount are shown alongside it.

    The purpose of this feature is:

    • Verify the mapping status of accounts.
    • Their related amounts.
    • Making it possible to identify any necessary corrections.
    • Anticipate the results arising from the mapping between operating accounts and XBRL CH accounts.

    Print preview with verification report

    Print preview with verification report - Balance Sheet - 1/2

    Print preview with verification report

    Print preview with verification report - Balance Sheet - 2/2

    Print preview with verification report

    As shown in the screenshot above, for each main account the corresponding main XML tag of the XBRL CH file is displayed. Below it, within the subgroup of the main account, the operating accounts linked to that grouping appear, along with their account number and amount.

    If calculation errors occur with respect to the XBRL CH accounting logic, they are flagged in red text at the bottom of the report:

    • Indicating which error occurred and its implications.

    For example, in the case shown here:

    • Using fictitious data for demonstration purposes.
    • An error is flagged regarding the balance sheet.
      • Since the assets do not equal the sum of liabilities and equity.

    XML file

    This feature generates an XBRL CH XML file for testing and verification purposes.

    Before proceeding with this option, it is strongly recommended to carry out a review using the Print preview function, to make sure that:

    1. All operating accounts are correctly matched to those defined by XBRL CH;
    2. The structure of the XBRL CH documents is correct from an accounting and tax perspective;
    3. The amounts are correct;
    4. The classification of accounts between XBRL CH and operating accounts has been carried out correctly;
    5. The entered company and tax data are correct.