PANTHEON™ manual

 Categories
 Скласти тех карту
[Expand]User Manual for DataLab PANTHEON 5.5
[Collapse]Datalab PANTHEON 5.5
 [Expand]Orders
 [Expand]Settings
 [Expand]Manufacturing
 [Expand]Goods
 [Expand]Service
 [Collapse]Financials
  [Expand]Accounting Basics
  [Expand]Manual Posting and the Journal Entry
  [Expand]Accruals and Deferrals
  [Expand]Automatic Posting
   General Ledger Overview
   Subsidiary Accounts Overview
  [Expand]90626
  [Expand]Browse Posts
  [Expand]Close
  [Collapse]Reports
   [Expand]General Journal
   [Expand]Account Card - old
   [Expand]Outstanding Items
   [Expand]Account Card
   [Expand]Outstanding Items - old
   [Expand]Debt Structure
    Balance Report of Customers and Suppliers
   [Expand]Invoice Payment List
   [Expand]Pregled zamude pri plačilih
   [Expand]Trial Balance
   [Collapse]Financial Reports
     Financial Statement Report
     Primeri bilanc
   [Expand]Monthly SKV Report for the National Bank
   [Expand]Summary Reports
   [Expand]Financial Analyses (ZEUS)
   [Expand]SFR - Statistika Finančnih Računov
    Export General Ledger Data for Tax Purposes
   [Expand]Cross Reference
  [Expand]Fixed Assets
  [Expand]Transactions
  [Expand]Debt Collection
  [Expand]Reminders
  [Expand]Interest
  [Expand]Cash Transactions
  [Expand]Year-end
  [Expand]Archive
   Planning
  [Expand]Reports
 [Expand]Personnel
 [Expand]ZEUS Business Intelligence System
 [Expand]Desktop
  Web Portals
  Extra
 [Expand]Datalab Software System Environment
 [Expand]Messages and Warnings
 [Expand]Additional Programs
 90632
[Expand]Pantheon RA (android POS) guide
[Expand]Довідник користувача Datalab PANTHEON Farming
[Expand]User Site

Load Time: 1000.0143 ms
print   |
Label

Financial Statement Report

Financial Statement Report

Financial Statement Report

010381.gif010411.gif010382.gif010383.gif

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:

47445.gif

000001.gif 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.
000001.gif 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.

2. Financial reports by departments

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).

3. Financial reports by 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).

4. Financial reports by departments and 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:

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 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.

000001.gif 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.

019261.jpg
By clicking this button you display the finacial report with the previously selected criteria and in the currently selected report type.

 

000001.gif The window for entering of report criteria may be opened also by clicking the 019259.jpg button found in the taskbar of financial report register!
000001.gif To make the selection of document types easier you can also use the shortcut from the right mouse click menu (see General - Multiple confirmation).
000001.gif See Taskbar for a general description of its functions.
000001.gif You have to select the repot criteria each time you start or you can save as a template.
000001.gif 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).
Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!