Chapter 16 Investments - Office of the State Auditor
Contents
1. Chapter Investment This Page Left Blank Inte ally 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 tabi in the Task Bar then the Accountipy a Payroll Investments Indebtedness Reports Admin Help Exit a Investment lt 4 04 PM Add Investments LT ID Y Type 7 Description Y Maturity Date Y Purchase Date Y IntRate Y Curr value Amount Y Curr Value Date Y Sold Date Y 12 4 005 00 05 14 2014 i Li 1 1 I From the Investment main menu screen you can Add Investments Edit Delete or Export to CSV an investment By clicking on the Reports tab you can print a Current Investments Report Current Investments with Accrued Interest Report Schedule 8 Investment Activity Report Schedule 8 Investment Activity Report with Accrued Interest Investment Worksheet Report or an Investment Worksheet with Accrued Interest Report Instructions on these reports can be found later in this chapter Office of the State Auditor CTAS User Manual 16 2 Invest2. I Confirm Delian H y M T r I I ti t1 L Are you sure you Want to delete the 1 selected items t Abso the list below shows associated investment deposits that will also be deleted TE you would like to prevent this from occuring pledse I uncheck the box below LA I I 1 T LA 1 01 Certificate of Deposit 18 Month CD which is associated with IAD108 I I I I f I ri I I I I I T I v The IAD disbursement should now be deleted and the investment created should have its balance intact Office of the State Auditor CTAS User Manual 16 6 Investments Changing an Investment To change an investment highlight the investment while in the Investments List tab and click the Edit button I A 4 a n Accounting Payroll Investments Indebtedness Reports Admin 7 Felp Exit t Zen a 1 1 Beis a Investment Y Sold Date Y Y IntRate Y Curr value Amount Y Curr Value Date Y Description Y Maturity Date Y Purchase Date 02 03 2014 Office of the State Auditor CTAS User Manual 16 7 Investments Changing an Investment continued After the Edit button is selected an individual investment tab will appear shown below On the individual investment screen you change any field After completing your change s click Save when finished You caf also enter any deposits w
3. 02 18 2015 cd 0000000000000000 02 18 2015 00 500 00 0218 2015 jf f f 03022015 0 100 00 03 02 2015 DEdt 3 Delete 4 Exporttocsv y To search by Purchase Dated A e Choose the Purchase Date option The screen will then display the Search by Purchase Date fields e Click on the first date field and enter a 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 an ending date or click on the down arrow at the end of the field to use the calendar e Click the Search button Investments matching the criteria will then be displayed Office of the State Auditor CTAS User Manual 16 12 Investments Using the Search Feature continued Another option is to search by Maturity Date Accounting Payroll Investments Indebtedness Reports Admin Eit Investment Investment 7 25AM Investments List Add Investments Search by Maturity Date 02 10 2015 m To 0303 2015 Not Sold Sold Date T ID Purchase Date Type Y Description Y Maturity Date Y Purchase Date Y IntRate Y Curr value Amount Y Curr Velue Date Y Sold Date Y Mak DAS cp 3Year CD 02032017 02032014 12 4 006 00 057142014 90000000000000000 02 18 2015 06 500 00 02 18 2015 ca 0000000000000 Use 20 UU if ni f 03022015 0 100 00 03 02 2015 x N N N N N N
4. N N N N N N N N N N N N N XN y N N N N N N N b N N N N N N N XN N N a N 2 Edit 3 Delete 4 Exportto CSV N N N N N To search by Maturity Date e Select the option to search by Maturity Date The screen will then display the Search by Maturity Date fields e Click on the first date field and enter a 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 an ending date or click on the down arrow at the end of the field to use the calendar e Click the Search button Investments matching the criteria will then be displayed Office of the State Auditor CTAS User Manual Investments Printing Reports 16 13 There are six reports that you can create and print from the Investments section They are the Current Investments Report Current Investments with Accrued Interest Report Schedule 8 Investment Activity Report Schedule 8 Investment Activity with Accrued Interest Report Investment Worksheet Report and the Investment Worksheet with Accrued Interest Report CF Accounting Payroll Investments Indebtedness Reports Admin Help Exit 3 y a sb cbasg S T Receipts Claims Disbursements Budget Cash Chartof Vendors Financial Tax Payroll Year Thdebtedness Accounts Reports v Filing to Date Accounting N Employee 4 Investment
5. ithdrawals or accrued interest while in an individual inyestment tab 1 ua ee ee Accounting Investment Investment Investments List Add Investments Investments 001 x InvestmentiD 001 Description 3 Year CD Deposits Fund Number p 100 General Funds 100 General Funds Delete Selected Records Withdrawals Fund Number p 100 General Funds Delete Selected Records Transaction Date 02 03 2014 03 31 2014 Transaction Date 05 14 2014 Indebtedness 1 Reports Admin Help Exit a y 4 Ae Type cD Maturity Date 02103 2017 7 Interest Rate 4 1205 Transaction Amount Fund Number Transaction Date Transaction Amount 5 000 00 x 5 00 Delete Selected Records Transaction Amount 1 000 00 Current Value 4005 00 Import from File S Cancel Office of the State Auditor CTAS User Manual 16 8 Investments Deleting an Investment The need to delete an investment could result if an error was made when the investment was entered p _ Accounting Payroll Investments Indebtedness Reports Admin Help Exit d Investment t Add Investments lip Y Type Y Description Y Maturity Date Y Purchase Date Y IntRate Y Currfvalue Amount Y Curr Valve Date Y Sold Date Yi cD C 0203 2017 02 03 20 12 ee Dedit 3 Delete 4 Exportiocsv x s 3 e To delete an in
6. ments Entering an Investment To begin entering investments click on the Add Investments tab at the top of the Investment screen ae 7 Accounting Payroll Investments Indebtedness Reports Admin Ap Exit Investment ite Add Investments ID Y Type Y Description Y Maturity Date Y Purchase Date 070301 Y IntRate Y Curr valueAmount Y Curr Value Date Y Sold Date y 1203 2014 12 j DEdita 4 Export io CSV After the Add Investments tab is selected the Add Investments screen will appear allowing you to enter the information for your investment An example of the Add Investments screen is shown on the next page Office of the State Auditor CTAS User Manual 16 3 Investments Entering an Investment continued L3 Accounting Payroll Investments Indebtedness Reports Admin Help Exit Investment Investment LF 4 07 PM 4 Investments List Add Investments InvestmentID Type Maturity Date Description Interest Rate 0 000 Deposits Accrued Interest Fund Number Transaction Date Transaction Amount Fund Number Transaction Date Transaction Amount Delete Selected Records Delete Selected Records Withdrawals Fund Number Transaction Date Transaction Amount Delete Selected Records Current Value Import from File Cancel When the Add Investments screen appears complete the following steps e Enter an investment number in the InvestmentID field Note There is no
7. nes are plugged in 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
8. s Indebtedness hi Investments M T 4 53 PM rg Report Name ye Current Investments y Current Investments with Accrued Interest Fi Schedule 8 Investment Activity Schedule 8 Investment Activity with Accrued Interest md Investment Worksheet NV Investment Worksheet with Accrued Interest Pa y rA ti Z g 1 A pi A 1 J 1 A h 2 7 1 r 1 ed mo gt A 7 k y To seleet a report you want to create click on the Reports tab from the Task Bar then the Investments icon A Report Name screen will appear as shown above Office of the State Auditor CTAS User Manual 16 14 Investments Printing Reports continued To run a report meen the report and click the Run button O M o _ Accounting Payroll Investments Indebtedness Reports Admin Help Bits S55 OGG e 2 Oe a E Receipts Claims Disbursements Budget Cash Chart of Vendors Tax Payroll YgSr Investments Indebtedness 1 Accounts Reports Filing to Dg Accountigg Employ Investments Indebtedness a Current Investments Current Investments with Accrued Interest Schedule 8 Investment Activity 7 Schedule 8 Investment Activity with Accrued Interest Investment Worksheet F Investment Worksheetwith Accrued Interest j No speakers or headpho
9. sly purchased and has not been entered in CTAS Follow the above steps to create an investment pages 16 2 through 16 3 Delete button 1 Accoun ting Payroll Investments Indebtedness Reports Admin Exit a aa E ww GB g Receipts Claims Disbursements Budget ash Chartof Vendors ih counts Disbursements Disbursements List Add Disbursement Search By A Searchyby Disbursement Date Disbursement Dat i x Date rofl oaraidyis bursement nN AD108 To 04 16 2015 YH Vendor Certific ion 900 Ot 2 View Edit a voia ea l 4 Delete 5 Export to csv 6 Print The Confirm Deletion box will appear as seen on the next page Office of the State Auditor CTAS User Manual 16 5 Investments Adding an Existing Investment continued This box confirms that you want to delete the disbursement and gives you the opportunity to not delete the entry made in the Investment section By unchecking the Delete associated investment deposits box the entry made in the Investment section will remain fi Confirm Deletion Are you sure you want to delete the 1 selected items the list below shows associated investment deposits that wibl also Also If you would like to prevent this from occuring please be deleted uncheck the box below 0i Certificate of Deposit 18 Month CD aa associated with IADi0 gt V Delete associated investment deposits
10. t a pre determined numbering system for the InvestmentID you will assign the number e Enter the type of investment in the Type field Type could include Certificate of Deposit Savings Money Market etc e 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 e Enter the interest rate in the Interest Rate field This is for your information CTAS does not calculate the interest earned e Ifthe investment has a maturity date enter the date in the Maturity Date field e In the Deposits section enter the Fund Number in the Fund Number field to indicate which fund purchased the investment e 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 e Continue to enter Deposit lines until the investment is allocated to all of the funds e Click the Save button to continue to enter investments Information on entering withdrawals and accruals can be found later in this chapter Office of the State Auditor CTAS User Manual Investments Adding an Existing Investment 16 4 Once the investment is saved you will need to delete the corresponding disbursement that CTAS creates IAD Highlight the investment disbursement in question then select the This section refers to adding an Investment that was previou
11. te 02102015 To 03 03 2015 lz o El Search Not Sold ID Purchase Date p Type Y Description Y Maturity Date Y Purchase Date Y IntRate Y Curr value Amount Y Curr Value Date Y Sold Date Y Matury Date Jco 3 Year CD 020372017 02032014 12 4 005 00 05 14 2014 ed 90000000000000000 02 18 20 00 500 00 02 18 2015 ff f f 03 02 2015 0 100 00 03 02 2015 DEdit 3 Delete 4 Exporttocsv s To search by Sold Date e Select the Sold Date option The screen will then display the Search by Sold Date fields e Click on the first date field and enter a 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 an ending date or use the calendar by clicking on the down arrow at the end of the field Click the Search button e Investments matching the criteria will then be displayed Office of the State Auditor CTAS User Manual 16 11 Investments Using the Search Feature continued Another option is to search by Purchase Date Ws lay aan a i Accounting Payroll Investments Indebtedness Reports Admin Exit Search by Purchase Date 02 10 2015 m To 03 03 2015 reeds k Not Sold Sold Date 1D Type Y Description Y Maturity Date Y Purchase Date Y IntRate X Curr value Amount Y Curr Value Date Y Sold Date y poi A 3Year CD 02032017 02032014 12 4 005 00 05 14 2014 aT 18 2015 105 00 00
12. vestment highlight that investment while in the Investments List tab and click the Delete button e After the Delete option is selected the Confirm Investment Delete screen will appear as shown below e Click on the Yes button to delete the investment Office of the State Auditor CTAS User Manual 16 9 Investments Using the Search Feature In the Investment 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 LL Lo o MM Accounting Payroll Investments Indebtedness Reports Admin Help Exit Investment na a oom Investments List Add Investments 4 Not Sold f Sold Date ID Purchase Date Y Maturity Date Maturity Date REETH Y IntRate T Curr value Amount Y Curr Valve Date Y sage Y 12 VY Description Y Purchase Date Year CD 02 03 201 3 2014 BDEdit 3 Delete 4 Exportiocsv a To select Investments Not Sold 5 A e Clickon Not Sold radio button e Click the Search button e Investments that match the search criteria will be displayed Office of the State Auditor CTAS User Manual 16 10 Investments Using the Search Feature continued You can also search by Sold Date Accounting Payroll Investments Indebtedness Reports Admin Bit Investment Investment 7 21 AM Investments List Add Investments Search by Sold Da
Download Pdf Manuals
Related Search