Questions? We have answers.

Audit Plan: Export CSV and XLSX files

  • Updated

Summary

Learn about the information found within the audit plan when exported in CSV and XLSX format.

To learn how to export an audit plan, review Audit plan management. 


Configuration details

You must have created a task before you can access the Audit Plan page.


Export details for CSV files

The CSV version of an audit plan export contains a single sheet that can include any of the following columns, as desired:

  • Task details*
  • MindBridge Score
  • Audit assertion risk scores:
    • Existence/Occurence Score

    • Rights and Obligations Score

    • Completeness Score

    • Valuation/Accuracy Score

    • Presentation/Classification Score

    • Cut-off Score

  • Every control point score
  • Transaction ID
  • Account ID
  • Account name
  • Effective date
  • Memo
  • Debit
  • Credit
  • User
  • Status
  • Task Type
  • Sample Method
  • Description
  • Reporter
  • Assignee
  • Filters applied as of task creation
  • Audit Areas
  • Audit Assertions
  • Sample
  • Comments
Note: If additional columns have been added, they will be included in this export as well.

Export details for XLSX files

The XLSX version of an audit plan export contains at least 3 sheets:

  • Data sheet (for each analysis type)
  • Settings sheet (for each analysis type)
  • Summary sheet

Data sheet

This sheet provides information about the analysis' transactions/entries, tasks, and control points.

8d713d71-7f25-454c-860a-8b982a6fdd80.png
 
Transaction/Entry columns Task columns Control point columns
  • Transaction ID
  • Analysis Name
  • Account
  • Account Name
  • Mb Account Tags
  • Effective Date
  • Memo
  • Debit
  • Credit
  • Monetary
  • Value
  • User ID
  • Status
  • Task Type
  • Sample Method
  • Description
  • Reporter
  • Assignee
  • Filters applied as of task creation
  • Audit Areas
  • Audit Assertions
  • Sample
  • Comments
Each control point is represented in this section.
Note: If additional columns have been added, they will be included on this sheet as well.
Note: The Control Points section of the export shows the risk score given to each transaction/entry from a machine learning control point (if applicable), and whether or not the transaction/entry triggered a rule-based control point.

Settings sheet

This sheet provides information regarding the settings used with this export, and includes the following information:

  • Analysis name
  • Analyzed on
  • Materiality
  • Rationale
  • Fiscal start month
  • Fiscal start day
  • Frequency
  • Accounting package
  • Industry

Control points, audit assertion scores, and settings are also included on this sheet, as well as the following column headers:

  • Control points
  • Library Default Weight
  • Current Weight
  • Last Modification By
  • Reason For Deviation
  • Date Setting Changed
  • Default suspicious keywords
  • Suspicious keywords
  • Default complex transaction keywords
  • Complex transaction keywords
  • Default manual entries
  • Manual entries
  • High dollar top percentage
  • Materiality amount
  • Old invoice day threshold
  • End of reporting period threshold
  • End of analysis period threshold

Summary 

This sheet outlines high-level details about the export, such as:

  • Engagement’s name
  • When it was exported
  • Library applied to the analysis
  • Name of the analysis
  • Filters applied while generating the export

 

Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.


Related article

Was this article helpful?