A solution that i use is this checkbook assistant it is an app(add-in) for Microsoft excel that can help you manage checkbooks and back statements within spreadsheet. Entries like cheque deposited but not collected by bank or adjustments related to bank reconciliation can be done easily with this tool. You can run an anti virus check on this app before using it.
You can find this tool working under ribbons >> Specialty tab
Download the add in here
A simple and user friendly checkbook register for excel. You can manage all details such as date of issue check number and payee name along with purpose and balance.There is a balance and reconcile column that will do auto calculate. User can web view this document by clicking on the image.