Summary

The Checks by Date Report displays a filtered list of checks generated in the Computer Checks and Manual Checks processes. The summary version of the report displays the check number, check date, vendor information and check amount. The detail version of the report displays all of the information on the summary report plus the detail line items on each check (for example, the invoice line items paid on the check).

Step by Step

1     Open the Checks by Date window (AP> Reports> Checks by Date).

2     Complete the Print Options section.

• The Check Date From and Check Date To fields are used to filter the report by AP check date.
  • The check date of an AP check is set during the Checks step (AP> Computer Checks> Checks).
  • The check date of an AP manual check is set during the Enter Manual Checks step (AP> Manual Checks> Manual Checks).
• The Check Number From and Check Number To fields are used to filter the report by check number.
  • The check number is set during the Check Register step (AP> Computer Checks> Check Register) when creating computer checks. Uncommitted checks will not have a check number until the batch has passed the Check Register step.
  • The check number is set during the Manual Checks step (AP> Manual Checks> Manual Checks) when creating manual checks.
• The Amount From and Amount To fields are used to filter the report by check amount.
• The Batch Number From and Batch Number To fields are used to filter the checks that display on the report by AP Computer Check or AP Manual Check batch number.
  • Entering a batch number will overwrite the dates in the Check date or Period End date fields.
• The Batch Month and Batch Year fields are used to filter the checks by the batch month and year of the batch that created the AP manual or computer check. The batch month and batch year of a Computer Checks or Manual Checks batch are set up when the batches are created using the New Batch window.
• The Expense Period From and Expense Period To fields are used to filter the checks on the report by the fiscal period attached to the invoice paid by the check.
  • The fiscal period expensed by an invoice is set by the journal entry date entered when the GL Distribution Report is generated in the Invoices batch (AP> Invoices> GL Distribution).
• The Expense Fiscal Year field is used to filter the report by the fiscal year attached to the invoice the check is paying.
  • The expense fiscal year of an invoice is defined during the Settings step of the Invoices process (AP> Invoices> Settings> Fiscal Year field).
• The Vendor Number field is used to filter the checks that display in the report by the vendor. Leave this field blank to include all vendors on the report.
  • Click the Vendor Number field search button   to select a vendor from a list.
  • Vendors are created and maintained using the Vendor Maintenance window.
• The Batch Process drop-down menu is used to filter the checks that display on the report by computer (AP> Computer Checks) or manual checks (AP> Manual Checks). Select All to include both on the report.
• The Check Status drop-down menu is used to filter the checks that display in the report by commit status.
  • Select Uncommitted if you would like to include all checks that are in uncommitted Computer Checks or Manual Checks batches.
  • Select the Select For Check option if you would like to include committed and uncommitted transactions on the report.
  • Select Committed if only committed checks should display on the report.
• The Sort By drop-down menu is used to select the order information will display on the report. The selection in this field will affect the functionality of the new page toggle at the bottom of the window.
• The Report Type drop-down menu is used to select the information that will display on the report.
  • Select Summary if you would like to display the basic check information: check number, check date, vendor information and check amount.
  • Select Detail if you would like to include the basic check information and the line items on the check.
• Check the Show void checks toggle if you would like to include voided checks on the report.
  • Checks that have been voided using the Void Checks process will display on the report when this toggle is checked.
• The function of the Page Break toggle depends on the sort option selected in the Sort By drop-down menu.
  • If Check Date is selected in the Sort By drop-down menu, the new page toggle will be titled New page for each day. Check this toggle if each day included on the report should display on a separate page.
  • If Check Number is selected in the Sort By drop-down menu, the new page toggle will be titled New page for each check. Check this toggle if each check included on the report should display on a separate page.
  • If Vendor Number is selected in the Sort By drop-down menu, the new page toggle will be titled New page for vendor. Check this toggle if each vendor included on the report should display on a separate page.

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.