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…
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.
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.
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.
*Analysis of various studies report
