Learn how to use DataSnipper to perform and automate your cash confirmation procedures with Document Matching. This procedure applies to DataSnipper v5.0 or later.
Video walkthrough
What the video covers
The walkthrough shows importing confirmation responses and bank statements, organising them into folders, and running Document Matching against the client listing to confirm cash balances, with alternative procedures for non-replies.
Prerequisites
Completed and scanned confirmation responses imported into DataSnipper
Any supporting evidence for alternative procedures, such as bank or account statements or screenshots from a web portal or source system
A listing from your client's source system
Start the procedure
1. Import all relevant documents into DataSnipper: confirmations, bank statements, and screenshots.
2. Open the Document Organizer and create folders for Bank Confirmation, Bank Statements, and any other supporting evidence for alternative procedures.
3. Click the Document Matching button in the DataSnipper ribbon and select Start new Document Matching.
4. Select your sample data. If it includes headers, check First row includes headers, then click Next to select the relevant document folders.
5. Cross-check the output columns and adjust them to your procedure.
6. Click Match all rows and DataSnipper matches the input and output columns automatically.
7. Once the match is complete, review the output by moving through the snipped cells.
If you do not have a listing to match against, you can use Form Extraction to create a table first.
Sharing the file
You can exclude all documents before saving the workbook in your audit file using the include/exclude documents toggle. You can also delete specific documents if needed.