DATA Analysis Outsourcing

Q: What about turn-around time?

We've been downloading data since 1984. We typically process new setups in an hour or less for most reports.

Q: Any support for field exam setups?

First, the examiners tend to be well-versed in Excel. But we do provide support for processing files for field examinations.

Analysis of Electronic Data

Lenders are looking for ways to improve efficiency and accuracy for ABL ineligible calculations without increasing back-office costs or field examination staff sizes. With the increasing use of data downloads some lenders are learning that it is not always easy to manipulate reports for analysis of electronic data with varying headers, page breaks, date formats and a host of small problems. Staff turnover places huge responsibility on the Lender to have sustained support for data downloads. To these concerns, we began processing data for lenders and field examiners. Fast, accurate and affordable outsourcing of data analysis provides timely ineligible reports, expert analysis and time savings. Lenders are learning that it can be more economical and technologically feasible to outsource data analysis to a dedicated group with expertise. Our difference, we're an employee owned software company with a specialty in commercial finance and we have extensive data download and ABL ineligible experience.
Leveraging tools such as AssetReader for the data download, AssetArchive for time series analysis and fraud reduction and AssetWriter for Borrowing Base and summarization of key trends, statistics and comparisons.

Also see the "All three together" page.

Features	Benefits
Expert analysts and programmers	Intelligent problem solving and insight
Consistent interface	Reports become familiar and predictable
Parameters specified by you	Electronically calculate ineligible items over and over
Credits over Eligible Days using 3 methods	Experiment with options in seconds
Concentrations based on % and $ limits	Control credit and concentration risks
Recurring ineligible items are marked	Reduces errors and improves consistency
Enhancements are available immediately	No obsolescence and ability to adapt to new formats
Re-age invoices	Integrity can be tested in minutes and not hours
List concentrations	Data can be tested in minutes and not hours
Calculate confirmation requirements and reports	Reduce time needed to mail and track confirmations
Perform shipping / billing test electronically	Data can be tested in minutes and not hours
Ineligible calculations are automated	Data can be tested in minutes and not hours
Software can be used by back-office or field examiners	We sell the same software that we use
Inventory reports can be footed	Reduces fraud risks
Movement analysis of inventory	Don't lend on the oldest items
Sales and Cash Journals can be tested	Group credit memos, debit memos and adjustments
Field Examination time is reduced	The examiners can focus on testing instead of compiling

Why Data Analysis Outsourcing?

Are your agings and other reports accurate and are you spending too much time on aging or other report analysis? Worried about fraud? Worried about staff support overload? Are you running a revolving door recruiting operation for your back-office? Want some additional peace of mind? Look to outsource? Improved accuracy, consistency, lower operating costs and reduced fraud are just some of the benefits of data analysis outsourcing.

Data Analysis saves time while improving accuracy by removing the manual analysis and formatting headaches that spreadsheets or general use import tools require for aging and other report analysis.

Data Analysis provides a turn-key and state-of-the-art solution for: in-depth analysis, consistent reports, clear presentations, faster report preparation, better field examination time, computer support and cost control.

Data Analysis Outsourcing is backed with reports, expert programmers, continuous updates, and employee-owner technical support.

Save time by automating the process of analyzing agings
Improve coverage of testing
Save time with electronic templates for repetitive tasks or accounts
Save time performing receivable and inventory ineligible analysis
Improve report accuracy with automation
Analyze data with expert reports and the benefit of more time
Support and training comes from software and ABL experts
Time efficiencies lead to greater productivity
Reduce staff work time, frustration and turnover costs
Get control of complex reports
Export to AssetWriter field exam software for greater time savings

Requirements

Data file from borrowers
Ability to receive files via the internet and email.
Windows operating system
Ample hard drive space to archive data and analysis files
Microsoft Excel (to view reports that get saved)
A Web Browser

Data Processing Frequently Asked Questions

What setup services do you do?

In most cases, lenders and borrowers will need the initial setup to be created for the imports into AssetReader. As staffs grow, lenders do more in-house. As people leave positions in the monitoring groups or audit, they sometimes need additional assistance to get setups done. Lenders that have hundreds of files setup don't need much support for ongoing files, it is the new ones where we provide most of the support.

What about turn-around time?

We've been downloading data since 1984 and our expertise is as strong as it is going to get. We typically process new setups in an hour or less for most reports. Sure some are difficult, that's what software support helps with, but because we have seen so many variations since 1984, it takes a lot to stump us and our turn-around times are quite fast.

Any support for field exam setups?

First, the examiners tend to be well-versed in Excel and they often read-in sales, cash, GL journals, inventory and other reports with success, pivot table work, etc. The agngs tend to be the tough ones to get normalized into nice columns with customer and vendor names on every row. Joining inventory to a cost of sales or usage or date report is often problematic. Our extensive training with AssetReader usually lets those users bring the data into AssetReader. But we do provide support for processing files for field examinations and it tends to be the AR, AP, accrual, inventory and inventory usage reports that we are asked to process.