Audit Data Analytics Corp
(864)625-2524
contact@auditdataanalytics.net
Menu
  • Home
  • Professional Services
    • Custom Excel Solutions
    • Help Desk Support
  • Forum
  • Blog
  • Research
  • About Us
  • Privacy
  • Download
    • Windows
    • Mac
  • Shop
    • Cart
    • Checkout
    • My Account
  • ADA Help
Menu

Versatile Excel Importer

  • Does the Excel data you need to analyze seem to always be a different structure and format every time you turn around?
  • Does your data have multiple accounts in one worksheet and you need the data in separate sheets?
  • Does your data have complicating headers, footers and subtotals?
  • Does it have embedded graphics and report formats that you have to work around?
  • Does the date format change based on the source location of the data?
  • Do you get data spread out across worksheets and workbooks and you need it all in one place?

Our Versatile Excel Importer will adapt and handle all kinds of polymorphous data formats and structures. Some accounting systems output data in hierarchical account-subaccount structures that can be a headache, such as the QuickBooks Transaction Detail by Account report. Let our Versatile Excel Importer be the cure. Show us 10 of your most problematic datasets and we’ll make sure it works on all of them.

You operate a simple dialog where you identify the Excel column letter for a few key account data columns such as the date and amount. Select one file, multiple files or a whole folder containing a bunch of files.

Versatile Excel Importer Dialog
Versatile Excel Importer Dialog

The Versatile Excel Importer will hunt the accounts of interest and collate them as necessary for any subsequent analysis or presentation you wish. These accounts can be G/L, A/P, A/R, T&E or any other identifier for the data. We make it very easy for you to provide a list of account identifiers and with the press of a button all your data is collected and ready the way you want it.

QuickBooks Data Outline Format
QuickBooks Data Outline Format

 

Date and Description Together Data
Date and Description Together Data

 

Data with Monthly Totals
Data with Monthly Totals

Examples

Check out some examples of our work that employ the Versatile Excel Importer:

  • FAR 31 Audit Sampling
  • Automated Analysis Toolboxes
  • Business Intelligence Reporting

Share with:

Facebook Twitter Google StumbleUpon LinkedIn Reddit Email Print


Contact

To discuss your needs and how we can help you best, please contact:

Donna Ellis, Director of Professional Services

(864) 625-2171

donna@auditdataanalytics.net

Professional Services

  • Professional Services Home
    • Custom Excel Solutions
      • FAR 31 Audit Sampling for A/E/C Companies
      • Automated Analysis Toolboxes
      • Business Intelligence Reporting
      • Versatile Excel Importer
      • Sampling Tool
      • Report Builder
      • Automated Audit Analyzer
      • Excel Graphics and Power BI Packages
    • Help Desk Support
©2021 Audit Data Analytics Corp | Design: Newspaperly WordPress Theme