If you wish to reconcile transactions individually on your spreadsheet using your mouse you can move the mouse cursor over the spreadsheet and when it goes over the ‘S’ and ‘Reconciled Amount’ columns you can click in the column and perform the function applicable by double clicking the left mouse button:
Status Column – Double clicking on this column will change the status of the transactions from open to reconciled and vise versa.
Reconciled Amount Column - Double clicking allows you to enter an amount to reconcile the transaction with.
If you do not put in the correct amount Cashbook will calculate the variance between the original amount and reconciled amount and place the variance in the Variance column.
This entry is then ‘Reconciled in Error’.