35 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 35-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

• Account Attributes Tab
  The account attributes tab displays account/deal attributes, so you can get an idea if the account is fixed or floating rate, rate of interest charged, original balance, remaining balance, account maturity etc., which would be required to verify the calculations in subsequent tabs.
• Audit Details Tab
  The audit details tab contains two sections. The first section will display all the calculated rates, for example:
• Cash Flows Tab
  The Cash Flow tab details all the cash flows for the searched account. Same account can have multiple processes one for transfer rate, a different process for adjustment rate calculations, and so on, all processes which have generated cash flows for the record are listed here.
• Process Errors Tab
  The Process errors tab lists all the errors logged for the concerned account (Transfer Rate, Adjustment Rate, and Economic Cost Calculations, and so on). You could have Run the multiple processes for Transfer Rate or Adjustment Rate Calculations for the same account and the Process errors tab will collate all the errors spread across various processes for a particular account and display on one screen.