Enhanced interface

Cheque register report

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

Do you need help troubleshooting the Check register?

About the Cheque register

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

You can void cheques that have been confirmed to the General Ledger from the Cheque register and reverse the associated AP supplier invoice.

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

Cannot void a cheque?

You can only void a cheque in the Cheque register in one of the following circumstances:

The cheque has been confirmed to the General Ledger.

Void unconfirmed cheques from the Print cheques 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 cheque in an open period.

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

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

If you’re viewing the Cheque 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 Cheque register report.

If you’re restricted to certain entities and want to void a cheque created at the top level, run the Cheque 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:

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

View these cheques 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 > Cheque.
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 cheque 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 Current 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 (supplier) 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, suppliers, 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 cheque number or range of cheque numbers, use the From cheque no and To cheque no dropdowns.
To show results for cheques 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 AP supplier invoice and the amounts paid against them by cheque 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:
- AP supplier invoice GL account from and AP supplier invoice GL account to – show cheques filtered among different GL accounts (show the line items from the accounts listed)
  
  OR
- AP supplier invoice GL account group – show cheques filtered by a specific account group (for example, GL account “utilities”)
If you have AP account labels turned on in your configuration, the AP supplier invoice 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 cheques that have been voided.
Select the Show only cheque transactions checkbox if you want the report to display only transactions paid for by cheque.
Select the Show reconciliation status checkbox if you want the report to display whether the cheques have cleared or are in transit.
Select one of the following Reconcile state options:
- All – show cheques that are both in transit and cleared.
- In Transit – show only cheques that are being processed .
- Cleared – show only cheques that have cleared.

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

Filter Box	Notes
Current account	Include only cheques written from the selected current account
From/To	Includes data only for a specific supplier or payee or range of suppliers or payees. By default these fields are blank, which means the report will include all suppliers and payees.
From cheque no/To cheque no	Includes only the cheque or range of cheques 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: AP supplier invoice 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.
AP supplier invoice 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 AP supplier invoices paid by cheques which were later voided
Show only cheque transactions	Include only AP supplier invoices paid for by cheque
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 cheques for this report.

If the Current account field (Filters section) is set to All current accounts, the cheque 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, cheque, 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 (Supplier)
- Date
- AP supplier invoice Account

For example, to see all cheques grouped by the bank on which they were drawn, select the Bank option. You can then sort the cheques by date or cheque 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 Cheque 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 current account.
Date	The date on which the cheque was written. When you pay AP supplier invoices, the register displays the date chosen in the Set payment date to field.
AP supplier invoice date (AP) Transaction date (CM)	Appears only if the Show details checkbox was selected. AP: The AP supplier invoice date as entered in the Date field on the AP supplier invoice CM: The date of the transaction.
AP supplier invoice No (AP) Transaction no. (CM)	Appears only if the Show Details checkbox was selected. The record number assigned to the AP supplier invoice by the supplier
Supplier (AP) Payee (CM)	The ID associated with your supplier or payee followed by the supplier or payee name. Display the Supplier 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: cheque, EFT, cash, or a transfer of funds.
Document no.	The ID associated with payment type, for example, the number on the cheque, written to the supplier.
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 supplier.
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 supplier in your base currency.
Cleared	In Transit: The cheque has not yet been reconciled. Cleared: The cheque 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.
AP supplier invoices	Display details about the AP supplier invoices paid with the selected cheque.
Void	Void the selected payment. You can only void a cheque in the Cheque register in one of the following circumstances: The cheque has been confirmed to the General Ledger. Void unconfirmed cheques from the Print cheques 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 cheque in an open period. You can't void a cheque in a closed period. Instead, void the cheque using a date that falls within the next open period. For example, you have a cheque dated 6/20/2022. You reconciled the cheque at the end of the next month on 6/30/2022 and closed the books on the same date. You can void the cheque using the date 7/1/2022 because this is a date that falls within an open period. You can't void the cheque any earlier than this date without reopening the reconciliation and also reopening the period. Make sure to enter the correct void date for the cheque as it cannot be changed. You're in the same entity that made the payment. If you’re viewing the Cheque 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 Cheque register report. If you’re restricted to certain entities and want to void a cheque created at the top level, run the Cheque 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.