Financial Statement Report
By selecting a corresponding ID of financial report template (from the menu or taskbar of settings of financial statement) you open a panel for entering of criteria to display financial reports:
 |
Since different reports are calculated with different date and other criteria as well as being shown in different reports you are recommended to save them as templates. Templates are linked to a specific financial report format which makes work with templates easier. |
|
Financial reports that are used more frequently you can assign a shortcut in the toolbar! |
| Report type |
You can select a form on which the calculated data shall eb displayed. By double-clicking the name of report or by clicking the report button you can display it.There is available:
1. Financial report
- Financial report– typical financial report with amounts of the current period. With this form of display there are no date margins available since they are not used in this report.
- Comparative financial report– Financial report showing the amounts in the comparative period (e.g. previous year) as well as balance of the difference between both periods. Date margins are available only with this type of report yet only if financial report template in question has a method of filling columns Period comparison.
Financial reports by periods:
- Financial report by months– data are displayed separately by calendar months. With this form of display there are no date margins available since they are not used in this report.
- Financial report by quarters – data are displayed separately by quarters. With this form of display there are no date margins available since they are not used in this report.
- Financial report by half-year - data are displayed separately by half-year. With this form of display there are no date margins available since they are not used in this report.
The first and second type of reports are used for AJPES financial reports and others are designated as validation reports or rather internal reporting.
This type of reports show reports by individual departments as they are shown in posting items that have been included in the report by the selected criteria. If department has not been posted such post appears in the first financial report that is designated for reports with no specified department.
Only financial reports of departments that include items with transactions or balance in the selected period are displayed according to the selected financial report setting (if constants are not used in the template - for more detailed treatment see Financial reports by departments and/or cost drivers).
This type of reports show reports by individual cost drivers as they are shown in posting items that have been included in the report by selected criteria. If cost driver has not been posted such post appears in the first financial report that is designated for reports with no specified cost driver.
Only financial reports of cost drivers that include items with transactions or balance in the selected period are displayed according to the selected financial report setting (if constants are not used in the template - for more detailed treatment see Financial reports by departments and/or cost drivers).
This type of reports enables you to view data on department and cost driver combination. Thus financial reports are shown for each posted combination of department nad cost driver. Hence these reports combine characteristics of reports by departments and those by cost drivers.
5. List of financial report formulas
- Financial report types– is a list ot item names and formulas used in their calculation (used in the control settings for calculation formulas). Thus no criteria are available in this report type, however, only the button to view settings.
|
| Document types |
You may select document types for journal entries (general journals) that you want to prepare the report for. Document types for the record are not included in the list! Journal entry for year-end also is not selected here by default. |
| Account |
Financial reports may be restricted by individual account or more than one account by using multi select key  . |
| For currency |
Financial reports may be restricted by currency in which the post has been performed (if it is left empty = all currencies). The report shall be created in the local currency amount of the post that has been entered with the selected foreign currency according to the exchange rate in the posted documents. |
| To currency |
You may select financial report to be made in any given currency! To recalculated in a foreign currency the program uses the National bank's exchange rate valid on Posting period to. It is therefore mandatory to enter this data to use recalculation. |
| Subject |
Financial reports may be restricted by individual subjects (customer, supplier …) |
| Department |
Financial reports may be restricted by a specific company's organizational unit (filtered by data from posting items) |
| Cost drv. |
Financial reports may be restricted by a specific cost driver (filtered by data from posting items) |
| Journal entry (planned) |
You can enter the ID of journal entry where you have entered the planned assets status, payables to asset sources, revenues, expenses, costs and/or other financial report categories for planning period or the end of planning period.
Journal entry for planned financial report, a planned financial statement of operating results and/or planning other financial report categories should be entered in a special document type that should have the For the record checkbox selected. Such a document type has not been predefined. Since it is a document type for the record, transactions of this journal entry shall not be included in the financial report (left column), yet they will be displayed in the right comparative column. That is why you should select as report type Comparative financial report.
|
| Settings |
By clicking this button you open a financial report template as can also be seen in the financial report register .
To use this function the user has to have adequate authorization for financial report register! |
DATE MARGINS FOR PERIOD
By selecting date margins for Period you select date margins of the current period:
izračun lahko omejimo tudi glede na datum dokumenta (iz pozicije temeljnice) - za tekoče obdobje. Ta možnost je uporabna le za razne komercialne preglede, izvedene iz podatkov glavne knjige in ne za letna poročila.
Period:
Posting per. (from) |
Reports can be restricted by the period start date (from the journal entry header) - of the current period.
For annual financial reports this is the only adequate and necessary criteria! |
Period:
Posting per. (to) |
Reports can be restricted by the period end date (from the journal entry header) - of the current period.
For annual financial reports this is the only adequate and necessary criteria! |
Period:
Document (from) |
iReports can also be restricted by document date (from the journal entry item) - of current period. This option can be of help only for various commercial overviews performed on the basis of general ledger data, and not for annual reports. |
Period:
Document (to) |
| Period – date 2: |
Other set of dates from the current period that is being used in items of financial reports that have Date 2 checkbox selected (checked) for use of the second set of dates (see Financial reports items). For example of use see Usage of any other date in financial reports. |
DATE MARGINS FOR COMPARATIVE PERIOD
You can select date margins for Comparative period.
|
It is recommended to use date margins for comparative period only if you deal with a financial report template with method of filling columns for Comparative period. This selection is furthermore wise only if you deal with a report of the Comparative financial report type (see above) - that is also why financial reports of this type and different date margins are not available.
Hence date margins for comparative period are not available if you deal with financial report template with method of filling columns of Debit/credit.
|
| Period - date 2 (comparative): Posting per. (from) |
You can select the start date of posting period to calculate data of comparative period. The report may be restricted by period dates (from the journal entry header).
Report of data for forumula 2 is also used.
|
| Period - date 2 (comparative): Posting per. (to) |
ou can select the end date of posting period to calculate data of comparative period. Ihe report may be restricted by period dates (from the journal entry header).
Report of data for formula 2 is also used.
|
Period - date 2 (comparative):
Document (from) |
Report of comparative period may also be restricted by document start date (from the journal entry item). This option is useful for various commercialy - related overviews performed on the basis of data from general ledger and not for annual reports.
Uporablja se tudi za izračun podatka za Formulo 2.
|
Period - date 2 (comparative):
Document (to) |
izračun za primerjalno obdobje lahko omejimo tudi glede na končni datum dokumenta (iz journal entry item). Ta možnost je uporabna za razne komercialne preglede, izvedene iz podatkov glavne knjige in ne za letna poročila.
Report of data for formula 2 is also used.
|
| Period (comparative) – date 2: |
The second set of dates of comparative period that is used in items of financial reports and that have the Date 2 checkbox selected (checked) (see Financial reports items). For example of use see Usage of a different date in financial reports.
Report of data for formula 2 is also used.
|
| |
 |
By clicking this button you display the financial report with the previously selected criteria and in the currently selected report type.
|
|
To make the selection of document types easier you can also use the shortcut from the right mouse click menu (see General - Multiple confirmation). |
|
See Taskbar for a general description of its functions.
|
|
You have to select the repot criteria each time you start or you can save as a template. |
|
As in all other filtering it holds true also in reports that if the field is empty all the amounts are included in the report, yet the if the field is not empty it includes in the report only documents and items that match the entered data!
By using wildcard characters you can set the filter a bit wider (see General - Wildcard characters). |