Date Cutoff for Bank Reconciliation

The current bank reconciliation functionality does not have the ability to cutoff cleared transactions based on the bank statement/reconciliation date.  We clear transactions daily to ensure that there is no fraudulent check or ACH activity on our bank accounts because the bank has strict timelines for notice if we find improper transactions, but this creates a problem with the monthly bank reconciliation because it includes cleared transactions beyond the bank statement date in the cleared balance.  For example, if my bank statement date is April 30th, but I have cleared transactions with a May date, those will get included in the reconciled balance in the bank reconciliation even though they were cleared AFTER the cutoff date of April 30th.  This means that we have to perform a manual reconciliation daily to check the validity of the bank transactions and then we perform the reconciliation again at month end using the FE bank reconciliation.  This is inefficient and if the bank reconciliation functioned with a true cutoff date, we would be able to do this all within the FE system.  

  • Heather Bushey
  • May 16 2018
  • Needs review
  • Attach files