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 label 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 employee.
  • If Check Number is selected in the Sort By drop-down menu, the new page toggle will be titled New page for each pay type.
  • If Vendor Number 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.

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