Page Comparison

...

1. Bank Reconciliation (Statement-centric):
   1. Any bank lines that are in a group will not show in the bank rec.
   2. The group will show on a line with:
      1. 'Group' in the Bank Balance column.
      2. The group Date in the Bank Date column.
      3. The group Description in the Bank Description column.
      4. The sum of the debit amounts of the bank lines in the group in the Bank Out-DR column.
      5. The sum of the credit amounts of the bank lines in the group in the Bank In-CR column.
   3. The group line will have all of the same functionality of a bank line:
      1. Match to an existing journal or batch.
      2. Be reconciled to an existing journal or batch.
      3. Create a journal according to the DR or CR amount.
      4. Create a new Journal Template (bank rec rule).
      5. Show a draft journal according to a bank rec rule.
2. If the user has secure feature Secure Features#CanPerformBankReconciliation with a qualifier greater than 0:
   1. On a bank line that has not been reconciled and is not a group, new right click option 'Add to new group':
      1. A new group will be created, with the Date and Description from the bank line.
      2. The bank line will be added to the group.
      3. A popup window will show the group and list the bank lines in the group.
   2. On a bank line that has not been reconciled and is not a group, new right click option 'Add to Date Description':
      1. One option for each unreconciled group shown in the bank rec.
      2. Multiple groups will be listed in order of the number of days difference between the bank line date and the group date.
      3. The bank line will be added to the group and contribute to its amount.
   3. On a group line a new right click option 'Show bank transaction group':
      1. A popup window will show the group and list the bank lines in the group.
   4. In the group popup window:
      1. The Date and/or Description for the group can be changed, and click Save in the popup.
      2. If the group has not been reconciled then a new right click option 'Remove from group'.
3. Right click option 'Delete all bank lines from here on' is not available if any of the lines that would be deleted are in a group. Remove from the group first.

Unreconciled lines that have a cleared date

A cleared date is put on the journal line when the line is reconciled in the bank statement.  It cannot be removed by a user.  This feature is an audit check and if you see this button please contact support.

When the Action menu option ‘List bank statement(s)’ is chosen then a check is done to see if there are any journal lines with

1. the selected bank GL account
2. and within the selected date range
3. that have a cleared date
4. but are not in any bank statement.

If any are found then a red button labelled ‘Cleared bank lines not in bank statement’ will show under the ‘Journal unreconciled;’ label.

1. Clicking this button will open the ‘G/L Health’ form at the ‘Cleared bank lines’ tab with the bank rec date range and bank account selected and the list of relevant journals showing.

G/L Health form (Admin menu, Audit, View G/L health checks), new ‘Cleared bank lines’ tab:

1. If no date range and no bank account are selected then all journal bank lines with a cleared date but not in a bank statement will be shown.

   1. Journals with a journal date before the date of the first bank statement for the selected bank account will not be shown.

   2. Right click with one or more lines selected to remove the cleared date from the selected journal line(s).

   3. Right click on a line to open the journal.

Changing from the non-statement centric (old method) Bank Reconciliation process

...