Please click HERE to get the script to run. And click HERE for the document of step with screen shot.
At QnE system, please go to File -> Utilities -> QnE Management Tools.
Once the QnE Management Tools is pop out, go to Tools -> Intelligence SQL Queries, after the screen pop out, click 'Import Script', select the script file that downloaded at the link above, then click 'Execute SQL' to run the script.
If the script is finish run, below of the 'Exit' button will have a timestamp.
Now you can close the screen and go to check the Bank reconciliation amount.