SmartFusion Modules > Bank Reconciliation > Reports > Bank Reconciliation Report

Recent Change:  
6.215 - Added functionality to separate E-Payments from Payroll by update number.  
6.134 - Added Fund ledger information to the report
6.97 - Fixed "other credits" to show correct balance. 
6.75 - Fixed the report to show the correct projected ending bank balance.
6.60 - Report will now include fields for Outstanding checks, Debits in transit, and Ending bank balance.

Introduction

This report allows users to view previously created bank reconciliations. The same report that is generated from this screen is also automatically generated at the end of creating or editing a bank reconciliation.

Screen Details

  • Bank account group
  • Statement Date/Ending Balance - Grid that allows users to select the reconciliation they wish to generate the report for

Report details

The reports displays the bank name(s), totals, and a list of all cleared checks, deposits, other credits, and other debits

Totals fields
  • Previous reconciliation date
  • Statement end date
  • Starting balance
  • Cleared checks
  • Cleared deposits
  • Cleared other credits
  • Cleared other debits
  • Cleared epayments
  • Ending balance
  • Bank balance
  • Difference
  • Outstanding checks
  • Deposits in transit
  • Outstanding credits
  • Outstanding debits
  • Outstanding epayments
  • Projected ending bank balance
  • Fund ledger begin date
  • Beginning fund ledger balance
  • Total fund ledger credits
  • Total fund ledger debits
  • Ending fund ledger balance
  • Bank and fund ledger ending balance difference
Grid fields
  • Type - either Check, Deposit, Other Credit, or Other Debit
  • Number
  • Date
  • Amount ($)