SmartFusion Modules > Bank Reconciliation > Process > Create Bank Reconciliation 

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

6.212 - Updated the E-Payment data pull so that previously reconciled E-Payments would appear as unreconciled if their bank reconciliation was deleted and re-created.  

6.210 - Fixed an issue where an application error was being thrown because of an invalid AP128ID of zero for Payroll; Also fixed an issue where duplicate ReconciledEpayments records were being created for AP

6.209 Supplemental - 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.202 Supplemental - Fixed an issue where voided E-Payments were not showing up on the Electronic Payments grid. Also fixed it so that only E-Payments that have been voided and have a void date that is later than the "Statement end date" will now be included in the Electronic Payments grid.    

6.201 - E-Payments that have been voided and have a void date that is later than or equal to the "Previous statement end date" will now be included in the Electronic Payments grid.    

6.196 - Added receipt number to the deposits grid. When receipts that have already been imported into bank reconciliation are now voided, the deposits grid will now show the reversal entries  with the receipt number that was voided. The receipt number will be zero for the original deposit.

Refer to bottom of page for changes prior to version 6.190

Introduction

This screen allows users to view/create/edit bank reconciliations. Users may also import bank reconciliation files that will allow the system to automatically clear checks based on the import file. This screen contains grids to display any checks or deposits that have not yet cleared as well as any credits, debits, or E-payments.

There is a portion of the screen that shows the totals for the bank reconciliation as well as a section that allows users to view the fund ledger totals for the account associated with the bank account group.

Users may also access the Enter/Edit Journal Entry and Post JE to Ledger screens from here.

Upon reconciling, the Bank Reconciliation Report will automatically be generated as a print preview.

Details

Fields
  • Bank account group
  • Previous reconciliation date
  • Import bank reconciliation file (button)
  • Refresh (button)
Grids
  • Checks
  • Deposits
  • Other Credits
  • Other Debits
  • Electronic Payments
  • Bank Accounts
Bank Reconciliation Fields
  • Statement end date
  • Starting balance
  • Cleared checks
  • Cleared deposits
  • Cleared credits
  • Cleared debits
  • Cleared E-Payments
  • Ending balance
  • Bank balance
  • Difference - The difference between the ending balance and the ending bank balance
  • Outstanding checks
  • Deposits in transit
  • Outstanding credits
  • Outstanding debits
  • Outstanding E-payments

  • Projected Ending bank balance - This value is the bank balance minus any outstanding checks plus any deposits in transit minus Outstanding debits plus Outstanding credits minus outstanding E-payments

  • Notes

Fund Ledger Fields
  • Fund ledger begin date
  • Total credits
  • Ending FL balance
  • View account detail inquiry (button)
  • Difference between fund ledger and ending bank balance
  • Enter/Edit Journal Entry (button)
  • Post JE to Ledger (button)

Changes Prior to Version 6.190

6.186 
- Fixed an issue where voided checks that had a void date less than the Statement end date were showing on the checks grid and were getting included in the Outstanding checks totals.
- Added an option to display/clear Cash Receipts in FL in a lump sum, grouped by a new 'Bank rec group' field added to the cash receipt master.

6.183 - Checks that have been voided and have a void date that is later than or equal to the "Statement end date" will now be included in the checks grid. They will not be able to be selected, however, as they have been voided.

6.170 Supplemental
- Added a refresh button to refresh all the checks and saved the progress.
- Fixed an issue with the reconciling of outstanding manual checks.  

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.  

6.134 - Added the logic to save the fund ledger information when reconciling and it will now be displayed in the Bank reconciliation report. Also added logic if the setting 'Last reconciliation must be in balance' is set in the system file and the last reconciliation balance is not 0 it will now display a message that the last reconciliation is not in balance and close the form.

6.124 - Updated the reconciling of checks to include checks that have a check date with a time stamp  

6.123 - Updated the statement end date to use the latest SQL time for the end-of-day for the Fund Ledger data pull. 

6.117 - Updated the statement end date to be the end-of-day for the Fund Ledger data pull  

6.89 - Made sure that EFT deposits were included in the deposits tab.  

6.88 - Fixed an issue where a canceled bank rec was being saved after starting an import for a file, then canceling the bank rec.  

6.67 - Changed the logic that pre-populates the Fund ledger being date. Previously is was using the date of the last bank reconciliation, now it's using the date of the last bank reconciliation PLUS 1 day.

6.63 - Added three new fields to the bank reconciliation portion for Outstanding Credits/ Debits and E-payments. Outstanding Credits/Debits and E-payments will be automatically calculated based on the number of credits/debits/E-payments that have not cleared before the Statement end date. Changed formula to calculate  Ending bank balance. It will be calculated as follows: Ending bank balance = Bank balance - Outstanding checks + Deposits in transit - Outstanding E-payments + Outstanding Credits - Outstanding Debits)

6.60 - New features to help integrate fund ledger with the bank reconciliation process
  > Added section to the right to show fund ledger beginning balance, total credits, total debits, ending FL balance, and difference between fund ledger and ending bank balances.
  > Relocated fund ledger detail account inquiry report button to be next to the Ending FL balance field instead of being next to the Bank account group.
  > Added two new fields to the bank reconciliation portion for Outstanding checks and Deposits in transit. Outstanding checks will be automatically calculated based on the number of checks that have not cleared before the Statement end date. Deposits in transit will be a user entered value and will be stored when the bank reconciliation is saved. Both new fields will be included when determining the Ending bank balance (example: Ending bank balance = Bank balance + Outstanding checks - Deposits in transit)
  > Added new button to bring up the Enter/Edit Journal Entry screen as a modal.
  > Added new button to bring up the Post JE to Ledger screen as a modal. Closing this modal will save the current bank rec and refresh the tables.

6.50 - set the header of the Bank Reconciliation report to go further than the first page if takes up more space than that.