AuditTrack ULTRA  2013 Help

What Is AuditTrack?  

AuditTrack ULTRA is a multiuser accessible database of all your internal/external  audit projects. It tracks and reports on the status, findings,  recommendations, management response follow up dates  and control parameters of each project.

 

We developed this product for the Audit Department of a bank to replace the cumbersome Excel Spreadsheets they were using to  track ongoing audit projects. The bank wanted to allow  all staff auditors to access, update, and print out any project from a central source instead of manually distributing the individual spreadsheets, which were prone to re-input errors.

 

Secondly, the bank wanted to be able to query the database via keyword searches and multiparameter queries to filter down and print out matching audits.

 

Finally, the bank desired a more “readable” report of each audit project rather than super-wide and hard-to-read spreadsheet reports  to distribute to managers and BOD members.  Third

 

Up to 999 users may add/edit/delete/query/print their projects individually without interferring with coworkers.  Just sign in to AuditTrack ULTRA with your user # and password, and you have instant access to the latest data.

 

You  can add a new audit project by typing it into the grid. Edit and delete (if your user rights allow deletion, that is) any project. Print out any project or collections of projects in easy-to-read, letter-sized portrait style reports. No more unwieldy, extra-wide spreadsheets with ragged print formatting to contend with! Document your findings in Memo fields that hold up to 65000 characters each and can be formatted with clear line breaks so you can list your findings numerically  line-by-line like you would in a word processor. Research your past audits by Full Text Searching the database for key words or use the multiparameter  query function to filter items by column header and matching criteria. You can even query for records with Null fields (blank data) in the column header fields.

 

Please note that AuditTrack ULTRA runs as a SEPARATE APP with a COMPLETELY INDEPENDENT DATABASE from invent!ory ULTRA . Audit users will not be able to access any of your purchasing data, nor will you be able to access any of their audit data.

AuditTrack ULTRA  Functions

  • Add a new project 
  • Edit cell-by-cell
  • Delete any project
  • Undo any deletion
  • Full Text search on keyword
  • Multiparameter queries  (up to 4 separate field searches per query)
  • Pre-set “Queries to “filter” records by field values like “Open,” “Closed,” “Int,” “Ext,” “This Year,” and “Last Year.”
  • projects, Internal /external  projects
  • Multiselect individual rows to filter and print
  • Search and Replace editing
  • Export to Excel (all data or individual queries)
  • Multiple printers selectable
  • Print to .pdf and MS Word
  • Sort the grid by clicking the field column header.
  • Add/Delete/Edit records in the grid.  Includes an Undo function for unlimited number of deleted records.
  • Mulituser (999 user IDs) with access rights
  • Print reports showing all records or just those selected.
  • Multiparameter Query (up to 4 search arguments) to view/print specific records.
  • Row heights and column widths may be expanded/contracted by dragging the cell border.
  • Change your password
  • Backup/Restore database
  • Repair /Compact database
  • SysAdmim function assigns user passwords and set user access rights

 

 

To PRINT a report:

Clicking the “Print button will produce a “preview report” of the record(s) appearing in the grid.

 

 

Note:  The printed report will appear in the same sort order as the grid.

Copyright 2013, Koehler Software, Inc.