The idea is to make sure the ending balance in GL Cash account is the same as ending balance in the bank statement. This activity should not be made too complicated. I know users in companies keep their own Excel version to help them in reconciliation tasks. However, the number of these worksheets should be kept to minimal and more focus should be give to reconciliation report.

The GL reocnciliation report in Cash Management is sufficient enough. If there are complex requirement then perhaps a custom report could easily be produced.

The seeded report lists a balance and an adjusted balance for the bank statement. It also lists a separate adjustment amount for un-reconciled receipts, payments, and journal entries, as well as bank errors. Before running the report Create Accounting, Transfer to GL, Import and Post must be run in GL. Also run account analysis to make sure there direct manual entries through GL enter journal screen or Spreadsheet wizard are not touching the cash account.