Management Information

Finance Automation Data Repository - Balance Sheet Data

All of the Balance Sheet and Profit & Loss is enriched and included in the Finance Automation Data Repository with a very high degree of granularity. Each item is included in an identical generic data format with a wide range of management information designations in a single master table. Further data tables refreshed each day include the Current Exchange Rates, and relevant next business days for each currency The base currency equivalent of the key amount fields are available for reporting purposes by using the Views (Queries) provided in the repository.

Management Information Reports

Eaxmples of reports which come pre-delivered with Finance Automation's Management Information Suite are:
  • Internal Balance Sheet

    A summary balance sheet report grouped by Balance Sheet Classification. One key difference is the drill-down capability where from any balance sheet category the user is able to determine the amounts which comprise the category total – from the individual deal, or accrual item (instead of merely the account balance)

  • Internal Profit & Loss

    A summary Profit & Loss report grouped by Profit & Loss Code. The key difference is the drill-down capability where from any P&L category the user is able to determine the amounts which comprise the category total – even from the individual deal income accrued month to date or the retail interest by underlying account.

  • Alternate Format Balance Sheet

    The Bank’s Balance Sheet presented in either Head Office format or Bank of England format with full drill-down capability

  • Liquidity Analysis

    A comprehensive view of the organisation’s entire balance sheet by cash flow date. All Assets and Liabilities are analysed with a high degree of granularity to the level of each individual loan repayment or demand account balance

  • Interest Analysis

    A specific Profit & Loss report selecting only Interest Income & Expense, grouped by Profit & Loss Code. However, each item of interest income or expense month to date is available via drill down, whether retail or deal based.

  • Interest Control Report

    A report which provides a reconciliation of each Interest Payable and Receivable Account against the underlying transactions. Each call account, money market deposit taken or placed, and each commercial loan is analysed item by item and reconciled against the relevant accrual account

  • Top Twenty Exposures Bank / Non-Bank

    A two-part report showing the top twenty group exposures in the Bank and the Non-Bank categories Exposure is aggregated according to group or “boss” code to provide group exposure. Where no boss number is present the group number equates to the client number. The aggregate exposure includes, active Commercial Loan Drawdowns, Money Market Placements, Overdrafts, plus Undrawn Commitments The aggregate exposure also includes Accrued Interest Outstanding on all the above.

  • Country / Industry Exposure

    A comprehensive view of the organisation’s exposure by risk country (both immediate and ultimate) or by risk industry (both immediate and ultimate) The report can be requested in Euros, Sterling or Dollar equivalent and is fully drill-down enabled

To find out more, please write to info@messageautomation.com