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
1) Bank Account - A listing of all bank accounts
2) Show Unapproved - Includes or excludes Unapproved transactions along with Approved transactions
3) Start Date - The beginning date for the report
4) End Date - The ending date for the report
5) Sort - This organizes the checks based on Date or, if 'Reconciled Then Date' is selected, reconciled first and then organized by date
6) Hide Reconciled - This option allows the User to hide or show reconciliations
7) Voids - This option will either show or hide voids
8) Vendor - A listing of all Vendors
9) 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
1) Date - The date of the transaction
2) Matched - The date the transaction was matched to a bank activity
3) Reconciled - The date of the bank reconciliation, or when the transaction was reconciled
4) Type - The type of transaction
5) Ref. Number - The number associated with the transaction
6) Company - The company/person that the expense was made out to (Vendor) or Bank Withdrawal
7) 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
8) Comment - Any additional information about the transaction, as written in the transaction
9) $ 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'
10) $ In - The amount deposited into the bank, totaled in the very last row
11) $ Out - The amount taken out of the bank, totaled in the very last row
12) Balance - The bank account balance after the deposits and expenses from the selected date range, totaled in the very last row
13) 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.