Use DataSnipper's Form Extraction and Document Matching to perform and document batch payment testing procedures.
Prerequisites
Batch payment statements
Individual invoices
Bank statement showing batch payments
Invoice listing from your client's system
This procedure involves two reconciliation tests: invoices to the batch statement, then the batch statement to the bank statement.
Reconcile invoices to batch statement
Import your supporting evidence: invoices, batch payment listing, and bank statements.
Click Document Organizer and create folders for each document type.
Click Document Matching and select Start new Document Matching. Select your sample data, check First row includes headers if applicable, then select Use document folders and check the Invoices and Batch payments folders.
Adjust the output columns to match your procedure, then click Match all rows. Review the output by moving through the snipped cells.
Reconcile batch statement to bank statement
If you do not have the batch listing in Excel already, use Form Extraction to extract it. Navigate to Form Extraction, select your batch statements, snip the required fields from the first document, then export to Excel.
Re-open Document Matching and configure a second test, this time reconciling the batch data against the Bank Statement folder. Review the snipped output.