Welcome to Gravity Help
Investments

Investment Activities

Each Investment transaction is recorded as a separate investment activity. The Investment Activity types are:

  • Purchase
  • Sale
  • Market Revaluation
  • Currency Revaluation
  • Interest Payment
  • Dividend Payment

Currency and Market Revaluations



Document image


Currency and Market revaluations can be performed in bulk from the Investments grid. Selecting the menu option for Currency and Market Valuation opens the revaluation dialog.

Currency Revaluation



Document image


Process

  • Select appropriate values in the grid header
  • Select Investments to be revalued
  • Enter new FX Rate
  • Post transactions.

Select Action

Select Currency Revaluation

Show All Entities

You can filter the grid for the current entity or all entities to simplify the revaluation of multiple investments.

Apply Date

Apply Date represents the GL date for the Journal Entries created for the currency revaluations

Transaction Date

Transaction Date represents the date for the Entry Date created for the currency revaluations

Currency

Selecting a single currency will filter the investments for only the selected currency

Market Revaluation



Document image




Process

  • Select appropriate values in the grid header
  • Select Investments to be revalued
  • Enter new valuation
  • Post transactions.

Select Action

Select Currency Revaluation

Show All Entities

You can filter the grid for the current entity or all entities to simplify the revaluation of multiple investments.

Apply Date

Apply Date represents the GL date for the Journal Entries created for the currency revaluations

Transaction Date

Transaction Date represents the date for the Entry Date created for the currency revaluations

Purchase/Sale/Interest Payment/Dividend Payment



Document image


Purchase/Sale/Interest Payment/Dividend Payment transactions are entered directly from the Investment Ledger grid. Transactions saved must be Posted from the Action Menu to update the investment values.

Purchase



Document image


Investment Activity Information

Activity Type

Select Purchase from the activity list

Investment ID

Select the appropriate Investment

Apply Date

Apply Date represents the GL date for the Journal Entries created for the currency revaluations

Transaction Date

Transaction Date represents the date for the Entry Date created for the currency revaluations

Journal Entry ID

This field displays the Journal ID created from posting the investment transaction.

Financial

Create Journal Entry

Select Yes to create a Journal Entry in the General Ledger when the transaction is posted. If no is selected no Journal Entry will be made.

Distribution From Account

Select the GL account that would be credited in the Journal Entry created. The GL account listed in the Investment details will be debited with the entry.

Voucher

Create Voucher for Payment

Select Yes to create a Voucher in Accounts Payable to be processed through the normal AP protocols.

Total

Quantity

Enter the quantity purchased

Cost per Unit

Enter the cost per unit quantity purchased

Currency

If the investment is in a foreign currency you can override the exchange rate for the transaction

Sale



Document image


Investment Activity Information

Activity Type

Select Sale from the activity list

Investment ID

Select the appropriate Investment

Apply Date

Apply Date represents the GL date for the Journal Entries created for the currency revaluations

Transaction Date

Transaction Date represents the date for the Entry Date created for the currency revaluations

Journal Entry ID

This field displays the Journal ID created from posting the investment transaction.

Financial

Create Journal Entry

Select Yes to create a Journal Entry in the General Ledger when the transaction is posted. If no is selected no Journal Entry will be made.

Proceeds Account

Select the GL account that would be debited in the Journal Entry created. The GL account listed in the Investment details will be credited with the entry.

Total

Quantity Sold

Enter the quantity Sold

Override Cost

If set to Yes, the user can override the system generated cost.

Cost per Unit

System generated if not overridden

Sale Amount per Unit

Enter the per unit sales amount.

Total Cost/Total Sale Amount/Gain/Loss

System calculated values

Realized Gain/Loss & Unrealized Gain/Loss

Users must define the portion of the calculated gain/loss to be recorded as Realized and Unrealized

Currency

If the investment is in a foreign currency you can override the exchange rate for the transaction

Interest/Dividend Payment



Document image




Investment Activity Information

Activity Type

Select Interest Payment or Dividend Payment from the activity list

Investment ID

Select the appropriate Investment

Apply Date

Apply Date represents the GL date for the Journal Entries created for the currency revaluations

Transaction Date

Transaction Date represents the date for the Entry Date created for the currency revaluations

Journal Entry ID

This field displays the Journal ID created from posting the investment transaction.

Financial

Create Journal Entry

Select Yes to create a Journal Entry in the General Ledger when the transaction is posted. If no is selected no Journal Entry will be made.

Proceeds Account

Select the GL account that would be debited in the Journal Entry created. The GL account listed in the Investment details will be credited with the entry.

Interest/Dividend Revenue Account

Select the GL account to be credited from the proceeds.

Total

Interest/Dividend

Enter the amount of the Interest or Dividend proceeds.

Currency

If the investment is in a foreign currency you can override the exchange rate for the transaction