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
To navigate to the Check Register Report, click 'My Reports' under 'Reports' in the left pane and select 'Banking' in the top header of the reporting window. Once opened, a listing of reports will be shown.
Find 'Check Register' and select 'Customize' next to the report. This will open up a listing of all Report Parameters that can be used to define your report.
Report Parameters
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. Click here to learn more about this functionality
Click here to learn more about Report Views and their added functionality.
Report Details
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 while a debit to cash void is displayed without a negative sign. This column will only be displayed if the 'Voids' parameter was toggled to 'Yes'
$ In - The amount deposited into the bank, totaled in the very last row
$ Out - The amount taken out of the bank, totaled in the very last row
Balance - The bank account balance after the deposits and expenses from the selected date range, totaled in the very last row
Reconciled - This column will be displayed if 'No' was selected for 'Hide Reconciled' and is totaled in the very last row. To the right of this column, letters will be displayed to show 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.