TalisWare Ratio is designed to record, monitor and report
client compliance to a set of financial conditions, usually expressed as
formulas in a spreadsheet. All client financial data is entered into
Ratio using a spreadsheet interface and stored in a MySQL or SQL Server
database. Ratio allows you to standardize the structure of your
spreadsheets, the construction of the formulas, and provide
comprehensive reporting including the automatic detection of breaches
and warnings. This will help your company minimize risk and reduce the
costs of client monitoring. Ratio makes it much easier to address
section 404 of the Sarbanes-Oxley Act by providing automatic spreadsheet
generation, standardized formulas, spreadsheet documentation, access
control and backups.
Key Features
- Create structured spreadsheets with standard business formulas that can be selectively customized by the user depending on their security level
- Automatically generate spreadsheets from a database
- Set up categories of business formulas that can be of general applicability or industry specific
- Automatically detect and report on breaches or warnings
- Customize screens, formulas and nomenclature to comply with company standards
- Manage large numbers of clients with specialized reports and notes
- Group clients (include several companies under one single name)
- Specify different sheets for each client, e.g. covenants and reports for one client, and margining and reports for another
- User-defined client manager types
- Configure the number of months on the spreadsheet e.g. 24 months for one client and 12 for another
- Create client notes that print with the spreadsheet
- Create a new standard formula from an existing formula
- Support multiple copies of the same formula for a client, e.g. consolidated and non-consolidate current ratio
- Monitor client formulas weekly, bi-weekly, monthly, quarterly, semi-annually, annually, multi-year annually or use a custom schedule
Talisman developed a custom financial compliance system similar to Ratio for RBC Royal Bank from 2000 to 2003.
For more details about Ratio, please view the sample screenshots
|