Report List
Reports in ABRA Flexi are created by a general report "generator." The principle of the generator is that you first create a report form. An example would be the Income Statement. You then need to create a specification defining which synthetic accounts from the standard chart of accounts belong to a given report line. You also need to define the summation conditions in the form. A practical example is always useful for understanding the system. We want to create a report with three lines. The first line includes accounts 501 – material consumption and 521 – wages. The second line includes 601 – revenue from goods and 602 – revenue from services. The third line is the difference between line 2 and line 1. The report will be called "Profit."
Step one – we create the "Profit" report
Step two – we create 3 report lines: 1 – expenses, 2 – revenues, 3 – Difference = profit
Step three – we create a standard specification – line 1 contains 501, 521; line 2 contains 601, 602;
Step four – we create a summation specification – line 3 contains the sum of lines 1 and 2
Step five – we press the Calculate button and the result is the sum of turnovers for line 2 minus the sum of turnovers for line 1
As the examples show, this "generator" can be used to create any report. Changes to standard reports are not permitted for security reasons. You can only modify the optional parameters for the placement of certain accounts within the report.
The "Report" Tab
The report list contains standard reports that are linked to the legislation table. These reports and their associated tables cannot be modified by users. It also contains reports created by the user.
Basic Panel
Report Code
Unique report code
Report Type
Permitted values: Balance Sheet, Income Statement, Cash Flow, General.
For user-defined reports, only the General value is permitted.
Calculate Previous Period
When checked, the program calculates values into columns 1 through 3 for the specified period range.
For the same period in the previous year, the calculation will be performed into columns 4 through 6.
Name – Name C
Required field.
The "Name" through "Name C" fields have a maximum of 255 characters.
OrganizationType
Select from the list of organization types.
Not available for user-defined reports
Standard reports are those defined by legislation.
Standard reports cannot be updated by the user.
Reports created by the user can be freely updated.
The "Report Properties" Panel
"Columns 1–3" Tab
The following fields are labels for the numeric columns 1–6, which serve as summation fields in individual reports. The standard balance sheet requires all 6 columns for calculation but displays only 4 (1, 2, 3, 6). The standard income statement requires only two columns for the current period and the previous period (1, 4).
Column 1 Name – home language
Name of column 1 in the home language
Column 1 Name – language A
Name of column 1 in language A
Column 1 Name – language B
Name of column 1 in language B
Column 1 Name – language C
Name of column 1 in language C
Show column 1
When this field is checked, column 1 from the form will be displayed in the window and also printed in the output report.
Column 2 Name – home language
Column 2 Name – language A
Column 2 Name – language B
Column 2 Name – language C
Show column 2
When this field is checked, column 2 from the form will be displayed in the window and also printed in the output report.
Column 3 Name – home language
Column 3 Name – language A
Column 3 Name – language B
Column 3 Name – language C
Show column 3
When this field is checked, column 3 from the form will be displayed in the window and also printed in the output report.
Column 3 is the sum of columns 1 and 2
This value will be checked in the case of a balance sheet. Column 1 will contain GROSS values, column 2 will contain corrections (accumulated depreciation), and column 3 is their sum.
"Columns 4–6" Tab
Column 4 Name – home language
Column 4 Name – language A
Column 4 Name – language B
Column 4 Name – language C
Show column 4
When this field is checked, column 4 from the form will be displayed in the window and also printed in the output report.
Column 5 Name – home language
Column 5 Name – language A
Column 5 Name – language B
Column 5 Name – language C
Show column 5 (Show5)
When this field is checked, column 5 from the form will be displayed in the window and also printed in the output report.
Column 6 Name – home language
Column 6 Name – language A
Column 6 Name – language B
Column 6 Name – language C
Show column 6
When this field is checked, column 6 from the form will be displayed in the window and also printed in the output report.
Column 6 is the sum of columns 4 and 5
This value will be checked in the case of a balance sheet. Column 4 will contain GROSS values for the previous period, column 5 will contain corrections (accumulated depreciation) for the previous period, and column 6 is their sum.
"Add Row from Another Report" Tab
For the Balance Sheet report, it is necessary to insert the net income value from the Income Statement into the "Net income for the period..." line. This tab serves that purpose.
Target Row
Select the report row to which the required value should be added from the drop-down list.
Source Report
Select the source report from the drop-down list.
Source Row
Select the source row from the source report where the value is read, using the drop-down list.
"Administration" Tab
The Administration tab contains information about the validity and visibility of the given record in the code list for accounting periods. The validity of a record is specified by a range of accounting periods. Within the specified range, the record is valid; outside that range, the record is not valid and will not be displayed in the code list (list) at all. By restricting validity, you ensure that records no longer in use are not shown during routine use of the code list. Unlike time-based record validity, it is not possible to select a range of accounting periods that does not at least partially correspond to the active accounting period.
Because the validity of a record is tied to accounting periods, it can also be used with fiscal accounting periods.
Valid from
Select the start period of the record's validity using the scroll button from the list of accounting periods.
Valid to
Select the end period of the record's validity using the scroll button from the list of accounting periods.
If you require unlimited validity for the record, leave the Valid from and Valid to fields empty (remove an already selected value by pressing the Del key). The record will then be usable in all accounting periods. It is also possible to leave one of the fields without a selected value, thereby leaving the start or end of the record's validity open-ended.
If you select the same accounting period in both the Valid from and Valid to fields, the record will only be usable in that accounting period (see the accounting period in the header of the side navigation).
"Notes" Tab
The "Notes" tab is included in all code lists and all lists. It contains two fields where you can enter information according to your own needs.
Description
You can provide a more detailed description.
Note
The note is used to alert users to any special characteristics of the record or to highlight anything other users should be aware of when working with the record.
Related
"Generate User Specification from Standard" Button
Pressing this button generates a user specification for the report. The user specification is created by iterating through the rows of the standard specification, which contains the placement (column) of the account in the report and the calculation type. For all analytical accounts of a given synthetic account in the chart of accounts, rows are generated (created) in the user specification. If a synthetic account appears more than once in the standard specification, the generator uses the first occurrence.
"Calculate Report" Button
After pressing the button, the user specifies the range of periods (months) for the calculation (for example, 04–06 in 2007) and whether the calculation should cover the entire company or a specified list of cost centers. (Account turnovers are broken down by cost center.) When calculating for the entire company, the program sums the turnovers of all cost centers.
"Report Rows" Panel
At the bottom of the report card, there is a panel containing the "Report Rows" list, which represents the actual definition of the report form.
"Report Rows" List
"Report Rows" Card
"Report Rows" Tab
Row Number (CisRad)
Report records are sorted by row number
Label (Oznaceni)
Row label as prescribed by legislation
Name, Name A, Name B, Name C
Required field.
The "Name" through "Name C" fields have a maximum of 255 characters.
"Notes" Tab
Description
Note
"Breakdown of Report Rows by Accounts" Tab
When a report is calculated, the form rows are populated with summations of account balances according to the given specification and the row calculation method. To give the user an overview of which accounts and values make up a form row, this table is populated with a "breakdown" of the selected row into individual accounts. When the report form is calculated, the account value is added to the appropriate row and column of the form, and at the same time, exactly one record is created in this table linked to the corresponding form row.
Account
Report Value 1
Report Value 2
Report Value 3
Report Value 4
Report Value 5
Report Value 6
"Standard Report Specification – Standard Placement of Synthetic Accounts in the Report Form" Tab
Account placement is linked to the report list and will be used for standard reports. This table will not be accessible to users.
Synthetic Account Number
If an account has multiple placement options in the report, the same number will be repeated for different report codes
Account Type
Permitted values are Active, Passive
These values will only be used for updating the standard balance sheet. For user-defined reports, this value is not accessible.
Report Column Number
Permitted values for calculating the previous period are 1, 2, 3. If the previous period is not being calculated, the range is 1 to 6.
Calculation Method
The calculation method determines how the value will be calculated from account turnovers for the defined calculation period. The user specifies this value when initiating the report calculation. The user can enter values in the range 01 to 12 when the accounting period equals the fiscal year.
The following values are available for standard and general reports:
Account balance at the beginning of the period
Used for balance sheet + general report + Cash Flow
The opening balances for the relevant accounting period are calculated as the sum of
Debit turnover for month "00" – Credit turnover for month "00" +
Sum of turnovers before the first month of the calculated period (Debit turnover – Credit turnover).
Turnover for the period
Used for income statement + general report + Cash Flow
The turnover for the defined calculation period is the sum of all turnovers (Debit turnover – Credit turnover) within the given range.
Account balance at the end of the period
Used for balance sheet + general report + Cash Flow
The account balance is the sum of the opening balance for the calculated period and the turnovers for the period
Debit turnover for the period
Used for general report + Cash Flow
The debit turnover for the defined calculation period is the sum of all debit turnovers within the given range.
Credit turnover for the period
Used for general report + Cash Flow
The credit turnover for the defined calculation period is the sum of all credit turnovers within the given range.
Reverse sign (PrevratZnam)
If this value is checked, the program will reverse the sign of the result.
Consider positive values only (JenKladne)
If this value is checked, the program will not include negative results.
Access to this table will be restricted to service staff only – not standard users. This applies only to standard accounting reports – those that do not have a legislation code filled in.
List – User Report Specification – Placement of Analytical Accounts (uSesUzivPred)
Account placement is linked to the report list. This table will only be accessible for non-standard reports created by the user. For standard reports, it will be generated automatically and cannot be modified by the user. Only in cases of ambiguity (where the standard specification contains multiple placement options for a single synthetic account) must the user decide, when creating the chart of accounts, where the account belongs. This does not apply to accounts that belong to assets or liabilities based on the account's value.
The following fields are described in the previous section
Analytical Account Number
Report Column Number
Calculation Method
Balance at the beginning of the period
Balance at the end of the period
Turnover for the period
Debit turnover for the period
Credit turnover for the period
Reverse sign
Consider positive values only
"Summation in Reports" Tab
Add row
Reverse sign
If this value is checked, the program will reverse the sign of the value being added.
Description and Overview of the Report Creation Principle
Principle of report creation and calculation:
What is a report form? By default, it is a form defined by the country's legislation. Each report form primarily contains rows that are the sum of the balances of one or more accounts.
Which accounts these are is first defined in the Standard Report Specification table (account placement). This table defines the standards. For a single synthetic account, the standard specification table may contain placement in multiple rows of the report form. An example is account 311 – Receivables, which may be placed in the balance sheet under either short-term or long-term receivables. Therefore, the standard specification table will have two rows for this account:
The User Report Specification – Placement of Analytical Accounts in the Report Form table contains the final placement of analytical accounts in the form.
In addition, the form contains subtotals for individual rows as well as final totals. For the balance sheet, these are ASSETS and LIABILITIES respectively. For the income statement, it is the Net Income. The specification for how to perform the summation is contained in the Report Summation Specification table.