<< Click to Display Table of Contents >> Navigation:  General > Import data > Import Portfolio transactions

The next fields can be allocated:

 

1. Bookkeeping *

2. Type of transaction *

3. Date transaction

4. Bank account *

5. Name/code stock *

6. Quantity *

7. Price of stock **

8. Total amount **

9. Transaction currency

10. Currency rate to Bank daybook

11. Description

12. Incl. costs

 

 

1. Bookkeeping

The value of the field bookkeeping in the import file. must be equal to the name of the bookkeeping.

The name can be set in Maintenance> company data.

If the name of the bookkeeping in the import line is not equal to the name of the bookkeeping in which the import is started, the line will not be displayed in the proposal.

 

2. Type of transaction.

The type of transaction is to determine the kind of transaction.

In the screen 'Import data' the codes used in the import file has to be allocated to a Mill7 transaction code.

- Buy

- Sale

- Opening balance

- Stock dividend

- Interest

- Short Sale

- Short Cover

- Other banktransactions

 

3. Date transaction

This is the date the transaction took place.

If the date is not connected, Mill7 chooses the date of processing.

 

4. Bank account

The bank account must occur in a daybook in Mill7. The bank account can be set in the maintenance menu. Choose option Daybooks. In the concerning daybook, in field Bank account, the bank account can be set. Depending of the bank account in the import file the transaction will be imported to the concerning daybook.

 

If the bank account cannot be found in a daybook, the import line can not be processed and the import line will get status: Account does not exist in "Bank-daybook" and cannot be imported.

 

5. Name/code stock

The value of field "stock" must occur in the file with stock.

This file with stock can be found in screen Portfolio, tab page "Stock"

In field "code" a list will pop up when F4 is pressed. This list shows all the stock.

The value of the field "Stock" must be identical to the name or code of one of the stocks in the list.

 

If the kind of stock cannot be found in the file, the import line cannot be processed and will receive the status: "Stock not found"

 

6. Quantity

The number of stock applied to the transaction.

 

7. Price of stock

The price of one stock at the date of transaction.

 

8. Total amount

The total amount of the transaction. If the total amount appears in the import file, the price per stock will be calculated by dividing the total amount by the number of stock.

 

9. Transaction currency

If the amounts, in the import file, are in a transaction currency that is different from the daybook currency, the different currency must be indicated.

 

10. Currency rate to Bank daybook

If the transaction currency is different from the daybook currency, the rate must be indicated.

The amounts in the import file will be recalculated to amounts in the currency of the daybook.

 

11. Description

Extra information for the transaction.

 

12. Incl. costs

The amount of costs for this transaction.

 

The currency of the transaction is set by Mill7.