1 / 23

Start of ATM Reconciliation Presentation

Start of ATM Reconciliation Presentation. Address: 1512 Edison Shores Lane - Port Huron - MI - 48060 Phone: (810) 985-6343 Fax: (810) 985-6367 URL: http://www.altcompenv.com Email: rmcneice@altcompenv.com.

brit
Download Presentation

Start of ATM Reconciliation Presentation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Start of ATM Reconciliation Presentation Address: 1512 Edison Shores Lane - Port Huron - MI - 48060 Phone: (810) 985-6343 Fax: (810) 985-6367 URL: http://www.altcompenv.com Email: rmcneice@altcompenv.com

  2. Alternative Computing Environments This slide show presentation will show many of the screens and the features available in the program. To view the next slide Click the left mouse button or press the Enter key. To view the previous slide press the Up-Arrow or Left-Arrow key. Investment Tracking Software

  3. Three levels available • Level 1 – CD portfolio • Designed for a CD portfolio • Cost effective accounting solution • Level 2 - All investment types • Support for all investment types • Ease of use and fully featured • Level 3 – Adds third party updates and extracts • Update the database from outside sources • Extract GL entries for auto posting

  4. Program Features • No limit to the number of investments • History for the life of the investment • Full Maintenance Audit Trail • Custom Report Writer • Custom Verification Letters • ALM data extracts and Updates • Full Suite or Standard Reports and Graphs • NCUA 5300 Call Report Schedule • Built in graphing capability

  5. Simple GL balancing • Each investment has GL numbers for • Principal • Accrued Interest • Purchased Interest • Income • Premium or Discount • Unrecognized Gain or Loss • and more • GL numbers defaulted by type of investment • GL balance report shows up to minute balances • GL Activity report show transactions and GL entries for any user defined period.

  6. Easier Audits and Examinations • Custom Confirmation letters and envelopes Issuer Broker Safe Keeper / Custodian • Extract data to a delimited file • Annual activity summary report • GL Activity report can list all transactions and GL entries for the audit period. • Month end accrual reports automatically saved on disk for later review

  7. Types of Investments Supported • Certificates of Deposit • Bonds • Treasuries • Agencies • Deposit Notes • Principal Pay Back Investments • C.M.O.’s • Compound Interest Accounts • Overnight Accounts

  8. Fixed Rate Variable Rate Calendar cycles On Demand Stepped Rate Indexed Rates Interest Accrual Methods • Actual / Actual • Actual / 360 • Actual / 365 • 30 / Actual • 30 / 360 • Actual / T-Bill Period

  9. Amortization and Accretion Calculations • Daily to Maturity • Daily to Call or Weighted Average Life • Monthly to Maturity • Monthly to Call or Weighted Average Life • Principal repaid percentage • Level Yield / Interest Method • Daily Treasury Bill Period • Current Balance to Specified Date

  10. Investment Data Includes • User specified ID field • User defined fields • Issuer Account Number • Large note field • Original and current ratings fields • Current and Previous month market values • Broker and Custodian information • Track safe keeping receipts • SFAS 115 class • NCUA category • ALM designation

  11. Activity Reports Daily Monthly Specific Period Scheduled Activity Broker / Custodian Investment Calc Maturity Regulatory Call Report Schedule Call Report Detail SFAS 115 Portfolio Shock Large List of standard reports • Auditing Reports • Detailed Investment • Maintenance Audit • Risk Report • Verification Letters • Issuer • Supervisory • Run Off • Summary Recap • GL Reports • Balance Sheet • Activity Report Not exactly the report you want then build it using the custom report writer.

  12. Custom Report Writer • Multi level sorting and sub totals • Sort on fields not in the report • Average Yield • Average Maturity • Inclusion testing on any field • Last month end posting entries • Modify format and headings on each field • Print or extract the information as a data file

  13. System requirements • Windows 2000 or XP • Approximately 10 MB of disk space • Can be installed on a network drive • Allows 1 Update user at a time • Unlimited read only users • Includes a Backup, Restore and Update Utility The program can be installed on Windows 98 and newer operating systems by installing additional functionality available from Microsoft that is not included in the standard operating system.

  14. A quick look at the program • Start the Investment Tracking program • The Log in screen is displayed • Enter a User ID and a password, then click Sign On • The program supports individual ID’s and security levels Screens and functionality shown is from the Level II version of the program.

  15. The Main Screen • This screen has five sections The program menu at the top, a set of function buttons just below the menu, Investment selection drop down lists in the middle left, sub-portfolio / search criteria in the middle right, current selected investment information in the lower left and common action buttons on the lower right.

  16. Maturity Distribution Screen • This screen provides a laddered view of the portfolio. This can be a ladder to maturity or next call date. The ladder can be printed or graphed. Details on maturing items can be seen by double-clicking one of the amount fields

  17. Pending Activity List • Details scheduled activity in the current month Double-clicking an investment in the list selects that investment and returns to the main screen

  18. Investment Edit Screen • This screen is divided into six sections The top identifies the investment and is always displayed. There are five tabbed sections for balances, processing parameters, GL and other information, mortgage back investment information and variable rate information.

  19. Posting Payments • Posting payments is quick and easy. Select the investment and click the payment button to display the posting screen. Verify and change the amounts if required and click the Post button.

  20. Sample Graph This is the graph from the maturity distribution screen shown earlier. It is fully customizable and can be copied and pasted as pictured or in spreadsheet format. This makes building a board package with graphs quick and easy.

  21. Why should I change? • How many spreadsheets or reports do you have to maintain? • Are you updating investment information for your ALM program? • How painless have your audits and examinations been? • How long does it take to come up with the GL accrual entries at month end? Who uses the ACE Investment Tracking program?

  22. Overview of Current Clients • Clients from • $10 million to over $1.5 billion in assets • 6,000 to over 150,000 members Call or email for a list of references or a price quote.

  23. End if Presentation Call or email for a list of references or a price quote. Address: 1512 Edison Shores Lane - Port Huron - MI - 48060 Phone: (810) 985-6343 Fax: (810) 985-6367 URL: http://www.altcompenv.com Email: rmcneice@altcompenv.com

More Related