Portfolio Genius | Modules & Interfaces
Application Security Module provides a logon validation process and works in conjunction with Microsoft Windows 7 and Microsoft SQL Server security implementations.
General Ledger Module provides a means to manage the chart of accounts, with no limit to the number of line items for either the balance sheet or the income statement. The module provides the flexibility to make changes to the chart of accounts on an as-needed basis, allows for the creation of sub-portfolios of assets and liabilities, and consolidation of the sub-portfolios to the total level for both point-in-time and average balances (average by month and year).
Mark to Market Adjustment Module provides the ability to perform backdated mark to market adjustments on your portfolios, tracking the adjustments in an audit log.
Payment Reconciliation Module provides a means to reconcile the amount of actual cash (principal and interest) received for a holding against anticipated amounts calculated on the holding and CUSIP data. The module posts the data to the general ledger and contains reporting functionality for principal and interest reconciliation.
Pledge/Safekeeping and Collateral Tracking provides the functionality to manage pledge and safekeeping information and track collteral on repurchase agreements and reverse repurchase agreements.
Report Manager Module supplies tools to manage your reports—apply filters and set date parameters, create batches, roll reports into holding company reporting, create consolidated reports, add custom reports, and more. The Report Manager Module uses Crystal and Microsoft Reporting Services (MRS) as the report writer.
Regulatory Module supplies tools to support the various reporting requirements of the different regulatory agencies for banks, savings institutions, and credit unions. Detailed information for each regulatory report can be viewed to verify or make edits, thereby enabling the generation of a detailed report to supplement the report which can be saved, retrieved and printed at any given time.
Maintenance Tool Kit provides your IT staff the resources it needs to effectively and easily maintain the TPG database. The Maintenance Tool Kit contains these modules:
- Administration Tool provides the ability to customize user access to specific screens and functional areas to control and monitor transaction entry, based on user-defined policies and procedures.
- Audit Tool provides access to the audit logs which describe changes made to the TPG database.
- Data Mover Tool provides the ability to transfer specific data types from one database to another.
TPG Automation Tool Kit provides a means to set up and schedule certain events to occur automatically at specific times, such as importing and exporting files, running the process, and many more.
Export Builder Module is a unique data export utility that provides the ability to create custom extract files, selecting any number of data fields desired, and exports the information in whichever format your institution uses.
Analytics Module incorporates advanced analytics such as total return, projected cashflows, stressing a portfolio or position, and an internal Pricing Matrix model to price securities.
ePortfolio Module is an optional Web application for Portfolio Genius that provides the functionality to create portfolios, conduct trade ticket entry for any buy and sell tickets, enter and edit pledge and safekeeping information, view and print reports and graphs of portfolio holdings, and upload and download files to your A/LM system, GL System, or any other extract, regardless of file format. And there are levels of security built into the browser you can set to restrict access rights to certain users and customers.
Interfaces to Third Party Data Vendors which can be automated with import, export, and bi-directional interfaces to data vendors.
Custodial Reconciliation Interface provides a link to your custodian (Bank of New York, Citibank, JPM Chase, Bloomberg, etc.) to import data payments into Portfolio Genius, reconcile position information such as par and original face amount, and reconcile payments.
TPG Sweep Module provides the ability to sweep the repo positions in your portfolio on a daily basis.
TPG Data Link Interface provides the ability to import data such as factors, rates, market prices, and CUSIP-descriptive information from Bloomberg Data License and/or Interactive Data Corporation "Remote Plus".
TPG Data Excel Add-in Tool provides the ability to download real-time data from the entire TPG database and includes a dashboard and pre-defined templates for analytics and reporting, and enables you to create reports on the fly using Excel that can be saved and reused.
SharePoint Add-in Tool is a document storage and linkage depository that enables users to save files to specific record types created in Portfolio Genius, Trader, and other sources.
Portfolio Genius Interface to DDA provides the ability to customize a daily file extract from Portfolio Genius to be uploaded into your DDA.
News and Events
TPG Solution for Debt Securities CECL
TPG FR Y-14Q Securities Reporting