Financial Statement Report
Financial Statement Report
In menu Financials | Reports | Financial Reports you can find different financial reports.
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:
 |
HINT
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!
|
You can select a form on which the calculated data shall be displayed. By double-clicking the name of report or by clicking the report button you can display it. There are available:
1. 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.
2. Financial report with disclosures
- In addition to the data shown in the above standard financial report, these two reports show all accounts with actual values (with their debit / credit total values) contributing to the single positions of the according financial report; these reports are very helpful to analyze how the values on the single positions are calculated
3. Comparative financial report
- A 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.
4. Financial reports by periods
Be aware that all financial reports by periods DON'T perform financial report checks.
- 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.
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).
Otherwise these five reports follow the same logic as the five reports outlined above under point 1, 3, and 5.
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).
Otherwise these five reports follow the same logic as the five reports outlined above under point 1, 3, and 5.
7. Financial reports by departments and 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.
Otherwise these five reports follow the same logic as the five reports outlined above under point 1, 3, and 5.
8. Financial reports over several year
As opposed to the reports outlined under point 4 above, this report shows financial figures for up to four years side by side.
9. List of financial report formulas
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 center |
Financial reports may be restricted by a specific cost driver (filtered by data from posting items).
|
HINT
Using the function  opens Lookup table in which multiple options can be selected within a single field. In this case, different Cost Centers in relation to their Name, Group or Status
On lookup table you can see also non-active cost centers.
|
|
| 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. The calculation can also be limited according to the date of the document (from the journal entry) - for the current period. This option is useful only for various commercial checks, derived from general ledger data and not for annual reports.
| Target date from / to for period (date 1) |
Reports can be restricted by the target dates set in the journal entry header. For an annual financial reports this is the only adequate and necessary criteria. |
| Document date from / to for period (date 1) |
Reports can also be restricted by document date from the journal entry item. This option can be of help only for various commercial overviews performed on the basis of general ledger data, and not for annual reports. |
| Target date from / to for 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. |
| Document date from / to for period - date 2 |
See above "Document date from / to for period (date 1)". |
DATE MARGINS FOR COMPARATIVE PERIOD
You can select date margins for Comparative period.
|
HINT
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.
Report of data for formula 2 is also used.
|
Period - date 2 (comparative):
Document (to) |
Report of comparative period may also be restricted by document end 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.
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.
|
| Only Approved Journal Entries |
If selected, only Journal entries with status Approved will be included in Reports. |
| Use Formula 2 for Period 2 |
If selected, formula 1 will be used for Period 1 and Formula 2 will be used for Period 2. Option is visible only in case of Comparative Financial Report |
| |
 |
By clicking this button you display the financial report with the previously selected criteria and in the currently selected report type.
|
|
HINT
Drill through or option to search the source of printed values by clicking the value is available only in ME, GE and MF versions of program Pantheon.
To make the selection of document types easier you can also use the shortcut from the right mouse click menu (see General - Multiple confirmation).
The window for entering of report criteria may be opened also by clicking the  (Report) button found in the taskbar of financial report register!
|
|
HINT
You have to select the report criteria each time you start or you can save as a template.
|
|
HINT
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).
|