7.3 Account Audit Report

The Account Audit report provides users a tool to validate the account attributes along with calculated FTP results like Transfer Rates, Adjustment Rates, and Economic Cost results.

To open the Account Audit, follow these steps:

1. From the LHS menu, click Funds Transfer Pricing, select Analytics, and then select Account Audit.
2. There are filters available for:
   1. As of date: user can select all as of dates available on selected period OR can choose few as of dates in selected period like last few quarters.
   2. Currency: It helps user to filter accounts based on their respective currency.
   3. Instrument Table Name, Instrument Type Name, Common COA, Product Identifier: These are few dimensions based on which user can filter and see specific list of accounts.
   4. Adjustable and Amortization Type Code: User can filter accounts based on whether they are fixed or adjustable rate or conventional/custom amortization schedule.
3. After applying all or few filters, user will get a list of accounts, user can even further select just few accounts for detailed analysis. Account number selection is given for this.
4. Once user has selected one or multiple accounts for detailed analysis or comparison, all the account input details like Product ID, Currency, Amortization schedule, Account and ID Number will be listed in account summary grid.
5. Account Timelines: This displays all the input dates for the account like origination, issue, payment and reprice dates etc.
6. Account Balances and Customer Rates: This grid display all the balances like Origination, current, average balance along with rates like customer net or gross rates.
7. Account Terms and Frequencies: This grid contain all the details like payment term, reprice term, original term of the account, and so on.
8. Account Rates: This display all the transfer pricing calculated rates like transfer pricing, add-On rates like liquidity premium rate, Basis risk cost rate, other add-On rate and pricing incentive rate etc.
9. Account Charge Credit: This display all the charge credits corresponding to calculated FTP rates like transfer pricing charge credit, liquidity premium charge credit, Other add-on charge credit etc.

   Figure 7-167 Account Audit Report