Talisman Products Home Home Talisman Consulting Contact Us

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




© 2001-2016 Talisman Software Inc.