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.
Related Topics
Published date: 05/21/2021