Investment club software

From Wikipedia, the free encyclopedia

Investment Club Accounting Software is typically used to manage:

  • Member Subscriptions
  • Ownership / Unit Valuation System
  • Investment Transactions
  • Financial Reports
  • Income / Expenditure transactions
  • Performance reports
  • Manage tax returns

Contents

[edit] Member Subscriptions

Investment Clubs are groups of people who meet up on a regular basis to make investment decisions, which are typically associated with stock market investments. On a periodical basis investment club members contribute to an investment fund, typically via monthly 'subscriptions'. Investment club accounting software provides a means of tracking and managing monthly subscriptions made by each club member.

[edit] Allocating Ownership

Investment clubs tend to use one of three methods for managing the allocation of ownership, profit and loss for investments that an investment club makes.

The first method is based on simple Equal Ownership, whereby each investment club member contributes exactly the same amount per month on the same day.

The primary benefit of using an Equal Share Ownership percentage scheme, whereby each club member contributes an equal amount on a fixed date each month, is simplicity. The challenges with an Equal Share Ownership scheme, are what happens if a club member:

  • can not make a monthly payment
  • makes a late payment
  • needs to withdraw money
  • wishes to increase or decrease their monthly contribution
  • is new and can not afford to pay the historical monthly subscriptions that have been paid by legacy club members

The second approach is the Optional Allocated Ownership scheme. This allows individual investments, right down to individual parcels of stock, to be assigned to one or more investors on a percentage basis. Any investments which are not assigned specific ownership splits are assumed to be pooled as they would be under Equal Share Ownership above. Systems using this approach will segregate income and expenses associated with the individual investments according to the ownership tables for a clearer. An important advantage of the Optional Allocated Ownership scheme is that it allows for the representation of the differences in contribution levels that may emerge over time.

Another approach used is the Unit Valuation System (UVS). The primary benefit of using a Unit Valuation System is flexibility to make varying subscriptions or withdrawals at any point in time and it addresses the short comings of the equal share ownership scheme. An important challenge of such a system is that it relies upon the timely revaluation of all investments to arrive at the unit values. This introduces significant manual processing in cases where valuations are not automated, however most modern Investment Club Accountancy products provide real time automated stock market portfolio valuation therefore overcoming this challenge. Click here for an example of how the Unit Value is calculated.

Investment Club accounting software should provide a means of managing either an equal share ownership scheme, optional allocated ownership scheme or a Unit Valuation System.

[edit] Investment Transactions

Typically in an investment club has between 10 and 20 members. Only the club treasurer or a limited number of club traders will actively manage the club investments. A solution is therefore required to enable all club members have visibility of the investment club transactions, without for example any potential issues with club members having to log on to the investment club's brokerage account.

[edit] Financial Reports

Financial Reports should ideally include the ability to generate transaction reports and financial statements for defined periods of time. Typical financial statements include Investment Transaction History, Income & Expenditure statements, Member Unit Valuation & Ownership reports, Balance Sheet, Income Statement and Cash Flow.

[edit] Income / Expenditure transactions

Investment clubs typically generate expenditures over and above normal brokerage charges. For example an investment club may rent a room for club meetings, or use profits/subscriptions to pay for a meal for club members. If a club is using a Unit Valuation System to track performance, typically non-tax deductible or non-investment related expenses are excluded from the Unit Value calculations through a process referred to as Unit Cancellation.

[edit] Performance Reporting

Investment club software should provide members with a clear report of the clubs performance. Performance reporting, as the name would suggest, is primarily concerned with reporting investment performance using a variety of metrics that can be generally classified as Money Weighted Return or Time Weighted Returns metrics. Secondary performance metrics commonly used are Profit and Loss, Asset Allocation, Dividend Yield, Sector Weighting, Investment Types, Performance Comparison to market indices, stocks etc.

Performance reporting should not be confused with financial reporting, such as the generation of Balance Sheet, Cash Flow and Income Statements. Financial reports reflect the state of a set of accounts at a specific point in time, and not their performance over a defined period of time.

Time Weighted Returns (TWR) are a means of measuring performance over time, independent of the amount invested or withdrawn. The Unit Valuation System is an example of TWR system whereas the Internal rate of return is a Money Weighted measure of performance.

Money Weighted Return (MWR) metrics are used to establish investment performance for a portfolio and are ideally suited to comparing investment performance. Money Weighted Returns metrics such as Internal rate of return enable investors to determine financial performance based on series of cash flows such as money deposited, varying investment returns and money withdrawn over a defined period of time.

For a comparison of Money Weight Return metrics versus Time Weighted Return metrics, click on the following link: Time Weighted Return versus Money Weighted Return Performance Metrics

[edit] Manage tax returns

In the UK, investment clubs have to generate an Inland Revenue tax return called Form 185(New). Form 185(New) provides a statement of a club member's share of gains for the years and indicates each investment sold, the time at which it was acquired and the date each member joined the club. The allocation of gains in the UK is typically based on allocation of units that are calculated using the Unit Valuation System.

[edit] Providers of Investment Club Accounting Software