Affiliated Companies

Chart of Accounts

You can set up accounts separately for each chart of accounts in the software. The data transfer will take into account the chart of accounts that is active for the consolidation period.

Create Linked Server

Click the button to create a connection to the selected server.

WARNING The affiliated company we want to involve in the data production must first give us access to its database. The linked company does this in the Remote access for consolidation tab.

Remove linked Server

Click the button to remove the link to the selected server.

Take over Doc. Types

By clicking on the button, the software displays all document types used by the selected linked company. As the company may also open new document types over time, this process can be repeated several times (before the consolidated balance sheet is produced).

Import Doc. Type from File

Click this button to import the VD for the selected entity. VDs that have already been entered are deleted!

Excel file structure:

• Entity
• document type
• opening (T/F)
• used (T/F)
• document of record (T/F)
• document type name

Example of file formatting:

Import Chart od Accounts

Click on this button to import the chart of accounts for the selected entity. A previously entered chart of accounts is deleted!

Excel file structure:

• entity
• account
• our account
• type (I - elimination, Z - replacement)
• - enabled (T/F)

Subject

Select the entity that is the related company. To select an entity, it must be entered in the Subjects Register.

Foreign Share

Choose the foreign share:

1. Non-residents holding 10% or more of the value of the equity interests in the reporting company

3. Other residents

Our Share

We choose our share:

1. Non-residents in which the reporting agent has a participation of 10% or more of the value of the ownership interests

3. Other residents

Our Share (%)

In the field enter our share in percentage.

Foreign Share (%)

In the field enter foreign share in percentage.

Server Type

Select from the drop-down list whether it is an MS SQL server, an ORACLE server or an external file.

Server

Select the server on which the database is located from the drop-down list.

Database

When we create a link to a server, the databases that exist on that server are displayed in the database field. Select the database for which you want to prepare a consolidated balance sheet.

We can select a database when it allows remote access for consolidation.

Collation

If the data is extracted from a database (MSSQL server) whose collation differs from ours (e.g. Macedonian Cyrillic database), we can specify a collation to convert the data. When the data is transferred, it will be converted to the collation of the database we are extracting the data to.

Receivables Account

If the option to post receivables and payables according to the related party account setting is checked in the Administration Panel, the related party account entered here will be used when creating the invoice.

Payables Account

If the option to post receivables and payables according to the related parties account setting is checked in the Administration Panel, the account entered here will be used when creating the invoice received.

Type of Share

In the drop-down list box, select one of the participation type options:

1 – Receivables from non-residents - direct investors (10% participation and more)

2 - Receivables from non-residents - horizontally linked within the same direct investor - non-resident group

3 - Receivables from non-residents - vertically integrated within the same direct investor group - non-resident

4 - Receivables from non-residents in which both the reporting resident and the direct investor are residents (10% participation and above)

5 - Receivables from non-residents - horizontally related within the same direct investor group - resident

6 - Receivables from non-residents - vertically integrated within the same direct investor group - resident

7 - Receivables from other non-residents

Selected

Select this box if you would like that program will include transactions on this journal entry in the preparation of the consolidation statement.

Document Type

Document type that is used by the company for posting.

Record Only

This box will be checked if a document type on the selected affiliated company has selected the Record Only option. This information can be a basis for the decision to include the transaction of this journal entry in the creation of the consolidated statement.

Name

Name of the document type.

Selected

Select this box if you would like that program will include transactions on this journal entry in the preparation of the consolidation statement.

Document Type

Document type that is used by the company for posting.

Record Only

This box will be checked if a document type on the selected affiliated company has selected the Record Only option. This information can be a basis for the decision to include the transaction of this journal entry in the creation of the consolidated statement.

Name

Name of the document type.

Account

The ID of the account that is used by the selected affiliated company.

Name

Name of the account.

Subs. Acct. Type

From drop down menu select type subsidiary account. You can select between:

• Payables
• Receivables
• Payables in the System
• Receivables in the System

Account (affiliate)

ID of the account that is used by the selected affiliated company.

Account (ours)

You account that suits the account of the linked company.

Name

Name of your account.

Type

If we choose Replace, program will replace account of affiliated company. If we choose Exclude, it will not be take into account when collecting data form other databases.

Being Established

.

Exchange rate type

From drop down menu select type of exchange rate. You can select between:

• As defined on document
• Target date
• Document date
• Average rate
• Closing rate

Take Over Chart of Accts.

If you click this button, the program will display the chart of accounts that is used by the selected affiliated company.

Save Changes

If you click this button, the program will save entries to the Account (ours) column. All accounts of the affiliated company to which you have assigned a suitable account of your company will be transferred to the Accounts to Exchange window on the left side below in the panel.

Account (affiliate)

ID of the account that is used by the selected affiliated company.

Name

Name of the account that is used by the affiliated company.

Posting

Information in this field shows whether if the affiliated company has on the account debit posting, credit posting or both.

Subject Account

Information in this field shows whether the account of the affiliated company is defined as a subsidiary account.

Account (ours)

If an account of the affiliated company is not defined in your chart of accounts, you can assign him in this field your account.

Subsidiary Account

In this field the program displays account that is used by the selected affiliated company as a subsidiary account.

From department

In this field select department from which you would like to transfer matrix.

To department

In this field select department to which you would like to transfer matrix.

From Cost center

In this field select cost center from which you would like to transfer matrix.

To Cost center

In this field select cost center to which you would like to transfer matrix.