General
The General tab on the form Consolidated Financials statements is used for printout of balance report and allows settings for some important parameters for reports.
Here is a description of the tab.
The Company section is meant for data acquisition of the selected affiliated company.
 |
HINT
The selected company is marked in blue:
|
|
Collect data
|
The program collects data according to the selected/marked databases in the first tab - Companies. Data collection is valid only for companies that are preconfigured in Administration Panel | Settings | Company | Affiliated Companies in the Server Type field as MS SQL server type and not for data collection from an external file (import from XLS).
|
|
Trial balance
|
Printout of trial balance for the selected company. The report can be selected with the right mouse click:
|
|
Trial Balance
|
Printout of tiral balance for the selected company.
|
|
Balance sheet
|
Printout of selected balance sheet for the selected company.
|
The consolidation section is meant for consolidated data from companies, marked in tab. Data are consolidated according to the settings in the Administration panel for companies, selected in the Company tab.
|
Collect data
|
The program collects and transfers data exclusively from the Separate Figures tab to the Consolidated Figures tab.
|
|
Trial balance
|
Printout of conoslidated trial balance for the selected companies. The report can be selected with the right mouse click.
|
|
Trial Balance
|
Printout of consolidated tiral balance for the selected company.
|
|
Balance sheet
|
Printout of selected consolidated balance sheet for the selected companies.
|
The usage of the exchange rate section is meant for selecting exchange rate to recalculated data.
|
Exchange rate
|
If the primary currency of the related entity is different from the primary currency of the entity in which the consolidated balance sheet report is prepared, the data will be translated at the selected exchange rate into the primary currency of the entity at the time of transfer.
The possible choices are:
- Date of posting - translation at the period date rate in the header of the underlying
- Date of document - conversion at the document date rate in the header position of the base document
- Close exchange date – manually entered exchange rate in the Company tab (it is entered seperatly for each affiliated company).
- Date of posting (from linked DB) – conversion at the period date in the posting journal header. The exchange rate is taken from the affiliated company.
- Date of document (from linked DB) - conversion at the document date in the posting journal line. The exchange rate is taken from the affiliated company. In case of a large amount of data conversion it can take a longer time.
 |
WARNING
The exchange rates must be entered for a correct transfer!
|
|
|
Exchange rate 2
|
|
|
Report currency
|
The Trial Balance Sheet and the Balance Sheet/Profit and Loss Account can be printed in any currency. The program will take the exchange rate from the main, parent base (mother) for the selected currency on the last day of the period. From the drop-down menu select the report currency.
|
|
Report in User´s Language
|
Check the checkbox if you want the report to be executed in the language of the related company. If you want to create a report in a different language select the language in the drop-down menu of the field. The language information is extracted from the register of Chart of Accounts translations.
|
The Include Demegers section is meant for choosing an option on how to select data from the affiliated companies:
|
All posts
|
The program collects all the entries in the Separate Figures tab. All the data from the mapped accounts will be collected.
|
|
Exclude Demergers
|
The program will filter out posts from the Separate Figures tab according to the VAT ID number entered in the Subjects register. This means that if there is a bookkeeping between the main database (mom) /daughter1/daughter2 or any other bookkeeping in the Separate Figures and this bookkeeping is entered in the main database under the same VAT ID, such bookkeeping will be filtered out from the data collection.
Data for consolidation (without posts, marked for exclusion).
|
|
Demergers only
|
The reverse of the situation described above. With this switch, however, the program only collect excluded bookings. Only posts, marked for exclusion.
|
|
Use document types 2 for values 2
|
|
|
Use date 2 for values 2
|
|