General

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 field Server Type as MS SQL server type and not for data collection from external file (import from XLS).

Trial balance 

Printout of trial balance for selected company. Report can be selected with right mouse click:

Trial Balance

Printout of tiral balance for selected company.

Balance sheet

Printout of selected balance sheet for selected company.

Collect data

The program collects and transfers data exclusively from the tab Separate Figures to the Consolidated Figures tab.

Trial balance 

Printout of conoslidated trial balance for selected companies. Report can be selected with right mouse click.

Trial Balance

Printout of consolidated tiral balance for selected company.

Balance sheet

Printout of selected consolidated balance sheet for selected companies.

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 on tab Company (it is entered seperatly for each affiliated company).
• Date of posting (from linked DB) – conversion at the period date in the posting journal header. Exchange rate is taken from affiliated company.
• Date of document (from linked DB) - conversion at the document date in the posting journal line. Exchange rate is taken from affiliated company. In case of a large amount of data conversion 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 report in 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.

All posts

The program collects all the entries in the tab Separate Figures. All data from mapped accounts will be collected.

Exclude Demergers

The program will filter out posts from the tab Separate Figures according to the VAT ID number entered in the Subjects register. This means that if there are bookkeeping between the main database (mom) /doughter1/doughter2 or any other bookkeeping in the Separate Figures and these bookkeeping are 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 collects excluded bookings. Only posts, marked for exclusion.

Use document types 2 for values 2

Use date 2 for values 2