Check Register report

Related information

Related topics

• Troubleshoot the Check register report
• Void checks
• Unvoid a voided check
• Troubleshoot voiding checks
• Troubleshoot bill reversals

The Check Register report provides a list of payments made by check, bank files, charge card payments, and more.

You can void checks that have been confirmed to the General Ledger from the Check Register report. If required, you can also reverse the associated bill.

Generate a monthly report—Overview

1. Go to Cash Management > All > Reports > Registers > Check.

2. Choose a reporting period.

3. Apply any filters.

4. Select Run.

   To adjust results, select Customize to return to the report.

Customize the report

1. Select the Reporting period.

   Or, enter the Start date and End date of the period to cover. Specify either the reporting period or the start and end dates, but not both.

2. Set the Filters to target specific data.

   Filter options

   1. Select the Checking account to include in the report.

      Administrators can pre-set a default bank in the Configure Cash Management page. For multi-entity shared companies, you can set a default bank on an entity-by-entity basis.

   2. Use the Payee from and Payee to fields to show results for a specific payee (vendor) or a range of payees,

   3. The following filters appear if you work in a multi-currency environment

      1. Select the Transaction currency of the transactions you'd like to include.

         This option appears if your company uses foreign currencies If you do not make a selection, the report includes transactions of all currencies. The report itself is in base currency.

      2. Select the Location to filter the report by.

         This can be the name of the region, country, state or territory, or city.

         Enter or select a location to run this report at the top level. The location you specify determines the appropriate currency.

      3. Filter the report by Department.

      4. To include certain locations regardless of what you select as the Location, use the Show for field.

         • To include data for all locations regardless of the entity that you're currently using, select All Locations.
         • To include data only for the entity that you're currently using, select This location.
         • To include data only for locations that are child locations of your current entity, select Child locations.

           For example, if your current entity is California, and you have child locations for San Francisco and Los Angeles, use this option to include data only for Los Angeles and San Francisco.

   4. Use the From check no and To check no dropdown lists to show results for a specific check number or range of check numbers.

   5. Select Show details to include the following details in your report:

      • Account label (or Account), Department, Location, and Memo for each line item
      • Line items of the transaction and the amounts paid against them by check number.
      • The payment method for each entry in the register.

      You can include one of the options in the Detail mode options dropdown lists:

      • Bill GL account from and Bill GL account to – show checks filtered among different GL accounts (show the line items from the accounts listed)

        OR

      • Bill GL account group – show checks filtered by a specific account group (for example, GL account “utilities”)

      If you have AP account labels turned on in your configuration, the GL account dropdown lists show AP account labels instead of GL accounts.
   6. Select Show only voided if you want the report to display only checks that have been voided.
   7. Select Show only check transactions to display only transactions paid for by check.
   8. Select Show reconciliation status to display whether transactions have cleared the bank or are in still in transit.

      Select one of the following Reconcile state options:

      • All – show checks that have been reconciled and checks that have not been reconciled.
      • In Transit – show only checks that have not been reconciled.
      • Cleared – show only checks that have been reconciled.

   The following table describes each item in the Filters section:

   Filter box	Notes
   Checking account	Include only checks written from the selected checking account
   From/To	Includes data only for a specific vendor or payee or range of vendors or payees. By default these fields are blank and the report will include all vendors and payees.
   From check no/To check no	Includes only the check or range of checks specified
   Location, Department, Individual report, Prompt on run, and Show for	Limit report results to a specific location or department. Individual report: If this checkbox is cleared, the data is summed in a single report. If selected, each department and/or location combination has its own report page. The order you shuffle the groups determines the order in which their pages are printed. Due to their potentially large size, reports with departments and locations on individual pages can be run offline only. Prompt on run: Select to require you (or anyone using the report) to enter a location/department before the report runs. Show for: Enables you to display transactions for certain locations regardless of the location selected in the Location dropdown list. All locations: Display the data of the location/entity you selected and its children. This location: Only display the data of the location/entity you selected and not of its children. Child locations: Only display the data of the children of the location/entity you selected.
   Show details	Add a second line of additional detail for each transaction in the report. This line includes Account Label (or Account), Department, Location, Allocation and Memo. In addition, you can view the payment method for each entry. By default this checkbox is unchecked, which means the report will not include any details.
   Detail Mode Options: Bill GL account from, to	If you selected the "Show details" checkbox, select either the range of accounts from the GL or the account group from the GL.
   Bill GL account group	If you selected the "Show details" checkbox, select either the range of accounts from the GL or the account group from the GL.
   Show only voided	Include only bills paid by checks which were later voided
   Show only check transactions	Include only bills paid for by check
   Show reconciliation status	Select this checkbox to view the Cleared column in the register report. There, you can view the Reconcile State of the transaction (see description below).
   Reconcile state	Displays the reconciliation status for a transaction in the Cleared column of the register report. All: show transactions that have been reconciled (the reconciliation is closed) and transactions that have not yet been reconciled. In transit: show only transactions that have not yet been reconciled. Cleared: show only transactions that have been reconciliation. Transactions appear with their reconciliation date in the Cleared column.

3. Format the report.

   Select the Page orientation and specify how to sort included data. You can also group data by Bank, Vendor, or Date.

   Format options

   1. Select either Portrait or Landscape for the Page orientation.
   2. Select the Sort by dropdown list, and select a category to sort by.

   3. Use the Report grouping option to arrange related data together by group. Select one of the following:

      • Bank
      • Payee (Vendor)
      • Date
      • Bill Account

   For example, to see all checks grouped by the bank on which they were drawn, select the Bank option. You can then sort the checks by date or check number.

   The following table describes each item in the Format section of this report settings page:

   Format box	Notes
   Page orientation	Portrait is the default layout. Portrait: display or print the report pages vertically. Landscape: display or print the report pages horizontally.
   Sort by	Date is the default.
   Report grouping	Bank is the default. Arrange related data together by group.

4. Create a title, subtitle, and footer text for your report.
   About titles, subtitles and footer text

   Titles, subtitles, and footers apply only to the print versions of this report. Export to Excel or CSV, or select Print for a PDF version.

   Add a title, subtitle, and footer to the report

   1. Enter the title in the Report title 1 box.

      • This title displays in large type at the top of the page, directly under your company name,
      • You can type over any default name that appeared automatically in this box.

   2. Enter the subtitle in the Report title 2 box.

      The subtitle displays in smaller type, directly beneath the main title.

   3. Enter the footer text in the Footer text box. Footer text displays at the bottom center of the report.

   You can use up to 80 characters, including spaces, in each title, subtitle, and footer.

   Titles, subtitles, and footers apply only to the PDF version of this report.

   Generate a PDF version

   1. Open the report and select Graph.
   2. From the graph page, select Print.

5. Select one of the following options. Some options are only available from the Reports center.

   • View: View the report in your browser.
   • Print: View the report in a printable PDF format.
   • Process & store: Generate the report and store it for later access.

     Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.

   • Add to dashboard: Add the report to your dashboard.

   • Memorize: Memorize (save) the report to refer back, modify, and re-run it.

     Schedule memorized reports to run on a recurring basis. Automatically email the reports or deliver them to a cloud storage location.

   • Export: Export the report to a separate file.

     File formats vary among reports.

   • Customize: After you run the report, refine the report further.
   • Email: After you run the report, email to others.

What's in this report?

The default Check Register report includes of the following columns.