Bank Reconciliation contains a number of reports available for your use. These reports include the following:

 

•All Records

  Show all records for a given date range

•Bank Only

  Shows all bank records for a given date range

•GL Only

  Shows all GL records for a given date range

 

 

•Unmatched items (period sensitive)

Show all unmatched items through the period ending date.

•Unmatched items (thru current)

Show all unmatched items

•Unmatched w/o OS checks

Show all unmatched items except for outstanding checks

•Matched only (grouped)

Show all matched record (grouped by audit trail number)

•Outstanding Checks

Show all outstanding checks

•Periods

Show period ending listings, including whether period is reconciled and the ending balance

 

•Import Logs

  All files imported into the system by type (GL or Bank).  Includes record counts, total imported amounts, and date range

•Manually Added Records

  Only transactions that were manually added through the Add Record function

•All Records (All Text Fields)

  Similar to All Records, but displays all optional text fields

•Bank Statement Summary

  Displays bank statement for selected period

•Bank Statement Detail

  Similar to Bank Statement Summary, but can be drilled into for more information

•GL Statement Summary

  Displays GL statement for selected period

•GL Statement Detail

  Similar to GL Statement Summary, but can be drilled into for more information

•Balancing Entries

  Entries created by the system during reconciliation to correct an out-of-balance

 

 

Through a combination of grouping and filtering, it is possible to obtain a very customized report which can then be exported to Excel for later use or import into another system.

 

See Grouping data to learn how to use different data groupings within the report (change data view)