Investment Register Links

Chart of Accounts Setup Options

Cashbook provides the capability to maintain an Investments Register to track details of investments e.g. shares, fixed term deposits, unit trust investments, rental property, etc.

The Investment Register can be used to maintain details of the purchase of investments as well as the related income and capital gains.

Option 1

Automatic updating of the Investments Register can occur via a Cashbook transaction entry. In this way, the investments register can be updated as purchases or sales of investments (or related income & expenses) are entered into cashbook.

Option 2

Alternatively, the investments register can be maintained independently of any other transactions.

Accounts needed when using the Investment Register to track details of share investments:

Setup an Asset account
Setup an Other Expense account for the purchase of Share Investments
Setup an Other Income account for the sale of Share Investments
Setup an another Other Income account for share income, dividend, distributions, etc

Setting Up and Linking Accounts in the Chart to the Investment Register

Step 1: Setup Asset Account - Share Investments

This is so the value of the share portfolio is reflected on the balance sheet as an asset

Click Chart tool bar option
To add a new account, click Add
To edit an existing account, select the account and click Edit
Chart of Accounts setup:

Account Code: 785
Description: Share Investments
Account Type: Asset
GST Category: 10. Non-reportable Payments
Reporting Group: 7-780 Investments

Step 2: Set up an Other Expense Account - Shares Purchased

Click Chart tool bar option
To add a new account, click Add
To edit an existing account, select the account and click Edit
Chart of Accounts set up:

Account Code: 460
Description: Shares Purchased
Account Type: Other Expense
GST Category: 10. Non-reportable Payments
Reporting Group: 4-460 Investments Purchased
Register Link: Investments
Balance Sheet Link: 785 Share Investments

Step 3: Set up an Other Income Account - Shares Sold

Click Chart tool bar option
To add a new account, click Add
To edit an existing account, select the account and click Edit
Chart of Accounts setup:

Account Code: 410
Description: Shares Sold
Account Type: Other Income
GST Category: 10. Non-reportable Receipts
Reporting Group: 4-410 Investments Sold
Register Link: Investments
Balance Sheet Link: 785 Share Investments

Step 4: Set up an Other Income Account - Share Income/Dividends

Click Chart tool bar option
To add a new account, click Add
To edit an existing account, select the account and click Edit
Chart of Accounts setup:

Account Code: 645
Description: Share Income/Dividends
Account Type: Other Income, if the investment activity is not part of the main business e.g. farming. Operating Income if it is part of the business
GST Category: 10. Non-reportable Receipts
Reporting Group: 6-600 Off Farm Income
Register Link: Investments

Click on the following link to: add a share purchase to the investment register via cashbook transaction

Article ID CBP905