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 label 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     Print the report.

• Click the Print icon to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).