Home → Campaign Manager → Georgia State Report → Investment Schedule - How to Pull Purchases, Interest, and Dividend Transactions
45.5. Investment Schedule - How to Pull Purchases, Interest, and Dividend Transactions
How to Enter a "Purchase" Transaction
You will need to create a new Expense transaction for this. See below screenshots for each required field, as well as how it will appear on the GA Investment Schedule. Fill in each of those fields, and you also must make sure you set the "Reporting Code" to "TRNS-P".
You can add multiple purchase transactions for the same investment by making sure to enter the exact same "Investment Name" into the "Reporting Description" field of the expense. For the example shown in the below screenshot, you could add an additional purchase transaction by creating a new expense and entering "Georgia Investment Name" into the "Reporting Code" field of that expense. Campaign Manager will see that the "Reporting Description" is the same for both expenses and will include them both under the same investment.
FINAL STEP: You must also always make sure you click the "Linking" tab within the expense, select "Advanced", and use the advanced linking feature to link this purchase transaction to any other existing purchase, interest, or dividend transactions. The transactions must all be linked together for them to pull properly to the Georgia Investment Schedule.
How to Enter an "Interest" Transaction
You will need to create a new Contribution transaction for this. Fill in each field shown in the below screenshots and that info will pull to your report as you need it to.
Make sure you enter the exact same text into the "Reporting Description" field of this contribution that you entered for the "Purchase" transaction you created above. You also must make sure you set the "Reporting Code" section of this contribution to "INT".
FINAL STEP: You need to click the "Linking" tab within the contribution, select "Advanced", and use the advanced linking feature to link this new contribution to the existing "Purchase" transaction you created while following the above "Purchase" transaction steps.
How to Enter a "Dividend" Transaction
You will need to enter a new Expense transaction for this. Fill in all the required fields and this info will show on your report as you need it to.
Make sure you enter the exact same text into the "Reporting Code" field of this expense that you entered for any "Purchase" or "Interest" transactions you created above. You must also make sure you set the "Reporting Code" field within the expense to "DVND".
FINAL STEP: You need to click the "Linking" tab within the contribution, select "Advanced", and use the advanced linking feature to link this new expense to any existing "Purchase" and "Interest" transactions you created while following the above steps.