BankReconciliationCS > Bank Reconciliation > Reconciliation Tasks menu > BR Reconcile Bank Statement window
 
BR Reconcile Bank Statement window
Reconcile your bank statements using this window. Each bank account must be reconciled separately.
Bank Account 
Enter the Bank Account Code or double-click and select the correct code from the Lookup. The bank account must already be set up in the BR Bank Account window. Once you refresh the grid or select Save, you cannot change the Bank Account in this field. The description of the bank account you choose appears next to the Bank Account Code.
Closing Statement Amnt 
Enter the closing statement amount. This is the selected bank account’s balance at the time the statement is issued.
Ending Statement Date 
Enter the ending statement date or use the drop-down to select the correct date from the calendar. This defaults to the current date.
Cutoff Date 
Enter a date or select a date from the drop-down calendar to exclude items outside of the statement period. This defaults to the current date.
Starting and Ending Range: Item # 
Use this range to specify which item numbers you want to include in the reconciliation. Leave the defaults of Start and End to include all values for a particular range. You can also type the values or use the Lookup to enter the starting and ending values to include.
Sort Items By 
From the drop-down, select how you want to sort items in the grid. The default is based on your selection on the General tab of the BR Bank Account window. You can choose:
Item Number: sort by item number, date, and type.
Date: sort by date, item number, and type.
Type: sort by type, date, and item number.
Additions/Deposits, Checks, and Other Withdrawals: this sort groups additions and deposits together, followed by checks and other withdrawals. Each group is ordered by date.
Deposits, Checks, Other Additions, and Other Withdrawals: this sort begins with deposits ordered by date, followed by checks ordered by check number (item #), then all other additions ordered by date, and ends with all other withdrawals ordered by date.
Checks, Additions, Deposits, and Other Withdrawals: this sort shows checks ordered by date, followed by additions and deposits ordered by date, and then all other withdrawals ordered by date.
Type > Item #: sort by type first and then sub-sort by item #.
Type > Date> Amount: sort by type, date, and amount.
Date > Type > Item #: sort by date, type, and item #.
Date - Most Recent First: this sort is by date, with the most recent date appearing first.
Amount - High to Low: sort by amount, from highest amount to lowest.
Amount - Low to High: sort by amount, from lowest amount to highest.
All sorts are in ascending order, except for the Date - Most Recent First and Amount - High to Low options.
Activity Type
Select the activity type you want to include in the reconciliation. You must select at least one activity type, but you can select multiple types. Your can choose from:
All  
This is the default option. If you want to include all activity types on the report, leave it selected. To select a specific type or types, deselect this check box.
Check 
Select this check box to include check activity in the reconciliation.
Deduction 
Select this check box to include deduction activity in the reconciliation.
Bank Charge 
Select this check box to include bank charge activity in the reconciliation.
Deposit 
Select this check box to include deposit activity in the reconciliation.
Addition 
Select this check box to include addition activity in the reconciliation.
Reconcile Bank Statement Grid
The information in this grid is based on the selections you previously made in the window and the information entered in the BR Enter Bank Activity window.
Item # 
This is the item number entered in the BR Enter Bank Activity window. You cannot edit this field.
Date 
This is the date the line item was posted. You cannot edit this field.
Type 
This is the type of activity. You cannot edit this field.
Description 
This is the description of the line item. You cannot edit this field.
Amount 
This is the amount of the line item activity. You cannot edit this field.
Clrd? 
Check this field to mark the item as cleared. The total fields at the bottom of the window will adjust based on the line item amount.
If you use the automated reconciliation option, the cell will turn green when the box is checked (matched through the automated process). If you manually uncheck this box, it breaks the link with the automated reconciliation.
If you want all items to automatically be marked as cleared when you refresh the grid, select the Default All Items to “Clear” for Reconciliation check box on the General tab on the BR Bank Account window.
Reconcile Bank Statement Totals Fields
The fields under the detail grid cannot be edited. They provide you with running totals as you mark items as cleared and help you keep track of your reconciliation.
Checks 
For items with a Check activity type, this is the total number of items in the grid that are marked as cleared and their dollar amount.
Deductions 
For items with a Deduction activity type, this is the total number of items in the grid that are marked as cleared and their dollar amount.
Bank Charges 
For items with a Bank Charge activity type, this is the total number of items in the grid that are marked as cleared and their dollar amount.
Deposits 
For items with a Deposit activity type, this is the total number of items in the grid that are marked as cleared and their dollar amount.
Additions 
For items with an Addition activity type, this is the total number of items in the grid that are marked as cleared and their dollar amount.
Net Activity 
This is the total number of items in the grid that are marked as cleared and the total dollar amount.
Last Reconciled 
This is the date the selected bank account was last reconciled. When you post, this is updated with the date in the Ending Statement Date field.
Previous Balance 
This is the last balance to which the statement was reconciled for the selected bank account.
Out of Balance 
This field displays the amount by which that bank account balance does not match the statement balance. The amount is derived from the following formula: Closing Statement Amount - Previous Balance - Net Activity Amount. When the Out of Balance amount equals zero, the field reads <Balanced>.
Print Edit 
Select this button to open the BR Print Activity Report window.
Bank Register 
Select this button to open the BR Bank Register window for the selected bank account.
Refresh Grid 
Once you choose a bank account, select this button to populate the detail grid with all outstanding items within the selected ranges. If you select the Default All Items to “Clear” for Reconciliation check box on the on the General tab on the BR Bank Account window, all items will be marked as cleared when you refresh the grid. Items in the grid that are saved as Cleared will remain in the grid until they are Uncleared or until you post.
Zoom / Unzoom 
Once you select a bank account, use this button to increase the size of the grid area on the window. The button changes to Unzoom to decrease the grid size back to the default.
Clear All 
After you select the Refresh Grid button, select Clear All to mark all items on the grid as cleared.
Unclear All 
Use the Unclear All button to unclear all the items marked as cleared in the grid.
Automated Reconciliation 
Click this button to open the Automated Reconciliation window.
Published date: 05/21/2021