Enhanced interface

Check register report

The Check register report provides a list of payments made through a specified bank, or multiple banks. View payments made by check, or a list of all payments and the payment method for each (for example, by check, EFT, cash, or a transfer of funds).

Do you need help troubleshooting the Check register?

About the Check register

The Check register includes all checks recorded or printed from Accounts Payable. By default, the Check register report includes the reconciliation status of each payment entry, such as In transit or Cleared.

You can void checks that have been confirmed to the General Ledger from the Check register and reverse the associated bill.

Make sure to enter the correct void date for the check as it cannot be changed.

Cannot void a check?

You can only void a check in the Check register in one of the following circumstances:

The check has been confirmed to the General Ledger.

Void unconfirmed checks from the Print checks page.
You have the appropriate permissions.

You need permissions in Accounts Payable to void posted payments and (optionally) posted advances. You need similar permissions in Expenses to void posted reimbursements and posted advances.
You're voiding the check in an open period.

You can't void a check in a closed period. Instead, void the check using a date that falls within the next open period.

For example, you have a check dated 6/20/2022. You reconciled the check at the end of the next month on 6/30/2022 and closed the books on the same date. You can void the check using the date 7/1/2022 because this is a date that falls within an open period. You can't void the check any earlier than this date without reopening the reconciliation and also reopening the period. Make sure to enter the correct void date for the check as it cannot be changed.
You're in the same entity that made the payment.

If you’re viewing the Check register report from the top level and do not see a Void link, slide into the entity from which the payment was made and open the Check register report.

If you’re restricted to certain entities and want to void a check created at the top level, run the Check register report without providing a location. Without a location filter, the report shows transactions created at the top level only. Where applicable, you have the option to void.

Alternatively, you can void payments from Posted payments in Accounts Payable.

The Check register does not include the following:

Checks from before you started using Sage Intacct which were imported as initial open items.

View these checks in the pending reconciliation report.
Applied credits.

To see applied credits, run the AP ledger report.

For information on terms that may differ in your location, see Terminology across locales.

View a monthly report

Subscription	Cash Management
User type	Business, Employee
Permissions	Cash Register Report: Run

Go to Accounts Payable > All > Reports > Registers > Check.
On the report settings page, select View.

All results for the default reporting (the current month) period appear.
To refine the report, select Customize which takes you back to the filter page.

Customize and run

Before running the report, you can select the time period and types of items to include and specify how you want the report to appear.

Use trial-and-error to get the precise results you want.

Fill in the desired boxes, and select View to see the report. If after viewing the results you want to refine the report further, select Customize to return to the report setup page. Repeat this process until you're satisfied. For complex financial reports you plan to run regularly, select a reporting period and memorize the report when you're done setting it up. Just change the As of date before running the report next time.

Select the Reporting period, or enter the start and end dates you want the report to cover.

If you do not specify a reporting period, the generated report uses the current month to date. You can specify either the reporting period or the start and end dates, but not both.
Set the Filters to get the specific data you want.

You can include or exclude specific types of data, such as specific payees or check numbers. To get fewer and more precise results in your report, set more filters.
Format the report.

You can set the layout of the report and/or arrange how to group, sort, and display the data.
Create a title, subtitle, and footer text for your report.
To view, process, memorize, export, customize or add the report to the dashboard, select one of the buttons at the top of the page.

Time period

Use one of the predefined reporting periods available from the Reporting period and As of date boxes or create your own reporting period using the Start date and End date boxes.

You can specify either the reporting period or the start and end dates, but not both.

To set the time period

In the Time Period section, do one of the following:

