I reviewed the reconciliation again and found that there were several transactions that are not ticked. After ticking them, the end balance at the reconciliation is now correct. Thank you! I am not sure why this error occur because I am of the impression that as long as the transactions get categorised, they show up as reconciled (ie, ticked) in the reconciliation report.