Search
Certified Public Accountants
& Business Consultants

Data Assurance & Analysis Services


Data analysis is the combination of skills and tools that enables compliance personnel and internal auditors to gain insight into business processes and transactions.

Data analysis is useful in audit planning, performance, and reporting. In the planning process, it can provide an in-depth insight into trends and attributes of the population not found through traditional audit approaches by looking at 100% of the data, rather than just a representative sample.

Data analysis also provides valuable insights to business leaders outside of the audit process by consolidating and linking decentralized data from different systems into a single analysis.

This analysis provides management insights into transactions, as well as customer, employee and vendor relationships, which they can use to proactively monitor risks across business operations and support benchmarking across functions.

What Can RubinBrown Do For You?

RubinBrown’s Data Services team combines industry experience, functional specialists and state of the art audit and analysis tools, such as ACL, IDEA and SAS, to provide you with insight and a fresh perspective about your business, division, process or control environment.

Our analysts not only design audit tests, but also help management identify hidden risks, flag abnormal transactions and provide valuable insights into the business. RubinBrown Data Assurance & Analysis Services team can also provide you with automated end-to-end data analytic solutions.

Data Assurance & Analysis Services

  • Computer audit techniques (with ACL and IDEA)
  • Continuous auditing and/or monitoring solutions
  • Automated controls testing
  • Business intelligence solutions (Business Analytics, KPIs, KRIs, KCIs)
  • Cost recovery
  • Data quality and integrity management for:
    • Integration and system consolidation/migration
    • Contract compliance (royalty, licensee, franchisee, service level)
  • Forensic investigations
  • Customer, contract, billing, and vendor data integrity and quality checks
  • Segregation of duties within and across ERPs

Financial Analysis Testing with Data Analysis

Sales Analysis

  • Generate sales & profitability reports by sales representatives, product, etc.
  • Recap product sales by region, customer, category, etc.
  • Analyze sales trends by comparing current & previous periods
  • Identify top dollar volumes by products, customers, sales reps, etc.
  • Compare current sales to open receivables

Accounts Receivable

  • Report & automatically age total receivables
  • Determine carrying cost by comparing days in collection by customer
  • Identify credit limit exceptions
  • Generate summaries by customer, invoice, amounts, etc.
  • Identify duplicate invoices, credits, or receipts
  • Summarize client days to payment by customer, sales rep, region, etc.
  • Identify credits taken beyond discount terms
  • Look for lost revenue from unpaid carrying charges by client, etc.
  • Determine average sales amounts by product, sales rep, region, etc.

Asset Management

  • Compare book & tax depreciation & indicate variances
  • Identify fully depreciated items & assets higher than replacement cost
  • Recalculate expense & reserve amounts using replacement costs
  • Compare useful lives of assets by category
  • Extract assets with useful lives or depreciation rates beyond set norms

Inventory

  • Segregate variances from standard pricing in dollar amount order
  • Identify obsolete inventory by stored turnover analysis
  • Report on products in order of profitability
  • Summarize & stratify turnover by stock item
  • Analyze high value transactions
  • Summarize stock on-hand by group, location, type, etc
  • Look for differences between standard costs & actual costs
  • Compare cost to retail price to look for pricing discrepancies
  • Find products with zero quantities or zero prices

Accounts Payable

  • Compare voucher or invoices posted against purchase order amounts
  • Identify vendor unit price variances by product
  • Find invoices without purchase orders
  • Look for distributions to suppliers not in suppliers master file
  • Identify invoices posted with duplicate purchase order numbers
  • Look for lost discounts not taken

Payroll

  • Isolate entries against authorization records for new or terminated employees
  • Analyze costs for special pay, overtime, premiums, etc.
  • Look for changes in key payroll data, such as gross pay, hourly rates, salary amounts, exemptions, etc.
  • Compare employee tax identification numbers, phone numbers, & addresses to vendor information for payables to identify potential conflicts of interest