SmartFusion Modules > Bank Reconciliation > Process > Edit Bank Reconciliations 

Recent Changes:
6.215 - Added functionality to separate E-Payments from Payroll by update number.

6.209 - Added functionality to split epayments from AP into individual payments in bank reconciliation; Added functionality to Each payment should be able to be cleared just like checks.

6.193 - Fixed an issue where checks cleared in a date later than the current statement end date were not getting included in the Outstanding checks totals.

6.167 - Added a filter to pull only the outstanding debits, credits, e-payments, deposits and checks less than or equal to the ending bank statement date.

Introduction

This screen allows any bank reconciliation that was created through the new Bank Reconciliation feature to be edited or deleted if needed.

You cannot edit any account adjustments (journal entries) on this screen. You must edit these records on the Enter/Edit Journal Entry screen in the Fund Ledger module.

Selection Criteria

Bank account group

Bank Reconciliation Detail

Statement date
Continue bank reconciliation
This will take you into the same process as Create Bank Reconciliation. If SmartFusion cannot determine a prior bank reconciliation it will prompt user for a previous statement end date and the ending balance.

Edit starting balance
When editing the starting balance of an reconciliation all of the subsequent reconciliation starting and ending balances will be updated\calculated based on the new ending and starting balance as well as cleared activity totals.

Trouble-Shooting

If customer data is not currently in sync with ending and starting balances applying a new starting balance has the potential data to calculate all starting and ending balances to values that are not desirable.

This is possible if user has only been using the process to clear checks. When doing so even though a bank reconciliation is displayed it is not a true reconciliation. It will show the cleared checks in the Reconciliation Report but will not display a cleared total in the summary section

BankRecScreenshots-BankRecReportZeroAmountCleared2.jpg

To resolve this issue the user will need to

  1. edit the starting balance of the reconciliation they wish to fix even if it is correct. If the balance is incorrect fix it or just click ok to run the process.
  2. If the ending balance is not correct and/or the the above scenario is found the user will need to continue bank reconciliation for that statement date. In most cases the user will just need to reconcile the reconciliation.
  3. User will need to edit the starting balance for the same reconciliation and keep the same balance as per the process in step 1. This will recalculate all the ending balances moving forward.
  4. If there are future reconciliations that are incorrect restart at step 1 on that reconciliation statement date and process until all reconciliations are correct.