Report 'Balance Sheet'

The financial report 'Balance sheet' provides an easy way for you to view and analyze the assets, equity capital and debts relating to a company/fiscal year for a particular period. The report model 'Balance Sheet', which is configured in the Power BI Settings section, forms the basis of the report.

Settings

Use the settings on the left-hand side of the form to define the contents of the report:

• The company/fiscal year you want to see details of
• The relevant periods. If you do not make a selection, the details of all periods of the company/fiscal year will be shown.
• Whether to show amounts with decimals.

Tree structure

The table shows the structure with various levels of nodes and ledger accounts, as defined in the report model 'Balance Sheet'. The columns show the opening balance sheet, the transactions and the balance sheet for each line.

Balance sheet by period

The next tab of the 'Balance Sheet' report displays the figures for every period.

Charts

The charts provide a quick way to see how the business is performing:

• The top-most chart, the balance sheet by account group, shows the transaction amount of the grouped ledger accounts, including the opening balance. This chart does require you to specify for each ledger account which group the account belongs to.
• The bottom chart shows the liquid assets over time. An account group must have been created for all ledger accounts for liquid assets, and this group must be defined in Power BI Settings.

Analyzing actual values

Use the Drillthrough option to see the origins of actual values. From a line in the balance sheet report, you can retrieve the sales orders or production orders intended for stock that the balance sheet amount is based on. This enables you to see, for example, what the work in progress in a particular ledger account consists of.

To retrieve the overview of sales orders or production orders, right-click a line and choose 'Drillthrough'. You can open the view from the following columns:

• Opening balance sheet: This shows the sales orders or production orders intended for stock that have a start date in a previous fiscal year. These orders specify the opening balance sheet.
• Transactions: This shows the sales orders or production orders intended for stock that have transactions in the current fiscal year.
• This shows the sales orders or production orders intended for stock that have transactions in previous fiscal years and/or the current fiscal year.

It is also possible to retrieve the lists grouped by sales order.

Note: The drillthrough option will retrieve the correct information for each sales order only if the amounts have been posted for individual sales orders. This means that if the opening balance has been posted as a total, drilling through to a sales order will not display the correct values. In that case, you need to specify the opening balance for each individual sales order.