Many business documents such as checks, invoices, purchase orders, cash receipts are sequentially numbered in order to help assure that missing documents can be determined. The purpose of performing a "gaps" test is to account for any missing documents in the accounting records. Missing documents may be a symptom of unrecorded expense or revenue.
To perform such a test and have the results available in electronic work paper format, the following processing information is explained below:
|
|
| Description | Value |
|---|
| Select | Specify 'OK' to have this row processed, otherwise it will be skipped |
| Data Source | Specify the name of the Excel workbook, including directory or the name of the Access database which has the data to be analyzed |
| Command Name | gap |
| Command Description | Check for gaps in numeric sequences |
| Table | Must enter either a sheet name followed by $ or else enter an Access table name |
| Where | An optional row selection statement may be made to narrow the analysis to just certain rows |
| Column |
The name of the numeric column which contains the data for the test, e.g. check number, invoice number, etc. |
| Column String | This command does not accept group of column names |
| Parm1 | This command does not accept a first parameter |
| parm2 | This command does not accept a second parameter |
| Theme | No chart is produced, so this value is not applicable |
| Title | No chart is produced, so this value is not applicable |
Return to electronic work paper home page
|
