Running the Bank to GL Reconciliation Report will tell the User if he/she setup his/her GL Accounts properly. This is usually ran at setup to make sure that all GL Accounts are balanced.
Navigation
To navigate to the Bank to GL Reconciliation 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 'Bank to GL Reconciliation' 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
Bank Rec - A listing of bank reconciliations based on the bank accounts chosen
Show - The options available to view the report:
All Reconciliations - Displays all the reconciliations for this bank account
Only Out of Balance - Displays only the reconciliations that are out of balance
This Reconciliation Only - Displays the balance of the chosen reconciliation
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 Reconciliation. This is hyperlinked, which enables the User to view all transactions associated with the GL Reconciliation. When this row is expanded, the dates associated with those transactions are shown and their transaction types are hyperlinked to their transaction details
Beginning Balance - The beginning balance for the selected Bank Account
Withdrawal Total - The amount of money withdrawn from the account
Deposit Total - The total amount deposited into this Bank Account
Ending Balance - The balance based on the Withdrawals and Deposits made (Beginning Balance - Withdrawal Total + Deposit Total)
End Bal + Uncleared - The ending balance with uncleared transactions included
GL Balance - The General Ledger balance
Difference - The difference between the Total End Balance (End Bal + Uncleared) and the GL Balance. If they are not equal, review the transactions to find and correct this imbalance
Balance Comment - If there's a comment listed, it will detail out why that row might be causing an issue
When the report is run for all Bank Reconciliations, the very first line will show the Beginning Balance at Go-Live, not a created Bank Reconciliation. This allows for User to know whether there is an imbalance at Go-Live.
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.