Financial reports
The Financial reports tab shows various options for printing financial reports. Depending on the selected criteria and the report type, the program displays the company's balance sheet information.
The window can be divided into two parts:
- Printout type (report type) – On the left side, there is a list of all the available financial reports in the program.
- Criteria – On the right side, there are the criteria fields used to define the data that will be displayed in the report.
|
1. Printout type
Select the form on which the calculated data should be displayed. By clicking the name of the report, you can also print it.
The following reports are available:
1. Financial report
Financial report – A standard financial report (balance sheet) with values for the current period. Date ranges for the comparative period cannot be selected for this format, because they are not used in this report.
Comparative financial report – A financial report showing the value in the comparative period (e.g. the previous year) and the balance of the difference between the two periods. Date ranges of the comparative period can be selected here, but only for a financial report template with the column filling mode "Comparison of periods".
2. Financial reports by period
Financial reports by period – month – The data is displayed separately by calendar month. Date ranges for the comparative period cannot be selected for this format, because they are not used in this report.
Financial reports by period – quarter – The data is displayed separately by quarter. Date ranges for the comparative period cannot be selected for this format, because they are not used in this report.
Financial reports by period – half-year – The data is displayed separately by half-year. Date ranges for the comparative period cannot be selected for this format, because they are not used in this report.
The first and second reports are used for AJPES statutory financial reports, while the others are used for control reports or internal reporting purposes.
3. Financial reports by department
These types of reports display the data for the individual departments as it appears in journal entry lines, which are included in the report based on the criteria selected. If a department is not recorded on a particular journal entry, that journal entry is displayed in the first of the financial reports intended for records without a specific department.
Depending on the selected financial report setting, only the financial reports for the departments showing turnover or balance on the lines included in the financial report for the selected period are printed (if no constants are used in the template; for more information, see section 5. Financial reports by department and cost center).
4. Financial reports by cost center
These types of reports display the data for each cost center as it appears in journal entry lines, which are included in the report based on the criteria selected. If a cost center is not recorded on a particular journal entry, that journal entry is displayed in the first of the financial reports intended for records without a specific cost center.
Depending on the selected financial report setting, only the financial reports for the cost centers showing turnover or balance on the lines included in the financial report for the selected period are printed (if no constants are used in the template; for more information, see section 5. Financial reports by department and cost center).
5. Financial reports by department and cost center
These types of reports provide insight into the combination of departments and cost centers. This means that you can display the data for each of the recorded combinations of department and cost center. These reports therefore combine the features of both report types – by department and by cost center.
6. Financial reports by year
These types of reports provide insight into data over a period of time longer than one year. Such a report can be created for periods longer than one year and shorter than or equal to four years. The data for an individual fiscal year is displayed in columns.
7. Print to preprinted form
A special branch of reports on financial reports (AJPES financial reports) has been added. It is important that the data in the table of this report is comparable to the reports in the AJPES files. The reports have been added to provide a better overview and simplify the work of users when comparing the company's and AJPES financial reports.
8. By departments – landscape
In this report, lines are displayed horizontally by department, compared to the By department format where they are displayed consecutively. It is recommended to use this format if you are using up to approximately 12 departments.
9. List of financial report formulas
Financial report formats – Shows the line names and their calculation formulas (used when checking the settings of the calculation formulas). No criteria can be defined for this report type, which is why only a button to view the settings is displayed.
2. Criteria
|
Financial report type
|
From the drop-down list, you can select a different type of financial report without changing any settings.
|
|
Document Type
|
Select the document type for journal entries (general journal) for which you want to create a report. Record-only document types are not listed. The year-end journal entry is not selected here by default.
|
|
Account
|
The financial report can be limited to display data for a single account.
|
|
Subject
|
The financial report can be limited to display data for a single subject (customer, supplier, etc.).
|
|
Department
|
The financial report can be limited to display data for a single organizational unit (filtering the data from journal entries).
|
| Cost center |
The financial report can be limited to display data for a single cost center (filtering the data from journal entries). |
| For currency |
The report can be limited to the currency in which the journal entry was made (blank = applies to all currencies). The report is created in EUR value of the journal entry entered in the selected foreign currency at the exchange rate of the posted document. |
| To currency |
You can choose to display your financial report in any currency. For the conversion of values to a foreign currency, the program uses any exchange rate you choose before creating the report. By default, the Bank of Slovenia average exchange rate is used, as selected in Administration Panel | Settings | Company. |
| Period from |
Limit the calculation to the start date of the period (from the journal entry header) – for the current period.
This is the only relevant and necessary criterion for annual financial reports.
|
| To |
Limit the calculation to the end date of the period (from the journal entry header) – for the current period.
This is the only relevant and necessary criterion for annual financial reports. |
| Period (Date2) from |
The second date range of the current period to be used for financial report lines that have the D.2 radio button selected (activated) for the use of the second date range (see the chapter Lines in Financial Reports). For a use case, see the chapter Using Different Date in Displaying Financial Reports. |