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. Click here to learn how to send, export, or print this report.
