Summary

The Audit Data Export tool is used to export GL data for state auditing purposes. This tool generates a set of .csv files that can be submitted through state auditing processes. The tool will generate an export file for each of the following tables:

• Table: gl_acct_1, Filter: Fiscal Year
• Table: gl_acct_2, Filter: Fiscal Year
• Table: gl_acct_3, Filter: Fiscal Year
• Table: gl_account_type, Filter: All data in table
• Table: gl_chart, Filter: Fiscal Year
• Table: gl_history, Filter: Fiscal Year
• Table: pr_employee, Filter: All data in table
  • Exclude SSN from pr_employee export
• Table: pr_history, Filter: Batch Year
• Table: pr_deduction, Filter: All data in table
• Table: pr_pay_type, Filter: All data in table
• Table: ap_vendor, Filter: All data in table
  • Exclude account_no, fed_tax_id, state_tax_id, and other_tax_id from ap_vendor export.
• Table: ap_history, Filter: Expense Fiscal Year *or* Check Fiscal Year
• Table: cr_category, Filter: All data in table
• Table: cr_distribution, Filter: All data in table
• Table: cr_type, Filter: All data in table
• Table: cr_line_item, Filter: Batch Year
• Table: cr_receipt, Filter: Batch Year
• Table: cr_receipt_payment, Batch Year

Step by Step

1     Export Audit Data tables.

• Open the Audit Data Export window (GL> Utilities> Audit Data Export).
• Select a Fiscal Year for the export file.
  • Only the account data associated with this fiscal year will be included in the export file.
• Click the Confirm icon to export the audit data.
  • The export files will be in pipe (|) delimited format.
• Once the export file has been generated, the Export Settings window will open.
  • Check the Open toggle if you would like to open the exported file after it is saved locally.
  • Enter the Full Path location and click the Save icon to export the data to the local path.