Three Ways to Enhance Data in ScanWriter

Three Ways to Enhance Data in ScanWriter

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!

How to Create a Data Quality Checklist in ScanWriter

How to Create a Data Quality Checklist in ScanWriter

Did you know that *almost 90% of spreadsheets have errors? Now with the leading data automation software, ScanWriter, you can guarantee 100% accuracy in every spreadsheet – every time.

Here’s how to create an easy data quality checklist in ScanWriter:

After ScanWriter automatically converts the data from your paper or PDF statements and organizes the data in the easy to read data preview screen…

checkbox-303113Follow ScanWriter’s data color coding system

  • Data in Black means it’s verified
  • Orange means that ScanWriter automatically corrected the data, but you should double check for accuracy
  • Data in Red means you need to correct the data

How to edit the colored data:

Displaying the source document on the left and the data that ScanWriter captured on the right, ScanWriter makes it easy to verify any data item. Simply click on the specified data item on the right side of the data preview window and ScanWriter will automatically highlight the data item on the source document to the left. Directly edit the data item in ScanWriter’s data preview window.

checkbox-303113Compare the data ScanWriter captured side by side with the source document

The Compare Data feature is great for checking the accuracy of poor quality documents. Simply click on ScanWriter’s Compare Data feature and choose the column(s) you would like compare. ScanWriter will display the captured data in a green box directly next to the data on the source document. Compare data side by side and easily edit any data in the green box. The data in ScanWriter’s preview screen will automatically update.

checkbox-303113Verify data with the ‘Check Balance’ feature

ScanWriter’s Check Balance feature automatically calculates the balance that ScanWriter captured by date and compares it to the balance found on the source document. Identify any differences in the ‘balance difference’ column and directly edit the data on the fly for that period. Then just recalculate the balance. When you see ‘0.00’s in the balance difference column for each period, you know your data is correct.

Using ScanWriter’s exclusive data accuracy check features, you can ensure 100% accuracy with every QuickBooks import or Excel export. ScanWriter’s features make data quality management painless, quick and easy.

To learn more request a free ScanWriter demonstration or contact us at (800) 688 – 4281.

*analysis of various studies report