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-303113 Follow 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-303113 Compare 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-303113 Verify 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.

Request a free ScanWriter demo to learn more.

button_request-a-demo-164x36noborder

 

*Analysis of various studies report

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