Use Document Matching to verify the accuracy and completeness of cash confirmations in DataSnipper for Excel. This procedure covers v5.0 or later.
Video tutorial
What the video covers: importing confirmation documents and bank statements, creating Document Organizer folders, setting up Document Matching against the confirmation listing, matching all rows automatically, and reviewing snipped evidence cells.
Prerequisites
Completed and scanned confirmation responses imported into DataSnipper
Supporting evidence for alternative procedures, such as bank or account statements or screenshots from a web portal or source system
Listing from your client's source system
Start procedure
Import all relevant documents into DataSnipper: Confirmations, Bank Statements, and Screenshots.
Click on Document Organizer, and create folders for 'Bank Confirmation', 'Bank Statements', and any other supporting evidence folders needed for alternative procedures.
Click on the Document Matching button in the DataSnipper ribbon, and select "Start new Document Matching".
Select your sample data. If it includes headers, check "First row includes headers" and click "Next" to select the relevant Document Folders.
Cross-check the output columns and adjust them according to your procedure.
Click "Match all rows". DataSnipper will automatically match the input and output columns for you.
Once the match is complete, review the output by moving through the snipped cells.
If you don't have a listing to match against, you can use Form Extraction to generate a table from your confirmation documents. See the Form Extraction article to learn more.