Skip to Content
AuditAI workbooksSample data and columns

Set up sample data and columns

On Setup, define the population you want to test and the information the workpaper should produce. Review the selected rows and columns before saving.

Name the workpaper

Enter a descriptive name under Workpaper Details. The name saves when you leave the field or press Enter. A blank or default name prevents execution.

Use Give additional information for context such as the period, eligibility conditions, or conventions relevant to your work. On Financial Audit workpapers, Enable assertions adds assertion review to the workpaper. This toggle is not offered for other audit types.

Add sample data

  1. Click Upload Sample Data on Setup.
  2. Upload a CSV, XLSX, or XLS file, or paste your table into the grid.
  3. Click the row number that contains the actual column headings.
  4. Use the column checkboxes to select the fields to include.
  5. Use the row checkboxes to exclude titles, totals, or other rows outside your sample.
  6. Review Current Header Row, Current Columns, and Current Rows.
  7. Click Save Sample Data.

At least one column and one data row must remain included. A workpaper created from a template can start with its reference headings. Review Output Columns to check the template’s expected structure.

Replace or reset the sample

Click Edit in Sample Data to review or replace the table. Reset Table deletes the saved sample data and clears the grid, including template headings. Closing the dialog does not restore the deleted sample. Save new sample data before trying to execute again.

Configure output columns

Saving sample data creates an output column for each input field. In Output Columns, leave checked the columns you want tested. Uncheck a column to exclude it from testing.

Use a column’s edit action to change its heading or instructions, then Save. Add column lets you create a custom output with a heading and a description. Describe the extraction, check, or calculation you want. Type @ to choose an existing column reference where the suggestions are available.

Review instructions that involve calculations against the input data and evidence. A description is an instruction to the AI, not a substitute for checking its result.

Approve the configuration

Click Approve & Continue to move to Support Documents. Column selections and edits save as you make them. Changing the configuration makes approval available again. If you edit columns after running a workpaper, use Execute Again to produce results using the revised configuration.

Continue with documents and execution.

Last updated on