Financial Statement Report
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 fincial 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 finacial 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 finacial reports are shown for each posted
combination of department nad cost driver. Hence these reports cobine
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.
|
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 racalculation.
|
Subject
|
Financial reports may be restricted by individual subjects (customer,
supplier …)
|
Department
|
Fincial reports may be restricted by a specific company's organizational
unit
(filtered by data from posting items)
|
Cost drv.
|
Finacial reports may be restricted by a specific cost driver
(filtered by data from posting items)
|
| Journal entry (planned) |
You can enter the ID of journa lentry where you have entered the planned
assets status,
payables to asset sources, revenues, expenses, costs and/or other
financial report categories for plannin period or the end of planning
period.
Journal entry for planned financial report, a planned finacial
statement of operating results and/or planning other finacial report
categories should be entered in a special
document type that should have the For the record
checbox selected.
Such a documnt 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 finacial report.
|
Settings
|
By clicking this button you open a finacial report template as can also be
seen in the
financial report register .
To use this function the user has to have adequate
authorization for finacial report register!
|
DATE MARGINS FOR PERIOD
By selecting date margins for Period
you select date margins of the current period:
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)
| 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 – date 2:
|
Other set of dates from the current period that is being used initems 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 finacial report
type (see above) - that is also why finacial 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 jornal
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 jornal
entry header).
Report of data for forumula 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 forumula 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 forumula 2 is also used.
|
|
|
| By clicking this button you display the finacial 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 filterings 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). |