Do you need to create a custom balance sheet or profit and loss statement report? Or do you need to override the values on individual lines? In this article, we will show you how to do it.
Creating a report
You can define a custom report in the Accounting - Report List menu. The reports found here are set by default and cannot be modified. However, you can create your own reports by copying existing ones.
Setting up rows
You can then configure which accounts should belong to a specific row by opening the subtotal row (e.g., P.A.IV.):
Using the Add button, you can add accounts to be included in the subtotal row, as well as modify or delete them. By checking the Invert Sign checkbox, you can ensure that, for example, a negative value is converted to a positive one:
Entering specific values
You can also change the values on the rows that will appear in the report. In this case, you need to expand a specific row (this cannot be set on a subtotal row). The account balance can then be entered on the Values tab:
Displaying the report
It is also important to note that if you have configured a custom report, you must always generate it from the Report List menu, as the Accounting - Accounting Outputs menu contains only the default print reports preconfigured in the application.
Click the Calculate button and define the rows as you would for standard reports. You can refer to the following articles for guidance on setting up rows:
You then proceed in the same way as through the Accounting - Accounting Outputs menu, selecting the period, cost center, and so on:
Next, click Calculate, and you can then print the balance sheet or income statement using the yellow printer button in the top menu:
Several reports are available here — select the one you currently need:
