Chapter 16: Investments
Contents
1. InvOO3 CD 154604 03 31 2006 5 400 01 01 2013 03731 2008 In O0 ifi i CO 154667 05 31 2007 6 200 04 26 2014 05 31 2007 Accounting Payroll Investments s Indebtedness Accrual as e To delete an investment highlight that investment and click the Delete Button e After the delete option is selected the Confirm Investment Delete screen will appear below left Click on the Yes button to delete the investment e You will then receive a screen message below right that indicates the investment was deleted Click the OK button to complete the process Confirm Investment Delete Office of the State Auditor dne2012 CTAS User Manual 16 6 Investments Using the Search Feature In the Investments section you can choose from a number of options to search for investments The first and default option is to search by investments Not Sold w CTAS Investment Module 10 23 AM ps Cun Value Deve InvOO4 CD 1 254b 5 500 02 01 2012 03 31 2005 E cO CD 1 54605 05 31 2007 6 400 01 01 2012 05 31 2007 cO CD 154604 03 31 2006 5 400 01 8 2013 03 31 2005 Cerificate of Deposit CDF S460 05 31 2007 5 250 02 26 201 4 05 31 2007 7 To select investments not sold e Click on Not Sold radio button e Click the Search button e The investments meeting the search criteria will be displayed Office of the State Auditor ne2012 CTAS User Manual Investments Using the S2. Chapter 16 Investments June 2012 This Page Left Blank Intentionally June 2012 CTAS User Manual 16 1 Investments Introduction The Investment module is designed to track your investments By entering the interest earned on the investments CTAS will track the current value of the investments The Investment Module is integrated with the Accounting module so when you enter information for an investment the corresponding transaction is recorded in the receipts or disbursements Accessing the Investments Section To access the Investments module click on the Investments radio button at the bottom of any module s home screen The Investments screen as shown below will appear i CTAS Investment Module EJ 03 31 2006 5500 02 01 2012 CD 154665 0210 2007 6 400 01 01 2012 05731 2007 CD 154654 4 03731 2008 5 400 01 01 2013 03731 2008 Cerificate of Deposit CD 1 5460 j 05731 2007 5 250 02 26 2017 4 05 31 2007 Le sO se 1 s From the Investments Main Menu screen you can Add Edit or Delete an investment In addition by clicking on the Reports button you can print a Current Investments Report an Investments Activity Report or an Investments Worksheet Instructions on these reports can be found later in this chapter Office of the State Auditor ne2012 CTAS User Manual 16 2 Investments Entering an Investment To begin entering investments click on the Add button on the bottom of the Investments scre
3. Maturity Date e Click the Maturity Date radio button The screen will then display the Search by Maturity Date fields e Click on the first date field and enter a new beginning date or use the calendar by clicking on the down arrow at the end of the field e Click on the second date field and enter a new ending date or click on the down arrow at the end of the field to use the calendar e Click the Search button e Investments matching the criteria will then be displayed Office of the State Auditor ne2012 CTAS User Manual 16 9 Investments Usine the Search Feature continued You can also search by Sold Date w CTAS Investment Module 10 34 AM 01 01 2006 heaven H __ Cur Value Date Cu 1003 Cerificate of Deposit CO 521645 12 31 2005 e500 14 31 2006 12 31 2006 To search by Sold Date e Click the Sold Date radio button The screen will then display the Search by Sold Date fields e Click on the first date field and enter a new date or use the calendar by clicking on the down arrow at the end of the field e Click on the second date field and enter a new date or use the calendar by clicking on the down arrow at the end of the field e Click the Search button e Investments matching the criteria will then be displayed Office of the State Auditor ne2012 CTAS User Manual 16 10 Investments Printing Reports There are three reports that you can create and print from
4. ating Investment screen will appear shown below On the Updating Investment screen you change any field After completing your change s click Save and Add to make changes on another investment click Save and Exit when finished You can also enter any withdrawals in the Withdrawals section For information on entering the interest earned see chapter 23 Sample Transactions Investment ID finvo Type eD Description CD 2354 Interest Rate 1 000 Maturity Date fizs12012 M Deposits Fund Number Transaction Date Amount 100 General Fund 03 30 2011 10 000 00 _ som H 0 00 0 00 Withdrawals Fund Number Transaction Date Amount 03 30 2011 M 0 00 0 00 0 00 NOTE Set amount to 0 to clear row when saved Current Value 10 000 00 Save and Add Save and Exit Cancel Office of the State Auditor dne2012 CTAS User Manual 16 5 Investments Deleting a Investment The need to delete an investment could result 1f an error was made when the investment was entered w CTAS Investment Module Fille Accounting Payroll Investments Indebtedness Accrual Help Investments SearchBy J 5 Not Sold C 8 Sold Date search by Funds Not Sold C 6 Purchase Date 7 Maturity Date InvOOS CD 12354 03 30 2011 1 000 12 31 2012 03 0 2011 DANIE CD 1 2546 03 31 2008 5 500 02 01 2012 05 31 2008 Inr 001 CDi 154665 05 31 2007 6 400 01 01 2012 05 31 2007
5. earch Feature continued The second option is to search by Purchase Date ig CTAS Investment Module CD Certificate of Deposit CD CD CD 521645 CD 154685 CD 154687 CDi 2546 CD 154684 To search by Purchase Date e Click on the Purchase Date radio button The screen will then display the Search by Purchase Date fields 0631 2007 0631 2007 03 31 2006 03 31 2006 poem A 2500 12 31 2006 6 400 01 01 2012 5 250 02 26 2014 5 500 02 01 2071 4 5 400 01 01 2013 16 7 10 27 AM __ Curt Value Date Cu 12 31 2006 0531 2007 0531 2007 03731 2005 03731 2005 e Click on the first date field and enter a new beginning date or use the calendar by clicking on the down arrow at the end of the field e Click on the second date field and enter a new ending date or click on the down arrow at the end of the field to use the calendar e Click the Search button e Investments matching the criteria will then be displayed Office of the State Auditor June 2012 CTAS User Manual 16 8 Investments Using the Search Feature continued Another option is to search by Maturity Date w CTAS Investment Module 10 31 AM In001 CD c i 54605 05731 2007 6 400 01701 2012 05 31 2007 COF 2546 03 31 2006 5 500 02701 2012 03 31 2008 CD 154654 05 31 2008 5 400 01 01 2073 03 31 2005 Certificate of Deposit CO S4ho 05 31 2007 5 250 02 26 2014 05 31 2007 To search by
6. en w CTAS Investment Module __ Curt Value Date Cu CD 1 2546 5 500 02 01 2012 03 31 2008 1001 c CO 154665 02 10 2007 6 400 01 01 2012 05 31 2007 O01 Co CD 154654 03 31 2006 5 400 01 01 2013 03 31 2006 Ingi Certificate of Depasit CD 15466 05 31 2007 5250 Oefebfe014 05 31 2007 After the Add option is selected a New Investment screen will appear allowing you to enter the information for your investment An example of the New Investment screen is shown on the next page Office of the State Auditor 0 Jue2012 CTAS User Manual 16 3 Investments Entering an Investment continued New Investment When the New Investment screen appears complete the following steps Enter an investment number in the Investment ID field Note There isn t a pre determined numbering system for the Investment ID you will assign the number Enter the type of investment in the Type field Type could include Certificate of Deposit Savings Money Market etc Type a brief explanation of the investment in the Description field A description should identify the investment and can be the CD number Savings Account number Money Market number etc Enter the interest rate in the Interest Rate field This is for your information CTAS does not calculate the interest earned If the investment has a maturity date enter the date in the Maturity Date field In the Deposits section enter the fund number in the Fund Number field t
7. o indicate which fund purchased the investment Enter the date the investment was purchased in the Transaction Date field Enter the amount of the Investment allocated to this fund in the Amount field Continue to enter Deposit lines until the Investment is allocated to all of the funds Click the Save and Add button to continue to enter investments When all the investments have been entered click the Save and Exit button Information on entering withdrawals can be found on the next page Office of the State Auditor ne2012 CTAS User Manual 16 4 Investments Changing a Investment To change an Investment highlight the Investment and click the Edit Button CTAS Investment Module Fie Accounting Payroll Investments Indebtedness crual Help Investments Search By 5 Not Sold C8 Sold Date Search by Funds Not Sold Pa Search C 6 Purchase Date 7 M 7 Maturity Date ne Description Purchase Date Int Rate 12354 03 30 2011 1 000 12 31 2012 03 30 2011 In004 CD 12546 03 31 2008 7 5 500 02 01 2012 03 31 2008 In001 CD 154685 05 31 2087 6 400 01 01 2012 05 31 2007 In003 CD 154684 03 31 2008 5 400 01 01 2013 03 31 2008 Inv002 Certificate of Deposit CD 1 54687 05 34 2007 5 250 02 26 2014 05 31 2007 1 Add 2 Edit 3 Delete 4 Reports C Accounting C Payroll Investments Indebtedness C Accrual After the Edit option is selected the Upd
8. the Investments section They are the Current Investments Report the Investments Activity Report and the Investments Worksheet i CTAS Investment Module 10 40 AM zJ Purchase Date Maturity Date Curr Value Date InvOO4 CO CD 1 254b 5 500 02 01 2012 03 31 2006 E In00 CD 1 54605 05 31 2007 6 400 01 01 2012 05312007 In003 CD 154664 03 31 2006 5 400 01 01 2013 03 31 2006 Invo02 Certificate of Deposit CDF S460 05 31 2007 D250 02 26014 05 31 2007 To select a report you want to create click on the Reports icon at the top of the Investments screen or click on the button at the bottom of the screen A Reports screen will appear as shown on the next page Office of the State Auditor ne2012 CTAS User Manual 16 11 Investments Printing Reports continued To run a report highlight the report and click the Run Button So Current Investments Investment Activity Investment vyorksheet Chapter 17 of this manual entitled Investment Reports describes each report and illustrates how to create and print each one Office of the State Auditor ne2012
Download Pdf Manuals
Related Search