Investment Ledger - Migration from Tangible Fixed Assets - Investments

Prior to the implementation of the investment ledger, users could use the fixed asset ledger to set up an Investment asset. This was designed to be used for property investments, but it has been used to hold other forms of investments.

The Investment ledger feature allows for all the organisation's investments to be fully recorded, managed and reported.

Types of Investment

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

An investment may be tagged as a social investment and highlighted in reports.

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.

Moving Property Investments in the Asset Ledger to the Investment ledger

This must be done as part of entering the investment ledger opening balances. It is only necessary to do it the once.

Where there are tangible fixed assets in prior years in the system, it is only values from the end of the very last year that you need to migrated to the investment ledger.

Note that the Investment ledger does not support automatic depreciation. Investment property fair (market) value will be managed by events such as revaluation, impairment, reverse impairment.

Follow the process below:-

Run a Fixed Asset Net Book Value Report at the Opening Balance Date
Take a note of the Cost Value and the Net Book value (if different)
List and select the relevant asset on the Asset Ledger
Navigate to the Disposal/Reinstatement tab enter a disposal value equivalent to the net book value noted above. Make the disposal date the Opening Balance Date. Click Dispose.
Re-open the prior year if it is in a closed state to allow the journal below.
Navigate to Control - Batch Jobs - Batch Run History - Delete the Year End Close job
Add a Journal as follows
  • Date is the opening balance date above
  • Select the Asset Name from the dropdown
  • Add Item, Debit account Suspense with the Net Book Value above, Save Item
  • Add Item, Credit account Disposal of Assets with the Net Book Value above, Save Item
  • Submit
Enter the Property Investment as an Opening Balance in the Investment Ledger
  • Name the Investment
  • Investment Type is Property
  • Choose the relevant fund and the Investment Holding Account
  • On the Initial Investment tab, the historic cost is the Cost Valued noted above and the unit price the Net Book Value
  • Submit when done
Check figures in the opening balance sheet report
Ensure the balance sheet is reflecting what is expected.
Re-close the prior year if it was re-opened
Navigate to Control - Batch Jobs - Close Financial Year

Moving Investments in the Asset Ledger to the Investment ledger

Repeat the same process, but choose the correct Investment Type