Accessing and using transaction testing tables

In the Evidential Testing areas and also in a number of other places to allow transactions to be added manually or imported into a testing grid.

These pages are usually respawners - in other words the dialog box stays even though testing pages have been created allowing multiple versions of the testing pages with their own testing tables may be created.

Here is a step-by-step guide - assuming you wish to test transactions in say the Expenditure section (principles are the same for all sections):

1. If you haven't already done so create the lead schedule. In this case the question is at 13.2 on the Control Page:

2. A "Yes" response generates a button to create the lead schedule for Expenditure:
3. Click the button to create:

4. Follow the link to H1 to open the page. Point 1.7 on H1 asks whether there are payments transaction that require testing. Click "Yes":


5. Click on "Detailed Substantive Testing - Purchases" to create page:


6. At this point you may if you wish give the page a unique name - as you may want to create more that one version of this page say for different types of expenditure:


7. Select "Add" to save then follow the link that is created to page H2, or if you wish click "Detailed Substantive Testing - Purchases" again to create another version of the page:

8. On page H2 under point 1.1 use the drop-down selector to choose what tests you want to apply to the data. You may choose one of the standard tests or click "Other Test" to make your own custom tests (try to keep descriptions brief so that they fit in the table):


9. Once tests are selected and rationale for sample size is documented click "Create Table":Screen_Shot_2014-04-16_at_5.03.26_pm.png
10. The name of the table may be changed at this point if a more specific title is wanted. Data columns are pre-selected but these may be changed, removed or dragged and dropped into a different sequence as required. There is a limit to the total width available and when this is reached no more columns will be able to be selected. When you have chosen click "Add":

(For extra width "landscape" may be selected from drop down - in this case if want to test specific stock items we could add some extra columns so we switch to landscape and select additional columns) 

11. Now follow the link H2-2.2 to the table itself:


12. The table has the tests included (you can't see them yet), the column you specified but no data - this may be loaded manually "Add Row" or from an Excel/CSV import using "Import Rows":


13. Here two rows have been added manually. Note that the $ column is totalled allowing you to see the total value of your sample:


14. To view your tests, click the arrow next the "pending tests". Click Pass, Fail or n/a:


15. You may also add comments in the box, or click the down arrow to the right to add further comments or attachments (a scanned copy of the supporting document for instance). The results of the tests are shown - in this case "0 deviations":


16. If there is a deviation the test where the deviation occurred will be noted in the comment:


17. The number of deviations on the testing page is noted back on the parent page (H2 in this case) to alert the user to any exceptions found:


18. There is no conclusion on testing pages - they are like an attachment to the parent page and are indexed as such:


19. To add data from an Excel or CSV file the columns must match - but no headings are required. For example:


20. To import select "Import Rows":


21. Browse to where Excel/CSV file is saved:


 22. Save - data will populate table.


23. Edit lines by clicking on edit (pencil) icon at left - may also delete from this option:


24. Lines may be reordered by dragging and dropping on the edit icon (without opening the edit dialog).

Have more questions? Submit a request


Powered by Zendesk