Reports, evaluations, statistics

Tutorial: The reports part of CashCtrl allows evaluating accounting data, sales statistics and custom formulas.

Content

1. Report collection

Individual report collections can be compiled under "Reports". Create a new collection via Add report collection. Subsequently, various reports can be added to the collection via Add.

The collection must be given a name such as "Sales statistics", a title text, location and responsible person can be defined. There are also display options for logo, header, footer, title and period.

The format can be selected in the dropdown menu at Size, e.g. A4 landscape (A4R) or A3 can be selected.

Screenshot of the configuration of a report collection

2. Add report to collection

Several reports can be added to the collection, e.g. "Revenue by customer", "Expense" by "Suppliers", and so on. To do this, select the collection and add the desired report to the collection at the top via Add .

Each report has individual options and the possibility to add a title and a description text. Useful if the reports are to be shared.

Screenshot CashCtrl Reports Add Dropdown Menu

3. Arranging / moving reports

Reports and report collection can be arranged as desired. They can be moved using drag & drop, i.e. click on the element, hold the mouse button and release it again at the desired location where the dashed line appears

Reports can be moved within a collection or into another collection. It is also possible to drag a report out of a collection and place it under All reports below the report collections.

The order of the report collections can also be adjusted the same way.

Screenshot of arranging / moving a report within a collection

4. Set time period

The evaluated period of the reports can be displayed independently of the fiscal period. On the right side at the top, a period can be selected, e.g. 2025 / Q2, and all reports will use this period. Next to it, the language of the report can be changed.

Screenshot dropdown menu Select period in reports

5. Configure report/ add text

The Edit button at the top or directly at the report opens the dialog. Here, in the Configuration tab, different options can be selected depending on the report, such as displaying the time period in the title, etc.

In the Text tab, an accompanying text can be created for the respective report.

Screenshot of the configuration of a report

6. Customize columns

In the Edit dialog of the report switch to the Columns tab. Here you can add, copy, move or remove columns. The order of the columns can be adjusted via drag&drop.

Via Reset the default columns in the respective report are restored.

Screenshot of the configuration of a report with the columns tab, where columns can be added, deleted and moved.

7. Using formulas with the formula column

The formula column is used to calculate individual key figures. It is available in all tabular reports, but not in graphical reports such as the pie chart.

Via Add Custom a new, custom column is created. Here a title can be defined for it as well as a placeholder to use the value of this column in another formula column as a placeholder.

In the Calculation field, the following operators + - / * can be used to perform the basic arithmetic operations. Use to show the drop-down menu for further calculation operators as well as to choose columns / custom fields.

This column is suitable, for example, to create a column for the margin or other calculations.

Screenshot of the configuration of a report with the addition of a custom column with a custom calculation

8. Export reports

Finally, the compilation can be exported as PDF or exported as Excel / CSV file (CashCtrl PRO). This is easily done using the corresponding buttons above the report (PDF, Excel, CSV).

Depending on which report is selected, only a single report is exported or the entire collection with all the reports it contains.