Follow

Balance sheet and income statement reports (New version «Plus»)

In bexio accounting you will find the “Balance Sheet” and “Income Statement” reports in two versions: Our classic Balance Sheet and Income Statement and now also in the new «Plus» version. This means that, as a user, you can still choose which report version you would like to work with.

The differences and advantages of each version are briefly explained below.

New «Plus» version:  

New filters for account levels and account groups for more flexible analyses
Better previous-year comparisons
New quarterly comparisons or individual period comparisons
Optimized export/print format for greater clarity
New, more comprehensible calculation formula in the balance sheet
New display also shows changes as amounts
Any filters you have used are applied automatically during export

Previous version:

Saving of individual filters
Opening balance

Content


Income statement

Several filter options are available for the income statement «Plus».

Income_statement_plus.png

 

Period ①

Here you can select the exact period for which you want the income statement to be created. By default, you can select a fiscal year, YTD (beginning of the year to the current date) or you can define your own period (e.g. quarter).

 

Reference period ②

The reference period can be used optionally. Here too, you can choose between a fiscal year, YTD and an individual period. To display the comparison data, select the “Show reference period” checkbox.

The reference period allows you to view how your current fiscal year compares to the previous fiscal year. You can display the differences under “Changes in %”. If you also want to display the differences in figures, you can use the “Change as amount” display option in the «Plus» income statement.

 

Account level to be displayed ③

The account level filter provides an even more flexible analysis of the 5-level income statement. You can restrict the display to a specific account level and analyze the corresponding account groups in detail, with or without displaying the associated accounts.

 

Show 0 accounts ④

This filter allows you to display or hide all accounts and account groups with 0-values. This helps you to focus on the accounts with postings and provides a more streamlined presentation of the income statement.

 

Show all account groups ⑤

By selecting this checkbox, you can display or hide third-level account groups. The income statement can thus be displayed more or less granularly, either only up to the second account group or including the third account group.

 

Export ⑥

The income statement can be downloaded in PDF or Excel format. Any filters you have used are applied automatically during export.

Export_Income_statement_plus.png

 

5-level income statement

bexio presents your income statement with the new reports under "Early Access" in 5 levels. This allows you to easily read the most important key figures.

Gross profit

Gross profit is one of the most important key figures, especially for trading companies.

EBITDA (earnings before interest, taxes, depreciation and amortization) EBITDA is an important key figure in terms of whether a company’s operating activities cover all costs incurred and shows whether there is a functioning business activity.
EBIT (earnings before interest and taxes) EBIT is used to show the operating result regardless of the amount of taxes and the form of financing used. This key figure has now also become standard for SMEs.

Balance sheet

Several filter options are available for the balance sheet «Plus».

Balance_sheet_plus.png

 

Balance sheet per ①

Here you can select as of which key date the balance sheet data should be displayed. If you select the end of a fiscal year, the entire fiscal year will be taken into account. However, the balance sheet can also be created on any date during a fiscal year. In this case, the balance sheet includes all data from the beginning of the fiscal year to the selected date.

 

Comparative data as of ②

The “Comparative data as of” filter can be used optionally. Here too, you can select an individual closing date. To display comparative data, select the “Show comparative data” checkbox.

The comparison period allows you to compare your current fiscal year with the same closing date of the previous fiscal year and to analyze how your business is performing. You can display the differences under “Changes in %”. If you also want to display the differences in figures, use the “Change as amount” display option in the «Plus» balance sheet.

 

Account level to be displayed ③

For a more detailed analysis, you can display the assets or liabilities individually and focus the analysis on this level.

 

Show 0 accounts ④

Use this filter to display or hide all accounts and account groups with 0-values. This helps you to focus on the accounts with postings and provides a more streamlined presentation of the balance sheet.

 

Show all account groups ⑤

By selecting this checkbox, you can display or hide third-level account groups. The balance sheet can thus be displayed more or less granularly, either only up to the second account group or including the third account group.

 

Export ⑥

Balance sheets can be downloaded as PDF or Excel files. Any filters you have used are applied automatically during export.

Export_Balance_sheet_plus.png

 

New calculation formula

In the previous version, the balance sheet was displayed according to the following example: 

1100 - Trade receivables (debtors) 500
2000 - Trade accounts payable (creditors) -300
Profit -200

 

For better readability, the liabilities in the new «Plus» balance sheet are displayed with a positive balance, as shown in the following example:

1100 - Trade receivables (debtors) 500
2000 - Trade accounts payable (creditors) 300
Profit 200

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request