The Check Register Report allows the User to see both deposits and expenses made during a specified date range. Details on the checks made during a specific time period can allow a user to see which locations are associated with checks.
Navigation
The My Reports search bar can be used to search R365's entire catalog of reports.
- Open the Reports app.
- Navigate to My Reports.
- Enter all or part of the report name in the search bar.
- The Results tab will open with the list of search results.
- From beneath the report name, click Run to run the report with the selected report view.
-OR-
Click Customize to adjust the report parameters and run the report.
Report Parameters
Field/Column | Description |
|---|---|
Bank Account | A listing of all bank accounts. |
Show Unapproved | Includes or excludes unapproved transactions along with approved transactions. |
Start Date | The beginning date for the report. |
End Date | The ending date for the report. |
Sort | This organizes the checks based on date or, if 'Reconciled Then Date' is selected, reconciled first and then organized by date. |
Hide Reconciled | This option allows the user to hide or show reconciliations. |
Voids | This option will either show or hide voids. |
Vendor | A listing of all vendors. |
Run Button | Runs the report. Users can also send, export, or print the report directly from this button by clicking the down arrow portion and selecting the desired action. |
Report Details
Field/Column | Description |
|---|---|
Date | The date of the transaction. |
Matched | The date the transaction was matched to a bank activity. |
Reconciled | The date of the bank reconciliation, or when the transaction was reconciled. |
Type | The type of transaction. |
Ref. Number | The number associated with the transaction. |
Company | The company/person that the expense was made out to (vendor) or bank withdrawal. |
Payment Name | The payment name used at the time of payment and noted on the payment record. This is not the payment name from the vendor record. |
Comment | Any additional information about the transaction, as written in the transaction. |
$ Void | The amount voided. If a credit to cash void occurred, the amount is displayed with a negative sign; a debit to cash void is displayed without a negative sign. This column appears only if the 'Voids' parameter was toggled to 'Yes'. |
$ In | The amount deposited into the bank, totaled in the last row. |
$ Out | The amount taken out of the bank, totaled in the last row. |
Balance | The bank account balance after the deposits and expenses from the selected date range, totaled in the last row. |
Reconciled | This column appears if 'No' was selected for 'Hide Reconciled' and is totaled in the last row. To the right of this column, letters indicate whether a transaction was reconciled (R), matched but not yet reconciled (M), or voided (V). |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Learn more about how to send, export, or print this report.
