Investment Income Generation

Overview

The Investment Income Generation screen helps automate the process of recording distributions, dividends, and accruals for investments.

By using ASX and UUT income data, the Investment Income Generation screen can calculate and post the expected income transactions based on how many units are recorded in each investment account.

Navigation

From the Main Toolbar, go to Accounting.
Select Investment Income Generation from the list.

Instructions

Generate Transactions Deleting Transactions

Generate Transactions

---

The Investment Income Generation screen will display each investment grouped by type along with the calculated Investment Income Data and Ledger Data currently entered into the system:

~~Click the above image to expand~~

1. To post transactions, first, ensure the desired Income type is selected.
   
   The income type selected will determine which transaction is posted:

   Income Type	Credit
   23800 - Distributions	23800/INVESTMENT
   23900 - Dividends	23900/INVESTMENT
   61800 - Receivable	IF 61800/INVESTMENT does have an existing Debit balance: 61800/INVESTMENT
   	IF 61800/INVESTMENT does not have an existing Debit balance: 23800/INVESTMENT

2. For each transaction required, click the checkbox in the left column:
   
    
3. Once all transactions have been selected, click Post Amounts:
   
   If Income transactions for the selected investments have already been posted, you will be prompted to review these transactions before proceeding:
   
    
4. The Investment Income Generation screen will update the ledger data with the new transactions. When this matches the estimated income displayed, the transaction will be coloured green:
   
   ~~Click the above image to expand~~
   
   The transactions can also be located in the transaction list. These are all posted against a clearing account (92000/Investment Income Data Clearing Account):
   
   ~~Click the above image to expand~~

Deleting Transactions

---

To delete any transactions created using the Investment Income Generation screen, simply delete the transaction from the Transaction List:

From the Main Toolbar, go to Accounting.
Select Transaction List from the list.

1. Find the transactions you want to delete. You can search for the investment, payment date, or amount to find the necessary transactions:
   
    
2. Select the check box to the left of the transactions:
   ~~Click the above image to expand~~
    
3. Click Delete:
   

Filtering the Investment Income Generation Screen

Use the search options in the top-right corner of the screen to filter what investment transaction details are displayed.

You also have the option to hide year-end accrual income using the Filters button:

Unmatched Transactions and Discrepancies 

If there is a discrepancy between the Ledger and the Investment Income Data, do not post directly from the Investment Income Generation screen.

First, review whether the income already received in the Transaction List is correct.

• If the amount is incorrect or missing, manually enter the transaction with the correct value. Posting from the Investment Income Generation screen will post the full amount rather than just the remaining balance, which may result in duplicated or overstated income.

If the income received is already correct:

• Ignore any grey rows displayed in the Investment Income Generation screen, as these may represent duplicate or unmatched entries.

Reconciliation should always be completed against your bank statements. If the income has already been recorded correctly in the Transaction List, any additional entries shown in the Investment Income Generation screen can be safely disregarded.

Example

You receive a dividend of $100 with a Date Payable of 15 March, which is already recorded correctly in the Transaction List. However, the Investment Income Generation screen still shows a grey row for the same $100 (with the same or different Date Payable).

• If you post this from the screen, another $100 will be recorded, resulting in $200 total income (overstated).
• Instead, confirm the original $100 and Date Payable are correct and ignore the grey row.

If instead only $80 was recorded in the Transaction List (with a Date Payable of 15 March):

• Do not post from the Investment Income Generation screen.
• Manually enter the missing $20 using the correct Date Payable to ensure the total income equals $100.