Summary

The Audit Data Report is used to export a filtered list of committed journal entries to a Microsoft Excel spreadsheet. The journal entry line items of each journal entry included on the report will display on a separate line. The spreadsheet generated by the process includes the following columns: GL account number broken up by section, GL account description, journal entry date, fiscal year, fiscal period, journal entry number, journal entry line item number, debit amount and credit amount.

If the journal entry line item was created by a batch process, the Description field on the report displays the batch number and process used to generate the journal entry. If a journal entry was created by the AP Computer Checks process, the description will include the check numbers processed in the batch. If a journal entry was created by an Accounts Payable invoice, the invoice line item description will display in the Description field on the report.

If you would like to view individual journal entries, use the Display palette (GL> Display> Journal Entries).

Step by Step

1     Open the Audit Data Report window (GL> Reports> Audit Data Report).

2     Configure the report. 

• The Date From and Date To fields are used to filter the journal entries that display on the report by journal entry date. You can view the journal entry date of a journal entry using the Journal Entry Selection window (GL> Display> Journal Entries).
• The Account From and Account To fields are used to select a range of GL accounts. Enter a GL account in the fields or click the Account From or Account To field search icon to select a GL account from a list.
• The System drop-down menu is used to filter the journal entries that display on the report by the module that was used to create them. For example, select AP if you would like to see the journal entries created by generating invoices and computer checks.
• The Sort Order field is used to select how information will display on the report.
• The Journal Entry column displays the journal entry number. Journal entries are assigned a sequential number that resets and begins at 1 at the beginning of each fiscal period.
• The Line Item column displays the journal entry line item number of the journal entry line item. The journal entry line item number is a sequential number assigned to journal entry line items when they are created.

3     Export the report.

• Click the Submit button to generate the export file.
• The export file will be automatically downloaded to your Downloads folder.