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
|