Summary

The Detail by Account Report displays the uncommitted or committed detail line items on computer checks, manual checks or invoices. The report can be filtered by check date or invoice date, batch number and the GL accounts attached to the line items.

Step by Step

1     Open the Detail by Account window (AP> Reports> Detail by Account).

2     Complete the Print Options section.

• The GL Account Number field is used to filter the report by a single general ledger account.
  • Click the GL Account Number field search button   to select the GL account number from a list of accounts.
  • Leave the GL Account Number field blank to include all GL account on the report.
• The Date From and Date To fields are used to filter the report by date. The date that will be used depends on the transactions included on the report. If Computer Checks Only or Manual Checks Only is selected in the Print Only field, the Date From and Date To fields will filter the transactions by check date. If Invoices Only is selected in the Print Only field, the Date From and Date To fields will filter the transactions by invoice date.
• The Batch Number field is used to filter the report by the transactions in a computer checks, manual checks or Invoices batch.
  • Click the Batch Number field search button to select the batch you would like to include in the report.
• Select the transactions that will display on the report in the Print Only drop-down menu.
  • If you select Computer Checks Only or Manual Checks Only, the report will display check line items. The report will display the GL account, vendor, description, check number and amount attached to each line item. The GL Date column will display the invoice date of the invoice paid by the check.
  • If you select Invoices Only, the report will display the GL Account, vendor, description, invoice date, invoice number and amount.
    • If the invoice has been paid or is being paid in an open Computer Checks batch, the check number of the payment will display in the Check Number column.
    • If the invoice is attached to a purchase order, the purchase order number will display in the PO Number column.
• Check the Page Break by Department toggle if you would like to add a page break to the report for each department. This toggle will also insert a subtotal by department at the bottom of each department included in the report.
  • If you do not check this toggle, the report will still display the total transactions by department, but a page break will not be inserted.
• Check the Show only committed entries toggle if you would like only committed computer checks, manual checks or invoices to display on the report.
  • This toggle is generally checked if you have not filtered the report by batch. For example, check this toggle and enter a GL account number in the Account Number field to display all of the committed line items attached to a specific GL account.

3     Print the report.

• Once the required report settings have been specified, click the Print button to print your report.
• Click the options arrow on the right side of the Print button to see other print options.
  • Select Send PDF to Job Viewer to print the report in the default Springbrook format.
  • Select Send Excel to Job Viewer to export the report data to an Excel spreadsheet as unformatted data.
  • Select Send Excel (Formatted) to Job Viewer to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
• Click the Schedule icon next to the Print button in order to schedule the report to generate at a later date and time.
  • Scheduled printing has not yet been enabled for reports generated from process batches. This functionality will be released in an upcoming service pack.
• Users can also regenerate a report with the same configuration as a prior report via the report history section. This can help improve efficiency when an identical report is frequently generated.
  • Once a report has been generated, the date and time it was generated will display in the report history accessed via the Expand Arrow button on the right side of the window.
  • Expand the report history and click on a previous report record to automatically populate the report criteria with the criteria specified on the previously generated report. This section will display the last three times the report was generated.