Add/Edit Investment

This screen is used to create or edit an investment.

When adding an investment it captures the definition of the investment as well as information needed for an addition event which will trigger creation of a purchase transaction.

Subsequent editing of an investment allows for some changes to the definition of the investment but the transactional detail can only be changed by deleting event(s) and recreating them with the corrected values.

Where the screen has been accessed via the opening balance routine the header will display the Balances Brought-in date read-only to be used for the opening balance transaction.

An accordion screen with two sections is displayed when adding a new investment. Click the section headers to display as required. When reviewing an existing investment only the Description and Configuration section is displayed.

  1. Description and Configuration
  2. Initial Investment

Investment

Enter a name for the investment. If required a note can also be added.

Investment Type

Investments are categorised, in the system, over the following types:-

An investment may be tagged as a social investment and highlighted in reports. The Charity Commission requires social investments to be reported separately in the year end accounts.

The categorisations are those required for annual accounts for filing purposes, so if the user is unclear as to which to allocate to any particular investment they are urged to consult with their professional advisor.

Investment UoM

Each investment will have a unit of measure (UOM). The selected UoM determines how the total value of each investment is calculated. Each Investment Type has a default UoM set by the system. The user may amend if required.

Currency
A unitary monetary figure (normally in £ sterling); the default for Fixed Term Cash Deposits and Bonds where you might record 1 deposit of £10k or 2 bonds of £25k.
Unit
A unitary number; the default for Commodity. Can also be appropriate for holdings in unit trusts where you might record 1.25KG of silver or 237.23 units of H&L Overseas Investment Unit trust.
Shares
A unit of a single share; the default for Listed and Unlisted Investments. For examples of how the system deals with valuation of shares over the various events associated with Stock and Shares click on the link.
Each
A single investment; the default for Property Investments.

Fund

Select the Fund that the investment is associated with.

Activity/Department

Where Activity and/or Department analysis are in use, select what is associated with the Investment

Holding Account

Select the balance sheet account that will hold the value of the investment. If the required account does not exist, navigate to Accounts Menu and use Add Custom Account to set it up.

One of two screen layouts will be displayed, one for a adding a new investment the other for adding details for an opening balance investment.

Adding a new Investment

Reference

Enter a suitable reference if required.

Date Acquired

Enter the date the investment made.

Quantity

Enter the quantity consistent with the chosen UoM.

Unit Price

Enter the investment unit purchase price. The total value of the investment will be Quantity x Unit Price.

Supplier

Select the supplier from which the investment was made. If the supplier is not in the drop-down list, start typing and the add a supplier screen appears.

Bank Account

Choose the bank account from which the purchase was made.

Fees and Fee account

If there are transaction fees, enter the fee amount paid and choose an expense account to record the transaction fee.

Adding an opening balance for an investment

Reference

Enter a suitable reference if required.

Date Brought in

The date displays the Balances Brought-in date. This is a read only field.

Historic Cost

When bringing an investment in as part of opening balances this value is needed to be able to accurately report the average unit cost for an investment. i.e. if your opening balance represents the total of 3 tranches of share purchases record the total paid for the 3 tranches. N.B. this figure may well differ from the value obtained from Quantity * Unit Price

Quantity

Enter the quantity brought in consistent with the chosen UoM.

Unit Price

Enter the investment unit price as reflected by any values brought into your opening balances from your previous accounts, assuming all necessary adjustments were made to your previous accounts after any revaluations of the investments.

Related Topics