Data entry automation software may relieve your hands of tedious keying and typing, but did you know it can also enhance data for a more efficient analysis? Government agencies and top CPA firms use ScanWriter’s exclusive features to automatically flag transactions, set formulas and extract locations and business names – helping save 90% more time in the data analysis process.

Here’s three ways to enhance data in ScanWriter:

  1. Extract the Business Name from the transaction Description

Stop wasting time trying to identify information lost amongst the junky transaction description. With a simple click, ScanWriter can extract essential information (like the Business Name and if it was a Transfer, Deposit or Refund) from each description. Just click Edit Data > Mapping > Get Business Name. ScanWriter will automatically create a new column called “Business Name” and enter the extracted information. The Business Name column even exports to your final Excel file.

[Example:]

Description:
FL Tlr transfer to Chk 1234 Banking Ctr The Falls #0000888 FL Confirmation# 2975634302

What ScanWriter extracts:
transfer to Chk 1234

  1. Flag specific transactions with Data Column Mapping

In an investigation, scouring data for key financial indicators is an essential yet very meticulous task. ScanWriter can help identify these important indicators, setting your analysis up for success before it even starts. Customize ongoing or one time mapping rules with ScanWriter’s Data Column Mapping (Quick Mapping) feature. Flag specific account activity in a separate and customized column. Just select the “From” column (where the data will be pulled from) and the “To” column (where the data will be identified and flagged). You can identify data “exactly” or identify data “containing” certain information. Export all the information to an Excel spreadsheet for fast, straightforward analysis.

[Example:]

From
“Description”

To
“Notes”

Contains
“American Express”

Identify in Notes as
“Personal”

mapping

          3. Custom Sort Data

ScanWriter makes it easy to organize and identify specific data with its custom sort feature. Simply click the column name to sort alphabetically, by date, by Business Name, by custom indicators and more. You can even drag and organize columns to your desired order. Simply click and drag.

sort

ScanWriter hosts various features to help continuously enhance and analyze data. For more information on ScanWriter features or to learn how ScanWriter can help increase efficiency for your business please contact info@personable.com or call (800) 688 -4281.

Request a free online demo here!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s