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 label 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 label 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.

• 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).