...
Financial Table Definitions located in the Transactions menu of the General Ledger section are kept as files with user defined names, and reports can be generated by selecting the required table. The defined tables are:
- Balance Sheet
- Profit/Loss Table
- Cost of Sales Table
- Fund Flow Table
- Cash Flow Table
- Dividend Table
- Net Monetary Position Profit/Loss Statement
- VAT Return
- Monthly Tax Return
- VAT Return (2)
- Provisional Tax Declaration
Existing definitions for the table are displayed on the window accessed by selecting any one of these definitions. A dialogue box opens by clicking on "New" button, and it displays the following options:
- Standard Definition
- Blank Definition
...
Financial table reports are generated using Report option located in the right mouse button menu while the defined table is selected.
Standard definitions must be previously recorded on the Financial Table Definitions section in order to run Standard Definition reports.
If there are no definitions, reports cannot be run when Standard Definition is selected.
Anchor
The balance sheet consists of Actives (Assets) and Passives (Liabilities) sections. This table can be thought as the combination of two separate financial table definitions called Actives and Passives. The difference of the balance sheet from other tables is that the Profit/Loss definition is included in the report. The profit/loss definition is not included in other tables. The profit and loss formulas are displayed as below:
...
Loss = Total Passive Amount – Total Active Amount
Anchor
The definitions of Profit/Loss, Cost of Sales, Cash Flow, Fund Flow and Dividend tables within this group do not consist of two sections as in the balance sheet. The items on these tables are defined as a single list sorted top-down. Profit/Loss definitions are not included in the table.
Anchor
The tables are defined using the options located in the right mouse button menu. These options and their functions are:
Footnotes
This option is used to record footnotes in Balance Sheets and Income tables. If the application does not contain any footnote for the selected table, Footnotes should be entered by the user when the table is defined.
Record Table
Table records require a file name and description. The report file to run in the Financial Table Definition section is selected depending on the Description information entered on this field.
Anchor
The Group line is used to display the totals of amounts that are displayed under the selected line and that are coded to generate a sub-header on a single line. The group line can be independent from other groups, or can be the sub-line of another group depending on the definition code. This line is also processed when the Subtotal and General Total information of other lines is calculated.
Calculation Method
The amount of the group line is calculated by aggregating the amount of other lines that are listed under this line, and that are "sub-lines" according to the definition code.
Group Definition Window
The fields and functions of this window are:
Field Name | Description |
|---|---|
Definition Code | Used to assign a line code to group information. If codes entered on this field are defined in order to generate sub-headers as in chart of accounts codes, sub-groups and lines can be generated. The coding can be done as follows:
|
Definition Name | The description of the group line for which a definition code is entered is recorded on this field, and is displayed next to the group code. |
Transaction Type
| This information indicates how the amount of the group line will affect the Subtotal and General Total fields located on subsequent lines. If the defined group line is used as a subgroup due to the coding method, this option also specifies how the line amount will affect the main group. |
Inverse Balance
| This option is used to prevent displaying amount information in table report if the total amount resulting from sub-lines is negative. |
Reporting
| Used to avoid that the line of the defined group is displayed on the Financial Table report. Since the effect of this option is only visual, the group line is not printed on the table report; however, the amount information of the line is processed on Subtotal, General Total and Main Group Total transactions. |
Account
The Account line is used to select an account depending on its code in the chart of accounts, and to display amount transactions for this account such as Debit, Credit, Balance, Increase and Decrease on a single line. The Account line can be independent from other groups, or can be the sub-line of another group depending on the definition code. This line is also processed when the Subtotal and General Total information of other lines is calculated.
Calculation Method
The amount to be displayed on the account line is equalized to the amount of the G/L account specified on the Account Code field for which the type is selected on the Account Amount field.
Account Definition Window
The fields and functions of this window are:
Field Name | Description |
|---|---|
Definition Code | Used to assign a line code to the G/L account information. If this code is specified according to the level-based structure, it can be the sub-line of a group. Since the definition code is applied only for financial tables, it shouldn't be confused with the G/L Account Code. Other lines cannot be connected as sub-lines to the account line. In other words, the account amount information is not affected by other lines, and is generated only according to the amounts of the defined account. |
Definition Name | The description of the account line for which a definition code is entered is recorded on this field, and is displayed next to the account definition code. |
Account Code | The account that will affect the amount line is selected according to the G/L code on the chart of accounts. The Debit, Credit and Balance amounts of the selected G/L account generate the amount of the account line at the end of this transaction. |
Reporting
| Used to avoid that the defined line is displayed on the Financial Table report. Since the effect of this option is only visual, the account line is not printed on the table report; however, the amount information of the line is processed on Subtotal, General Total and Main Group Total transactions. |
Inverse Balance
| This option is used to prevent displaying amount information in table report if the calculated amount is negative. |
Account Amount
| This field is used to specify the information to be used in G/L account amount calculations. For example, if account code is selected as 100 and account amount is selected as debit, the amount information to be displayed for this line on the financial table report is equal to the debit of the account with code 100 at the date of the table. The functions of the account amount parameters are separately explained. |
Transaction Type
| This information indicates how the amount of the account line will affect the Subtotal and General Total fields located on subsequent lines. If the defined account line is used as a subgroup due to the coding method, this option also specifies how the line amount will affect the main group. |
Exchange Rate to Use
| If the report is generated in foreign currency, the amount of the account line must be calculated in foreign currency. |
Account Type
| This option is used in connection with the Account Amount parameter, and affects the calculation of Increase and Decrease information. |
Anchor
The Account range line is used to select a group of accounts depending on their codes in the chart of accounts, and to display amount transactions for these accounts such as Debit, Credit, Balance, Increase and Decrease on a single line. The account range line can be independent from other groups, or can be the sub-line of another group depending on the definition code. This line is also processed when the Subtotal and General Total information of other lines is calculated.
Calculation Method
The amount to be displayed on the account range line is equalized to the amount of the G/L accounts specified on the Account Range field for which the type is selected on the Account Amount field.
Account Range Definition Window
The fields and functions of this window are:
Field Name | Description |
|---|---|
Definition Name | Used to assign a line code to the account range information. If this code is specified according to the level-based structure, it can be the sub-line of a group. Other lines cannot be connected as sub-lines to the account range line. In other words, the account range amount information is not affected by other lines, and is generated only according to the amounts of the defined accounts. |
Definition Name | The description of the account line for which a definition code is entered is recorded on this field, and is displayed next to the account range definition code. |
Account Range | The account range that will affect the amount line is selected according to the G/L code on the chart of accounts. The Debit, Credit and Balance amounts of all accounts within the range (including the start and end values) generate the amount of the account range line. |
Transaction type
| This information indicates how the amount of the account range line will affect the Subtotal and General Total fields located on subsequent lines. If the defined account range line is used as a subgroup due to the coding method, this option also specifies how the line amount will affect the main group. |
Account Amount
| This field is used to specify the information to be used in amount calculations for the defined G/L account range. The specified account type is applied to all accounts within the range. For example, if account range is selected as 100...150 and account amount is selected as debit, the amount information to be displayed for this line on the financial table report is equal to the debit of all accounts within codes 100 and 150 at the date of the table. The functions of the account amount parameters are separately explained. |
Exchange Rate to Use
| If the report is generated in foreign currency, the amount of the account lines must be calculated in foreign currency. |
Reporting
| Used to avoid that the defined line is displayed on the Financial Table report. Since the effect of this option is only visual, the account range line is not printed on the table report; however, the amount information of the line is processed on Subtotal, General Total and Main Group Total transactions. |
Inverse Balance
| This option is used to prevent displaying amount information in table report if the calculated amount is negative. |
Account Type
| This option is used in connection with the Account Amount parameter, and affects the calculation of Increase and Decrease information. |
Anchor
Amount information such as cash amount in account XX, and allowances allocated from account YY cannot be obtained from the chart of accounts in financial tables in foreign currency, or Cash Flow and Fund Flow tables. Therefore, Amount lines can be defined in financial tables for data entry by users.
The amount line can be independent from other groups, or can be the sub-line of another group depending on the definition code. This line is also processed when the Subtotal and General Total information of other lines is calculated.
Calculation Method
Since the amount to be displayed is directly entered by the user, calculation is not performed.
Amount Definition Window
The fields and functions of this window are:
Field Name | Description |
|---|---|
Definition Code | Used to assign a line code to the amount information. If this code is specified according to the level-based structure, it can be the sub-line of a group. Other lines cannot be connected as sub-lines to the amount line. In other words, the amount information of the amount line is not affected by other lines, and is generated only according to the amounts of the defined accounts in local or foreign currency. |
Definition Name | The description of the account line for which a definition code is entered is recorded on this field, and is displayed next to the amount definition code. |
Transaction type
| This information indicates how the amount of the amount line will affect the Subtotal and General Total fields located on subsequent lines. If the defined amount line is used as a subgroup due to the coding method, this option also specifies how the line amount will affect the main group. |
Amount
| The amount required to be displayed next to the description of this line on table reports, and to be added to line calculations is entered on this field in local currency. |
Reporting
| Used to avoid that the defined line is displayed on the Financial Table report. The amount information of the line is assumed present and processed in Subtotal, General Total and Main Group Total transactions. |
Anchor
When certain Subtotal information is calculated on financial table lines, certain lines within the groups may be required to be excluded from addition and subtraction operations, or be included by multiplying with a factor. Since group or subtotal definitions may not work in such complex calculations, definitions in which formulas can be used to specify the table lines to be affected by the line total, and how they will be affected are necessary.
The Formula line is always independent from groups; it can't be the sub-line of a group. Furthermore, it is also not processed in the calculation of Subtotal and General Total information located in subsequent lines. Therefore, the definition code information is not necessary. The description would be enough.
Calculation Method
The amount of the Formula line is calculated using the information entered into the formula definition field.
Formula Window
The fields and functions of this window are:
Field Name | Description |
|---|---|
Description | The description to be displayed on the Formula line of the table report in entered on this field. |
Formula Definition | The amount information to be displayed next to the Formula line description is defined on this line. Definition codes of table lines are used as variables on the formula by inserting the letter "P" standing for the word parameter. Aggregation, subtraction, multiplication and division operations with fixed numbers can be performed between variables as in Discount and Surcharge calculations. |
Anchor
A Subtotal line is inserted into any line within the table report to display the total or difference of lines listed up to that point. The subtotal line is always independent from groups; it can't be the sub-line of a group. Furthermore, it is also not processed in the calculation of Subtotal and General Total information located in subsequent lines.
Calculation Method
Only the lines that are not sub accounts of another line can be used to calculate the amount of the subtotal line. The Transaction Type parameter of the related line definition is used to specify how these lines will affect the transaction. The Subtotal and General Total lines listed on previous lines, and the formula lines do not affect the subtotal as well.
Anchor
The fields and functions of this window are:
Field Name | Description |
|---|---|
Description | The description to be displayed in Subtotal line of financial tables is entered in this field. |
Anchor
It may be necessary to add a line anywhere in the table, or at the end of the table to display the total or difference of all lines displayed on the table. This function is performed by the General Total line. This line is always independent from groups; it can't be the sub-line of a group. This line is not processed when the Subtotal and General Total information of other lines is calculated.
Calculation Method
Only the lines that are not sub accounts of another line can be used to calculate the amount of the General Total line. The Transaction Type parameter of the related line definition is used to specify how these lines will affect the transaction. The Subtotal and General Total lines listed on previous lines, and the Formula lines do not affect the general total as well.
The difference between the general total line and the subtotal line is that the amount displayed on the general total line does not change independently from its position within the table, and that this amount is calculated by processing all independent lines within the table.
Anchor
The fields and functions of this window are:
Field Name | Description |
|---|---|
Description | The description to be displayed on the General Total line of financial tables in entered on this field. |
Anchor
This option is available only in balance sheet definitions. If G/L transactions such as transfer of income and expense accounts into balance accounts or transfer transactions are not completed within the balance sheet period, or if the defined lines in the Active and Passive sections are incomplete or inaccurate, there will be a difference between the active and passive accounts when the report is completed. Profit/Loss option is used to display this difference on table lines. The profit/loss line is always independent from groups; it can't be the sub-line of a group.
Anchor
The amount displayed next to the profit/loss line of the table report is calculated with the General Total of the Profit/Loss = Actives lines - General Total of Passives lines formula. The calculated amount is displayed on the profit/loss line of the table with a plus or minus sign.
Attention: The Profit/Loss line is located in the Passives section of the balance sheet as a rule. However, the balance sheet is not restricted assuming that the user is aware of this situation.
Anchor
The fields and functions of this window are:
Field Name | Description |
|---|---|
Profit Description | This description is displayed on the Profit/Loss line if the result of the Active total - Passive total operation is positive. |
Loss Description | This description is displayed on the Profit/Loss line if the result of the Active total - Passive total operation is negative. |
Anchor
This option is used to visually organize Financial Table reports virtually. The option can be used to leave blank lines within the table, or display certain sections of the table separately from others by generating lines with single or double dashed lines.
Page Setup Window
The fields and functions of this window are:
Field Name | Description |
|---|---|
None | Generates a blank line on the table. |
Single Line | Generates a line consisting of – characters on the table. |
Double Line | Generates a line consisting of == characters on the table. |