How to perform batch payment test of detail procedures with DataSnipper?

Learn how to perform and document procedures over batch payments using the DataSnipper tool.

Example

Here you can download the workbook shown in the video including all of the sample data and documents.

ToD batch payment - example

Template

Here you can download a blank version of the workbook shown in the video to use or customise for your own procedures. 

ToD batch payment - template

Prerequisites

  • Batch payment statements
  • Individual invoices
  • Bank statement showing batch payments
  • Listing of invoices from your client's system.

Start procedure

  1. Create two testing tables, one to reconcile the invoices to the batch statement and another to reconcile the batch statement to the bank statement.
  2. Add your listing of individual invoices to the first testing table, click document matching and then configure the test by setting your document groups, header row, and output columns. 



  3. Click match all rows and review the output by scrolling through the cells once it is complete.



  4. If you have a listing of the batch payments then add this to the second testing table, if you dont then you can use form extraction to obtain this, please click here for more details.
  5. You can then click document matching again and use the plus button to add a new test, you can then configure this test in the same way as you did for the first test but this time you should reconcile the batch payment listing to the bank statement.

    Hnet-image (4)
  6. Click match all rows and review the output by scrolling through the cells once it is complete.

Sharing the file

  1. You can choose to exclude all documents before saving the workbook in your audit file, by selecting the include/exclude documents toggle.
  2. You have some options to delete specific documents, please click here to learn more.