Use a pre-defined reporting period:
1. Select the Reporting period down arrow, and then select the period you want.
2. Enter an As of date (the date that will be used as a baseline for the period you select; leave blank for today's date).
Specify your own reporting period by entering a specific Start date and/or a specific End date.

If you complete all the time period fields (that is, if you fill in the Reporting period, As of date, Start date, and End date fields), Sage Intacct generates your report based on the start and end dates. It ignores the As of date.

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

Time period box	Notes	Limitations
Reporting period	These periods are relative to the As of Date. All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select.	Only works with As of date. Does not apply if you select a Start date or an End date.
As of date	The date to as a baseline for the reporting period you select. Leave this box blank to use today's date.	Only works with Reporting period. Does not apply if you select a Start date or an End date.
Start date, End date	Leave the Start date blank to include all information from the earliest date you entered data into your company up to and including the end date. Leave the End date blank to include all information from the start date up to today.	The format must be: MM/DD/YYYY
Prompt on run	Select to require you (or anyone using this report) to enter a time period before the report runs.

Report filters

Use the filters to focus the results of your report. In effect, filters enable you to isolate and assemble just the data you want. You can set any combination of filters.

Customize report results

Select the account that you want to report on from the Checking account dropdown.

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.
To show results for a specific payee (vendor) or range of payees, use the Payee from and Payee to fields.
How to use the From and To fields
All From and To field pairs work the same way. Use them to get search results in as broad or as fine a range as you need, from everything in the system down to a single specific object.

To run this report for a single object:
1. From the From dropdown list, select the object you want.
2. From the To dropdown list, select the same object.
To run this report for a specific range of objects:
1. From the From dropdown list, select the object that you want at the beginning of the range.
2. From the To dropdown list, select the object that you want at the end of the range.
To run this report for all objects:

Leave both fields blank.

If you have a large number of objects or the report takes too long to process, use the From and To fields to run a series of smaller reports. For example, you can run five reports, one each for objects whose names begin with A-E, then F-J, K-O, P-T, and U-Z.

An object is a catch-all term that refers to any specific data item in the system. Customers, vendors, items, and accounts are all examples of objects.
The following filters appear only if you work in a multi-currency and multi-entity environment
1. To select transactions of a specified currency, use the Transaction currency dropdown. This option appears only if your company uses foreign transaction currencies. If you do not make a selection, the report includes transactions of all currencies. However, the report itself is in base currency.
2. To filter the report by geographic location, enter the name of the region, country, state or territory, or city in the Location box, or select the down arrow, and select the location you want from the list that displays.
  
  Enter or select a location to run this report at the top level. The location you specify determines the appropriate currency.
3. To filter the report by company department, enter the name of the department in the Department box, or select the down arrow and, from the list that displays, select the department you want.
4. If you want the report to cover certain locations regardless of what you select in the Location box, use the Show For field. In the Show For field, select the down arrow and select the locations you want the report to cover:
  1. To include data for all locations regardless of the entity that you're currently using, select All Locations.
  2. To include data only for the entity that you're currently using, select This Location.
  3. 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.
To show results for a specific check number or range of check numbers, use the From check no and To check no dropdowns.
To show results for checks from a specific location, disregarding the location selected in the Location dropdown, use the Show For dropdown.
Select the Show details checkbox if you want the report to include the following additional details in your report:
- Account Label (or Account), Department, Location, and Memo for each line item
- Line items of the bill and the amounts paid against them by check number
- The method of payment for each entry in the register
You can also include one of the options in the Detail mode options dropdowns:
- 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 Bill GL account dropdowns show AP account labels instead of GL accounts.
Select the Show only voided checkbox if you want the report to display only checks that have been voided.
Select the Show only check transactions checkbox if you want the report to display only transactions paid for by check.
Select the Show reconciliation status checkbox if you want the report to display whether the checks have cleared or are in transit.
Select one of the following Reconcile state options:
- All – show checks that are both in transit and cleared.
- In Transit – show only checks that are being processed .
- Cleared – show only checks that have cleared.

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

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, which means 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	Appears only for multi-entity shared companies. Enables you to limit report results to a specific location and/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 are both in transit and cleared In transit: show only transactions that haven't yet been reconciled. Cleared: show only transactions that have cleared reconciliation. Transactions appear with their reconciliation date in the Cleared column.

Formatting

Use this section to change the page layout, specify the sort order, and specify how to group the checks for this report.

If the Checking account field (Filters section) is set to All checking accounts, the check register list is first sorted by bank, and then by the sort order you selected from the Sort by field in this section. You can sort by date, check, payee, payee ID, or amount.

Format the report

Select either Portrait or Landscape from the Page orientation dropdown.
To sort the report results, select the Sort by dropdown, and select a category to sort by.
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.

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.

Titles and footer

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.

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

Generate a PDF version

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

What's in this report?

The default Check register report includes of the following columns.

You can select any link to drill down to the details.

Report Column Heading	Description
Bank	The Account ID and Bank Name for the checking account.
Date	The date on which the check was written. When you pay bills, the register displays the date chosen in the Set payment date to field.
Bill date (AP) Transaction date (CM)	Appears only if the Show details checkbox was selected. AP: The bill date as entered in the Date field on the bill CM: The date of the transaction.
Bill No (AP) Transaction no. (CM)	Appears only if the Show Details checkbox was selected. The record number assigned to the bill by the vendor
Vendor (AP) Payee (CM)	The ID associated with your vendor or payee followed by the vendor or payee name. Display the Vendor Information page to see more details about that record.
GL account or account label	Appears only if the Show details checkbox was selected. The account assigned to the expense.
Method	Appears only if the Show details checkbox was selected. The payment method: check, EFT, cash, or a transfer of funds.
Document no.	The ID associated with payment type, for example, the number on the check, written to the vendor.
Txn curr	For multi-currency, multi-entity companies only. The currency in which the transaction was paid.
Txn amount	For multi-currency, multi-entity companies only. The amount of the transaction paid in the currency preferred by the vendor.
Base curr	For multi-currency, multi-entity companies only. The value of the transaction in your base currency at the time the transaction took place.
Amount	The amount paid to the vendor in your base currency.
Cleared	In Transit: The check has not yet been reconciled. Cleared: The check has been included and cleared in a reconciliation. Result status: F: The check is unreconciled. M: The check is matched; status prior to reconciliation. T: The check has cleared.
Memo	Appears only if the Show details checkbox was selected. An optional description for the expense.
Department	Appears only if the Show details checkbox was selected. The department assigned the expense.
Location	Appears only if the Show details checkbox was selected. The location to which the system assigned the expense.
Bills	Display details about the bills paid with the selected check.
Void	Void the selected payment. You can only void a check in the Check register in one of the following circumstances: The check has been confirmed to the General Ledger. Void unconfirmed checks from the Print checks page. You have the appropriate permissions. You need permissions in Accounts Payable to void posted payments and (optionally) posted advances. You need similar permissions in Expenses to void posted reimbursements and posted advances. You're voiding the check in an open period. You can't void a check in a closed period. Instead, void the check using a date that falls within the next open period. For example, you have a check dated 6/20/2022. You reconciled the check at the end of the next month on 6/30/2022 and closed the books on the same date. You can void the check using the date 7/1/2022 because this is a date that falls within an open period. You can't void the check any earlier than this date without reopening the reconciliation and also reopening the period. Make sure to enter the correct void date for the check as it cannot be changed. You're in the same entity that made the payment. If you’re viewing the Check register report from the top level and do not see a Void link, slide into the entity from which the payment was made and open the Check register report. If you’re restricted to certain entities and want to void a check created at the top level, run the Check register report without providing a location. Without a location filter, the report shows transactions created at the top level only. Where applicable, you have the option to void. Alternatively, you can void payments from Posted payments in Accounts Payable.