alert-icon
Only limited material is available in the selected language. All content is available on the global site.
Wolters Kluwer Navigation
  • Welcome to the New WoltersKluwer.com
  • Solutions
  • Careers
  • Investors

About Wolters Kluwer

Wolters Kluwer is a global provider of professional information, software solutions, and services for clinicians, nurses, accountants, lawyers, and tax, finance, audit, risk, compliance, and regulatory sectors.

About Us
  • About Wolters Kluwer
  • Strategy
  • Our Organization
  • Management
  • Supervisory Board
  • Value Creation
  • News & Press Releases
  • Events
Expert Insights
  • All Expert Insights
  • Health
  • Tax & Accounting
  • Finance
  • Compliance
  • Legal
Get Help
  • Contact Us
  • View Solution List
  • Bookstores
  • Welcome to the New WoltersKluwer.com
  • Solutions
  • Careers
  • Investors
PrimaryNav Button
Wolters Kluwer Logo
Search
    No Suggestion
    WK logo

    Visit our global site, or select a location

    • Americas
    • Europe

    • Asia & Pacific

    Brazil

    • Portuguese

    Canada

    • English
    • French

    Latin America

    • Spanish

    United States

    • English

    Belgium

    • Dutch
    • French

    Czech Republic

    • Czech

    France

    • French

    Germany

    • German

    Hungary

    • Hungarian

    Italy

    • Italian

    Netherlands

    • Dutch

    Poland

    • Polish

    Slovakia

    • Slovak

    Spain

    • Spanish

    Sweden

    • English

    United Kingdom

    • English

    Australia

    • English

    China

    • Simplified Chinese

    India

    • English

    Japan

    • Japanese

    Thailand

    • Thai

    Vietnam

    • Vietnamese
    Primary Navigation
    • Health

      Trusted clinical technology and evidence-based solutions that drive effective decision-making and outcomes across healthcare. Specialized in clinical effectiveness, learning, research and safety.

      Health Overview
      Solutions
      • LexicompEvidence-based drug referential solution
      • OvidThe world’s most trusted medical research platform
      • UpToDateClinical decision support resource
      • Sentri7Revolutionizing patient care
      View All Solutions
      Expert Insights
      • Nursing faculty shortage in the U.S.: Has a pandemic compounded an existing problem?
      • The reverse case study: An innovative approach to develop critical thinking skills
      • What should nurse leaders know about communication overhauls?
      • Four priorities for ramping up COVID-19 vaccination
      • Faculty best practices in supporting nursing students: New year and new semester - same challenges!
      • Health literacy and importance to prelicensure nursing students
      • Partnering with nursing staff: Thoughts for nurse leaders
      • My nursing shift continues
      View All Expert Insights
    • Tax & Accounting

      Enabling tax and accounting professionals and businesses of all sizes drive productivity, navigate change, and deliver better outcomes. With workflows optimized by technology and guided by deep domain expertise, we help organizations grow, manage, and protect their businesses and their client’s businesses.

      Tax & Accounting Overview
      Solutions
      • CCH Axcess™ SuiteCloud-based tax preparation and compliance, workflow management and audit solution
      • CCH® ProSystem fx®Integrated tax, accounting and audit, and workflow software tools
      • CCH® ProSystem fx® EngagementOne central hub for all your firm’s engagements
      • Corporate Actions SuiteSuite of solutions with detailed and accurate corporate action taxability
      View All Solutions
      Expert Insights
      • IRS announces tax relief for individuals affected by winter storms in Texas: IRA and HSA deadlines extended for some
      • IRA distributions prior to age 59½: When must an individual file IRS Form 5329?
      • $name
      • Individual retirement accounts: When is IRS Form 8606 required?
      • Knorr-Bremse AG & TeamMate+ Audit
      • Being agile in internal audit: 5 top tips to get started
      • IRA reporting: Excess contributions and recharacterizations - tax year “during which” vs. tax year “for which”
      • 3 things to do right now to become more agile
      View All Expert Insights
    • Finance

      Our solutions for regulated financial departments and institutions help customers meet their obligations to external regulators. We specialize in unifying and optimizing processes to deliver a real-time and accurate view of your financial position.

      Finance Overview
      Solutions
      • OneSumX for Finance, Risk and Regulatory ReportingIntegrated regulatory compliance and reporting solution suite
      • TSoftPlus for Paycheck Protection ProgramSBA Paycheck Protection Program (PPP) software program
      • eOriginalEnabling trusted transactions for the most valuable digital loan assets
      • CCH TagetikUnified performance management software
      View All Solutions
      Expert Insights
      • How to tackle IFR/IFD reporting obligations
      • Knorr-Bremse AG & TeamMate+ Audit
      • Being agile in internal audit: 5 top tips to get started
      • Webinar: Market Insights France 2021
      • Webinar: Market Insights Luxembourg 2021
      • Uncovering hidden portfolio risks
      • GHB Customer Testimonial Video - OneSumX For IFRS 9
      • 3 things to do right now to become more agile
      View All Expert Insights
    • Compliance

      Enabling organizations to ensure adherence with ever-changing regulatory obligations, manage risk, increase efficiency, and produce better business outcomes.

      Compliance Overview
      Solutions
      • OneSumX for Finance, Risk and Regulatory ReportingIntegrated regulatory compliance and reporting solution suite
      • TeamMateSolutions suite for auditors
      • OneSumX for Regulatory Change ManagementTrack regulatory changes across a list of global agencies
      • Lien SolutionsMarket leader in UCC filing, searches, and management
      View All Solutions
      Expert Insights
      • How to tackle IFR/IFD reporting obligations
      • IRS announces tax relief for individuals affected by winter storms in Texas: IRA and HSA deadlines extended for some
      • Chapter 7 bankruptcy cases: Evaluating a secured creditor's position
      • IRA distributions prior to age 59½: When must an individual file IRS Form 5329?
      • Florida's out-of-state telehealth registration law
      • Best practices for UCC filings and searches
      • Individual retirement accounts: When is IRS Form 8606 required?
      • Knorr-Bremse AG & TeamMate+ Audit
      View All Expert Insights
    • Legal

      Serving legal professionals in law firms, General Counsel offices and corporate legal departments with data-driven decision-making tools. We streamline legal and regulatory research, analysis, and workflows to drive value to organizations, ensuring more transparent, just and safe societies.

      Legal Overview
      Solutions
      • Enterprise Legal managementMatter and spend management solution
      • CT Global Corporate ServicesCompliance services for global expansion
      • CheetahAccelerate your legal research
      • CCH AnswerConnectResearch platform & content
      View All Solutions
      Expert Insights
      • ELM Amplify: Advice on AFAs from those who have made them work
      • How CLM Matrix helped Kedrion Biopharma streamline contract request processes and improve productivity
      • Practicing the three A’s of good cybersecurity
      • On-demand webinar: The 2021 Delaware update
      • See the potential ROI of a CLM solution with our savings calculator
      • Meeting diversity goals starts with measuring them
      • On-demand webinar: Modernization of corporate legal - How and why is legal changing?
      • Making the business case for a contract lifecycle management solution
      View All Expert Insights
    1. Home >
    2. Solutions >
    3. TeamMate Audit Solutions >
    4. TeamMate Analytics for Audit >
    5. FAQs

    TeamMate Analytics FAQs

    Secondary Navigation
    TeamMate®
    • About TeamMate

      We are the world's leading audit and assurance expert solution with over 25 years dedicated to advancing corporate, commercial, and public sector auditors.

      Audit
      • TeamMate+ Audit
      • TeamMate+ Audit for Public Sector
      Analytics
      • TeamMate Analytics
      • Features
      • FAQs
      • Download
      Controls
      • TeamMate+ Controls
    • Services
    • Insights from TeamMate

      Check out our broad array of audit industry thought leadership, written by experts with decades of deep domain knowledge.


      Insights from TeamMate
      • Touchstone Insights for Internal Audit
      • Demos
      • Articles
      • Webinars
      • Reports
    • Customer Spotlight
    • Events
    • Support
    • Contact Us
    View a Demo

    Frequently Asked Questions

    Can I see a demo of TeamMate Analytics in action?

    Yes – click here to view a demo, and we’ll show you what TeamMate Analytics can do for your department.

    How is TeamMate Analytics going to save me time and money?

    Data analytics tools, also known as Computer Aided Audit Tools or “CAATs”, are software tools that help Auditors to carry out their work. It is becoming near impossible to gain sufficient audit evidence and risk coverage using traditional manual audit methods such as sampling alone. Data analytics allow Auditors to carry out more work, in less time, with greater coverage, and with a whole host of other benefits.

    We already use data analysis software ‘XYZ’, why would we need TeamMate Analytics?

    You might be surprised at how many of our customers already use (or used) another data analysis software package. They realized that the software they purchased was designed more for auditors that can also write code and be a DBA, not most auditors. The software they have isn’t right for their needs or is too complex for more than a few highly-trained specialists to use. As a result, their staff don’t use it or it is used only on a few audits, and they don’t get the benefits they expected. Often these organizations find they have too many licenses of the other software package. If you think that TeamMate Analytics might be better for your team, or TeamMate Analytics would complement and supplement your other tool, contact us.

    Will TeamMate Analytics make the audit team more effective?

    Auditor input is essential to select which tests are appropriate for a given situation, define critical variables (e.g. materiality) and to interpret and further investigate the outputs of the tools. By testing 100% of the data population, your risk is reduced. TeamMate Analytics allows your entire staff to apply this to analytics on nearly all your audits. Furthermore, ‘the data guy’ can spend more time auditing and less time programming and more time on more involved data analysis projects.

    How much time will TeamMate Analytics save me?

    Typically, we expect TeamMate Analytics to save an auditor 10-20 hours each month. Of course, this varies widely, depending on several factors. For example, in one location you could find that just one test using TeamMate Analytics takes 5 minutes, and eliminates 3 days of manual work. In another location, you may find that they simply can’t get the data you need electronically, so there would be less scope for TeamMate Analytics to save you time.

    I can’t get my data in Excel format; how can I use TeamMate Analytics?

    While simply opening an Excel file is the easiest way to get your data, TeamMate Analytics has lots of different options for obtaining your data.

    Excel files, csv files – these can simply be opened in Excel

    Text files, print reports, PDFs – the Import Wizard tool in TeamMate Analytics allows you to easily convert these files into Excel format, even capturing data in headers, footers, totals, etc.

    Use your existing tools to extract data from system databases. Most organizations have many tools from SQL scripting tools to reporting tools that allow users to export data into Excel where TeamMate Analytics can be used without fear of corrupting production data or writing queries that will bring the system to its knees.

    If these tools are not available Excel’s native tools allow you to connect into various databases to pull data into Excel. For more advanced database access, including connectors to common systems, we recommend the use of Microsoft’s free Power Query add-in for Excel 2010/2013. This is already built into Excel 2016.

    TeamMate Analytics also includes a variety of data cleansing tools for tidying up your data, ready for analysis.

    Does TeamMate Analytics have an audit trail?

    Yes, each tool stores a log of the tool that has been run, the date and time and the parameters selected. You can also optionally add a screenshot of the inputs to the log.

    Custom Modules, and a few of the other tools, will create a summary worksheet with the audit trail information, also with a screenshot of the inputs.

    How much data can TeamMate Analytics handle?

    Excel worksheets are limited to 1,048,576 rows of data. While this is adequate for most data sets auditors analyze, TeamMate Analytics can process tens of millions of rows of data. Custom Modules can read data in from a spreadsheet or delimited files such as CSV files that could contain much more than one million rows of data. These large data sets are put into a database for processing. All of this occurs within the easy to use interface of TeamMate Analytics, so DBA and programming skills are still not required.

    We’re still using an old version of Excel/Windows, can I use TeamMate Analytics?

    TeamMate Analytics supports all the versions of Excel and Windows that are still supported by Microsoft.

    Do I need the 32-bit or 64-bit version?

    TeamMate Analytics has 2 versions, one for 32-bit and one for 64-bit. These are identical except for the versions of Excel they support. If you use the .exe installer for TeamMate Analytics, it will automatically install the correct version for your version of Excel. If you use a .msi installer, you will need to choose the correct version for your version of Excel (not Windows).

    For example, if you have 64-bit Windows but 32-bit Excel, you need 32-bit TeamMate Analytics. If you have 64-bit Windows and 64-bit Excel, you need 64-bit TeamMate Analytics.

    The advantages of using 64-bit over 32-bit Excel is the amount of data that can be processed, as 64-bit Excel can use all the memory on your PC, while 32-bit Excel is limited to 4GB (for Excel 2013/2016 from June 2016) or 2GB (for Excel 2010). This is still normally more than enough for most users.

    Do I need TeamMate+ Audit or TeamMate+ Controls software to be able to use TeamMate Analytics?

    No, TeamMate Analytics can be used completely independently of TeamMate+ Audit or TeamMate+ Controls. Even if you have TeamMate+, you can still use TeamMate Analytics separately if you wish.

    Does TeamMate Analytics work with the TeamMate+?

    TeamMate Analytics integrates with TeamMate+ and its Excel add-in and is compatible with all currently supported versions.
    TeamMate Data Analytics Software

    TeamMate Analytics

    Data Analytics can dramatically increase the value delivered through 100% coverage highlighting every potential issue or anomaly and the ability to get to the root of issues quickly. Join us to see how TeamMate Analytics can change the way you think about audit analytics.

    Length: 34 minutes, 29 seconds
    View Demo
    TeamMate Analytics
    More Information about TeamMate Analytics
    Footer Navigation
    • About Wolters Kluwer
    • Strategy
    • Our Organization
    • Management
    • Supervisory Board
    • Value Creation
    • News & Press Releases
    • Events
    • Solutions
    • Health
    • Tax & Accounting
    • Finance
    • Compliance
    • Legal
    • Expert Insights
    • Careers
    • Investors
    • Sitemap
    • Site Owner
    • Contact Wolters Kluwer

    TeamMate

    • Support
    • Services
    • View a Demo
    • Contact Us
    Follow TeamMate
    • LinkedIn
    • Facebook
    • Twitter
    • YouTube
    Wolters Kluwer Logo

    When you have to be right

    • Terms of Use
    • Privacy & Cookies

    © 2021 Wolters Kluwer N.V. and/or its subsidiaries. All rights reserved.