36 Account Audit Portal

The Account Audit portal provides users a tool to validate account attributes along with calculated FTP results and the related cash flows:

• Transfer Rates, Adjustment Rates, and Economic Cost results.
• Audit information like method used for transfer rate or adjustment rate calculations.
• Interest rate curves used for calculations.
• Cash flows generated for the account, which are helpful to verify the rate calculations.
• Process Error messages
• Current and Prior “As-of-Date” data is also accessible.

All these details can be verified in a single UI portal by functional users, without taking any technical help to query multiple DB tables.

To open the Account Audit

1. From the LHS menu, click Funds Transfer Pricing, and then select FTP Account Audit.

   Figure 36-1 FTP Account Audit page

   
   

   

   
   
2. The following table describes the fields from the above screen.

   Field	Description
   As Of Date	By Default, this is the as of date set in application preferences. However, if you want to pull records for another date, you can choose from the calendar option.
   Instrument Type	This is a mandatory field. By Default, this is blank. If you do not select any value from the drop-down list, you would not be able to proceed with your search. As, you can have 30 to 35 instrument tables to retain various instruments like separate tables for deposits, annuities, loans, saving accounts, and so on. Each table may have millions of records, so to speed up the process, you must select an instrument name from drop-down list, and corresponding table will be picked up for search.
   Product Name and Currency	Both of these are optional fields with a drop-down. You can select a value to narrow-down the search criteria and reduce the turnaround time.
   Identifier	You can enter either the ID Number or the Account number. You can select a particular radio button and enter the corresponding data.

3. After entering the relevant details, click Search.
   If there are no records for the search criteria entered, then FTP displays a message No records found. Update the search criteria.
   If the record is found, then the screen displays either the Account Number or ID Number based on your search criteria.
4. Select the Account Number. This enables an Apply button.
5. Click Apply. The system displays the selected Account Details.
   The Account Audit Details are displayed in four tabs:
   • Account Attributes
   • Audit Details
   • Cash Flows
   • Process Errors