In NextGen: Reporting > Management board
In Classic Design: Controlling > Management Board
The Management board contains a range of statistics concerning sales orders and purchase orders, the financial data and cashflow of your company, the liquidity of your company, as well as statistics concerning sales orders vs. offers.
For the Management board to be filled with your data, you have to activate the process starter Umsatzstatistik. You can find out more about process starters and how to configure them in the article Process starters.
Only documents that have been approved are included in the statistics. Documents in draft mode are not included.
The Management board contains 4 tabs showing you the following information:
-
Finance/ cash flow
-
Liquidity
-
Orders
-
Offers/ orders
The finance/ cash flow tab consists of two areas, the Monitor and the Live monitor liquidity area.
The Monitor gives you an overview of your sales data while the Live monitor liquidity gives you some key statistics of your current financial data.
Your sales data is displayed as two graphs in the Monitor section. The upper graph displays your monthly net figures for offers, orders, invoices, and credit notes for a 12 months period while the lower graph displays the cumulative net numbers per month for that time frame.
Note
All invoices created are taken into account when creating the statistics, not only paid invoices.
The graphs offer the following functionalities:
-
The graphs always display the current year but you can select any year you want to analyze by selecting it from the Year drop-down and clicking load.
-
If you want to compare the sales statistics between years, select a year from the Year drop-down and the year you want to compare it with from the Reference year drop-down and click load.
-
You can hide the graph for a certain statistic, for example offers, by clicking on the relevant symbol above the graph.
You can hide as many different statistic items as you want. By clicking on the item a second time, it will be displayed in the graph again.
-
You can display your yearly statistics by project. For that select the relevant year from the Year drop-down, search for the required project in the Project field and click load.
On the right in the Finance/ cash flow tab you can find a table giving you some key figures to evaluate your company's current financial situation and cashflow.
Below all the fields in the table are described.
|
Field |
Description |
|---|---|
|
Open invoices (gross) |
The sum off all invoices that have not yet been paid. |
|
Open liabilities (gross) |
Sum of all liabilities that have the status Offen (open) |
|
Open orders (net) |
Net sum of all approved but not yet delivered orders based on the following calculation: Item quantities * price - discounts. |
|
Dunning (gross) |
Total amount (gross) of all invoices that are in the dunning process, meaning invoices that have not been paid and at least one reminder has been sent. |
|
Field |
Description |
|---|---|
|
Invoice/ credit note (net) |
Sum of all net invoices minus credit note nets for the current month, last month, or the month before respectively. |
|
Liabilities (gross) |
Sum of all liabilities for the current month, last month, or next to last month respectively. |
|
Chart of accounts expenses (gross) |
Debit sum minus the credit sum imported with the bank statements for all postings assigned the type expenses in the chart of accounts for the current month, last month, or next to last month respectively. |
|
Bank account balance (gross) |
Debit sum minus the credit sum imported with the bank statements for the current month, last month, or next to last month respectively. |
You can use these figures to compare specific key performance indicators (KPIs) over three months. This might help you derive a trend in specific areas to act accordingly.
|
Field |
Description |
|---|---|
|
Number of orders |
Number of sales orders created in the current month. Only approved orders are included. |
|
Revenue (net) |
Net revenue based on authorized sales orders. |
|
CM (net) in EUR |
Contribution margin in euro net based on authorized sales orders. |
|
CM in % |
Contribution margin in percent net based on authorized sales orders. |
|
Field |
Description |
|---|---|
|
Current month |
Sum of all work hours tracked by employees in the current month. |
|
Last month |
Sum of all work hours tracked by employees in the last month. |
|
Current month's orders |
Sum of all work hours tracked by employees in the current month that can be invoiced. |
|
Last month settlement |
Sum of all work hours tracked by employees in the last month that can be invoiced. |
|
Field |
Description |
|---|---|
|
Subscription run next month |
Sum of all subscriptions of the coming month. To get a result here, the Subscription run/ subscription system module (App Center > Sales) must be active. If not, this field shows the value 0. |
|
Account balance total |
Total sum of all bank account statements linked in Xentral via a business account. Condition: The Sum up check box in the business account is selected. |
Legacy module
The module described in this article section has been marked as a legacy module. This means the following:
-
We don't create new features for this module or fix any bugs.
-
The module is not available anymore in Xentral instances (demo or licensed) created after 28-Sep-2022. If you as a new user have special requirements that could only be fulfilled by this module, please contact our customer support team to discuss a solution.
For more information, see also Why is Xentral deprecating some modules (Legacy modules) and what does this mean for you?
In the Liquidity tab, you get a time frame-specific overview of the following:
-
Invoices
-
Orders without invoices
-
Credit notes
-
Liabilities without purchase order
-
Orders
-
Other costs
To analyze this data:
-
In the Overview sub-tab select the time frame you want to analyze by clicking the relevant button above the calendar. You can display your data per month, week, or day.
-
In the Receipts section select the document type(s) you want to display for the selected time frame.
The selected documents created during the time frame are displayed item by item per each calendar day.
By selecting Group costs only the summary amount per document type is displayed for each day. Liabilities cannot be grouped.
You can use the Other costs sub-tab to create new cost entries. For that click +Create a new entry and enter or select the following: Designation, Type (that is how often the cost occurs), Date, and Amount. Click Save. The new cost entry is displayed both in the Other costs sub-tab as well as in the calendar in the Overview sub-tab.
Please note the following in relation to liabilities:
-
Orders are planned with their order's dates until a liability is created. After that the invoice date is used for planning purposes. If a target payment date has been entered, this will be used.
-
Orders are shown as Orders without invoice until an invoice was created. Until the invoice is created, the delivery date or default payment target is used.
-
Orders are planned with their relevant target payment date.
In the Orders tab you can find six different graphs/ charts displaying the following information:
|
Total order quantity graph |
This graph shows the amount of sales orders created for each day (green line) as well as the net revenue generated by these orders (blue line) for the displayed time frame. X-axis: Date Y-axis (left side): Amount of orders created Y-axis (right side): Net revenue generated by the sales orders By clicking on any point in the green or blue line, the values relevant for the selected date are displayed. You can hide the amount of orders or sales value generated by clicking on Number or Revenue above the table. |
|
Orders graph |
The orders graph contains the statistics for your purchase orders. You read it in the same way as the Total order quantity graph, just that it pertains to purchase orders and net costs instead of sales orders and net revenue. |
|
Sales orders per project per yearchart |
This chart displays the net sales per project per year. The color in which a project is displayed in the chart can be changed under Projects > Open project > Settings tab > General section > Color field. |
|
Sales orders per project per month chart |
This chart displays the net sales per project per month. The color in which a project is displayed in the chart can be changed under Projects > Open project > Settings tab > General section > Color field. |
|
Employee chart |
This chart shows the share of employees per project in percent. Basis is the main project in the master data. The color in which a project is displayed in the chart can be changed under Projects > Open project > Settings tab > General section > Color field. |
|
Top 5 products (in last 90 days) chart |
This chart shows the top five bestselling products in the past 90 days. |
The Offers/ orders tab shows a graphical summary in the form of cumulative net amounts for the following document types:
-
Offers
-
Orders
-
Invoices
-
Credit notes
You can hide a certain document type from the graph by clicking on the relevant document type above the table.