Cheque Register report
The Cheque Register report provides a list of payments made by cheque, bank files, charge card payments, and more.
You can void cheques that have been confirmed to the General Ledger from the Cheque Register report. If required, you can also reverse the associated AP purchase invoice.
Make sure to enter the correct void date for the cheque as it cannot be changed.
You can only void a cheque in the Cheque register in 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 report does not include the following information:
Cheques from before you started using Sage Intacct which were imported as initial open items. Instead, view these cheques in the pending reconciliation report.
Applied credits. Instead, run the AP ledger report.
| Subscription | Cash Management |
|---|---|
| User type | Business, Employee |
| Permissions | Check Register report: Run |
Generate a monthly report—Overview
Go to Cash Management > All > Reports > Registers > Cheque.
Choose a reporting period.
Apply any filters.
Select Run.
To adjust results, select Customize to return to the report.
Customize the report
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.
Set the Filters to target specific data.
Filter optionsSelect the Cheque 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.
Use the Payee from and Payee to fields to show results for a specific payee (supplier) or a range of payees,
- The following filters appear if you work in a multi-currency environment
- 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.
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.
- Filter the report by Department.
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.
- Select the Transaction currency of the transactions you'd like to include.
- Use the From cheque no and To cheque no dropdown lists to show results for a specific cheque number or range of cheque numbers.
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 cheque number.
- The payment method for each entry in the register.
You can include one of the options in the Detail mode options dropdown lists:
AP purchase invoice GL account from and AP purchase invoice GL account to – show cheques filtered among different GL accounts (show the line items from the accounts listed)
OR
AP purchase 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 GL account dropdown lists show AP account labels instead of GL accounts.- Select Show only voided if you want the report to display only cheques that have been voided.
- Select Show only cheque transactions to display only transactions paid for by cheque.
- 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 cheques that have been reconciled and cheques that have not been reconciled.
- In Transit – show only cheques that have not been reconciled.
- Cleared – show only cheques that have been reconciled.
The following table describes each item in the Filters section:
Filter box Notes Cheque account
Include only cheques written from the selected cheque account
From/To
Includes data only for a specific supplier or payee or range of suppliers or payees. By default these fields are blank and 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
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: AP purchase 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 purchase 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 purchase invoices paid by cheques which were later voided
Show only cheque transactions
Include only AP purchase 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 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.
Format the report.
Select the Page orientation and specify how to sort included data. You can also group data by Bank, Supplier, or Date.
Format options- Select either Portrait or Landscape for the Page orientation.
- Select the Sort by dropdown list, 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 purchase 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.
- 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 reportEnter 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.
Enter the subtitle in the Report title 2 box.
The subtitle displays in smaller type, directly beneath the main title.
- 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
- Open the report and select Graph.
- From the graph page, select Print.
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 Cheque Register report includes of the following columns.
| Column heading | Description |
|---|---|
Bank | The Account ID and Bank name for the cheque account. |
Date | The date on which the cheque was written. The register displays the date chosen in the Set payment date to field when you go to pay AP purchase invoices. |
AP purchase invoice date (AP) Transaction date (CM) | Appears only if Show details was selected.
|
AP purchase invoice No (AP) Transaction no. (CM) | Appears only if Show details was selected. The record number assigned to the AP purchase invoice by the supplier. |
Supplier (AP) Payee (CM) | The ID associated with your supplier or payee followed by the supplier or payee name. |
GL account or account label | Appears only if Show details was selected. The account assigned to the expense. |
Method | Appears only if Show details was selected. The payment method: cheque, cash, or a transfer of funds, for example. |
Document no. | The ID associated with payment type, for example, the number on the cheque, written to the supplier. |
Txn curr | For multi-currency companies only. The currency in which the transaction was paid. |
Txn amount | For multi-currency 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. |
Base amount | The amount paid to the supplier in the entity's base currency. |
Cleared | Information about the reconciliation status of the transaction.
Key:
|
Memo | Appears only if Show details was selected. An optional description for the expense. |
Department | Appears only if Show details was selected. The department assigned the expense. |
Location | Appears only if Show details was selected. The location to which the system assigned the expense. |
AP purchase invoices | Display details about the AP purchase invoices paid with the selected cheque. |
Void |
